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

## How to use VLOOKUP in Excel 2010

VLOOKUP is a powerful function in Excel that can save you a lot of time in managing your data… In this post, I’ll show you how to use VLOOKUP in Excel 2010. Why use the VLOOKUP function in Excel? VLOOKUP can help you connect/associate data that exists in two (or more) separate tables. To illustrate, …

## 3 Ways to obtain the Max Value in Excel 2010

There are different ways in which you can obtain the Max value in Excel, given a set of values… In this post, I’ll show you the following 3 ways that you can use in order to obtain the Max value in Excel 2010: (1) Using the MAX formula (2) Using the AutoSum under the ‘Home’ tab (3) …

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

There are different ways to sum values in Excel. In this post, I will show you 4 ways to sum values in Excel 2010 using the following methods: (1) Sum values within a single cell (2) Sum values in multiple cells (3) Sum values using AutoSum (4) Sum values using the ‘Insert Function’ Sum values …

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

There are few ways to link tables in Access 2016… In this post, I am going to show you how to link tables in Access 2016 using an Inner Join. An Inner Join is used to obtain all the records (i.e., rows) from the linked tables, where a match exists between the tables. What do …

## How to Import Data into Access 2016

Need to import data into Access 2016? If so, in this post, I’ll show you the steps to accomplish this goal. In particular, I’ll demonstrate how you can import your data from external sources such as Excel. The data to be imported into Access 2016 Let’s say that you store the following information about your …

## How to Create a Column Chart in MS Excel 2010

Need to create a Column Chart in MS Excel? There is an easy way to do it in Excel. In this post, I’ll show you how to create a Column chart in MS Excel 2010. But before we begin, you’ll need a data-set that will be presented in your Column Chart. I created the following …

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

Need to create columns in Access for your table? In this post, I’ll show you how to create columns in Access 2016. But before we start, you’ll need to open a table that you’ve already created in Access. For more information about how to create a table, visit our post about How to Create a Table in …