How do you change the page background color in Microsoft Word In wrapping up an Intro to Microsoft Word class I am teaching I received an email that asked how […]
You are browsing archives for
Category: Tips
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 […]
“The handle is invalid” when accessing share over network.
“The handle is invalid” when accessing share over network. I have a client with a Windows 7 pc with a folder that is shared on their network (Workgroup). Sometime last […]
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 […]
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 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 […]