972-377-0074 ext 3256
- IT CERTIFICATION
- DESKTOP & OFFICE
- WEB & GRAPHICS
- SECURITY & NETWORKING
- PROJECT MANAGEMENT
- TRAINING LIBRARIES
Microsoft Excel 2007 : New Features
Complete our classroom training taught by leading trainers and you will never miss a single session. You are entirely in control. We worked with certified instructors to create the premier training program developed for people preparing for certification exams.
Microsoft Office Excel 2007 can be used to develop and format spreadsheets and evaluate and share data with others to make better business decisions. It's never been easier to use and create glitzy charts with Microsoft Office Excel. New features include the PivotTable views, detailed-data visualization, and Fluent user interface. It also comes with a new feature, Excel Services, which makes it easier to share secure data. This makes it possible to share sensitive data with business colleagues, clients, and co-workers. It's possible to filter, sort, utilize PivotTable views, and input data on a web browser with Excel Services and Office Excel 2007.
- This course features instructor demonstrations, video lectures, and full audio
- Interactive Labs Try out one of our labs...
Exclusive LearningZone Live Mentor Click for Details. ($695 Value)
Assistance whenever it's needed! Exclusive LearningZone - Communicate online with certified trainers 24/7
- We teach practical solutions to common development problems
- 1 Year Upgrade for Free
Sandra has more than 15 years experience developing IT training programs. She is also a Senior Microsoft Certified Instructor. Sandra has consulted with Fortune 500 companies about IT training. She also has years of real-world experience installing networking infrastructure, configuring Internet security gateways, WAN, and LAN, and transitioning to Microsoft Exchange 5, 2000, 2003, 2007, and 2010. Sandra has taught numerous classes about Adobe, CompTIA, and Microsoft products, and she has made presentations at online Boot Camps.
The organized and effective structure enables users to browse through hours of comprehensive content rapidly and with ease.
PowerPoint presentations improve instruction by displaying all types of information for users. They can better comprehend material by viewing graphs, definitions, charts, etc.
Exclusive Learning Zone
Train anywhere in the world at any time. Certified online instructors are situated at international support centers in the United States, United Kingdom, Australia, and Singapore to offer support and answer technology-related questions 24 hours a day. In other words, no matter where you live, you can communicate with specialists at any time. This level of interaction between instructors and students makes it possible for students to get answers to specific questions at their convenience.
Move ahead, review, or repeat previous topics and sections. A progress bar monitors progress as you complete exercises.
Full Motion Video
Every course offers full-motion videos of classroom instruction. It's as if you're sitting in a classroom. Our one of a kind delivery mimics a one-on-one classroom setting for more personalized educational experiences.
Every section contains a review quiz to assist and enhance learning by testing whether students comprehend course concepts before moving forward.
Every course resumes where you finished during the previous session in case you forget where you stopped.
Instructors provide live and "hands on" demonstrations to explain and show users how to complete tasks. This enables users to witness professionals perform everyday tasks in real world settings as often as they like.
This course offers interactive labs, making it possible for students to obtain hands-on learning. This setting enables you to use the software without buying it or installing it on a computer.
Certificate of Completion
We are internationally recognized for our technology-centered IT training programs. Once you finish a program, you'll receive a Certificate of Completion.
Lesson 1 - Exploring the Excel Environment
The Microsoft Office Button
Demo - Explore the User Interface
Demo - The Ribbon
Demo - Excel Options
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
The Mini Toolbar
The Live Preview Feature
Demo - Galleries and Live Previews
The Excel Options Dialog Box
Lesson 1 Review
New Workbook Dialog Box
Excel Template Enhancements
Demo - Enhancements and Themes
The Enhanced Excel Table
Demo - Insert a Table
Demo - Using Table Styles
Lesson 2 Review
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
Demo - Range, Name, and Formula
Lesson 3 Review
Demo - Create a Chart
The SmartArt Graphics Gallery
The Enhanced Shapes Gallery
Demo - Smart Art
Demo - Create a PivotTable
Demo - Create a PivotChart
Enhanced Save As Options
The Prepare Options
Demo - Mark as Final
Lesson 4 Review