Creating and Implementing Dynamic Excel Dashboards - NASBA CPE - 1.5

  • Speaker:David H. Ringstrom, CPA
  • Date: 29th June 2018 10:00 AM PST | 01:00 PM EST
  • Duration:90Min
  • Product Code:GRC-90333
  • NASBA CPE: 1.5

$169

10

DAYS
Left to Register

refer

Refer Friends


Live Session - How it works

  • Username and Password will be sent to you 24 hours prior to the webinar.
  • Presentation handouts in pdf format will be mailed to you.
  • Login to the session using the username and password provided to you.
  • Get answer to your queries through interactive Q&A sessions via chat.
  • Please let us know your thoughts and views at the end of webinar, your valuable feedback will help us improve.
  • Get certification of attendance.

Recorded Session - How it works

  • Login Information with Password to view the webinar, 24 hours after the Live webinar (link valid for 6 months).
  • A link will be provided to you upon purchase of the recorded session.
  • Please click on the link to access the session.
  • Presentation handouts in pdf format will be mailed to you.
  • Get certification of attendance.

Training CD - How it works

  • Free shipment within 72 Hours, from the date of webinar completion.

(More about our products contact +1- 248-233-2049)

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com.
NASBA

Group Internet Based | 1.5 (1 CPE for 50 minutes) | Accounting - 1.5CPE (1.5 CPE) | Finance- 1.5CPE (1.5 CPE) | Intermediate | Prerequisites - Excel Knowledge | No advance preparation.

Description: 

Excel expert David Ringstrom, CPA, lays the groundwork for creating and implementing dashboards in this comprehensive presentation. You’ll discover how dashboards allow you to quickly assimilate large amounts of data into spreadsheets by way of pivot tables, charts, and other Excel features. David shows you how to streamline data analysis, expand or collapse rows and/or columns, create dashboards that look less like Excel spreadsheets, filter pivot table data based on date ranges, and much more.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 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.

Topics Covered:

  • Discovering how Microsoft Query allows you to create self-updating links to databases, spreadsheets, text files, and other data sources.
  • Displaying two or more pivot tables on a single worksheet close together without triggering a conflict.
  • Avoiding the dreaded PivotTable Field Name Already Exists error prompt.
  • Linking data from text files to Excel spreadsheets by way of Microsoft Query.
  • Gaining an overview of what a dashboard is within the context of a Microsoft Excel spreadsheet.
  • Minimizing visual clutter by hiding worksheet gridlines.
  • Adding new data sources to Microsoft Excel so you can extract data from text files, accounting software, and other data sources.
  • Filtering two or more pivot tables simultaneously by way of the Slicer feature in Excel 2010 and later.
  • Determining which refresh commands in Excel update a single pivot table versus all pivot tables in a workbook.
  • Duplicating Excel worksheets in two different ways.
  • Assembling a dashboard from multiple pivot tables.

Learning Objectives:

  • Identify ways to use Excel dashboards to quickly assimilate large amounts of data.
  • Recall how to use Microsoft Query to create persistent connections to data you wish to present in a dashboard.
  • Apply the Quick Analysis feature for data visualization.

Who Should Attend:

Practitioners tasked with summarizing large amounts of data in Excel spreadsheets.

Instructor: 

David H. Ringstrom, CPA

Nationally recognized Microsoft Excel expert David H. Ringstrom, CPA, is the president and owner of Accounting Advisors, Inc. based in Atlanta, Georgia. David founded Accounting Advisors in 1991 as a consulting-services business, later he began teaching continuing education classes as well. His mission since is to offer quality training and consulting services on Microsoft Excel via live webcasts, on-demand self-study webcasts, and in-house engagements. David has taught hundreds of webinars on Excel and other topics, in addition to speaking at conferences and in-house engagements.

David has developed training courses based on his 25 years of experience in Consulting. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what many users don’t know but should know about Microsoft Excel.

His mission is to offer quality training on Excel and additional accounting software via live webcasts, on-demand self-study webcasts, and in-house engagements. More than 24 providers, located throughout the country as well as overseas, now look to David for their Excel and accounting software training needs.

David’s Excel courses cover the gamut of the software’s features and functions to provide CPAs as well as accounting and financial professionals the knowledge they need to work more efficiently and effectively in Excel. His comprehensive yet easy to understand presentations cover Excel 2016, 2013, 2010, and 2007. David’s webcasts are fast paced, and he welcomes attendees’ questions. In addition, his detailed handouts and slides serve as handy reference tools students can fall back on after participating in his webcasts or taking his self-study courses.

Available Options

