❤️ Top 30 Excel Tips and Tricks to save 30+ hours of work
✅ Earn More & Fast Track Your Career: https://go.launchexcel.com/macros-vba...
✅ Get weekly Excel VBA tips to be more productive. Join here: https://go.launchexcel.com/email-sign...
Master Excel VBA to save hours at work. Click here: https://go.launchexcel.com/macros-vba...
Get weekly Excel VBA tips to be more productive. Join here: https://go.launchexcel.com/email-sign...
Watch more videos
1. Top 50 Excel Shortcuts from Beginner to Advanced • ❤️ Top 50 Shortcuts in 30 Minutes
2. Link every worksheet to a Master Sheet in Excel (VBA) • Link every worksheet to a Master Shee...
3. Highlight Active Row & Column in Excel (VBA) • Highlight Active Row & Column in Exce...
Click here for the article:
https://www.launchexcel.com/top-30-ex...
Download the sample workbooks with full VBA code in a ZIP file:
https://d1yei2z3i6k35z.cloudfront.net...
Tip 22: McKinsey Lollipop Chart Characters
Start ▌ https://symbl.cc/en/258C/
Line — Windows Emoji picker (WIN + .)
End ● Windows Emoji picker (WIN + .)
Tip 23: Formula for Workbook Name
https://exceljet.net/formulas/get-wor...
Learn how to set up and use your Personal Macro Workbook:
https://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
❤️ 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