## Merge and Manipulate Multiple Excel Sheets like a Pro

Working with multiple Excel sheets is common for many spreadsheet users. However, managing and consolidating data across worksheets and workbooks can be tedious and time-consuming…

## Automatically Adding Serial Numbers in Excel

Serial numbers are an essential part of many datasets because you can use them to identify specific entries in your sheet. Adding them manually can…

## VLOOKUP, HLOOKUP, and XLOOKUP Formulas Part 3: XLOOKUP Formula

The XLOOKUP function is relatively new, and it was introduced to provide solutions for some of the issues that commonly occur when using the VLOOKUP…

## VLOOKUP, HLOOKUP, and XLOOKUP Formulas Part 2: HLOOKUP Formula

HLOOKUP is a function that Excel users can key in to look up and retrieve data from a specific row in a table. This function…

## VLOOKUP, HLOOKUP, and XLOOKUP Formulas Part 1: VLOOKUP Formula

VLOOKUP is a relatively common Excel function that aims to simplify locating a specific piece of information located within a spreadsheet. For example, if you…

## Reviewing Formulas and Functions Part 3: COUNT in Excel

Most working professionals want to save time when writing reports and copying data into spreadsheets, yet worrying about making mistakes can slow progress to a…

## Reviewing Formulas and Functions Part 1: SUM in Excel

Mastering Excel formulas can make a world of difference for working professionals. Not only does using formulas save time, but it also ensures that the…

## Creating Basic Formulas Part 2: Multiplication

Addition, subtraction, multiplication, and division are essential mathematical functions that can be made easy by using Excel formulas.  In Part 1 of this series, we covered…

## Creating Basic Formulas Part 1: Addition and Subtraction

Excel can be intimidating for people who have just been introduced to the program, but basic mathematical functions are relatively easy through Excel when you…

## Excel Date Calculations Part 2: Setting Sequential Dates

Excel offers a variety of ways to perform date calculations. In part 1 of this series, we showed you how to find the difference between…