Excel Foundations Course

Understand the Basics of Excel Step-by-Step

Start here, know the essential tools in Excel – and how to use them

42 Lessons

}

4.5 Hours

What is Excel Foundations?

A step-by-step guide for Excel Beginners

42 bite-size videos introduce you to the power of Microsoft Excel from the beginning. Watch anytime, anywhere, at your own pace.

Delivered by Experts

We walk you through the entire process so you know exactly what to do and you feel confident implementing every step

Practice and check your knowledge

Downloadable Practice files make it easy to understand. Take the online quiz to confirm your new Excel knowledge.

Prove to others

Add CPD Certified Excel Apprentice Certification to your Resume to prove you have the skills to succeed and help you land that promotion.

Includes Loads of Helpful tools

When you sign up for the 42 Excel Foundations Knowledge Pack, you’ll also get a FREE copy of our “Excel Cheat Sheets” and “15 Keyboard Shortcuts” to save you time everyday.

How to Navigate Cells in Excel

Module 1 : Start Up and Interface

Opening Microsoft Excel and the Interface

We start at the beginning and walk you step by step through the navigation of Excel so you can find your way around

The Excel Quick Access Toolbar

Discover the Excel Quick access toolbar and be introduced to Tabs and Ribbons

The Formula Bar and Status Bar

Find out about the Formula Bar, what it does and how you can use it.

Opening, Closing and Saving Workbooks

Know how to open, close workbooks, and how to save your work in Excel

Module 2 : Formatting and Editing

Formatting Fonts and Cells

Know how to format fonts in Excel. Understand how to merge and align cells

Formatting Numbers, Dates & Currencies

Find out about all the different types of formatting that can be done in Excel

Editing Cells in Excel

Discover the differences between ‘Cell’ editing and ‘Formula Bar’ editing

Format Painter and Autofill

Find out how to use the Format Painter Tool and Autofill to save you time

How to Format Cells in Excel

Our Excel Program just works ...

Check out what some of our customers have said

Luis

Senior System Administrator, FIS

Amanda

Talent Manager, U.S. Bank Home Mortgage

Shawn

Program Assistant, West Virginia

How to Apply Filters in Excel

Module 3 : Worksheets

Formatting an Excel Worksheet

Find out how to Insert and Edit cells, insert columns and rows, and how to Hide & Unhide them

More Sheet Options

Discover the features in Excel that allow you to Group Sheets, Freeze Panes, Link Sheets, Create Custom Views and insert Headers and Footers

Module 4 : Printing & Scaling

Printing your Excel work

In this module you’ll find out how to use Print Preview; Scale To Fit, Editing Margins And Orientation, and Print Titles

Printing to Scale

Discover the best ways to Print or Not Print Grid lines And Headings, Print One Sheet And Multiple Sheets

How to enter Formulas in Excel

Enroll now and add Excel Certification to your resume