Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Excel Dashboard - Next level of Excel Reporting (one on one)

No Reviews Yet

Course type: Online Instructor led Course

Platform: Skype

Course ID: 9159

Course type: Online Instructor led Course

Platform: Skype

Students Interested 0 (Seats Left 0)

No Reviews Yet

About the Course

Excel Dashboards are the new buzzword employers are looking for.

If you want a career that involves creating reports in Excel, then you need to know how to create impressive, interactive, and easy to read Dashboards

This course will get your skills up to date by teaching you how to create Dashboards that will wow your boss (or your prospective employer) even if you don’t have an artistic bone in your body.

Topics Covered

So, what is an Excel Dashboard?

An Excel Dashboard is simply a report like the one above that:

Usually fits on one page
Displays key trends, comparisons and data graphically or in small tables
Provides the reader with conclusions to their objective
Is often interactive allowing the user to filter data and switch views themselves
Employs best practices that enable the report to be updated quickly and easily (often at the click of just one button)

Dashboards can be complex or simple, fancy or plain. They can contain financial or non-financial data, or both. They can work with any data in any organization.

This comprehensive Excel Dashboard Course will teach you the simple techniques you can apply in Excel to make killer dashboards that will set your skill level apart from the crowd.

Who should attend

The course is for you if you:

Want to change career or apply for a new job;
Already prepare reports of any kind that require updating with new data on a regular basis (weekly, monthly….) and, or;
Work with charts and, or;
Work with large volumes of data and, or;
Import data into Excel from another source e.g. another database, Access, Web, Text files etc. and, or;
Often don’t know the best chart to use to display your data.

Pre-requisites

This course is not for complete beginners but if you’ve put together any type of report in Excel before then you will definitely benefit from the time saving tips and data visualization techniques I share with you.

What you need to bring

Offline - Your Laptop
Online - Your Laptop / High speed Broadband Internet

Key Takeaways

In the course I teach you how to build Excel Dashboard reports from the ground up.

By applying the simple rules I share with you, you will have the skills to be able to create reports that save loads of time (allowing you to go home early :) ) and you’ll quickly become known as a Dashboard Superhero with reports that are:

Quick and easy to update, in fact they can update themselves (imagine being able to confidently say that in an interview) by pulling in data direct from your external database, Microsoft Access, the web etc. at the click of a button if you set them up right (I show you how).

Fully interactive so the reader can change the view themselves; they can filter by product, time period or any parameter you choose, they can show and hide data using check boxes, drop down lists, and option buttons to name a few.

Easy to read and interpret; plus I share with you a heat map of your page that shows you where your most important data should go and where will get the least attention.

Exactly what the reader wants; I teach you the 5 key questions to ask and to who in the planning stage of your report so you get it right first time.

Choose the right chart for your data; I teach you over 20 charts and show you which type of chart will best display your data.

Date and Time

Not decided yet.

Gallery (1)

About the Trainer

Rajesh S picture

Avg Rating

Reviews

Students

Courses

Rajesh S

Microsoft Excel 2003 to 2013

Highly skilled Business & Operation Analyst
With 8+ years experience and 3+ years in Ms Excel Training


Rajesh S,
Seminar Trainer and Individual Excel Coach

Career Summary:
- Consultant / Coach and Trainer for Microsoft Excel for Over 2 Years.
- 8 + years work experience in Microsoft Excel Application in MNC

Training Experience:
- Experienced in the design and implementation of training programs for group of 50 plus numbers of delegates
- Personalized Excel Coaching for 200+ professional from Jan-2010.
- Trained professional at various Levels (Entry level Executives to CEO)
- Trained different sectors like Retail / Banking / Logistics / IT / Sales / Marketing / HR

Industry Experience
I have broad experience in the Retail, Media / DTH, ISP / Telecom and Finance Sectors. This allows me to quickly turn the management skills to other industries, applying known solutions to new problems in new industries.

Reviews

No reviews currently

Discussions

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more