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
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 […]
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 […]
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. […]
This short snapshot simply provides a reference of using the FILTER function in Excel. Keep in mind, this reference does not go into full detail of using this function. On the whole, it is a snapshot of the function. We pattern this example from the following function. LET function Snapshot of using the FILTER function […]
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
