Understanding formula syntax is crucial for powerful data analysis in Microsoft Excel. In this module, you will be introduced to essential Excel formulas and functions. You'll learn how to write them, use them to perform calculations, and master different cell references. By the end, you'll confidently apply formulas to solve business problems.

You'll discover how formatting helps highlight key messages and make your data presentable in Microsoft Excel. This module covers essential formatting tools like font styles, borders, alignment, and number formatting, along with Excel's built-in styles and themes. By the end, you'll be able to apply professional formatting to any spreadsheet, making your data clear and impactful.

This module is all about working with data in Microsoft Excel and making it easy to manage. You will learn essential techniques to manage your spreadsheets, including how to efficiently find data with Filter and Sort, retrieve and change data using Find and Replace, and apply Conditional Formatting to highlight specific data. By the end, you'll confidently organize and manipulate your Excel data.

When you need to share your work, printing your Microsoft Excel spreadsheets professionally is key. This module will guide you through optimising your spreadsheets for printing by managing margins, orientation, headers & footers, and more. By the end, you'll confidently prepare your Excel files for perfect printouts every time.

Charts are powerful tools for presenting data visually. In this module, you'll learn to create and modify various charts in Microsoft Excel, transforming raw data into clear, compelling insights. By the end, you'll confidently choose and customize chart types to effectively communicate your business data.