What are some popular ways of using Microsoft Excel?

Rajesh Pathak

I can list some of the popular ways, but there are many other ways of using Excel efficiently for different purposes:

Highlight data in many ways using Conditional Formatting.
Restrict entry of data in worksheet using Data Validation
Creating drop down list through data validation and using that in Vlookup formula.
Using Pivot table/Pivot Chart/Slicer/Timeline
Using Go to Special and Paste special
Using functions and formulas
Using flash fill and auto fill
Using custom formatting
Using data visualization techniques
Using what if analysis
Using Power BI