Udemy
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel: Beginner to Advanced Project Based Training
Rating: 4.1 out of 5(96 ratings)
1,920 students

Microsoft Excel: Beginner to Advanced Project Based Training

Learn Excel formulas, AI, XLOOKUP, PivotTables and Power Query. Build dashboards and reports with practice workbooks.
Last updated 11/2026
English
English [Auto],

What you'll learn

  • Build and format Excel spreadsheets using tables, keyboard shortcuts, sorting, filtering, and conditional formatting.
  • Clean and reshape data with Flash Fill, Text to Columns, duplicate removal, and Excel text and date functions.
  • Write IF, AND, OR, COUNTIF, SUMIF, and SUMIFS formulas, and use relative and absolute references correctly.
  • Find and match records with XLOOKUP, VLOOKUP, HLOOKUP, INDEX and MATCH, and DGET.
  • Combine files from a folder with Power Query to prepare a consolidated dataset for reporting.
  • Summarize data with PivotTables and PivotCharts, then build interactive dashboards with slicers.
  • Create drop-down lists with data validation and use named ranges to organize inputs and formulas.
  • Apply Excel to marksheets, sales and bonus reports, bank reconciliation, and accounts receivable aging.
  • Use advanced filters and macros for repetitive tasks, and explore AI-assisted Excel workflows.
  • Set up print-ready worksheets with page breaks, repeating headers, and custom headers and footers.

Course content

11 sections • 190 lectures • 18h 48m total length
  • Introduction to Excel Course1:49
  • Using Fill Series to Work Smartly5:50
  • Edit Custom List in Excel8:05
  • Data Cleaning Technique Using Text to Columns3:19
  • Smart Data Cleaning Technique Using Flash Fill2:59
  • Blank Rows Cleanup Ninja Technique2:49
  • Efficient Use of Common Keyboard Shortkeys in Excel7:35
  • Golden Shortkey to Use Complete Excel2:39
  • Intro to Project and Use of Transpose Function3:14
  • Generate Random Numbers Data to Create a Sample2:35
  • Remove Formula but keep the values in Excel2:27
  • Applying Sum Formula2:39
  • Extracting Percentage2:32
  • Freeze Multiple Rows and or Columns1:53
  • Applying First Logical Formula - Simple Use of IF2:58
  • Applying Basic Conditional Formatting in Excel2:48
  • Multiple conditions within an IF function7:03
  • Dealing With Sort and Filter Basics3:31
  • Use Rank Or Position Formula In MS Excel4:38
  • Create and Format Visually Appealing Tables in Excel2:51
  • Remove a Table in Excel Without Losing Data3:48
  • Basic and Advance Use of Format Painter2:44
  • Quickest Way to Remove All Formatting1:28
  • Effective Use of Count Count A Countblank3:02
  • Basic Use of Find and Replace in Excel1:09
  • Smartly Use Count A and Count IF3:22
  • Remove Duplicate Values From Data1:49
  • Countif With Multiple Criterias (Free Preview)2:29
  • Keyboard Shortcuts Practice With Tasks6:29
  • Use of AI In Excel Introduction4:46
  • Using Vlookup Basics5:22
  • Applying Vlookup Using Named Ranges6:08
  • How to Edit and Extend Named Ranges in Excel2:54
  • How to Extend or Expand the Named Range Automatically6:53
  • Create a Dropdown Menu in Excel Using Data Validation2:18
  • Create Custom Error Alert in Data Validation3:14
  • How to Replace NA Error in Excel with Custom Text1:59
  • Using Match Function to Extract Column Index Number7:24
  • Applying Vlookup Using Approximate Match4:35
  • Combining and Mixing of Two Formulas into One2:26
  • How to Resolve Formatting Issues in Excel2:01
  • Applying Hlookup Function with Advanced Techniques9:22
  • Vlookup to Calculate Tax on Employees Payroll3:54
  • Combining Two Lookups in a Formula4:22
  • Index Match Function9:53
  • Amazing Use of Xlookup Function10:28
  • Xlookup Advanced Functions6:27
  • Use of Xlookup With Approximate Match3:59
  • Get Multiple Answers Using Xlookup2:40
  • Using SUMIF Conditions and XLOOKUP Limitations2:03
  • Dget vs Vlookup4:11
  • Using DGET Instead of INDEX MATCH Is More Powerful4:00
  • DGET Works Even Better than XLOOKUP4:01
  • XLOOKUP Wildcard Limitations vs DGET Magic3:17
  • Limitations and Solutions of DGET6:34
  • Use of VLOOKUP in Large Data Reconciliation5:55
  • Effective Use of Hyperlinks4:09
  • Hyperlink for Data Mapping6:39
  • How to Add Hyperlinks Across Multiple Sheets in Excel3:14
  • Change Defaut Colour of Hyperlink2:35
  • Turn All Web Links into Named Hyperlinks in 1 Click1:17
  • Combine Multiple Excel Sheets in to One Part 17:22
  • Split Excel Workbook Into Multiple Files Automatically1:46
  • Combine Multiple Excel Files in a Folder Using Power Query9:24
  • How to Resolve the Expression Error: The Key Didn’t Match Any Rows12:27
  • Creating a Master Total from Multiple Sheets Using AutoSum6:45
  • Introduction to Sumif4:49
  • Smarter Use of Sumif Function1:06
  • Use of COUNTIF and AVERAGEIF Functions in Excel3:04
  • Concept of Absolute and Relative References9:11
  • Applying Two Dimensional Sum Using Sumifs12:57
  • SUMIF Using Named Ranges and Auto Creation4:32
  • SUMIFS Functions by Selecting a Range as Criteria1:32:57
  • How to Cross-Verify the Accuracy of a Formula in Excel1:18
  • Sumif Test Project4:48
  • Test Assignment Task 14:46
  • Test Assignment Task 29:51
  • Test Assignment Task 311:42
  • Concept of Auto Totalling With Subtotal4:06
  • How to Change Subtotal Criteria1:24
  • Application of Multiple Subtotals4:03
  • Comparison of Subtotals Vs Sumif Which is More4:10
  • Using Subtotal Function is Better than All Com7:40
  • Why Excel Pros Use AGGREGATE Instead of SUM or5:15
  • Advance Filters Use in Excel6:18
  • How to Copy Filtered Data to Another Sheet in Excel3:26
  • Fix Excel’s “You Can Only Copy Filtered Data to the Active Sheet” Error2:12
  • How to Apply Macros to Automate Tasks Using Advanced Filters8:24
  • How to Remove Gridlines from Entire Sheets Or2:15
  • Show the Current Date and Time Automatically in Excel2:48
  • Extract Day, Month and Year from a Date in Excel3:33
  • Combine Separate Day, Month and Year Values into a Date3:04
  • Understanding TIME, HOUR, MINUTE and SECOND Fu4:16
  • Using TRIM Function in Excel for Data Cleaning0:55
  • Excel Change Case Using UPPER , lower and Prop1:39
  • How to Use the SUBSTITUTE Function in Excel1:23
  • Use of Search Function in Excel1:33
  • Left Mid and Right Function in Excel7:03
  • Using Text Join Function1:20
  • Split Text Easily in Excel with TEXTBEFORE and TEXTAFTER7:07
  • How to Use TextSplit Function6:45
  • Calculate Age or Years of Experience7:00
  • Remove Unnecessary Blank Spaces for Data Cleaning1:46
  • Highlight an Entire Row Using Conditional Formatting5:44
  • bank book reconciliation11:52
  • Dealing With Simple IF Conditional Formulas7:19
  • Working With IF and AND Formulas in Excel6:57
  • Handling IF OR Criterias In Excel5:21
  • Combine IF, AND, and OR in a Single Formula7:44
  • Practical Application of IF With Multiple AND and OR Criteria3:48
  • Aged Debtors Analysis4:32
  • Aged Debtors Analysis Advanced Calculation21:57
  • Advanced Subtotals in Excel for Large Data Se6:50
  • Advanced Formatting Using Find and Replace4:25
  • Advanced Conditional Formatting Techniques7:35
  • Page Layout and Print Settings in Excel4:42
  • Adjust Page Breaks in Excel for Perfect Printing4:34
  • How to Repeat Header Rows on Every Page in Excel1:01
  • How to Create and Use Custom Sheet Views in Excel3:50
  • Create Custom Headers and Footers in Excel3:52
  • Print Unlimited Cheques in Excel Using a Cheque Template7:45
  • Print Unlimited Cheques in Excel by Connecting to Word8:21
  • Data Analysis Using Pivot Table Basics13:44
  • Multiple Criteria Analysis With Pivot Tables4:31
  • How to Use Show Values As in a PivotTable2:01
  • Adding Custom Fields in a PivotTable4:24
  • Use Filters and Create Multiple PivotTable Reports3:19
  • Dashboard Reporting Basics10:44
  • How to Place All Charts on a Single Dashboard6:43
  • Build Interactive Excel Dashboards Using Slicers7:30
  • Excel AI Functions for Working Smarter5:46

