12 Excel productivity hacks to make your life easier
In this video we'll take a look at some various was to be more productive in excel, how to handle common situations people encounters-- plus a few cool hacks 😁
There is no learning progression for this video, since you may already know some of the topics covered, so feel free to jump around using the timestamps below. And if I may, number 7 (using names for two-way lookups) is my favorite. 😝
⌚**TIMESTAMPS**
0:00 Intro
0:20 Faster ways to select data
0:48 Move columns with click and drag
1:18 Resize messy columns and rows (2 methods)
1:57 Move between sheets using keyboard
2:10 Show all formulas and evaluate them
2:42 Using names
3:42 Doing two way look-ups with names
4:31 Showing large numbers in "M" and "B"
5:02 Importing data from the web
5:56 Using Integrated AI
6:34 Fix numbers stored as text (might be worth the price of admission 😂)
7:04 Using ALT = with some cool twists
📄 *RESOURCES*
Mega Excel Keyboard Shortcut List
https://view.flodesk.com/pages/63bf31...
Quick Reference Guide
https://view.flodesk.com/pages/63bf2f...
☕ ** BUY ME A COFFEE? **
https://www.buymeacoffee.com/professo...