## How to Apply Conditional Formatting in Excel

In this short guide, I’ll show you how to apply Conditional Formatting in Excel. The Example Let’s suppose that you have the following 5 by 5 matrix, which contains the grades of 25 students: 60 65 85 75 90 45 80 35 80 65 90 25 65 20 70 85 95 60 40 60 70 30 …

## How to Add, Subtract, Divide and Multiply in Excel

There are different arithmetic functions that you can execute in Excel. In this short guide, I’ll show you how to add, subtract, divide and multiply in Excel. Before we start, let’s look at the symbols that represent the basic arithmetic functions in Excel: The ‘+’ symbol is used to add/sum values The ‘-‘ symbol is used to …

## How to Link Multiple Tables in Access 2016

Suppose that you created multiple tables in Access and now you want to link them together. In this tutorial, I’ll show you how to link multiple tables in Access 2016. In particular, I’ll review an example to show you how to link the following 4 tables: Clients Orders Products Shipping Your 4 tables in Access Let’s …

## 3 Ways to obtain the Max Value in Excel

In this short tutorial, I’ll review 3 ways to obtain the Max value in Excel using the: MAX formula AutoSum Insert Function The Example For simplicity, let’s pick the following set of numbers: 22, 55, 38, 79, 63 The goal is to find the maximum value in Excel using each of the 3 methods above. …

## How to Create a Pie Chart in Excel (with example)

Need to create a pie chart in Excel? If so, I’ll show you the steps to create a pie chart using a simple example. By the end of this short guide, you’ll be able to create the following chart: Steps to Create a Pie Chart in Excel Step 1: Gather the data for the pie …

## 4 Ways to Sum Values in Excel (with examples)

There are different ways to sum values in Excel. In this short guide, I’ll show you 4 ways to sum values: Within a single cell Across multiple cells Using AutoSum Using the Insert Function Sum Values within a Single Cell To start with a simple example, let’s suppose that you’d like to sum two numbers …

## How to Link Tables in Access using an Inner Join

There are few ways to link tables in Access. In this short guide, I’ll show you how to link tables in Access using an Inner Join. In general, an inner join can be used to obtain all the records (i.e., rows) from the linked tables, where a common value exists in both of the tables.  …

## How to Import an Excel File into Access

In this guide, I’ll show you how to import an Excel file into Access. Here are the steps you may follow: Steps to Import an Excel File into Access Step 1: Prepare the Excel File To start, prepare the Excel file to be imported. For example, I stored the following data in an Excel file: …

## How to Create a Pivot Table in Excel

Pivot table is a powerful tool that can help you summarize and organize your data in an efficient manner. In this guide, I’ll review a simple example with the steps needed to create a pivot table in Excel. Example of a Pivot Table in Excel To start, let’s say that you have a small company …

## How to Create Columns in Access (example included)

In this short guide, I’ll show you the steps to create columns in Access. In particular, I’ll show you how to create 3 columns: The first column would contain the First Names of 5 individuals The second column would contain their Last Names The third column would contain the Age of those individuals Steps to Create …