Basic Data Analytics in Excel Workshop

This fast-paced interactive workshop will allow short periods for you to apply the techniques hands-on. Participants will enter virtual breakout rooms to work through Excel examples together with David's assistance. David will be answering questions throughout the sessions. Live attendance is a must to get the most out of this engaging training opportunity. Breakout rooms will not be recorded. Space is limited to 30 participants for a high-value learning experience, so register today!

May 8, 2024
May 9, 2024
Presented by David Ringstrom
2h 30m total length
$850.00 or 3 Tokens

Includes: 30 Days OnDemand Playback, Presenter Materials and Handouts

  • Computer Skills
  • Information Technology/Security
  • Branch Manager
  • Commercial Lender
  • Community Reinvestment Act Officer
  • Compliance Officer
  • Consumer Lender/Retail Banker
  • Controller/Accountant
  • Credit Analyst
  • Internal Auditor
  • IT Professional
  • Loan Closer
  • Loan Operations Manager/Specialist
  • Marketing Officer/Business Development
  • Mortgage Lender
  • Privacy Officer/Information Security Professional
  • Small Business Lender
  • Training Manager
  • Trainer
  • Trust Officer
  • Workout Specialist/Collector

Save on annual training costs with our Webinar Subscription Service and share webinars across your entire organization.

Become a subscriber

Learn about upcoming events, webinars and discounts.

Sign Up For Email Notifications

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.

David Ringstrom

Instructor Bio

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David's mantra 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. To learn more about David, you can view his LinkedIn profile and follow him on Facebook or Twitter (@excelwriter).