Excel: Stunning Excel Dashboards with PowerPivot-Power View

MP4 | Video: 960x540 | 128 kbps | 44 KHz | 392 MB

Genre: eLearning | Language: English

Excel Dashboards are a powerful tool to present and report data. However building a dashboard is a complex process. In this course I'll walk you through the most effective ways and tools to build Excel dashboards that will wow management both visually and substantively. We'll use Microsoft's free PowerPivot and Power View tools to analyze huge amounts of business data fast and transform data into bottom-line results – no programming required!

Note: Power View is a new interactive tool available only in Excel 2013 (PowerPivot is available in both versions - 2010 and 2013)

You'll have lifetime access to watch the videos whenever you like. If you're not 100% satisfied there is a 30 day money back guarantee!

Plus you will get fast and responsive support within 24 hours.

Free downloadable Excel working files are included to allow you to follow along using the same material I use throughout the lectures. You can download all of them.

What are you waiting for? Enroll now and make your Dashboards look amazing!

What you'll learn:

Dashboard design principles, tips and tricks

Understand and install the Excel PowerPivot and Power View add-ins

Import data from spreadsheets, Access, SQL, text files and other sources

Add calculated fields and columns with Data Analysis Expressions (DAX) formula language

Create complex reporting systems

Design your Dashboard with link buttons

What are KPI's and add key metrics

Create mind blowing Excel Pivot Charts from PowerPivot

Create powerful reports using Slicers and Timeline

Make an amazing interactive sales map using Excel 2013 Power View powerful add-in

Summarize data with Matrices, Cards and Tiles

Perform simple-to-sophisticated calculations like Month to date and Year to date

Analyze multiple tables together without the need to ever write VLOOKUP formulas again

Enroll now and master the creation of interactive Excel Dashboards!

Who is this course for?

This course assumes that you have a basic knowledge of Excel 2010 or Excel 2013. You don't need to be a master of Excel. Only basic prior experience in Excel or Spreadsheets is required to get the most out of this Excel course.

This course is also ideal for data analysts, MIS professionals, business analysts, managers, dashboard makers, business intelligence professionals and students.

At the end of this Excel class you will be given a Certificate of Completion.

About the instructor

"Hi, I am Andreas and I'm a teacher. I really love learning and teaching whenever i can.

I have over 16 years of experience in teaching as an instructor. I have my own computer learning school, called Futurekids, from 2001 to now. I am the founder of Mellon Training, an online video tutorials learning school.

I have a passion for software products that make people's lives easier.

Thank you and I'll see you inside!"

And don't forget:

I answer all student's questions.

I'll update the course and add new material as often as I can.

Honest reviews are always greatly appreciated.

Enrol now and enjoy!

What are the requirements?

To have Excel 2010 or later version installed, so you can open the workbooks and practice what you learn

PowerView is a new interactive tool, available only in Excel 2013

PowerPivot is not available in Office Standard 2013

Willingness for learning

What am I going to get from this course?

Over 26 lectures and 1.5 hours of content!

Create business intelligence reports and dashboards

Quickly turn mass quantities of data into meaningful information using Excel PowerPivot add-in

Make amazing interactive sales maps using Excel 2013 Power View powerful add-in

Analyze huge amounts of data fast and accurate

Learn in depth PowerPivot and Power View tools

Improve general Excel knowledge

Follow along with included Excel project files

Learn the most current version of Microsoft Excel

Course updated regularly

Learn from an instructor with over 16 years of experience, teaching thousands of students in his own computer learning school

An instructor ready to answer your questions in less than 24 hours

Watch high-quality video lectures with lifetime access

Certificate of completion

What is the target audience?

Everyone who wants to master Excel Dashboards

Business analysts

Data analysts

Students

Entrepreneurs