Skip to content

Microsoft Excel 2010 Online Training


Barnet and Southgate College

Summary

Price
£400 inc VAT
Study method
Online
Duration
Self-paced
Qualification
No formal qualification

Overview

Using a mixture of expert instruction, hands-on exercises and interactive quizzes the Microsoft Excel 2010 Online Training course is delivered online via the learning platform. This self-study approach allows students to work at their own pace, as and when suits them – all they need is an Internet-connected computer.

Description

Grow yourself and your career by completing this comprehensive course in using Excel 2010. This step-by-step course takes novice Excel users and teaches them how to build professional quality spreadsheets with which to capture, manipulate and report on data.

In just three modules learners will move from understanding the basic principles of Excel 2010, to mastering the most advanced concepts.

The Microsoft Excel Online Training package is best suited to:

  • Professionals who need to learn how to create and manage spreadsheets using Microsoft Excel 2010 to track and report data.
  • Employees who want to expand their knowledge of the Microsoft Office suite of applications.
  • Individuals who would like to learn and apply some of the more advanced Excel techniques to help them be more productive.
  • Individuals who would like to build their own spreadsheets for use at home or at work.

This self-study approach allows students to work at their own pace, as and when suits them – all they need is an Internet-connected computer.

Students can also use the social networking platform to share tips and advice with other learners, or to ask for help should they encounter problems whilst completing exercises.

key learning points

The Microsoft Excel 2010 Online Training course is split into three sections – Basic, Intermediate and Advanced. Starting gently with the basics of understanding the Excel interface, training quickly moves on to cover:

  • Entering and editing data.
  • Creating formulae to perform automated calculations.
  • Preparing and printing spreadsheets.
  • Inserting pivot tables to provide additional analytical potential.
  • Copying and pasting data, and inserting other data types (such as images) into a sheet.

Moving on, the Intermediate modules cover several topics including:

  • Creating a sparkline.
  • Editing and auditing formulae to ensure they are delivering accurate calculation results.
  • Sorting and filtering data to display pertinent information more quickly.
  • Creating and managing charts.
  • Using multiple workbooks to manage separate, but related data.
  • Freezing panes and autosizing columns to improve data display.

Finally students will learn a number of advanced Excel 2010 topics including:

  • Using the VLOOKUP function to find precise data more quickly.
  • Using “Paste Special” to transpose data and save time re-editing information.
  • Deleting duplicate records to maintain data integrity.
  • Grouping data for analysis.
  • Applying conditional formatting to highlight certain datasets based on user actions.
  • Protecting data using passwords or the Final and Read Only designations.

The course modules cover all these topics and more, ensuring students will demonstrate complete mastery of Excel 2010 by the end of their studies.

advantages of this course

This three-phase course helps students move quickly from understanding the basics of Excel to mastering advanced techniques of using spreadsheets that they can immediately apply to their own projects.

Other benefits of the Microsoft Excel 2010 Online Training package include:

  • The skills and experience required to create useful spreadsheets that can be used to analyse and report on key business data and inform strategic business decisions.
  • A boost in confidence when building new spreadsheets from scratch.
  • An in-demand skill that will help secure new opportunities at work.
  • A good understanding of Excel 2010 that can also be used to train other employees.

Upon completion of the Microsoft Excel 2010 Online Training course, students will have an advanced working knowledge of building spreadsheets and the basic skills to take their learning further towards earning the globally-recognised Microsoft Office Specialist qualification.

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.