Image by Philipp Katzenberger

Excelpedia

Microsoft Excel Online Video Course

Description

There are millions of Excel videos on the Internet. It is overwhelming for people who want to learn Excel to decide which videos to watch and the sequence to watch.

Excelpedia is a collection of free Excel videos on the Internet.  It provides a course outline which gives you a structural way to learn Excel.  You do not need to sign-up or do anything to access this course. It helps you self-learn Excel at your own pace.

We hand-picked each video in the course to make sure that it is the best video to watch to learn a certain topic.  We also broke down long videos into smaller sections so you can watch the section of a video that is the most relevant to the topic you are learning. 

If you are completely new to Excel, we suggest going through these lessons in the sequence we designed. If you already know how to use Excel, feel free to dive into a topic that interests you.

 

People upload new videos to the internet from time to time and so is this course.  Please do come back to this course often as we will include new videos to the course as needed.

Who this course is for

  • Anyone who wants to learn Excel

  • No prior experience of Excel required

Course content

Module 1 - Getting Started with Excel

15 lessons

04:15

Quick introduction of Excel

08:21

Get familiar with the Excel startup screen and the main working area.

08:44

Backstage view

05:20

Understanding the Ribbon

01:33

The Formula Bar

02:23

See how to use the status bar.

01:15

Learn how to use the Excel help menu.

03:34

How to use the Tell Me What you Want to Do Help feature?

05:21

Getting started with Excel

03:00

A trick to avoid one Excel affecting another Excel when it crashes.

00:26

Close Excel the most usual ways.

02:41

Close all or Exit Excel quickly in separate windows mode.

00:49

A fast way to close all workbooks in Excel when you do not want to save them.

02:58

Saving your workbooks

03:22

Ways to recover unsaved or deleted Excel files

Module 2 - Customizing Excel

16 lessons

01:40

Customize the Quick Access toolbar using Excel Option.

01:18

Adding Ribbon commands to the Quick Access Toolbar

01:09

Run macros with one-click by adding them to the Quick Access Toolbar.

07:00

Customizing the Ribbon bar

01:02

Export and import customizations

00:30

Rest customization in Excel

02:37

Increase the number of rows you see on the screen by using different Ribbon display options.

00:44

Hide the formula bar if you do not need it

02:09

Options in the General tab explained

03:18

Some frequently used options in the Formulas Options

04:01

Reducing data entry time by expanding AutoCorrect options

02:42

Save time by setting up your default save location

01:41

Change the display language in Excel

05:27

Some common default settings you may want to change

15:51

6 Free Office Add-Ins you may want to start using

01:00

How to install Excel Add-in (AlchemyJ)

Module 3 - Building Worksheets

12 lessons

01:55

Creating and opening new workbook

02:56

Learn more about Excel templates

02:50

Entering Data into Excel

01:59

Excel Labels, Values and Formulas

03:14

Data Entry Keyboard Shortcuts (Beginner)

02:59

Data Entry Keyboard Shortcuts (Advance)

04:08

Excel Autofill (beginner)

08:49:51

Excel Autofill (advanced)

02:50

Custom List for Autofill

08:37

Mastering Auto complete and auto fill in Excel

05:31

Data validation in Excel

03:50

Creating dropdown list in Excel

Module 4 - Formatting Worksheets

23 lessons

04:30

Selecting Cells in Excel

06:00

7 keyboards shortcut to select cells and ranges in Excel

01:43

Excel Shortcuts - Go to a specific cell and special options

02:13

Named range in Excel

01:09

Modify the columns and rows in Excel

04:14

Hide and unhide rows or columns in Excel

02:32

Wrapping and Shrinking cell text in Excel

05:28

Tables in Excel

06:04

Excel number formats explained

02:43

Creating custom number format in Excel

04:03

Cell alignment formatting and best practices

01:31

Excel working with fonts

02:10

Change cell color in Excel

01:30

Giving Cells Background Pattern or Gradient

01:25

Format Painter in Excel

03:32

Excel Conditional Formatting

01:33

Excel Conditional Formatting - Data bars

06:15

Excel Conditional Formatting - Color Scales

02:02

Excel Conditional Formatting - Icon Sets

02:45

Excel Conditional Formatting - Icon Sets for Text

