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

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

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

## Make Average Line Stretch Across Chart – Tutorial

This lesson shows you how to make average line stretch across a column chart in Excel. There are various ways to do this. For the most part, it depends on the type of chart and the average line. If you do not have a chart with an average line, you can either follow along, or […]

## Run a Macro from a Button in Excel – Tutorial

This lesson shows you how to run a macro from a button in Excel. Steps to Run a Macro from a Button in Excel Follow the steps below to use a button for a macro. Step 1: Open File with Macro and Open Developer Ribbon Click the Developer tab. If you have not done so, […]