Data Analysis & Business Reporting Techniques Using Excel - Level 2
This course is Excel-based allowing you to develop an exclusive level of expertise and adding immediate value to your job
Course curriculum
-
1
Welcome to the course!
-
A message from your Trainer
FREE PREVIEW -
Download Complete Course Exercises
-
-
2
COMPETENCY 3: BUSINESS MODELING
-
Explaining Business Modeling
-
-
3
Spinner
-
Spinner: Demonstration
-
Spinner: Whole Number
-
Spinner: Whole Number above 30,000 units
-
Spinner: Percentage
-
Spinner: Text
-
Spinner Review Workshop
-
-
4
Scenario Manager
-
Scenario Manager: Demonstration
-
Scenario Manager: Demonstration using Pivot Tables
-
Scenario Manager Review Workshop
-
-
5
Goal Seek
-
Goal Seek: Demonstration
-
Goal Seek Review Workshop
-
-
6
Data Tables
-
Data Tables: Demonstration
-
Data Tables Review Workshop
-
-
7
List Box Data Model
-
List Box: Demonstration
-
List Box Review Workshop
-
-
8
Check Box Data Model | IF Statement
-
Check Box Data Model: Demonstration
-
Check Box Data Model Review Workshop
-
-
9
Option Button Data Model
-
Option Button: Demonstration
-
Option Button Review Workshop
-
-
10
Next steps
-
Congrats on Finishing Business Modeling!
-
-
11
COMPETENCY FOUR: DATA INTEGRATION
-
Explaining Data Integration
-
Connecting Excel to .CSV or .TXT Files: Demonstration
-
Connecting Excel a Database: Demonstration
-
Connecting Excel to Web: Demonstration
-
Connecting Excel to Excel: Demonstration
-
Integration Review Workshops
-
Congrats on Finishing Integration!
-
-
12
COMPETENCY FIVE: AUTOMATION / MACRO / VBA
-
Explaining Automation
-
First Things First!
-
Automation Control Board: Demonstration
-
Planning a Macro: Demonstration
-
Recording and Testing a Macro: Demonstration
-
Editing a Macro
-
Macro Workshop
-
-
13
Assessment
-
Data Level 2 Final Exam
-
-
14
Course Survey
-
Course Evaluation تقييم الدورة
-
-
15
Congratulations!
-
Congrats! You have completed Data Analysis & Business Reporting Using Excel - Level 2
-