Creating Workbooks | Microsoft Excel Beginners 2019

Book Overview & Buying
Table Of Contents

Microsoft Excel Beginners 2019

By : Simon Sez IT

Buy this Video

Microsoft Excel Beginners 2019

By: Simon Sez IT

Buy this Video

Overview of this book

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. All the codes and supporting files for this course are available at: https://github.com/PacktPublishing/Microsoft-Excel-Beginners-2019

Intro to Excel

What's New In Excel 2019

Course Overview

Overview of the Excel window

Mouse-Features

Back Stage View

Creating Workbooks

Entering Text and Numbers

Creating Basic Formulas

Relative References

Order of Operations

Working with Ranges

Module 2 - Practice Exercise

Saving Workbooks

Working with the Save and Save As Commands

File Extensions, Share, Export and Publish Files

Module 3 - Practice Exercise

Navigating Workbooks

Opening a File

Working with Larger Files

Freeze Panes Option

Split Screen Option

Module 4 - Practice Exercise

Page Setup & Print Options

Headers and Footers

Print Titles

Comments

Page Setup Options

Fit to Print on One Page

Printing Workbooks

Module 5 - Practice Exercise

Working with Rows, Columns and Cells

Adding and deleting rows columns and cells

Changing Column and-Row Widths

Module 6 - Practice Exercise

Moving Data

Cut Copy and Paste

Copying Formulas

Module 7 - Practice Exercise

Formulas & Functions

Overview of Formulas

Create Formulas Using Functions part1

Create Formulas Using Functions part 2

Absolute Values

Module 8 - Practice Exercise

Working with Sheets

Adding Deleting and Renaming Sheets

Additional Sheet Tab Options

3 Dimensional Formulas

Module 9 - Practice Exercise

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

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

Working with Names

Creating Range Names

Managing Names

Using Names in Formulas

Module 12 - Practice Exercise

Sorting and Filtering

Remove Duplicates

Sort Data

Filter Data

Advanced Filters

Module 13 - Practice Exercise

Outlining and Subtotaling

Creating an Outline

Subtotals

Module 14 - Practice Exercise

Working with Views

Arranging Files

New Window Option

Custom Views

Module 15 - Practice Exercise

Linking Files

Creating Formulas Between Files

Working with Links

Consolidating Data

Module 16 - Practice Exercise

Advanced Formula Creation

If Statements

VLookups

Data Validation

Formula Auditing

Module 17 - Practice Exercise

PivotTables

Pivot Charts

Module 18 - Practice Exercise

Additional Excel Features

Slicers

Goal Seeker

Text to Columns

Watch Window

Customizing Ribbons and Tabs

Module 18 - Practice Exercise

Shortcuts

Excel Shortcuts Every User Should Know

Closing

Closing Video

Microsoft Excel Beginners 2019

By : Simon Sez IT

Microsoft Excel Beginners 2019

By: Simon Sez IT

Overview of this book

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access