A good skill to possess especially for your career is the usage of Microsoft Excel. Whether you are looking for a job, currently employed, or a business owner, Excel can assist you in various ways. This course aims to provide skills and knowledge of Microsoft Excel which allows you to increase efficiency and simplify your daily tasks. Students will learn Excel from the very basic to extensive functions, formulas, automation macros, and even the advanced features of Microsoft Excel.
This This training package includes:
- 2 Full Day Training (16 Hours) at the venue above
- 1 Year Access to Mobile App with step by step videos of Excel Advanced exclusively produced by Excel.my in Bahasa Melayu and English.
- Listing in Excel.my Certified User Directory.
- Breakfast, lunch and refreshments
- Free flow drinks
- Notebook, Stationery and Bag
- Certificate of Completion
100% HRDF Claimable for HRDF registered private companies.
Course Content - Day 1 (Basic)
LESSON 1: INTRODUCTION
• Topic A: Using the menus
• Topic B: Versions
LESSON 2: DATA ENTRY
• Topic A: Formula Bar
• Topic B: Working with dates and times
• Topic C: Format Cells/ Data Formatting
• Topic D: Flash Fill Series
LESSON 3: CREATING FORMULAS
• Topic A: AutoSum/Average
• Topic B: Days Formula
• Topic C: Formula Wizard
• Topic D: Audit Formulas (Trace precedent/dependent)
LESSON 4: FORMATTING
• Topic A: Inserting shapes, arrows, and other graphics
• Topic B: Adding and deleting rows and columns
• Topic C: Hiding data
• Topic D: Moving, copying, and pasting
• Topic E: Sorting and filtering data
• Topic F: Conditional Formatting / Data Bars / Data Icon Sets
LESSON 5: INSERTS
• Topic A: Clipping Screens
• Topic B: Images/ Shapes
• Topic C: Recommended Charts
• Topic D: Linking Charts in PowerPoint
• Topic E: Advanced Charts / Combo Charts
LESSON 6: PRINT
• Topic A: Print Area
• Topic B: Repeat Titles on print
• Topic C: Page Layout / Page Break
LESSON 7: SECURITY
• Topic A: Allow people to edit selected cells only (Creating Forms)
• Topic B: Protecting Worksheet & Workbook (Read Only)
• Topic C: Workbook Encryption (Password to open)
Course Content - Day 2 (Advanced)
LESSON 1: FORMULAS IN DEPTH
• Topic A: IF Function
• Topic B: 3D Formulas
• Topic C: CHOOSE/MATCH/INDEX
• Topic D: VLookup / H Lookup
LESSON 2: DEFINE NAMES
• Topic A: Create your own names
• Topic 2: Define Names in formulas and references
LESSON 3: PIVOTTABLES
• Topic A: Using PivotTables and Filters
• Topic B: PivotCharts
• Topic C: Creating extended charts / business charts
• Topic D: Gantt Charts
LESSON 4: GOAL SEEK
• Topic A: PMT Formula (Loan Calculator)
• Topic B: Goal Seek
LESSON 5: SCENARIO MANAGER
• Topic A: Create various scenarios
• Topic B: Using Scenarios
LESSON 6: MACRO, RECORD AND PLAY
• Topic A: Record repeated tasks with Macro
• Topic B: Add new buttons to your Excel to playback Macros
• Topic C: VBA and Macro
LESSON 7: MICROSOFT OFFICE SPECIALIST (77-420) OVERVIEW