How many times have you encountered an Excel spreadsheet where the first and last names were in two different columns and you needed to combine them? Or, perhaps you need to do the reverse. Yes, Excel contains formulas that will...
“If-then” is a common formula. Once you have the hang of this formula, you will find yourself using it in many situations. They called this video “Conditional Formatting,” but it’s really not. If you understand the formula used when they...
This tutorial gives examples of Autofill, writing formulas to find sums, percentages, averages, maximums, and minimums.The examples also shows how to sort rows, resize fonts, and merge cells. Click here to go to the tutorial....
A budget is a pretty standard Excel example to work through. This example shows how to add labels in Excel, enter numbers, format the numbers as money, total the amounts rows, and total the amounts in columns. Click here to...
One of the best investments of my time was learning the spreadsheet portion of AppleWorks back in the days when an Apple IIe was “cutting edge.” The first accomplishment was immediately moving my gradebook from paper to computer. Never again...