Microsoft Excel 2019 - Beginners course

My Training Academy
My Training Academy

Course

Online

Save 89%

Special Emagister price

£ 20 £ 195 VAT inc.

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

"Course Description

This Microsoft excel 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 Excel course is a great starting point to prepare for the intermediate and advanced Excel course.

The MS Excel beginner’s course will give you a full overview of all of the most common features of Excel and how to use them. Here are some of the highlights of the beginner’s 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.

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 01707 828 751 to make an enquiry.

 "

Important information

Price for Emagister users:

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

"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."

"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."

Questions & Answers

Add your question

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

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Options
  • Auditing
  • Microsoft Excel
  • IT Auditing
  • Painter
  • Graphics
  • Printing
  • Export
  • Microsoft excel training
  • MS Excel

Course programme

"

Course Outline


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



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


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


1: Introduction to Excel


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

  • Intro to Excel

  • What's New In Excel 2019?

  • Course Overview

  • Overview of the Excel Window

  • Mouse Features

  • Back Stage View

    1. Creating Workbooks

  • Creating Workbooks

    • Creating Workbooks
    • Entering Text and Numbers
    • Creating Basic Formulas
    • Relative References
    • Order of Operations
    • Working with Ranges
    • Module 2 - Practice Exercise

  • Entering Text and Numbers

  • Creating Basic Formulas

  • Relative References

  • Order of Operations

  • Working with Ranges

  • Module 2 - Practice Exercise

    1. Saving Workbooks

  • Saving Workbooks

    • Saving Workbooks
    • Working with the Save and Save As Commands
    • File Extensions, Share, Export, and Publish Files
    • Module 3 - Practice Exercise

  • Working with the Save and Save As Commands

  • File Extensions, Share, Export, and Publish Files

  • Module 3 - Practice Exercise

    1. Navigating Workbooks

  • Navigating Workbooks

    • Navigating Workbooks
    • Opening a File
    • Working with Larger Files
    • Freeze Panes Option
    • Split Screen Option
    • Module 4 - Practice Exercise

  • Opening a File

  • Working with Larger Files

  • Freeze Panes Option

  • Split Screen Option

  • Module 4 - Practice Exercise

    1. Page Setup and Print Options

  • Page Setup and Print Options

    • 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

  • 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

  • Working with Rows, Columns, and Cells

    • Working with Rows, Columns, and Cells
    • Adding and deleting rows columns and cells
    • Changing Column and Row Widths
    • Module 6 - Practice Exercise

  • Adding and deleting rows columns and cells

  • Changing Column and Row Widths

  • Module 6 - Practice Exercise

    1. Moving Data

  • Moving Data

    • Moving Data
    • Cut, Copy, and Paste
    • Copying Formulas
    • Module 7 - Practice Exercise

  • Cut, Copy, and Paste

  • Copying Formulas

  • Module 7 - Practice Exercise

    1. Formulas and Functions

  • Formulas and Functions

    • Formulas and Functions
    • Overview of Formulas
    • Create Formulas Using Functions - part 1
    • Create Formulas Using Functions - part 2
    • Absolute Values
    • Module 8 - Practice Exercise

  • 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

  • Working with Sheets

    • Working with Sheets
    • Adding, Deleting, and Renaming Sheets
    • Additional Sheet Tab Options
    • 3 Dimensional Formulas
    • Module 9 - Practice Exercise

  • Adding, Deleting, and Renaming Sheets

  • Additional Sheet Tab Options

  • 3 Dimensional Formulas

  • Module 9 - Practice Exercise

    1. Formatting Worksheets

  • Formatting Worksheets

    • 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

  • 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

  • Charts

    • 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

  • 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

  • Working with Names

    • Working with Names
    • Creating Range Names
    • Managing Names
    • Using Names in Formulas
    • Module 12 - Practice Exercise

  • Creating Range Names

  • Managing Names

  • Using Names in Formulas

  • Module 12 - Practice Exercise

    1. Sorting and Filtering

  • Sorting and Filtering

    • Sorting and Filtering
    • Remove Duplicates
    • Sort Data
    • Filter Data
    • Advanced Filters
    • Module 13 - Practice Exercise

  • Remove Duplicates

  • Sort Data

  • Filter Data

  • Advanced Filters

  • Module 13 - Practice Exercise

    1. Outlining and Subtotaling

  • Outlining and Subtotaling

    • Outlining and Subtotaling
    • Creating an Outline
    • Subtotals
    • Module 14 - Practice Exercise

  • Creating an Outline

  • Subtotals

  • Module 14 - Practice Exercise

    1. Working with Views

  • Working with Views

    • Working with Views
    • Arranging Files
    • New Window Option
    • Custom Views
    • Module 15 - Practice Exercise

  • Arranging Files

  • New Window Option

  • Custom Views

  • Module 15 - Practice Exercise

    1. Linking Files

  • Linking Files

    • Linking Files
    • Creating Formulas between Files
    • Working with Links
    • Consolidating Data
    • Module 16 - Practice Exercise

  • Creating Formulas between Files

  • Working with Links

  • Consolidating Data

  • Module 16 - Practice Exercise

    1. Advanced Formula Creation

  • Advanced Formula Creation

    • Advanced Formula Creation
    • If Statements
    • VLookups
    • Data Validation
    • Formula Auditing
    • Module 17 - Practice Exercise

  • If Statements

  • VLookups

  • Data Validation

  • Formula Auditing

  • Module 17 - Practice Exercise

    1. PivotTables

  • PivotTables

    • PivotTables
    • PivotTables
    • Pivot Charts
    • Module 18 - Practice Exercise

  • PivotTables

  • Pivot Charts

  • Module 18 - Practice Exercise

    1. Additional Excel Features

  • Additional Excel Features

    • Additional Excel Features
    • Slicers
    • Goal Seeker
    • Text to Columns
    • Watch Window
    • Customizing Ribbons and Tabs
    • Module 19 - Practice Exercise

  • Slicers

  • Goal Seeker

  • Text to Columns

  • Watch Window

  • Customizing Ribbons and Tabs

  • Module 19 - Practice Exercise

    1. Shortcuts

  • Shortcuts

    • Shortcuts
    • Excel Shortcuts Every User Should Know

  • Excel Shortcuts Every User Should Know

    1. Closing

  • Closing

    • Closing
    • Closing Video

  • Closing Video

    • Project Files Included


    Project Files Included


    "

    See related categories

    Microsoft Excel 2019 - Beginners course

    Special Emagister price

    £ 20 £ 195 VAT inc.