How to Impress Your Boss With 7 Shortcuts in Excel
Here are more than 7 amazing shortcuts and ideas to showcase your Excel data in meetings and impress your boss! See filtered data easily, find formula errors, auto-sum, find the top or bottom most data.
Timestamps:
00:00 Excel Intro
00:07 Select entire table (Ctrl a)
00:18 Convert to Table (Ctrl t)
00:29 Add Filters (Ctrl Shift L)
00:39 Add Filter Slicer
01:23 Autosum (Alt =)
01:35 Top 3 and Lowest 3 in a range (=LARGE or =SMALL)
02:04 F4 to add dollar signs $ so the range doesn't move
03:07 Tracing formulas (Ctrl [ and Ctrl ])
03:36 Show all formulas (Ctrl ` )
03:54 Trace Formulas with arrows (Alt t u t)
04:22 Create Pivot Table (Alt n v t)
⭐️ AMAZING 52 Project TOOL Templates in Excel and PowerPoint ready-made and ready to use here: https://www.etsy.com/listing/11998005...
➡️ Get Project Management Plan templates in PowerPoint and Word ready-made for you here: https://www.etsy.com/listing/16580064...
✅ The BEST PMP Course - get 35 PDUs plus 500 PMP Practice Questions: https://www.udemy.com/course/ultimate...
🚀 The BEST Agile Course - get 21 PDUs plus 200 Practice Questions: https://www.udemy.com/course/the-grea...
Watch video How to Impress Your Boss With 7 Shortcuts in Excel online without registration, duration hours minute second in high quality. This video was added by user David McLachlan 16 August 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,137 once and liked it 129 people.