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 […]
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 […]
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 […]
The LEN worksheet function in Excel returns the number of characters in a text string. LEN worksheet function Here is the syntax of the LEN function. Syntax =LEN(reference) Arguments Reference – A text string or cell range. Example(s) Example 1 Example 2 Example 3 Excel functions Reference home
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 […]
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. 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 […]
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
