Microsoft Excel Fundamentals

Course Overview

Microsoft Excel Fundamentals

This course covers all the fundamental skills required to create and format spreadsheets, automate spreadsheets with formulas and prepare spreadsheets for printing.

Course Content

Module 1 - Spreadsheet Basics

• Spreadsheet concepts
• Exploring the Excel window
• Working with the ribbon and commands

Module 2 - Navigating, Selecting and Entering Data

• Creating, saving, opening and closing spreadsheets
• Moving around a spreadsheet
• Entering, editing and deleting data
• Using Auto Fill and Flash Fill
• Creating custom lists

Module 3 - Editing Data, Columns and Rows

• Inserting and navigating worksheets
• Inserting and deleting rows and columns
• Adjusting column widths and row heights
• Showing and hiding columns and rows
• Cut, copy and paste techniques

Module 4 - Formatting

• Formatting text and sizes
• Aligning text horizontally and vertically in cells
• Applying number and date formats
• Formatting cells with background colours and borders

Module 5 - Basic Formulae and Functions

• Using formulas to add, subtract, divide and multiply numbers
• Using the AutoSum function
• Working with relative and absolute cell references

Module 6 - Data Lists Essentials

• Introducing data lists
• Freezing worksheet titles
• Sorting a list of data
• Filtering data using Auto Filter

Module 7 - Page Setup and Printing

• Using print preview
• Changing page layouts
• Changing and applying print options