Microsoft Excel 2007 : Level 3 Training


Untitled Document

Package Includes:
  • 1 DVD 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
OURexpertText
Sandra Batakis

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)
Course Outline TXT
Lesson 1 - Steamlining Workflow
Steamlining Workflow
Macro
Record Macro Procedure Reference
Demo - Macros
Editing Macros
Macro Settings
Demo - Edit Macros
Conditional Formatting
Conditional Formats
Conditional Formatting Procedure Reference
Demo - Conditional Formats
Data Validation
Data Validation Procedure Reference br /> Workbook Properties
Demo - Data Validation
Lesson 1 Review
Lesson 2 - Collaborating with Others
Collaborating with Others
The Collaboration Process
File Protection
The Changes Group
The Protect Workbook Options
Demo - Protection
Sharing Workbooks
Shared Workbooks
Sharing Workbooks Procedure Reference
Demo - Share Workbook
Revision Tracking
Revision Tracking Procedure Reference
The Highlight Changes Dialog Box
The Accept/Reject Changes Option
Demo - Changes
Merge Workbooks
Demo - Merge Workbooks
Digital Certificates
Digital Signatures
Demo - Digital Signature
Demo - Mark As Final
Lesson 2 Review
Lesson 3 - Auditing Worksheets
Auditing Worksheets
Tracer Arrows
Cell Precedents
Cell Dependents
Demo - Tracing
Invalid Data
Error Checking
Demo - Invalid Formulas
The Watch Window
Demo - Watch and Evaluate
Formula Evaluation
Outline
Demo - Group and Subtotals
Lesson 3 Review
Lesson 4 - Analyzing Data
Analyzing Data
Trendlines
Trendline Procedure Reference
Demo - Trendline
Scenarios
The Scenario Manager Dialog Box
Demo - Scenario
The Solver Parameters Dialog Box
Demo - Solver
Analysis ToolPak
Demo - Data Analysis
Lesson 4 Review
Lesson 5 - Working with Multiple Workbooks
Working with Multiple Workbooks
Workspaces
Demo - Workspace
Data Consolidation
The Consolidate Dialog Box
Link Cells
Demo - Consolidate Data
Demo - Edit Links
Lesson 5 Review
Lesson 6 - Importing and Exporting Data
Importing and Exporting Data
File Export
Demo - Export to Word
File Import
The Get External Data Group
Demo - Import Delimited Text File
Delimited Text Files
Lesson 6 Review
Lesson 7 - Using Excel with the Web
Using Excel with the Web
File Publish
The Publish As Web Page Dialog Box
Demo - Publish Data
Import Data From Web
Demo - Import Data from Web
The New Web Query Dialog Box
Lesson 7 Review
Lesson 8 - Structuring Workbooks with XML
Structuring Workbooks with XML
XML
XML Uses
XML Components
XML Schema
XML Schemas
XML Map
XML Maps
The XML Source Task Pane
The XML Group
Demo - XML Map
Demo - XML Data
Lesson 8 Review
Course Closure



Price: $79.00
Buy Product Online | Visit Store Home
   


 Other Items from Office Users

  Office 2003 MOUS Training - 
  Microsoft Publisher 2003 Training - 
  Microsoft FrontPage 2003 Training - 
  Microsoft Word 2007 : Level 1 Training - 
  Microsoft Word 2007 : Level 2 Training - 
  Microsoft Excel 2007 : Level 1 Training - 
  Microsoft Excel 2007 : Level 2 Training - 
  Microsoft Word 2007 Training - 
  Microsoft Excel 2007 Training - 
  Microsoft Access 2007 : Level 1 Training - 
  Microsoft Access 2007 : Level 2 Training - 

 

  Return To MCSE Training MCITP A+ Certification CCNA CEH Training IT Computer Training, Online, eLearning, Videos and CBT

 

 

e-commerce software
E-commerce powered by MonsterCommerce shopping carts.