Live Meeting Access Single: Attend the meeting Live via Webex Meeting

$169

2 Single Live Access: 2 people can attend the meeting Live from any location

$279

3 Single Live Access: 3 people can attend the meeting Live from any location

$339

Recording: Access the training Recording for 6 months from any location

$259

CD: Shipped within 2 working days

$359

USB - Shipped within 2 working days

$389

Live + Recording: Attend Live Meeting Online + Access the recording for 6 months

$289

Live + CD: Attend Live Meeting Online + Get the training CD shipped for free

$389

Live + USB - Attend Live online + Get the training USB shipped for free

$419

5 Member Group: 5 can Attend Live Meeting Online from any location globally

$539

10 Member group: 10 can Attend Live Meeting Online from any location globally

$839

Related Products

TIN Matching & B Notices - How to minimize the paperwork from complaints on IRS information returns | NASBA CPE 1.5

TIN Matching & B Notices - How to minimize the paperwork from complaints on IRS information returns | NASBA CPE 1.5

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. You can access the recording of the webinar for 6 months. Contact our support for any clarifications. NASBAGroup Internet Based | 1.5 (1CPE for 50 minutes) | Accounts - 1CPE / Taxes - .5CPE (1.5 CPE) | Intermediate | Prerequisites - None| No advance preparation.Description: This webinar will help you reduce the risk of being out of compliance with your Form 1099 reporting requirements with the I..

$279

Financial Modeling with Excel Tools or Dashboard Reporting and Balanced Scorecards |  NASBA CPE - 1.5

Financial Modeling with Excel Tools or Dashboard Reporting and Balanced Scorecards | NASBA CPE - 1.5

If you are unable to attend the Live meeting then you can opt in for the Live Recording instead. You can access the recording of the webinar for 6 months. Contact our support for any clarifications. Description:Attend this briefing and demonstration on Excel to unleash its powerful sensitivity tools. Get the full power out of your financial models.  Improve the design of your models to take advantage of these tools in just 90 minutes.Financial analysis is an area of opportunity and ris..

$269

Excel Data Management Features Manage Data with Sorting, Filtering and other tools

Excel Data Management Features Manage Data with Sorting, Filtering and other tools

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com.NASBAGroup Internet Based | 1.5 (1CPE for 50 minutes) | Specialized Knowledge (1.5 CPE) | Intermediate | Prerequisites - Comfortable working with Excel; some knowledge of sort and filter is helpful, but not re..

$269

Excel Tips, Tricks, and Shortcuts Work more efficiently - NASBA CPE - 1.5

Excel Tips, Tricks, and Shortcuts Work more efficiently - NASBA CPE - 1.5

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. NASBA: Group Internet Based | 1.5 (1 CPE for 50 minutes) | Specialized Knowledge - (1.5 CPE) | Basic to Intermediate| Prerequisites: Must have basic Excel Knowledge| Advanced Preparation: Must have basic Excel Knowledge.Descrip..

$279

Business Email Etiquette: Learn to Process, Route, and Respond in a Timely Manner - NASBA 1.5 CPE

Business Email Etiquette: Learn to Process, Route, and Respond in a Timely Manner - NASBA 1.5 CPE

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. You can access the recording of the webinar for 6 months. Contact our support for any clarifications.NASBA CPE - 1.5Group Internet Based | 1.5 (1 CPE for 50 minutes) | Specialized Knowledge - (1.5 CPE) | Basic to Intermediate| Prerequisites: Must have basic Knowledge| Advanced Preparation: Must have basic Knowledge.Topic Description: Don’t let email be the bane of your daily work existence. Optim..

$269

Outlook on Steroids: Tips and Techniques for the Advanced User - NABSA HR CPE - 1.5

Outlook on Steroids: Tips and Techniques for the Advanced User - NABSA HR CPE - 1.5

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. NASBA CPE - 1.5 | Field - HRDescription:Outlook is a powerful productivity tool and can be treated as a programming tool. The savvy users of Outlook can program its features to be more productive – taking into account their job desc..

$269

Easy Planning and Prioritizing Using Microsoft Outlook Tasks and Calendar - NASBA HR CPE - 1.5

Easy Planning and Prioritizing Using Microsoft Outlook Tasks and Calendar - NASBA HR CPE - 1.5

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. NASBAGroup Internet Based | 1.5 (1 CPE for 50 minutes) | HR - 1.5CPE (1.5 CPE) | Specialized Knowledge - 1.5CPE (1.5 CPE) | Intermediate | Prerequisites - Basic Knowledge in Outlook| No advance preparation.Description..

$289