Microsoft Excel 2010 Este curso é ministrado em inglês

Course details

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.

Why You Should Choose Study 365

• 12 months Access to your course.
• The price shown on Reed is for the whole course, including the final exam and free e-certificate.
• CPD and iAP accredited certificate upon successful completion
• Tutor Support available Monday – Friday

 Description

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

Course Curriculum

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

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

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

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.

Why Choose Us?

• Our courses represent outstanding value for money
• High quality e-learning study materials and mock exams.
• Each course is designed by industry experts, using an innovative interactive learning approach.
• Includes step-by-step guided videos tutorials.
• Benefit of applying NUS extra Discount Card.
• 24/7 Access to the Online Learning Portal.
• Anytime & Anywhere Learning.
• Recognised Accredited Qualification.
• Access Course Content on Mobile, Tablet or Desktop.
• Study in a user friendly, advanced online learning platform.
• Excellent customer service and administrative support.

Ultima actualização em  13 March, 2024