1. Are your providing Online Continuing Education Credits?
We are approved to provide CPE/CE credits to Tax Professionals
- IRS
- NASBA
Shopping Cart
{{cart.item_name.toUpperCase()}}
{{cart.type}}
$ {{new Intl.NumberFormat().format(cart.single_amount)}}
Oops! Your cart is empty!
Excel Dashboard: How To Build An Effective Dashboard With Microsoft Excel
- Mar 31, 2020 Tuesday | 12:30 PM ET | 11:30 AM CT | 09:30 AM PT | Duration: 60 Minutes
Webinar Instruction will be emailed on your registered email address 3 days prior to webinar | Web Download / e-Transcript will be shared in 7 working days from the date of webinar
An Excel dashboard is a single page of “interactive” charts that display important information relevant to the business (or a specific department/process of the business)
In this informative webcast, Excel expert David H. Ringstrom, CPA, introduces you to the concept of Microsoft Excel dashboards. Dashboards offer valuable techniques that will allow you to assimilate large amounts of data quickly and easily by way of charts and summary tables.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 365 version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
Learning objectives:
- An easy way to take raw data and make it presentable with Excel dashboards
- Identify ways to use Excel dashboards to quickly assimilate large amounts of data.
- Recall how to create a dashboard that looks less like an Excel spreadsheet.
- Define how to create dynamic and interactive graphs with Excel’s PivotChart feature.
Session Highlights:
- Discovering how Microsoft Query allows you to create self-updating links to databases, spreadsheets, text files, and other data sources.
- Managing information overload by creating a Top 10 pivot table.
- Discovering how Microsoft Query allows you to create self-updating links to databases, spreadsheets, text files, and other data sources.
- Assembling a dashboard from multiple pivot tables.
- Linking data from text files to Excel spreadsheets by way of Microsoft Query.
- Understanding the conflicts that can arise when you position two or more pivot tables too close in proximity to each other.
- Using Excel’s PivotTable feature to condense large amounts of information into manageable chunks.
- Linking data from text files to Excel spreadsheets by way of Microsoft Query.
- Presenting the largest or smallest values in chart form by way of a Top 10 pivot chart.
- Adding interactivity to pivot tables by using the Slicer feature for filtering in Excel 2010 and later.
- Filtering two or more pivot tables simultaneously by way of the Slicer feature in Excel 2010 and later.
- Adding interactivity to pivot tables by using the Slicer feature for filtering in Excel 2010 and later.
Who should attend:
- All practitioners who may benefit from using Excel charts more effectively.
- Financial Professionals Including CFO's, Controllers, Accounting and Finance Managers and Staff
- Financial Analysts, Budget Directors and Staff, CPAs, Auditors, Administrators and Managers
- HR and Sales professionals who prepare reports using Excel
- Engineers and Production Managers who prepare reports using Excel
- Users of Excel who want to learn about Excel dashboards
2. When are the continuing education credits reported to the IRS, HRCI, NASBA and other regulatory bodies ?
We reports the educational credits to the respective licensing/regulatory bodies in 5 business days.
3. What should I do if I can’t log my account?
The credentials to log into your account is your EMAIL ADDRESS & PASSWORD used during account creation.
- If you’ve forgotten your password, please go to the login page and click on the ‘Forgot Password.’ Then enter your registered email id to receive the password reset email. Click on the link given in the email to enter your new password.
- If the face any challenge, please reach out to us via email support@pro2learn.com or contact our support team through live chat support. Our support line is 1-937-865-8027.Our support team is available Monday to Friday from 09:00 AM – 06:00 PM EST/EDT
4. How can I view /access the courses that I have registered for?
When you register for any of our webinars/product, you receive will the instruction 24 hours prior to the conference. Also, the instructions are avilable in your account under ‘My Webinars’ section.
5. How can I cancel my registration?
You can cancel your registration to by email at support@pro2learn.com. If you cancel your registration for the paid webinar, the amount shall be credited back in your payment method within 7 business days.
6. How can I download the learning materials/Handouts available for the webinars/Seminar?
The conference materials are available 4 hours prior to the webinar. You can download it from the webinar page or by logging to your account.
7. What are the system requirements to attend a live webinar?
Our seamlessly integrated with ZOOM, WebX and, Goto for delivering continuing education webinars. The system requirements are :
- An internet connection – broadband wired or wireless
- Speakers and a microphone – built-in, USB plug-in, or wireless Bluetooth
8. What are CPE Package Courses?
Our package courses are the bundles of various continuing education courses which have been specially designed to meet your continuing education requirements for a particular Qualification.
9. What is web download and transcript?
- The web download is the recording of the webinar. You will receive a link to download and save the webinar on your computer and watch it anytime and multiple times.
- The transcript is the detailed written material presented during the webinar.
10. What is an On demand session?
On demand session is when we conduct the webinar as per your available dates after the live training. You will get access to the training for 24 hours.
11. How do I access a previously purchased webinar, self-study course, Web Download, or package?
To access a course that you have already purchased, all you must have to create/log in to your account. Click on the "Log In" button in the top right of the screen. Once you are logged in, you will have immediate access to all your purchased CPE courses, packages and other self-service or you can write on support@pro2learn.com.
12. I took a webinar, where is my certificate?
We will email your certificate within 3 working days of the end of the webinar, or you can login your account at www.pro2learn.com. If you don’t receive the email within 3 working days of the end of the webinar, check your spam/junk folder. If it’s not there, we recommend that you send us an email at support@pro2learn.com or connect over the online chatroom.
Download Summit Material
Mentors
© 2024 Pro2learn, Inc. All rights reserved.
