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 a product number that was […]
Computer not working? Then you need ITFixed Contact Us Now!
Our Latest Blog Posts
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, […]
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. […]
How to remove spaces in cell data in ...
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 ...
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 t...
Three Ways the New Office 365 Takes the Work out of Working Together
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 […]
Free Online Excel Training
For my students in the Excel classes, here is some Free Online Excel Training. These training videos are from Microsoft and LinkedIn and walk you through many features of Microsoft Excel. The training videos are split up into topics such as Formulas, Functions, Tables, Charts and many others. If you are new to Excel 2016 […]