Category Windows

Excel Formulas and Functions

Excel Formulas and Functions Featured Image

Excel formulas and functions are two words that you may have heard a lot during the Excel learning process. Those words are sometimes used interchangeably, this is why they might be confusing at times. Do not worry we are here…

100 Useful Microsoft Excel Shortcuts

Microsoft Excel Shortcuts Featured Image

Excel Shortcuts. In the journey of learning Microsoft Excel, we learn a lot of functions and keywords. We learn several techniques to handle and manipulate data. It will be really helpful if we learn to use shortcuts. So here I…

What is VLookup in Excel and How to Use it?

vlookup featured image

Vlookup. Today we will talk about Vlookup in excel and why do we use it. Many of you who have recently started learning Microsoft Excel, are very curious about this topic. What is Vlookup? Vlookup is a function in Microsoft…

Easily Removing Duplicates in Excel 2019

removing duplicates in excel Featured Image

Removing Duplicates in Excel. Today we will talk about how to remove duplicates in the Microsoft Excel spreadsheet. The version of Microsoft Excel that I am going to use in this article is Micorosft Excel 2019. Let us start. In…

How to Add Data Bars in Excel?

How to Add Data Bars in Excel Featured Image

Bars in Excel. In our last article when we discussed How To Do Conditional Formatting In Excel, today’s chapter is about how to add data bars in excel. The data bars in Excel also come under the conditional formatting option.…

How to do Conditional Formatting in Excel?

How to do Conditional Formatting in Excel Featured Image

When we start learning Microsoft Excel, we get to learn a lot of formulas and tricks. Being a beginner one thing that excited me a lot was ‘how to do Conditional Formatting in Excel’. As a beginner, I used to…

What is Goal Seek in Excel and How to Use It?

What is Goal Seek in Excel and How to Use It Featured Image

What is Goal Seek in Excel? This question is a frequently asked question in Microsoft Excel interview. Today we will talk about this question. After reading this article I am sure you will be able to answer this question easily…