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.
Over 435,214+ students took our courses
Get Access To Full Course
What's included:
14.5 hours on-demand video
5 downloadable resources
Access on mobile and TV
Certificate of completion
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

Watch video

What's included

You will explore what cells and worksheets are, how to enter formulae, manipulate data through functions and present the data in an effective fashion.
Using Formulae in Excel
Data, Formatting and the First Function
Every single detail counts. Learn how to format data, how to create formulae and how to resolve relative addressing issues
YLearn how to format data
Learn how to resolve relative addressing issues
Ut facilisis justo consequat;
Every single detail counts. Learn how to create lists, how to add and delete rows and columns and work with conditional formatting.
Learn how to add and delete rows and columns
Learn how to work with conditional formatting

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

Get skills, get clients, go travel. With Skillademia.

The current education system needs improvement. Especially in the developing countries, where infrastructure is poor. Skillademia aims to provide quality education to as many learners as possible.

435,214+ customers from 98 different countries

Led by a team of 30 passionate employees

A revolutionary approach to learning.

And we're on our way to solve education.

The smarter way to learn.

Skillademia takes you from a complete novice to an advanced pro, easily.

Easy-entry barrier

Higher education costs upwards of $10k per year, while courses don't provide much value. Skillademia is the opposite.

Community-support

Learn together with your tribe of passionate learners. Community support, helpful guidance, and like-minded people.

Step-by-step guides

Skillademia takes complete novices and guides them to become a pro. So fun and exciting, a toddler could learn Photoshop.
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.
Over 435,214+ students took our courses
Get Access To Full Course
userchevron-down