Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
An Excel Dashboard provides insight, analysis and alerts. They’re fully interactive and dynamic and can help with project management, customer service, retail management, financial forecasting and much more.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
|Section 2: Navigation & Shortcuts Within Excel|
Navigation Shortcuts - p1
Search Functions ( Lookups, Match, Index)
Arrays ( Rows , Columns , Transpose, Frequency)
Pivot Table & SlicerPreview
Forms and Controls
|Section 3: Dashboards|
Introduction to DashboardPreview
Process of Creating a DashboardPreview
Creating Dashboard KPI Part 1
Creating Dashboard KPI Part 2
Creating Dashboard KPI Part 3
Creating Dashboard KPI Example 2 Part 1
Creating Dashboard KPI Example 2 Part 2
Creating Dashboard KPI Example 2 Part 3
Sample of some Good DashboardsPreview
|Section 4: Conclusion|
I have a degree of Masters in Computer science and currently work as a Planning manager in the field of Logistics for a $10+ billion dollar company.
I have number of years of experience working with Directors and Vice Presidents of companies presenting them alternate solutions to optimize their supply chain network.
I also own a consulting firm Aarya Global Services currently providing consulting services for supply chain network planning and Optimization to various companies.