Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Intermediate Excel course

Name: Intermediate Excel course
Rating: 4.3 (16 reviews)

From Data to Decisions: Intermediate Excel for Real-World Impact

Created byStephen Saxton

Last updated 12/2025

English

What you'll learn

How to use Microsoft Excel Pivot tables to manage large data sets.
Save time with avoid common errors with Excel.
Learn how to use subtotals and other database features
Understand how to use the IF functions and lookups, such as Vlookup and Hlookup
Use conditional formatting to automatically colour up trigger cells
Learn how to use named cells and ranges and work with them in formulae
Create charts using advanced automated features and functions

Course content

10 sections • 44 lectures • 6h 41m total length

0.0 Introduction7:18
this section contains te course manual
1.0 Linking sheets and workbooks26:44
1.1 Linking Sheets Instructions5:23
1.4 Revision exercise Instructions14:42

2.0 Names and named ranges10:44
This video explains how to named cells and named ranges. Once you feel confident in how to use names have a go at the exercise in the practise file Names
3.0 Conditional Formatting14:39
After this section you will be able to set automated conditions based on dates and figures, try using the name file to add your own conditions and practise. In the file called Name add the following conditions. Using the total column any figure over 1000 should be green, over 500 amber and less than or equal to 500 red. Try and recreate the conditions shown in the videos, use the attached files
3.0A Automatically highlight weekends4:51
3.1 Exercise tracker14:48
3.2 Weight Loss tracker9:35
3.3 Covid19 Test Monitor8:00
3.4 Project Management Heat Map using conditional formatting12:41
How to use conditional formatting to create a resource allocation heat map
3.5 The Bradford Factor4:33
Use conditional formatting to highlight attandance issues triggered by using the Bradford Factor
3.6 Conditional Formatting and names exercise instructions8:23

4.0 Grouping and Outline10:31
Ratios6:35
4.1 Subtotal and CountIF3:17
This video explains how to use the SubTotals feature and how the CountIF function may be a better option. Once you have watched the video try and recreate the features in the practise files.
4.2 Basic IF CountIF and SumIF statements17:11
Students will learn how to create a basic IF statement and how to create and use the CountIF and SumIF statements. After watching the video have a go at the exercises.
4.3 Timesheet with an IF16:50
4.4 Exercise Instruction IF SumIF CountiF10:12
4.6 Database Forms4:46
4.7 Forms Exercise Instruction0:47

6.0 Dynamic Charts8:27
Gannt Chart with a progress line8:52
6.1 Excel Maps5:15
Watch this video and then recreate the map on a new sheet as a practise. You can use the charting file and the maps tab if required.
6.2 3D Maps7:25
This video explains how Excel 3D maps work. You will need to be online for the feature to work. Once you have watched the video try to recreate it on a new sheet.
6.3 Intermediate charts10:12
In this section student will learn how to create a chart on two axis a dynamic chart using SumIF, a doughnut chart and much more. Try and recreate each chart that is shown on a new sheet. If the chart type is not explained in the video miss that one out.
S Curve Chart4:27
Pareto Analysis chart7:51
6.4 Exercise Instruction charts8:48

Requirements

Should complete the Excel basics course first but if the students have previous knowledge of Excel they will be able to take this course.

Description

Welcome to the course on Excel level 2. In this course, you will learn how to use advanced features and functions of Excel to create, analyze, and present data. You will also learn how to automate tasks, work with multiple worksheets and workbooks, and use data validation and protection tools. By the end of this course, you will be able to:

- Apply conditional formatting and custom number formats to enhance the appearance of your worksheets.

- Use formulas and functions such as IF, VLOOKUP, SUMIF, COUNTIF, and more to perform complex calculations and data analysis.

- Create and modify charts, sparklines, and slicers to visualize and summarize data.

- Use pivot tables and pivot charts to organize and manipulate large data sets.

- Link, consolidate, and group data from multiple worksheets and workbooks.

This course is designed for intermediate users of Excel who want to enhance their skills and productivity. To enroll in this course, you should have completed Excel level 1 or have equivalent knowledge and experience. You should also have access to a computer with Excel 2016 or later installed.

We hope you enjoy this course and find it useful for your personal or professional goals. If you have any questions or feedback, please feel free to contact us at any time. Thank you for choosing us as your learning partner.

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.

Intermediate Excel course

What you'll learn

Explore related topics

Course content

Overview presentation4 lectures • 54min

Names and Conditional Formatting9 lectures • 1hr 28min

4.0 Grouping, Subtotals, CountIF and forms8 lectures • 1hr 10min

5.0 Dynamic charts and SmartArt4 lectures • 24min

6.0 Advanced charts8 lectures • 1hr 1min

7.0 Vlookup and Hlookup2 lectures • 6min

8.0 Create an Invoice2 lectures • 19min

9.0 Pivot tables and charts4 lectures • 43min

10.0 Data Analysis2 lectures • 23min

11.0 Final Exercise1 lecture • 13min

Requirements

Description

Who this course is for: