Excel Module 1 - Analysis and Dashboards

By the end of this course you'll be an ABSOLUTE EXCEL MASTER You'll have Excel doing your work for you

Course curriculum

1. 1.- Intro to Course
2. 2.- About the Exams
3. 3.- Support
1. Why the shortcuts?
2. English keyboard shortcuts
3. Intertask
4. Task1
5. Task2
6. Task3and4
1. 1.- Formulas
2. 2.- Operators
3. 3.- References
1. 1.- Vacation Days
2. 2.- Commision Payments
3. 3.- Package Pricing
4. 4.- Exchange Rates
5. 5.- Areas
1. Tips Tricks
1. 1.- Highlight cells rules
2. 2.-Color Sacles
3. 3.- Unique Values
4. 4.-TopBottomRules
5. 5.-AboveBelowAverage
6. 6.-FullLinesPainting
7. 7.-Challenge
1. 1.- Intro
2. 2.-Normalized Table
3. 3.-Excel Tables
4. 4.- Pivot Tables Getting Started
5. 5.-Tips by Waiter
6. 6.- Waiter Analyisis
7. 7.- Customer Analysis
8. 8.- Conclusions
1. 1.-Intro to Charts
2. 2.-Tables v charts
3. 3.- Replace that Pie Chart
4. 4.- Line Charts
5. 5.- Bar Charts on your Own
1. 1.- Introduction
2. 2.- Total Sales
3. 3.- Costs and Income
4. 4.- Charts
5. 5.- Top 10 Table
6. 6.- Slicers
1. 1.- Intro
2. 2.- Cleaning up the table
3. 3.- Normalizing the Table
4. Analysis
5. Dashboard
6. Extracting Useful Data
7. Raise Calculations
8. Severance Calculation
1. 1 Intro to Case Study
2. 2 Normalizing the Table
3. 3 Analysis
4. 4 Doc Analysis
5. 5 Dashboard
6. 6 Dashboard 2
1. 1.-Intro to Case Study
2. 2.- Table Cleanup
3. 3.- First Look
4. 4.- Reading the Docs
5. 5.-Analysis
6. 6.- Dashboard
7. 7.- Bridge
8. 8.- Bridge by Projects
1. Congratulations! You have completed your Yellow Belt

Enroll today