• LOGIN
  • No products in the basket.

Overview             

Would you like to become a master of Microsoft Excel 2010 and wow your colleagues? This course will be your ultimate guide to this fantastic program, and covers the basic, intermediate, and advanced features of Excel, so no matter what experience level you are, there is something to learn. With Excel, create and format workbooks (a collection of spreadsheets) in order to analyse data and make more informed business decisions. Specifically, you can use Excel to track data, build models for analyzing data, write formulas to perform calculations on that data, pivot the data in numerous ways, and present data in a variety of professional looking charts.

Learning with Study 365 has many advantages. The course material is delivered straight to you and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand.

This course is comprised of professionally narrated e-Learning modules, interactive quizzes, tests, and exams. All delivered through a system that you will have access to 24 hours a day, 7 days a week for 365 days (12 months).

What will I learn?

  • How to navigate Excel
  • How to enter data and format cells
  • How to customise rows and columns
  • How to create formulas
  • How to sort and filter data
  • Basic tables, headers and footers and layout options
  • Manipulating data within the pivot tables
  • Understanding data validation
  • How to customise the ribbon and cell
  • Create and manage ranges
  • How to carry out data analysis, spark lines, and macros

Course Description:

This online training course is comprehensive and designed to cover the key topics listed under the curriculum.

Course Duration:

You will have 12 Months access to your online study platform from the date you purchased the course. The course is self-paced so you decide how fast or slow the training goes. You can complete the course in stages revisiting the training at any time.

Method of Assessment:

At the end of the course, learners will take an online multiple choice question assessment test. The online test is marked straight away, so you will know immediately if you have passed the course.

Certification:

Successful candidates will be awarded a certificate for Microsoft Excel 2010.

Entry Requirement:

Learners must be age 16 or over and should have a basic understanding of the English Language, numeracy, literacy, and ICT.

Please note: we do not provide any software with this course.

Career Path:

As Excel is so widely used this course provides transferable skills that will be useful in a wide range of job roles, and could help you land your next job, or get a pay rise. The qualification will be of particular interest to anyone hoping to work in administration, accounting or bookkeeping.

Course Curriculum

free introduction
Microsoft Excel 2010 FREE 00:00:00
Course Brochure – Microsoft Excel 2010 FREE 00:00:00
Excel 2010 Basic
1. Intro to Excel Basic 00:00:00
2. Interface and Functions 00:00:00
3. Cells 00:00:00
4. Entering Data Into Cells 00:00:00
5. Basic Formatting in Excel 00:00:00
6. Creating a Worksheet 00:00:00
7. The Intelligence Of Excel 00:00:00
8. Customizing Rows and Columns 00:00:00
9. Creating Formulas 00:00:00
10. Summary Pages and Moving Workbook to Workbook 00:00:00
11. The Function Builder 00:00:00
12. Conditional Formatting 00:00:00
13. Sorting and Filtering Data 00:00:00
14. Printing with Excel 00:00:00
15. Conclusion 00:00:00
Excel 2010 Intermediate
1. Intro to Excel Intermediate 00:00:00
2. Charts 00:00:00
3. Headers Footers and Layout Options 00:00:00
4. What If 00:00:00
5. Basic Tables in Excel 00:00:00
6. Generating Cross Tab Tables (Pivot) 00:00:00
7. Manipulating Data Within the Pivot Tables 00:00:00
8. Pivot Table Charts 00:00:00
9. Data Validation 00:00:00
10. Conclusion 00:00:00
Excel 2010 Advanced
1. Intro to Excel Advanced 00:00:00
2. Customizing the Ribbon and Cells 00:00:00
3. Creating and Managing Ranges 00:00:00
4. More Formulas 00:00:00
5. Data Analysis 00:00:00
6. Data From an Outside Source 00:00:00
7. Spark Lines 00:00:00
8. Macros 00:00:00
9. Conclusion 00:00:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

1519 STUDENTS ENROLLED

    CPD Accredited

    UKRLP

    ACCREDITED CERTIFICATE

    certificate

    Awarded by iAP

    Awarded by iAP

    CPD Accredited Partner

    CPD Accredited

    CPD Membership No: 10582

    Study independently accredited and recognised CPD courses. Gain your certification today.

    cvAll students enrolled with STUDY365 are entitled to a CV Writing and Interview Skills Pack, which includes CV templates, cover letter guidance, and advice for interviews.
    MORE INFO

    cvIf you need career support STUDY365 is here for you. We provide excellent career support through our Career Support Service.
    MORE INFO

    NUS Extra Card

    NUS Extra Card

    Course Reviews

    • Office Skills, Secretarial & PA Training

      Office Skills, Secretarial & PA Training 2

      I regret doing this course- only a few units were actually useful! *A lot of it is just common sense *The units on Microsoft Word and Outlook were shown using the obsolete versions *Some of the videos were shot & edited very poorly *Some of the written tutorials were shoddy and seemed 'rushed' *A couple of videos were looped *I couldn't find the exercise files for at least one of the units (not at the end where they usually are) *The mock exams and final exam had questions on things that weren't even in the course! All I got from this course is an idea of what I need to work on and how NOT to do it.
      Sally Eastman
    • Adult Nursing & Social Care Training

      Adult Nursing & Social Care Training 4

      Learnt how to work in a practical sense with those who really need you after taking this course.
      Emma Hanks




    Address: Study365, 406 White Horse Lane, London E1 3FY
    Phone: 0203 874 9355​
    Email: support@study365.co.uk

    Certificate Code

    Secure Payment
    top