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 […]
Posts in category Excel
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 […]
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 […]
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 […]
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 […]
For my students in the Excel 2016 classes. Below is a good quick reference guide for using Excel Shortcut Keys. To download click the link below. For Microsoft Word Shortcut Keys For Microsoft PowerPoint Shortcut Keys Please consider ordering these books as well as they provide some great information.