Teach on Udemy

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

Learn More

Your cart is empty.

Keep shopping

Microsoft Excel 365 - Beginner to Advanced Level

Name: Microsoft Excel 365 - Beginner to Advanced Level
Rating: 4.4 (33 reviews)

Excel Beginner to Advance. Excel Formatting, Excel Functions, Excel Charts, Excel Pivot Table.. (2016, 2019 & Excel 365)

Created byHimanshu Dhar

Last updated 10/2025

English

What you'll learn

Basic to Advance Level Excel in the latest Office 365
Mastering the use of Text Functions
Mastering the use of Math Functions
Mastering the use of Logical Functions
Mastering the use of Lookup and Reference Functions
Mastering the use of Date and Time Functions
Mastering the use of Pivot Table and Power Pivot
Mastering the use of Chart Preparation
Mastering the use of What If Analysis Tools
Mastering the use of Data Organizing Tools
Learn to Record Macro Effectively

Course content

15 sections • 88 lectures • 12h 1m total length

Excel Intro - New File and Title Bar9:08
How to open new Excel File
Understanding Title Bar options
Autosave File option
Search within File
Command Button option
Customize Ribbons and Quick Access Toolbar8:16
Understanding Excel Ribbon Structure
Learn to Customize Ribbon
Learn to customize Quick Access Toolbar
Excel Structure and Worksheets10:47
Excel Rows and Columns
All About Excel Worksheets
Rename Sheet
Hide/Unhide Sheet
Delete and Create Sheet
Color/Highlight Sheet
Data Entry and Formatting14:16
Understand all the format options in Excel
Fundamentals of data entry in Excel
Fill Series in Excel11:22
Cell Properties
Number Fill Series
Text Fill Series
Date Fill Series
Custom Options in Fill Series
Flash Fill in Excel3:15
How to work with all new Flash Fill
Cell Reference Understanding5:57
Understanding Relative Cell Reference
Understanding Absolute Cell Reference
Understanding Mixed Cell Reference

IF Function in Excel7:38
Logical Test
Introduction to If Function
Nesting IF Methodology4:44
Nested If Examples
IF Related Project Solution8:42
Nesting IF() to get desired output
IF Project Task1:07
Time for the small project task on IF()
IF Project Task Solution4:44
Got it correct? If not watch the video for solution
IFS Function - Newly Introduced4:56
IFS can take the place of multiple nested IF statements, and is much easier to read with multiple conditions.
AND & OR Function in Excel6:07
AND() Function
OR() Function
Nested IF() with AND() & OR()
Advance Examples
XOR Function4:34
The XOR function returns a logical Exclusive Or of all arguments.

Filter in Excel16:27
How to Apply Filter correctly
How to use Filter
Text Filter
Number Filter
Date and Color Filter4:37
Date Filter
Filter by Color
Advanced Filter Option6:35
Excel Advanced Filter is the advanced version of the regular filter. You can use this when you need to use more complex criteria to filter your data set.
Sort and Custom Sort4:20
Regular ascending and ascending sorting option
Create your own custom sort

UPPER, LOWER, PROPER and TRIM Function8:28
Introduction to Text Function
UPPER()
LOWER()
PROPER()
TRIM()
Nesting TRIM with other Function
LEFT, RIGHT and FIND Function7:18
LEFT()
RIGHT()
FIND()
Find Related Task Solution6:21
Advance FIND() Function practical example
Nesting LEFT, RIGHT and FIND Function3:53
Nesting FIND() with RIGHT() & LEFT()
MID Function4:17
MID Function
Nested MID
CONCATENATE Function4:25
CONCATENATE()
Nesting CONCATENATE with other Text Function.
CONCATENATE Project Task Solution2:40
Practical CONCATENATE() Function example
CONCAT and TEXTJOIN Function4:21
TEXTJOIN lets you join values with a delimiter of your choice, and has an option to ignore empty values. CONCAT simply mashes all values together without options.
REPLACE Function7:15
REPLACE()
Nested REPLACE()
REPLACE Function Project Solution1:55
REPLACE() Function practical example
SUBSTITUTE Function4:30
The Excel SUBSTITUTE function replaces text in a given string by matching
REPT, LEN Function and Project2:23
REPT()
LEN()
Project
Task Solution - Substitute and Len Nesting2:35
Project Task Solution
NUMBERVALUE Function3:24
The Excel NUMBERVALUE function converts a number in text format to numeric value, using specified decimal and group separators.
Text to Column Option14:28
How to use Text to Column
Delimited & Fixed Width
Date Format through Text to Column

Chart Preparation in Excel16:29
Start with Excel Chart
Understanding Layout options
Designing and Format Chart14:23
Chart Format
Chart Design
Chart Customization - Part 13:50
Handling Axis and Series
Chart Customization - Part 25:29
Handling Data Series and Legends
Customize options
Pie Chart in Excel12:25
How to create Pie chart
Create Pie of Pie Chart
Quick Analysis and Chart Recommendation3:58
How to use Quick Analysis
Chart Recommendation
Power Map in Excel5:11
Microsoft Power Map for Excel is a three-dimensional (3-D) data visualization tool that lets you look at information in new ways.

