Microsoft Excel : Intermediate

----SPECIAL OFFER----SPECIAL OFFER----SPECIAL OFFER----

***Complimentary Course Bundle 5 Courses + PDF Certificates Absolutely FREE***

**5 Free Courses Included**

• Course 1 : Microsoft Project 2016
• Course 2 : Microsoft Project
• Course 3 : Facilitation Skills
• Course 4 : QuickBooks Pro 2016
• Course 5 : Organising and Efficiency Skills

**FREE PDF Certificates Included**

Microsoft Excel 2016 - Intermediate

Become a pro with latest features of Excel

If you use Excel often and want to stay up to date with its latest features or you want to just brush up your skills, this Microsoft Excel 2016 – Intermediate course is perfect for you. Knowledge and information shared in this Microsoft Excel 2016 – Intermediate course will prove valuable for people of all levels and capabilities.

With Microsoft Excel 2016 – Intermediate course, you will explore the 2016 interface, learn to format paragraphs, edit documents, work with long documents and become skilled at using the print option. Microsoft Excel 2016 – Intermediate course is a fun and engaging one that provides a fresh and new outlook on the basic function of the programme The course will explain to you new features and teach you how to perform a range of functions making you confident in using Excel in your place of work or just in your business operations.

Get Started Today!

• Accredited by CPD
• Unlimited Access for 365 Days
• Free PDF Certificate Included

Why You Should Learn at Next Learn Academy?

Next Learn Academy is a leading online provider for several accrediting bodies, and provides learners the opportunity to take this exclusive CPD Course. At Next Learn Academy, we give our fullest attention to our learners’ needs and ensure they have the necessary information required to proceed with the Course.

• Microsoft Excel 2016 Introduction 02:27

  • 1: Microsoft Excel 2016 Intermediate - Introduction Preview 02:27

• Statistical And Logical Functions 43:16

  • 2: Statistical And Logical Functions 43:16

• Microsoft Excel 2016 Intermediate 44:51

  • 3: Microsoft Excel 2016 Intermediate 44:51

• Sorting , Filtering And subtotaling Lists 41:23

  • 4: Sorting , Filtering And subtotaling Lists 41:23

• Conditional Formatting 21:21

  • 5: Conditional Formatting 21:21

• Charts 36:36

  • 6: Charts 36:36

• Using The Worksheet Efficiently 28:04

  • 7: Using The Worksheet Efficiently 28:04

• Printing Large Spreadsheets 18:58

  • 8: Printing Large Spreadsheets 18:58

• The Quick Analysis Button 18:39

  • 9: The Quick Analysis Button 18:39

• Exam 44:00

  • 10: Mock EXAM 23:00
  • 11: Final Exam 21:00

We are always looking for new ways for our learners to pursue their skills training and receive the best our online learning platform has to offer.

COURSE CURRICULUM

Module 01 : Statistical And Logical Functions

• Course structure and Outline
• Statistical Functions
• Logical Functions

Module 02 : Microsoft Excel 2016 Intermediate

• Inserting Sheets
• Naming Sheet
• Deleting Sheet
• Grouping Sheet
• Calculating with Multiple Books

Module 03 : Sorting, Filtering & Subtotaling Lists

• Sorting Lists
• Filtering Lists
• Calculations with Lists
• Subtotaling Lists
• Flash Fill

Module 04 : Conditional Formatting

• Background Color Shading
• Font Color Shading
• Data Bars
• Icons
• Values

Module 05 : Charts

• Bar Chart
• Column Chart
• Pie Chart

Module 06 : Using the Worksheet Efficiently

• Splitting the Screen
• Freezing Panes
• Creating Custom Views

Module 07 : Printing Large Spreadsheets

• Printing Selection
• Change the orientation
• Page break previews
• Header and Footer

Module 08 : The Quick Analysis Button

• Conditional Formatting
• Chart
• Totals
• Tables
• Sparklines

What Will I Learn?

• Learn to navigate the Excel 2016 interface effectively
• Understand how to work and customise the ribbon and quick access toolbar
• Learn to create, open and save documents
• Learn how to change print settings and print a document
• Learn to navigate, format and select texts

Method of Assessment

At the end of the course, learners will take an online multiple choice questions assessment test. This online multiple choice questions assessment test is marked automatically so that you will receive an instant grade and know whether you have passed the course.

Certification

Upon the successful completion of the course, you will be awarded the ‘Microsoft Excel 2016 - Intermediate’ certificate by CPD. You will receive a FREE E-certificate (PDF format) and a Printed Certificate absolutely FREE, with an applicable delivery fee upon completing the course.

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.

Awarding Body

CPD is an internationally recognised accrediting body that will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in an enterprise.

Other Benefits

• High-quality e-learning study materials.
• Tutorials/materials from industry-leading experts.
• 24/7 Access to the Learning Portal.
• Recognised Accredited Certification

This course is recommended for,

• Individuals interested in learning Excel 2016 for the first time
• Anyone who wants to take a refresher course in Excel 2016
• Individuals working in an office environment like Admin Assistants, PA’s, Executive Assistants and Secretaries

• This course requires no formal prerequisites and this certification is open to everyone

Once you successfully complete the Microsoft Excel 2016 Intermediate, it will demonstrate your understanding of how to use Microsoft Excel 2016 Intermediate effectively in your place of work. The course will give you the confidence to apply Excel in your day to day tasks, and your new-found skills and knowledge will impress your current employer or potential employers, in the process.

Currently there are no Q&As for this course. Be the first to ask a question.

Reed courses certificate of completion

Digital certificate - Included