Requirements

  • No prior Excel experience is required. The course starts with spreadsheet fundamentals and builds toward advanced techniques.
  • Use a computer with desktop Microsoft Excel and access to the practice files. Microsoft 365 for Windows is recommended for the broadest feature coverage.

Description

This course contains the use of artificial intelligence.

Learn Microsoft Excel from the basics through advanced data analysis and reporting. Work through step-by-step demonstrations and downloadable practice workbooks so you can apply each technique to a spreadsheet of your own.

Build Excel Skills You Can Use at Work

Start with Fill Series, keyboard shortcuts, tables, sorting, filtering, and conditional formatting. Clean imported data with Flash Fill, Text to Columns, text functions, and duplicate removal. Practice relative and absolute cell references so your formulas behave as expected when you copy them.

Use IF, AND, OR, COUNTIF, SUMIF, and SUMIFS to calculate results based on business rules. Compare VLOOKUP, XLOOKUP, HLOOKUP, INDEX and MATCH, and DGET so you can choose a lookup method that fits your data. Use named ranges, data validation, and drop-down lists to make workbooks easier to maintain.

Combine files from a folder with Power Query. Use PivotTables, calculated fields, PivotCharts, and slicers to summarize data and build interactive Excel dashboards. Explore advanced filters and macros for repetitive tasks, and see how AI can help with selected Excel workflows.

Put the techniques to work on practical projects. Create a marksheet, prepare a sales and bonus report, reconcile bank book data, and analyze accounts receivable aging. Selected lessons include starter and finished files, so you can try the exercise yourself and compare your results with the demonstration.

This course is for beginners, students, accountants, finance and operations staff, and anyone who uses spreadsheets for reporting. By the end, you’ll be able to take raw data, clean and analyze it, and turn it into a report someone else can use. A recent desktop version of Microsoft Excel is recommended for newer functions such as XLOOKUP and TEXTSPLIT.

Who this course is for:

  • Beginners and students who want to learn Microsoft Excel through guided exercises and practical projects.
  • Accountants, bookkeepers, and finance staff who prepare reconciliations, aging reports, and other spreadsheet-based reports.
  • Business analysts and operations staff who clean data, combine files, and build Excel reports or dashboards.
  • Excel users who know the basics and want to work with XLOOKUP, PivotTables, Power Query, and macros.