Microsoft Excel Beginners 2019

Microsoft Excel Beginners 2019
Microsoft Excel Beginners 2019
English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 7h 29m | 1.91 GB

Discover Excel 2019 and become confident in using spreadsheets

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.

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
Table of Contents

Intro to Excel
1 Intro to Excel
2 What’s New In Excel 2019
3 Course Overview
4 Overview of the Excel window
5 Mouse-Features
6 Back Stage View

Creating Workbooks
7 Entering Text and Numbers
8 Creating Basic Formulas
9 Relative References
10 Order of Operations
11 Working with Ranges
12 Module 2 – Practice Exercise

Saving Workbooks
13 Working with the Save and Save As Commands
14 File Extensions, Share, Export and Publish Files
15 Module 3 – Practice Exercise

Navigating Workbooks
16 Opening a File
17 Working with Larger Files
18 Freeze Panes Option
19 Split Screen Option
20 Module 4 – Practice Exercise

Page Setup & Print Options
21 Headers and Footers
22 Print Titles
23 Comments
24 Page Setup Options
25 Fit to Print on One Page
26 Printing Workbooks
27 Module 5 – Practice Exercise

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

Moving Data
31 Cut Copy and Paste
32 Copying Formulas
33 Module 7 – Practice Exercise

Formulas & Functions
34 Overview of Formulas
35 Create Formulas Using Functions part1
36 Create Formulas Using Functions part 2
37 Absolute Values
38 Module 8 – Practice Exercise

Working with Sheets
39 Adding Deleting and Renaming Sheets
40 Additional Sheet Tab Options
41 Module 9 – Practice Exercise

Formatting Worksheets
42 Formatting Cells part 1
43 Formatting Cells part 2
44 Formatting Numbers
45 Borders and Shading
46 Format as Table
47 Using Styles
48 Using Format Painter
49 Protecting Sheets
50 Fill Handle and Custom Lists
51 Module 10 – Practice Exercise

Charts
52 Creating Charts
53 Types of Charts
54 Editing Charts Part 1
55 Editing Charts Part 2
56 Using Graphics to Enhance Charts
57 Linking Chart Titles
58 Module 11 – Practice Exercise

Working with Names
59 Creating Range Names
60 Managing Names
61 Using Names in Formulas
62 Module 12 – Practice Exercise

Sorting and Filtering
63 Remove Duplicates
64 Sort Data
65 Filter Data
66 Advanced Filters
67 Module 13 – Practice Exercise

Outlining and Subtotaling
68 Creating an Outline
69 Subtotals
70 Module 14 – Practice Exercise

Working with Views
71 Arranging Files
72 New Window Option
73 Custom Views
74 Module 15 – Practice Exercise

Linking Files
75 Creating Formulas Between Files
76 Working with Links
77 Consolidating Data
78 Module 16 – Practice Exercise

Advanced Formula Creation
79 If Statements
80 VLookups
81 Data Validation
82 Formula Auditing
83 Module 17 – Practice Exercise

PivotTables
84 PivotTables
85 Pivot Charts
86 Module 18 – Practice Exercise

Additional Excel Features
87 Slicers
88 Goal Seeker
89 Text to Columns
90 Watch Window
91 Customizing Ribbons and Tabs
92 Module 18 – Practice Exercise

Shortcuts
93 Excel Shortcuts Every User Should Know

Closing
94 Closing Video