Zenler Player
Your course is loading. Hang tight.
Essential Excel Skills for Business - Windows Version
Back to curriculum
0% Complete
0% Complete
Starting Excel
The screen and Ribbon
Customise the Ribbon
Create your own Ribbon
The Quick Access Toolbar
The ALT Key
Move and copy worksheets and set tab colour
Adding and Deleting Worksheets
Selecting in your worksheet
Download my workbook
Start adding data to your worksheet and data types
Resize columns and rows
Move data around, cut, copy, paste
AutoFill
Create a Custom List
Flash Fill
The Structure of a formula
Bodmas
AutoSum
Average
Finding the Minimum or Maximum in a list of numbers
Count Numbers and Count Text
Font Formatting
Borders and Shading
Download notes - Formatting Cells and Worksheets
Views - an overview
Page Layout View - Headers and Footers
Page Break Preview
Print and Print Preview
Page Setup
Print Titles - Print header rows on every page
Absolute Cell References
Using the F4 key or the $ sign
Name a cell to make it absolute
Excel Skills - Exercise - download to practice your skills
Default Options
Saving - as a spreadsheet, a PDF and to OneDrive
Share a spreadsheet
Protect Cells
Please fill in our Feedback Form
Join the Facebook Group!
The Interface
Starting Excel
Preview
The screen and Ribbon
Customise the Ribbon
Create your own Ribbon
The Quick Access Toolbar
The ALT Key
Move and copy worksheets and set tab colour
Adding and Deleting Worksheets
Selecting in your worksheet
Sample Workbook
Download my workbook
Adding things to your Spreadsheets
Start adding data to your worksheet and data types
Preview
Resize columns and rows
Move data around, cut, copy, paste
Autofill Magic
AutoFill
Create a Custom List
Flash Fill
Essential Calculations
The Structure of a formula
Bodmas
AutoSum
Average
Finding the Minimum or Maximum in a list of numbers
Count Numbers and Count Text
Formatting
Font Formatting
Borders and Shading
Download notes - Formatting Cells and Worksheets
Views
Views - an overview
Page Layout View - Headers and Footers
Page Break Preview
Printing and Page Setup
Print and Print Preview
Page Setup
Print Titles - Print header rows on every page
Preview
Fixing Cell References
Absolute Cell References
Using the F4 key or the $ sign
Name a cell to make it absolute
Download Worksheet to practice
Excel Skills - Exercise - download to practice your skills
Excel Options
Default Options
Saving
Saving - as a spreadsheet, a PDF and to OneDrive
Share a spreadsheet
Protection
Protect Cells
Feedback
Please fill in our Feedback Form
Join the Facebook Group!
×
This is an unpublished lesson. This lesson will not be shown for students unless you set it as Public.
Back to Dashboard
No contents are available in this lesson!
No lessons available !
Back to Dashboard
Lesson contents locked
Enroll to unlock this lesson.
Enroll to unlock
Next Lesson