Upgrade your skills with an extra 25% off selected courses with codeMTA25
MOS019

Microsoft Excel 2019 Course

19.9900 2023-12-30 MOS019 19.9900
100 100 100 0 The Microsoft Excel 2019 course has been designed to provide you with the essential skills you will need to be proficient in Excel 2016, in a work or home environment, in as short a time as possible. https://mytrainingacademy.org.uk/pub/media/catalog/product/r/s/rsz_ms-excel.jpg
  • Price

    £19.99 including VAT (was £195.00)

    Offer ends 31 May 2022

    Save £175.01
  • Course Type Online Course
  • Course Duration 7 Hours
  • Course Access 12 Months
  • Awarded By MTA
  • Student Discount Card All students enrolled on this course are entitled to apply for a XO student discount card.
Share
MOS019
The Microsoft Excel 2019 course has been designed to provide you with the essential skills you will need to be proficient in Excel 2016, in a work or home environment, in as short a time as possible.
-
+
Course Description

This Microsoft excel training course will provide learners with a core understanding of how to effectively operate and use the Excel spreadsheet software at a beginner level. Whether you need to learn the skills for work, fill the gaps in your CV or simply fancy learning something new, this Excel course is perfect.

This Microsot Excel training is a great starting point to prepare for the intermediate and advanced Excel course. This course will give you a full overview of all of the most common features of Excel and how to use them.

What you'll learn on this Microsoft excel training

Here are some of the things you will learn on this excel course:

  • Creating workbooks
  • Entering text, numbers and working with dates
  • Navigating workbooks
  • Page setup and print options
  • Working with rows, columns and cells
  • Cut, Copy and Paste
  • Introduction to functions and formulas
  • Formatting in Excel, including formatting cells and numbers
  • Creating charts and graphs
  • Sorting and Filtering
  • Introduction to PivotTables
  • Logical and lookup formulas - the basics
  • Exercises included, so you can practice what you learnt.

What's included in this Microsoft excel training?

  • 12 months unlimited access.
  • Online video tutorials created by expert instructors.
  • Project files to help you consolidate your learning.
  • MTA course completion certificate.

Course Format

  • This Microsoft Excel training is a video-led course. 
  • This course includes project files so you can practice while you learn.
  • There is no formal assessment for this course.

Entry Requirements

This Microsoft excel training is designed to provide you with the essential skills you will need to be proficient in Excel, in a work or home environment, in as short a time as possible. You don't need any prior experience of using Microsoft Excel, our Microsoft Excel 2019 training covers beginners level training to help you develop the skills you need to progress in your career.

Bulk discounts

Bulk discounts are available on purchases of 10 or more courses.

If you wish to discuss a large individual order for this course, and/or would like to be invoiced in advance, please call our sales team on 0808 175 1269 to make an enquiry.

 

Who is this course for?

Anyone looking to develop their Microsoft Excel 2019 skills.

By choosing online learning instead of a classroom based course, it eliminates the need for time away from work, saving you valuable time and money. It is ideal for those with tight schedules as our online courses give you 12 months unlimited access to all the course materials, so you can study at a pace that suits you. Allowing you to easily resume your studies whenever you have the time. All you need is internet connection to study, so you can study from the comfort of your home or any environment that suits you.

Course Assessment Process

There is no formal assessment on this course.

Project files are included in each course to help you consolidate your learning. At the end of each course, please get in contact with Student Support to request a copy of your certificate of completion.

Got a question about exams? Contact our course advisors by email or by phone on 0808 175 1269. We're happy to help!

Requirements

Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.

For the best viewing experience on our state-of-the-art eLearning platform we recommend an internet connection of 10Mbps or better. Please also use Google Chrome or Mozilla Firefox as your browser with Adobe Flash Player.

Course Media
Career Path

We've put together a list of relevant job titles you can apply for after achieving the Microsoft Office certification (note that some careers may require further study, training and/or work experience):

  • Office Administrator
  • Business Administrator
  • Personal Assistant, Clerical Assistant
  • Receptionist
  • Secretary
  • Customer Service Representative
  • Project Officer, Project Manager
  • Business Manager
  • Sales Executive, Sales Manager, Sales Director
  • Human Resource Officer
  • Finance Assistant. Book-keeper, Accountant
  • Healthcare Assistant, Nurse
  • Database Administrator

Career Advice

Once you have achieved your certification, you'll have full access to our recruitment package for a wide range of information and advice - including:

  • How to put together a killer CV, Covering Letters and Thank You emails.
  • How to gain relevant work experience.
  • Howto prepare for interviews.
  • How to understand Job adverts.
  • How to choose the right recruitment agency.
  • How to look for work on LinkedIn.
  • Information on dealing with redundancy.

Our careers advice section is available for you to see now.For more information about our career advice services, contact us on 0808 175 1269 to speak with one of our friendly course advisors today.

Course Outline
 

The Microsoft Excel 2019 - Beginners course is organised into the following modules:

