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
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.
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.
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.
|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|
|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|
|Excel 2010 Intermediate|
|1. Intro to Excel Intermediate||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|
|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|
No Reviews found for this course.