1. KEYBOARD SHORTCUTS
CTRL + V: For Paste
CTRL + C: FOR Copy
CTRL + Z: For undo your last action
CTRL + Arrow Keys: For navigate each of the data ranges from bottom to up and from left to right
CTRL + shift + L: For applying or removing the filters
2. AUTO FILL
Auto fill used for the data which will filled automatically. If you write Monday, then Tuesday will be automatically filled in the next row. If you fill 1 will fill 2 in the next row automatically. it will fill the series of data in just one click.
3. BASIC FORMULAS
Formulas like
SUM(A1:A10): Will give the sum of all the data from A1 cell to A10 cell
AVERAGE(A1:A10): Will give you avarage of the dat filled in cell A1 to A10
VLOOKUP(A1,VALUE, TABLE,COLUMN,[RANGE]): will search for the specific value from the table
IF(A1>100,"YES","NO"): It is the condition if the value of the cell A1 is higher than 100 will return YES otherwise it will return NO
Understanding these formulas will give you strong foundation
4. CONDITIONAL FORMATTING
Conditional formatting is used for visualizing and highlighting your data as per the condition you apply
Home>Style>Conditional Formatting
5. FREEZE PANES
Which will freeze the first row or the first column. If you are working with a large data set, you need to see the what is in the first column and first row. These will have very very helpful for the large database.
You can access it from View>Freeze Panes
6. FILTER
Filter will help you to filter out the specific data. It will sort and view specific data. If you have a large data set and you want to see the specific data this will help you. It is very easily to find out the specific data
Home>Editing>Sort & Filter
7. EXCEL TABLES
Excel tables will formatting your table automatically, and making it filtering or sorting easily and making formulas for dynamic ranges. Will use for working with frequently updated data.
To convert your data in to table use CTRL + T
8. PROTECT YOUR WORKSHEET
After making your worksheet. You don’t allow other people to see or to edit the sheet. You can protect your sheet by using a password
Review>Protect sheet
9. REMOVE DUPLICATES
Remove duplicate means you have a bunch of data large data and you want to delete some specific duplicate entry or duplicate values. You can use remove duplicate It will remove the duplicate data and clean up the data
Data>Remove Duplicates
10. SAVE TIME WITH TAMPLATES
In Microsoft excel some of the built in free templets are available about calendar, budget, financial etc. It will save your time and customization is also available
File>New
We hope this post will help you to understand and expand your excel knowledge
By mastering this 10 Excel tips, you become very confident and can do work very efficiently and fast
No comments:
Post a Comment