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
Resolve the captcha to access the links!