Microsoft EXCEL 2010

Study247

Course

Online

Price on request

The best Office Systems courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Course Description
In order to succeed in today's business world, you must have competent skills in Microsoft Office. Whether you're an administrative assistant, office manager, sales professional or business manager, utilising all of the powerful features of Microsoft Office will make you more efficient and subsequently more marketable. Almost every job in the business world involves office products. Take your skills to the next level and make your current job easier to manage by completing our Microsoft Excel 2010 course.
The Microsoft Excel 2010 course has been designed to provide you with the essential skills you will need to be proficient in Excel 2010, in a work or home environment, in as short a time as possible. You don't need any prior experience of Microsoft Excel, but you will need to be familiar with using a computer and the Windows environment.
Get the skills employers are currently looking for, enrol today!

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Who Is This Course For?
Anyone looking to develop their Microsoft Excel 2010 skills.
By choosing online learning instead of a classroom based course, it eliminates the need for time away from work, saving you valuable time and money. It is ideal for those with tight schedules as our online courses give you 12 months unlimited access to all the course materials, so you can study at a pace that suits you. Allowing you to easily resume your studies whenever you have the time. All you need is internet connection to study, so you can study from the comfort of your home or any environment that suits you.

Requirements
Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.
For the best viewing experience on our state-of-the-art eLearning platform we recommend an internet connection of 10Mbps or better. Please also use Google Chrome or Mozilla Firefox as your browser with Adobe Flash Player

Certification Details
In order to earn your certification, you’ll have to sit an exam after completing your course with us. To prepare you for your exam, we provide interactive quizzes after each module and a mock exam at the end of your course to ensure you’re fully prepared for the real thing. Once you’ve passed with at least 85%, you’ll be ready to book your exam as a private candidate.
Booking your exam is pretty simple, just purchase your exam voucher and schedule your exam. To make life easier, we can help you find an appropriate exam centre and give you all the information you need to secure your place.
Please note that the exam fees aren’t included in the course price.
Got a question about exams? Contact one of our course advisors. We’re happy to help!

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
  • Microsoft Excel
  • Art
  • Ms Office
  • Microsoft excel training
  • MS Excel
  • Microsoft Office

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

See related categories

Microsoft EXCEL 2010

Price on request

The best Office Systems courses

See all

See all