How to Count Blank Cells in Excel – 3 Easy Ways
The only thing worse than wrong data in your spreadsheet is Empty Cells. If these blanks aren’t filled, they can cause problems when using formulas. I usually fill these empty cells with 0 or “NA”…
Why use dollar sign ($) in Excel formulas – absolute and relative cell references
When creating a formula in Excel, many people get confused by the $ symbol in cell references. But it’s actually very simple. The dollar sign in an Excel cell reference tells Excel whether to keep the reference the same or allow it to change when you copy the formula to other cells. This guide will explain how it works and why it’s helpful.
Understanding Excel cell references is really important. Knowing the difference between absolute, relative, and mixed references will help you get the most out of Excel formulas and functions.
View Two Worksheets Side by Side in Excel – 2 Easy Methods
View two worksheets Side-by-Side in Excel lets you view multiple worksheets at once in layouts like vertical, horizontal, tiled, or cascade, so you don’t have to keep switching between sheets. You can also split a…
How to Print Row Header on Each Page in Excel – 3 Easy Ways
Print Row Header on Each Page in Excel means that when you print your worksheet, the selected row (often the top row with column headers) will repeat at the top of every printed page. This ensures…
Excel Hyperlink: how to create, change and remove
This tutorial shows you three easy ways to add hyperlinks in Excel. You will learn how to insert, change, and remove hyperlinks in your worksheets. It also explains how to fix links that don’t work.
Hyperlinks are often used on the internet to move between websites. In Excel, you can create links like that too. You can make a link to another cell, a different sheet, or even another workbook. You can also link to open a new Excel file or start an email message. This guide will show you how to do all of this in Excel 2016, 2013, 2010, and older versions.
Circular reference in Excel – how to check, find, enable, or remove
If you need to keep This quick guide explains what Excel circular references are and why you should be careful when using them. You’ll also learn how to check for, find, and remove circular references in Excel worksheet.a circular reference, it will show you how to turn on and use circular formulas safely
You tried to enter a formula in your Excel sheet, but it’s not working. Instead, Excel is showing you a message about a circular reference. Is that why you’re here? 🙂
Thousands of people run into this issue every day because they accidentally make an Excel formula try to calculate its own cell. When this happens, Excel gives the following error message:
How to Group Worksheets in Excel – 3 Easy Methods
Group worksheets in Excel makes it easier to manage a big workbook. This feature allows you to treat multiple worksheets as one, helping you perform identical tasks like formatting or data entry across several sheets…
Advance Filter in Excel – how to create and use
This guide explains the basics of Excel’s Advanced Filter and shows you how to use it to find records that match one or more complicated conditions.
If you’ve read our previous guide, you know that Excel’s regular filter offers different options for filtering text, numbers, and dates. These options work well for many situations, but not all. When the regular filter isn’t enough, you can use the Advanced Filter to set up custom criteria that fit your exact needs.
Excel’s Advanced Filter is especially useful for finding data based on two or more complex conditions. For example, you can use it to find matches and differences between two columns, filter rows that match another list, or find exact matches with the same uppercase and lowercase letters.
Advanced Filter is available in all Excel versions from 365 to 2003. Click the links below to learn more.
How to convert CSV file to Excel (open or import)
This tutorial shows how to quickly change CSV files into Excel in any version, from 365 to 2007, without common problems.
There are two main ways to move a CSV file to Excel: by opening it directly or by importing it as external data. This article gives step-by-step instructions for both methods, explains their pros and cons, and highlights potential problems with tips to fix them
How to Undo in Excel – 3 Easy and Quick Ways
Undo in excel very useful If you’re new to Excel or even if you’ve been using it for a while, you’ve probably made a mistake on a spreadsheet. Mistakes happen a lot, especially when working…
How to Remove Password from Excel – 2 easy methods
While passwords in Excel help protect data, there are times when you may need to remove them to make changes, like modifying the workbook structure or editing data. This tutorial explains six methods to remove…
How to mail merge from Excel to Word
This step-by-step guide will show you how to easily do mail merge in Word using an Excel sheet.
Mail Merge can save you a lot of time when you need to send letters or emails to many people. It helps you create personalized letters, emails, or labels in Word by combining the information from your Excel sheet. This guide gives an overview of the main steps and explains how to do a mail merge from Excel in an easy way
How to color alternate rows in Excel: highlight every other row
This tutorial shows you how to change the row colors in Excel to automatically highlight every other row or every nth row or column in your worksheets. You will also learn how to use Excel’s banded rows and columns and find some helpful formulas to shade rows based on value changes.
Using alternating colors for rows in Excel is a common way to make data easier to read. While it’s simple to manually highlight rows in a small table, it can be very time-consuming in larger tables. A better approach is to automatically alternate the colors of rows or columns, and this article will show you how to do it quickly
Turn Off Scroll Lock in Excel – 4 Easiest and Quick Ways
Scroll Lock in Excel can make scrolling, selecting cells, checking formulas, entering data, and recording macros harder. So, you might need to turn it off to work normally. In this article, we’ll show you how…
Excel Nested IF statement: examples, best practices and alternatives
This guide shows how to use the nested IF function in Excel to check several conditions. You will also learn about other functions that can be to use than a nested formula.
When you want to make decisions in Excel, you often use an IF formula. It checks if something is true, then gives one result if it is and another result if it isn’t. If you need to check more than one thing, you can put many IFs inside each other.
Although using multiple IFs is common, it’s not the only way to check several conditions in Excel. This guide will introduce you to some easier and useful alternatives.
Correlation in Excel: coefficient, matrix and graph
This tutorial teaches the basics of correlation in Excel. It shows how to find a correlation coefficient, make a correlation matrix, and understand the results.
Correlation is one of the easiest calculations you can do in Excel. Even though it’s easy, it helps a lot in understanding how two or more things are related. Excel has all the tools you need to do a correlation analysis—you just need to know how to use them
Lock a Column in Excel – 3 Easy and Simple Methods
Microsoft Excel lets you share your spreadsheets with others, but sometimes your co-workers might edit the wrong column by mistake. To avoid this, you can lock specific columns. In this guide, we’ll show you how…
How to create external reference in Excel
This quick tutorial explains the basics of external references in Excel and shows how to reference another sheet or workbook in your formulas.
Excel logical operators: equal to, not equal to, greater than, less than
Many tasks in Excel require comparing data in different cells. To do this, Excel offers six logical operators, also known as comparison operators. This tutorial will help you understand how these operators work and how to write efficient formulas for data analysis
How to Add New Line in Excel Cell – 4 Easy Methods
Add new line in Excel cell lets you type on multiple lines within the same cell. Instead of having all the text in one long line, you can split it up to make it easier…
How to calculate NPV in Excel
In this guide, you will learn how to use the NPV function in Excel to calculate the net present value of an investment and how to avoid common mistakes when using NPV in Excel.