quick tips

## Add data labels to a chart in Excel – How to

The following lesson shows you how to add data labels to a chart in Excel. Since we use Excel on a Windows PC to complete this task, we suggest you do the same. However, you can still follow along on any operating system that has Excel. Introduction Data labels shows the value of a particular […]

## Add footnote to category label in Excel – How to

In this quick tip, we show you how to add a footnote to a category label in Excel. Also, we use Excel 2007 or higher, on a Windows PC, for this lesson. However, you can follow along on any system that has Excel. Steps to add footnote to category label in Excel Follow the steps […]

## Adding numbers in Excel – How to video

This quick video lesson is about adding numbers in Excel. For the purpose of this lesson, we use Excel 2007 or higher, on a Windows PC. However, you are free to follow along on any computer that has Excel. Video – Adding numbers in Excel As you see, in our list, all we did was, […]

## Basic math operators in Excel – How to

There are 5 basic math operators in Excel. The basic math operators in Excel Below is a table representing the basic operators in Excel. So, the operation and result columns are based on A1 equalling 6, and B1 equalling 2. Operator Meaning Operation Result + Addition =A1+B1 8 – Subtraction =A1-B1 4 * Multiplication =A1*B1 […]

## Change number format of value scale – How to

Overview This quick lesson shows you how to change the number format of a value on the y-axis of a column chart, in Excel. So, in the above chart, we want to change 200 to \$200, and keep all other values the same. Overall, we think that will add value to the chart, and make […]

## Change the value scale of a chart to improve view – How to

This quick tip shows you how to change the value scale of a chart to improve its view in Excel. Since we use Excel on a Windows PC to complete this task, we suggest you do the same. However, you can still follow along on any operating system that has Excel. Introduction So, this chart kind […]

## Customize quick access toolbar in Excel – How to

This quick lesson shows you how to customize the quick access toolbar (or QAT) in Excel. For the purpose of this tutorial, we use Excel 2007 or higher, on a Windows PC. Overview Although we use Excel as the learning app, you can use this method in any Office program that has a QAT. So, […]

## Make the plot area of your column chart better – How to

Introduction One way to make the plot area of your column chart better is by reducing the space between the columns. Overall, the vertical spacing of the above chart is great. So, all we really need to do is increase the width of the columns. Thus, we will improve the spacing of this chart, in […]

## Show developer toolbar in Excel – How to

This quick tip illustrates how to show the developer toolbar, in Excel. For the purpose of this lesson, we use Excel 2007 or higher on a Windows PC. However, feel free to follow along if you have Excel on a different type of system. Overview If you plan to do any kind of development in […]

## The OR() truth table in Excel – How to

This quick lesson illustrates the OR() truth table in Excel. For the purpose of this lesson, we use Excel 2007 or higher, on a Windows PC. If you are using another system, then feel free to follow along. Overview Before you go through this lesson, take a look at the tutorial on proving 0 is […]