These are a few tips and tricks in excel which I figured I should share. Some are more obvious and others not so and could potentially help anyone using the tool to reduce time while working with excel.

Part one: Excel tips and tricks Part I.

Photo by Campaign Creators on Unsplash

1. Row delimiting data in excel:

Very helpful when working with product attribute based data.

We all know how to delimit a column basis a special character but row delimit is very helpful when you have data that has multiple attribute, for example: you want to buy an iPhone 12 so you will check out all the different models available…


While working I used to wonder if there is a way we can create databases out of flat files or local excel files and perform query operations on them. After a bit of exploration I figured out a way we can do so and thought of documenting and sharing for anyone looking for the same.

Photo by Caspar Camille Rubin on Unsplash

The article is structured in the following way where I will go in detail about:

  1. The data we will be using
  2. The tool we will be using
  3. The process of importing the data into databases
  4. Starting up the query console
  5. Querying the database and the…


These are a few tips and tricks in excel which I figured I should share. Some are more obvious and others not so and could potentially help anyone using the tool to reduce time while working with excel.

1. IF statements:

This one is a pretty basic one.

Can be used to check for a condition but how I like to use it when I have a lot of rows and quickly need to see which rows meet a particular condition.

I first use create a condition and specify 1 for TRUE and 0 for FALSE.

Condition to check if the Col 8 has an odd number in the cell, if it does then return 1 else 0.

Then after dragging the formula across the…

Raghav Rama

Sometimes you gotta run before you can walk.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store