Microsoft Office Excel 2007 Basic
|
|
MS Office |
Language Course |
ILT Classroom |
Mentored Learning |
OnLine AnyTime |
OnLive Live |
|
Excel 2007 |
Portuguese /
English |
Yes |
Yes |
Yes |
Yes |
24 HRS / 3 DAYS
Lesson 1: Creating a Basic Worksheet
• Explore the User Interface and the Ribbon
• Navigate and Select in Excel
• Obtain Help
• Enter Data and Save a Workbook
• Customize the Quick Access Toolbar
Lesson 2: Performing Calculations
• Create Basic Formulas
• Calculate with Functions
• Copy Formulas and Functions
Lesson 3: Modifying a Worksheet
• Manipulate Data
• Insert and Delete Cells, Columns, and Rows
• Search for Data in a Worksheet
• Spell Check a Worksheet
Lesson 4: Formatting a Worksheet
• Modify Fonts
• Add Borders and Color to Cells
• Change Column Width and Row Height
• Apply Number Formats
• Position Cell Contents
• Apply Cell Styles
Lesson 5: Printing Workbook Contents
• Print Workbook Contents Using Default Print Options
• Set Print Options
• Set Page Breaks
Lesson 6: Managing Large Workbooks
• Format Worksheet Tabs
• Manage Worksheets in a Workbook
• Manage the View of Large Worksheets
Lesson 7: Calculating Data with Advanced Formulas
• Manage Cell and Range Names
• Calculate Data Across Worksheets
• Use Specialized Functions
• Analyze Data with Logical and Lookup Functions
Lesson 8: Organizing Worksheet and Table Data
• Create and Modify Tables
• Format Tables
• Sort or Filter Worksheet or Table Data
• Calculate Data in a Table or Worksheet
Lesson 9: Presenting Data Using Charts
• Create a Chart
• Modify Charts
• Format Charts
Lesson 10: Analyzing Data Using PivotTables and PivotCharts
• Create a PivotTable Report
• Analyze Data Using PivotCharts
Lesson 11: Inserting Graphic Objects
• Insert and Modify Pictures and ClipArt
• Draw and Modify Shapes
• Illustrate Workflow Using SmartArt Graphics
• Layer and Group Graphic Objects
Lesson 12: Customizing and Enhancing Workbooks and the Excel Environment
• Customize the Excel Environment
• Customize Workbooks
• Manage Themes
• Create and Use Templates