Microsoft Excel Intermediate course

——   Created by Stephen Saxton

A must for Excel users

Share this course:

NEW
Course
42
Lessons
6h 23m
Lesson time
intermediate
Skill level

More about this course

You will learn how to use some of the more common functions like IF statements, CountIF , Vlookup, Hlookup and SumIf. You will also see how you can create create superb visualisations using charts and maps. The Pivot tables and charts feature will enable you to manage and report on large data sets and remain in control of your data no matter how complicated the raw data set looks.

Outline is below:

· Conditional formatting

· Average function/Count

· Maximum function/Sum

· Minimum function/SumIF

· Basic Scenarios

· Sheet Layout and design

· Named Cells/Ranges

· Absolute Referencing/ percentages

· Basic Pivot Tables

· Using 3-D Referencing

· Goal Seek

· Data Tables

· Sheet and cell Protection

· Linking Sheets and Workbooks

· Using Array Formulae

· Using Group and Outline/Saving Views

· Naming Worksheets

· Using the Subtotals Feature

· Creating Templates

· Basic Lookups/Basic IF

Who this course is for:
  • Microsoft Excel intermediate users, administrators, finance support workers, business owners, training an development creators
  • Don't miss out, Excel is a great time saver, but if you don't know how to do something, Excel can be a great time waster.

42 Lessons

Overview Presentation
0:07:18
Introduction
0:26:44
1.0 Linking sheets and workbooks
0:05:23
1.1 Linking Sheets Instructions
0:14:42
1.4 Revision exercise Instructions
Names and Conditioning Formatting
0:10:44
2.0 Names and Named Ranges
0:14:39
3.0 Conditional Formatting
0:04:51
3.0A Automatically highlight weekends
0:14:48
3.1 Exercise Tracker
0:09:35
3.2 Weight Loss Tracker
0:08:00
3.3 Covid19 Test Monitor
0:08:23
3.4 Conditional Formatting and names exercise instructions
Grouping, Subtotals, CountIF and Forms
0:10:31
4.0 Grouping and Outline
View more lessons +
This course is included in Arbington Premium
$15/month gets you access to every course. Start your 14 day trial today. ☝️

Class benefits

  • Certificate of Completion
  • 30 day satisfaction guarantee
  • 24/7 streaming access
  • Direct teacher access
  • 6h 23m of on-demand video
  • 12 downloadable files
  • Have a coupon?

About the instructor

I am a Microsoft Office, Project and Visio trainer with over twenty two years experience. Delivering training sessions to over fifteen thousand delegates. I am based in the UK and have been working as a trainer for IT's Easy Training for the whole twenty two years. Excel courses provide about 46% of …

View full profile

For super learners, get unlimited access for $15 per month

Start your 14 day free trial. Cancel at any time.

Join Today Learn More