Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Unlock MICROSOFT EXCEL: Excel Basics, Charts & Functions

Name: Unlock MICROSOFT EXCEL: Excel Basics, Charts & Functions
Rating: 4.3 (4 reviews)

Master Excel Charts, Pivot table, Maps. Learn Functions such as SUMIF, SUMIFS, IFS, SWITCH, TEXT, Date/Time functions

Created byPamch Tutor | M.EdTech | MCE

Last updated 6/2025

English

What you'll learn

Understand the basics of Excel and how to manipulate the workbook tabs, ribbons and tools
Creating and designing different types of charts - Histogram, Pareto, Funnel Chart, Combo Chart, Tree map, Box and Whisker Chart, Sunburst chart and more
Get a good grip on how to work with Maths & Trig Functions - TRUNC, POWER, SUM, SUMIF, SUMIFS, QUOTIENT, SUMX2PY2, SUMX2MY2, ,LCM, SIN, COS, TAN, etc
Master how to work with Logical Functions - IF, IFERROR, IFS, SWITCH, NOT, OR, AND, etc
Enjoy how to work with Text Functions - LET, CONCAT, MID, REPT, TEXT, ARRAYTOTEXT, TRIM, LEN, LEFT, RIGHT, etc
Understand how to work with Date & Time Functions - DAYS360, NOW, TODAY, DATE, TIME, etc
Master the skill of tracing dependents and precedents of data
Create 3D Map with Time Line

Course content

18 sections • 200 lectures • 28h 43m total length

Introduction6:24
Introduction - Part 213:06
Introduction - Part 35:53
Introduction - Part 46:54

Introduction to Excel Worksheet - Part 119:26
Introduction to Excel Worksheet - Part 214:44
Selecting Cells - Part 15:08
Selecting Cells - Part 26:17
Selecting Columns and Rows7:38
Inserting Rows, Columns and shifting Cells6:07
Status Bar7:05
A trick to move within cells6:41
Tell me what you want to do3:24
How to Search in Office 2021 and Office 3653:17
Customizing Quick Access Toolbar, Tabs and Ribbons17:21
Using the ALT key combinations as shortcut keys8:33
Excel Worksheet in Office 3655:10
Clipboard17:13
Paste Transpose and Number Formatting7:28
Paste Special Operations and Paste Link7:21
Click and Drag Content From One Cell to Another3:46
Font, Fill and Border Tools18:14
Alignment11:11
Format Numbers17:49
Explore Different Currency Symbols3:33
Format Date, Time, Phone Number, SSN13:23
Customizing cell styles15:51
AutoFormat Data5:45
Insert, Delete and Format cells14:31
Autosum Tools and Clear Tools10:15
Exploring Fill Handle16:24
Fill Tools15:58
Flash Fill9:47
Find, Replace, Wildcard Search13:37
Sorting Data11:31
Filtering Data6:42
Sort and Filter again12:22
Sort and Filter with colours3:44
Convert Text to Columns8:09
Flash Fill - Part 25:00
Remove Duplicates3:33
Data validation11:30
Creating data as a list4:19
Working with CSV in Excel11:44
Group and ungroup data4:50
Subtotal and Grand Total11:12

Chart Styles and Chart Data11:46
Chart Elements - Part 18:04
Chart Elements - Part 28:52
Learn how to customize Excel charts by adding chart titles and data labels. Explore data tables, legend placement, colors, borders, error bars, gridlines, trend lines, and moving averages.
Chart Styles and Chart Filters and Quick Layout9:52
Moving Charts and More on Chart Elements9:11
Formatting the chart elements11:17
More on Formatting your chart10:04
Formatting 3D Bar Chart8:35
Formatting 3D Pie Chart5:43
Formatting other 3D Charts6:37
Recommended Charts12:59
Stacked charts9:12
Learn to create stacked and 100% stacked charts in Excel, compare values across categories, adjust gap width and series overlap, and customize colors on primary and secondary axes.
3-D Column Chart10:34
Line chart and Area Chart14:14
3D Area Chart8:56
Area Chart again5:30
Box&Whisker and Scatter Chart12:18
Deeper Dive into Box&Whisker part 111:27
Deeper Dive into Box&Whisker part 29:59
Bubble Chart8:42
Understand how bubble charts compare two numerical variables using the third variable for size. See how x and y coordinates form the plot while the bubble size conveys additional data.
Stock Chart - High Low Closing10:29
Stock Chart - Open-High-Low-Close10:55
Stock Chart - Volume High Low Closing6:48
Doughnut Chart10:58
Doughnut Chart - 3D Format4:42
Treemap Chart6:55
Sunburst Chart6:35
Waterfall Chart6:49
Funnel Chart5:50
Histogram Chart - Part 110:41
Histogram Chart - Part 211:49
Pareto Chart13:32
Combo Chart16:30
How negative values impact a chart13:47
Interactivity of charts7:00
Using slicer tools to interact with charts - Part 16:58
Using slicer tools to interact with charts - Part 23:23
Map Chart - Introduction10:29
Map Chart - Chart Elements and Chart Design6:44
More on Map Charts8:00
Map Chart with multiple levels of geographic details5:54
Sparklines - Line15:18
Sparklines - Column6:36
Sparklines - Win/Loss8:36
3D Map - Introduction14:32
3D Map labels and flat map3:33
3D Map Time Line13:48

