Course description
Presented by leading Excel trainer Alan Murray, this in-person course will cover all the essential skills to advance your Excel knowledge - formulas, top features, PivotTables, pro tips, and more.
Whether you are a relative beginner or at intermediate level, this course will make you a confident and skilled Excel professional.
This course will teach you the building blocks of Excel formulas so that you can read and understand others' formulas, update them, and fix errors. You will learn how to write conditional formulas to perform different calculations based on cell values, use Conditional Formatting to highlight specific values, and utilize various lookup functions in Excel. You will also learn how to use data from various data structures and create and use PivotTables to summarize data.
Upcoming start dates
Outcome / Qualification etc.
Training Course Content
Introduction
This in-person course will cover all the essential skills to advance your Excel knowledge, formulas, top features, PivotTables, pro tips, and more.
This course is targeted at all levels though assumes a basic working knowledge of Excel.
Whether you are a relative beginner or intermediate level this course will make you a confident and skilled Excel professional.
NB: A laptop is required for the course.
What You Will Learn
This course will cover the following:
- The building blocks of Excel formulas so that you can read and understand anyone’s formula, update them and fix errors
- How to write conditional formulas to make decisions and perform different calculations based on cell values
- Use Conditional Formatting to highlight specific values automatically and bring meaning to your data
- Utilise the lookup functions in Excel from the infamous VLOOKUP to the new XLOOKUP
- Use data from any data structure including ranges, tables, defined names and arrays
- Create and use PivotTables to easily summarise data and create dynamic reports
- Some of the most used features of Excel including Data Validation, Flash Fill and Text to Columns
- Pro tips to use Excel the ‘right way’ and get the most from Excel
Expenses
MBL Seminars Limited
MBL is a leading learning and development provider for professional service firms. Over the past 18 years, more than 198,000 people across 23,000 different organisations spanning 81 countries, have chosen us to deliver their training. With over 800 expert speakers...