Piggy Goes to Market
Intermediate Excel Objectives
In this lesson, you will learn how to:
1. Practice modifying cell contents and formats.
2. Use the Paste Special options.
3. CONCATENATE (combine) data with a formula.
4. Modify and format TEXT with formulas.
5. Use DATE and TIME formulas.
6. Use FINANCIAL formulas to calculate a car payment
Download this lesson as a PDF file
Piggy Goes to Market (pdf)
Download the Sample Files as a zipped folder, below:
Legs Eggs Pigs 2013.xlsx
Counting Chickens 2013.xlsx
Brown Bag Sales Data 2013.xlsx
IntermediateExcel2013-TextDateFormulas.pdf
Download