Excel

Data Analyst vs Data Scientist

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.

 

Excel Hack: Using the DATE functionalities

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

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

Let us see how we can find that:

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

Excel Automation: Creating an Index sheet in a Workbook

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?

Visualization Charts in Excel

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.

Excel productivity hack - Navigating between sheets

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!

Filter Function for Data Analytics - with Examples

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.