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
Category: Microsoft Office
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 […]
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 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 calculate age in Excel
How do you calculate age using a formula or function in Excel To calculate age in Excel is relatively easy if you know the proper function to use. In this […]
Missing Row and Column Headings in Excel
Missing Row and Column Headings This is a question I received for the first time during my latest Excel 2016 Class. My student mentioned that she had missing row and […]
How to create an Excel Forecasting Worksheet
In this short example I am going to show you how to create an Excel Forecasting Worksheet to graph out with a certain percentage of accuracy a forecast of future […]
How to remove spaces in cell data in Excel
How to remove spaces in cell data in Excel This came up in the last Excel class. A student asked how to remove spaces in Excel cell data. For example […]