Microsoft Excel 2019: Beginners

Beschreibung

This 7-hour Microsoft Excel 2019 course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. In this course, your expert author gives you a solid grounding in the basics of Excel and guides you towards becoming more confident with spreadsheets.

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 Included?

Unlimited 12 months access
  Access anywhere, any time
  Fast effective training, written and designed by industry experts
  Track your progress with our Learning Management System
  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
  Exam preparation quizzes, tests and mock exams to ensure that you are 100% ready

£119.00In den Warenkorb

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