2022-11-27 18:00

2024-12-29 0:19

Building a Better Spreadsheet - Excel Tips and New Features

Shawn will cover the benefit of HLookup over VLookup. Shawn also gives an update on the newest features from Excel and covers his favorite hotkeys. XMatch is a new function that Shawn will show exactly how to use it. He also will cover the new decision function IFS vs IF.

https://cdn.prod.website-files.com/6733a3411808260faf1d287d/675c20f0f42cc350aef3a834_6733a3411808260faf1d35e3_6384d6787c42c41fcd7eea41_excel2.png

https://www.cs3technology.com/resource/smarttalks-october-2022

https://youtu.be/cXRuUI53Dkg

0:47:53

Blog

Webinar Recording

Sucess Story

Article

Technical Article

Video Insight

Trade Show

Webinar

Tutorial

Video Demo

SmartTalks - October 2022 Excel Tips and Tricks

Join us on

November 28, 2022

Registration Subscribe

Event Details

Price:

$

USD

Location:

Virtual

Address:

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

‍

Author

Shawn Slavin

Contractor & Trusted Advisor

Shawn Slavin is the co-founder and Vice president of CS3 Technology. Shawn is the master of business process improvement. He has diverse skill that include hardware infrastructure, business software an accounting.

https://www.linkedin.com/in/shawnslavin/

https://www.cs3technology.com/employees/shawn-slavin

sslavin@cs3technology.com

Video

SmartTalks

Excel Tips