en | de
Worldwide Content
Aug 6, 2022 12:00 AM

MrExcel's Favorite Excel Tricks & Tips - 2022

Microsoft's program does just about everything one could ask for in a spreadsheet. Become the office Excel guru in no time with these hacks and tricks.

Consider how to make your dashboard practical as well as attractive now that you've built it and added some tiles. It often refers to making the most crucial information stand out and keeping everything organized and simple.

Table of Contents

  • (0:00) Historical re-enactment
  • (0:20) Data description
  • (1:00) Begins typing
  • (1:38) Adding text is #VALUE error
  • (1:57) & to Concatenate
  • (2:10) FORMULATEXT function
  • (2:36) Adding a space while joining text
  • (3:09) Needs Proper Case
  • (3:38) 500 functions in Excel
  • (3:50) PROPER function
  • (4:20) 5-Step way to copy
  • (5:10) Hello YouTube viewers
  • (6:00) Excel in Olympics Joke
  • (6:33) Excel on ESPN
  • (7:10) Dragging Fill Handle is a drag
  • (8:24) Double-click Fill Handle
  • (8:42) Blank cell in adjacent column
  • (9:21) 3 Ways to Undo in Excel
  • (9:35) Right-Drag to Paste Values
  • (9:50) Alternate Drag and Drop
  • (10:10) ESPN versus Olympics
  • (10:29) I bought a commercial on ESPN8
  • (10:47) Ocho-themed deals
  • (11:10) Promo Codes Woes
  • (11:40) Buy from Amazon in USA
  • (12:05) Buy e-Books
  • (12:20) Liam Bastick Financial Models in Power BI
  • (12:45) Wyn Hopkins Power BI for Excel Analyst
  • (13:05) Mike Girvin Only App That Matters
  • (13:25) Oz & Bill new Edition
  • (14:05) Courses on Retrieve

  • NewsContent Type
  • Aug 4, 2022First published
  • 1 minReading Time
  • EnglishArticle Language