Excel Pivot Tables are sometimes a mystery to users of Excel. In this example I am going to show you how to add a percentage (%) column into a pivot table. This column will calculate that rows percentage of the grand total. We will start with some sample raw data. In the worksheet above we […]
You are browsing archives for
Category: How To
How to create a dual axis chart in Excel
Creating a dual axis chart In my opinion, charting in Excel is an art that needs to be practiced extensively to be an expert. As I demonstrate many examples in class I like to give additional info here for reference, for past, or future students. In this example I will show you how to create […]
How to insert a degree symbol in Microso...
How to Insert Degree Symbol in Microsoft Word I recently created a post on How to insert the degree symbol in Google Docs. The post received quite a few views so I figured I would create a similar post on How to Insert a degree symbol in Microsoft Word as well. Below is a simple […]
How to update WordPress Plugins
Update WordPress Plugins There are already many WordPress blogs out there that may have this info but I would like to add my two cents for my students and other users of WordPress on the steps I recommend for updating plugins. Depending on the number of plugins you normally use it is not unreasonable to […]
How to add a call out Arrow to an Excel ...
How to add a call out Arrow to an Excel Spreadsheet Lets pretend that you have an Excel Spreadsheet with an important number that you do not want your viewers to miss. How do you add a call out arrow to your spreadsheet? Below is our sample spreadsheet with a total under the last row […]
WordPress Website Redirected to Spam Sit...
Is your Website being redirected to a spam site? Was just asked by a client why their website was redirected to spam site. I checked the url of the site and it worked fine from my pc. I first suspected it could have been malware on the users pc. This was not the case as […]
How do you insert the degree symbol in G...
How do you insert the degree symbol in Google Docs? Google Drive (Google Docs and Google Sheets) are becoming more popular in schools. My son was working on a project and needed to enter the degree symbol in Google Docs. At first it took me a quick second to find how to do it. Below […]
Boot Device Not Found
How to fix “Boot Device Not Found” error. How do you you fix an HP pc that does not boot? Upon starting up I get the dreaded “Boot Device Not Found” error. The pc in question is a clients pc. It is an HP with a 500GB Seagate hard drive. First thing I checked is […]
Keyboard appears to be typing backwards
I just had a client give me a call and state that their Windows 10 pc keyboard was typing backwards. At first I was not sure what this meant so I visited this client in person. Indeed the keystrokes the user was typing were displaying to the left of the last character. At first I […]
How to retrieve a Windows 7 Product Key
I have not posted an “It Fixed it for me” article in a while. Here is one that may help someone else. Have you ever needed to reinstall your operating system due to a failed hard drive, severe virus infection or just want a fresh start but realize that you either lost your Windows 7 […]