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.
Included Webinars
Basic Data Analytics in Excel Workshop – Part 1
Basic Data Analytics in Excel Workshop – Part 2
Series Details
Basic Data Analytics in Excel Workshop – Part 1
Identifying the ideal data formats for streamlining analytical procedures
Utilizing Excel’s Power Query feature to transform unwieldy reports
Using lookup functions such as VLOOKUP and XLOOKUP to combine data from two or more reports together
Contrasting lookup functions with the Merge Queries feature in Power Query
Understanding the Sort feature in Excel for rearranging lists of data
Gaining control of long lists of data by filtering instead of sorting
Learning how the Table feature empowers you to improve the integrity of Excel spreadsheets
Streamlining the filtering of lists using the Slicer feature with tables
Analyzing your data with artificial intelligence by way of the Analyze Data feature in Excel 2021 and Microsoft 365
Basic Data Analytics in Excel Workshop – Part 2
Summarizing data with PivotTables and Pivot Charts
Enabling analysis of larger data sets than Excel can usually accommodate with PowerPivot
Identifying duplicates in a list using Conditional Formatting
Displaying subsets of data dynamically by way of the FILTER worksheet function
Sorting lists of data dynamically from elsewhere in a spreadsheet with the SORT function
Removing duplicates from a list with the UNIQUE function
Automating analysis by using the Spilled Range Operator within Excel formulas
Exploring Excel’s Goal Seek feature, which can be used to solve for a single missing input
Learning the basics of Excel’s Solver feature
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.
We may request cookies to be set on your device. We use cookies to let us know when you visit our websites, how you interact with us, to enrich your user experience, and to customize your relationship with our website.
Click on the different category headings to find out more. You can also change some of your preferences. Note that blocking some types of cookies may impact your experience on our websites and the services we are able to offer.
Essential Website Cookies
These cookies are strictly necessary to provide you with services available through our website and to use some of its features.
Because these cookies are strictly necessary to deliver the website, refusing them will have impact how our site functions. You always can block or delete cookies by changing your browser settings and force blocking all cookies on this website. But this will always prompt you to accept/refuse cookies when revisiting our site.
We fully respect if you want to refuse cookies but to avoid asking you again and again kindly allow us to store a cookie for that. You are free to opt out any time or opt in for other cookies to get a better experience. If you refuse cookies we will remove all set cookies in our domain.
We provide you with a list of stored cookies on your computer in our domain so you can check what we stored. Due to security reasons we are not able to show or modify cookies from other domains. You can check these in your browser security settings.
Other external services
We also use different external services like Google Webfonts, Google Maps, and external Video providers. Since these providers may collect personal data like your IP address we allow you to block them here. Please be aware that this might heavily reduce the functionality and appearance of our site. Changes will take effect once you reload the page.
Google Webfont Settings:
Google Map Settings:
Google reCaptcha Settings:
Vimeo and Youtube video embeds:
Privacy Policy
You can read about our cookies and privacy settings in detail on our Privacy Policy Page.
