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

30 Excel tips and tricks covering a wide range of tasks, from inserting data into Excel from screenshots to creating stunning charts, and automating repetitive tasks with VBA. ✅ Earn More & Fast Track Your Career: https://go.launchexcel.com/macros-vba-school-youtube ✅ Get weekly tips to learn Advanced Excel: https://go.launchexcel.com/email-signup-youtube *Watch more videos* 1. Top 50 Excel Shortcuts from Beginner to Advanced https://youtu.be/iGdzvurKGHA 2. Link every worksheet to a Master Sheet in Excel (VBA) https://youtu.be/G7SOJvtUUrc 3. Highlight Active Row & Column in Excel (VBA) https://youtu.be/2bWObFD_CEI *Click here for the article:* 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.* *Get weekly email tips and be more productive.* Join here: https://go.launchexcel.com/email-signup-youtube *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-workbook-name-only *Learn how to set up and use your Personal Macro Workbook:* https://www.launchexcel.com/excel-personal-macro-workbook *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