The Basics of Excel: Part 1

This three-part series will focus on how to maximize functions in Microsoft Excel, set up database-like structures, and build various kinds of reports. By the end of this series, participants will be able to import text data, perform basic mathematical operations and character-based functions, sort and filter data, and utilize pivot tables.

Please note: Registration is required for each part of this series. See below for topics covered during each session and links for registration.

The Basics of Excel Part 1:

• Importing Text Data
• Text to Columns
• Cell Referencing
• Math Operations
• Basic Formulae
• Spreading Formulae
• Locking Reference
• Sorting and Filtering

The Basics of Excel Part 2:

• Vlookup
• Character-based Functions: concatenate, extracting substring (mid/left/right)
• If/Countif

The Basics of Excel Part 3:

• Pivot Tables
• Macros