### How to Generate Random Numbers in Excel (6 Simple Ways)

This tutorial covers generating random numbers in Excel. Using the RAND, RANDBETWEEN and RANDARRAY functions, and VBA, we will demonstrate how to generate random whole

### How to Add Leading Zeros in Excel (5 Super Easy Ways)

Have tried entering a code prefixed with a bunch of zeros only to find that not one zero made it through? That's Excel's manhandling for

### How to Calculate Months Between Two Dates in Excel

This tutorial will help you learn how to calculate the number of months between two dates in Excel. Our helpers will be the DATEDIF function,

### How to Track Changes in Excel (Easy Step-by-Step)

This tutorial will give you the ins and outs of Track Changes Feature in Excel. Everything from what Track Changes is and what it does,

### Highlight Entire Row in Excel With Conditional Formatting

Learn how to highlight rows in Excel with Conditional Formatting in this tutorial. We have detailed methods on highlighting rows according to text or numbers,

### How to Separate Numbers From Text in Excel (4 Easy Ways)

You will not be the first ones to have badly imported or badly managed data. One such example is text and numbers in the same

### How to Convert Date to Month and Year in Excel

In this tutorial, you will find how to get the month and year from a date in Excel. For certain reports, comparative data, and monthly

### How to Highlight Blank Cells in Excel (In 4 Easy Ways)

You're probably thinking that it is no big deal or maybe you're not, since you're here reading this guide. But of course, when the task

### How to Remove Formulas But Keep Values in Excel

Why would you need to keep the cell values and remove their formulas? Especially true for very busy and large worksheets, removing the formulas will

### How to Print an Excel Sheet on One Page

Your data looks great in Excel; you’ve used the perfect font styles, the right borders, and all that is Excel nifty. But the printer didn’t

### How to Make Negative Numbers Show Up in Red in Excel

We have 3 quick and easy ways for you today to have the negative numbers in your spreadsheets displayed in red. We’re using Conditional Formatting

### #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

## Excel Functions

### Excel TEXT Function – How to Use

The TEXT function in Excel converts numeric values to a text string. While you'll mostly be fiddling with numbers on an Excel sheet, you may

### Excel WORKDAY Function – How to Use

The WORKDAY function is categorized as a Date and Time function. It helps us add or subtract N working days to a date provided by

### Excel WEEKDAY Function – How to Use

The WEEKDAY function is a DATE and TIME function that can be used to find the weekday for a given date. The date is supplied

### Excel FILTER Function – How To Use

The FILTER function is an Excel function that lets you fetch or "filter" a data set based on the criteria supplied via an argument. The

### Excel OFFSET Function – How to Use

The OFFSET function is one of the most enigmatic Excel functions that may take a while to wrap your head around. But I will ensure

### Excel IF Function – How to Use

IF function is undoubtedly one of the most important functions in excel. In general, IF statements give the desired intelligence to a program so that

## 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