Understand the Basics of Excel Step-by-Step
42 Lessons
4.5 Hours
4 Quizzes
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.
Click an icon to see what's covered
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
Our Excel Program just works ...
Amazing !! I love the tutorials and even though I’ve been using Excel for years, I now have many new tricks that will make my job a lot easier.
Great and very easy to follow. If you need to go over everything more than once, you can! Plus, the certificate looks great on my resume!
Very helpful, instructions are super easy and layout is step by step… I will purchase from them again – thumbs up and 5 star rating from me!!!
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
