5 shortcuts that will make analyzing data a little bit easier:
1. ALT =
Let Excel do the math for you with this shortcut! ALT = detects data in adjacent cells and automatically sums it using the SUM function. Just select an empty cell adjacent to the data that needs to be added and press ALT =.
Let Excel do the math for you with this shortcut! ALT = detects data in adjacent cells and automatically sums it using the SUM function. Just select an empty cell adjacent to the data that needs to be added and press ALT =.
2. CTRL H
Finding values in your workbook and replacing them one by one could take hours, but not with CTRL H. The CTRL H shortcut opens the find and replace dialog box, which finds a value and replaces all instances with a new specified value.
Finding values in your workbook and replacing them one by one could take hours, but not with CTRL H. The CTRL H shortcut opens the find and replace dialog box, which finds a value and replaces all instances with a new specified value.
3. CTRL T
Start getting into the routine of using Tables with CTRL T. CTRL T converts data to an Excel Table. Tables are a powerful tool that cleans up formatting, auto-fill formulas down columns, automatically expand and update linked charts when new rows are added, and more!
Start getting into the routine of using Tables with CTRL T. CTRL T converts data to an Excel Table. Tables are a powerful tool that cleans up formatting, auto-fill formulas down columns, automatically expand and update linked charts when new rows are added, and more!
4. ALT F1
If you spend too much time creating charts to visualize your data, meet ALT F1. These two magical keys automatically generate a bar chart using the selected data and insert it right into the active worksheet!
If you spend too much time creating charts to visualize your data, meet ALT F1. These two magical keys automatically generate a bar chart using the selected data and insert it right into the active worksheet!
5. CTRL SHIFT L
Make analyzing large data sets a little easier with the CTRL SHIFT L shortcut. CTRL SHIFT L adds the Sort&Filter toggles to the top row of the data set, so you can quickly sort and filter data.
Make analyzing large data sets a little easier with the CTRL SHIFT L shortcut. CTRL SHIFT L adds the Sort&Filter toggles to the top row of the data set, so you can quickly sort and filter data.
To learn all of Excel’s shortcuts and productivity hacks like this, make sure to sign up for my new course! #excel
Sign up here 👇🏼education.morningbrew.com
Sign up here 👇🏼education.morningbrew.com
Follow me @exceldictionary for even more Excel tips and tricks.
And if you never want to forget my excel tips at your desk, check out my shortcut merch and ebooks.
shop.morningbrew.com
And if you never want to forget my excel tips at your desk, check out my shortcut merch and ebooks.
shop.morningbrew.com
جاري تحميل الاقتراحات...