Unlock all Microsoft Excel lessons and 4,242+ more with a single membership. Start Learning Now

Microsoft Excel

Microsoft Excel

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
What you'll learn:
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
Who is this for:
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

What our customers say about this course

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

Curriculum for Microsoft Excel

14.5 hours of valuable material

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

Advance your skills with thousands of professional classes made by experts

4,242+
Lessons
2,351+
Hours of video content
56+
Different skills
crossmenuchevron-downarrow-right linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram