Become an Excel Pro – Master essential skills for daily tasks (Windows & Mac supported)

Boost your efficiency and conquer spreadsheets with our Microsoft Excel training. Whether you’re using Windows or Mac, we’ll equip you with the skills you need to thrive in your day-to-day work.

Master Excel on your terms: Our Microsoft Excel training caters to both Windows and Mac users and is offered in flexible formats to suit your learning style. Choose from engaging in-person workshops or the convenience of online learning.

Which Microsoft Excel training course is right for you?

Conquer spreadsheets: Microsoft Excel essentials for beginners

Who should attend?

  • Are you new to Excel? This course is perfect if you’ve never used a spreadsheet program before.
  • Feeling lost in formulas? Brush up on the basics and unlock the power of Excel calculations.

Aim

This course equips you with the essential skills to confidently build and manage spreadsheets in Excel. No prior experience is needed, just basic computer skills like using a mouse and saving files.

By the end of this course, you’ll be able to:

  • Navigate with ease: Create, save, open, and print spreadsheets like a pro.
  • Master the basics: enter different types of data, insert and delete rows/columns, and perform calculations with formulas.
  • Format for impact: Customise the appearance of your spreadsheet to make information clear and visually appealing.
  • Chart your success: Learn to create charts that effectively showcase your data insights.

Ready to unlock the power of Excel? Enroll today and start building spreadsheets with confidence!

Microsoft Excel Intermediate

Who should attend?

This course is designed for individuals who are comfortable with Excel basics and want to take their skills to the next level. You should be familiar with:

  • Creating and editing simple spreadsheets
  • Using basic formulas (e.g., AutoSum)
  • Formatting and AutoFill

Aim

By the end of the course, you will be confident in going beyond the basic features of Excel. For example, using multiple sheets, linking them to create formulae across sheets, using common functions such as Average and If statements, and managing data in an Excel database.

What you will learn

  • Navigate Multiple Worksheets: Efficiently manage workbooks with multiple sheets and link them for complex calculations.
  • Master Advanced Formulas: Utilize functions like AVERAGE, IF statements, and nested IF for conditional calculations and data analysis.
  • Data Management and Analysis: Learn to format data as tables, create structured references, and leverage powerful functions like SUMIFS, COUNTIFS, and AVERAGEIFS to analyze large datasets.
  • Interactive Data Exploration: Create PivotTables and apply slicers for dynamic data visualisation and exploration.

Ready to unlock the full potential of Excel?

This course will equip you with the skills to become a spreadsheet power user and boost your productivity. Enroll today.

Microsoft Excel Advanced

Who should attend?

This advanced course is designed for those who are comfortable with the basics but want to take their skills to the next level. You’ll learn powerful features to automate tasks, analyse data more effectively, and create impressive visualisations.

Delegates must be confident in using a mouse. Additionally, you must have used Excel before and be familiar with entering formulae and using absolute cell references (see our Excel Essentials and Intermediate Outlines).

Aim

By the end of this Excel training course, you will be confident in using some of Excel’s more advanced features. You will be able to perform more complex “what if” scenarios and manipulate information using conditional formulas and pivot tables.

Who should attend?

  • Regular Excel users familiar with formulas and cell references (see our Excel Essentials/Intermediate courses)
  • Anyone using Excel for data analysis, budgeting, or reporting
  • Professionals who want to significantly improve their efficiency

What you’ll learn:

  • Advanced Charting: Craft impactful and informative charts with customisation options, trendlines, and sparklines.
  • Conditional Formatting: Use formula-based rules to highlight data dynamically, format cells based on specific conditions, and streamline data analysis.
  • Data Manipulation Mastery: Learn powerful techniques like text manipulation, data cleaning, and using Paste Special functions to organize and streamline your data sets.
  • Efficiency Boosters: Discover keyboard shortcuts and Quick Access Toolbar customisation to save time on repetitive tasks.
  • Formula Deep Dive: Gain in-depth knowledge of formula auditing, error tracing, and advanced functions like LOOKUP and a variety of text functions.
  • Data Analysis Expertise: Master advanced features like removing duplicates and using PivotTables to effectively summarise and analyse large datasets.

Master Microsoft Excel with Automation – VBA programming

Who Should Attend?

  • Experienced Excel users who want to:
    • Automate repetitive tasks
    • Boost productivity
    • Simplify complex workflows

Requirements

This VBA course empowers you to take control of Excel and streamline your work. No prior programming experience is required. As long as you’re comfortable with advanced Excel functions, you’ll be well on your way to VBA mastery.

Aim

By the end of this course, you’ll be able to:

  • Automate repetitive tasks: Write macros to eliminate tedious manual work and save valuable time.
  • Unlock efficiency: Build powerful tools and workflows tailored to your specific needs.
  • Control Excel with VBA: Learn how to leverage VBA to manipulate data

What you will learn

Key Course Highlights:

  • VBA fundamentals: Grasp the core concepts of VBA programming within the Excel environment.
  • Object model mastery: Navigate the Excel object model, utilising its properties, methods, and events effectively.
  • Coding with confidence: Declare and manipulate variables to control your VBA programs.
  • Conditional statements: Write code that reacts to specific conditions, making your automation dynamic.
  • Looping techniques: Automate repetitive tasks with powerful loop structures (For Next, While Do).
  • Building reusable functions: Create custom functions to streamline complex calculations and enhance code reusability.
  • Error handling: Implement robust error handling to prevent program crashes and troubleshoot potential issues.

Ready to transform your Excel skills and achieve peak efficiency? Sign up for our VBA training course today.

Course Outline

Unleash the Power of Data: Master Excel Pivot Tables & Dashboards

Transform your data into clear, actionable insights with our Excel Dashboards course

Who should attend this training?

  • This course is ideal for Excel users who want to transform data into impactful dashboards.
  • You should be comfortable with advanced Excel functions (or have completed our advanced Excel course).

Aim

By the end of this course, you will be able to use workbook best practice to set up a dashboard from scratch by using charts, tables and other visualisation techniques.

What you will learn?

  • Go from raw data to clear insights: Learn to create dashboards from scratch using charts, tables, and other visualization techniques.
  • Master Pivot Tables & Charts: Effortlessly create and customise pivot charts to effectively present complex data.
  • Interactive analysis: Utilize slicers to allow users to filter data and explore insights dynamically.
  • Linked tables & conditional formatting: Build compelling linked tables for clear information presentation and leverage conditional formatting to highlight data trends.

Learn by Doing:

Our hands-on course structure includes dedicated sessions for practicing each skill with real-world examples.

Excel Power User

Who should attend Excel Power User training?

Anyone who wishes to be adept and get the most out of Microsoft Excel by using its advanced functionality.

Requirements

Delegates wishing to attend this course must;

  • Have attended the Microsoft Excel advanced course or be familiar with the advanced course topics.

Aim

By the end of this course, you will be able to manipulate data sets, locate specific data in a table, consolidate data and create single formulas to aggregate a series of data.

What you will learn?

In particular, you will be able to:

  • Import data outputted from differing systems, tidy, amend and query.
  • Use lookup and reference functions to simplify finding specific entries in a data table
  • Summarise and report results from data on separate worksheets or workbooks and easily update and aggregate
  • Work with array formulas on a series of data values to aggregate them using SUM(), AVERAGE(), or COUNT(), to return a single value in a single cell

Course Outline


Microsoft IT Training

Which Microsoft Office skills training do you need?

Contact us

Would you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.

More