Accredited Microsoft Excel 2019 Basic and Advanced Training Bundle - Jobs and Recruitment on reed.co.uk, the UK's #1 job site

Accredited Microsoft Excel 2019 Basic and Advanced Training Bundle

£34.78

Become a master of Microsoft Excel 2019 with this essential bundle. Through 16 hours of video tuition combined from 2 in-depth courses, you will master the exceptionally popular program and gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis and reporting of financial information What’s Included? Unlimited 12 months access Access anywhere, any time Fast effective training, written and designed by industry experts Unlimited support Save money, time and travel costs Learn at your own pace and leisure Easier to retain knowledge and revise topics than traditional methods What You’ll Learn · What’s new in Excel 2019 · 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 · What’s new/different in Excel 2019 · Advanced charting and graphing in Excel · How to use detailed formatting tools · Lookup and advanced lookup functions · Financial functions including calculating interest and depreciation · Statistical functions · Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web. · How to create awesome visualizations using sparklines and data bars · Mastery of PivotTables and Pivot Charts · Scenario Manager, Goal Seek and Solver · Advanced charts such as Surface, Radar, Bubble and Stock Charts Course Format: This is a video-led course. This course includes practice exercises so you can practice as you learn. This course is suitable for Windows users.

SKU: 286382 Category:

Description

Accounting and finance_Bookkeeping

Description

This in-depth course will take you from zero to hero in the latest Excel MS 19 series.

Here is the content of the 21 modules for the basic 2019 course :

MODULES

1: Intro to Excel

Intro to Excel

What’s New In Excel 2019?

Course Overview

Overview of the Excel window

Mouse Features

Back Stage View

2. Creating Workbooks

Entering Text and Numbers

Creating Basic Formulas

Relative References

Order of Operations

Working with Ranges

Practice Exercise

3. Saving Workbooks

Working with the Save and Save As Commands

File Extensions, Share, Export, and Publish Files

Practice Exercise

4. Navigating Workbooks

Opening a File

Working with Larger Files

Freeze Panes Option

Split Screen Option

Practice Exercise

5. Page Setup and Print Options

Headers and Footers

Print Titles

Comments

Page Setup Options

Fit to Print on One Page

Printing Workbooks

Practice Exercise

6. Working with Rows, Columns, and Cells

Adding and deleting rows columns and cells

Changing Column and Row Widths

Practice Exercise

7. Moving Data

Cut, Copy, and Paste

Copying Formulas

Practice Exercise

8. Formulas and Functions

Overview of Formulas

Create Formulas Using Functions – part1

Create Formulas Using Functions – part 2

Absolute Values

Practice Exercise

9. Working with Sheets

Adding, Deleting, and Renaming Sheets

Additional Sheet Tab Options

3 Dimensional Formulas

Practice Exercise

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

Practice Exercise

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

12. Working with Names
Creating Range Names

Managing Names

Using Names in Formulas

Practice Exercise

13. Sorting and Filtering

Remove Duplicates

Sort Data

Filter Data

Advanced Filters

Practice Exercise

14. Outlining and Subtotaling

Creating an Outline

Subtotals

Practice Exercise

15. Working with Views

Arranging Files

New Window Option

Custom Views

Practice Exercise

16. Linking Files

Creating Formulas between Files

Working with Links

Consolidating Data

Practice Exercise

17. Advanced Formula Creation

If Statements

VLookups

Data Validation

Formula Auditing

Practice Exercise

18. PivotTables

PivotTables

Pivot Charts

Practice Exercise

19. Additional Excel Features

Slicers

Goal Seeker

Text to Columns

Watch Window

Customizing Ribbons and Tabs

Practice Exercise

20. Shortcuts

Excel Shortcuts Every User Should Know

21. Closing

Closing Video

And the Advanced Excel 2019 series :

MODULES

Chapter 1: Introduction to Excel 2016 Advanced Course

Prerequisites of the Course and Version of Excel

Course Structure

Chapter 2: Functions

Functions – Part 1

Functions – Part 2

Autosum

Chapter 3: Date and Time Functions

How Date and Time Works

Basic Date and Time Functions

Complex Date and Time Functions

Chapter 4: Text Functions

Using Text Functions – Part 1

Using Text Functions – Part 2

Chapter 5: Logical Functions

Using Logical Functions

Exercise 01

Chapter 6: Lookup Functions

HLOOKUP Function

VLOOKUP Function

Exercise 02

Chapter 7: Financial Functions

Financial Functions and Terminology

Personal Financial Functions

Professional Financial Functions

Depreciation

Exercise 03

Chapter 8: Statistical Functions

Statistical Functions for Description – Part 1

Statistical Functions for Description – Part 2

Statistical Functions for Forecasting – Part 1

Statistical Functions for Forecasting – Part 2

Exercise 04

One Click Forecasting

Statistical Functions for Inference

Chapter 9: Connecting to External Data

Connecting to Other Workbooks

Connecting to Access Databases

Connecting to Web Data Sources

Get and Transform

Exercise 05

Chapter 10: Tables

Introduction to Tables

Working with Tables

Table References

Table Styles

Exercise 06

Chapter 11: Pivot Tables

Introduction to Pivot Tables

Working with Pivot Tables

Filters and Slicers

Pivot Charts

Exercise 07

Chapter 12: Data Analysis

What If Analysis

Scenario Manager

Goal Seek

Solver

Exercise 08

Chapter 13: Graphs and Charts

Area Charts

Surface Charts

Radar Charts

Bubble Charts

Sparklines

Stock Charts

Exercise 09

Chapter 14: Excel Web App

Introduction to Excel Web App

Using the Excel Web App

Chapter 15: Course Conclusion

Closing Message