1: Introduction to Excel

  • Intro to Excel
  • What's New In Excel 2019?
  • Course Overview
  • Overview of the Excel Window
  • Mouse Features
  • Back Stage View
  1. Creating Workbooks
  • Entering Text and Numbers
  • Creating Basic Formulas
  • Relative References
  • Order of Operations
  • Working with Ranges
  • Module 2 - Practice Exercise
  1. Saving Workbooks
  • Working with the Save and Save As Commands
  • File Extensions, Share, Export, and Publish Files
  • Module 3 - Practice Exercise
  1. Navigating Workbooks
  • Opening a File
  • Working with Larger Files
  • Freeze Panes Option
  • Split Screen Option
  • Module 4 - Practice Exercise
  1. Page Setup and Print Options
  • Headers and Footers
  • Print Titles
  • Comments
  • Page Setup Options
  • Fit to Print on One Page
  • Printing Workbooks
  • Module 5 - Practice Exercise
  1. Working with Rows, Columns, and Cells
  • Adding and deleting rows columns and cells
  • Changing Column and Row Widths
  • Module 6 - Practice Exercise
  1. Moving Data
  • Cut, Copy, and Paste
  • Copying Formulas
  • Module 7 - Practice Exercise
  1. Formulas and Functions
  • Overview of Formulas
  • Create Formulas Using Functions - part 1
  • Create Formulas Using Functions - part 2
  • Absolute Values
  • Module 8 - Practice Exercise
  1. Working with Sheets
  • Adding, Deleting, and Renaming Sheets
  • Additional Sheet Tab Options
  • 3 Dimensional Formulas
  • Module 9 - Practice Exercise
  1. Formatting Worksheets
  • Formatting Cells - part 1
  • Formatting Cells - part 2
  • Formatting Numbers
  • Borders and Shading
  • Format as Table
  • Using Styles
  • Using Format Painter
  • Protecting Sheets
  • Fill Handle and Custom Lists
  • Module 10 - Practice Exercise
  1. Charts
  • Creating Charts
  • Types of Charts
  • Editing Charts - Part 1
  • Editing Charts - Part 2
  • Using Graphics to Enhance Charts
  • Linking Chart Titles
  • Module 11 - Practice Exercise
  1. Working with Names
  • Creating Range Names
  • Managing Names
  • Using Names in Formulas
  • Module 12 - Practice Exercise
  1. Sorting and Filtering
  • Remove Duplicates
  • Sort Data
  • Filter Data
  • Advanced Filters
  • Module 13 - Practice Exercise
  1. Outlining and Subtotaling
  • Creating an Outline
  • Subtotals
  • Module 14 - Practice Exercise
  1. Working with Views
  • Arranging Files
  • New Window Option
  • Custom Views
  • Module 15 - Practice Exercise
  1. Linking Files
  • Creating Formulas between Files
  • Working with Links
  • Consolidating Data
  • Module 16 - Practice Exercise
  1. Advanced Formula Creation
  • If Statements
  • VLookups
  • Data Validation
  • Formula Auditing
  • Module 17 - Practice Exercise
  1. PivotTables
  • PivotTables
  • Pivot Charts
  • Module 18 - Practice Exercise
  1. Additional Excel Features
  • Slicers
  • Goal Seeker
  • Text to Columns
  • Watch Window
  • Customizing Ribbons and Tabs
  • Module 19 - Practice Exercise
  1. Shortcuts
  • Excel Shortcuts Every User Should Know
  1. Closing
  • Closing Video

Project Files Included

 

Training Features
  • feature
    EXPERT INSTRUCTOR-LED TRAINING

    We only use the industry’s finest instructors to develop our courses. They have a minimum of 15 years real-world experience and are subject matter experts in their fields. Unlike a live class, you can fast-forward, repeat or rewind all your lectures. This creates a personal learning experience and gives you all the benefit of hands-on training with the flexibility of doing it around your schedule 24/7.

     
     
  • feature
    NAVIGATION & CONTROLS

    Our self-paced training programs are designed in a modular fashion to allow you the flexibility to work with expert level instruction anytime 24/7. All courses are arranged in defined sections with navigation controls allowing you to control the pace of your training. This allows students to learn at their own pace around their schedule.

     
     
     
  • feature
    12 MONTHS UNLIMITED ACCESS

    Each student will have 12 months unlimited access to allow you to have access to the training anytime 24/7.

     
Student Reviews

We make it our absolute mission to give you the training you need and the service you deserve. Hear what our students say about us...

READY TO MASTER EXCEL?

You're only one click away.

Enrol Now
£195.00 £19.99

Save £175.01

Was £195.00 (Offer ends 31/05/2022)
Microsoft Excel 2019 Course
-
+
 

14 day money back guarantee

klarna

Spread the cost

Interest-free instalments

Read more...

Enquire now
We're trusted by
Individuals, small businesses and large corporations who continuously put their trust in My Training Academy.
We are privileged to have trained individuals who work for some of the world’s largest companies, including: