Home / Excel
Category: Excel

Changing the Order of Operations in Excel Formulas

Excel's order of operations covers how Excel evaluates formulas containing more than one mathematical operator.

Read more

Here's How to Print an Excel Spreadsheet

Need to take your Excel spreadsheet offline? Learn how to print out your spreadsheet, or your entire workbook, for use without a computer.

Read more

Sum Cells that Meet Multiple Criteria with Excel SUMPRODUCT

Use Excel's SUMPRODUCT function to sum cell values that meet multiple criteria. A step by step example is included.

Read more

How to Wrap Text and Formulas on Multiple Lines in Excel

Learn how to use shortcut keys and menu options to wrap text and formulas on multiple lines in a worksheet cell or in the formula bar.

Read more

Learn to Generate Random Numbers With Excel's RAND Function

How to use Excel's RAND function to generate random numbers between 0 and 1, or another range, and truncating the results. Updated to include Excel...

Read more

How to Nest Multiple IF Functions in Excel

Learn to nest IF functions in Excel to increase the conditions tested for and the actions performed by the function. Updated to include Excel 2019.

Read more

Transposing Excel Data Turns a Spreadsheet Mess Into a Big 'ol Success

This guide will walk you through transposing Excel data, as well as flipping entire columns or rows, and even swapping individual cells.

Read more

Extract Text Characters With Excel's LEFT and LEFTB Function

Use Excel's LEFT and LEFTB functions to remove unwanted characters from imported data or to truncate existing text. Updated to include Excel 2019.

Read more

What's the Definition of the Serial Date in Excel?

The serial number in Excel calculates dates and times. There are two dating systems and you can switch between the two. Updated to include Excel 2019.

Read more

Finding Minimum Values in Excel is a Snap

Find the smallest number (fastest time, shortest distance, lowest temperature, etc) with Excel's MIN function. Updated to include Excel 2019.

Read more

How to Quickly Sum Data in Excel Using the DSUM Function

The DSUM function an Excel database function used add up or sum data that meets specific conditions that you set. Updated to include Excel 2019.

Read more

Use an Excel Data Form to Quickly Add Data to a Worksheet

The Excel data entry form simplifies the task of viewing, entering, editing, and searching data in large spreadsheets. Updated to include Excel 2019.

Read more

Learn About Count Records in an Excel Database

Excel's DCOUNT function is used to count the number of records in a database that meet the conditions that you set. Updated to include Excel 2019.

Read more

Great Tips for Entering Data Into Excel

There are dos and don'ts when working in Excel worksheets. Enter spreadsheet data correctly and avoid problems. Updated to include Excel 2019.

Read more

How to Use the Excel MODE Function to Find Averages

Use the MODE function in Excel to find the most frequently occurring value in a group of numbers in your spreadsheet. Updated to include Excel 2019.

Read more

Excel Watermark Step-By-Step Tutorial

Although there is no way to add a true watermark in Excel, you can insert an image to serve as a watermark in Excel. Updated to include Excel 2019.

Read more

This Excel Function Helps You Calculate Loan Payments and Saving Plans

Learn how to easily calculate loan payments or saving plans in your Excel spreadsheets with the PMT function. Updated to include Excel 2019.

Read more

Learn How to Zoom in Excel: Change Your Worksheet Magnification

Change your worksheet magnification in Excel using the zoom slider or shortcut keys on the keyboard for a better view. Updated to include Excel 2019.

Read more

How to Use Excel's DGET Function to Summarize Large Tables of Data

The DGET function is one of Excel's database functions. It counts records in a database that meet specific conditions. Updated to include Excel 2019.

Read more

Round Numbers to an Even Integer in Excel

Use the EVEN function in Excel to remove the decimal portion of values and round them to the nearest even integer. Updated to include Excel 2019.

Read more

Eliminate Duplicates in Excel and Keep Your Data Clean

Eliminate duplications in Microsoft Excel to keep your spreadsheets looking good and working better. There are a few ways to dedupe Excel data, but...

Read more

How to Use an Excel Timeline Template

How to use Excel's timeline templates to easily plot your projects, milestones, and more with only a few clicks. Updated to include Excel 2019.

Read more

Here are the Basic Excel Screen Elements

When you're familiar with the Excel screen and what the screen elements do, you'll produce spreadsheets effectively. Updated to include Excel 2019.

Read more

What's an Easy Way to Extract Data for Excel Pivot Tables?

When you find data that you want to use in an Excel pivot table, copy and paste the pivot table data into a new worksheet. Updated to include Excel...

Read more

Here's How to Find Multiple Fields of Data With Excel VLOOKUP

Learn how the VLOOKUP and COLUMN functions return multiple values from a row or record of data in an Excel spreadsheet. Updated to include Excel 2019.

Read more

Learn About the Dialog Box and Dialog Box Launcher in Excel

Learn about dialog boxes and dialog box launchers. Find out how they are used in Excel workbooks to give you control. Updated to include Excel 2019.

Read more

Here's How Text Strings Are Used in Excel

Understand the definition and use of a text string, also known as a string, in Excel and Google Spread. Updated to include Excel 2019.

Read more

Organize and Find Data Without Formulas Using Excel Pivot Tables

Pivot tables in Excel organize and extract information from tables of data without the need for complex formulas. Updated to include Excel 2019.

Read more

Latest 20