Microsoft Office 2010 Specialist - Excel

Overview

Get Office 2010 skills on your CV Today!

Show your current or future employer that you are serious about your career.

The Microsoft Office Excel 2010 course provides students with the skills and knowledge needed to use the software effectively and efficiently including advanced software features.

Included Microsoft Office 2010 Specialist Course:

• Microsoft Office 2010 Excel

When you pass your Excel 2010 Exam, you will have achieved the Microsoft Certified Application Specialist (MOS) status in Excel 2010.

What do I actually get?

• Expert Instructor led training delivered via video streaming
• Extensive Demonstrations and presentations delivered in a multimedia format
• Practice Tests and exam simulators

*Course does not include exam fee.

New to IT students or existing IT Professionals wanting to validate skills and knowledge with Microsoft's internationally recognised Office 2010 Certifications.

Microsoft Certified Application Specialist - Excel, Awarded by Microsoft

Course Outline:

• Introduction
• Course Outline
• Introducing Excel 2010
• The Excel Interface
• Keyboard Shortcuts
• Section Review
• Basic File Commands and Operations
• Creating, Saving and Closing Workbooks
• Personalising 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
• Analysing and Organising 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
• Sparklines
• 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
• Customise the Excel Interface
• Section Review
• Course Review

Located in Sittingbourne, Kent in the United Kingdom, ITonlinelearning was founded by Jeremy Dargie in 2009. Our aim is to help both aspiring and seasoned professionals gain internationally recognised, accredited certifications that enable them to begin and develop their careers and develop into sought after and well-versed professionals.

We are able to tailor your courses to your specific needs, giving you the opportunity to study courses on offer from world-leading companies such as Microsoft, Cisco, CompTIA, PRINCE2, Adobe, NEBOSH and CIW, to name but a few. These certifications will help you, like thousands others, reach your certification goals and beyond, ensuring that you develop your chosen career into a lucrative and rewarding profession.