At Excel Effects, education is a key component to our program. So, this page shows the entire gamut of our tutorials. Overall, we have a good range of topics in our library. If you want to view a particularly section, then click on a button below. Our training topics and sections include – charting, Excel, PowerPoint, quick tips, snapshots, and Visual Basic for Applications (or VBA). Additionally, we have a good set of video lessons for visual step-by-step processes. Feel free to click on one of the buttons below to view various tutorials.
Charting Excel PowerPoint Quick tips Snapshots VBA Video lessons
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 […]
Question on how to hide object in Excel with VBA What VBA line of code would you use to hide the named shpSaucer object in Excel? Select your answer below, and try not to take a sneak peak. A. Shapes.Range(“shpSaucer”).Show = False B. Shapes.Range(“shpSaucer”).Visible = msoFalse C. Shapes.Range(“shpSaucer”).Hide = msoTrue D. Shapes.Range(“shpSaucer”).Display = Visible Answer […]
So, in this quiz, we ask you to identify key elements of an Excel chart and ask you to identify them. Of course, we did not include every chart item. However, there are a lot of them. Keep in mind, every question has an image. Moreover, we use red callouts to showcase each question. Therefore, […]
How to insert hyperlinks in Excel This quick how-to guide shows you how to insert hyperlinks in Excel. Overview So, in this tutorial, we show you how to place links on text and on images. Essentially, both methods are the same. But, we want you to know ahead of time, that image links are also […]
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 […]
Fun quiz on Microsoft Excel love. So, how deep does you love go for Excel? Will you be able to find love with this spreadsheet program? Who knows. In any case, do not take this quiz seriously. Once you are done, click on the love points button to see where you stand. There are 14 […]
This quiz tests your knowledge of PowerPoint shapes. Keep in mind, this is a fun quiz, and do not take it too seriously. Quiz on PowerPoint shapes Overall, there are ten “image” questions to this quiz. The passing mark is 80%. Basically, all you have to do is, look at the image and identify the […]
Want to see everything, well almost everything on Excel Effects?
How-to guides Charting Excel PowerPoint Quick tips Quiz Snapshots VBA Videos Google courses Python courses Question of the day Tech Tuesday
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
Excel Effects filing and organizational tools for your digital office needs.
Yearly calendar Monthly calendar Project schedule template Templates
Affiliate stuff – Move up and excel with Excel
