SkillSoft Explore Course – Lambers, Inc.

Collections Essentials Microsoft Office 2010: Intermediate Excel (No Assessments)

Excel 2010 is a highly customizable application. Discover how to extract information with formulas, cross reference data lists, insert data automatically, and more.

Asset ID	ds_msex2010_14_enus
Course Type	Video Course
Course Category	Essentials

Objectives
Excel 2010: Extracting Information with Formulas Retrieving information with dates Finding a date automatically Finding the largest & smallest values in a list Separating data into multiple cells Combining data in a single cell Retrieving information on a cell Retrieving information on your text Cross referencing two data lists Inserting data automatically Finding a value in a double entry table Performing a search across two tables Finding data in a database Performing calculations using your database

Objectives

Excel 2010: Extracting Information with Formulas

Retrieving information with dates
Finding a date automatically
Finding the largest & smallest values in a list
Separating data into multiple cells
Combining data in a single cell
Retrieving information on a cell
Retrieving information on your text
Cross referencing two data lists
Inserting data automatically
Finding a value in a double entry table
Performing a search across two tables
Finding data in a database
Performing calculations using your database