Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Advanced Excel
Module (1): Manipulate and Format Workbook
M1-1 Selection and highlighting cells and sheets in excel
M1-2 Protecting cells , rows, columns, worksheets and multiple worksheets in excel
M1-3 Validate cells in excel
M1-4 Advanced cut, copy paste in excel
M1-5 Format cells in excel ( date, time, text, numeric, currency, percentage, fractions)
M1-6 Format cell emphasis (including: colour, shading, merge, borders, comments)
M1-7 Conditional formatting
Module (2): Advanced Functions
M2-1 Use absolute and relative cell referencing, named cells and ranges in excel formulas and functions
M2-2 Use mathematical functions
M2-3 Use statistical functions 1
M2-4 Use statistical functions 2
M2-5 Logical functions 1
M2-6 Logical functions 2
M2-7 Use date & time functions 1
M2-8 Use date & time functions 2
M2-9 Use lookup functions
M2-10 Index-match functions
Module (3): Create summaries & Analyse Data
M3-1 Prepare summaries using functions
M3-2 Create pivot table to summarize data
M3-3 Use subtotal function
M3-4 Create data tables
M3-5 Use what-if analysis & scenario manager
Module (4): Create & Format Charts
M4-1 Present data using charts including pivot charts
M4-2 Format charts
M4-3 Create dashboards
Teach online with
M1-5 Format cells in excel ( date, time, text, numeric, currency, percentage, fractions)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock