Excel Power Skills: Build Confidence with Formulas & Functions
This half-day Excel power skills course is designed to give you the confidence to master formulas, apply essential and advanced functions, and discover productivity boosters that transform the way you work in Excel.
Perfect for anyone with basic Excel knowledge who wants to build core skills and boost efficiency.
Course Content
Objective
To ensure participants understand the Excel interface, input data with precision, and write calculations.
Module content
Data Entry and Foundational Formatting
- Techniques for the accurate entry of data.
- Application and understanding of number formatting conventions (e.g., currency, percentage, date).
Construction of Basic Formulas
- Introduction to Formulas: A definition of formulas and the how to write them.
- Fundamental Arithmetic Operators: Thorough exploration of +, -, *, /, operators and using them.
- How Excel understands our calculations: (BODMAS): Emphasis on ensuring the correct sequential execution of operations within formulas.
- Relative and Absolute Cell References
Objective
To enable participants to proficiently utilize common functions to summarize data.
Module content
- Introduction to Excel Functions and understanding syntax
- Core Statistical Functions - SUM, AVERAGE, COUNT, COUNTA,MAX & MIN
- Rounding Functions for Numeric Values
- Data Sanitisation - Strategies for cleaning and standardizing data
Objective
To develop an understanding and working knowledge of Logical Functions. This module will explore how and why they behave the way that they do, and how to effectively write and utilise them.
Module content
Making Decisions with IF, AND & OR
- The IF Function: Detailed syntax and application of IF
- Nested IF Statements: Advanced techniques for managing multiple interrelated conditions.
- AND & OR functions Integrating IF with other functions to overcome syntax barriers
Conditional Summing & Counting
- Introduction to Formulas: A definition of formulas and the how to write them.
- Fundamental Arithmetic Operators: Thorough exploration of +, -, *, /, operators and using them.
- How Excel understands our calculations: (BODMAS): Emphasis on ensuring the correct sequential execution of operations within formulas.
- Relative and Absolute Cell References
Making Errors disappear
- Exploring & understanding error messages and how to deal with them.
Module content
Lookup Functions
- VLOOKUP: Fundamental lookup functionality for matching & extracting data.
- INDEX & MATCH: An exploration on these functions as a more versatile and robust alternative to VLOOKUP.
- A Quick Look at XLOOKUP (if your Excel version has it): A concise overview of this contemporary lookup function.
Date & Time Functions
- DATE, DATEDIF & TODAY functions to concisely reference and produce dates.
