SkillSoft Explore Course – Lambers, Inc.

BUY NOW! STARTING AT ONLY $299!

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

You can use formulas to extract and analyze data in your spreadsheet. DiscoverÂ how to use the MAX, MIN, LARGE, and SMALL formulas, and work with VLOOKUP to cross-reference the contents of two lists.

Asset ID	ds_msex2013_17_enus
Course Type	Video Course
Course Category	Microsoft Office 2013

Objectives
Excel 2013: 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 values 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 2013: 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 values 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