The IF Function: Learn how to use the IF function to perform conditional calculations in Excel, allowing you to make decisions based on specified criteria.
Nested IF: Dive deeper into conditional logic by mastering nested IF statements, which enable you to create more complex decision trees.
The Lookup Function: Explore the Lookup functions (such as VLOOKUP and HLOOKUP) to search for and retrieve specific data from tables or ranges.
Date and Time Functions: Learn how to work with date and time functions in Excel to perform various date-related calculations and operations.
Advanced Filters: Explore techniques to efficiently filters lists and databases within Excel.
Subtotals & Outlines: Learn how to create subtotals and outlines to summarize and structure data within large datasets.
Database Statistical Functions: Discover statistical functions to analyse and interpret data, including functions like DAVERAGE, DCOUNT, and DSUM.
Data Validation: Use this powerful tool to validate user input within Excel to minimise user error.
Conditional Formatting: Use conditional formatting to create formulas to control cell formatting.
Pivot Tables & Pivot Charts: Delve into pivot tables and pivot charts to efficiently summarise, analyse, and visualise large datasets.