Course curriculum
-
1
Welcome to the course!
-
A message from your trainer
FREE PREVIEW -
Course Road Map
FREE PREVIEW -
Download Complete Course Book, Materials, and Exercises
-
-
2
COMPETENCY 1: MASSAGING DATA
-
3
Consolidation
-
Download Consolidation Workshop
-
Consolidation: Demonstration
FREE PREVIEW -
Consolidation: Technical
-
-
4
Data Validation
-
Data Validation: What is Data Validation
-
Download Data Validation Workshop(s)
-
Data Validation: Demonstration - Whole Number
-
Data Validation: Demonstration - List
-
Data Validation: Demonstration - Date
-
Data Validation: Demonstration - Text Length
-
Data Validation: Demonstration - Custom
-
-
5
Table Tools - Ctrl T
-
Download Ctrl T Workshop(s)
-
Ctrl T (Table Design): Demonstration of Functionality
-
Ctrl T (Table Design): Demonstration of Technical Part 1
-
Ctrl T (Table Design): Demonstration of Technical Part 2
-
-
6
Naming Cells & Ranges
-
Download Naming Cells & Ranges Workshop(s)
-
Naming Cells & Ranges: Demonstration
-
-
7
Surgeon Functions
-
Download Surgeon Functions Workshop(s)
-
Surgeon Functions: Explaining the Concept
-
-
8
Date Analysis
-
Download Date Functions Workshop(s)
-
Date Functions: Demonstration
-
-
9
Vlookup
-
Download VLookup Workshop(s)
-
Vlookup: Date Demonstration
-
Vlookup: Bank Account Demonstration
-
Vlookup: Corporate Sales Demonstration
-
-
10
Select, Shift, Select
-
Download Select-Shift-Select Workshop(s)
-
Select Shift Select: Explaining the Concept
-
-
11
Subtotal
-
Download Subtotal Workshop(s)
-
Subtotal: Explaining the Concept
-
-
12
Text Change Functions
-
Download Text Change Case Workshop(s)
-
Text Change Functions: Explaining the Concept
-
-
13
Text-To-Columns
-
Download Text-To-Columns Workshop(s)
-
Text-To-Columns: Explaining the Concept
-
-
14
Conditional Formatting
-
Download Conditional Formatting Workshop(s)
-
Conditional Formatting: Explaining the Concept
-
-
15
What is Next!
-
Congratulation: Completing Data Massaging
-
-
16
COMPETENCY 2: REPORTING, ANALYSIS, & DASHBOARDING
-
Explaining: Reporting, Analysis, & Dashboarding
FREE PREVIEW -
The 19 Rules of Pivot Tables
FREE PREVIEW -
Download Pivot Table Rules 1 -12
-
Rule 1: Creating Pivot Tables
FREE PREVIEW -
Rule 2: Number Formatting
-
Rule 3: Design Report Layout
-
Rule 4: Sorting in Pivot Tables
-
Rule 5: Filtering in Pivot Tables
-
Rule 6: Drill-down in Pivot Tables
-
Rule 7: Data Analysis Type 1 - Summarize Value by
-
Rule 8: Data Analysis Type 2 - Show Values As
-
Rule 9: Data Analysis Type 3 - Inserting Formulas
-
Rule 10: Date Analysis & Grouping
-
Rule 11: Show Report Filter Pages
-
Rule 12: Copying Pivot Tables
-
Review Workshop - Pivot Tables 1
-
Rule 13: Pivot Charts
-
Rule 14: Dynamic Chart Labeling
-
Rule 15: Linking Pivot Tables with Power Points
-
Rule 16: Pivot Table Options
-
Rule 17: Conditional Formatting in Pivot Tables
-
Rule 18: GetPivotData
-
Rule 19: The Magical Slicer
-
Review Workshop - Pivot Tables 2
-
Rule Dashboard: Creating an Excel-Based Dashboard
-
Congratulations: Completing Pivot Reporting, Analysis, and Dashboards
-
-
17
Course Evaluation
-
Course Evaluation تقييم الدورة
-
-
18
Final Assessement
-
Data Analysis Final Exam
-
Instructor(s)
