Excel Data Analysis
This course is a comprehensive overview of what effective business analysts really do - their strategies, techniques, tools and methods – all which apply to any process whether it’s a traditional large project, and Agile or DevOps project.
1
Segment - 01 - Introduction to the course
Segment - 02 - Introduction of the Instructor
Segment - 03 - Course Requirements
Segment - 04 - How to get Excel
2
Segment - 05 - What will we learn in this section?
Segment - 06 - What are Dashboards?
Segment - 07 - Answers you need before you start a dashboard
Segment - 08 - Best Practices for Dashboard Layout
Segment - 09 - Best Practices for Dashboard Colors
Segment - 10 - Section Summary
3
Segment - 11 - What will we learn in this section?
Segment - 12 - Build a Wireframe in Excel
Segment - 13 - Prepare Raw Data for Dashboard
Segment - 14 - Prepare Calculation Sheet
Segment - 15 - Section Summary
4
Segment - 16 - What will we learn in this section?
Segment - 17 - Build a Combo Box
Segment - 18 - Complex Lookup
Segment - 19 - Build a Scrolling Data Table
Segment - 20 - Conditionally Format Actual Values vs Budgeted Values
Segment - 21 - Conditional Headers
Segment - 22 - Section Summary
5
Segment - 23 - What will we learn in this section?
Segment - 24 - Show top matches over and under budget
Segment - 25 - List box to select indicators
Segment - 26 - Toggle between Top Over or Under
Segment - 27 - Section Summary
6
Segment - 28 - What will we learn in this section?
Segment - 29 - Prepare Data for Scrolling Chart
Segment - 30 - Scrollable Line Chart
Segment - 31 - Remove Crashing Lines
Segment - 32 - Toggle Visibility of Line Series
Segment - 33 - Finetune the Line Series
Segment - 34 - Section Summary
7
Segment - 35 - What will we learn in this section?
Segment - 36 - Column Chart Controlled by Slicer
Segment - 37 - Pivot Slicer Sorting
Segment - 38 - Select Only 1 Slicer
Segment - 39 - Dynamic Comments with Slicer
Segment - 40 - Section Summary
8
Segment - 41 - What will we learn in this section?
Segment - 42 - Add Calculations for Variances in Pivot Tables
Segment - 43 - Conditional Formatting in Pivot Tables
Segment - 44 - Refresh Pivot Table with Easy VBA
Segment - 45 - Section Summary
9
Segment - 46 - Course Summary and Next Steps