Pivot Table in Excel53:50
How to create Pivot Table
Managing Fields Properly in Field area
Managing Value setting
How to get detailed report
Managing Field List, Buttons & Field Headers
Refresh Options
Designing Pivot Table
Pivot Table layout
Changing Source Data
Managing Slicer
Pivot Chart
Multiple Pivot Table
Handling Dates and Values through Group option
Doing Calculation through Calculated field.
GETPIVOTDATA Formula4:27
Power Pivot in Excel - Most Powerful Analysis Tool29:45
Practice Files are available in Resources

PDURATION Function2:33
PDURATION() Function helps the user calculate the time or the specific number of periods required for an investment made to reach a particular value
PMT Function - EMI Calculator6:13
How to create EMI Calculator
Apply PMT() Function
Data Table in Excel11:45
How to create data table
How to format data table
Goal Seek in Excel5:44
How to apply Goal seek
Get the desired output from complicated equation through Goal Seek
Solver Plugin in Excel4:52
A solver is a mathematical tool present in MS-Excel that is used to perform calculations by working under some constraints/conditions and then calculates the solution for the problem
Scenario Manager in Excel7:22
How to Apply Scenario Manager
How to merge Scenario
How to get Scenario summary

Define Name Feature in Excel8:56
How to name ranges with Define Name
What are the advantages of it
Hyperlink in Excel7:47
Types of Hyperlink
How to Apply it
Group and Subtotal in Excel7:24
Excel provides an easy way to organize data in groups allowing you to collapse and expand rows with similar content to create more compact and understandable views.
Draw Tab in Excel5:22
The Draw Tab allows you to make drawing edits within a spreadsheet. This tab is found on the Excel ribbon and is not enabled by default.
Data Validation10:48
Data Validation - Input message and Error Alert4:58
Indirect Function4:45
Data Validation - Create Dependent List4:12

Requirements

Basic Computer Knowledge
No previous knowledge is required
Great for students who want to learn at their own pace

Description

Unlock Your Full Excel Potential: Excel 365 - From Beginner to Advanced

Are you ready to excel in Excel, even if you've never touched it before?

Discover the Power of Microsoft Excel 365!

In today's data-driven world, Excel isn't just a tool – it's the ultimate key to success. But we get it – you're short on time and don't have any prior experience. That's where we come in.

Our comprehensive course, "Excel 365 - From Beginner to Advanced", is designed especially for you. Starting from the ground up, we'll guide you through 11 hours and 30 minutes of expert-led training that will transform you into a Microsoft Excel master.

Why This Excel Course is Your Game-Changer:

Career Opportunities: Excel mastery opens doors in every field.
Rapid Advancement: Excel experts climb the corporate ladder effortlessly.
Future-Proof Skills: Your Excel proficiency means job security in any economic climate.

What Sets Us Apart:

High-Quality Production: Crystal-clear HD video and top-notch sound.
Experienced Instructor: With over 19,000 Udemy students and 14+ years in the industry.
Downloadable Resources: Handouts, Excel files, and more at your fingertips.
Practical Examples: Reinforce your learning with real-world scenarios.
Exceptional Support: Prompt answers to your questions and feedback.
Dynamic Learning: No time-wasting – we maintain an engaging pace.
Comprehensive Coverage: We leave no Excel stone unturned.
Latest Version: Tailored for Office 365, but applicable to any Excel version.

Who Benefits Most:

University students seeking an edge in their studies.
Entry-level finance, business, and marketing professionals eager to outshine their peers.

Our Promise to You:

Rest assured, our course comes with Udemy's 30-day unconditional money-back guarantee. We're confident it will deliver immense value, so why not take the leap?

Ready to embark on this transformational journey? Buy the course today and unlock the full potential of Excel 365. Don't miss out – seize this opportunity to enhance your skills, advance your career, and secure your future!

Who this course is for:

MIS Job Aspirants
Anyone want to get expertise in Excel

Microsoft Excel 365 - Beginner to Advanced Level

What you'll learn

Explore related topics

Course content

Lets Start with Excel Fundamentals7 lectures • 1hr 3min

Mastering Mathematical Functions4 lectures • 58min

Mastering Logical Functions Use8 lectures • 43min

Data Filter and Sorting in Excel4 lectures • 32min

Conditional Formatting in Excel3 lectures • 23min

Mastering Text Functions and Tools15 lectures • 1hr 18min

Mastering Chart Presentation in Excel7 lectures • 1hr 2min

Mastering Pivot Table and Power Pivot3 lectures • 1hr 28min

Financial Functions and What if Analysis Tools6 lectures • 38min

Data Grouping, Linking & Validation8 lectures • 54min

Requirements

Description

Who this course is for: