Microsoft® Office 2010 Specialist | Excel (Includes Access to our IT Library)
Add Office 2010 skills to your CV.
ITonlinelearning
Summary
- Exam(s) / assessment(s) not included in price, and must be purchased separately
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.
Why not explore our training for FREE?
Explore the great variety of courses free and get an exact idea of how the training is delivered.
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.
When can I Start?
Online learning allows you to start anytime, even Today!
Enquire Now >>
Our friendly consultants are waiting to help you.
** This course bundle is part of our IT Library which also includes Certified Network Professional (CCNP), CISSP, MCSA: Windows Server 2016, MCSE: Cloud Platform and Infrastructure and MCSE: Productivity and many more **
Certification
Microsoft Office Specialist (MOS) IT
Description
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
Who is this course for?
New to IT students or existing IT Professionals wanting to validate skills and knowledge with Microsoft’s internationally recognised Office 2010 Certifications.
Requirements
There are no academic requirements for this course.
Career path
- IT System administrator
- IT Infrastructure Manager
- Desktop support engineer
- Cloud Applications Administrator
- Software as a Service Administrator
- 1st Line, 2nd Line IT Support Engineer
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.