Excel proficiency comes from layering skills in the right order, and this masterclass follows that progression. It starts with navigation, cells, and formatting, then moves into calculations, logical and lookup functions, PivotTables and charts, and finishes with what if tools including Goal Seek and Scenario Manager.

This Course Offers

• Excel fundamentals covering the interface, ribbons, tabs, menus, the grid system, and data entry and editing
• Formatting skills including font styles, colours, alignment, borders, shading, and worksheet grouping
• Core and advanced functions spanning SUM, AVERAGE, IF, AND, OR, VLOOKUP, HLOOKUP, and XLOOKUP
• Text and date functions including LEFT, RIGHT, MID, CONCAT, TEXT, TODAY, NOW, and DATE
• Data analysis and visualisation with PivotTables, Pivot Charts, dropdown lists, Goal Seek, Data Tables, Scenario Manager, and column, line, and pie charts

Why We Love This Course

1. No Microsoft Excel experience is needed, so it genuinely starts at the beginning.
2. It covers XLOOKUP and Pivot Charts, which are more current than what many beginner courses teach.
3. The what if tools are included, and Goal Seek and Scenario Manager are valuable for planning and forecasting.
4. At three and a half hours across thirty four lessons, it covers a broad skill range efficiently.

Excel remains the tool most workplaces run on, and moving beyond basic formulas changes how quickly you can answer questions. Do you want to keep building calculations manually, or use functions that do the work for you? Enrollment is open, and a 30 day money back guarantee applies.

• This course is perfect for anyone wanting to save time and get more from Excel.
• It suits students and professionals improving their spreadsheet skills.
• Entrepreneurs and office workers preparing financial reports regularly will find the analysis and charting sections directly useful.

• Access to Microsoft Excel, ideally Office 365, 2019, or 2021, and a computer are all you need.
• No Microsoft Excel experience is needed to start.
• A willingness to practice the functions and tools will help the skills stick.

Interested in exploring more lessons? Check out our full course library to continue building your skills and advancing your learning journey.