Microsoft Excel – Level 1

By the end of this workshop, you will be able to:

• Enter and edit data
• Format data, cells and sheets
• Use basic formulas and functions
• Page setup and print worksheets

Creating a Basic Worksheet

• Navigate and select in Excel
• Customize the interface

Performing Calculations

• Create basic formulas
• Calculate with functions
• Copy formulas and functions

Modifying a Worksheet

• Manipulate data
• Insert and delete cells, columns, rows
• Search for data

Formatting a Worksheet

• Modifying a worksheet’s appearance, fonts, borders, colours
• Column width and row height
• Apply number formats
• Cell styles

Printing Workbook Contents

• Print workbook contents
• Setting print options and page breaks

Managing Large Workbooks

• Format worksheet tabs
• Manage worksheets

There are no prerequisites for this course.

Note on Versions:
This workshop is applicable to users of Microsoft 365, 2019, and 2016 versions. While some features or layouts may differ slightly between versions, the core skills and tools covered remain consistent.

Anyone who has in interest in learning the productivity software MS Excel for analyzing and making sense of large amounts of data.