Attend FREE Webinar on Data Science for Career Growth Register Now

Author Archive

Introduction to DAX Functions in Power BI | Power BI DAX Functions

Introduction to DAX Functions DAX stands for Data Analysis eXpressions. It is basically a language that is used to calculate or analyse existing data (similar to Microsoft Excel functions). Sure, you can analyse data as-is by using charts and other such tools, but sometimes it is necessary to carry out calculations to understand better. For […]

Read More →

MS Excel Glossary: The Ultimate List of All Microsoft Excel Glossary of Terms

There are many times when we stumble upon Excel Terminology that looks like complete jargon. At other times, there are words that are completely misunderstood or misused when it comes to Excel. This MS Excel Glossary can be used like an Excel Dictionary. This Microsoft Excel Glossary is not intended to be comprehensive, but the […]

Read More →

Top Excel Interview Questions and Answers to Crack Job Interviews

Excel Interview Questions and Answers When you are interviewed for a job, there is a high possibility of Microsoft Excel interview questions and answers being asked. To help you prepare, we will cover a few basic Excel interview questions and answers,  and even some advanced Excel interview questions and answers. Q1.) What is the difference […]

Read More →

What is Conditional Formatting and 5 great Tips on it

Introduction to Conditional Formatting When someone refers to the Formatting of a cell it means they are referring to the colors, fonts, borders, alignment, etc. of the cell. When a conditional format is applied on a cell it means the formatting of the cell is based on a condition. Why would you need this? Let’s […]

Read More →

Slicer Controlled Interactive Excel Charts | Excel Slicer

We all have some or the other time used Charts in Excel, but always struggle with when it comes to growing data. Once the data starts growing, we want to see the effect of the growing data into the chart immediately without having to do any manual settings every time. Plus, we want to be […]

Read More →

Auto Filter and Advanced Data Filtering in Excel

Filtering data simply means seeing limited data. The other data that you do not want to see doesn’t get deleted or doesn’t change in anyway, it just gets hidden. Why would you want to filter data? If you have thousands of rows of data, it’s going to be difficult to locate part of the data […]

Read More →

What is What-If-Analysis in Excel and how is it used

What-if-analysis in Excel is a tool in Excel that helps you run reverse calculations, sensitivity analysis and scenarios comparison. Decision making is a crucial part of any business or job role. When you can take decisions, which are informed based on data, the outcome of the business or project or task is always more in […]

Read More →

15 Useful Excel Functions for a Data Analyst

The primary job of a data analyst is to make sense out of raw data. Excel has a number of tools to help with this. In this post, we will focus on useful functions towards this purpose. These functions are categorised into different sections like statistical, logical, financial, etc. We will look at a few […]

Read More →

Data Cleaning Features in Power BI

Data cleaning is utmost important for any kind of data before you can make sense out of it and generate reports. Let’s say you get a ton of data which is extremely inconsistent in spaces, Mumbai is spelt as “Mumbai”, “Mum bai”, “ Mumbai”, “Mumbai  ”, “M Mumbai”. All these 6 different spellings of Mumbai […]

Read More →

How to Use Data Validation in Excel

What is the use of Data Validation in Excel? It’s an amazing feature to control and restrict data entry being done by the user in multiple different ways. For example, using Data Validation in Excel you can allow entry of data in a particular column called City, by only allowing to choose from a drop-down. […]

Read More →