2022 TPP Seminar Program

MICROSOFT EXCEL TRAINING FOR TPP

Monday, December 5th

Time

Topic

8:30 AM

Introduction & Setup

8:50 AM

Best Practices

9:30 AM

Formula Review/Foreign Values/Dropdown Lists

10:30 AM

Break

10:45 AM

Logical Functions/Lookup Functions/Error Checking

12 Noon

Lunch

1:00 PM

Complex Functions

1:45 PM

Rules for Naming/Defined Names/Formula Protection

2:15 PM

Conditional Formatting/Advanced V - Lookup

3:00 PM 3:15 PM

Break

Data vs. Reports/Using Tables for Data

4:45 PM

Conclusion for the Day

Tuesday, December 6th

Time

Topic

8:30 AM

Welcome & Recap

8:45 AM

Data Normalization

9:15 AM

Introduction to Power Query

10:00 AM

PivotTables

10:30 AM

Break

10:45 AM

Designing PivotTables/Get Pivot Data Functions/Filters & Slicers

12 Noon

Lunch

1:00 PM

Using Excel as a Database

1:45 PM

Power Query Data/Scraping Data from Web

2:15 PM

Conditional Formatting/Advanced V - Lookup

3:00 PM

Break

3:15 PM

Custom Formulas/Lookups and Joins

4:45 PM

Conclusion for the Day

APPROXIMATE SCHEDULE—SUBJECT TO CHANGE.

3