Microsoft Excel-Beginner To Advanced With Data Analysis & Ai
Published 3/2025
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
What you’ll learn
Comprehensive Excel Training from A to Z: Learn from basic spreadsheet operations to advanced reporting, automation & AI-driven analytics.
Become a Lookup & Logical Functions Expert : Easily search, match, and analyze data using VLOOKUP, XLOOKUP, INDEX-MATCH, IF,AND,OR,SUMIF,COUNTIF,IFERROR ETC
Learn to Work with Big Data Using Power Tools: Easily integrate, clean, and model large datasets using Power Pivot and Power Query.
Save Hours with Macros Automation: Automate tedious tasks by recording macros and understanding VBA code of macro to improve efficiency.
Requirements
This course is designed for learners of all levels, from beginners to advanced users. However, to make the most of it, the following prerequisites are recommended.
Basic Computer Skills : Familiarity with using a computer, keyboard, and mouse and Ability to navigate files and folders in Windows or macOS.
Microsoft Excel Installed : A working version of Microsoft Excel (2016, 2019, 2021, or Microsoft 365) is required.
Willingness to Learn & Practice Excel skills improve with hands-on practice-regular application of concepts is essential for mastering the tool.
Description
Overview
Section 1: Course Introduction
Lecture 1 Course Introduction
Lecture 2 Excel Interface and All Course Resources
Lecture 3 Navigation and Selection Keyboard Shortcuts & Download Resources
Lecture 4 Functions in Excel
Lecture 5 Mathematical Functions in Excel
Lecture 6 Logical Functions in Excel
Lecture 7 Date Functions in Excel
Lecture 8 Range Vs Table
Lecture 9 Data Formatting and Number Formats in Excel
Lecture 10 Database Functions and Subtotal in Excel
Lecture 11 Relative, Absolute and Mixed Referencing in Excel
Section 3: Complex Logical and Nested Formulas in Excel
Lecture 12 IF,AND,OR,NOT & Download Resources
Lecture 13 Nested IF and IFS
Lecture 14 SUM IF and COUNT IF
Lecture 15 SUMIFS and COUNTIFS
Section 4: Data Cleaning Techniques in Excel
Lecture 16 Remove Errors and Blanks & Download Resources
Lecture 17 Remove Duplicates
Lecture 18 Dividing Data from Single Column
Lecture 19 Replace and Substitute
Lecture 20 Left,Right & Mid
Lecture 21 Concat,Find and Replace
Lecture 22 Trim & Case Change
Lecture 31 Scatter Plot
Lecture 33 Waterfall Diagram
Lecture 35 Sparklines
Section 6: Named Ranges in Excel
Lecture 36 Creating and Using Named ranges & Download Resources
Section 7: Look Up And Reference Functions In Excel
Lecture 37 VLOOK UP to Search for a Value in Column & Download Resources
Lecture 38 VLOOKUP & MATCH
Lecture 39 INDEX & MATCH for Vertical & Horizontal Look Up
Lecture 40 HLOOK UP & MATCH to search for a value in the top row
Lecture 41 XLOOK UP to Search in Range or Array
Lecture 42 Approximate Match in Look Up Functions
Section 8: Data Protection and Data Validation in Excel
Lecture 43 Encrypting File with Password & Download Resources
Lecture 44 Protecting Worksheet & Allow Edit Ranges
Lecture 45 Protecting Workbook
Lecture 46 Data Validation
Section 9: Sorting and Filtering Data
Lecture 47 Sorting and Custom Sort & Download Resources :
Lecture 48 Filtering Data and Using Advanced Filters for complex criteria
Lecture 49 Filter & Sort Functions
Section 10: Conditional Formatting and Data Consolidation
Lecture 50 Conditional Formatting using Icons ,Data Bars & Download Resources
Lecture 51 Conditional Formatting using Rules
Lecture 52 Conditional Formatting Using Formula
Lecture 53 Data Consolidation
Lecture 54 Learning Pivot Tables & Download Resources
Lecture 55 Value Field Settings in Pivot Tables
Section 12: Data Modeling using Power Pivot
Lecture 57 Introduction to Data Model & Download Resources
Lecture 58 Creating a Data Model in Power Pivot
Section 13: Data Transformation in Power Query and Excel Business Dashboard
Lecture 60 Dashboard Introduction, Data Import & Download Resources
Lecture 61 Append, Data Profiling , Remove Blanks & Errors in Power Query
Lecture 62 Remove Duplicates & Split
Lecture 63 Format & Extract in Power Query
Lecture 64 Add Columns in Power Query
Lecture 65 Merge and Joins in Power Query
Lecture 66 Fuzzy Merge, Cross Join, Pivot, Unpivot & Group by
Lecture 67 Loading Data from Power Query
Lecture 68 Power Pivot And Add To Data Model
Lecture 69 Creating Calendar Table, Relationships & Hierarchy
Lecture 70 Key Points about Dashboard
Lecture 71 Objectives, Audience and Layout of Business Dashboard
Lecture 72 (KPI) Key Performance Indicators
Lecture 76 Pivot Tables for Business Dashboard
Lecture 77 Slicers for Business Dashboard
Lecture 78 Findings and Navigation for Business Dashboard
Section 14: Revenue and Cost Dashboard
Lecture 79 Objectives and KPI’s of Revenue & Cost Dashboard
Lecture 83 Visuals Should Not Change Shape or Size with Cells
Lecture 84 Slicers for Revenue and Cost Dashboard
Lecture 85 Key Analytical Findings and Observations
Lecture 86 Design Adjustment and Navigation
Section 15: Expenses Dashboard
Lecture 87 Objectives, Audience, Layout and KPI’s of Expenses Dashboard
Lecture 89 Pivot Tables for Expenses Dashboard
Lecture 90 Slicers, Findings and Navigation for Expenses Dashboard
Lecture 91 View Settings and Protection for Dashboards
Section 16: What If Analysis
Lecture 92 Goal Seek – What-If Analysis & Download Resources
Lecture 93 Scenario – What-If Analysis
Lecture 94 Solver
Lecture 95 Data Table
Section 17: Macros for Automation and understanding VBA code of macro
Lecture 96 Recording, Running Macros & Download Resources
Lecture 97 Understanding Visual Basics Code of Recorded Macros
Section 18: AI Features in Excel
Lecture 98 Flash Fill
Lecture 99 Insert Data from Picture
Lecture 100 Analyze Data in Excel
Lecture 102 Column from Examples in Power Query
Lecture 103 Forecast
Section 19: Copilot in Excel : AI Assistant
Lecture 104 Copilot to Sort, Filter, Highlight Data in Excel & Download Resources
Lecture 105 Generate formulas in Excel with Copilot
Lecture 106 Text Insights using Copilot
Lecture 107 Data Insights using Copilot
Lecture 108 Data Visualization with Copilot in Excel
Beginners & Intermediate Excel Users : If you have little to no experience with Excel or only use basic functions, this course will help you build a strong foundation and advance to expert-level skills.,Business Professionals : Ideal for managers, executives, and business analysts who need to analyze data, create reports, and make informed decisions using Excel.,Data Analysts & Aspiring Analysts : Learn how to clean, transform, and analyze data using Power Query, Power Pivot, Pivot Tables, and AI-driven tools to gain valuable insights.,Finance & Accounting Professionals : Master essential Excel formulas, dashboards and data modeling techniques to streamline data management and reporting.,Marketing & Sales Professionals : Learn to use Excel for trend analysis, sales forecasting, customer segmentation, and automated reporting.,Human Resources (HR) Professionals : Use Excel for HR analytics, employee data tracking, performance evaluation, and payroll management with automation and dashboards.,Entrepreneurs & Small Business Owners : Leverage Excel to track expenses, manage financial data, and create business dashboards for better decision-making.,Students & Job Seekers : Gain a highly valuable skill that is essential for most office-based jobs, making your resume stand out in a competitive job market.,IT & Operations Professionals : Use Excel for data automation, process optimization, and performance tracking.
