Page Title

September Wednesday Excel Series

  • Published on Aug 27, 2020
  • by Kristie Ondracek, CPA, CGMA

Join us for an Excel Series each Wednesday in September from noon-12:50 pm. This series will help accounting professionals maximize often-used functions. Each week’s information will progress to a higher level. Register for all of the sessions or select those that fill your knowledge gaps. 

It will be split into two parts during the time. The topics to be covered are:

9/2/2020 Register Here

Part 1 - Spreadsheet Navigation and Formatting

Part 2 - Simple Formulas (SUM, Subtotal, MAX, AVERAGE, MIN, Subtracting)


9/9/2020 - Register Here

Part 1 - Reference functions (DATE, TEXT, RIGHT, LEFT, MID)

Part 2 - Pivot Tables (Overview & Troubleshooting)


9/16/2020 - Register Here

Part 1 - SUMIFS

Part 2 - VLOOKUP


9/23/2020Register Here

Data Normalization: Remove Duplicates / Flash Fill (build off week 2 to show how you can efficiently populate fields)/Text-to-Column (names, locations, etc [FIND/SEARCH]


9/30/2020Register Here

Part 1 - Comprehensive example to walkthrough

Part 2 - Highlight any other uncovered items

Guest speakers will be providing materials prior to the class. Come learn more about Excel and increase your knowledge. 

DETAILS

  • September Wednesday Excel Series
  • Noon - 1 p.m.
  • Complimentary Live Webinar
  • 1 FREE CPE Credit

For more information, contact cpe@houstoncpa.org.