Excel for Smarter Working

Half Day Course

Develop more advanced Excel skills to manage data efficiently, use powerful formulas and create professional spreadsheets with confidence.

Overview

If you’re already confident using the basics of Microsoft Excel, this practical half-day course will help you take your skills further. You’ll explore more advanced formulas, data management techniques and time-saving tools that improve efficiency and accuracy when working with spreadsheets.

Designed for professionals who regularly use Excel, the course combines practical exercises with real-world examples to help you build more effective spreadsheets, analyse information and manage data with greater confidence.

Please bring your own laptop with Microsoft Excel installed so you can work using the version you’re most familiar with.

What You'll Learn

  • Use logical and conditional formulas including IF, SUMIF and COUNTIF.
  • Work confidently across multiple worksheets.
  • Apply absolute cell references effectively within formulas.
  • Create and manage structured data tables.
  • Use What-If Analysis tools to explore different scenarios.
  • Present information clearly using charts and graphs.
  • Build spreadsheets for budgets, invoices and reports with greater confidence.

Course Content

Building on the skills developed in Excel for Everyday Work, this practical half-day course introduces more advanced Excel features that help improve productivity, accuracy and confidence when managing data.

You’ll learn how to use logical and conditional formulas such as IF, SUMIF and COUNTIF to automate calculations and make spreadsheets more responsive to changing information. The course also explores working across multiple worksheets, using absolute cell references and organising larger spreadsheets effectively.

Through guided practical exercises, you’ll discover how structured tables and What-If Analysis tools can support budgeting, forecasting and decision-making. You’ll also develop techniques for presenting information clearly using charts and graphs, making reports easier to interpret and communicate.

Throughout the session, the emphasis is on practical application. Working alongside an experienced trainer, you’ll develop techniques that can be applied immediately to budgets, reporting, project management and everyday workplace tasks. By the end of the course, you’ll have greater confidence in using Excel as a more powerful and efficient business tool.

Looking for specific date(s), group booking or workplace delivery?

We’d be happy to discuss your requirements and the training options available.

Explore More Training Opportunities