Do you need to create a table in Access in order to store and manage your data? In this post, I’ll show you how to create a table in Access 2010. To illustrate how to create a table in Access, we will review a simple example, where: (1) you are the owner of a store that sells …

## How to Multiply in Access 2016 using SQL

Do you need to multiply in Access? If you do, I’ll show you the full steps needed to multiply in Access 2016 using SQL. In the next section, I’ll review a simple example to illustrate the multiplication process. The Example To start, let’s say that you’re the owner of a store that sells office supplies. You …

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

Continue reading “Highlight Cells Rules under Conditional Formatting in Excel”

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

Continue reading “How to Add, Subtract, Divide and Multiply in Excel”

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

Continue reading “How to Link Multiple Tables in Access 2016”

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

Continue reading “3 Ways to obtain the Max Value in Excel 2010”

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