Microsoft Excel 2016 Intermediate Online Course

1 Training

Short course

Online

Save 75%
£ 29 VAT inc.

The best Excel courses

See all

See all

Description

  • Type

    Short course

  • Methodology

    Online

  • Duration

    365 Days

Certificate in Microsoft Excel 2016 Intermediate

"Improve your Excel skills! Understand PivotTables, Slicers, Charting, Sparklines and other unique features of Microsoft Excel 2016. A good understanding of Excel will give you the edge as this power-packed Microsoft office program can boost your productivity.

The Microsoft Excel 2016 Intermediate course will upgrade your basic understanding of Microsoft Excel. The knowledge and understanding of Microsoft Excel skills at the intermediate level will afford you the opportunity to work with speed and accuracy for numerical calculations. Also, by the upgrading of your skills, the presented data will look more sharp and professional.

The Microsoft Excel 2016 features changes on the user interface, besides there are many new features that have been added and enhanced to make using Excel more user-friendly and efficient."

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now closed

About this course


"Module 01: Working with Functions
Module 02: Working with Lists
Module 03: Analyzing Data
Module 04: Visualizing Data with Charts
Module 05: Using PivotTables and PivotCharts

"


This Microsoft Excel 2016 Intermediate course is ideal for professionals and students who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. The learners will also work with charts and advanced formatting including styles.

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

Those who successfully complete the exam will be awarded the certificate in Microsoft Excel 2016 Intermediate course

Our online programme is well designed that you feel same as you are in the classroom. 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 in 365 days (12 months). Effective support service, and study materials including step by step guided tutorial videos build your confidence to study well and guide you to secure your qualification.


On receiving your request, one of our stuff members will call you or send you a message by explaining everything about the course you are requesting information including how you can sign up, payment options, exam and enrollment requirements etc.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2018

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 7 years

Subjects

  • Receptionist
  • Excel
  • Access
  • Office IT
  • Microsoft Excel
  • Ms Office
  • Secretary
  • Microsoft excel training
  • MS Excel
  • Office Administrator

Teachers and trainers (1)

Vitthal Srinivasan

Vitthal Srinivasan

Flipkart, Credit Suisse and INSEAD

Course programme

"

Course Curriculum

➤ Module 01 - Working with Functions

1.0 Topic A: Work with Ranges

2.0 Topic B: Use Specialized Functions

3.0 Topic C: Work with Logical Functions

4.0 Topic D: Work with Date & Time Functions

5.0 Topic E: Work with Text Functions

➤ Module 02 - Working with Lists

1.0 Topic A: Sort Data

2.0 Topic B: Filter Data

3.0 Topic C: Query Data with Database Functions

4.0 Topic D: Outline and Subtotal Data

➤ Module 03 - Analyzing Data

1.0 Topic A: Create and Modify Tables

2.0 Topic B: Apply Intermediate Conditional Formatting

3.0 Topic C: Apply Advanced Conditional Formatting

➤ Module 04 - Visualizing Data with Charts

1.0 Topic A: Create Charts

2.0 Topic B: Modify and Format Charts

3.0 Topic C: Use Advanced Chart Features

➤ Module 05 - Using PivotTables and PivotCharts

1.0 Topic A: Create a PivotTable

2.0 Topic B: Analyze PivotTable Data

3.0 Topic C: Present Data with PivotCharts

4.0 Topic D: Filter Data by Using Timelines and Slicers

Learning Outcomes

  • Learn to use formulas and functions.
  • Create and modify charts.
  • Convert, sort, filter, and manage lists.
  • Insert and modify illustrations in a worksheet.
  • Learn to work with tables.
  • Learn to use conditional formatting and styles.

Progression and Career Path

Once you successfully complete the Microsoft Excel 2016 Intermediate course you will be qualified to work with enhanced confidence in the following positions. Also, your potential will be highlighted by the way you manage, organize, present, and distribute your company’s data and information.

  • Office Administrator – £17,158 per annum
  • Office Manager £24,073 per annum
  • Receptionist – £15,961 per annum
  • Personal Assistant – £25,003 per annum
  • Project Assistant – £20,785 per annum
  • Business Executive – £23,667 per annum
  • Secretary £19,460 per annum
  • Business Analyst – £35,543 per annum
  • Technical Support Analyst – £22,753 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 an 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 the course before you purchase (For selected courses only)

"

Additional information

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 any time.

Method of Assessment
At the end of the Microsoft Excel 2016 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.

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

See related categories

Microsoft Excel 2016 Intermediate Online Course

£ 29 VAT inc.

The best Excel courses

See all

See all