Microsoft Excel 2010

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).

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

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.