COURSE OVERVIEW

Sign up for this course taught by industry experts and you'll never miss a class or lecture since you can complete it when it's convenient for you. We collaborated with premier Office Trainers to help us create a superior certification and training program.

This complete course will familiarize you with every feature and function of Excel 2010. It's designed for users of all skill levels. The class begins with simple concepts before slowly progressing to more difficult ones. Following a brief summary of window features and spreadsheet terms, students are taught how to navigate through workbooks and utilize the help feature. After the introduction, students will learn how to edit content, pictures, formulas, and values and save workbooks in several different formats. Additionally, students will learn how to copy and export data, utilize relative and absolute references, and setup columns, rows, and ranges. Moreover, this course introduces students to basic functions, formatting strategies, charts, and workbook management.

Students will also be taught how to use multiple workbooks effectively, and they'll be shown how to utilize advanced options for formatting and creating backgrounds, outlines, themes, and styles. Students are also shown how to obtain subtotals, create cell names, and create and edit tables. Additionally, this course teaches students how to save their work as web content, edit and place hyperlinks into excel sheets, and transmit workbooks via email. Other course topics include charting strategies, utilizing spark and trend lines, auditing worksheets, securing worksheets, and file sharing.

Before finishing the course, students will learn about advanced formulas and lookup functions, including MATCH, VLOOKUP, and INDEX. They'll also be taught about database functions, including DSUM, data validation, and Pivot Charts and Tables. Students will finish the course with the ability to query external databases, format by using graphics, and record macros. Finally, students will be taught how to utilize Excel's analytical features, including Solver, Goal Seek, and SmartArt graphics.

PACKAGE INCLUDES

3 DVD-ROMs that include live demonstrations, video, audio, and courses taught by leading authorities

Printable study guides

LearningZone Live Mentor Click for Details. ($695 Value)
Support from experts around the clock! Exclusive LearningZone - Chat online with Certified Instructors 24 hours a day

Students are taught how to solve everyday work problems

1 year upgrade policy free of charge

YOUR INSTRUCTOR

Debbie Fierst - Has taught ColdFusion, Microsoft Project, and Dreamweaver for over 5 years. Debbie has been developing websites since the 90's, developing more than 100 using various technologies, including ColdFusion, HTML, ASP .Net, JavaScript, and XML. She has consulted with large corporations, the National Security Agency, and the Air Force about various project management strategies. Debbie has applied these strategies at her web design company.

FEATURES

Main Menu
The organized and effective structure enables users to browse through hours of comprehensive content rapidly and with ease.

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.

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.

Study Guides
Users can print entire course study guides, permitting them to view and review course material at their convenience.

Review Exercises
Every section contains a review quiz to assist and enhance learning by testing whether students comprehend course concepts before moving forward.

Resume
Every course resumes where you finished during the previous session in case you forget where you stopped.

Live Demonstrations
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.

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.

Topic A: Logical Functions
The IF Function
Demo - A-1: Using the IF Function
AND, OR, and NOT Functions
Demo - A-2: Using OR, AND, and NOT as Nested Functions
Nested IF Functions
Demo - A-3: Using Nested IF Functions
The IFERROR Function
Demo - A-4: Using the IFERROR Function