Overview
This 2-day program covers functions & formulas important to regular users of Excel who process and operate a medium-to-high volume of data in various complexities at the office. This course aims to bring your expertise in Excel to the advance level so that your turn-around-time in Excel spreadsheets are reduced.
Learning Outcomes
Upon completion of this course, you will be able to have an in-depth understanding of essential functions & formulas, Excel’s Power Query; and the ability of applying your skills to the correct work scenarios.
Who Must Attend
HR managers, project managers, revenue managers, finance managers and administrative personnel who are in the basic to intermediate group wishing to improve their general working knowledge on Excel 2016.
Course Details
2 Days Training
9.00 am - 5.00 pm
MODULE 1 : FORMULA REFERENCES
- Absolute & relative references
- References when copying formulas in an array
MODULE 2 : GROUPING AND OUTLINING
- Manual Grouping, Auto Outlining
- SUBTOTAL, AGGREGATE Functions
MODULE 3 : LOOKUP FUNCTIONS
- VLOOKUP Function
- Match types-looking up an exact match and looking up a range
- INDEX, MATCH Functions- basic & complex
MODULE 4 : SUM & COUNT FUNCTIONS
- SUMIF, SUMIFS, COUNTIF, COUNTIFS Functions
- DSUM & DCOUNT
MODULE 5 : AN INTRODUCTION TO TABLE
- Function of the Table
- Creating the Table
- Advance Filtering
- Slicers
MODULE 6 : THE PIVOT TABLE
- Creating the Pivot Table from a flat file
- Populating the Pivot Table, formatting values & other Pivot Table options & settings
- Slicers & Timelines
- Pivot Charts
MODULE 7 : FORM CONTROLS
- Introduction to Form Controls
- Creating Form Controls and using them in data analysis
MODULE 8 : EXTRACTING & COMBINING DATA WITH POWER QUERY
- Extracting data of various file types and source
- Transforming extracted data
- Merging and appending data
MODULE 9 : EXCEL CHARTS
- Creating commonly used graphs
- The primary & secondary axis
- Chart styles
- Custom chart templates
- Sparklines
MODULE 10 : CONDITIONAL FORMATTING
- What is Conditional Formatting?
- Conditional Formatting Rules, Data Bars, ColorScales and Icon Sets
- Creating and managing formatting rules
- Advance formatting using formula
Methodology
The course is instructional and approached step-by-step. Participants will undergo the entire course in Excel.
SETUP REQUIREMENTS
Required software: Excel 2016 or above version
Course Leader
Testimonies
Investment
| Normal Fee |
| Sign up 0 pax |
| Pay before course starts |
| MYR 2,590.00 |
| USD 760.00 |
| Early Bird |
| Sign up 1 pax |
| Pay 14 day(s) before course starts |
| MYR 1,990.00 |
| USD 580.00 |
| Group Fee |
| Sign up 3 pax or more |
| Pay 14 day(s) before course starts |
| MYR 1,890.00 |
| USD 550.00 |
(Fee is INCLUSIVE of 6% SST.)
Payment mode:
1. ONLINE PAYMENT by Credit card: You can opt to register and pay online with our latest payment integration system through our website.
2. Telegraphic Transfer- You can also opt to use GIRO or telegraphic transfer of payment via international banks.
