Caption

1. Ctrl + Shift + L - Filter Instantly add/remove filters to quickly find the data you need. 2. Ctrl + Arrow Key - Jump through data Move instantly to the edge of a data range instead of scrolling forever. 3. Ctrl + Shift + Arrow - Select data Select an entire row/column of data in seconds. 4. Alt + = - AutoSum Automatically add a SUM formula without manually typing it. 5. F4 - Repeat / Lock references Repeat your last action or add `$` to lock cell references in formulas. 6. Ctrl + E - Flash Fill Automatically recognize patterns and fill the rest of your data for you. 7. Ctrl + 1 - Format Cells Open the formatting menu instantly instead of right-clicking through menus. 8. Ctrl + Shift + $ - Currency format Instantly format numbers as currency, especially useful for financial analysis. Follow @ananyamentors for more job and corporate tips. Save this & send this to a friend! #job #corporate #corporatelife #careercoach #jobs