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 quick how-to video shows you how to add Excel camera tool to quick access toolbar (or QAT). In addition, we took it for a test drive. Video to add Excel camera to QAT One thing to note is, there is a part that jumps directly to Excel options, without seeing the mouse movement. So, […]
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 […]
Brief overview of the column row highlighter The column row highlighter is an experiment in conditional formatting. Moreover, we developed it as an Excel tool without macros. Basically, we like to call that sheet programming. Do not get us wrong, we love coding. But, it is a good challenge to try to do things in […]
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, […]
