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…
Excel 2013
Creating Basic Formulas Part 3: Division
Excel formulas can simplify the essential mathematical operations of addition, subtraction, multiplication, and division. In Part 2 of this series, we covered creating basic multiplication…
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 Pivot Tables: Using Slicers to Filter Data
Are you looking for a way to filter your Excel pivot tables quickly? If so, then you need to learn about slicers! Slicers are a…
Excel Pivot Table Tips: Refreshing the Table After Source Data Changes
The pivot table in Excel is one of the most vital and versatile tools available. It allows you to look at your data from a…
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…
Excel Date Calculations Part 1: Finding the Difference Between Two Dates
Excel has several built-in date functions you can use to quickly find important information. These are known as Excel date calculations. Today, we will focus…
Excel Data Validation: An Introduction
Excel data validation allows you to set specific criteria for the type of data that can be entered into a cell or group of cells.…
Excel Rank Function: What is It & How to Use It
One of Excel’s advanced functions is the RANK function. This formula is used to rank numbers in a dataset by either ascending or descending order.…