Microsoft Excel 2010 Intermediate

Overview:

Make your office tasks more effective with Microsoft Excel 2010 Intermediate. Microsoft Excel is a popular application that is widely used in a range of industries and multiple job roles. Whether you are just starting out or someone who is already employed the course covers intermediate functions and is right for everyone who wants to give their CV a boost.

The course will provide you an overview of Microsoft Excel 2010 Intermediate and cover intermediate functions such as advanced charting and advanced formatting using multiple workbooks and worksheets. If you have basic experience in using Microsoft Excel, you can master this application quickly as it will provide more opportunity to accomplish office tasks quickly and efficiently.

We recommend that learners review the exam preparation tutorial and become familiar with the resources before scheduling the exam. In addition, extra time will be given so that you can enjoy the flexibility of training and studying at your own convenience. The course is internationally recognised and accredited to a training organisation and you will be issued an internationally recognised qualification following full completion of Microsoft Excel 2010 Intermediate course.

Why consider 1Training?

As improvements and advancements are made in technology, online courses are no longer just conventional means of studying at affordable costs. In many aspects online training offers superiority to traditional learning. There is an effectiveness and convenience that traditional learning cannot provide. The overall convenience and flexibility makes it a superior learning method.

1Training offers the most convenient path to gain an internationally recognised qualification that will give you the opportunity to put into practice your skill and expertise in an enterprise or corporate environment. You can study at your own pace at 1Training and you will be provided with all the necessary material, tutorials, qualified course instructor and multiple free resources which include Free CV writing pack, Nus Discounted Card, Free career support and course demo to make your learning experience enriching and more rewarding.

Learning Outcomes

• Learn to store, organise and analyse data.
• Explore the concepts of Excel from intermediate to advanced levels. Learn how use advanced format spreadsheets, and produce professional looking tables and charts.
• Learn how to create an interactive dashboard, where pivot charts and pivot tables are connected to each other.
• Learn how to use group data and quickly display summary rows and columns.
• Combine multiple workbooks to one workbook, and consolidate data from a series of worksheets.

Course Curriculum

• Module 01: Using Multiple Worksheets/Workbooks
• Module 02: Advanced Formatting
• Module 03: Outlining and Subtotals
• Module 04: Cell and Range Names
• Module 05: Tables
• Module 06: Web and Sharing Features
• Module 07: Advanced Charting
• Module 08: Documenting and Auditing
• Module 09: Templates and Settings
• Module 10: PivotTables and PivotCharts

Access Duration

The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course.  The course is self-paced and you can complete it in stages, revisiting the lectures at anytime.

Who is this Course aimed at?

The course is aimed at individuals who have limited experience or are complete beginners looking to develop Microsoft Excel 2010 Intermediate skills. The course is also useful to individuals who want to learn advanced features of charts, tables, worksheets and workbooks.

Method of Assessment

At the end of each course you will be required to take a multiple choice question assessment test. The multiple choice question assessment will be automatically marked with learners receiving an instant grade.

Certification

Those who successfully complete the exam will be awarded the certificate in Microsoft Excel 2010 Intermediate. You will receive a free e-certificate and you can purchase a printed certificate, as well.

Entry Requirements

• You must be over the age of 16 and have a basic understanding of Maths, English and ICT
• The course is for beginners and intermediate learners

Awarding Body

The certificate will be awarded by CPD and iAP. This internationally recognised qualification will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in the IT enterprise.

Progression and Career Path

Once you successfully complete Microsoft Excel 2010 Intermediate you will be qualified to work in the following positions. The Microsoft Excel 2010 Intermediate qualification will also put you in line to demand a higher salary or job promotion. The average UK salary per annum according to https://www.payscale.com is given below.

• Business Administrator – £16,646 per annum
• Receptionist – £15,961 per annum
• Personal Assistant £25,003 per annum
• Secretary – £19,460 per annum
• Office Administrator – £17,158 per annum
• Human Resource Officer – £24,441 per annum
• Finance Assistant – £18,955 per annum

Other Benefits

• Written and designed by the industry’s finest expert instructors with over 15 years of experience
• Repeat and rewind all your lectures and enjoy a personalised learning experience
• Gain access to quality video tutorials
• Unlimited 12 months access from anywhere, anytime
• Excellent Tutor Support Service (Monday to Friday)
• Save time and money on travel
• Learn at your convenience and leisure
• Quizzes, tests mock exams, practice exams to ensure you are 100% ready
• Eligible for a NUS discount card
• Free Career Support Service
• 25% Discount on personal Statement and covering letter writing service
• Free Access to Over 150 courses for 2 days (48 hours)
• Free access to course before you purchase (For selected courses only)