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/2020 - Register 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/2020 - Register 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.