## Add an Average Line to a Column Chart – Tutorial

This tutorial shows you how to add an average line to a column chart in Excel. An average shows you what a typical value may be in a data set. In this lesson, we may also use the word “mean” to refer to the average. We use Excel 2016 for the purpose of this tutorial. […]

## Add Footnote Markers to Category Labels – Tutorial

This lesson shows you how add footnote markers to category labels on a chart in Excel 2010 or higher or compatible. And, you may not even need to touch the chart to achieve this task. We may refer to footnote as reference or just ref in this instruction. Process to Add Footnote Markers to Category […]

This quick tip shows you how to add items to quick access toolbar, QAT for short. The QAT is available in multiple Office applications. It provides you with a way to access commands you use often. And, it is separate from the ribbon. Meaning, if you click on a different ribbon, your commands will remain […]

## Create a Basic Column Chart in Excel – Tutorial

This tutorial shows you how to create a basic column chart in Excel. For the purpose of this lesson, we used Excel 2016. However, you should be able to follow these steps in Excel 2007 or higher. Steps to Create a Basic Column Chart Follow the steps below to create a column chart. Step 1: […]

## Create a Basic Macro in Excel – Tutorial

This lesson shows you how to create a basic macro in Excel. A macro is simply a set of steps to complete a task. Steps to Create a Basic Macro in Excel Follow the steps below to create a basic macro in Excel. Step 1: Display Developer Tab Click on Developer, from the menu bar […]

## Creating List Box Items in Excel – Tutorial

This Excel tutorial shows you the steps to creating list box items. In our case, for all the months in a year. Creating List Box Items Creating list box items in Excel is an excellent way to improve the user experience. It provides them with the ability to control what they see on the screen. […]

## Edit a Basic Macro in Excel – Tutorial

This lesson shows you how to edit a basic macro in Excel. Before you go through this tutorial, check out creating a basic macro in Excel first. As always, you can still follow along. Steps to Edit a Basic Macro in Excel Follow the steps below to edit a macro in Excel. Step 1: Open […]

## Find the Version of a Software App – Quick Tip

This quick tip shows you how to find the version of a software app. For most programs, it is the same or very similar process. Basically, all you need to do is find the help menu. After that, just select the “About…” option under the help menu. That is all to it, but we will […]

## Insert a Shape in an Excel Spreadsheet – Quick Tip

This quick tip shows you how to insert a shape on an Excel spreadsheet. In this lesson, we will use the circle as our shape. For the purpose of this instruction, we use Excel 2016. Steps to Insert a Shape in Excel Start a new file (Ctrl-N) and follow the steps below to insert an […]

## Link a Cell to a Shape in Excel – Quick Tip

This quick tip shows you how to link a cell to a shape in Excel. We will link cell A1 to a circle, which will update automatically upon change. Steps to Link a Cell to a Shape in Excel Now that you have a shape in Excel, let’s do something with it. Follow the steps […]