Enquire Now
Menu

Microsoft Excel 2013 Dashboard Design

0( 0 REVIEWS )
130 STUDENTS
Add To Cart
£199 £49 (inc. VAT)
Buy Now
  • 365 Days
  • Course Certificate
  • ACCREDITED BY CPD & iAP
  • 03Guided Learning Hours
  • Course Material
  • 08 Number of Modules
  • Exam Included

Overview

Microsoft Excel 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.

Why study at Global Edulink?

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.

 

  • Access Duration 
  • Who is this course aimed at?
  • Entry Requirements
  • Method Of Assessment
  • Certification
  • Career Path
  • Other benefits

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

  • Learners must be age 16 or over and should have basic understanding of the English Language, numeracy, literacy and ICT.
  • A working knowledge on Excel is required to follow up on this course

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.

Those who pass this test will get a certificate in Microsoft Excel 2013 Dashboard Design

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,

  • Business Analyst – £30,407 per annum
  • Financial Analyst – £31,090 per annum
  • Data Analyst – £25,972 per annum
  • Strategic Planning Manager – £48,006 per annum
  • Business Consultant – £37,658 per annum
  • High-quality e-learning study materials and mock exams.
  • Tutorials/materials from the industry leading experts.
  • 24/7 Access to the Learning Portal.
  • The benefit of applying for TOTUM extra Discount Card.
  • Recognised Accredited Qualification.
  • Excellent customer service and administrative support

Course Curriculum

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

Students feedback

N.A

Avarage rating ()
5 Star
4 Star
3 Star
2 Star
1 Star

No Reviews found for this course.

Add To Cart
£199 £49 (inc. VAT)
Buy Now
  • 365 Days
  • Course Certificate
  • ACCREDITED BY CPD & iAP
  • 03Guided Learning Hours
  • Course Material
  • 08 Number of Modules
  • Exam Included
WhatsApp chat