Excel Ninja Technique
1.Drop-Down List
Excel has many different options but, a drop-down list always helps you to enter data quickly. Here I show how to create excel Drop-down List
2. Name Manager
Name manager is used to jump any specific cell or cell range in excel by entering the name of the cell. Generally, we type cell address in the name box to go specific part, but the name manager has the ability to make any cell or cell range with our name.
Name manager is also used with the VLOOKUP function. We all know VLOOKUP needs table arguments. Sometimes Table are huge. Name manager gives the name to the table. It's will help you a lot.
3. Gradient Chart Color
We all are familiar with charts in excel like - columns, pies, bars, etc. Usually, we create charts & charts appear by their default color. You can enhance the change look by changing color to the gradient. Here is how you can do this
4. Lock Cell
We don't want to lose our data. That's why excel has an amazing feature called lock cell to prevent data losses & security. Here is how you can lock cells in excel.
5. Quick Format
Making the excel sheet more professional, we use color, border,s, etc. But, the excel table quickly give all format & save your time.