❓Do you want to learn how to use Excel like a pro?
 
❓Do you want to save time, boost your productivity, and impress your boss with your Excel skills?

❓Do you want to master the most powerful and versatile tool in your office toolkit?

☑️ If you answered yes to any of these questions, then this Masterclass is for you!

☑️Excel is not just a spreadsheet program. It is a powerful tool that can help you organize, analyse, and present data in various ways. Whether you need to create reports, charts, budgets, invoices, schedules, or anything else, Excel can help you do it faster and easier.

I know that Excel can also be intimidating and confusing. There are so many features, functions, and formulas that it can be hard to know where to start and how to use them effectively.

That’s why I created this Masterclass for Assistants like you!

⏰ In this 90-minute session, I will teach you the essential Excel skills that you need to succeed in your role.

You will learn how to:


 ☑️Customize The Ribbon and Quick Access Toolbar: Learn how to personalize your Excel interface and access your favourite commands with ease.

☑️Use Autofill to automagically generate lists – and not just any old lists: Discover how to use Autofill to create custom lists, such as dates, names, or numbers, in seconds.

☑️Build a formula from scratch – the basis and building blocks for the creation of all formula: Understand the basics of Excel formulas, such as cell references, operators, and functions, and how to combine them to perform calculations.

☑️How to make sure your formula behaves as you want it to and is not “wonky”: Learn how to use absolute and relative references, named ranges, and error checking to ensure your formulas are accurate and consistent.

☑️Format data as a Table – this will enable quick sorting and filtering and analysis of the data: Learn how to convert your data into a table and use its features, such as formatting, sorting, filtering, and slicers, to organize and analyse your data.

☑️Work with a Pivot Table – how to build one and then manipulate it to suit you: Learn how to create and modify a pivot table, a powerful tool that allows you to summarize and visualize your data in various ways.

☑️Use Conditional Formatting to show you what is what in your data: Learn how to apply conditional formatting, such as colour scales, data bars, icons, and rules, to highlight important or unusual data in your worksheet.

vIntroduction to Conditional Processing – IF Statements, SUMIF, SUMIFS – get Excel to answer your questions: Learn how to use conditional functions, such as IF, SUMIF, and SUMIFS, to perform logical tests and calculations based on criteria.

☑️Use Flash Fill to do amazing things – true magic: Discover how to use Flash Fill, a smart feature that automatically fills in data based on patterns or examples.

☑️Get Excel to create an Infographic using People Graph: Learn how to use People Graph, a new chart type that allows you to create infographics with icons and labels.