How to reconcile Excel with a payroll system? I had a past student bring in a problem spreadsheet that they could not reconcile with their Quickbooks Payroll totals. This student […]
You are browsing archives for
Author: Scott
How do you use Goal Seek in Excel?
How do you use Goal Seek in Excel? Goal Seek in Excel is a seldom used tool that can help you find the number of units of a product you […]
What is a Excel 3D Reference and How Do You Use One?
What is a Excel 3D Reference and How Do You Use One? Excel 3D References can come in handy when you need to perform a calculation on data located in […]
Helpful WordPress Resources
Helpful WordPress Resources I have compiled a set of useful WordPress Resources to help build a website using WordPress. These include links to SEO guides, free images, free WordPress themes, […]
How to add a percentage column in a pivot table.
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 […]
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 […]
How to insert a degree symbol in Microsoft Word
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 […]
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 […]
How to add a call out Arrow to an Excel Spreadsheet
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 […]
How to create a Photo Slide Show in PowerPoint
PowerPoint Photo Slide Show There are many programs available to create photo slide shows, however many users do not realize that you can create a Photo Slide Show in PowerPoint. […]