Description
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
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
