1. Remove Duplicates
Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates. Click Okay.
This is a great tip to use when you need to extract the unique values of data from a spreadsheet of many rows of data. For example, you have an Excel file with customer information data and you want to see which states you have reached. With just 3 clicks in Excel, you can remove the duplicate values from the ‘State’ column and quickly see all the states that you have customers. Ta-da!
2. Spell Check
Have you ever found yourself frustrated at the lack of auto-spell check within Excel? Well turns out it does exist! Press F7 and Excel will scan your spreadsheet for any spelling errors. This is a life-saver for those employees that are required to deliver reports to managers in an Excel format.
3. Freeze Top Row
On the View tab > Window > Freeze Top Row.
Do you find yourself working with large sets of data within Excel? It is easy to forget the name of the column you are looking at. This will keep the header row visible while you scroll to another area of the worksheet.
4. Wrap Text
On the Home tab, in the Alignment group, click Wrap Text.
5. Filter
Select Data > Filter. Select the column header arrow to start filtering!
An Excel essential is filtering columns of data to quickly and easily drill down your data to see insights. How many customers do we have in California? How many sales did we have in May of last year? Or even a combination of filters that could tell us how many sales did we have in May of last year from California. The options are endless when it comes to filters!
Basic Tips for Excel
If you’re simply starting out with Excel then those hints can save you lots of time and permit you to get higher quickly in ordinary duties.
Here are few tips that will help you to do your work quickly.
Select All:- Ctrl + A
Current Date and Time:- We can easily add current Date and Time in any cell by just using this simple shortcut in Excel
Ctrl + ; :- To Date
Ctrl + Shift + ; :- To add Current Time
Ctrl+N:- Create a new workbook in Excel
Ctrl+O:- Open an existing workbook in Excel
Ctrl+S:- Save a workbook in Excel
F12:- Open the Save As dialog box in Excel
Ctrl+W:- Close a workbook in Excel
Ctrl+F4:- Close Excel
F1:- Open the Help pane in Excel
F4:- Repeat the last command or action. For instance, if the last thing you typed in a cell is “Book,” or if you change the font color, clicking another cell and pressing F4 repeats that action in the new cell.
Shift+F11:- Insert a new worksheet in Excel
Ctrl+Z:- Undo an action in Excel
Ctrl+Y:- Redo an action in Excel
Ctrl+F2:- Switch to Print Preview in Excel
Alt+Q:- Go to the “Tell me what you want to do” box in Excel
F7:- Check spelling in Excel
F9:- Calculate all worksheets in all open workbooks in Excel
Shift+F9:- Calculate active worksheets in Excel
Alt or F10:- Turn key tips on or off in Excel
Ctrl+F1:- Show or hide the ribbon in Excel
Ctrl+Shift+U:- Expand or collapse the formula bar in Excel
Ctrl+F9:- Minimize the workbook window in Excel
F11:- Create a bar chart based on selected data in Excel
Alt+F1:- Create an embedded bar chart based on select data in Excel
Ctrl+F:- Search in a spreadsheet, or use Find and Replace in Excel
Alt+F:- Open the File tab menu in Excel
Alt+H:- Go to the Home tab in Excel
Alt+N:- Open the Insert tab in Excel
Alt+P:- Go to the Page Layout tab in Excel
Alt+M:- Go to the Formulas tab in Excel
Alt+A:- Go to the Data tab in Excel
Alt+R:- Go to the Review tab in Excel
Alt+W:- Go to the View tab in Excel
Alt+X:- Go to the Add-ins tab in Excel
Alt+Y:- Go to the Help tab in Excel
Ctrl+Tab:- Switch between open workbooks in Excel
Shift+F3:- Insert a function in Excel
Alt+F8:- Create, run, edit, or delete a macro in Excel
Alt+F11:- Open the Microsoft Visual Basic For Applications Editor in Excel
Left/Right Arrow:- Move one cell to the left or right in Excel
Ctrl+Left/Right Arrow:- Move to the farthest cell left or right in the row in Excel
Up/Down Arrow:- Move one cell up or down in Excel
Ctrl+Up/Down Arrow:- Move to the top or bottom cell in the column in Excel
Tab:- Go to the next cell in Excel
Shift+Tab:- Go to the previous cell in Excel
Ctrl+End:- Go to the most bottom right used cell in Excel
F5:- Go to any cell by pressing F5 and typing the cell coordinate in Excel
Home:- Go to the leftmost cell in the current row in Excel
Ctrl+Home:- Move to the beginning of a worksheet in Excel
Page Up/Down:- Move one screen up or down in a worksheet in Excel
Alt+Page Up/Down:- Move one screen to the right or left in a worksheet in Excel
Ctrl+Page Up/Down:- Move to the previous or next worksheet in Excel