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 […]
Our list of tags are somewhat like a site map. All in all, these tag names contain groups of posts, tools, and apps related to the name of the tag. In addition, these groupings help you navigate through the Excel Effects site. Our list of tags Here, you will find a list of our tags […]
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, […]
List of places to get data and information Below is a list of some places to get data and information on a variety of subjects. American National Standards Institute Biography Black demographics Britannica ESPN analytics History IMDb Merriam Webster National Institute of Standards and Technology (NIST) NBA statistics Our World in Data Pew Research Center […]
PowerPoint cover pages We love creating PowerPoint cover page designs. So, we have many, and we mean many designs for you to view and enjoy. Therefore, make sure you continue to come back to see all of our designs. If you want to see all of the cover designs in our collection, then click on […]
Project management tools Below is our selection of project management tools for you to use in your work. For the most part, these tools and templates are for Excel. Dynamic yearly calendar Learn more Ultimate monthly calendar Learn more Project schedule Learn more Excel Effects home
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 […]