Introduction to Pivot Table - Part 16:35
Introduction to Pivot Table - Part 26:45
Using the Design Tab tools on Pivot Table7:02
Manipulating the PivotTable Field2:28
Using the Analyze Tab tools on Pivot Table4:32
Creating a Timeline filter4:45
Grouping Selections8:35
Field Settings and PivotTable Options8:14
Inserting a Slicer tool3:06
Recommended Pivot Tables1:56
Pivot Chart8:44
Learn to create and customize pivot charts in Excel, choose chart types, filter by names and dates, switch values and axes, and interactively analyze pivot data.
Apply Conditional Formatting to Pivot Table2:50
Revising what we have learnt so far - Part 111:02
Revising what we have learnt so far - Part 25:42
Reinforce pivot table techniques by moving fields between columns and values, toggling months and region, and counting sizes, while exploring pivot charts like pie, area, and radar.
Plotting a Pivot Chart directly4:11
Drilling the Dependent Data in Pivot Table3:23
Exploring Pivot Table in Office 3654:40

Requirements

This course is for ABSOLUTE BEGINNERS in Microsoft Excel. You will be taught from beginner to advanced
You can use Excel 2013, Excel 2016, Excel 2019, Excel 2021, Office Excel 365 software.
This course uses Excel 2016 and Excel 2021

Description

You are welcome to this TWO in one course.

**The FIRST SECTION is all about Excel Workbook, charts and pivot table

1) It deals with The Dynamics of Microsoft Excel Workbook

2) It deals with Conditional Formatting

3) It deals with The Dynamics of Microsoft Excel Charts and Maps

4) It deals with The Dynamics of Microsoft Excel Pivot Table and Pivot Chart

**The SECOND SECTION is all about the mastery of MS Excel Functions (Office 2021)

1) It deals with Mastery of MS Excel Functions (Office 2021/Microsoft 365) such as Maths & Trig Functions, Date & Time Functions, Logical Functions, Text Functions

In the FIRST SECTION, you will be able to:

Be able to use the conditional formatting tool to present data and create your own custom formatting

Explore the dynamics of Pivot Table and Pivot Chart

Understand how Pareto Chart works and gain apt understanding of the Pareto line

Understand how Histogram works and be able to manipulate the grouped data in bins

Be able to create a Map Chart with multiple levels of geographic details

Understand how Bubble Chart works and be able to interpret the data

Create 3D Map with Time Line

Learn how to create a Funnel Chart, Combo Chart, Tree map, Box and Whisker Chart, Sunburst chart and more.

In the SECOND SECTION, you will be able to:

Learn how to work with Excel functions from scratch (absolute beginner) to a comfortable professional:

Master the skill of tracing dependents and precedents of data

Flourish in the skill of nesting functions

Understand how to create lists of items with Data Validation

Master the tool of evaluating data

Creating and Deleting and Editing Defined Names

Understand how to work with Maths & Trig Functions - TRUNC, POWER, SUM, SUMIF, SUMIFS, QUOTIENT, SUMX2PY2, SUMX2MY2, LCM, GCD, SIN, COS, TAN, etc.

Understand how to work with Date & Time Functions - DAYS360, NOW, TODAY, DATE, TIME, WEEKDAYS, etc

Understand how to work with Logical Functions - IF, IFS, IFERROR, NOT, OR, AND, etc

Understand how to work with Text Functions - CONCAT, MID, REPT, TEXT, ARRAYTOTEXT, TRIM, LEN, LEFT, RIGHT, etc

Who this course is for:

This course is for ABSOLUTE BEGINNERS in Excel spreadsheet and Excel Functions.
If you want to have an excellent grasp of Excel Charts, Pivot Table, Conditional Formatting, Tables, Slicer tools, then this Excel course is for you.
If you want to have an excellent grasp of Excel Functions, Arrays and Data Manipulation, then this Excel course is for you.
Mastery of MS Excel Functions (Office 2021/Microsoft 365) such as Maths & Trig Functions, Date & Time Functions, Logical Functions, Text Functions

Unlock MICROSOFT EXCEL: Excel Basics, Charts & Functions

What you'll learn

Explore related topics

Course content

Course overview [This part shows what you will get from the course]-You can skip4 lectures • 32min

Part 1 - Dynamics of Microsoft Excel Workbook42 lectures • 6hr 48min

Part 2 - Conditional Formatting9 lectures • 1hr 30min

Part 3 - Working With Tables in Excel4 lectures • 53min

Part 4 - Dynamics of Microsoft Excel Charts and Map47 lectures • 7hr 21min

Part 5 - Pivot Table and Pivot Chart17 lectures • 1hr 35min

===Introduction to the SECOND section - Excel Functions ===2 lectures • 13min

Basic Formula in Excel7 lectures • 40min

Absolute Referencing vs Relative Referencing2 lectures • 16min

Syntax of Functions in Excel1 lecture • 11min

Requirements

Description

Who this course is for: