# Course 50124A: Learn Microsoft® Office Excel® 2007 Step by Step, Level 2

 Type: Course Audience(s): information workers Technology: Excel Level: 100 This Revision: A Delivery method: Instructor-led (classroom) Length: 1 day Language(s): English First published: 02 February 2009
Overview
This one-day instructor-led course provides students with experience at creating more elaborate worksheets and workbooks in Microsoft Office Excel 2007 to display data in more effective ways.
Audience profile
This course is intended for information workers who want to learn intermediate-level Excel 2007 skills.
At course completion
After completing this course, students will be able to:
• Summarize data that meets specific conditions.
• Find and correct errors in calculations.
• Change the appearance of data based on its value.
• Customize the appearance of charts.
• Find trends in your data.
• Print charts.
• Create diagrams by using SmartArt.
• Define valid sets of values for ranges of cells.
• Limit data that appears on your screen.
• Manipulate list data.
• Sort data lists.
• Organize data into levels.
• Look up information in a data list.
• Use data lists as templates for other lists.
• Print data lists.
• Print parts of data lists.
• Link to data in other worksheets and workbooks.
• Consolidate multiple sets of data into a single workbook.
• Group multiple sets of data.
Course details
 Course OutlineModule 1: More Calculations and FormattingThis module explains how to create conditional formulas, identify and correct formula errors, and conditionally modify the appearance of data.Lessons Summarizing Data That Meets Specific ConditionsFinding and Correcting Errors in CalculationsChanging the Appearance of Data Based on Its ValueLab : More Calculations and FormattingAfter completing this module, students will be able to:Create conditional formulas.Track down calculation errors.Use conditional formatting.Module 2: More Charts and GraphicsThis module explains how to tailor a chart to best show your data and how to print them. The module also explains how to add visual objects such as images and diagrams.Lessons Customizing the Appearance of ChartsFinding Trends in Your DataPrinting ChartsAdding Images to WorksheetsCreating Diagrams by Using SmartArtLab : More Charts and GraphicsAfter completing this module, students will be able to:Modify the layout and style of a chart.Use a trendline to discover data trends.Print charts separately from their worksheets.Add visual objects such as images.Use SmartArt Graphics to create diagrams.Module 3: Data ListsThis module explains how to limit the data that can be entered in a worksheet, how to filter data, and how to manipulate and sort data lists.Lessons Defining Valid Sets of Values for Ranges of CellsLimiting Data That Appears on Your ScreenManipulating List DataSorting Data ListsLab : Data ListsAfter completing this module, students will be able to:Validate data entered into worksheets.Use filters to display specific data.Extract specific information from a data list.Sort data in different ways.Module 4: More Data ListsThis module explains how to organize data to show the information you want, look up information in data lists and use data lists as templates, and how to print all or part of a data list.Lessons Organizing Data into LevelsLooking Up Information in a Data ListUsing Data Lists as Templates for Other ListsPrinting Data ListsPrinting Parts of Data ListsLab : More Data ListsAfter completing this module, students will be able to:Create an outline to display different groups of data.Use VLOOKUP functions to look up values.Create templates for workbooks and worksheets.Print specific data and specify how information should be printed.Module 5: Data from Multiple SourcesThis module explains how to link data in other worksheets and workbooks, and how to consolidate and group multiple sets of data.Lessons Linking to Data in Other Worksheets and WorkbooksConsolidating Multiple Sets of Data into a Single WorkbookGrouping Multiple Sets of DataLab : Data from Multiple SourcesAfter completing this module, students will be able to:Create, break, and re-create links to workbooks and worksheets.Summarize data from different locations in one worksheet.Save multiple workbooks as a workspace.
Prerequisites
Before attending this course, students must have:
• Basic computer knowledge
• Basic file-management skills
• Basic knowledge of the Excel interface and workbook creation
Community

Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community.

Preparing for an exam now? Find your Microsoft Certification Study Group.

Talk to us on these social networks: