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 […]
High low bars in a line chart in Excel
Sometimes, when you watch a financial program on TV, you may see a chart with high low bars. So, in this particular chart, we show you high and low values in a line graph with range bars. Example of a line chart with high low bars Here is a fancier version of the above chart. […]
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. […]
