Microsoft Excel 2013 Dashboard is a page in Excel that contains information and data in forms of charts, tables and views to help higher officials in an organisation to track key KPIs or metrics. It has evolved into a crucial technique to make decisions in the business world and hence, could be a great way to progress in your career if you excel in creating mind-blowing dashboards in the spreadsheet application. If you came here wanting to learn dashboard designing to spruce up your skills, this course has got you all covered.
This video course will first off by exploring the features and constraints in Excel to consider it in your dashboard designing process. You will then be taught on how to connect to MS Access, MS SQL server and PowerPivot to import the data stored in them to the Excel dashboard. How to use relationships and hierarchies to use data from various sources in your dashboard and to knit them together will also be further discussed in this course, followed by guidelines on how to implement the KPIs to track if the business has achieved its goals and objectives.
You will then move onto work with PivotTables and PivotCharts to present the imported data in Excel, along with an insight into the techniques and methods used to style the data in Excel dashboard to make it more appealing. The subsequent modules will educate you on how to implement slicers, timeline slicers and hyperlinks to improve the dashboard interactivity and on how to create drill-downs, filters, tiles and multiples using Power View. You will also be walked through how to publish your dashboard in Microsoft SkyDrive and Office 365 SharePoint to use it in the decision making process. By the end of this course, you will have a well-grounded knowledge in dashboard designing to make significant progress in your career.
Global Edulink offers the most convenient path to gain recognised skills and training that will give you the opportunity to put into practice your knowledge and expertise in an IT or corporate environment. You can study at your own pace at Global Edulink and you will be provided with all the necessary material, tutorials, qualified course instructor, narrated e-learning modules and free resources which include Free CV writing pack, free career support and course demo to make your learning experience more enriching and rewarding.
The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course. The course is self-paced and you can complete it in stages, revisiting the lectures at any time.
This course might interest individuals looking to improve their knowledge on Excel to make progress in their career
The course is assessed online with a final, multiple-choice test, which is marked automatically. You will know instantly whether you have passed the course.
This certificate will enhance your qualifications for a number of jobs across various industries. You can also use this certificate as a means to demand for salary increments or job promotions from your employer or to study further in the area. Below mentioned are some of the jobs this certificate will help you in, along with the average UK salary per annum according to https://www.payscale.com/career-path-planner,
Section 1: Dashboard Outputs and Inputs | |||
1.1. Beginning with the End in Mind | 00:00:00 | ||
1.2. Empowering your Audience | 00:00:00 | ||
1.3. Connecting to MS Access | 00:00:00 | ||
1.4. Connecting to MS SQL Server | 00:00:00 | ||
1.5. Using data in your Excel Sheet | 00:00:00 | ||
Section 2: Implementing PowerPivot | |||
2.1. Importing Data into PowerPivot | 00:00:00 | ||
2.2. Adding Data from Excel to PowerPivot | 00:00:00 | ||
2.3. PowerPivot Relationships and Hierarchy | 00:00:00 | ||
2.4. Creating Calculated Fields | 00:00:00 | ||
2.5. Implementing KPIs | 00:00:00 | ||
Section 3: Working With PivotTables | |||
3.1. Constructing PivotTables (part 1) | 00:00:00 | ||
3.2. Constructing PivotTables (part 2) | 00:00:00 | ||
3.3. PivotTable Formatting and Options | 00:00:00 | ||
3.4. PivotTable Design and Layout | 00:00:00 | ||
3.5. Adding a Calculated Field and KPI | 00:00:00 | ||
Section 4: Constructing Your Framework | |||
4.1. Creating a PivotChart | 00:00:00 | ||
4.2. Customizing a PivotChart | 00:00:00 | ||
4.3. Creating a Combo Chart | 00:00:00 | ||
4.4. Customizing a Combo Chart | 00:00:00 | ||
4.5. Creating Text-highlight Cells | 00:00:00 | ||
Section 5: Stylizing Your Data | |||
5.1. Formatting the Dashboard Sheet | 00:00:00 | ||
5.2. Referencing a PivotTable | 00:00:00 | ||
5.3. Conditional Formatting | 00:00:00 | ||
5.4. Implementing Sparklines | 00:00:00 | ||
5.5. Enhancing Sparklines Using Named Ranges | 00:00:00 | ||
Section 6: Adding Interactivity | |||
6.1. Implementing Slicers | 00:00:00 | ||
6.2. Customizing Slicers | 00:00:00 | ||
6.3. Employing Timelines | 00:00:00 | ||
6.4. Utilizing Hyperlinks | 00:00:00 | ||
Section 7: Utilizing Power View | |||
7.1. Creating a Power View | 00:00:00 | ||
7.2. Adding Drill-downs in Power View | 00:00:00 | ||
7.3. Using Filters in Power View | 00:00:00 | ||
7.4. Implementing Tiles in Power View | 00:00:00 | ||
7.5. Visualizing Multiples in Power View | 00:00:00 | ||
Section 8: Publishing Your Dashboard | |||
8.1. Cleaning Up and Locking Down | 00:00:00 | ||
8.2. Backwards Compatibility and SharePoint Distribution | 00:00:00 | ||
8.3. Sharing on Microsoft SkyDrive | 00:00:00 | ||
8.4. Publishing on Office 365 SharePoint | 00:00:00 | ||
8.5. Printing and Exporting to PDF | 00:00:00 | ||
Mock Exam | |||
Mock Exam : Microsoft Excel 2013 Dashboard Design | 00:40:00 | ||
Exam | |||
Exam : Microsoft Excel 2013 Dashboard Design | 00:40:00 | ||
Certificate Download Guide | |||
Certificate Download Guide | 00:03:00 |
No Reviews found for this course.