Microsoft Excel 2010

0( 0 REVIEWS )
Overview              Would you like to become a master of Microsoft Excel 2010 and wow your colleagues? This course will be …


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?
  • Course Description:
  • Course Duration:
  • Method of Assessment:
  • Certification:
  • Entry Requirement:
  • Career Path:
  • 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

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

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.

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.

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

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.

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

Students feedback


Avarage rating ()
5 Star
4 Star
3 Star
2 Star
1 Star

No Reviews found for this course.

Contact Us

Certificate Code

Secure Payment
Copyright © 2020 -Study365 - All rights reserved.
WhatsApp chat