Learn all the functionalities, shortcuts, formulas, interfaces and interactions between objects to generate dashboards
In this course the students will learn how to create automated Excel dashboards. In details:
how to connect form commands or ActiveX to values in cells and ranges
how to generate automated charts which will be updated just modifying a single value in one or a few cells
how to create dynamic images, which will be updated by changing some values in cells
how to use Excel functions and formulas to create tables and data sources and summary reports
how to use combined lookup and reference formulas to retrieve joined values between different tables
how to create variable charts with data series generated dynamically
The course is conducted through examples.
These examples covers Excel dashboards in the most popular business areas, in details:
Dashboard testing activities
Interactive Dashboard in Excel using Hyperlinks
Interactive Sales Chart
several KPI dashboards
Make Dynamic Dashboards using Pivot Tables & Slicers
Customer Service Dashboard
Project Management Dashboard / Project Status Report
Financial Dashboard
During the course and especially at the end some example will be done implementing Visual Basic for Applications (VBA). The programming language to create macros and functions to expand the functionalites of Excel.
Create their own Excel Dashboards
Create Excel reports with charts and formulas
Create automated reports in Excel
6 Lectures
27 Lectures
5 Lectures
6 Lectures
21 Lectures
6 Lectures
13 Lectures
11 Lectures
24 Lectures
19 Lectures
10 Lectures
10 Lectures
13 Lectures
I have 30+ years experience in IT project management, software development and software architecture.I have led several teams of software developers as project manager, quality manager and as team leader in different companies and different countries in sectors e.g. telecommunication, research & development, travel business, Internet marketing and Internet business, consultancy and services.I have been responsible to collect the requirements...
I have 10+ years experience in video creation and online training.I have created several videos and tutorial about how to create an online business and how to sell online as a reseller.I am now specializing in creating course about IT projects and companies.I have organized all my experiences in courses which are not only a list of functions and methods...
Course is to fast , example r not good, unable to understand.
The course has a good structure in the sense that the topics are in modular by topic focus and I can just refer to any module that I want to review.
too slow and poorly organized
There had been an instance wherein the tutor assumes that his errs on the instructional sequence of explanation on the subject matter could well be figured out by the student following the course, however I was able to spot a fix only after experimenting on the possible inputs those I could use to follow along with the course's content.
In another instance, the tutor assumes usage of tricks to tweak the referential data-flow formulae to arrive on the intended result-set without an elaborate reasoning w.r.t the context on its very usage...
This was a very thorough course but I suspect it would be more appropriate to describe it as an Advanced rather than Intermediate.
I don't have the knowledge off some of the formulas but hope to learn more
Voice is very low and not clearly audible and difficult for a common person to understand the fluency, till now nothing interesting found, felt bad for buying this course, not feeling motivated to learn further,
The introduction is good and i hope it will bring lots of knowledge to my excel skills.
ja
Your email address will not be published. Required fields are marked *
Mike H.
The concept of creating a Dashboard is spot-on what I need to move my skills to the next level. I have a bit of a difficult time understanding non-native English speakers, so the less-than-5-star rating.