Upgrade your skills with an extra 25% off selected courses with codeMTA25

Microsoft Excel 2010

19.9900 2023-12-30 MOS001 19.9900
69 69 69 0 The Microsoft Excel 2010 course has been designed to provide you with the essential skills you will need to be proficient in using Excel 2010, in a work or home environment, in as short a time as possible. https://mytrainingacademy.org.uk/pub/media/catalog/product/w/e/webp.net-resizeimage_2_.jpg

All students enrolled on this course are entitled to apply for an XO student discount card.

  • Type : Online Course
  • Duration : 6 Hours
  • Access : 12 Months
  • Awarded By : MTA
  • Eligible to Apply : Yes
The Microsoft Excel 2010 course has been designed to provide you with the essential skills you will need to be proficient in using Excel 2010, in a work or home environment, in as short a time as possible.
Course Description
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.

Microsoft Excel is one of the most commonly used spreadsheet programmes, whether used in businesses for customer data and accounting purposes or at home for household budgets. Having proven skills in this software will demonstrate to employers that you have had practical, hands-on experience and give you full confidence in your ability to navigate your way around the software with ease.

Depending upon the version of Excel you need, we have the perfect course for you; including the most up to date version, Microsoft Excel 2019 as well as 2016, 2013 and 2010.

Course Duration

The online Microsoft Excel 2010 course requires 6 hours to complete the course in full. This is only a guide to the learning hours required and it depends on how quickly an individual can absorb the information. The learning is online so it can be spread out over multiple sessions or done in one session.

Learners will have access to this course for up to 12 months from the date of joining. There is no time limit to complete the course during this period.

Course Format

  • This is a video-led course. 
  • This course includes practice exercises so you can practice as you learn.
  • This course is suitable for Windows users.

Entry Requirements

This course is designed to provide you with the essential skills you will need to be proficient in Excel, in a work or home environment, in as short a time as possible. You don't need any prior experience of using Microsoft Excel, our Microsoft Excel 2010 training covers beginners and advanced level training to help you develop the skills you need to progress in your career.


To assess the learners ability and knowledge to effectively understand the topics contained within the Microsoft Excel course, the course features a number of end of module interactive quiz questions.


Upon course completion, you’ll be awarded a certificate of completion at no additional cost to show employers your newly acquired skills. Enrol Online today and start learning straight away.

Adding this skill to your CV will greatly broaden your career propects and significantly improve your earning potential with current or future employers.

More Microsoft Excel training:

Microsoft Excel 2013, Microsoft Excel 2016, Microsoft Office Training Bundle

Who is this course for?
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.

Course Assesment Process
Course Assessment Process

The course is divided into simple sections with a short exercise at the end of each section to test your knowledge. Once you have progressed through each of the course sections you can complete an end of course exercise based on the material that you have studied.

Once you have passed the course, you'll be awarded your certificate of completion. If you don't pass the course first time, don't worry, you can resist the test as many times as required.

Got a question about exams? Contact our course advisors by email or by phone on 01707 828 751. We're happy to help!


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.

Course Media
Course Media
Career Path

We've put together a list of relevant job titles you can apply for after achieving the Microsoft Office certification (note that some careers may require further study, training and/or work experience):

  • Office Administrator
  • Business Administrator
  • Personal Assistant, Clerical Assistant
  • Receptionist
  • Secretary
  • Customer Service Representative
  • Project Officer, Project Manager
  • Business Manager
  • Sales Executive, Sales Manager, Sales Director
  • Human Resource Officer
  • Finance Assistant. Book-keeper, Accountant
  • Healthcare Assistant, Nurse
  • Database Administrator

Career Advice

Once you have achieved your certification, you'll have full access to our recruitment package for a wide range of information and advice - including:

  • How to put together a killer CV, Covering Letters and Thank You emails.
  • How to gain relevant work experience.
  • Howto prepare for interviews.
  • How to understand Job adverts.
  • How to choose the right recruitment agency.
  • How to look for work on LinkedIn.
  • Information on dealing with redundancy.

Our careers advice section is available for you to see now.For more information about our career advice services, contact us on 01707 828 8751 to speak with one of our friendly course advisors today.

Course Outline

Course Syllabus


  • 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
Training Features
  • feature

    We only use the industry’s finest instructors to develop our courses. They have a minimum of 15 years real-world experience and are subject matter experts in their fields. Unlike a live class, you can fast-forward, repeat or rewind all your lectures. This creates a personal learning experience and gives you all the benefit of hands-on training with the flexibility of doing it around your schedule 24/7.

  • feature

    Our self-paced training programs are designed in a modular fashion to allow you the flexibility to work with expert level instruction anytime 24/7. All courses are arranged in defined sections with navigation controls allowing you to control the pace of your training. This allows students to learn at their own pace around their schedule.

  • feature

    Each student will have 12 months unlimited access to allow you to have access to the training anytime 24/7.

£195.00 £19.99

Save £175.01

Was £195.00 (Offer ends 31/12/2021)

14 day money back guarantee

Spread the cost

Interest-free instalments

We're trusted by
Individuals, small businesses and large corporations who continuously put their trust in My Training Academy.
We are privileged to have trained individuals who work for some of the world’s largest companies, including: