Skip to content

Microsoft Excel - Level 1 and Level 2- Online with Tutor Support

Online Training | Study materials and Tutor support |


Pitman Training Wembley

Summary

Price
£460 inc VAT
Finance options

Price include VAT for individual Learners not for Corporate clients.

Study method
Classroom + online
Duration
24 hours · Part-time or full-time
Certification
Microsoft Office Specialist (MOS)
Professional certification What's this?
CPD
24 CPD hours / points
Additional info
  • Exam(s) / assessment(s) is included in price
  • Tutor is available to students

Location & dates

Location
Address
1-3
Lancelot Road
WEMBLEY
Middlesex
HA02AL
United Kingdom

Overview

Learn how to use the features and functions of Microsoft Excel 2016 with this unique course. The full course will teach you how to create and format
worksheets, use functions, tables, formulas, and more.

The course is for anyone wanting to learn how to utilise
the latest 2016 version of this powerful spreadsheet programme. As Excel is widely used in a variety of job roles such as finance and accounting, management and office administration roles, it is suitable for a wide audience.

Certification

Microsoft Office Specialist (MOS)

Awarded by Microsoft

CPD

24 CPD hours / points
Accredited by The CPD Standards Office

Description

There are 27 modules in total in this course

  • Introduction Module: Welcome and course
    information
    • Starting Excel
    • Opening & closing Excel, Using SUM and Navigating
    Excel
    • Formatting
    • Number Formats and Different File Types
    • Autofill, Formulas and Inserting/Deleting Columns
    & Rows
    • Hiding & Unhiding and Aligning & Formatting Cells
    • Cut, Copy & Paste, Drag & Drop, Format Painter and
    Auto Complete
  • Text Orientation, Non-Adjacent Data, Freeze &
    Unfreeze, Zoom and Worksheets
    • Styles and Themes
    • Configure Worksheets and Workbooks
    • Using Functions, Quick Analysis and Sort
    • Headers and Footers
    • Create and Manage Tables
    • Worksheets and Viewing Workbooks
    • Introduction to Charts
    • Complex Formulas
    • Now, Count, Today and If Functions
    • Format and Modify Text Using Functions
    • Perform Logical Operations Using Functions
    • Hidden Worksheets and Financial Functions
    • Using Formulas in Grouped Worksheets
    • Charts
    • Sparklines and Inserting Images
    • Spell Check, Filter and Find & Replace
    • Web Pages, Hyperlinks and Conditional Formatting
    • Importing a Text File, Customising the Ribbon & the
    Quick Access Toolbar and Tell Me What You Want
    To Do

Who is this course for?

The course is for anyone wanting to learn how to utilise
the latest 2016 version of this powerful spreadsheet
programme. As Excel is widely used in a variety of job
roles such as finance and accounting, management
and office administration roles, it is suitable for a wide
audience.
The full course is suitable for beginners with little or no experience of the programme; it will help you learn some of the fundamental actions you can carry out in
Excel before advancing your knowledge to more in-depth features.
The unique format of this training means you have the option to pick and choose to study individual modules, rather than the full course if preferred. This approach offers flexibility not only to individual learners but also allows businesses who have a particular learning objective or more bespoke requirements to gain access to our professional, CPD accredited training.

Requirements

There are no pre-requisites for the study of this Excel 2016 course, it is suitable for beginners.

Career path

As Microsoft Excel is used across such a wide range of job roles, taking the time to learn the latest version of this spreadsheet programme will show your commitment to
continuing professional development and help towards your career progression opportunities.

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs