• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Mastering MS Excel

Mastering MS Excel

By Janets

4.7(160)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 1 hour

  • All levels

Description

Become an Excel expert in a matter of hours and manage everyday office tasks faster and more efficiently with Mastering MS Excel. This course is ideal for experts in administrative and IT-based roles who want to improve their proficiency in Microsoft Office.

Throughout this Microsoft Excel training course, you will develop valuable administrative skills which will assist you in automating everyday work tasks, collaborating on spreadsheets, and data management. Taking you from beginner to advanced levels, you will learn how to create a basic spreadsheet, perform a financial analysis, insert tables, record macros and much more. 

On successful completion, you will have a solid knowledge of how to utilise the world’s leading spreadsheet program for business administration and master basic and complex work tasks.

Learning Outcomes of The Mastering MS Excel

  • Master the functions and features of the world’s leading spreadsheet program

  • Develop fundamental career-boosting skills in office administration

  • Learn how to automate tasks and collaborate on worksheets

  • Go from a beginner to an expert in Excel in a matter of hours

  • Get step-by-step training on how to calculate sums, totals and averages

  • Understand how to create different types of graphs and charts

  • Learn how to record macros to automate everyday administrative tasks

  • Get to grips with intermediate Excel functions including VLOOKUP, COUNTIF and AVERAGIF

  • Be trained on how to create a custom autofill for your data & save time for other tasks

Why choose this course

  • Earn an e-certificate upon successful completion.

  • Accessible, informative modules taught by expert instructors

  • Study in your own time, at your own pace, through your computer tablet or mobile device

  • Benefit from instant feedback through mock exams and multiple-choice assessments

  • Get 24/7 help or advice from our email and live chat teams

  • Full Tutor Support on Weekdays

Course Design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

  • Online study materials

  • Mock exams

  • Multiple-choice assessment

Certificate of Achievement

Endorsed Certificate of Achievement from the Quality Licence Scheme

Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage.

CPD Certificate of Achievement from Janets

Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99.

Endorsement

This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website.

Method of Assessment

To ensure the Quality Licensing Scheme is endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on their performance. After passing the assessment, one can apply for a certificate.

Course Contents

  • Getting Started with Microsoft Office Excel 2016

  • Performing Calculations

  • Modifying a Worksheet

  • Formatting a Worksheet

  • Printing Workbooks

  • Managing Workbooks

  • Working with Functions

  • Working with Lists

  • Analyzing Data

  • Visualizing Data with Charts

  • Using PivotTables and PivotCharts

  • Working with Multiple Worksheets and Workbooks

  • Using Lookup Functions and Formula Auditing

  • Sharing and Protecting Workbooks

  • Automating Workbook Functionality

  • Creating Sparklines and Mapping Data

  • Forecasting Data

  • Resources

About The Provider

Janets
Janets
London
4.7(160)
Janets is an online platform where learners come to learn, and evolve. From the very beginning, the aim of this platform was to create an ever-growing community of avid learners instead of just delivering formulaic education. Emphasising on making the learners equipped for the fu...
Read more about Janets

Tags

Reviews