SkillSoft Explore Course – Lambers, Inc.

BUY NOW! STARTING AT ONLY $299!

Productivity & Collaboration Tools Microsoft Office 2016 Excel 2016 Microsoft Office 2016: Intermediate Excel

Many times, you will use a cell value in a formula or another location. DiscoverÂ absolute and relative cell references, using data across multiple worksheets, formula auditing, and interpreting formula errors in Excel 2016.

Asset ID	ds_msex2016_08_enus
Course Type	Video Course
Course Category	Microsoft Office 2016

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