All you wanted to know about Self-Service Dashboards in Exce
4.3 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
504 students enrolled
Wishlisted Wishlist

Please confirm that you want to add All you wanted to know about Self-Service Dashboards in Exce to your Wishlist.

Add to Wishlist

All you wanted to know about Self-Service Dashboards in Exce

Smart techniques and new capabilities to develop instant Dashboards of MS Excel
4.3 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
504 students enrolled
Created by GreyCampus Inc.
Last updated 1/2016
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 2 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Some knowledge of basic word processing, computing, and spreadsheets
  • Familiarity with the Microsoft Office work environment
Description

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.

Who is the target audience?
  • This course focuses on the self-service approach to BI.
  • To learn the tools and applications that allow business managers to create personalized reports and analytical queries.
  • Focus will be given to standard reporting tools, advanced spreadsheet and dash board.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
12 Lectures
01:49:04
+
Course Introduction
1 Lecture 02:38
+
Creating Pivot Tables using complex datasets
1 Lecture 16:43
+
Generating Pivot Charts Instantly
1 Lecture 15:26
+
Implementing Slicers to build Interactive dashboards
1 Lecture 15:05
Implementing Slicers to build Interactive dashboards
15:05
+
Grouping and Sub Total of Data in Pivots
1 Lecture 09:42
Grouping and Sub Total of Data in Pivots
09:42
+
Beautifying reports / tables using Sparklines
1 Lecture 10:03
Beautifying reports / tables using Sparklines
10:03
+
Designing Aged Reports and understanding data bucketing concepts
2 Lectures 19:45
Designing Aged Reports and understanding data bucketing concepts Part 1
10:13

Designing Aged Reports and understanding data bucketing concepts Part 2
09:32
+
Reducing speculation with What-If-Analysis - Goal Seek, Data Table, Scenario Man
1 Lecture 13:46
Reducing speculation with What-If-Analysis - Goal Seek, Data Table, Scenario Man
13:46
+
Quick Analysis Tools - for Charts, Tables, Formatting etc. (Excel 2013)
1 Lecture 05:51
Quick Analysis Tools - for Charts, Tables, Formatting etc. (Excel 2013)
05:51
+
Additional Material
1 Lecture 00:02
Additional Material
00:02
2 More Sections
About the Instructor
GreyCampus Inc.
3.9 Average rating
2,196 Reviews
26,735 Students
53 Courses
Professional Certification and Competitive Exam Trainings

GreyCampus is a leading provider of certification training solutions for professionals globally. We offer a personalized, interactive and engaging learning experience for professionals across sectors to help them clear the certification exams of their choice quickly and easily.

Our online learning portal uses a highly advanced, analytics-driven technology platform to deliver courses that are highly personalized, adapt to your learning needs and constantly provide feedback to help you achieve your objectives. Each eLearning program is independently hosted on a Cloud platform that guarantees 99.99% availability anywhere in the world 24×7.