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 […]
You are browsing archives for
Category: Excel
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 […]
Excel Tips and Helpful Info for Students
Excel Information and Tips Excel is an extremely powerful program. Most users do not take advantage of all of the capabilities Excel has to offer. Below, please find some links […]
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 […]
Excel – Conditional Formatting Example
Excel – Conditional Formatting Example I have been asked by a former student for some help with Excel’s Conditional Formatting. My student needed help setting up a column of data […]
Excel Pivot Table Example
Excel Pivot Table Example Many students and other Excel users often ask me what a pivot table is in Excel. Most users really have never needed them. It really is […]
Excel vLookup Example
Excel vLookup Example While teaching Excel classes over the past few semesters I get many questions on how to perform certain fuctions in Excel. Below is another request for and […]
Excel Date Calculations
How to use simple Excel Date Calculations Several students have asked about Excel Date Calculations. Here is a good quick example to calculate the difference between todays date ( “today()”) and […]