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. Click Home from the main menu. […]
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. The short video Below is the short video on adding footnote markers to categories in Excel. Now, you may need to maximize the video, to get the full […]
How to add an average line to a column chart This quick tip shows you how to add an average line to a column chart in Excel. The short video Below is the short video on adding an average line to a column chart in Excel. Now, you may need to maximize the video, to […]
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 […]
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, […]
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 Excel Effects home
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. The short video Below is the short video on putting an average line on a bar chart in Excel. Now, you may need to maximize the video, to […]
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
Learn new things and improve on the skills you already have.
