Excel Dashboards 101
|Date / Time:
Microsoft® Excel® dashboards are a powerful way to pull together different information in a single place to give a high-level overview of a business. A meaningful "big picture" view of business activities can drive the allocation of scarce resources.
Decisions are easier.
And, the end-user doesn't have to spend valuable time swimming through seas of unimportant information to get to key information.
You could buy expensive software to create dashboards. But, before you do, see what you can do with tools you already possess in Excel.
Join Microsoft® Certified Trainer Melissa Esquibel on December 3 for Excel Dashboards 101 to discover how to create useful dashboards with financial, production and customer data. Get tips on converting raw data into readable charts, diagrams and tables that are easy to consume.
- What should be included in your dashboard
- Set-up tips to allow data to easily flow from source to dashboard
- How to make your dashboards resilient to changing data
- Using charts and pivot tables to get just the detail you need
The session will be presented from Excel 2010, but many of the techniques you'll learn will be applicable to Excel 2007 and 2013. Some material will also be usable in older versions. To get the most out of this program, attendees should have some experience with Excel charts, pivot tables and formulas.
Among the techniques you'll learn are:
- Importing data from external sources
- Transforming cell data into dynamic graphics
- Creating interactive user interfaces
- Connecting your dashboard to automatically refreshing data
With Excel Dashboards you can step back from the details and see the key trends and relationships that drive business.
Cannot Attend The Live Presentation?
This presentation is also available in a recorded format, in CD version, as shown in the pricing options below.
|About Webcasts / Audio Conferences / Podcasts:|
Webcasts, audio conferences, and podcasts are presentations that you
attend via the Internet, phone, or mobile device at a specified date and time for "live" versions, or at your convenience for "recorded" and "On-Demand" versions.
versions are interactive, meaning that participants can ask questions in real time, plus are a very cost-effective form of training because 1) you receive fast, convenient learning without
any out-of-office time; 2) you can invite as many colleagues as you'd like to listen in on a single phone line; 3) you incur no travel expenses; and 4) you and your colleagues are back
at work immediately after the session ends!
And though with recorded versions you do lose the ability to ask questions, you gain the ability to hear the presentation numerous
times and to share it with others in your office.
Handout materials and the phone number for live presentations are made available to you prior to the event via email from the
presenter and from the "MyAccount" link on the menu bar. Copies of the presentations are included with recorded versions.
|Licenses / Designations / Educational Credits:||PACE|
All US States: 1.5
All Canadian Provinces: 1.5
|About The Provider:
||The HR Specialist family of products helps HR professionals quickly resolve their daily challenges. From state-specific employment law to compensation and benefits, our experts give you the HR advice you need to know.
Whether you're new to HR or an experienced pro - a department of one or 10 - you can trust the practical, plain-English advice from HR Specialist. We'll save you time and headaches by focusing on what you need to know, when you need to know it. That makes you the HR expert your company can rely on and gets you the recognition you deserve.
||Contact Us For More Information
||Share on Facebook
Share on Twitter
Share on Google+
|Keywords For This Course:|
Excel, accounting, data, presentations, software, MS Office
How To Keep HR From Being The Employee Complaint Department
Reasonable Or Unreasonable Accommodation? How To Identify Disabilities And Handle Employee Issues - Without Violating The ADA
Workers′ Comp 101: The Whats, Whens, And Whys
Internal Investigations Certificate Program
Certificate Program For HR Generalists
Service Animals In The Workplace: What You Need To Know
Multi-State Payroll Tax Compliance
Visa (Non-Immigration) For Payroll Professionals
IRS Rules For Travel Pay
How To Get Your Managers To Cooperate With HR
How To Avoid Wrongful Termination Claims
Form I-9: Understanding The Anti-Discrimination Provisions Of The Law
Certificate Program In FMLA &ADA Compliance
Dealing with Difficult People
How To Communicate With Tact And Professionalism
Dress Code Policy Do′s and Don′ts