BCU Webinars Webinar

Basic Data Analytics in Excel Workshop

In this presentation, author and Excel expert David H. Ringstrom, CPA will take you on a journey to master the Excel features that transform the way you handle data, enabling you to expedite tasks and analyze information more effectively.

You'll learn the intricacies of PivotTables, from identifying ideal data sets to refreshing and optimizing your PivotTables with recommended layouts. David will demonstrate the power of sorting—whether by color, custom lists, or other criteria—and how to enhance data analysis through Excel's advanced sorting features. He will guide you through the nuances of filtering data, adding ad hoc totals, and employing slicers to create dynamic Excel tables.

Get ready to dive into the sophisticated world of dynamic array functions in Microsoft 365 and Excel 2021's, including FILTER, SORT, and UNIQUE, and explore how these can revolutionize your data workflows. Dynamic array functions improve data integrity of spreadsheets and reduce maintenance. David will show you how to follow along with this part of the presentation in Excel for the Web if you're using Excel 2019 or earlier. This session will also cover conditional formatting tricks, the art of removing duplicates, and leveraging structured references with the SUMIF function.

Finally, enhance your problem-solving arsenal with an introduction to Excel's Goal Seek and Solver add-ins, and learn how to streamline text manipulation with the Flash Fill tool.

Whether you're a seasoned professional or new to Excel, this webinar is designed to equip you with the skills to navigate and manipulate data with unprecedented ease and confidence.

Add to Cart

SKU 70BWUS245260E

What You'll Learn

You will learn to recognize which items can be added to a PivotTable by way of the PivotTable Fields task pane, state what the FILTER function returns if there are no records to be displayed, and identify the Conditional Formatting command that would color code cells with values within a given range of numbers.

Who Should Attend

This webinar is perfect for professionals across various sectors, including business analysis, accounting, marketing, project management, and anyone eager to leverage Excel's advanced features to enhance their data analytics and reporting capabilities.