Microsoft Excel 2007 : New Features


Untitled Document

Package Includes:
  • Featuring live instructor-led classroom sessions with full audio, video and demonstration components
  • Printable courseware
  • Step-by-step hands-on-labs Try out one of our labs...
  • Exclusive LearningZone Live Mentor Click for Details (Value at $195)
    Help Whenever you need it! Exclusive LearningZone - Chat Live with our Certified Instructors anytime around the clock (7x24)
  • 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 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...
  • Exclusive Learning Zone
    Train around the clock, around the world. Our certified online instructors are located at global support centers in the U.S., U.K., Australia, and Singapore to provide real-time answers to technology- and soft-skill-related questions 24x7. This means access to a live subject matter expert no matter where you are - day or night. This level of student/instructor interaction provides real-time training specific support and extends training beyond content and instructor-led solutions by providing flexibility to accommodate individual needs and schedules.
  • 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 where.
  • 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.
  • Certificate of Completion
    Career Academy is recognized worldwide for its technology-based IT training curriculums. Upon successful completion of our program, you will be receiving a Career Academy Distance Education Certificate of Completion.
Course Outline TXT
Lesson 1 - Exploring the Excel Environment
Exploring the Excel Environment
The Microsoft Office Button
Demo - Explore the User Interface
The Ribbon
Demo - The Ribbon
Demo - Excel Options
ScreenTip Enhancements
The Quick Access Toolbar
Demo - The Quick Access Toolbar
The Microsoft Office Window Frame
The Page Layout View
The Home Tab
The Insert Tab
The Page Layout Tab
The Formulas Tab
The Data Tab
The Review Tab
The View Tab
The Developer Tab
Dialog Box Launchers
Contextual Tabs
Program Tabs
The Mini Toolbar
Galleries
The Live Preview Feature
Demo - Galleries and Live Previews
The Excel Options Dialog Box
Lesson 1 Review
Lesson 2 - Organizing Data Organizing Data
Excel Spreadsheet Enhancements
New Workbook Dialog Box
Excel Template Enhancements
Themes
Demo - Enhancements and Themes
The Enhanced Excel Table
Table Tools
Demo - Insert a Table
Demo - Using Table Styles
Lesson 2 Review
Lesson 3 - Analyzing Data
Analyzing Data
The Conditional Formatting Button
Conditional Formatting Categories
The Conditional Formatting Rules Manager Dialog Box
Demo - Conditional Formatting
Enhanced Sort Options
Demo - Sort Data
The Enhanced Formula Bar
The Formula AutoComplete Feature
The Enhanced Function Wizard
The Function Library
The Name Manager Dialog Box
Calculation Options
Demo - Range, Name, and Formula
Lesson 3 Review
Lesson 4 - Presenting Data
Presenting Data
Enhanced Charts
Demo - Create a Chart
The SmartArt Graphics Gallery
The Enhanced Shapes Gallery
Demo - Smart Art
Enhanced PivotTables
Demo - Create a PivotTable
Demo - Create a PivotChart
Enhanced Save As Options
The Prepare Options
Demo - Mark as Final
Lesson 4 Review
Course Closure




Price: $99.00
Buy Product Online | Visit Store Home
   


 Other Items from Office Users

  Microsoft Office XP Training - 
  Internet Explorer and Email Basics - 
  PC Security Virus and Spam protection - 
  Microsoft FrontPage 2003 Training - 
  Microsoft Project 2003 Training - 
  Microsoft Word 2007 : New Features - 
  Microsoft Excel 2007 : New Features - 
  Microsoft Access 2007 : New Features - 
  Microsoft Access 2007 : New Features - 
  Microsoft Word 2007 : Level 1 Training - 
  Microsoft Word 2007 : Level 2 Training - 

 

  Return To MCSE Training A+ Certification CCNA CISSP CEH Training Microsoft eLearning MCSD Computer Training videos and CBT

 

 

Ecommerce
E-commerce powered by MonsterCommerce shopping cart.