## Highlight Cells Rules under Conditional Formatting in Excel

Highlight Cells Rules is a useful functionality in Excel. In this post, I’ll show you how to use the Highlight Cells Rules under Conditional Formatting in Excel. You can use Highlight Cells Rules to automatically highlight the cells that meet your defined rules. Let’s look at an example to better understand how you can benefit from using …

## How to use the IF function in Excel 2010

The IF function is a useful operation that you can perform in Excel. In this post’ I’ll show you how to use the IF function in Excel 2010. Structure of the IF function in Excel 2010 The IF function in Excel has the following structure: IF (logical_test, [value_if_true], [value_if_false]) Where: • logical_test is the logic …

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

A pie chart is a useful way to track and summarize your information in a graphical form. If you’d like to know how to create a Pie chart in Excel 2010, follow the steps below. The Data-set used to Create a Pie Chart in Excel 2010 In order to create a Pie chart in Excel …

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