Excel Dashboards Masterclass هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

*** Completely up-to-date for November 2016 ***

*** This course is fully subtitled in English! ***

Excel dashboards are a powerful way to leverage Excel functionality, build and manage better presentations and improve your Excel and data visualization skills. In this course I'll show you how you can turn Excel into your own, personal Business Intelligence tool and create Interactive Charts and awesome Dashboards in Microsoft Excel.

Learn how to make amazing Dynamic Excel Charts, Dashboards and Pivot Charts in a few weeks

Content and Overview

Have you wasted your time searching countless hours for YouTube videos, trying to find useful content about Excel Graphs and Dashboards?

While Excel offers dozens of chart types and hundreds of formatting options, making the right chart is the trickiest part. In order to use charts effectively, you'll need to understand how different charts are used.

In this course my goal is to give my students the practical knowledge, with real-world examples and step by step instructions, to create professional and designer-quality Charts and Dashboards in Excel.

With over 90 Lectures, quizzes, assignments, real-life Excel projects+SAMPLES and weekly updates, learning advanced Excel techniques has never been easier. This course is a concise and practical go-to guide for creating Interactive Charts and awesome Dashboards in Microsoft Excel. It also expands in to Pivot Tables, Pivot Charts, Conditional Formatting, Functions, Formulas and Macros.

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.

What are you waiting for? Enroll now! (it is 100% no risk deal)

Why is this course different?

• It's super practical. 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.
• It's comprehensive and fast. Microsoft Excel charts are complex, that's why the course is broken down into bite-sized pieces
• The course also expands in to Conditional Formatting and Functions-Formulas
• I update the Excel class monthly with new lectures!
• It has a quiz after section so to prove that you have learned the material.
• You will learn the version of Microsoft Excel (2013) but the concepts are compatible with Excel 2016, 2010, Excel 2007 and the brand new Excel 2016
• Compatible with Microsoft Office for Macintosh

What am I going to get from this course?

• How to select the correct Excel chart type for your data.
• How to create amazing data visualizations in a matter of seconds!
• The most important elements of a Microsoft Excel chart, like chart and plot area, Design and Format tab, data labels, gridlines, legends, titles, axes, layouts and much more
• Modifying an Excel chart visually: styles and colors, create a pictograph, Excel's camera tool, shapes, effects, text etc.
• Basic Excel chart types like Column charts, Bar charts, Pie charts, Line charts, 3D charts, Scatter charts, Bubble charts, Stock charts, Surface charts and Radar Excel charts.
• How to create mini charts like Sparklines and make data analysis fun!
• Advanced Excel chart types like Combo charts, Pareto charts, Gantt charts, Gauge-Speedometer charts, Waterfall Charts, Bullet charts and Frequency charts.
• How to create impressive Dynamic Professional Excel Charts with 5 different methods.
• How to create Business Dashboards and Excel Reports.
• How to create Excel Pivot Tables, Pivot Charts and how to add Slicers to help you filtering your data.
• Create a Histogram in Excel, using Frequency Distribution.
• How to create all types of Excel Sparklines.
• The secrets of linking Excel Graphs with other programs and printing charts
• Bonus material : Excel most useful shortcuts etc
• How to create and use Functions-Formulas for Excel Charts.

Enrol now and enjoy the course!

Who is this course for?

• Entrepreneurs
• Students
• Business Professionals
• Everyone who wants to master Excel Graphs, Pivot Charts and Dashboards
• Students with willingness for learning

Only basic prior experience in Microsoft Excel or spreadsheets is required to get the most out of this Excel course.

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

Testimonials for this Course

"I learned so many new excel tricks from this course. It covers almost everything. Andreas impressed me for updating his course so often! It worth every cent. Great job!" - Chris K

===================================================================

"Outstanding course! Very thorough and easy to understand. Sample spreadsheets make it very simple to follow along and provide hands on work. I would highly recommend this course." - Kelli Kellen

===================================================================

"A strongly recommend the course for all type of excel users. The lecturer follows a systematic and inspiring approach to present the most important techniques for data visualization with Excel." - Tommy Kalman

===================================================================

*** learning is more effective when it is an active rather than a passive process *** Euripides Ancient Greek dramatist