Macros are a set of commands or instructions to help you complete tasks that you may do often. Overall, it is a group of step-by-step instructions. Each task runs one after another. In addition, you can test and monitor your steps within the macro. In Excel, you can use the recorder to create a macro. […]
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 […]
The Marimekko – one level chart Believe it or not, the Marimekko – one level chart, is actually an area chart in Excel. Now, isn’t that something? It is a unique chart. And, in the beginning, it took a while learning how to create it. But now, we have one where you can just plug […]
Overall, the MID worksheet function in Excel returns the characters from the middle of a text string, given a starting position and length. MID worksheet function Here is the syntax of the MID function. Syntax =MID(Text, Start_num, Num_chars) Arguments Below are the arguments of the MID function. Argument Description Text A text string from which […]
Pill Bar overview The pill bar with average line chart is similar to a regular bar chart. Instead, with this chart, the two endpoints are round. Thus, you get what looks like a pill. Of course, as with the bar chart, this chart is shows everything in a horizontal manner. Now, with all that said, […]
Project schedule template Although the Project Schedule is part of our vintage collection, it is a timeless tool. Overview, it is a great template for people of all levels. Requirements: Excel 2007 or higher or compatible. Click on the button below to download. DownloadFile size: 98 bytes Related Color scheme table for Excel Dynamic yearly […]
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. The short video Below is the short video on putting an average line on a bar chart in Excel. Now, you may need to maximize the video, to […]
Our quick access toolbar The quick access toolbar (or QAT) allows you to quickly access commands that you use often. Overall, it helps you work more efficiently. So, this QAT is actually the one we actually use in Excel. Since we are into graphics and data, we have commands that work with objects and numbers. […]
The rounded column chart with average line is very similar to our column with average line chart. Basically, it shows data across categories. In addition, the average line shows the central tendency of the values. Moreover, you can visually view which categories are above or below average. Adjusting the Rounded Top Now, depending on the […]
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 […]
We will show you some sample table designs in Excel. Sample table designs Because of Excel’s structure, you do not have the same flexibility as you would in a word processor. Or, in a desktop publisher app. However, with some creative thinking, designing fancy stuff is always possible. Also, the good thing about tables in […]
Scatter dots chart with trendline for Excel. Download Overview of scatter dots chart with trendline The scatter dots chart allows you to display data using x, y coordinates. It is a great way to show the spread of many data points. In addition, we include a trendline with the formula to help you see if […]
