Microsoft Office Excel 2010 Expert

Overview

Who is it for?

Whatever job you’re looking to do, MOS training helps you present yourself as truly knowledgeable and differentiates you in a competitive job market. For employers, identifying candidates with the Microsoft Office skills helps them in making job placement decisions. Show employers that they need only train you the particulars of your role, not how to use the tools. 

What is it about?

Get that job by boosting your CV with the skills employers are looking for. Completing the Microsoft Excel Expert 2010 training demonstrates these skills and differentiates you as committed to growing them to develop your career prospects.

You will be learning on SkillSoft software. SkillSoft is the world leader in e-learning for businesses, and is used by multinational companies such as FedEx, Hilton, VirginMedia and Hewlett Packard. By training with SkillSoft you will be working with an industry recognised organisation and investing in training that employers already know and trust.  

Description

When can I start?

You can enrol at any time - start today.

Are there any requirements?

There are no formal requirements for this course.

What skills will I gain?

You will be trained to navigate through spreadsheets comfortably, and be able to edit their content to present valuable data to colleagues and managers. You will learn how to input cell data, format them to give them different properties and to split and merge cells so you can present data exactly how you want. You will be able to hide and unhide rows and columns, and filter data, so that your colleagues can get to the data they need with the minimum of fuss. You will start to use formulas in your excel spreadsheets to perform calculations; make Excel do the maths so you don’t have to. These skills will demonstrate to employers that you are a candidate who can handle and present data in an efficient and professional manner. 

Module breakdown

In completing your MOS Excel Expert training you will cover the following topic areas:

• Getting started with excel 2010
• Applying basic data formatting in excel 2010
• Moving and getting around in excel 2010
• Moving data and modifying worksheets in excel 2010
• Saving, sending, and printing excel 2010 workbooks
• Using conditional formatting, tables, and sparklines in excel 2010
• Reviewing and protecting content in excel 2010
• Using basic formulas in excel 2010
• Using basic functions with excel 2010
• Inserting basic charts in excel 2010
• Adding visuals, themes, and styles to excel workbooks
• Customising visual elements in Excel 2010
• Customising workbook settings, conditional formatting, and number formats
• Organising data and objects in Excel 2010
• Ensuring Excel 2010 data and formulas are right

What support is available?

• Your training takes place through easy-to-navigate video, audio and interactive tutorials
• At the end of each section you will have the opportunity to sit multiple-choice practice tests to check how you are getting on
• LiveChat Mentors, and our Student Support team, will be available to help you along the way

How will I be assessed?

This course will prepare you for the MOS Excel Expert exams, 77-883 and 77-888. These will require booking and purchasing separately. 

What should I do next? For a free consultation call a specialist Essential Skills Learning Consultant on 0207 980 2844 or enquire online today to request a call back.