In this helpful session, Excel expert David Ringstrom, CPA, shares various ways you can streamline filtering tasks, including little-known shortcuts, such as using Custom Views and the hidden AutoFilter command. He also discusses Conditional Formatting and explains how to resolve somewhat challenging issues, including how to remove non-breaking spaces from reports you copy from cloud-based software or from text with carriage returns.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He’ll draw to your attention 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.
Who Should Attend?
Excel users who work with large data sets and wish to learn ways to streamline their filtering and formatting tasks.
If you are having issues with registering online, please contact CBAO's Education & Training Coordinator, Lianne Simeone, (614) 610-1877.