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.

Objective

 

  • 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.

Details

Do you want to get a better job or advance in your current position? This course can help you learn the Microsoft Excel skills you need to be a valuable asset in the workplace and prepare you to earn certification.

Through this program, you'll master all the Excel tasks you need to know, including:

 

  • Entering, copying, pasting, and filling data and formulas
  • Linking worksheets, consolidating data, and calculating revenue from several worksheets
  • Using the PivotTable and PivotCharts
  • Filtering and outlining data
  • Saving, sending, and sharing workbooks
  • Creating and modifying Tables

 

Upon completion, you will be prepared to earn your certification and gain an important edge in today's competitive job market. This program is Microsoft Approved Courseware and can help you prepare to earn Microsoft Office Specialist (MOS) certification. MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2010 suite. If you 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, this course will help you build the skills and knowledge you need.

Upon registering you are given six months to complete this program.

  • Registration + Fees

    Begins: Open enrollment | REGISTER

    Course: OMEX800.01

    Tuition: $795

  • Outline

    1. Beginning Guide to Microsoft Excel 2010
    a) Getting Started: How to use the online course
    b) Hello, Excel! Enter data and use basic text formatting
    c) It All Adds Up: enter data, labels and formulas
    d) A Question of Balance: Use and audit formulas from Excel’s formula library
    e) Charts and Chart Tools: Insert and modify Charts
    f) Picture the Data: Insert and format pictures
    g) Shapes, SmartArt, Views: Insert and modify Shapes and SmartArt, change View

    2. Intermediate Guide to Microsoft Excel 2010
    a) Legs, Eggs, and Pigs: Troubleshooting formulas and data
    b) Piggy Goes to Market: Use and modify TEXT formulas
    c) Name that Tune: Create, use and troubleshoot Named Ranges
    d) Sound Advice: Create and use Lookup Tables, use IF functions
    e) Excel In Print: Use page Layout and Page Set up to modify print settings
    f) Excel Online: Use and modify Sparklines and hyperlink

    3. Advanced Guide to Microsoft Excel 2010
    a) Works for Me! Create and modify Tables and apply Quick Styles
    b) Work Smarter, Not Harder: Use Sort, Filter, Outline, and Goal Seeking Tools
    c) What Happened? (Pivot Tables) Create and modify Pivot Tables
    d) What Did You See (Pivot Charts) Create and modify Pivot Charts and Slicers
    e) Working Overtime: Create drop-down lists and use Data Validation
    f) Prepare to Share: Use reviewing tools and permissions g) Working with Macros: Create and use Macros

  • 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.

    Click here to download the Acrobat Reader.
    Click here to download the Flash Player.

    All materials for this program are available online.

    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.

  • Instructors

    Clair Dickinson has a B.S. in secondary English education from Eastern Michigan University. She currently works as an online course facilitator in a lab setting, working with students taking courses towards their high school diplomas. She also completed her Graduate Certificate in Educational Media and Technology through Eastern Michigan University Online, doing all of the work online.

    She earned the Microsoft Office 2010 Master certification by passing the tests for Word, Excel, PowerPoint, and Outlook 2010. In addition, she has Microsoft Word 2003 Expert level certification. She has used every version of Office since 1995 and still enjoys finding new ways to use the software.

    In her spare time, Clair writes short crime stories and chases after her young son.

    Elizabeth Ann Nofs is the designer and developer of the Computer Mama guides. Her research on how men and women approach computer learning provided the foundation for the Comma Method of training, as well as The Computer Mama Show, a pilot produced with WFUM/TV28 (PBS), Flint, Michigan.

    She’s the author of 44 books, including: The Computer Mama Guide to Computers (2001), The Comma Method of Computer Training (2003), The Comma Teachers Edition (2003), The Complete Computer Guide (2005), and the Complete Computer Guides for Microsoft Office 2007 and Office 2010 (MOS) certification training.

    Elizabeth received her B.A. degree in biology from the University of Michigan, Ann Arbor.

  • FAQs

    1. Can I register for programs if I am an international student?

    Yes, because ed2go programs are online you never have to actually travel to the school. Most schools offer telephone or online registration.

    2. How long does it take to complete a program?

    Upon registering you are given six months to complete this program.

    3. Do I have to buy additional materials?

    You must have Microsoft Excel 2010 software already installed on your computer before taking the program. You must use the full retail version of Excel 2010. This course cannot be completed with the Microsoft Excel 2010 Starter, which comes free on many new PCs. Otherwise, all the materials you’ll need are included, and their cost will be covered in your tuition. Ed2go will ship all materials ground service upon enrollment.

    4. Can I get financial assistance?

    ed2go courses are non-credit courses, so they do not qualify for federal aid. In some states, vocational rehab or workforce development boards will pay for qualified students to take our courses.

    5. What happens when I complete the program?

    Upon successful completion of the program, you will be awarded a certificate of completion.

    6. Am I guaranteed a job?

    ed2go programs will provide you with the skills you need to obtain an entry-level position in most cases. We don't provide direct job placement services, but our facilitators and career counselors will help you build your resume and are available to give advice on finding your first job. Facilitators will also be available to use as a professional reference upon completion of the program. Potential students should always do research on the job market in their area before registering.

    7. Who will be my instructor?

    Each student is paired up with a facilitator for one-on-one interaction. The facilitator will be available (via e-mail) to answer any questions you may have and to provide feedback on your performance. All of our facilitators are successful working professionals in the fields in which they teach.

    8. What software or hardware do I need in order to take online programs and what are the system requirements?

    In order to take our online programs, you must have access to a computer and the Internet (high-speed Internet access is recommended). You can access the program contents from any Web-enabled computer. You will need the following Microsoft products already installed on your computer in order to take this program: Excel 2010, full retail version. Hardware requirements: • IBM-compatible (PC) computer • Processor: 1 GHz 32-bit (x86) or 64-bit (x64) • RAM: 1 GB of system memory MINIMUM • Hard Drive: 40 GB with at least 15 GB of available space • Video: Support for DirectX 9 graphics with WDDM Driver • 128 MB of graphics memory • DVD-ROM drive • Audio output • Adobe Acrobat Reader • Adobe Flash Player

    9. Can I use a Mac?

    No, you must access this program from a PC or IBM-compatible computer.

    10. How can I get more information about the program?

    If you have questions that are not answered on our website, please feel free to contact us via LIVE chat (click the button toward the top of the page). If you are visiting us during non-business hours, please feel free to send us a question using the "Contact Us" form to the right. You may also call us at 1-855-520-6806. We will answer your questions promptly.

    11. When can I start the program?

    Our programs are all open enrollment. You can register and start the program as soon as you are ready. Please note: Once the program curriculum is accessed online or through submission of a material shipment confirmation, refunds cannot be issued.

    12. What if I don't have enough time to complete my program within the time frame provided?

    The time allotted to complete your program has been calculated based on the number of hours for each program, so don't worry too much about not completing in time. If, after a concerted effort, you are still unable to complete, your Student Advisor will help you work out a suitable completion date. Please note that a fee will be charged for an extension.