In this presentation, author and Excel expert David H. Ringstrom, CPA, will take you on a deep dive into the art of data management and analysis in Excel. You’ll discover indispensable techniques for filtering Data efficiently and learn time-saving filtering keyboard shortcuts, including how to add Clear Filter to the Quick Access Toolbar for seamless data refinement. David will unveil the power of ad hoc totals while filtering and demonstrate the versatility of the Table feature. You’ll also gain insights into optimizing your workflow by mastering Slicers with Tables and harnessing the Custom Filter option for precise data extraction. Learn how to streamline your analysis by Filtering by Color and easily Reapply filters when needed. Dive into Advanced Filter functionalities and explore the FILTER function in Excel 2021 and Excel for Microsoft 365 for enhanced data manipulation. David will also show you how to use FILTER with multiple conditions and show how to filter charts. Join us for this enlightening webinar to transform your data filtering and analysis skills in Excel.

Learning Objectives:
•    State which argument number informs the SUBTOTAL function that you wish to calculate the average for a range of cells.
•    Recall the keystroke that enables you to select two or more non-adjacent items from a Slicer.
•    State which feature in Excel allows you to identify a criteria range for specifying data you wish to see within a list on a worksheet.

To complete this course participants need to: View the video and complete an assessment exam with a minimum passing grade of 70% or higher.

Upon course completion a course evaluation form is provided for your feedback.

You have 1 year from the time of purchase/enrollment to complete the course.

Our Refund Policy can be found at: https://cpeprime.com/cancellation-and-refund/