@launchexcel

❤ Chapters in this video:
00:00 Introduction to Excel Secrets
00:22 Tip 1: Insert Data from a Screenshot
01:43 Tip 2: Sum Values Fast Three Different Ways
02:57 Tip 3: Toggle Filters On and Off
03:26 Tip 4: Fast Filter Trick
03:43 Tip 5: Center Text Across Cells
04:44 Tip 6: Cell Message
05:26 Tip 7: Freeze Top Row
06:11 Tip 8: Freeze Top Row with Table
06:47 Tip 9: Freeze Bottom Row
07:16 Tip 10: Print Headers on Every Page
07:59 Tip 11: Move Cells with Mouse
08:36 Tip 12: Copy Cells with the Mouse
09:00 Tip 13: Copy Only the Visible Cells
10:09 Tip 14: Delete Blank Records
10:59 Tip 15: Fill Blank Cells
11:34 Tip 16: Fill Numbers to the Nth Value Using a Series
12:12 Tip 17: Fill Dates to the Nth Value Using a Series
12:50 Tip 18: Flash Fill Numbers
13:47 Tip 19: Flash Fill Letters
14:42 Tip 20: Smart Use of Clipboard
15:40 Tip 21: Quick Bar Chart with the REPT Function
17:28 Tip 22: McKinsey Lollipop Chart
22:36 Tip 23: Display File Path and Workbook Name
24:18 Tip 24: Hide Cell Contents from View
25:28 Tip 25: Center Text Across Cells with VBA
27:13 Tip 26: Remove Cell Formats
28:42 Tip 27: Filter Function, Single Criteria
29:33 Tip 28: Filter Function for Multiple Criteria
31:27 Tip 29: Create New Sheets from Values in a List Using a Pivot Table
33:25 Tip 30: Create New Sheets from Values in List Using VBA

Click here for the article with full VBA code:
https://www.launchexcel.com/top-30-excel-tips-and-tricks-2024

Download the Free Excel Workbook
Step 1: Sign up for free: https://go.launchexcel.com/email-signup-youtube
Step 2: Log in here: https://courses.launchexcel.com/dashboard/en/login
Step 3: Download: https://courses.launchexcel.com/school/course/workbook-downloads/lecture/5074882#headline-44a5e8d5

TIP: Stay logged in for quick access to all FREE workbook downloads.

@thwbn2508

A perfect tutorial with great choice of tipps, presented in a great layout!
Thanks a ton!

@orumeemmans8289

Thank you so much,
Really learned alot.
You actually A great Teacher,  the Explanations are perfect

@richardricka.remeikis268

I started my "PC programmer" career a a Lotus spreadsheet guy for THE boss, and spent several years at that before "graduating" to mainframe programming... but my heart always belonged to Lotus (sigh)
Now retired, I keep my "hand in" by making worksheets (Excel, Libre & Goog Sheets).
Stumbled on this video while looking for something else -- and, half way in, this is the neatest 20 minutes I've spent on line in a while,
LOVE IT!
I might have to subscribe - just to see what else I don't know!

@EgasBritesdaSilva

very informative tips and tricks for my works, thanks for sharing, greetings from Timor Leste

@mmerritt1844

Thanks!

@tiffanynguyen40

Thank you! I love your videos. You are very detail and easy to follow.

@pongpang13

thank you so much, it really works

@Aus_266

You're My Real Master

@maeregassuyohann6677

Great, thank you very much

@thoando113

Thanks Chan, very useful

@GosCee

Nicely done! Great tips. Thank you for sharing.

@power-reconcile

Amazing tutorial, thanks!

@ChristopheTourneret

It's very well done, thank you very much

@SagrenNaidoo-um4yz

Thank You

@TanerToker

Awesome video, thanks a lot

@Olesia_Dolzhenkova

Aweeeesome, thank you for your video. It was very detailed and nice explained 😎

@sukantacomputerengr

good tutorial

@Govinda7995

Very Helpful. Thank you!

@debbielaubscher4983

Brilliant! Thank you Victor.