Microsoft Excel for Beginners, 1-Day Online Training Course

* Please note that this is an online course, delivered remotely by a live instructor through Zoom *

Course Code: EXLBEG

Duration: 1 Day

Overview

This introductory one-day Excel course is ideal for anyone starting out with Microsoft Excel. Participants will learn essential spreadsheet skills, including data entry, basic calculations, formatting techniques, and printing options, while also discovering practical shortcuts that improve efficiency. Through a combination of instructor-led demonstrations and hands-on exercises based on everyday workplace scenarios, learners will build a solid foundation in spreadsheet creation. Emphasis is placed on producing clear, professional, and accurate worksheets by applying effective design, layout, and documentation practices.

Audience

This course is designed for people who are either new to Excel, or who want to fill in gaps and gain confidence and independence using Excel. Upon completion of the course, participants should be able to produce formatted spreadsheets containing basic formulas and functions, budgets and well-designed print copies.

Prerequisites

Designed for beginners and users looking to strengthen their existing knowledge, this course helps build confidence and self-sufficiency when working with Excel. By the end of the training, participants will be able to create and format spreadsheets, use common formulas and functions, develop simple budgets, and prepare professional print-ready documents suitable for business use.

Module List

• Module 1: Basics of Excel

• Module 2: Create a New Workbook

• Module 3: Working with Workbooks

• Module 4: Edit a Workbook

• Module 5: Learning Formulas and Functions

• Module 6: Selecting Cell Ranges

• Module 7: Copying Data in Excel

• Module 8: Special Pasting in Excel

• Module 9: Moving Data in Excel

• Module 10: Font Formatting in Excel

• Module 11: Applying Borders in Excel

• Module 12: Cell Alignment in Excel

• Module 13: Format Rows and Columns

• Module 14: Format Numbers

• Module 15: Formatting Techniques for Numbers

• Module 16: Page Setup in Excel

• Module 17: Printing

Click here for the full 'Excel for Beginners' course outline