• LOGIN
  • No products in the basket.

Microsoft Excel 2016 Intermediate Training

4.9( 8 REVIEWS )
595 STUDENTS

Since its inception in 1985, Microsoft Excel has an average of five new users added every minute. Now the total stands at more than thirty million users of this amazing spreadsheet program, who use it every day for personal and professional reasons. The 2016 version has many new features added to the program, and if you would like to learn more about them, you can do so with this Microsoft Excel 2016 Intermediate Training course.

This course is designed to help all users get familiar with the different features of Excel. As such you start out with learning how to use range names in formulas and functions, along with using specialized functions. Next you get to analyze the data with logical and lookup functions, organise and analyze datasets and tables, and also visualize data with charts. Furthermore you will learn about creating Pivot Table, filtering data using slicers, and analyzing data using PivotCharts. Finally the course will teach you to insert graphics, and enhance workbooks through customizing them, managing themes, and creating and using templates.

Overall this course can help you rediscover Excel, and if used correctly, you will only get to add invaluable skills to your arsenal.

Why Should You Choose Microsoft Excel 2016 Intermediate Training

  • Internationally recognised accredited qualification
  • 1 year accessibility to the course
  • Free e-Certificate
  • Instant certificate validation facility
  • Properly curated course with comprehensive syllabus
  • Full-time tutor support on working days (Monday – Friday)
  • Efficient exam system, assessment and instant results
  • Access to the course content on mobile, tablet or desktop from anywhere anytime
  • Eligible for **Student ID** card which gives you 1000’s of discounts from biggest companies.

Career path

This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful in no time. You will be able to stand out in the crowd after completing this course. You will also be able to add our qualifications to your Resume and make yourself worthy in the competitive job industry.

FAQs

Who is this course for?

There is no experience or previous qualifications required for enrolment on this course. It is available to all students of all academic backgrounds.

Is this course accredited?

Yes, this course is accredited by CiQ and CPD Qualification Standards.

If I take the course, how will I be assessed?

Once you complete all the lessons/units, you are required to sit an exam which is multiple-choice. Pass mark is 60%.

Does this course include exams?

Yes, this course includes exams.

How can I achieve my certificate?

Once you successfully pass your exam you can obtain your certificate of achievement either in PDF or hard copy format, or both, for an additional fee.  Certificates are also available as e-certificates.

Is there any charge for certification?

Yes, there is an additional charge for the certification service.  Certificates are £4 each for PDFs and £8 each for hard copies. If both PDF and hard copy certificates are ordered at the same time, the cost is £10. E-certificates are available from your learning portal completely free of charge.

Can anyone validate my certificate through your website?

Yes, there is a unique code issued for every certificate and anyone can validate your certificate by using this code through our website.

Are there any prerequisites for the course?

There are no prerequisites for this course and it is open to everyone.

How long until I receive the course confirmation details?

Once you purchase a course your account will be set up within 48 hours and you will receive an email with your account details.

For how long do I have access to the course?

You will have access to the course for one year following purchase.

What support do you offer?

We provide 24 hours live chat support and our customer service team is available during working hours to answer your phone calls.

Course Curriculum

Apply Range Names 00:30:00
Use Specialized Functions 00:30:00
Use Text Functions 00:30:00
Use Logical Functions 00:30:00
Use Lookup Functions 00:30:00
Use Date Functions 00:30:00
Use Financial Functions 00:30:00
Create and Modify Tables 00:30:00
Sort and Filter Data 00:30:00
Use Subtotal and Database Functions to Calculate Data 00:30:00
Create Charts 00:30:00
Modify and Format Charts 00:30:00
Create a Trendline 00:30:00
Create Advanced Charts 00:30:00
Create a PivotTable 00:30:00
Filter Data by Using Slicers 00:30:00
Analyze Data with PivotCharts 00:30:00
Insert and Modify Graphic Objects 00:30:00
Layer and Group Graphic Objects 00:30:00
Incorporate SmartArt 00:30:00
Customize Workbooks 00:30:00
Manage Themes 00:30:00
Create and Use Templates 00:30:00
Protect Files 00:30:00
Preparing a Workbook for Multiple Audiences 00:30:00
Activities
Activities – Microsoft Excel 2016 Intermediate Training 00:00:00
Mock Exam
Mock Exam- Microsoft Excel 2016 Intermediate Training 00:20:00
Final Exam
Final Exam- Microsoft Excel 2016 Intermediate Training 00:20:00

Course Reviews

4.9

4.9
8 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE

Instructors

595 STUDENTS ENROLLED

Accredited By

 

Our Students Say..

Our Course Awarding Bodies

Registered with the UK Register of Learning Providers (UKRLP)
UKPRN: 10063816

Our Courses Partners

Adams Academy

© Adams Academy Inc. Ltd.