This quick tip shows you 3 ways to insert a worksheet in Excel. Steps to insert a worksheet in 3 ways Below are 3 ways you can insert a worksheet in Excel. Method 1 Firstly, in method 1, we use the main menu and ribbon to insert a sheet. So, there you have it. A […]
How to add a footnote marker to a category in Excel This quick tip shows you how to add a footnote marker to a category in Excel. If you try to add a footnote to a category on the sheet, then it will not work. Well, it will add the marker to any text on […]
How to add average line to column chart This quick tip shows you how to add average line to column chart in Excel. Also, you may hear the term “target line” to describe this type of chart. Target line Overall, a target line represents a goal or a particular measuring point. So, your target may […]
This lesson shows you how to assign a name to an object in Excel. When you work with objects in Excel, it helps to give them unique names. Especially, if you plan to use them in code. That is probably the main purpose for naming an object. Steps to assign a name to an object […]
This how-to quick snapshot video shows you examples of using For Next statement for basic counting in Excel VBA. Remember, this snapshot is not a full tutorial. How to show basic counting using For Next statement We use Debug.Print to show results of different ways to count numbers from zero to ten. Debug.Print is a […]
This quick how-to snapshot shows you basic Excel operators that you use in spreadsheet development and analysis. Please pay attention to the table and not the chart holder. Overview of basic Excel operators So, the main operators to use in spreadsheets are: assignment, addition, subtraction, multiplication, division, power, and concatenation. Keep in mind, we are […]
This quick video tip shows you how to change cells from night to day in Excel. Change cells from night to day in Excel In this instance, we use a macro to accomplish this task. So, what we do is record the process of selecting all the cells in the sheet. Then, we change the […]
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. Related Education […]
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, […]
