Excel

Data is the new oil and a lot of new job profiles revolve around it. This is a trend that is hard to reverse in the near future. There are two job profiles in this domain that seem to cause some bit of confusion in our minds. Most people wonder “What is the difference between a Data Analyst and a Data Scientist?” Let us help to resolve this query here.

Every date on an Excel sheet can be converted into its corresponding number.

For example, the number 1 represents the date January 1, 1900

Let us see how we can find that:

Let us say we have the number 1 on a cell in Excel.

You may have worked on an Excel workbook with just 3 or 4 worksheets in them.

In those workbooks, navigating between worksheets is relatively easy.

Right?

Microsoft Excel can be a great tool for visualization purposes. There are some very powerful charts functionalities inbuilt in Excel, that can be used to depict numbers visually.

Let us look at some of those interest charts that are already available to use at the click of a button.

In one our earlier blogs, we discussed how to create an Index/TOC sheet in an Excel workbook.

Don’t recall? No worries, read it again here.

Got it now. Great!

The Filter function is a newly introduced function in Microsoft Excel 365. It is not available in earlier versions of excel. In earlier versions, Filtering of large data sets was done manually.