Home └Advanced Excel & Analytics

Advanced Excel & Analytics

If you have attended our Essential Excel Series, you have already been able to master the daily professional practices of an Excel User. In this Advanced Excel and Analytics Course, we will take you to a new level of Excel application, using more complex formulas, functions, tools, charts, macros, and database tools to create new scenarios and models that could serve you well as an expert user. You will become an Excel Power User, performing complex and advanced tasks in Excel, leveling up your Excel proficiency. These are some of the most powerful tools and techniques used by Excel Professionals.

Login to Enroll
Responsible Administrator
Last Update 02/28/2023
Completion Time 4 hours 19 minutes
Members 12
  • Class Introduction
    • Advanced Excel & Analytics Introduction
    • Class Schedule and Instructions
  • Introduction to Forecasting
    • 1 Advanced Excel and Analytics Forecasting Introduction
    • 2 Advanced Excel and Analytics Moving Average
    • 3 Advanced Excel and Analytics Simple Linear Regression Part 1
    • 4 Advanced Excel and Analytics Simple Linear Regression Part -2
    • 5 Advanced Excel and Analytics Multiple Regression
    • 6 Advanced Excel and Analytics Goal Seek
    • 7 Advanced Excel and Analytics Solver
  • VBA
    • 8 Advanced Excel and Analytics VBA Course Introduction
    • 9 Advanced Excel and Analytics VBA Introduction
    • 10 Advanced Excel and Analytics Macro vs VBA
    • 11 Advanced Excel and Analytics VBA Language in Simple Terms
    • 12 Advanced Excel and Analytics VBA Syntax Examples
    • 13 Advanced Excel and Analytics What is an Object
    • 14 Advanced Excel and Analytics Objects, Collections, Hierarchy
    • 15 Advanced Excel and Analytics Objects Names vs Index
    • 16 Advanced Excel and Analytics Event Introduction
    • 17 Advanced Excel and Analytics Setting Up Developer Tab
  • VBA 2
    • 19 1 Advanced Excel and Analytics Workbook1 Intro
    • 19 2 Advanced Excel and Analytics Workbook1 Explanation
    • 19 3 Advanced Excel and Analytics Macro Absolute vs Relative Reference
    • 19 4 Advanced Excel and Analytics Recording and Running Macro
    • 19 5 Advanced Excel and Analytics Creating Button for Macro
    • 19 6 Advanced Excel and Analytics Commenting in VB Editor
    • 19 7 Advanced Excel and Analytics Saving File in xlsm Format
  • Introduction to Variables
    • 20 Advanced Excel and Analytics Introduction to Variables
    • 21 Advanced Excel P1 1
    • 22 Advanced Excel P1 2
    • 23 Advanced Excel P1 3
    • 24 Advanced Excel P1 4
    • 25 Advanced Excel P1 5
    • 26 Advanced Excel P1 6
    • 27 Advanced Excel P1 7
    • 28 Advanced Excel P1 8
    • 29 Advanced Excel P1 9
    • 30 Data Table Case with Conditional Formatting
    • 31 Data Table Case
    • 32 Goal Seek Function
    • 33 One Variable Data Table
    • 34 Two Variable Data Table
  • Teaching Materials
    • Workbook7_Forecasting (Exercise)
    • Workbook1_Macro Recorder
    • User Form Workbook