Certifications / Designations
Safe Deposit Box
Trusts & Estates
Search By Topic
Conferences & Events
HR Events Calendar
List Your Events
List Your Courses
List As An Expert
List As A Vendor
Add Me To Your Mailing List
Format: Webcast/Audio Conference/Interview/Podcast
The following provides course information, as well as pricing, author, and educational credit information for the course you selected.
To order this course
, click on one of the "Order" options at the bottom of the page.
How To Use Excel Dashboards
Date / Time:
Recorded CD ($239.00)
Feel overwhelmed by the amount of information crossing your desk?
One way to stem the tide is by way of Excel-based dashboards, which can aggregate content from numerous sources into a compact resource that allows you to assimilate mass amounts of information at once, but also quickly drill down into the details when needed.
In this presentation, Excel expert David Ringstrom, CPA shares with you a number of techniques that you can use to construct dashboard applications in Excel. David teaches from Excel 2010 in this presentation, but his course materials include alternate instructions for Excel 2013, 2007, and 2003 when needed. He also provides an example workbook that includes copies of the related PowerPoint slides on each worksheet.
Who Should Attend:
Practitioners tasked with summarizing large amounts of data in Microsoft Excel spreadsheets
This webinar will help you to master a variety of Excel features and worksheet functions that will help you use Excel far more effectively. By attending, you will gain the ability to:
Create set-and-forget spreadsheets that others can use to monitor financial results
Use the From Text feature in Excel to establish persistent links to data files exported from your accounting software
Discover how Microsoft Query allows you to create self-updating links to databases, spreadsheets, text files and other data sources
Understand how to use the Slicers feature in Excel 2013 to streamline analyzing data within tables
Discover the Sparklines feature in Excel 2010 and 2013, and how to replicate it in Excel 2007 and earlier
Use Excel's Custom Views feature to show or hide multiple worksheets on demand
Use the Group and Ungroup feature to expand or collapse
Master the versatile SUMIF function
Use the SUMIFS to sum value based on multiple criteria
Compare the MIN, SMALL, MAX and LARGE functions
See why the MATCH and INDEX combination is often superior to VLOOKUP or HLOOKUP
Overcome annoyances in Excel 2013 by making simple adjustments to Excel's options
Discover the new Recommended Pivot Tables feature in Excel 2013
See the new Recommended Charts feature in Excel 2013, as well as user interface changes in Excel 2013 that make managing charts far easier
Capitalize on new features in Excel 2013 that empower anyone to quickly analyze data
NASBA Field of Study:
Specialized Knowledge and Applications (2 Hours)
About Your Speaker
David Ringstrom, CPA, is the Tech Editor-at-Large for AccountingWEB and Going Concern. David speaks at conferences nationally and presents dozens of webinars annually on Excel and other topics. He offers Excel training and consulting services nationwide, and has written numerous articles on spreadsheets.
Cannot Attend The Live Presentation?
This presentation is also available in a recorded format, in On-Demand Or CD versions, 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.
The live 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.
About The Provider:
The Industry Calendar creates and sells audio conferences, webcasts, seminars, and other training courses for busy business professionals.
We've done the work of listing the important, don't-miss events in one convenient location so you can quickly and easily view and register for upcoming events. Simply click on a course title or search by specific industry to get started!
Contact Us For More Information
, if you cannot attend this event, but like to get notified of future dates for this event.
Recorded CD ($239.00)
Alert! Financial Crimes Enforcement Network: Proposed Customer Due Diligence Requirements for Financial Institutions
Business Development Strategies for Lenders
Call Report For Banks: Recent Changes, Highlights, And Pitfalls
Legal Liabilities When Check Fraud Occurs
Sixty (60) Steps for Properly Handling Delinquent and Abandoned Safe Deposit Boxes (2014 Update)
Writing an Effective Credit Memorandum
Get Global! Understanding Global Cash Flow Analysis
Certified Regulatory Vendor Program Manager
Opening New Accounts For LLC's
Internal Investigations Certificate Program
Marketing & Advertising Compliance - The First UDAAP Hotspot
Bitcoin for Bankers
Appraisal Review for Residential Mortgage Decisions
The 8 Keys to Teller Excellence
Power of Attorney & Living Trust Documents
Series 11 Exam Prep
Series 55 Exam Prep
Series 24 Exam Prep
Series 62 Exam Prep
Series 3 Exam Prep
Series 26 Exam Prep
Series 63 Exam Prep
Series 4 Exam Prep
Series 27 Exam Prep
Series 65 Exam Prep
Series 6 Exam Prep
Series 28 Exam Prep
Series 66 Exam Prep
Series 7 Exam Prep
Series 32 Exam Prep
Series 79 Training
Series 9 Exam Prep
Series 51 Exam Prep
Series 82 Training
Series 10 Exam Prep
Series 53 Exam Prep
Series 99 Training
Accredited Investment Fiduciary (AIF®)
Certified Income Specialist (CIS)
Chartered Financial Analyst (CFA)
Certified Annuity Specialist (CAS)
Certified Senior Advisor (CSA)
Chartered Financial Consultant (ChFC)
Certified College Planning Specialist (CCPS)
Certified Tax Specialist (CTS)
Financial Risk Manager (FRM)
Certified Divorce Specialist (CFDS)
CFP Courses for Certification
Professional Plan Consultant (PPC)
Certified Estate and Trust Specialist (CES)
CFP Review Course
Qualified Financial Advisor (QFA)
Certified Financial Planner (CFP)
Chartered Advisor for Senior Living (CASL)
Steps to Achieve CFP® Certification
Certified Funds Specialist (CFS)
Chartered Alternative Investment Analyst® (CAIA®)
Account Management Training Courses For Bankers
Banking Certifications / Designations
Safe Deposit Box Training
Bank Compliance Training And Education
Call Report Training
Trusts and Estates Training
Bank Fraud Prevention
UDAAP Training Courses
Mortgage Lending Training Courses
Vendor Management Training Courses