9 secret things you can do with MS Excel to grow your business

Priya Mahindroo
mojoVerse: The Business Weekly
2 min readDec 16, 2020

MS Excel is one of the most underestimated and misunderstood software in this world. On a day when you are loaded with unorganised data, there is just one unsung hero who comes to your rescue — MS Excel.

Do you know business owners spend over 50% of their time organizing and analyzing data?

Most people perceive this software to be a tabular sheet software, where you can key in the information in rows and columns.

But truth is quite opposite!

The software is much more than just a data segregation tool used for calculations, formulas, graphs and tables.

You would be surprised to know that you can create digital art and stop-motion animation, and recreate iconic games like Sudoku, Tetris and Pacman.

Most of all, you can manage business with MS Excel!

Here are some secret things that can help you become a pro at using MS Excel for you business growth:

  1. Extract bank account nos. from narration
  2. Clean data using Excel’s Power Query
  3. Analyze ledger data using Pivot Table
  4. Clean Tally data to analyze it better
  5. Convert Dr-Cr to plus-minus in Tally data
  6. Format Form 26AS TDS Sheet
  7. Save time in general formatting issues
  8. Remove Passwords from Protected Sheets
  9. Perform 2-way reconciliation of two lists

In case you are wondering how and where to learn these 9 secret things, here’s a secret we’d like to share with you.

You can learn all about these secrets in an MS Excel Analytics course, free of cost, curated by WorkReady, hosted on our e-learning platform — mojoVersity.

Sign up for your free MS Excel Analytics course! Save time and cost by learning to take care of basics on your own. After all, for every business owner time is money!

Follow mojoVerse for more updates and hacks to start, manage and grow your business.

--

--