Previous Lecture Complete and continue  

  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