08:12

Conditional Formatting with Formula

11:15

Working with Styles and Themes in Excel

Module 5 - Editing and Proofing Worksheets

14 lessons

01:05

Opening Existing Workbook

03:15

Workpace - what is it and how to create one?

01:30

Learn how to open two workbooks at the same time

04:11

Easily view two sheet side by side in Excel

01:20

Editing content of a cell

04:14

Learn how to use undo and redo in Excel

02:26

Learning zooming in Excel

01:58

Learn how freeze panes works in Excel

04:27

Learn more on custom view in Excel

06:22

Learn about cut, copy and paste in Excel

06:18

How to find and replace in Excel also some advance features in it

00:57

Learn how to run spell check in Excel

02:21

Learn more on translation feature in Excel

01:51

Find out how to highlight invalid data in Excel

Module 6 - Managing Worksheets

13 lessons

01:53

Insert and Delete rows or columns in Excel

05:10

Find out what is split panes in Excel

01:02

Learn Grouping in Excel

03:20

Learn how to use subtotal in Excel

05:58

What is Auto-outline in Excel

02:42

Learn how to insert, delete, rename and rearrange worksheet

04:14

Learn grouping sheets in Excel

02:08

Find out how to hide and unhide sheets in Excel

06:17

Learn how to unhide all sheets in Excel

05:00

Learn how to compare two Excel files for difference

04:14

Learn how to move and copy sheets to another workbook in Excel

08:15

Learn how to consolidate data by position in Excel

05:09

Find out how to consolidate data by category or label

Module 7 - Printing Worksheets

7 lessons

03:13

Learn on how to set print area in Excel

09:54

Learn how to print and use printing features in Excel

02:40

Find out what is page layout view in Excel

04:04

What is print scaling in Excel

03:32

Learn how to create headers and footers in Excel

01:21

Find out how to use quick print in Excel

02:01

Learn how to print formulas in Excel

Module 8 - Building Formulas

28 lessons

03:30

Getting started with Formula in Excel

03:23

Find out how to edit formula in Excel

03:25

How to use Autosum formula in Excel

01:30

Find out how to use the quick analysis tool in Excel

#VALUE!

Learn how to use insert functions formulas in Excel

05:15

See how to use relative and absolute cell reference in Excel

04:39

Learn what is an array formula and how to use it.

02:09

Learn how to use transpose function in Array Formula

01:14

Learn how to use SUM and IF functon in Array Formula

02:13

See how to combine different functions with IF function in Array Formula

00:58

Learn how to find the weighted average using array formula

00:24

Using SUM and IFERROR function in array formula

01:30

Find out more on entered table

00:56

Learn about small and large functions in entered table

01:26

Find out how to find the number of unique values in a table

02:22

How to find the closest value in Excel

02:47

Check how many times certain data appeared in a table

02:31

Learn how to define name range for a cell

01:47

How to define name range for multiple cells

03:39

Learn how to use the name manager

00:57

Find out how to list all the name ranges in the workbook

01:25

How name ranges highlighted on a worksheet

06:03

Find out how to use relative name ranges in Excel

05:17

Learn more different ways to use relative name ranges

01:29

See how to reference data from another file in Excel

02:03

Learn how to recalculate your Excel Formula in Excel manually or automatically

03:32

What is circular reference error and how to find and fix it

03:25

See what iterative calculation is and how to enable iterative calculation

Module 9 - Logical Functions and Error Trapping

7 lessons

04:16

Show what is the Excel formula error about and how to fix it

05:58

Learn more about Excel logical functions

09:29

See how to handle NESTED IF function in Excel

03:38

Learn how to use IFS function instead of NESTED IF function in Excel

07:03

See how to use SWITCH function and also SWITCH function with VLOOKUP

03:40

Learn how to use CHOOSE function to replace VLOOKUP in Excel

04:15

See how to use IFERROR function in Excel

Module 10

0 lesson

Module 11

0 lesson

Module 12

0 lesson

Module 13

0 lesson

Module 14

0 lesson

Module 15

0 lesson

Module 16

0 lesson

Module 17

0 lesson

Module 18

0 lesson

Module 19

0 lesson

Module 20

0 lesson

Heading 3