Excel 2010 (77-882)

Course

Online

£ 195 VAT inc.

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    12 Months

  • Start date

    Different dates available

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

Completion Certificate awarded upon completion to show employers your new skills
Free upgrade on to our state of the art platform
12 Months unlimited Access
Excel 2010 (77-882)

Excel 2010 MOS Certification training courses prepare students for the MOS exams by teaching greater skill mastery in Microsoft Excel 2010. Candidates must pass one exam in order to earn the MOS credential.

The MOS exams provide a valid and reliable measure of technical proficiency and expertise in Microsoft Office Excel 2010 by evaluating the ability to use the advanced features in the product to solve real-world business problems.

In today’s competitive economic climate, having certifications that validate one’s skills are essential to “set yourself apart from the pack” in the marketplace. Having Microsoft certifications not only increase one’s marketability but also validates an employee’s skills and experience to a potential employer. IT University is committed to helping all of our students in their given profession and has designed this bundle specifically to help any Business, HR, Sales, Office, Administration or Accounting professional gain the skills and certification they need to help them attain the positions they desire.

In today’s marketplace computers are a part of daily life for almost everyone in an office setting. Many people spend hours on projects that could take minutes if they had the necessary training to expedite their day to day tasks.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Office IT
  • Art
  • MS Excel
  • Ms Office
  • Introducing
  • Outline
  • Existing
  • Workbooks
  • Templates
  • Personalizing

Course programme

Course Syllabus

Introduction
  • Course Outline
  • Introducing Excel 2010
  • The Excel Interface
  • Keyboard Shortcuts
  • Section Review
Basic File Commands and Operations
  • Creating, Saving and Closing Workbooks
  • Personalizing Files and Opening Workbooks
  • Viewing Existing Workbooks and Applying Templates
  • Keyboard Shortcuts
  • Section Review
Creating, Managing and Navigating the Worksheets
  • Creating and Managing Worksheets
  • Navigating the Worksheets
  • Keyboard Shortcuts
  • Section Review
Entering and Managing Worksheet Data
  • Worksheet Basics and Cell Range Selection
  • Entering Cell Content and Multiple Cells
  • AutoContent and Undo, Redo and Repeat
  • Updating and Clearing Cell Content
  • Inserting and Deleting, Rows and Columns
  • Copying, Cutting, Pasting and Moving Contents
  • Keyboard Shortcuts
  • Section Review
Formatting Cells and Worksheets
  • Formatting Cells and Applying Formats
  • Alignment
  • Merging Cells and Cell Styles
  • Numbers
  • Apply and Modify Formats
  • Using Table Features
  • Keyboard Shortcuts
  • Section Review
Applying Formulas and Functions
  • Creating Formulas
  • Using Cell References
  • Managing and Updating Formulas
  • Creating Functions
  • Conditional Statements
  • Error Messages
  • Keyboard Shortcuts
  • Section Review
Analyzing and Organizing Data
  • Find and Replace
  • Sorting
  • Filtering
  • Conditional Formatting and Keyboard Shortcuts
  • Section Review
Naming and Hyperlinks
  • Naming Cells and Ranges
  • Hyperlinks
  • Section Review
Displaying Data Visually Using Charts
  • Charting
  • Layout Chart Element Options and Format
  • Spark lines
  • Keyboard shortcuts
  • Section Review
Preparing to Print and Printing
  • Preparing to Print with Page Layouts
  • Section Review
Share Worksheet Data with Other Users
  • Sharing a Document and Managing Comments
  • Section Review
Including Illustrations and Graphics in a Workbook
  • Inserting and Formatting Pictures
  • Inserting and Formatting Clip Art
  • Inserting and Formatting Shapes, Word Art and Text Boxes
  • Inserting and Formatting Smart Art
  • Keyboard Shortcuts
  • Section Review
Customize the Excel Interface
  • Section Review
  • Course Review

Excel 2010 (77-882)

£ 195 VAT inc.