If you are new to Excel dashboards or data analysis or want to fill in some gaps in your knowledge, THIS is the course for you. We’ve focused on providing you with the fundamentals you need to work with Excel effectively! Don’t sit through days of boring training to understand how to create powerful interactive dashboards that work! This course will get you up to speed and working in half the time, giving you the crucial foundation to start you on the journey to becoming an Excel dashboard and data analysis expert! This course has been updated for 2022 in full HD video quality, so you will learn on the latest Excel interface. Students who have taken this course have this to say:“I thought i know Pivot tables, report and dashboards, but i was shocked to see one can do so much in reports, pivot tables and dashboards. Thanks Ian For this amazing course. I am glad i found it. Thanks once again. “Im really excited to use this tools, all the information was very clear and easy to understand, thank you!“Nice pace. Instructor knew the material and delivered it in a clear and understandable way"A very well structured course, taking the student from A to Z of Pivot tables, theory and practical aspects of Interactive Dashboards. A must for a foundation for other data analysis courses” Lifetime access to course materials and practice activities. This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 200 000 enrollments & 150 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5. Excel is the most commonly used data analysis tools available on the market today. In this course we show you how to create POWERFUL INTERACTIVE dashboards in minutes using standard Excel tools and techniques. (No coding or complicated methods required!)We also discuss how to create and use BEST PRACTICE for your dashboards. How to configure a dashboardWhat graphs you should use to display what types of dataWhat questions you should ask of the dataWhat methods of analysis you can use in the dataIn this course we answer these questions and more! We GUARANTEEthat you will be able to EASILY createinteractive dashboards and understand the most powerful methods of data analysis. In the course you will learn the following key outcomes: How to STRUCTURE your data for dashboards and data analysisCreate PIVOT TABLES to easily summarize and aggregate your dataUse Excel SLICERSto create filter tables and graphsCreate INTERACTIVEdashboards combining Key Metrics, Trend Graphs, Top 10 reports, Comparisons, Pie graphs and moreUnderstand how to EASILY create time / trend analysis using a few clicks of themouseFilter data and create Top 10 analysisLearn how to do comparison, trend, ranking, contribution, variance, frequency and pareto analysisCreate a Sales, Human Resource and Finance dashboardUse Conditional Formatting to highlight key data and trendsThis course will teach you the best practices and principles for dashboard design and creating graphs. In addition you will learn the following forms of data analysis: Comparison AnalysisTrend AnalysisRanking AnalysisContribution AnalysisVariance AnalysisPareto Analysis
