This course will cover getting started with Excel 2007, manipulating, formatting data and Worksheets, reviewing and printing. The training also teaches you Excel 2007 formulas, functions, charts, pictures, themes, styles, advanced formatting, advanced data management, advanced customization and how to analyze data and how to protect and share Excel 2007 workbooks.

Upon successful completion of this Microsoft Office Excel 2007 training course, you will be fully prepared to sit for the Microsoft Office Specialist Exam 77-602 MOS: Microsoft Office Excel 2007. All of our Microsoft Office 2007 training courses map to MOS certification paths.

Expected Duration (hours) – 24.5
Mentoring – 24x7

Price: USD $149.00

USD $119.00

Getting Started with Excel 2007

• match basic Excel 2007 features with their functions
• recognize how to use the Help feature in a given scenario
• create a new Excel workbook in a given scenario
• open an existing Excel workbook in a given scenario
• navigate through an Excel workbook
• enter data in an Excel worksheet in given scenario
• save a new workbook
• distinguish between the common file formats used to save work in Excel 2007
• launch Excel and open an existing workbook
• enter data in an Excel 2007 workbook in a given scenario
• save the workbook in a given scenario
• open a recently used workbook and locate specific values, in a given scenario

Manipulating and Formatting Data and Worksheets

• copy or move data in given scenarios
• add, delete, or resize rows and columns in a given scenario
• modify rows and columns to view specific sections of the worksheet
• format workbooks in given scenarios
• insert and delete a worksheet
• rename a worksheet and format the tab color
• copy or move worksheets
• modify cells and workbooks in a given scenario
• modify worksheets to view specified data
• copy and move data and worksheets in a given scenario
• apply basic data formatting
• format a data range as a table
• change the position of data in a cell in a given scenario
• identify the functions of Alignment commands
• work with tables in Excel 2007
• format a data range as a table
• modify an Excel table
• apply number formats in a given scenario
• identify the number formatting options available in Excel 2007
• apply basic conditional formatting rules in a given scenario
• recognize situations when conditional formatting is suitable
• format data and apply conditional formatting in given scenarios
• move data between workbooks and apply formats in a given scenario

Reviewing and Printing in Excel 2007

• use Excel 2007 review tools in a given situation
• work with comments
• use the track changes tool
• review a workbook in a given scenario
• customize page setup using the Page Layout View
• adjust page breaks using the Page Break Preview
• print a worksheet in a given scenario
• specify page set up options before printing a workbook in a given scenario

Excel 2007 Formulas and Functions

• identify the elements of a formula
• identify the default order in which calculations occur
• match absolute, relative, mixed, and 3-D references with examples
• insert an Excel 2007 formula
• use names to clarify formulas
• edit formulas
• work with Excel 2007 formulas in given scenarios
• use the AutoCalculate feature to perform basic functions
• use a logical function
• use a financial function
• use a date function
• use functions to perform calculations in Excel 2007
• use formulas and functions to calculate data in a given scenario

Excel 2007 Charts, Pictures, Themes, and Styles

• insert an Excel 2007 chart
• identify the main elements of a chart
• change Excel 2007 charts
• change the data range included in the chart
• move a chart to a new worksheet
• work with charts in Excel 2007
• insert illustrations in Excel 2007
• apply a theme
• apply a cell style
• use illustrations to enhance a worksheet
• use a predefined theme and style to create a professional-looking worksheet
• use charts, illustrations, themes, and styles to improve the visual impact of your workbook

Advanced Formatting in Excel 2007

• format chart elements in Excel 2007
• identify Chart Tools commands for customizing chart elements
• save and apply a chart template
• use the Adjust formatting commands to modify a picture
• recognize the commands for formatting a picture's style
• format a picture's size and properties
• format a chart
• modify a picture
• create a custom number format
• identify codes for custom number formats
• create a new conditional formatting rule
• recognize how conditional formatting cell precedence works
• find cells that have conditional formats
• create custom number formats
• create a new advanced conditional formatting rule
• use advanced formatting in Excel 2007

Advanced Data Management in Excel 2007

• sort data
• filter data in a range or table
• group and outline data
• insert subtotals in a worksheet
• display different levels of data using outlines
• outline data
• filter and sort data
• apply subtotals to data
• organize worksheet data to facilitate data analysis
• specify the data that is allowed in a particular range
• recognize which error alert to use in given examples
• locate and correct formula errors
• use the Watch Window to audit formulas
• locate and correct formula errors
• add data validation to prevent the errors from recurring

Advanced Customization in Excel 2007

• create an Excel template
• create new cell styles in Excel 2007
• customize Excel 2007 themes
• customize workbook settings
• change the workbook properties
• customize Excel 2007 workbooks
• record and run a macro
• match macro security settings with their effects
• edit and delete macros
• assign a button to a macro and add it to the Quick Access Toolbar
• to create a macro and add it to the Quick Access Toolbar

Analyzing Data in Excel 2007

• create a PivotTable report
• rearrange PivotTable data
• customize PivotTable reports
• modify the look and feel of a PivotTable report
• create a PivotChart report
• modify a PivotChart report
• perform calculations in PivotTables reports
• recognize when to use each calculation type
• create a PivotTable report
• customize a PivotTable report
• change the summary calculation in a PivotTable report
• create a calculation with a formula
• create a PivotChart
• use Goal Seek to perform data analysis
• use Solver to perform data analysis
• create scenarios for what-if analysis
• use the Scenario Manager to modify scenarios
• create a one-variable data table for data analysis
• create a two-variable data table for data analysis
• project values in a series
• perform advanced functions
• match advanced functions with examples of when you would use them
• consolidate data from different workbooks using a Summary function
• use Goal Seek
• use Solver to perform what-if analysis
• create a data table to perform what-if analysis
• use advanced functions and consolidate data

Protecting and Sharing Excel 2007 Workbooks

• protect a workbook in a given example
• apply worksheet protection in a given example
• identify the features of digital signatures in Excel 2007
• protect a workbook
• prevent users from editing a workbook
• apply worksheet protection
• share workbooks on a network location
• merge shared workbooks
• publish a workbook to a SharePoint library
• perform basic actions using SharePoint
• share a workbook on a shared network resource
• merge shared workbooks
• publish a workbook to SharePoint

Exchanging Data with Excel 2007

• create links to data
• identify how to import data
• embed a file in a workbook
• create database queries in Excel 2007
• import an entire Access table
• import Excel data into Access
• copy Excel data to Word
• import Excel data into Outlook
• embed a file in a workbook
• import data from a text file into Excel
• import data from a database into Excel
• use Excel data in a Word document
• retrieve data from an Access database using the Wizard
• create a manual query to retrieve data from an Access database
• identify how XML works in Excel
• recognize the components of a basic XML system
• create an XML map and map elements to it
• import XML data
• export XML data into mapped cells
• use XML data in Excel 2007