Complete Microsoft Excel: Tools, Formulas, Pivot & Charting

Name: Complete Microsoft Excel: Tools, Formulas, Pivot & Charting
Rating: 4.7 (2 reviews)

Master Microsoft Excel from using basic tools to Writing Advanced formulas, Creating Pivot Tables and Excel Dashboards

New

Created byAhmed Oyelowo

Last updated 7/2026

English

English [Auto],

What you'll learn

Manage Excel Workbooks and Worksheets
Use Excel Formulas to solve business problems
Use Excel Pivot Tables to summarize and Analyze Date
Use Excel Charts to visualize data and build Excel Dashboards
Manage data in Excel with Excel tools

Course content

3 sections • 150 lectures • 10h 6m total length

Pre-requisites1:21
Download the Files Used in this section0:04
Overview of Excel Knowledge areas1:28
Understanding Microsoft Excel Environment5:52
Peek into Excel Options Settings4:21
Saving and Protecting Excel Workbook files with Passwords5:31
Efficiently navigate between Excel Worskheets1:40
Efficiently navigate between Excel Workbooks1:52
Introduction to copying and pasting data4:30
Understanding Paste with options5:59
Using the Paste with options dialogue box4:01
Pasting copied data from the clip-board2:49
Quiz 1
Copying entire worksheets with Move or Copy feature4:48
Intro to Finding and Replacing data in excel3:34
Using the Find and Replace options3:38
Using Asterisk * as a wildcard to find and replace unknown data values3:32
Using Question Mark ? as a wildcard to find and replace unknown data values3:05
Finding and replacing data values based on cell formats2:10
Introduction to Cells in Excel2:54
Efficiently increasing cell size, row height and column width7:42
Understanding data types in Excel5:48
Understanding Dates as Numbers in Excel4:56
Introduction to Cell Formatting (part 1)7:17
Introduction to Cell Formatting (part 2)3:43
Introduction to Numbers formatting in Excel3:55
Customizing Number Formats4:51
Understanding the behavior of custom number and text formats7:06
Customizing Date Formats6:04
Formatting Cells - Round up Exercise5:40
Quiz 2
Introduction to Data Sorting2:16
Basic Data Sorting in Excel4:30
Sorting data with spaces in between2:58
The most efficient way to sort data4:41
Using other sorting options2:43
Using advanced sorting options6:45
Introduction to data filtering in excel4:19
Clearing filters from data and using search to filter data4:43
Applying filters on data based on conditions4:54
Using Advanced Filters option2:28
Keeping data headers visible with freeze panes3:50
Organizing data into collapsible groups with Outlines7:36
Introduction to filling data across cells with Fill Series and Autofill3:23
Using the Fill Series Dialog box3:55
Filling data series sing Linear and Growth options2:55
Filling data series based on existing trends1:52
Using flash-fill to fill data based on patterns1:28
Quiz 3
Introduction to Data Validation in Excel4:14
Creating Excel Dropdown lists3:20
Separating texts with delimiters to different columns3:37
Separating texts into different columns using a fixed width3:20
Introduction to writing formulas in Excel1:23
Writing simple Excel formulas with primitive values4:17
Introduction to Functions in Excel2:16
Writing basic Excel formulas using Excel Functions8:11
Adding up data values with SUM function5:15
Saving time with AUTOSUM feature6:12
Introduction to other aggregate functions in Excel8:24
Section Wrap2:12
Quiz 4

Download this section Workbook files here0:04
Understanding Excel Functions5:32
Understanding Expressions in Excel5:29
Understanding Expressions (part 2)0:53
Introduction to Excel Aggregate Functions7:03
Using Aggregate functions (part 2)4:32
Replicating formulas across cells & using the autosum feature5:45
Using the SUBTOTAL function5:07
Counting data in ranges with COUNT and COUNTA functions3:34
Assignment 1
Converting text values to different cases with UPPER, LOWER and PROPER3:04
Using LEFT and RIGHT excel functions to extract beginning and ending characters5:10
Using MID to extract middle characters and TRIM to remove extra spaces4:21
Combining texts with CONCATE, CONCATENATE & TEXTJOIN functions in excel7:24
Converting between text and number values with UNICHAR and UNICODE3:10
Using LEN to count length, FIND and SEARCH functions to find characters location4:41
Assignment 2
Introduction to Date functions in excel4:32
Extracting day, year and month parts of dates with DAY, YEAR and MONTH functions1:56
Using TEXT function to write dates in text forms7:15
Extracting day of week and week of year with WEEKDAY and WEEKNUM functions4:36
Using DATEVALUE to correct dates written in text formats to date formats2:48
Getting the last day of the month with EOMONTH function in excel3:08
Getting a specific date from a start date with EDATE function2:30
Getting number of working dates between 2 dates with NETWORKDAYS & it's Int'l5:00
Introduction to DATEDIF for calculating duration from a date4:28
Calculating Age in different units with DATEDIF function in Excel6:46
Assignment 3
Introduction to combining functions in Excel4:38
Combining functions in excel (part 1)7:18
Combining functions in excel (part 2)7:40
Combining functions in excel (part 3)6:20
Combining functions in excel (part 3b)4:27
Introduction to most important formula writing feature - Cell Referencing to5:44
Using the relative cell referencing style5:08
Using the absolute cell referencing style6:03
Using mixed cell referencing style7:34
Assignment 4
Introduction to logical operators in excel2:02
Counting cell values based on condition with COUNTIF function (part1)7:27
Counting cell values based on condition with COUNTIF function (part 2)3:13
Counting values based on multiple criteria with COUNTIFS function4:32
Using SUMIF and AVERAGEIF to summarize data categories in groups5:31
Using SUMIFS and AVERAGEIFS to summarize data categories with multiple criteria2:09
Introduction to Logical functions in excel3:59
Using IF function (part 1)2:58
Using IF function (part 2)4:09
Introduction to AND & OR functions3:08
Combining IF with AND functions3:55
Combining IF with OR function5:17
Using nested IFs4:42
Assignment 5
Introduction to VLOOKUP function5:21
Using the VLOOKUP function (part 2)3:45
Using the VLOOKUP function (part 3)3:37
Introduction to MATCH function5:32
Combining VLOOKUP and MATCH functions5:54
Combining VLOOKUP and IFERROR functions to trap unfound matches3:06
Using VLOOKUP function (part 4)3:56
Introduction to XLOOKUP2:53
Introduction to INDEX function2:52
Combining INDEX and MATCH functions2:57
Assignment 6

