Home └Advanced Excel & Analytics

Advanced Excel & Analytics

Login to Enroll
Responsible Administrator
Last Update 02/28/2023
Completion Time 4 hours 19 minutes
Members 11
  • 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