MUST KNOW Excel functions to SAVE LOADS of TIME!
There's a variety of functions in Excel to save time but I often find myself using these the most.
🔴 Don't forget to subscribe: / @transformita
✅ Connect on LinkedIn: / rajausmaanayub
Timestamps 🕐
0:00 Introduction
0:19 Moving columns
0:36 Sort and filter
0:58 Totals without typing
1:20 Navigating tables
1:46 Adding rows and columns
In this video I go over 5 Excel shortcuts or functions that will be useful for any person using Excel that wants to be more effecient and learn useful shortcuts to improve their workflow.
Excel shortcut 1: How to re-arrange columns in Excel? I'll show you how to re-arrange columns without having to insert a new column and then copying data
Excel shortcut 2: How to sort and filter your data in Excel? I'll show you how to create column filters and search data directly from your table with 3 clicks
Excel shortcut 3: How to do totals in Excel? I'll show you how to create row and column totals without having to write SUM and selecting your range.
Excel shortcut 4: How to navigate your tables in Excel? I'll show you how to navigate and select columns with ease in Excel without having to touch your mouse!
Excel shortcut s 5: How to insert columns and rows? I'll show you how to insert column and rows in Excel