This quick lesson shows you how to edit a basic macro in Excel. For the purpose of this lesson, we go through the steps on a PC running the Windows operating system. In addition, these steps should work perfectly in Excel 2007 or higher. Before we start, you need a macro to edit. We will […]
Fun with macros So, fun with macros is a set of learning tools that teach you to code and create great stuff in Excel. The basics Although we have a basics section, we do not plan to put our lessons in categories. Instead, when you learn to create code in Excel, you will realize, you […]
The Google courses in this section of Excel Effects are from our affiliates. Google courses Google Sheets Sheets is a free program that allows you to create and edit spreadsheets online. Also, you can save your work online and open it up in almost any location. Moreover, share your work with others, including coworkers, friends, […]
This tutorial shows you how to create a hello world macro in Excel. For the purpose of this lesson, we go through the steps on a PC running the Windows operating system. In addition, these steps should work perfectly in Excel 2007 or higher. A macro is a set of commands or actions that make […]
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 […]
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 […]
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 […]
The following Python courses are from our affiliates. List of Python courses Feel free to click on any of the links below to start learning how to code in Python. There is no particularly order to the list. So, just jump in and start learning and creating stuff. Python, baby steps Artificial intelligence Python 3 […]
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 […]
Chart library Area charts Bar charts Bubble charts Column charts Combo charts Donut charts Line charts Math charts Pie charts Scatter charts Sheet charts Special charts
Learn new things and improve on the skills you already have.
