Home Search Profile
TrainingHub TrainingHub

Ultimate Excel Mastery 2025: From Basics to Advanced AI Tools

Focused View

5:37:58

  • 1 -E1.pdf
  • 1 -E1.1 How to Launch MS Excel.mp4
    03:06
  • 2 -E1.pdf
  • 2 -E1.2 Start Screen - Back Stage Screen - Navigating MS Excel.mp4
    04:29
  • 3 -E1.pdf
  • 3 -E1.3 User Interface - Navigating MS Excel Workbook Screen.mp4
    08:04
  • 4 -E1.xlsx
  • 4 -E1.4 Home Tab - Basic Editing Tools.mp4
    11:25
  • 5 -E1.xlsx
  • 5 -E1.5 Copy and Paste I using Multiple Tools in MS Excel.mp4
    11:46
  • 1 -E2.1 Customize Ribbon Bar Tabs, Groups, Commands I Tools.mp4
    04:56
  • 2 -E2.xlsx
  • 2 -E2.2 Text to Column Multiple methods.mp4
    07:26
  • 3 -E2.xlsx
  • 3 -E2.3 Speak Cells Data Reading Tool.mp4
    04:00
  • 4 -E2.xlsx
  • 4 -E2.4 Comments - Add, Edit, Delete, Copy Paste, Background change.mp4
    08:23
  • 5 -E2.xlsx
  • 5 -E2.5 Filters in MS Excel.mp4
    04:24
  • 6 -E2.xlsx
  • 6 -E2.6 Freeze Panes and Split Window.mp4
    04:41
  • 1 -E3.xlsx
  • 1 -E3.1 Fill Series - Basics.mp4
    03:28
  • 2 -E3.xlsx
  • 2 -E3.2 Fill Series - Advanced.mp4
    07:37
  • 3 -E3.xlsx
  • 3 -E3.3 Fill Series - Flash Fill.mp4
    05:26
  • 4 -E3.xlsx
  • 4 -E3.4 Conditional Formatting.mp4
    04:09
  • 5 -E3.xlsx
  • 5 -E3.5 Hyperlinks to Sheets, Web pages, Files.mp4
    09:01
  • 6 -E3.6 Header and Footer Settings.mp4
    08:26
  • 7 -E3.xlsx
  • 7 -E3.7 Printing and Paper Settings.mp4
    05:50
  • 8 -E3.xlsx
  • 8 -E3.8 Import Data from Web.mp4
    05:47
  • 9 -E3.txt
  • 9 -E3.xlsx
  • 9 -E3.9 Import Data from Text File with Auto Refresh.mp4
    03:09
  • 10 -E3.xlsx
  • 10 -E3.10 Import Objects into Excel.mp4
    08:04
  • 1 -E4.xlsx
  • 1 -E4.1 Characteristics of a cell.mp4
    01:46
  • 2 -E4.xlsx
  • 2 -E4.2 Cell References Relative Ref, Absolute Ref, Mixed Ref.mp4
    13:59
  • 3 -E4.xlsx
  • 3 -E4.3 Custom View.mp4
    04:02
  • 4 -E4.4 Sheet protection.mp4
    05:38
  • 5 -E4.5 Cell Protection.mp4
    04:49
  • 6 -E4.xlsx
  • 6 -E4.6 Compare sheets side by side I View Sheets side by side.mp4
    05:15
  • 7 -E4.7 Compare sheets from Multiple Files.mp4
    02:38
  • 8 -E4.xlsx
  • 8 -E4.8 Working with cells, rows, columns, Specific Size, Auto Fit.mp4
    09:28
  • 9 -E4.xlsx
  • 9 -E4.9 Working with sheets rename, colour, copy, move, grouping.mp4
    07:08
  • 1 -E5.pdf
  • 1 -E5.1 Things to remember before starting formulas.mp4
    09:42
  • 2 -E5.pdf
  • 2 -E5.xlsx
  • 2 -E5.2 SUM.mp4
    08:52
  • 3 -E5.xlsx
  • 3 -E5.3 SUMIF.mp4
    05:52
  • 4 -E5.xlsx
  • 4 -E5.4 SUMIFS.mp4
    08:44
  • 5 -E5.xlsx
  • 5 -E5.5 SUBTOTAL.mp4
    04:44
  • 6 -E5.xlsx
  • 6 -E5.6 AGGREGATE.mp4
    03:08
  • 7 -E5.xlsx
  • 7 -E5.7 SUMPRODUCT.mp4
    03:54
  • 8 -E5.xlsx
  • 8 -E5.8 SUMSQ.mp4
    03:25
  • 9 -E5.xlsx
  • 9 -E5.9 SUMX2MY2, SUMX2PY2, SUMXMY2 I Maths and Trigonometry.mp4
    08:06
  • 10 -E5.xlsx
  • 10 -E5.10 DSUM - DATA BASE SUM.mp4
    04:07
  • 11 -E5.xlsx
  • 11 -E5.11 IMSUM vs IMSUB Complex Data Calculations.mp4
    03:31
  • 1 -E6.xlsx
  • 1 -E6.1 AVERAGE.mp4
    01:24
  • 2 -E6.xlsx
  • 2 -E6.2 AVERAGEA.mp4
    02:43
  • 3 -E6.xlsx
  • 3 -E6.3 AVERAGEIF vs AVERAGEIFS.mp4
    05:29
  • 4 -E6.txt
  • 4 -E6.xlsx
  • 4 -E6.4 Weighted Average with VBA Code.mp4
    04:20
  • 1 -E7.xlsx
  • 1 -E7.1 COUNT, COUNTA, COUNTBLANK.mp4
    03:05
  • 2 -E7.xlsx
  • 2 -E7.2 COUNTIF vs COUNTIFS.mp4
    04:59
  • 1 -E8.xlsx
  • 1 -E8.1 LOGICAL TEST with Comparative Operators.mp4
    03:40
  • 2 -E8.xlsx
  • 2 -E8.2 IF.mp4
    06:03
  • 3 -E8.xlsx
  • 3 -E8.3 IF AND vs IF OR.mp4
    05:04
  • 4 -E8.xlsx
  • 4 -E8.4 IFS vs NESTEDIF.mp4
    07:18
  • 5 -E8.xlsx
  • 5 -E8.5 IFERROR.mp4
    03:37
  • 6 -E8.xlsx
  • 6 -E8.6 SWITCH.mp4
    05:27
  • 1 -E9.xlsx
  • 1 -E9.1 LEFT, RIGHT, MID and LEN.mp4
    04:46
  • 2 -E9.xlsx
  • 2 -E9.2 FIND vs SEARCH.mp4
    02:14
  • 3 -E9.xlsx
  • 3 -E9.3 REPLACE vs SUBSTITUTE.mp4
    05:24
  • 1 -E10.xlsx
  • 1 -E10.1 CONCAT vs CONCATENATE.mp4
    02:14
  • 2 -E10.xlsx
  • 2 -E10.2 TEXT.mp4
    09:07
  • 3 -E10.xlsx
  • 3 -E10.3 UPPER, LOWER, PROPER.mp4
    01:09
  • 4 -E10.xlsx
  • 4 -E10.4 TRIM.mp4
    01:04
  • 5 -E10.txt
  • 5 -E10.xlsx
  • 5 -E10.5 SPELLNUMBER with VBA code.mp4
    04:11
  • 6 -E10.txt
  • 6 -E10.6 TEXT-TO-NUMBER with VBA code.mp4
    02:15

    • More details

    Course Overview

    This comprehensive Excel course takes you from beginner to advanced level, covering everything from basic functions to AI-powered automation, VBA macros, and professional dashboard creation for powerful data analysis.

    What You'll Learn

    • Master 50+ essential Excel functions including SUMIFS, VLOOKUP, and advanced text manipulation
    • Automate workflows using VBA macros and integrate ChatGPT/AI tools for efficiency
    • Create dynamic dashboards and implement professional data visualization techniques

    Who This Is For

    • Beginners seeking solid Excel foundations
    • Professionals aiming to boost productivity
    • Business owners managing operations/data

    Key Benefits

    • 20+ hours of hands-on training with practical exercises
    • Learn industry-relevant skills for today's job market
    • Includes AI integration and automation techniques

    Curriculum Highlights

    1. Excel fundamentals & interface mastery
    2. Advanced formulas & data analysis
    3. Automation with VBA & AI tools