For the students in my “Intro to Personal Computers” class. Here is a good article (not created by me) that goes over some of the many software we talked about in class. https://gizmodo.com/the-best-free-software-to-install-on-your-new-laptop-1831228091 The list includes Firefox – Web Browser LibreOffice – Office Applications GIMP – Image Editing Pixlr – Image Editing Google Photos – Image Editing […]
Blog
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 to some of the more helpful Excel Tips I have found. Please note I did not create the articles below. I am just linking to […]
How to check Website Performance
How to check Website Performance The links below can be used to check your Website Performance. This quick post is for my students in any of my WordPress classes. Simply enter your website address and have the sites below scan your site. You will get a list of items that have a good\bad status. Some […]
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 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 […]
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 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 […]