Category Windows

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…

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…

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…

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…

Delete blank rows in excel. We use blank rows to make our data look clean. However, they can be irritative when exporting your data in some database management software such as Microsoft Access. There are so many ways to delete…

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.…

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? 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…

How to Change the Case in Excel? While using Microsoft Excel, this will be a good thing to know how to change the case in Excel by the formula. If you know it then you don’t need to worry about…