Microsoft Excel - Intermediate

This course runs from 09:30-16:30 and will cover the following:

 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.

Learning Outcomes:

 Efficiently Query Spreadsheet Data: Learn how to retrieve specific values within a spreadsheet using various techniques and functions.

 Advanced Data Analysis: Gain expertise in analysing data by employing advanced formulas and functions to extract valuable insights.

 Data Management Mastery: Develop the skills to effectively manage and manipulate large volumes of data, making it more organised and accessible.

 Pivot Table and Chart Proficiency: Learn to create, customise and manage pivot tables and charts to visualise data and uncover trends and patterns.