You will explore what cells and worksheets are, how to enter formulae, manipulate data through functions and present the data in an effective fashion.

14.5 hours of video learning material

Certificate of completion

5 downloadable resources

How to use Microsoft Excel and its basic functions

Everything about using and formatting cells

The principles and use of formulas

How to create a budgetary system

How to create worksheets

Anyone who wants to learn to use Microsoft Excel - no experience needed!

Professionals who want to learn new tools of Excel

Anyone who wants take their Excel skills from beginner to advanced

Boadu B.

It been awesome. Learning good stuff here.

Mehawk

Amazing......very clear instruction. Exceptional course for both beginner and advance users.

Pratham A.

Its really great

Asuman

Useful tutorial, thanks

Ali Mamdouh H.

awesome

Esther O.

Above my expectations!

Frempong E.

I like how the important steps are explained and made to stand out.

Cristopher Jose Avendaño F.

I's been amazing. Incredibly explained.

Akram Tawfiq W.

It is really good

20 sections • 96 lectures • 14h 25m total length

Introduction

3 lectures • 9min

What is Microsoft Office • 02:29

How do I get Microsoft Excel • 03:58

How do I open Microsoft Excel • 02:13

Getting to know the Interface

6 lectures •57min

Cell, Worksheets, and Workbooks • 09:05

The Ribbon Toolbar • 09:30

Selecting Cells and The Name Box • 11:03

Altering Rows and Columns • 10:20

Borders • 09:06

Revision: Times Table Square • 08:07

Using Formulae in Excel

8 lectures • 1hr 29min

Exploring Data Types • 11:47

Formatting Data • 14:49

Creating a Series • 07:52

Creating Formulae • 11:22

Formulae and Autofill (Relative Addressing) • 12:27

Resolving Relative Addressing Issues (Absolute Addressing) • 13:27

Formatting Cells • 09:55

Revision: Times Table Square • 07:49

Protecting Cells and Worksheets

2 lectures • 16min

Protecting Worksheets • 10:22

Restricting Data in Cells • 05:16

Data, Formatting and the First Function

5 lectures • 53min

Creating Lists • 04:07

Adding and Deleting Rows and Columns • 05:21

Conditional Formatting • 10:05

Introducing Functions - MOD • 12:41

Revision: Times Table Square • 20:59

Basic Functions in Excel

8 lectures • 1hr 7min

Introducing Battleships • 13:13

The IF Function • 10:00

The COUNTIF Function • 02:09

The COUNTA Function • 02:34

Nested IFs • 08:02

The SUM Function • 05:51

Named Ranges • 06:09

Revision: Battleships • 18:44

Shapes and Images

5 lectures • 48min

3D Formulae • 02:36

Shapes • 03:36

Images • 09:52

Revision: Battleships • 13:48

Revision: Battleships • 17:54

Importing Data into Excel

4 lectures • 41min

Using CSV files • 15:47

Exporting Data into a CSV file • 08:04

Issues with CSV files • 08:35

Importing CSV files Using the Legacy Wizard • 08:38

Averages in Excel

6 lectures • 53min

The AVERAGE Function • 14:42

The MEDIAN Function • 10:07

The MODE Function • 05:58

The MODE.SNGL Function • 03:01

The MODE.MULT function • 04:37

Revision: Gradebook • 14:29

Using Lookups in Excel

2 lectures • 16min

The VLOOKUP Function • 11:32

The HLOOKUP Function • 04:49

More Functions in Excel

6 lectures • 34min

The MAX and MIN Functions • 02:09

The RAND and RANDBETWEEN Functions • 07:26

The INDEX Function • 01:58

The MATCH Function • 05:00

Filters • 05:07

Revision: Gradebook • 11:51

Functions and Conditions

2 lectures • 9min

The SUMIF Function • 03:15

The SUMIFS Function • 05:16

Working with Dates and Text

2 lectures • 9min

Working with Dates • 05:26

Working with Text • 03:45

Simple Graphs and Charts

4 lectures • 41min

Simple Bar Graphs • 06:14

Pie Charts • 03:50

Scattergraphs • 18:00

Scattergraphs 2 • 13:12

Handling Text and Importing WWW Data

3 lectures • 37min

3 lectures • 37min

More Manipulating Text • 17:00

Importing Data from the Web • 07:53

Generating Test Data

2 lectures • 41min

Creating Test Data Pt. 1 • 22:17

Creating Test Data Pt. 2 • 19:05

Creating a Budgetary System

2 lectures • 51min

Developing a Budget Spreadsheet • 28:49

Continuing the Budget Spreadsheet • 21:56

Revision Exercise: Astronomical Modelling

4 lectures • 1hr 19min

Revision: Astronomical Modeling Pt. 1 • 21:24

Revision: Astronomical Modeling Pt. 2 • 23:39

Revision: Astronomical Modeling Pt. 3 • 27:56

Revision: Astronomical Modeling Pt. 4 • 05:32

New Functions in Excel 365

13 lectures • 1hr 5min

UNIQUE and Spills • 09:07

The IFS Function • 08:58

The MAXIFS Function • 02:21

The MINIFS Function • 01:09

The SWITCH Function • 02:33

The SORT Function • 02:55

The XMATCH Function • 08:22

The LET Function • 03:30

The XLOOKUP Function • 04:20

The FILTER Function • 02:11

The SORTBY Function • 02:12

The SEQUENCE Function • 05:53

Revision: Combining Functions • 11:27

More Basic Features of Excel

9 lectures • 52min

The RANDARRAY Function • 07:48

Text to Columns • 01:27

Zooms and Sheet Selections • 02:21

Logical Functions • 10:09

ODDs and EVENs • 06:47

Trigonometry • 10:06

Ceilings and Floors • 06:07

Reviewing all our Learning • 06:24

Last Words • 00:31