Microsoft Excel 2013 Intermediate

Overview:

The Microsoft Excel 2013 Intermediate course will teach you the intermediate features and functions of Excel. You will learn to advanced formats and layouts. If you have basic experience this course will help you easily apply Excel skills in an office environment. The Microsoft Excel 2013 Intermediate is aimed at individuals who want to use MS Office programs in the workplace environment efficiently and effectively.

The Microsoft Excel 2013 Intermediate course will cover topics like how to manage, filter and generate reports, and learn how to summarise and analyse data using tools like Pivot Tables. You will gain an understanding on how to automate repetitive tasks and create macros, and how to protect workbooks and worksheets.  As it is a must have Office skill, you will learn to use the application effectively whether it is for personal or business use.

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 2013 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 how to share and link data.
• Learn how to review and protect content.
• Gain an understanding of advanced formulas and functions.
• Learn how to use Pivot Charts and Pivot Tables.
• Learn how to use advanced formats and layouts.

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 with a background in Microsoft Excel skills.
• Individuals who want to advance their knowledge in Excel.
• The course is suitable for students who want to gain an understanding in Excel.
• The course is suitable for anyone with an interest in Microsoft Excel 2013.

Entry Requirements

• You must be over the age of 16 and have a basic understanding of Maths, English and ICT
• Job seekers / school leavers

Method of Assessment

At the end of the Microsoft Excel 2013 Intermediate 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 2013 Intermediate. You will receive a free e-certificate and you can purchase a printed certificate, as well.

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 2013 Intermediate you will be qualified to work in the following positions. The Microsoft Excel 2013 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.

Other jobs you can get

• Microsoft Developer
• Microsoft Specialist
• Office Specialist

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)

COURSE CURRICULUM

• Module 01: Creating Advanced Formulas
• Module 02: Logical and Lookup Functions
• Module 03: Organizing Worksheet Data with Tables
• Module 04: Visualizing Data with Charts
• Module 05: PivotTables, Slicers, and PivotCharts
• Module 06: Inserting Graphics
• Module 07: Enhancing Workbooks