Skip to content

Microsoft Excel 2010 / 2013 Training With an Exam

Milton Keynes College

Summary

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

Overview

Master Excel completely with this comprehensive course encompassing both Excel 2010 and Excel 2013. Learn how to capture, understand and present data with this powerful application and make full use of all of the tools and functions across both editions.

Description

Master Excel completely with this comprehensive course encompassing both Excel 2010 and Excel 2013. Learn how to capture, understand and present data with this powerful application and make full use of all of the tools and functions across both editions. Excel 2013 has many new features that allow you to manipulate your data in new ways and guide you to make better, more informed decisions based on your calculations. A thorough understanding of Excel adds to your professional skill set and can boost your career by making you more attractive to potential employers.

A Microsoft Office specialisation certification is available for Excel, validating your knowledge and skills in this application. On passing the exam included in this course you will receive your certification.

Comprehensive and convenient

The course is broken down into 6 comprehensive modules covering basic, intermediate and advanced uses of Excel 2010 and 2013, with an exam at the end. You can spend as little or as much time on each module as you feel is necessary – simply log in and out of your course at your convenience. The flexible nature of the course means you can learn at your own pace depending on other commitments. The nature of online learning enables you to study anywhere and at any time.

key learning points

This course has been developed to enable you to become an expert in Microsoft Excel 2010 and 2013 and their various uses. Focus areas include:

  • MS Excel 2010 Introduction: Learn how to create tables in Microsoft Excel, how to enter data into them, how to format the data and how to edit the table format.
  • MS Excel 2010 Intermediate: Explore advanced techniques for data processing in Excel including formatting, locking, using templates and advanced copying. Create complex formulas and use functions within the date & time and text categories, as well as the logical, financial and database functions.
  • MS Excel 2010 Advanced: Explore working with the advanced Microsoft Excel functions for data manipulation and analysis. Familiarise yourself with macro creation, with the XML format and its use in Excel and with protecting and managing permissions for accessing workbooks.
  • MS Excel 2013 Introduction: Explore the basic concepts of Excel 2013 in this module. Learn how to create, open and save workbooks; how to enter and edit data; the use of formatting, headers and footers; working with columns and rows; using autofill and sorting and filtering data.
  • MS Excel 2013 Intermediate: Discover how Excel can transform raw data into reports using charts and graphs, formulas and functions and named ranges. Learn about data validation, sparklines, conditional formatting, comments, protecting a workbook and more.
  • MS Excel 2013 Advanced: Learn advanced Excel techniques and push your skill set to the next level. Create custom lists, use advanced forms and formulas, learn how to use the Watch Window, pivot tables, macros and how to work with external data sources.

advantages of this course

  • Comprehensive high quality e-learning content delivered in 12 manageable modules
  • Boost your education and job prospects. Develop skills and qualifications to take you to the next step in your career
  • Learn at your own pace and fully understand each module before moving on
  • Our technical support team will be on hand to offer you advice and guidance via telephone, email or online chat
  • Gain a certificate validating your core skills in this application

Invest in this course now and boost your job prospects with skills vital for the modern workplace.

Questions and answers

Reviews

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

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.

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.
View all
Related searches: Online courses