Excel Tips: Don't use Text Formulas! Use Flash Fill (CTRL + E)!

Don't use Excel Text Formulas! Instead how about using Flash Fill (Ctrl + E)

Let's face it, working with text in excel can sometimes be a pain, and might require typing a complicated text formula.

In this video we'll show you a feature that's been around for years, and surprisingly a lot of people still don't know about it.

It's called the Flash Fill, and it's versatile, and super simple to use.

⌚ *TIMESTAMPS*
0:00 Working with text in excel can be no fun
0:16 Intro to the Flash Fill
0:22 Overview of text functions-- Concatenation and RIGHT, LEFT, SEARCH, MID, FIND
1:05 Why use Flash Fill
1:47 Using Flash Fill -- 9 examples
4:30 Limitations with the Flash Fill
5:26 So, are text functions obsolete?

📢* FREE RESOURCES*

Mega Excel Keyboard Shortcut List
https://view.flodesk.com/pages/63bf31a4e59dcde5cc3b1717

Quick Reference Guide
https://view.flodesk.com/pages/63bf2fb230bfef80b54fa47e

☕*BUY ME A COFFEE?*
https://www.buymeacoffee.com/professorcubs
~~~~~~~~~~~~~~~~~~~
*ABOUT PROFESSOR CUBS*

🏆 My goal is to help you learn popular software apps so you can be more productive, save time in life, so you can spend it on activities that matter.
Some of the app tutorials include:
- Microsoft Excel, Power BI, PowerPoint, OneNote, Word, Tableau, Audacity, Reaper and other popular software applications

🎓 My background: 25+ years in corporate training teaching both software and business skills, along with working in the financial business. Degree in Finance, along with a list of certifications that would bore you to tears.

🚀 I remember first learning technology, how confusing and overwhelming it can be. So I strive to make things simple, easy and fun.

Thanks,
Professor Cubs

Видео Excel Tips: Don't use Text Formulas! Use Flash Fill (CTRL + E)! канала Professor Cubs