The Microsoft Excel 2010 Level 2 training is a one-day course that equips students in performing calculations on data, locating and validating data, creating styles and formatting data, filtering data, reordering and summarizing data, and combining data from multiple sources.
Completion of the course equips the participants with the following skill set:
Module 1: Perform Calculations on Data
Lab: Naming Groups of Data
Lab: Creating Formulas to Calculate Values
Lab: Summarizing Data That Meets Specific Conditions
Lab: Finding and Correcting Errors in Calculations
Module 2: Create Styles and Format Data
Lab: Defining Styles
Lab: Making Numbers Easier to Read
Lab: Changing the Appearance of Data Based on Its Value
Module 3: Focus on Specific Data by Using Filters
Lab: Limiting Data that Appears on Your Screen
Lab: Manipulating Worksheet Data
Lab: Defining Valid Sets of Values for Ranges of Cells
Module 4: Reorder and Summarize Data
Lab: Sorting Worksheet Data
Lab: Organizing Data into Levels
Lab: Looking Up Information in a Worksheet
Module 5: Combine Data from Multiple Sources
Lab: Using Workbooks as Templates for Other Workbooks
Lab: Linking to Data in Other Worksheets and Workbooks
Lab: Consolidating Multiple Sets of Data into a Single Workbook
Lab: Grouping Multiple Sets of Data
This course is beneficial for information workers who want to learn intermediate-level Excel 2010 skills.
Before attending this course, candidates must have:
Name | Code | Fee |
---|
OR