Excel expert David Ringstrom, CPA, teaches you how to pivot, or rearrange the data in an Excel file Pivot tables enable you to easily create reports from complex data simply by using your mouse. He shows you how to initiate a pivot table from a list of data into a conpact and understandable report.
Please check your State Board of Accountancy to confirm if Nano courses are accepted for CPE credit.
Publication Date: April 2019
Designed For
Practitioners who need to present complex data in a concise and easy to understand report.
Topics Covered
- Adding columns to a pivot table
- Filtering pivot table data based on date ranges
- Excel's Top 10 feature
Learning Objectives
- Recognize how to use pivot tables to tranform data into clear and concise reports
Level
Basic
Instructional Method
Nano Learning
NASBA Field of Study
Computer Software & Applications (0.2 hour)
Program Prerequisites
None
Advance Preparation
None
Instructor
David H. Ringstrom
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches over 200 webinars each year. His Excel courses are based on over 30 years of consulting and teaching experience. David’s catchphrase 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. He's currently writing a book titled "Exploring Excel's Hidden Treasures". To learn more about David, you can view his
LinkedIn profile and follow him on
Facebook or
Twitter (@excelwriter).