Download the Excel Files for this Section here0:04
Creating excel charts with Alt + F1 Keyboard shortcut3:25
Updating data range used in a chart4:38
Using Excel Data Tables to automate chart data input2:47
Creating charts from unsummarized data4:03
Creating charts from unsummarized data (part 2)3:00
Editing and Updating Excel Chart Axes3:49
Changing chart types2:36
Understanding Excel Chart Elements3:25
Formatting Chart Elements2:25
Formatting Chart Area Fill & Text Colors3:23
Formatting the Lines in an Excel Line Chart2:25
Chart Number Formatting & Display Series3:43
Using Combo charts and formatting columns gap width4:08
Formatting Excel Chart Titles, Grid Lines and Chart Legends2:08
Using Pie Charts and Formatting Data Labels3:41
Introduction to Excel PivotTables for reporting and Workbook structuring2:29
Understanding data rules for pivottables2:18
Creating basic pivot tables on new excel worksheets3:41
Creating Pivot Tables on Existing Worksheets and Renaming Pivot Table Headings2:36
Understanding Pivot Table Row Field and Pivot Table Design Layout3:34
Understanding Pivot Tables Column and Filter Field Buckets2:39
Understanding Pivot Tables Value Field Bucket & Changing default measure summary1:59
Applying Sorting & Filtering on Excel Pivot Tables3:17
Displaying Pivot Tables Numbers using different derived calculations2:41
Updating Excel Pivot Tables Source Data & Refreshing Pivot Tables2:13
Working with Date Columns in Pivot Tables3:48
Creating additional Pivot Tables (part 1)3:12
Creating Additional Pivot Tables (part 2)2:21
Using Slicers to apply interactive filters on Pivot Tables4:39
Building an Excel Dashboard (part 1)4:29
Building an Excel Dashboard (part 2)5:42
Building an Excel Dashboard (part 3)1:00
Building an Excel Dashboard (part 4)3:39
Building an Excel Dashboard (final part)6:17

Requirements

Microsoft Excel 2013 or above on Windows Computer

Description

Everybody thinks they know Microsoft Excel simply because they can open a spreadsheet and type in some data. To me, that's just like thinking you can cut down a tree because you have a razor blade"

Hi, My name is Ahmed Oyelowo - a Microsoft Certified Trainer, Certified Educator and Certified Microsoft Office Specialist - Excel Expert.

Welcome to the Complete Microsoft Excel: Tools, Formulas, Pivot & Charting Course. This is the only course you need to instantly become one of the best Excel users in your office or workplace.

If you are wondering where my confidence comes from, it is because my teaching methodology is built on delivering concepts in ways that are simple, enjoyable, relatable and easy to remember.

In this course, I will teach you how to solve problems in excel using:

the clicky-clicky tools in excel
how to write excel formulas using all the every day excel functions that solve majority of spreadsheet problems
how to analyse data in excel using Pivot Tables and
how to visualize data and build dashboards in Excel

I will provide all my Workbooks for you and...I will also give you Excel Formulas Practice Workbooks that you can use independently to practice your formulas and know when you have written the formulas correctly.

This course covers all the topics you need to master Excel including:

Loads of Keyboard Shortcuts
Workbook & Worksheet Navigation
Workbook & Worksheet Protection
Data Validation
Text to Columns
Advanced Data Sorting & Advanced Data Filtering
Freeze Panes
Using Excel Functions to write Advanced Formulas
SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS functions
DATEDIF, NETWORKDAYS, DATE, EOMONTH, EDATE functions
CONCATENATE, TEXTJOIN, CONCAT functions
IF, AND, OR functions
VLOOKUP, XLOOKUP, INDEX, MATCH functions
Pivot Tables
Excel Charts
Building Dashboards in Excel

Ready to start? Join me inside the course

Who this course is for:

Beginner and Intermediate Excel users
Aspiring data analysts
Aspiring data scientists
Finance professionals
Accounting professionals
Graduate Trainees
Students
Business owners
Marketing professionals

Complete Microsoft Excel: Tools, Formulas, Pivot & Charting

What you'll learn

Explore related topics

Course content

Mastering Microsoft Excel Tools58 lectures • 3hr 58min

Mastering Microsoft Excel Functions and Formulas57 lectures • 4hr 17min

Analyzing & Visualizing Data in Excel with PivotTables and Excel Charts35 lectures • 1hr 52min

Requirements

Description

Who this course is for: