This advanced MS Excel course is for anyone who needs to take their Excel skills to the next level. We assume learners will already be familiar with using a keyboard, mouse, computer and assistive technology. By the end of this course you will be able to
Understand and use logical functions such as IF, IFERROR, NOT and AND & OR
Work with Mathematical and Statistical functions such as CountA, CountIF, CountBLANK, Round, SUMIF, INT, Rank and Small and Large functions
Use Lookup Functions such as V, H and Xlookups, Index, Match, Indirect and Unique
Work with Text functions, use dates and times in calculations, create and edit Charts.
This course also covers the desktop and web versions.
Estimated Course duration is 3 - 4 hours. Each lesson take on average 3-5 minutes to complete.
Course Content
string(4) "3363"
Logical Functions
IF Function
Nesting Functions
AND & OR Function
NOT Function
IFS Function
IFERROR Function
IF with AND & OR Functions
Maths and Statistical Functions
COUNTA Function
COUNTBLANK Function
COUNTIF Function
ROUND Function
SUMIF Function
INT Function
RANK Function
SMALL and LARGE Functions
Lookup Functions
VLOOKUP Function
HLOOKUP Function
Using the INDEX Function
Using the MATCH Function
INDIRECT Function
UNIQUE Function
XLOOKUP Function
Text Functions
Text Case Function
LEFT, RIGHT and MID Functions
TRIM Function
LEN Function
SEARCH Function
CONCATENATE & CONCAT Functions
Working with Dates and Times
Calculations with Dates
Calculations with Times
Date, Time Functions
Age Calculations
Adding & Subtracting Years , Months & Days
NEXTWORKDAYS Function
WORKDAY Function
Exploring Charts
Value Comparison Charts (Column & Bar)
Category Comparison Charts (Pie & Doughnut)
Time Related Charts
Data Correlation Charts
3D Data Charts (Bubble & Surface)
Financial Charts
Multiple Criteria Charts
Data Frequency Charts (Radar)
Process Charts (Waterfall & Funnel)
Visual Analysis Charts (Box and Whisker)
Hierarchical Data Charts (Sunburst & Treemap)
Geographical Charts (Maps)
Sparklines
Combined Charts
Advanced Chart Editing
Advanced Chart Formatting
Use the X inside a lesson to save your progress. Then click Continue
