Zenler Player
Your course is loading. Hang tight.
Essential Excel Skills for Business – Mac Version
Back to curriculum
0% Complete
0% Complete
1.1 Starting Excel
1.2 The Ribbon and Screen
1.3 Customise the Ribbon
1.4 Customise The Quick Access Toolbar
1.5 Adding and Deleting Worksheets
1.6 Move and Copy Worksheets
1.7 Selecting in your Worksheet
2.1 Adding Data and Data Types
2.2 Resizing Columns and Rows
2.3 Cut Copy and Paste Information
2.4 Paste Special
3.1 Font Formatting and Cell Styles
3.2 Borders and Shading
3.3 Format Painter
4.1 Autofill
4.2 Custom List
4.3 Flash Fill
5.1 The Structure of a formula
5.2 Bodmas
5.3 AutoSum
5.4 Average Min Max Count
6.1 Brining it all together
7.1 Views an Overview
7.2 Page Layout and Headers and Footers
7.3 Page Break Preview and Print Titles
8.1 Absolute Cell References
8.2 The F4 key
8.3 Name a Cell to make it absolute
9.1 Page Setup
9.2 Print and Print Preview
Excel Sills Exercise
10.1 Default Options
11.1 Saving
11.2 Sharing a workbook
12.1 Protect Cells
Please complete the Feedback form
The Interface
1.1 Starting Excel
Preview
1.2 The Ribbon and Screen
1.3 Customise the Ribbon
1.4 Customise The Quick Access Toolbar
Preview
1.5 Adding and Deleting Worksheets
1.6 Move and Copy Worksheets
1.7 Selecting in your Worksheet
Adding things to your Spreadsheets
2.1 Adding Data and Data Types
2.2 Resizing Columns and Rows
2.3 Cut Copy and Paste Information
2.4 Paste Special
Formatting
3.1 Font Formatting and Cell Styles
3.2 Borders and Shading
3.3 Format Painter
Autofill Magic
4.1 Autofill
4.2 Custom List
4.3 Flash Fill
Essential Calculations
5.1 The Structure of a formula
5.2 Bodmas
5.3 AutoSum
5.4 Average Min Max Count
6.1 Brining it all together
Views
7.1 Views an Overview
Preview
7.2 Page Layout and Headers and Footers
7.3 Page Break Preview and Print Titles
Fixing Cell Refernces
8.1 Absolute Cell References
8.2 The F4 key
8.3 Name a Cell to make it absolute
Printing and Page Setup
9.1 Page Setup
9.2 Print and Print Preview
Download Practice Workbook
Excel Sills Exercise
Defaut Options
10.1 Default Options
Saving and Sharing
11.1 Saving
11.2 Sharing a workbook
Protecting your cells
12.1 Protect Cells
Please complete the Feedback form
×
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