### How to Lock Cells in Excel – Protecting Excel Worksheets

Whether you are trying to steer clear of accidental overwrites, feeling fickle, or trying to protect some important data; all your reasons are good enough

### How to Remove Hyperlinks in Excel

Removing hyperlinks is no difficult feat and with a few simple clicks, you can restore your hyperlinks to simple text. There are a handful of

### Excel NETWORKDAYS Function – How To Use

The NETWORKDAYS function is a Date/Time function in Excel that computes the number of days between two given dates. The function automatically omits weekends while

### Excel SECOND Function – How To Use

The SECOND function is categorized as a DATE/TIME function in Excel. It extracts and returns the seconds component from a time as a value between

### Count If Cell Is Not Blank (COUNTIF Not Blank or Not Empty)

This is going to be a super simple post, here our aim is to find the number of cells that contain data, cells that are

### Excel DATEDIF Function – How To Use

The DATEDIF function is categorized as a DATE/TIME function in Excel. The function name almost gives away its purpose. It calculates the difference (DIF) between

### Excel HOUR Function – How To Use

The HOUR function is categorized as a DATE/TIME function in Excel and extracts the hour component of a time. It returns a value between 0–23.

### Excel Shows Formula Instead of Result (How to Fix)

Select cell, equal sign, type formula, enter. Now it’s one thing to write a formula that triggers an error, but to see the formula do

### Excel MINUTE Function – How To Use

The MINUTE function in Excel is categorized as a DATE/TIME function. It extracts the minute component from a time and generates an output that's always

### How to Add a Total Row in Excel Table

In this tutorial, you will learn how to add a Total Row to an Excel table. If you’re wondering what Total Rows and Excel Tables

### How to Create, Use, Edit and Delete Named Ranges in Excel

Names are one convenient identity. Imagine how we'd be addressed if we didn't have names? Excel tries to make our lives easier by providing us

### How to Sort By Date in Excel

When you have a large data set to analyze, it’s often helpful to sort the dates in chronological order. Of course, Excel has some built-in

## Formula Errors

### #N/A Error In Excel – How To Fix

Sometimes, when you’ve used a bunch of lookup tables on your Excel sheet, you might spot a #N/A error. The #N/A error is typically associated

### #NAME? Error In Excel – How To Fix

The #NAME? error is a common Excel error because it’s easy to make mistakes that can cause the #NAME? error. In most cases, you’ll be

### #DIV/0! Error In Excel – How To Fix

When you’ve done some computations on your Excel sheet, you sometimes look at the whole thing later and find that one of the cells has

### #NUM! Error In Excel – How To Fix

The #NUM! error is a frequent visitor on your worksheet. This can make you want to pull your hair out if you’ve used the output

### #REF! Error In Excel – How To Fix

Say you’ve got this worksheet from a couple of months ago ready to work with. You pull it up on your computer and start working.

### #NULL! Error In Excel – How To Fix

The #NULL! error is less common than other errors like #VALUE! or #NUM! errors. The error is basically Excel telling you that you’ve supplied an

## How To's

### How to Insert, View, Move And Remove Page Breaks in Excel

If you feel your data is crowding the page it is to be printed on and dividing the data would help with clarity, you can

### How to Lock Cells in Excel – Protecting Excel Worksheets

Whether you are trying to steer clear of accidental overwrites, feeling fickle, or trying to protect some important data; all your reasons are good enough

### How to Create, Use, Edit and Delete Named Ranges in Excel

Names are one convenient identity. Imagine how we'd be addressed if we didn't have names? Excel tries to make our lives easier by providing us

### How to Find and Fix Circular References in Excel

A circular reference occurs when you end up having a formula in a cell – which in itself uses the cell reference (in which it’s

### Excel Flash Fill – How To Use

What is Excel Flash Fill, and more importantly, what is so special about it? Flash Fill is a special tool in Excel that can automatically

### How to Insert a Checkbox in Excel (In 5 Easy Steps)

Inserting a checkbox in Excel is an easy task. The checkbox control is available in the Excel developer tools option. Checkbox and other controls like dropdowns can

## Calculations

### How to Calculate Business Days in Excel (3 Easy Formulas)

Where are you from? Are you a TGIF person or is your Saturday spirit drowning somewhere behind the office walls? The most common understanding of

### How to Calculate Years of Service in Excel (3 Easy Ways)

Finding out the years of service of employees may come with their resignation. The intent may be to find out the employment duration or to

### How to Calculate Weighted Average in Excel (2 Easy Formulas)

We all know how averages work, right? Means or averages are easily calculable and represent a central value. That's all fine for regular numbers but

### How to Calculate Square Root in Excel (4 Easy Ways)

Hello there citizen of Excel town! Here's a brainwave. Have you ever thought about getting Excel to do what you have been doing for a

### How to Square a Number in Excel (In 5 Different Ways)

The aim is simple. Squaring a number, a number raised to the power 2, the number multiplied by itself; it's all the same thing, you