Microsoft Excel 2013 (Part 3 of 5): Working with Data

In this course, instructor LeeAnne McManus delves into Excel’s ability to complete calculations on formatted data. From basic multiplication and division to the use of advanced, predefined formulas, she will review the best practices for applying various types of calculations to your data. MOS certification prep (Exam 77-420).

Lesson 1:

• Creating Calculations
• Demo: Calculations
• Demo: Entering Calculations.

Lesson 2:

• Formulas
• Demo: Formulas
• Demo: Parentheses
• Demo: Parentheses Cont..

Lesson 3:

• Functions
• Demo: Functions
• Demo: Text Functions
• Demo: Convert to One Field
• Demo: If.

Lesson 4:

• AutoComplete Functions
• Demo: AutoComplete.

Lesson 5:

• AutoFill
• Demo: AutoFill.

Lesson 6:

• Flash Fill
• Demo: Flash Fill
• Demo: Forcing Flash Fill.

Lesson 7:

• Cell References
• Relative, Absolute, Mixed
• Demo: Cell Reference
• Demo: Absolute Cell Reference.