How to move lines in Excel

You can watch a video tutorial here. When working in Excel, you may need to move lines to change the order of the data or to make the sheet easier […]

How to remove leading zeros in Excel

While working with numeric data in excel, specially with phone numbers, we often see the numbers with leading zeros with the numbers. There might arise a requirement when you have […]

How to count number of months between two dates in Excel

The best way to understand how DATEDIF works is to first understand the structure of the function and the parameters it requires. Structure of DATEDIF The standard syntax of countif […]

How to resolve #Spill! in Excel

One of the most amazing features added into Microsoft Office 365 and Excel 2021 is dynamic arrays. So, now if a formula returns multiple values then its results will span […]

How to use Not Equal <> in Excel

Excel provides a variety of operators to check various logical conditions and Not equal is also one of those operators which can be used to check whether a value is […]

How to compare data from two worksheets in Excel

When you are working with small data files in Excel and you are asked to compare data within two different versions of the same file then it can be an […]

How to use CTRL+E (Flash Fill) Command in Excel

Flash Fill (CTRL+E) is an amazing tool in Excel that can reduce the time required to fill in data points while we are working with large data files. However, Flash […]

How to enable dark mode in Google Sheets on Desktop

When we are working with Google Sheets at night time, the total white background becomes very stressful for our eyes and creates a lot of strain on our eyesight. Unfortunately, […]

How to use excel help

How to fix Excel Formulas not showing results in Excel

Sometimes, while working in Excel we feel that the software has started behaving in a weird way. One such case could be when you open up a worksheet (working fine […]

How to use ISTEXT Function in Excel

Sometimes, we have a lot of data rows in the Excel dataset and we encounter a situation where we need to know the type of the data that is contained […]

How to Paste values using VBA in Excel

Microsoft Office provides support for programmers who like to automate their tasks through programming. Visual Basic for Applications also known as VBA is the programming language for Microsoft Office Applications, […]

How to fix type mismatch VBA error in Excel

In this tutorial we’ll learn why the “type mismatch” error occurs in VBA and how to fix this error through simple modifications in code.  Reasons for type mismatch Error This […]

How to use AVERAGEIF function in Google Sheets

If you are looking for Microsoft Excel’s online replacement then Google Sheets is the next best choice. It has almost all the functionalities in terms of functions and formulas as […]

How to capitalize all letters in Excel

In this tutorial we will learn how to change the case of letters by using specific formula. There is a formula to capitalize all the letters. This formula changes all […]