D I F F I C U L T Y L E V E LBASIC | INTERMEDIATE | ADVANCED | PROFESSIONAL
Basic: Start from zero, learn the essentials and use the tools correctly with confidence.Intermediate: Designed for users who know the basics who want to sharpen their skills for work scenarios.Advanced: Built for power users who want to handle complex data, scenarios, and evolving requirements. Professional: Multiple-skilled training. Designed for users who want to use multiple methods to build business-ready solutions.
Embedded Files
T A R G E T P A R T I C I P A N T SThis learning session is suitable for participants holding roles in the following areas:Accounting & book-keepingBack-end office administrationFinance-related workData analystsProject-related workRevenue managementExcel users keen to update their spreadsheet knowledge
HRDC claimable.
Click here for course outline >
Click here for course outline >
OUTLINE
OUTLINE
1. Introduction
1. Introduction
Absolute and relative cell references
The Formula Bar and the Insert Function tool
The Name Box, naming and editing cell ranges
The Status Bar
Basic Excel function syntax
Nested formulas
2. The new Array formula platform
2. The new Array formula platform
Evaluating dynamic arrays, array formulas & normal formulas
Spilled array behavior of formulas
What’s best?
3. Logical functions
3. Logical functions
IF
IFS
AND
4. Sum and Count functions
4. Sum and Count functions
SUMIF, SUMIFS, DSUM
AVERAGE, AVERAGEA
COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS
SUMPRODUCT
5. Text functions
5. Text functions
TEXTJOIN, TEXTAFTER, TEXTBEFORE
TEXT
TEXTSPLIT
6. Date and Time functions
6. Date and Time functions
DATE, DATEVALUE
EDATE, EOMONTH, DAYS, DAYS360, NETWORKDAYS, NETWORKDAYS.INTL, NOW
7. Transposing & Stacking
7. Transposing & Stacking
TRANSPOSE
VSTACK, HSTACK
8. Lookup-related functions
8. Lookup-related functions
VLOOKUP
HLOOKUP
XLOOKUP
9. Dynamic Array Transformation Functions
9. Dynamic Array Transformation Functions
UNIQUE
FILTER
SORT
SORTBY
10. Dynamic Array Aggregation Functions
10. Dynamic Array Aggregation Functions
GROUPBY
PIVOTBY
11. Image related functions
11. Image related functions
IMAGE
Cells and images
12. Other import tools on formulas
12. Other import tools on formulas
Formula Auditing
Displaying Formulas
Error Checking and tracing errors
Evaluating formulas
Calculation options
Copying and pasting formulas
Comparing conditional sum, count functions with database functions
13. Quick Summation methods
13. Quick Summation methods
Using shortcut keys and AutoSum
14. Customizing Number Formats
14. Customizing Number Formats
Examining number formats and changing them
Customizing number formats with advanced methods
Page updated
Report abuse