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
ChatGPT PEMDAS is an important acronym that helps you remember the order of operations in mathematics. It is short for: Take ChatGPT PEMDAS quiz For the purpose of this quiz, we use the carat (^) symbol to represent exponent. So, 22 will appear as 2^2. There are five questions to this quiz. They all were […]
So, we did the ChatGPT shapes quiz after the PowerPoint shapes quiz. On the whole, the GPT quiz is probably harder. Particularly, since it is not based on multiple-choice questions. To be fair though, the PowerPoint quiz actually displays images per question. Thus, the difficulty goes down a little. Take the ChatGPT shapes quiz This […]
The CONCAT worksheet function for Excel allows you to combine multiple ranges of text strings. CONCAT is short for concatenate. Overview of CONCAT worksheet function So, the main key word in the purpose of CONCAT is ranges, which means, CONCAT works as an array function. In other words, you can check values one-by-one within a […]
How to create a bar chart in Excel This quick tip shows you how to create a bar chart in Excel. The short video Below is the short video on creating a bar chart in Excel. Now, you may need to maximize the video, to get the full effect of this quick tip. Education home
This quick video tip shows you how to create a blue Pac-man figure in PowerPoint (or PPT). For the purpose of this video, we use PowerPoint version 2203 on a Windows system. However, it should work great in PowerPoint 2007 or higher. Create a blue Pac-man figure in PPT Sometimes, you need to cut loose […]
How to create a column chart in Excel This quick tip shows you how to create a column chart in Excel. The short video Below is the short video on creating a column chart in Excel. Now, you may need to maximize the video, to get the full effect of this quick tip. Education home
Create a face in PowerPoint This quick video shows you how to create a face in PowerPoint (or PPT). Although I was a little messy with certain parts of the video, it is still pretty fun to watch. By the way, I plan to make it possible for you to download some faces too. So, […]
This lesson shows you how to create a game board in Excel. Before we start the frontend part of the project, take a look at the requirements below. Requirements Create a game board For the board, we will work on placing the faces of the game. These will simply be boxes. Also, the faces are […]
This snapshot how-to shows you how to create formula from math function. Remember, snapshots are just quick snippets or screenshots of a task. How to create formula from math function Below are the step-by-step instructions on turning a basic math function into a workable formula for computing. Feel free to copy this huge image to […]
This silent how to video shows you how to create rounded brick tile pattern directly in PowerPoint. In the past, you had to create the tile pattern in a graphics or design program first. Video to create rounded brick tile pattern Below is a video that takes you through the step-by-step process of creating round […]
This video shows you how to create custom PowerPoint (or PPT) tile pattern. In the old days, we had to use a design app to make part of this happen. Today, you could to the entire process right in PPT. Video on how to create custom PowerPoint tile patterns So, we will get straight to […]
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 […]
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
