Creating Basic Formulas in Microsoft Excel

Overview

This module is designed to help you master the fundamentals of Excel formulas, from simple arithmetic to essential functions. Whether you're new to Excel or looking to consolidate your formula skills, this module will equip you with the knowledge to create efficient and accurate calculations.

Target Audience

This course is ideal for:

• Beginners with little to no Excel experience
• Professionals looking to refresh their basic Excel skills
• Anyone wanting to improve their productivity with spreadsheets

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

• Craft simple arithmetic formulas 
• Understand and apply relative and absolute cell references
• Efficiently copy and fill formulas across your spreadsheet
• Utilise basic Excel functions for quick calculations
• Troubleshoot common formula errors
• Implement named ranges for clearer, more manageable formulas
• Perform basic text and date calculation

Topics include:

• Creating formulas with basic arithmetic (addition, subtraction, multiplication and Division)
• Creating formulas with percentages
• Creating formulas with dates
• Use basic statistical functions to calculate totals, averages, highest, lowest and count.
• Sample text. Click to select the text box. Click again or double click to start editing the text.

First Steps in Microsoft Excel

Creating Basic Formulas

Manipulate Data Using Tables

Data Visualisation with Charts

Using Statistical Functions to Analyse Data