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

## How to Create a Table in MS Access 2016

In this guide, I’ll show you the steps to create a table in MS Access 2016. I’ll also review how to delete a table that is no longer needed. By the end of this guide, you’ll be able to create the following table in Access: ID Client First Name Client Last Name  1 Jon Smith …