Excel with Interactive Excel Dashboards (Udemy.com)
Learn how to create amazing interactive Excel Dashboards that will wow your boss & take your career to the next level. Lifetime access with no subscription on Udemy.
Created by: Mynda Treacy
Produced in 2015
What you will learn
- I teach you the 5 key questions to ask in the planning stage of your report so you get it right first time.
- Learn how to 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.
- Learn how to write reports that are 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.
- Be able to build Dashboards 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).
- Animate your charts with some simple VBA code that I teach you how to edit to suit your charts. If you want 'Wow factor', this is it.
- Learn how to create reports that are fully intera
Quality Score
Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/
Overall Score : 90 / 100
Course Description
Excel Dashboards are a powerful tool to communicate and summarize complex Excel data.
The price of this course reflects its value and I'm confident you'll get results. Just read some of the unsolicited testimonials I've received:
"I originally signed up for this as continuing professional education for my CPA license but I have learned so much, easily more than any other technical class I've taken in years. Thank you for a wonderful class, you are a great teacher. Dielle B"
Dashboards can be created to summarize important information and are excellent for sharing a "snapshot" view among teams.
Master the Creation of Interactive Excel Dashboards and Learn to Build and Distribute Dashboard Reports From the Ground up.
3 hours of the tutorials are optional supplementary Excel lessons and only for students who need to fill any knowledge gaps.I don't waffle on, my tutorials get to the point so you're up to speed fast.
Included are all the workbooks from the course which contain extensive notes, so you don't have to worry about taking notes while watching the tutorials. You can use the workbooks 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 information informative and relevant, analyzing and automating information for a fully functional and complete dashboard. It also includes key considerations for distributing dashboards like password protections, locking and unlocking cells and protecting workbooks. Upon completion, students will have a variety of techniques and examples that can be applied to their own datasets. Students will be able to choose the right chart for their data, write easy to interpret reports, know which areas of the dashboard will get the most attention, animate charts using VBA, create interactive reports (so users can change views and filter information), among a host of other abilities taught in this course. Who this course is for:
The price of this course reflects its value and I'm confident you'll get results. Just read some of the unsolicited testimonials I've received:
- "Financial Analyst - $52,500 (before taking your course)
- Sr. Financial Analyst - ($60,000) After finalizing my dashboard
- Sr. Business Analyst - ($70,000) Start that this Monday
"I originally signed up for this as continuing professional education for my CPA license but I have learned so much, easily more than any other technical class I've taken in years. Thank you for a wonderful class, you are a great teacher. Dielle B"
Dashboards can be created to summarize important information and are excellent for sharing a "snapshot" view among teams.
Master the Creation of Interactive Excel Dashboards and Learn to Build and Distribute Dashboard Reports From the Ground up.
- Advanced Features
- Design and Display Principles
- Interactive Controls
- Analyzing Data
- Automating your Dashboard so it updates in seconds
3 hours of the tutorials are optional supplementary Excel lessons and only for students who need to fill any knowledge gaps.I don't waffle on, my tutorials get to the point so you're up to speed fast.
Included are all the workbooks from the course which contain extensive notes, so you don't have to worry about taking notes while watching the tutorials. You can use the workbooks 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 information informative and relevant, analyzing and automating information for a fully functional and complete dashboard. It also includes key considerations for distributing dashboards like password protections, locking and unlocking cells and protecting workbooks. Upon completion, students will have a variety of techniques and examples that can be applied to their own datasets. Students will be able to choose the right chart for their data, write easy to interpret reports, know which areas of the dashboard will get the most attention, animate charts using VBA, create interactive reports (so users can change views and filter information), among a host of other abilities taught in this course. Who this course is for:
- This course is not for complete beginners because building Dashboards, and I mean proper interactive dashboards in Excel, requires some intermediate to advanced skills.
- Any course that says it's for All Levels' is either going to cover a load of basics you probably already know, or it won't get to the advanced topics that are going to make your dashboards truly dynamic and interactive.
- I know everyone is at different levels of Excel ability, which is why I've included a load of optional supplementary Excel lessons so you can fill in any knowledge gaps, like PivotTables, lookup formulas, Conditional Formatting etc.
- I recommend this course for people who have put together any type of report in Excel before, as you will definitely benefit from the time saving tips and data visualisation techniques I share with you.
Instructor Details
- 4.5 Rating
94 Reviews
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.
She doesn't waffle on just to make the course long. She'd rather get you up to speed quickly because she knows that what you really want is to know how to do this stuff, not spend hours watching videos.
Students also recommend
-
Microsoft Excel - Online Tutorial for Beginners (2010)
-
0.0 (0 Reviews)
-
Provider: Chandoo.org
Time: 1h 30m
Free
Reviews
- Video Duration:
12.5h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2015 - Language:
English, Polish [Auto-generated], 2 more - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
