Microsoft Excel 2007 : Level 2 Training

Schedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the Best Certified Trainers in the industry to help us develop the ultimate training and certification programs which include everything you will need to fully prepare for and pass your certification exams.

Microsoft Office Excel 2007 is a powerful tool you can use to create and format spreadsheets, and analyze and share information to make more informed decisions. With the new Microsoft Office Fluent user interface, rich data visualization, and PivotTable views, professional-looking charts are easier to create and use. Office Excel 2007, combined with Excel Services, a new technology that will ship with Microsoft Office SharePoint Server 2007, provides significant improvements for sharing data with greater security. You can share sensitive business information more broadly with enhanced security with your coworkers, customers, and business partners. By sharing a spreadsheet using Office Excel 2007 and Excel Services, you can navigate, sort, filter, input parameters, and interact with PivotTable views directly on the Web browser.

Our reputation speaks for itself! See what others are saying... Testimonials

Package Includes:

1 DVDs Featuring live instructor-led classroom sessions with full audio, video and demonstration components
Step-by-step hands-on-labs Try out one of our labs...
Focused on practical solutions to real-world development problems
Free 1 Year Upgrade Policy

Sandra Batakis - A+ Trainer, MCT, MCSE, CIW
Sandra is a Senior Microsoft Certified Instructor with over 15 years in the IT certification training and courseware development field. She has offered a wide variety of IT training and high level consulting projects for Fortune 500 companies. She possesses extensive hands-on IT experience including working with building computer networking infrastructure, configuring LAN, WAN and Internet security gateways, Implementing and migrating to Microsoft Exchange 5, 2000, 2003, 2007 and the new Exchange 2010. She has delivered numerous Microsoft, CompTIA and Adobe classroom-based as well as online Boot Camps and Seminars across the United States.

Course Features:

Explore our Training Features

Click on a Feature for more information! (popups must be enabled)

This slideshow requires Adobe Flash Player 9.0 (or higher). JavaScript must be enabled.

Lesson 1 - Enhancing Workbooks

Enhancing Workbooks Personalize Options
Demo - Excel Options
Lab - Customizing the Excel Interface
Color Scheme
Modified Excel Environment in Windows Vistas (Black)
Built-In Theme Options
Create New Theme Colors Options
Create New Theme Fonts Options
Demo - Custom Worksheet
Lab - Customizing an Excel Worksheet
Lab - Enhancing Worksheets using Themes
Comments
Demo - Comments
Lab - Manipulating Comments
Hyperlinks
Demo - Creating Hyperlinks
Lab - Creating a Hyperlink to an Existing File
Lab - Editing and Removing Hyperlinks
Research Task Pane
Demo - Research
Lab - Using Web-Based Research Tools
Lesson 1 Review

Lesson 2 - Creating Workbooks Using Templates

Creating Workbooks Using Templates The Expense Template
Demo - Using Templates
Lab - Creating a Workbook from a Template
Types of Excel Templates
An Example of a Custom Template
Demo - Creating Templates
Lab - Creating a Custom Template
Lesson 2 Review

Lesson 3 - Organizing Data Using Tables

Organizing Data Using Table sAn Excel Table
Demo - Create Table
Lab - Creating a Table Using the Default Table Style
Demo - Table Styles
Lab - Creating a Table Using the Desired Table Style
Lab - Modifying a Table
Lab - Formatting a Table
Lab - Creating a Custom Table Style
Lesson 3 Review

Lesson 4 - Presenting Data Using Charts

Presenting Data Using Charts Create A Chart
Demo - Create A Chart
Lab - Modifying a Table
Modify Charts
Lab - Modify a Chart
Demo - Changing a Chart Type
Format Charts
Lab - Formatting a Chart
Lab - Creating a Chart Template
Share Charts
Demo - Move Chart
Lab - Sharing a Chart
Lesson 4 Review

Lesson 5 - Analyzing Data Using PivotTables and PivotCharts

Analyzing Data Using PivotTables and PivotChartsSource Data for a PivotTable
Summarizing Data with a PivotTable
A PivotTable Report
Demo - Create Pivot
Lab - Performing Calculations Using a PivotTable
A PivotChart
Demo - Pivot Chart
Lab - Creating a Pivot Chart
An Existing PivotTable and Corresponding PivotChart
Demo - Modify Pivot
Lesson 5 Review

Lesson 6 - Enhancing Visual Appeal Using Graphic Objects

Enhancing Visual Appeal Using Graphic Objects
Graphic Objects
Demo - Insert and Modify Picture
Lab - Inserting a Picture in a Worksheet
Lab - Modifying Pictures
Lab - Applying Picture Shape to a Graphic
Lab - Drawing and Modifying Shapes
Lab - Rotating Shapes
Layering
Lab - Layering Graphics
Demo - Smart Art
Lab - Inserting a SmartArt Graphic
Lab - Modifying a SmartArt Graphic
Grouping
Lab - Grouping Objects
Demo - Clipart
Lesson 6 Review

Lesson 7 - Calculating Data with Advanced Formulas

Calculating Data with Advanced Formulas Range Names
Demo - Create Name
Lab - Naming a Range
Lab - Renaming a Range
Lab - Using Named Regions in Formula Calculations
Lab - Adding Columns to a Worksheet Containing Page Names
Three-Dimensional Cell References
Demo - Calculate Data Across
Lab - Comparing a 360-Day vs. 365-Day Date Calculation System
Date and Time Function
Demo - Dates
Financial Function
Demo - Convert Text To Columns
Lab - Using Formulas to convert text data to individual columns
Demo - Statistical Function
Demo - Upper and Lower
Lab - Using the UPPER, LOWER, and PROPER Text Functions
Lookup and Reference Function
Demo - Hlookup
Lab - Looking up Part Numbers with the HLOOKUP Function
Lab - Looking up Part Numbers with the VLOOKUP Function
Logical Function
Demo - If Statement
Lab - Performing Conditional Calculations with SUMIFS, COUNTIFS, and AVGIFS Functions
Lab - Performing Conditional Calculations with SUMIF, COUNTIF, and AVERAGIF Functions
Lab - Calculating Sales Honors with IF Function and the AND Function
Lab - Calculating Sales Honors with IF Function and the OR Function
Lab - Eliminating Calculation Errors with the IFERROR Function
Demo - View and Print Formulas
Lab - Printing a Worksheet with the Formulas Displayed
Lesson 7 Review

Lesson 8 - Sorting and Filtering Data Sorting and Filtering Data Single-Level Sort in Ascending Order

Multiple-Level Sort in Both Ascending and Descending Order
Demo - Sort Data
Lab - Sorting Data
Filter
Lab - Filtering Data
Lab - Calculating Sums, Counts, and Averages on Filtered Data
Database Function
Subtotals
Demo - Subtotals
Lab - Applying Subtotals to a Sorted List
Lesson 8 Review
Course Closure