Education

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

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

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

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

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