The 90 minute “Tips and Tricks” webinar will cover a variety of topics to introduce some of Excel’s most powerful and useful features to improve performance, save time, and build smarter spreadsheets.

Topics include:

Using Excel’s hotkeys and other functions to be more efficient in preparing spreadsheets

• Working quickly and efficiently with hotkeys and accelerator keys
• Eliminating manual “point and click” work by using Excel’s powerful selection tools like Go-To and Paste-Special
• Automating repetitive typing (i.e. adding dates to rows or columns) using Flash Fill
• Working with large and complex sheets using Excel’s “View” tools to your advantage

Working with different kinds of data in Excel- beyond just numbers!

• Using Dates in Excel, including calculations such as number of days/months/years between any two dates
• Working with Text in Excel

Key formulas for smarter spreadsheets- build spreadsheets that return data from a predefined list based on an input, or instantly evaluate if something meets a predefined criteria (such as a KPI)

• VLOOKUP
• IF, SUMIF, and Conditionals

Analyzing data using Excel- summarize large datasets instantly, without using formulas!

• Analyzing datasets using Filter, Advanced Filter, Conditional Format
• PivotTables- summarize big datasets how you want, quickly and easily

Date: Tuesday 07/21/20
Time: 3:00 pm to 4:30 pm (Question and Answer session to follow)
Presenter: Matt Russell, CPA - Supervisor, MarksNelson LLC
Cost: $25 for members and $75 for non-members

A zoom link will be emailed to everyone who registers on 7/20/20.