MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2 Hours | Lec: 12 | 831 MB
Genre: eLearning | Language: English
Smart techniques and new capabilities to develop instant Dashboards of MS Excel
This course takes a profound look at the new capabilities of MS Excel to develop instant Dashboards. These smart techniques will allow you to design self-service dashboards in minutes. The topics covered in this course primarily focuses on Analysis proficiencies.
At the end of the course, participants would learn/use/acquire the following techniques/knowledge:
Generate Pivot tables and charts to explore data sets
Implement slicers to develop instant dashboards
Appreciate the use of Sparklines to in-cell histograms
Reduce data speculation by using Excel’s data Analysis capabilities
This course is designed for Excel users, project managers, and decision makers who want to fill the gap between an Excel spreadsheet and a complete business intelligence solution. Leveraging Power Bi from Microsoft, candidates will learn how to pull data into an Excel spreadsheet from a multitude of sources, how to format and prepare that data prior to loading into an analytical model, and how to create visualizations and dashboards upon that data.