Mastering MS Excel

Janets

NVQ

Online

£ 317 VAT inc.

The best Excel courses

See all

See all

Description

  • Type

    NVQ Level 3

  • Methodology

    Online

  • Duration

    1 Year

  • Start date

    Different dates available

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

Become an Excel expert in a matter of hours and manage everyday office tasks faster and more efficiently with the Mastering MS Excel.

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.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

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

This course is ideal for professionals in administrative and IT-based roles who want to improve their proficiency in Microsoft Office.

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

Why choose this course
Earn a free 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

Questions & Answers

Add your question

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

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Microsoft excel training
  • Office IT
  • Microsoft Excel
  • MS Excel
  • Spreadsheet
  • Ms Office
  • Interface
  • Office Excel
  • Microsoft Office Excel
  • Excel Commands

Course programme

Getting Started with Microsoft Office Excel 2016
  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data
  • Use Excel Help
Performing Calculations
  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas and Functions
Modifying a Worksheet
  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools
Formatting a Worksheet
  • Apply Text Formats
  • Apply Number Format
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and Use Templates
Printing Workbooks
  • Preview and Print a Workbook
  • Set Up the Page Layout
  • Configure Headers and Footers
Managing Workbooks
  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties
Working with Functions
  • Work with Ranges
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date & Time Functions
  • Work with Text Functions
Working with Lists
  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data
Analyzing Data
  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting
Visualizing Data with Charts
  • Create Charts
  • Modify and Format Charts
  • Use Advanced Chart Features
Using PivotTables and PivotCharts
  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Timelines and Slicers
Working with Multiple Worksheets and Workbooks
  • Use Links and External References
  • Use 3-D References
  • Consolidate Data
Using Lookup Functions and Formula Auditing
  • Use Lookup Functions
  • Trace Cells
  • Watch and Evaluate Formulas
Sharing and Protecting Workbooks
  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks
Automating Workbook Functionality
  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Work with Macros
Creating Sparklines and Mapping Data
  • Create Sparklines
  • MapData
Forecasting Data
  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Forecasting Data Trends
Resources
  • Resources – Microsoft Excel Complete Course – Beginner, Intermediate & Advanced










See related categories

Mastering MS Excel

£ 317 VAT inc.

The best Excel courses

See all

See all