
Advanced Excel & Analytics
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
-