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...
Смотрите видео How to Impress Your Boss With 7 Shortcuts in Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь David McLachlan 16 Август 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,137 раз и оно понравилось 129 людям.