Microsoft Excel | Basic, Intermediate & Advanced Modules

Name: Microsoft Excel | Basic, Intermediate & Advanced Modules
Rating: 4.6 (22 reviews)

Formulae, Formatting, Charts, PivotTables and many more things.

Created byExcelR EdTech

Last updated 11/2025

English

What you'll learn

Learn to use Excel efficiently with keyboard shortcuts and without relying on a mouse.
Master formulas and functions to perform calculations, data analysis, and problem-solving.
Create and customize charts, tables, and dashboards to present data visually and professionally.
Apply Excel skills in real-world scenarios like budgeting, reporting, and data management.

Course content

21 sections • 125 lectures • 23h 52m total length

Excel Introduction5:11
Font Style & Alignment15:18
Cell Formatting17:36
Auto Calculation and Shortcut22:25
Master autosum shortcuts with alt+equals, learn sum, average, count, max, and min, and explore fill, series, flash fill, clear, and find and replace in Excel.
Different Types of Paste Values11:48
Note & Comment13:17
Different Types of Sample Templates19:17

Worksheet Operations21:07
Explore practical worksheet operations in Excel, including inserting, renaming, hiding and unhiding, copying, deleting, and protecting worksheets, plus applying tab colors for organization.
Moving Worksheets, Protect Workbook8:02
Structure Level Protection12:06
Transpose Past in Paste Special10:20
Past Link & Skip Blank6:43
Paste Special Operations7:05
Math & Trigonometry Functions14:07
Explore Excel math and trig functions for data and business analysis, including int, round, round up, and round down, plus power, roman, arabic, square root, abs, and sum product.
Math & Trigonometry, Applying Conditions Using IFS Function34:07
Subtotal Function & Aggregate4:33
Learn how to use the subtotal and aggregate functions in Excel to total only visible cells, ignore hidden rows, and handle errors in large data sets.
Assignment 0115:40

Fill Series Using Linear and Growth Options5:27
Fill Series Date3:28
Master date series in Excel using autofill and the fill series options. Learn to fill day, month, year, and weekday patterns with drag, control R, and the smart fill button.
Fill Series Custom List3:25
Create custom lists in Excel to power autofill and fill series, using the ribbon and options. Import, edit, and delete lists, and learn that these lists are application dependent.
Fill Series Flash Fill9:18
Remove Duplicates2:38
Text to Column Name Manager12:47

Date Function9:38
Explore date and time functions in Excel, including today and now for current dates and times, and text and date functions to extract day, month, year and format dates.
Time Function3:56
Extraction of Date, Month and Years17:01
Basic Text Function or Basic String Function11:09
Advanced Text Function or Advanced String Function17:38
Substitute, Text Join, Text After, Text Before5:12
Assignment 0413:58

Sorting19:18
Learn to sort data in Excel with single- and multi-level criteria, including by value, color, font color, and icons, and master filtering options from auto to advanced.
Filter14:24
Apply Excel filters to create data subsets using text, number, and date criteria; use operators, custom filters (and/or), and top/bottom, year-to-date options for precise analysis.
Advanced Filters20:37
Assignment 056:01
Master multi-level sorting in excel: sort by segment, then country and profit; filter begins with f and quarter three; copy results to a new worksheet and include a screenshot.

Requirements

No prior Excel experience required — this course starts from the basics, Willingness to practice along with the lessons for the best learning experience.

Description

All-in-One Microsoft Excel Training: Become an Excel Expert

This comprehensive course empowers you to become a proficient Excel user, boosting your efficiency and productivity. With lessons on advanced tools like Macros and VBA, you will become an expert in unlocking the full potential of Microsoft Excel.

This Excel version agnostic training helps you master all versions of Microsoft Excel,

Here’s what you’ll learn through this course:

Efficiently navigate Excel using keyboard shortcuts, enhancing your speed in data entry, formatting, and worksheet management in day-to-day operations.
Apply consistent formatting, including fonts, alignments, and conditional formatting, ensuring well-structured reports and presentations.
Perform complex calculations and apply logical functions like IF, AND, OR, and nested IFs for decision-making in financial, operational, and analytical tasks.
Clean large datasets by removing duplicates, handling missing values, and preparing data for marketing, sales, or operational dashboard analysis.
Create various charts, graphs, and dashboards to present data insights to stakeholders in meetings and business reviews.
Summarise and analyse large datasets using Pivot Tables and Pivot Charts, which are crucial for generating monthly sales reports, budget analysis, and performance tracking.
Handling and manipulating date and text data for real-time scheduling, reporting, and data consolidation tasks.
Automate repetitive tasks to streamline repetitive processes.

Who is this course for:

Freshers and Working Professionals who want to take their Excel skills from beginner to expert level.

Who this course is for:

Freshers and Working Professionals who want to take their Excel skills from beginner to expert level.

Microsoft Excel | Basic, Intermediate & Advanced Modules

What you'll learn

Explore related topics

Course content

Excel Introduction7 lectures • 1hr 45min

Functions, Reference, Naming ranges4 lectures • 39min

Subtotal, Aggeragate, Consolidation3 lectures • 29min

Financial Functions, Goal Seek, EMI Table3 lectures • 37min

New function in Office 3654 lectures • 24min

Worksheet Operations Paste Special10 lectures • 2hr 14min

Fill Series Fash Fill Remove Duplicates Text to column6 lectures • 37min

Date and time and Text functions7 lectures • 1hr 19min

Data Validation4 lectures • 36min

Sort & Filter4 lectures • 1hr

Requirements

Description

Who this course is for: