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