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 number of calls. This example uses Excel 2016. This example is going to start with some historical data for the past 6 years worth of […]
Blog
How to remove spaces in cell data in Exc...
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 a product number that was entered incorrectly. In the below simple example we are going to use the SUBSTITUTE() fucntion in Excel to substitute a space […]
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 with a cell fill color, red or green, based on wether the previous column was lower or higher. Here is the Excel – Conditional Formatting […]
Microsoft Windows Shortcut Keys
Microsoft Windows Shortcut Keys Reference Card For my students in the Introduction to Personal Computers classes (or any Microsoft software class realy), below is a good quick reference guide for using Microsoft Windows Shortcut Keys. This is very good for all Windows users to have handy as there are many shortcut keys to remember for […]
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 a rather useful tool if you know how to use it. I have put together this small Excel Pivot Table Example to help students understand […]
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 vLookup example. This is for a student that needed this for real world work. My student had two lists of customers. The first was […]
Updated Class Schedules
Due to the snow storms this winter the Excel class schedules needed to be adjusted. There are still open seats available for each of the classes below. The new start dates are listed below. Updated Excel Class Schedules Intermediate Microsoft Excel 2016 – Franklin MA 4 Sessions starting Wed 4/25/2018 from 6-9pm More Info Advanced Microsoft […]
Office 365: One License, Five Devices
#Office365: One License, Five Devices View: Office 365: One License, Five Devices Also visit our Amazon Local Associates Page
Three Ways the New Office 365 Takes the ...
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 a date entered in a cell. For a real world example, I use this to track the time I follow up on small projects. For […]