Font size:


This is a bundled training package. It contains training for each of the bundled items below:

Course Price
Advanced Formatting in Excel 2007 $74.95
Advanced Data Management in Excel 2007 $74.95
Advanced Customization in Excel 2007 $74.95

Bundle Price: $139.00
Total Savings: $85.85

Advanced Formatting in Excel 2007

Charts and pictures enable you to present data visually, demonstrating data more effectively than rows and columns of data. In Excel 2007, you can customize charts and their individual elements, as well as pictures and clip art, to create professional and appealing documents. Formatting, both custom and condition-based, enables you to display data in formats that best suit your needs. This course explores modifying charts and pictures and creating and editing custom number formats.

Learning Objectives
  • 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

Excel 2007 provides multiple features for organizing and managing data, so you can ensure data is entered correctly and that calculations and formulas are valid. Data organization features enable you to sort, filter, and group and outline data so that you can focus on the key parts of your data. Validation features ensure that data is correct, that it is entered in the proper format, and that formulas are working correctly, all of which are incredibly important for maintaining accurate records. This course explores organizing and subtotaling data in Excel 2007 using the available features. It also covers data validation, including error messages, invalid data prevention, formula auditing, error checking, and the Watch window.

Learning Objectives
  • 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

Numerous features and tools in Excel 2007 enable you to customize the look and feel of spreadsheets and workbooks, and also the functionality and efficiency of the program itself. Existing templates, themes, and styles can be altered to meet business needs, or you can create custom templates, themes, and styles to further enhance data presentation. Using macros, you can automate common or repetitive tasks, resulting in time savings and increased efficiency in day-to-day tasks. This course covers creating templates in Excel 2007, as well as customizing workbook properties, themes, and styles. Working with macros, including recording, editing, and running, is also explored.

Learning Objectives
  • 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
Register Now
Microsoft Office 2007: Advanced Excel e-learning bundle
  • Course ID:
  • Duration:
    5 hours
  • Price: