4.00
(1 Rating)
Excel Intermediate
Categories: Excel Online, UPvisor Academy
About Course
This online workshop equips attendees with the fundamentals of using Excel. These sessions are available on-demand, which means you can learn at your own pace. You get direct access to the trainer, with exercises and a test of competence at the end of the course.
What Will You Learn?
- Customise your Excel
- Use custom and conditional formats
- Print titles, headers and footers
- Use text to columns
- Understand Lookup & conditional functions
- Use Paste Special effectively
- Use custom sort and filter
Course Content
From Zero to Excel Hero
-
From Zero to Excel Hero
00:29 -
What To Expect
00:55
Introduction
-
Background And Recap
04:06 -
Introduction Background
01:57 -
Pre-Requisites To Using Excel
01:17
Stepping Up
-
Stepping Up
01:10
Setting Up Your Workbook
-
Workbook: Section 1
-
Customising Excel
04:43 -
Setting Up Your Workbook
04:20 -
Protecting Your Workbook
03:09 -
Editing And Formating Cells
06:56 -
Conditional Formatting
04:17 -
Templates
02:26 -
Find And Replace
05:17 -
Exercise 1 – Instructions
-
Exercise data
-
Section 1 – Tutorial Part 1
09:26 -
Section 1 – Tutorial Part 2
05:59 -
Section 1 – Tutorial Part 3
07:56 -
Section 1 – Tutorial Part 4
02:08
Printing For Presentations
-
Workbook: Section 2
-
Page Layout
05:01 -
Headers And Footers
04:31 -
Exercise 2: Instructions
-
Section 2 – Tutorial
08:55
Functions & Formulas
-
Workbook: Section 3
-
Formatting Cells
06:32 -
Absolute And Relative References
04:26 -
Formulae
05:17 -
Vlookups
03:57 -
Vlookup Crib Notes
05:05 -
Conditional Formulae
06:58 -
Understanding Formula Errors
05:27 -
Linking To Other Sheets And Workbooks
02:41 -
Exercise 3 – Instructions
-
Section 3 – Tutorial Part 1
08:20 -
Section 3 – Tutorial Part 2
07:02 -
Section 3 – Tutorial Part 3
08:02 -
Section 3 – Tutorial Part 4
01:57
Working With Data
-
Workbook: Section 4
-
Using The Clipboard
03:43 -
Duplicates
01:39 -
Custom Sort And Filter
03:08 -
Outlining Data
01:58 -
Using Tables
03:41 -
Exercise 4 – Instructions
-
Section 4 – Exercise 4A
09:55 -
Section 4 – Exercise 4B
03:41
Smart Charts
-
Workbook: Section 5
-
Smart Charts
04:17 -
Exercise 5 – Instructions
-
Section 5 – Tutorial
09:49
The Last Word
-
Workbook: Section 6
-
The Last Word
04:24 -
Time For A Test
00:50 -
Conclusion
00:34 -
Workbook: Completed
Student Ratings & Reviews
4.0
Total 1 Rating
5
0 Rating
4
1 Rating
3
0 Rating
2
0 Rating
1
0 Rating
Good course