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: Laptops are not provided so please bring your own.
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
With over 1,000 expert speakers covering more than 3,360 different topics, our course portfolio is vast and can be delivered either online or in-person. With over 450 years of collective professional development experience, we are proud to be trusted to...