Like any application, Excel comes with basic tips and tricks to help you carry out various functions. But before we get into details, let’s understand how and why MS- Excel is so useful. To begin with, it is a powerful tool that cuts across all stages of data handling -

Yesterday’s lesson was all about mining relevant insights from your processed data. But what if you want to share your data in a beautiful, palatable format with others? In fact, any business analysis is pointless if there are no action items to follow up on! But since the action lies with teams that are not involved in analysis & data processing, the data needs to be presented in a format that facilitates action items.

Today we move on to the next stage of data handling: data analysis. While analysis will depend on various factors, there are some great tools that aid the analysis process either by processing the data faster & more accurately than manual effort, or by undertaking several steps that seem daunting, if done manually.

Now that you know how to name your data, you are ready to start processing your data. Once we have the data cleaned & organized, we need to process it in ways that will allow us to draw insights from it. Let’s assume that you wish to buy a white shirt made of linen, with a price range between 800 INR to 1500 INR. Let’s head over to Flipkart so that you can buy this shirt. Once you log in, what do you do next? You apply filters for clothing, shirts, colour and price range. This process helps you get a list of white shirts from different brands and at different price ranges. Doesn’t this make your purchasing process quicker and easier?

Become and excel ninja and unlock the power of spreadsheets.