PrintE-mail

Microsoft Excel 2007 : Level 3 Training

 
Microsoft Excel 2007 : Level 3 Training
View Full-Size Image



Microsoft Excel 2007 : Level 3 Training Online $175.00  $99.00

:

Microsoft Excel 2007 : Level 3 Training DVD CBT $175.00  $99.00

:



Microsoft Office Excel 2007 : Level 3


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.

Package Includes

  • The Online course features 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
  • *This product options are only available in the DVD/CD CBT format and not available in the On-Line Delivery.

Sandra Batakis - A+ Trainer, MCT, MCSE, CIW
Sandra is a Senior Microsoft Certified Instructor with over 10 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 and the new Exchange 2007. She has delivered numerous Microsoft, CompTIA and Adobe classroom-based as well as online Boot Camps and Seminars across the United States.

Course Features

Main Menu
Move through hours of in-depth content, quickly and easily due to the efficient and organized structure.
PowerPoint
Utilizing PowerPoint presentations enhances the delivery by displaying a variety of visual information to the user. This type of representation allows the user to better interpret the material through charts, definitions, graphs, and more...
Controls
Move forward, back, and repeat entire topics or just a section. A progress bar illuminates as you advance through exercises.
Full Motion Video
All courses feature full-motion videos of instructors teaching the information as if they are speaking directly to you. Our unique delivery simulates a one-on-one classroom environment creating a more personal lesson and learning experience.
Review Exercises
Each section has a review quiz to aid in the learning process by validating the comprehension of the material covered before moving on to a new section.
Resume
All courses are resumed to where you left off last session allowing you to learn when it is convenient for you without the hassle of remembering where you were.
Labs
This course features cutting-edge, interactive labs, which provide a hands-on learning experience. This environment allows you to interact with the software with out the need for purchasing it or having it installed on your computer.

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
  • vTrendline Procedure Reference
  • Demo - Trendline
  • Scenarios
  • The Scenario Manager Dialog Box
  • Demo - Scenario
  • The Solver Parameters Dialog Box
  • Demo - Solver
  • Analysis ToolPak
  • Demo - Data Analysis
  • vLesson 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
  • vLesson 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




You may also be interested in this/these product(s)

Microsoft Excel 2007 Training
Microsoft Excel 2007 Training
$299.00
$199.00
You Save: $100.00
Microsoft Office 2007 Training
Microsoft Office 2007 Training
$795.00
$595.00
You Save: $200.00
Microsoft Excel 2007 : Level 1 Training
Microsoft Excel 2007 : Level 1 Training
$175.00
$99.00
You Save: $76.00
Microsoft Excel 2007 : Level 2 Training
Microsoft Excel 2007 : Level 2 Training
$175.00
$99.00
You Save: $76.00


Last Updated: Friday, 30 July 2010 18:12
RocketTheme Joomla Templates