Practical Beginner Excel 365

Zenler Player

Your course is loading. Hang tight.

Learn and Earn Activities Preview
Before we begin
Excels Help Options
First Look at Excel Introduction
How do I open and save a workbook?
Open and Save workbooks in Excel
What are the Ribbons?
Orientation
How do I enter data?
How do I enter formula?
How do I navigate a workbook and select data?
Entering data to Excel
How do I use and edit the quick access toolbar?
Quick access toolbar
First Look conclusion
First Look Activity
First Look Quiz

Working with Data Introduction
How do I use Autofill?
Autofill
How do I use Cut, Copy, Paste, Undo and Redo?
The Clipboard
How do I use Sort and Filter?
Sort and Filter
How can I use find, replace, hide and unhide?
Find and Replace
Formatting - How do I work with fonts and number formatting?
Formatting - How do I work with alignment and insert borders?
Formatting
Working with data conclusion
Working with data activity 1
Working with data activity solutions
Working with Data Quiz

Print and Preview Introduction
How do I preview and print?
What page options are available when setting printing options?
How can I amend the page margins for printing an Excel workbook or worksheet?
Print options in Excel
How do I add headers and footers?
Headers and Footers
How do I change the view of my workbook?
Freeze panes
Print and Preview Conclusion
Print and Preview Activity
Print and Preview Quiz

Tables and Charts Introduction
How do I insert a table?
How do I work with a table?
Tables
How do I insert a chart?
Inserting Charts
How do I add and amend chart elements?
Chart elements
How do I insert slicers and timelines?
Slicers and Timelines
Working with tables and charts quiz
Working with tables and charts activity 1
Working with tables and charts activity 2
Conclusion