SkillSoft Explore Course – Lambers, Inc.

BUY NOW! STARTING AT ONLY $299!

Productivity & Collaboration Tools Microsoft Office 2010 Microsoft Office 2010: Intermediate Excel (No Assessments)

To use the contents of a cell, you must know how to reference that cell. Explore absolute and relative cell referencing, and discover how to work with named data ranges, formula auditing tools, and formula error messages in Excel.

Asset ID	ds_msex2010_08_enus
Course Type	Video Course
Course Category	Microsoft Office 2010

Objectives
Excel 2010: Referencing Data Referencing your cells Using data across multiple sheets Choosing between absolute & relative cell references Naming your data ranges Performing calculations using constants Using cell references indirectly Keeping an eye on your data Activating automatic updates Using formula auditing Understanding formula errors