SmartTalks - October 2022 Excel Tips and Tricks

Our monthly SmartTalks meeting in October covers the power of Excel:

New Excel Functions:

• TextBefore
• TextAfter
• TextSplit
• vstack
• hstack

How to Add and Edit Rich Text Formatting

How to use the Multiline formula bar

How to Pin and Save File Location

Why Xlookup is better than vlookup

When to use IFS rather than IF

How to make sure you leverage the Aggregate Function properly

What shortcuts are worth memorizing

‍

‍