❤️ Top 30 Excel Tips and Tricks to save 30+ hours of work

Learn 30 powerful Excel tips and tricks that will save you time and simplify your work. ➡️ Click to show more
This video covers solutions to the most common Excel challenges, helping you work smarter not harder.
From inserting data from screenshots and summing values quickly, to filtering data with advanced techniques and creating visually impressive charts like McKinsey lollipop charts - this video has it all.
You'll also discover how to freeze panes, repeat row headers on every printed page, move/copy cells with just your mouse, use the REPT function for bar charts, display full file paths, hide cell contents, and much more.
Plus, learn efficient ways to center text across cells, remove cell formatting, create new sheets from a list of names (using both pivot tables and VBA), and add handy buttons to your Quick Access Toolbar - all with step-by-step instructions.
Get ready to supercharge your Excel skills and impress everyone with your newfound expertise!
➡️ Tip 22: McKinsey Lollipop Chart Characters
Start ▌ symbl.cc/en/258C/
Line - Windows Emoji picker (WIN + .)
End ● Windows Emoji picker (WIN + .)
➡️ Tip 23: Formula for Workbook Name
exceljet.net/formulas/get-wor...
➡️ Learn how to set up and use your Personal Macro Workbook:
www.launchexcel.com/excel-per...
➡️ Tip 25: VBA Code for Center Across Selection
Sub Center_Across_Selection()
With Selection
.HorizontalAlignment = xlCenterAcrossSelection
End With
End Sub
➡️ Tip 26: VBA Code for Center Across Selection
Sub Remove_Formatting()
With Selection
.ClearFormats
End With
End Sub
➡️ Tip 30: VBA Code to Add Sheets from List
Refer to article for full VBA code
🅰️ Click here for the article:
www.launchexcel.com/top-30-ex...
🅱️ Download the sample workbooks with full VBA code in a ZIP file:
d1yei2z3i6k35z.cloudfront.net...
❤️ Chapters:
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
🚀 BEST EXCEL RESOURCES
Launch Excel Macros & VBA School:
Say Goodbye to Tedious Manual Work and Automate Your Way with Excel VBA. Our course helps you to learn Excel VBA and save hours of time every week even if you have zero prior experience with programming.
➡️ www.launchexcel.com/shop
Excel Dashboards: Learn how to make killer dashboards in Excel. They will set your skills apart from the crowd. Invest in your data reporting and presentation skills.
➡️ go.launchexcel.com/moth-dashb...
Explore 100+ Excel Templates: Save time and streamline your workflow. Here is a selection of over 100 spreadsheet templates. They cover Accounting, Finance, Data Analysis, HR, Operations, Project Management, Real Estate, Sales & Marketing, Small Business, and Management.
➡️ www.launchexcel.com/best-exce...
🚀 Ready to launch your Excel skills into orbit?
Subscribe to the Launch Excel channel for more stellar Excel tips and tricks! And check out our website www.launchexcel.com for in-depth tutorials.

[@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:* www.launchexcel.com/top-30-excel-tips-and-tricks-2024 *🅱️ Download the sample workbooks with full VBA code in a ZIP file:* d1yei2z3i6k35z.cloudfront.net/2762499/6634dbb85b136_Top-30-Excel-Tips-and-Tricks.zip

[@Olesia_Dolzhenkova]

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

[@launchexcel]

Glad you liked it!!

[@sumardjo]

Waoooo Thanks very much for sample file I have follow your video thanks very much

[@launchexcel]

Glad you liked the video and sample file!

[@jayeshkmodi3207]

Very nice presentation

[@launchexcel]

Thanks @jayeshkmodi!

[@IvanCortinas_ES]

Excellent tutorial. Thank you!!!

[@launchexcel]

Thanks @ivancortinas5427!

[@Hafiz_Ibrahim]

Thanks For such a informative video

[@launchexcel]

You're welcome, I'm glad you found it informative!

[@debbielaubscher4983]

Brilliant! Thank you Victor.

[@launchexcel]

Thanks for watching and commenting!

[@goodman-it2qy]

Thanks your valuable expertise share with us.

[@launchexcel]

It's my pleasure!

[@LadyOkere]

Thank you 🎉

[@launchexcel]

Glad you found this helpful!

[@mmerritt1844]

Excellent tips!

[@launchexcel]

I'm glad you found them helpful

[@wallywechs4694]

Powerful

[@launchexcel]

Yes, and you'll become more powerful after you master these tips 😄

[@mmerritt1844]

Thanks!

[@launchexcel]

Thanks for watching! 👍

[@exploreyourexcel]

You are awesome

[@launchexcel]

Thanks!

[@mehamada1]

insert from picture not exist in excel 2016 what excel version you use?

[@launchexcel]

Thanks for the question. I think get data from clipboard / picture works for Excel with an Office 365 subscription, sorry it doesn't work for Excel 2016. For those who use Excel 365, you also need to make sure you go to Excel > Preferences > Privacy and make sure optional connected experiences is enabled.