Excel Dashboards in an Hour

Learn how to create interactive Excel Dashboards in one hour. No special add-ins or tools required, just Excel.
Instructed by: Mynda Treacy | Subject: Office Productivity , Microsoft

Excel Dashboards in an Hour

About This Course

Excel Dashboards are a powerful tool to communicate and summarize complex Excel data. They can be created to summarize important information and are excellent for sharing a “snapshot" view among teams. In this mini-course I’m going to teach you a handful of the most powerful techniques so you can get some fast results. I’ve taught this course in various forms and the feedback has been incredible. Here are just a few:

Excel Dashboard students should have access to the PC version of Excel 2010 or later. Students should also be familiar with putting together any type of report in Excel to be able to apply the time saving and visualization techniques taught here. Students should be able to build and apply basic formulas in Excel. Pivot Table and Chart knowledge is helpful, but expertise is not necessary to take this course.

Contents and Overview This course includes 9 lectures and just over 1 hour of content in order to give students a working knowledge of utilizing Excel to create interactive Excel Dashboards to communicate their data.

Included are the Excel Dashboard workbook and PowerPoint presentation from the course which contain notes on where you can find more resources. You can use the workbook to practice what you learn and as a quick reference guide later on.

The course covers advanced features of Excel Dashboards, such as display and visualization principles for clear dashboard creation, using interactive controls to keep the report informative and relevant. Analyzing and automating information for a fully functional and complete dashboard.

Take the Course for Free

Instructor

Instructor   Mynda Treacy

Mynda Treacy is a qualified accountant and has been working with Excel since 1995, and sharing her knowledge on her Excel blog since 2010.

In 2014 she was awarded Microsoft Excel MVP for her contribution to the Excel community. She also teaches several highly acclaimed Excel courses at her website, My Online Training Hub, including an Excel Dashboard Course and Excel Expert course . Her courses incorporate real business scenarios drawn from her accounting background and work experience in multi-national companies in London.

Her teaching style is to the point with practical examples and files you can download for reference later on.


Course Info

Excel Dashboards in an Hour Excel Dashboards in an Hour Reviewed by Acamig Courses on November 15, 2018 Rating: 5
Powered by Blogger.