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 […]
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 […]
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 […]
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 […]
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 […]
The pie chart quarterly analysis tool allows you to compare data for up to nine years. It is a basic tool that provides a lot of information. In addition, it is very easy to use. This is a free tool. Key Specifications Program name: Quarterly Pie Tool Package file size: 45 Kilobytes Date created: April […]
This tutorial shows you how to quickly create stairs from box shapes in PowerPoint. This instruction expects you to have your boxes ready in PowerPoint already. We use PowerPoint 2016 for this lesson. However, PowerPoint 2007 or higher or compatible has a very similar process. Process to Quickly Create Stairs in PowerPoint Follow the process […]
This quick tip shows you a very quick way to remove an item from the quick access toolbar. You can use this method on any Office program that has a quick access toolbar. Process to Remove Item from the Quick Access Toolbar Follow the process below to delete an item from the quick access toolbar. […]
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, […]
There are only a few steps to show data labels on a column chart. Data labels provide a value you can use to make comparisons. For the purpose of this tutorial, we use Excel 2016. However, you can follow along in most previous versions of Excel. Steps to Show Data Labels on a Column Chart […]
