How to add a footnote marker to a category in Excel This quick tip shows you how to add a footnote marker to a category in Excel. If you try to add a footnote to a category on the sheet, then it will not work. Well, it will add the marker to any text on […]
How to add average line to column chart This quick tip shows you how to add average line to column chart in Excel. Also, you may hear the term “target line” to describe this type of chart. Target line Overall, a target line represents a goal or a particular measuring point. So, your target may […]
This quick how-to video shows you how to add Excel camera tool to quick access toolbar (or QAT). In addition, we took it for a test drive. Video to add Excel camera to QAT One thing to note is, there is a part that jumps directly to Excel options, without seeing the mouse movement. So, […]
This how-to quick snapshot video shows you examples of using For Next statement for basic counting in Excel VBA. Remember, this snapshot is not a full tutorial. How to show basic counting using For Next statement We use Debug.Print to show results of different ways to count numbers from zero to ten. Debug.Print is a […]
This quick video tip shows you how to change cells from night to day in Excel. Change cells from night to day in Excel In this instance, we use a macro to accomplish this task. So, what we do is record the process of selecting all the cells in the sheet. Then, we change the […]
How to create a bar chart in Excel This quick tip shows you how to create a bar chart in Excel. The short video Below is the short video on creating a bar chart in Excel. Now, you may need to maximize the video, to get the full effect of this quick tip. Education home
This quick video tip shows you how to create a blue Pac-man figure in PowerPoint (or PPT). For the purpose of this video, we use PowerPoint version 2203 on a Windows system. However, it should work great in PowerPoint 2007 or higher. Create a blue Pac-man figure in PPT Sometimes, you need to cut loose […]
How to create a column chart in Excel This quick tip shows you how to create a column chart in Excel. The short video Below is the short video on creating a column chart in Excel. Now, you may need to maximize the video, to get the full effect of this quick tip. Related Education […]
Create a face in PowerPoint This quick video shows you how to create a face in PowerPoint (or PPT). Although I was a little messy with certain parts of the video, it is still pretty fun to watch. By the way, I plan to make it possible for you to download some faces too. So, […]
This silent how to video shows you how to create rounded brick tile pattern directly in PowerPoint. In the past, you had to create the tile pattern in a graphics or design program first. Video to create rounded brick tile pattern Below is a video that takes you through the step-by-step process of creating round […]
This video shows you how to create custom PowerPoint (or PPT) tile pattern. In the old days, we had to use a design app to make part of this happen. Today, you could to the entire process right in PPT. Video on how to create custom PowerPoint tile patterns So, we will get straight to […]
Keep the size and position of an object in Excel This quick tip video shows you how to keep the size and position of an object in Excel. So, whenever you resize a column or row in Excel, the object under that position may move or change in size. Depending on what you want to […]
Link a cell to a shape This quick tip video shows you how to link a cell to a shape in Excel. You know what is funny, sometimes we actually want to use macros to do things. However, you do not necessarily have to use macros to do things. The video So, we have two […]
This quick video tip shows you how to link cells to fancy balls in Excel. Those balls look good! Just imagine what you had to do in the old days to accomplish this task. Link cells to fancy balls So, what we want to do is have a set of balls update when we update […]
Make a toggle button in Excel This quick video tip shows you how to make a toggle button in Excel, with a VBA macro. The video The code Below is the code for the toggle button. As you see, we use an IF…Then…Else statement to make the button work. Also notice, only one equal sign […]
How to put average line on a bar chart in Excel This quick tip shows you how to put average line on a bar chart in Excel. Set target goal So, you may hear people say “target line” for this type of chart. For the most part, it is the same idea. Except, we use […]
This tutorial shows you how to run a macro from a form button in Excel. If you do not have a macro to use, then create one. Or, just go through our Hello World lesson. In fact, we will use the macro from our Hello World lesson, in this tutorial. Steps to run a macro […]
Show developer ribbon in Excel. How to show developer ribbon in Excel This quick video tip shows you how to add the developer ribbon in Excel. The video Below is a video that shows you how to add the developer ribbon to the menu, in Excel. Related Education home
This quick tip video shows you how to show or hide an object with a shape in Excel. For the purpose of this tip, we use Excel 2007 or higher, on a Windows PC. In addition, we use a mouse with left and right button functionality. Show or hide an object with a shape So, […]
This quick tip shows you how to show the immediate window in Visual Basic for Applications (or VBA) for Excel . Show the immediate window The immediate window allows you to test single lines of code. In most cases, you use Debug.Print to run single line commands in VBA. The video So, here is a […]
Use a shape to run a macro in Excel This quick tip and video shows you how to use a shape to run a macro in Excel. Also, we have a lesson on running a macro from a form control. If you want a deeper understanding of this process, then you should view that tutorial. […]
