Author: David H. Ringstrom
Many users are unaware of the many data visualization and manipulation tools available in Microsoft Excel. In this session Excel expert David Ringstrom, CPA shows you various ways to streamline filtering tasks, including little known shortcuts such as Custom Views and the hidden AutoFilter command. David will also discuss Conditional Formatting, shows you how to how to resolve thorny issues like removing non-breaking spaces from reports you copy from cloud-based software or text with carriage returns.
David’s materials cover Excel 2016, 2013, 2010, and 2007. When applicable, some slides include alternate instructions for Excel 2003. In this presentation, he demonstrates techniques in Excel 2010, as he finds it’s presently the version most widely utilized by Excel users. David’s detailed handouts serve as reference tools you can fall back on after completing one of his courses. He also provides an Excel workbook that includes a majority of the examples he uses during each session.
Publication Date: October 2015
Designed ForUsers who work with large data sets in Excel
NASBA Field of Study
Computer Software & Applications (3 hours)