RW Advantage - Webinars

If you have any questions or comments please give us a call at 1.800.348.1831 or
submit a form here and we will get back to you as soon as possible.
Please visit our Educational Services page for more webinars.

Event Name:

Introduction to Excel Dashboards

Date:

Friday, October 12, 2018 10:00am CDT

Presented By:

BankWebinars.com

Panelist(s) Info:

David Ringstrom (Bio)

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. To learn more about David, you can view his LinkedInprofile and follow him on Facebook or Twitter (@excelwriter).

Price:

$265.00

Credits:

2.5 CE Credits

Description:

Excel expert David Ringstrom, CPA, introduces participants to Excel dashboards in this broad-reaching presentation. Dashboards give you the ability to quickly assimilate large amounts of data into spreadsheets by way of pivot tables, charts, and other Excel features, including the Recommended Charts feature, PivotTable feature, PivotChart feature, Quick Analysis feature, and others. After the webcast, you’ll be equipped to summarize and present your Excel data in an efficient manner.

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.

Covered Topics:

Creating self-updating titles for charts and pivot charts.

Exploring the Recommended Charts feature in Excel 2013 and later.

Discovering how Microsoft Query allows you to create self-updating links to databases, spreadsheets, text files, and other data sources.

Seeing how the Sparkline feature empowers you to create tiny, in-cell charts for showing trends of data.

Using the Group and Ungroup feature to expand or collapse rows and/or columns.

Jump-starting data visualization with the Quick Analysis feature.

Filtering pivot table data based on date ranges by way of the Timeline feature in Excel 2013 and later.

Learning how to hide or unhide Excel’s Ribbon interface using a simple macro technique.

Resource Links

About Us

RateWatch, established in 1989, collects thousands of data points from nearly 100,000 financial institution locations across the United States every week. In June of 2018, RateWatch was acquired by S&P Global. Ratewatch will be integrated into S&P Global Market Intelligence, a division of S&P Global that provides essential intelligence for financial institutions, companies, governments and individuals through financial and industry data, research and news.

Over 4,200 financial institutions use RateWatch reports to monitor competitors' deposit and loan rates and fees. These institutions depend on...