India

Microsoft Excel 2010 Certification Training

With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Excel 2010 software
Temecula, CA P.O. Box 760,, Temecula, CA 92593
(951) 9723600

Course at a Glance

Mode of learning : Online - Instructor Lead(LVC)

Domain / Subject : Business & Management

Function : General

Duration : 95 Hours

Difficulty : Medium

Microsoft Excel 2010 Certification Training

With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Excel 2010 software.  You’ll cover basic through advanced topics, including formatting fonts, applying number formats, linking worksheets, creating a PivotTable, and more. Upon completion, you'll be prepared to earn your certification and gain an important edge in today's competitive job market.

Objectives
By completing the Microsoft Excel 2010 program, you will:

  • Be able to enter, copy, paste, and fill data and formulas
  • Learn how to link worksheets, consolidate data, and calculate revenue from several worksheets
  • Understand how to use the PivotTable and PivotCharts to automatically format and analyze data
  • Know how to filter and outline data
  • Be able to use the VLookup and HLookup function
  • Save, send, and share workbooks
  • Insert and modify Charts, Sparklines, pictures, SmartArt, and shapes
  • Apply QuickStyles to Charts, pictures, SmartArt, and Tables
  • Create and modify a Table

Students who wish to prepare for Microsoft Certification Exam 77-882:  MOS: Microsoft Office Excel 2010 OR Microsoft Certification Exam 77-888: MOS: Microsoft Office Excel 2010 Expert will find beginning through advanced lessons that demonstrate these requires MOS topics.

Requirements

This program can only be taken on a PC. It is not compatible with a Mac. It is compatible with the Windows XP and later operating systems and IE 7 and later browsers. You need a high-speed Internet connection and e-mail account. You should also have the following full-retail version Microsoft Office 2010 Products already installed: Excel and Word.
It is recommended that you use the latest version of Internet Explorer in place of other Web browsers.  Adobe Flash Player and Adobe Acrobat Reader are required for this program.

The following textbooks are available to download throughout the lessons:

  • Beginning Guide to Microsoft® Excel 2010
  • Intermediate Guide to Microsoft® Excel 2010
  • Advanced Guide to Microsoft® Excel 2010

Prerequisites

To enroll in the Microsoft Excel 2010 Online Training Program, you should have basic computer skills, be comfortable using an Internet browser and selecting commands from a menu or toolbar, be proficient in file management (save, print, and back-up files), and be able to select, edit, and format text.

This program is for you if you’re an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Excel skills immediately.  This program is also suitable for you if you’re looking to learn about this software and expand your job possibilities.

All of our programs are self-paced and open enrollment, so you can start them when you want and finish them at your own pace.

Course Content

  • Beginning Guide to Microsoft Excel 2010
    • Getting Started: How to use the online course
    • Hello, Excel! Enter data and use basic text formatting
    • It All Adds Up: enter data, labels and formulas
    • A Question of Balance: Use and audit formulas from Excel’s formula library
    • Charts and Chart Tools: Insert and modify Charts
    • Picture the Data: Insert and format pictures
    • Shapes, SmartArt, Views: Insert and modify Shapes and SmartArt, change View
  • Intermediate Guide to Microsoft Excel 2010
    • Legs, Eggs, and Pigs:  Troubleshooting formulas and data
    • Piggy Goes to Market: Use and modify TEXT formulas
    • Name that Tune: Create, use and troubleshoot Named Ranges
    • Sound Advice: Create and use Lookup Tables, use IF functions
    • Excel In Print: Use page Layout and Page Set up to modify print settings
    • Excel Online: Use and modify Sparklines and hyperlink
  • Advanced Guide to Microsoft Excel 2010
    • Works for Me! Create and modify Tables and apply Quick Styles
    • Work Smarter, Not Harder:  Use Sort, Filter,  Outline, and Goal Seeking Tools
    • What Happened? (Pivot Tables) Create and modify Pivot Tables
    • What Did You See (Pivot Charts) Create and modify Pivot Charts  and Slicers
    • Working Overtime:  Create drop-down lists and use Data Validation
    • Prepare to Share:  Use reviewing tools and permissions
    • Working with Macros: Create and use Macros

Photos

Write Your Own Review


Write your review here (required)


Consider:
Is the price of course overrated?
would you recommend this course to others?
Is duration of the course sufficient enough?
Did you like the faculties?
What would you prefer in future classroom or online learning?


Disclaimer: The contents of the course & Institute are obtained from the institute’s website by automated scraping or manual updates. For the latest information, please refer the institute website directly. For any discrepancies in the content, contact us at