Add an average line to a column chart – Quick tip
Add an average line to a column chart – Quick tip This quick video tip shows you how to add an average line to a column chart. Related content Present your data in a column chart Online courses Home
Excel
Add or remove items from the quick access toolbar
So, this super quick tip shows you how to add or remove items from the quick access toolbar (or QAT). All in all, this lesson applies to versions of Office that have a QAT. Overall, the QAT allows us to access commands that we use frequently. It is located either above or below the ribbon. […]
Assign a macro to a command button in Excel
This lesson shows you how to assign a macro to a command button in Excel. A button is a great way to show the user a clickable item on your sheet. Furthermore, it helps you automate tasks in a user friendly manner. Right-click note In part of this lesson, you may see the term right-click. […]
Assign a macro to a shape in Excel – Quick tip
Certainly, you knew you can assign a macro to a shape in Excel? If not, then this lesson will show you how to do that. Anytime you are able to custom something, it leaves the door open to new ideas. In this case, you can design dashboards, games, and even automate tasks. And, having control […]
Create a shape link to a cell in Excel – Quick tip
In Excel, we will create a shape link to a cell. Meaning, we will put the value of a cell inside a shape. And, when you update that cell, the value within that shape is updated. After you establish a link, that ordinary shape turns into a dynamic floating shape. Good stuff, huh! For the […]
Creating a navigation bar in Excel – Quick tip
When creating a navigation bar in any program, it greatly enhances the user experience. And, it is even better if you do it in Excel. You see, if your app is easy to navigate, then that makes it more efficient. In the end, that is what you want. Therefore, this quick tip focuses on creating […]
How to create a multi-line shape link to a cell in Excel
How to create a multi-line shape link to a cell in Excel This quick tip video shows you how to create a multi-line shape link to a cell in Excel. Overall, it is a great way to introduce floating elements to create a dashboard. And, although we like the camera tool, a shape link uses […]
How to show or hide an object in Excel with a button click
This quick tip shows you how to show or hide an object in Excel with a button click. So, you guessed it! Once you learn how to do this, just think about all of the possibilities. For example, design your own game or a dashboard in Excel, like Jeopardy or a financial tool. Of course, […]
Open the Visual Basic for Applications editor in Excel
This super quick tip shows you how to open the Visual Basic for Applications (VBA) editor in Excel. Overall, the VBA editor allows you to do some amazing stuff with code. Again, we just show you how to open the editor here. However, we will go more in depth with VBA in a later lesson. […]
Record a basic macro in Excel – Quick tip
This quick tip shows you how to record a basic macro in Excel. On the whole, a macro lets you perform a set of tasks automatically. For the purpose of this lesson, we suggest you use Excel 2007 or higher or compatible. Steps to record a basic macro in Excel Follow the steps below to […]