Complete Excel 2019 for Beginners
IC0970

Complete Excel 2019 for Beginners

This Excel course is perfect for those who are 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 to bring your knowledge to an intermediate level. Exercises and sample files at every step along the journey.

2  Reviews   5.0 of 5.0

Course Goal

  • Learn the basics of Excel 2019 up to an intermediate level
  • Become more confident with your spreadsheets
  • Start performing data analysis in Excel today

Audience

  • End users
  • IT/Business analysts
  • Project Managers
  • Project team members

Exam/Certificate


Lesson Plan

2
What is new in Excel 2019
3
Course Overview
4
Overview of the Excel Window
5
Mouse Features
6
Back Stage View

7
Entering Text and Numbers
8
Creating Basic Formulas
9
Relative References
10
Order of Operations
11
Working with Ranges
12
EXERCISE - Practice Exercise
13
Excercise Document
14
EXERCISE - Practice Exercise Solution

15
Working with Save and Save As Commands
16
File Extensions, Share, Export & Publish Files
17
EXERCISE - Practice Exercise
18
Exercise Document

19
Opening a File
20
Working with Larger Files
21
Freeze Panes Option
22
Split Screen Option
23
EXERCISE - Practice Exercise
24
EXERCISE - Practice Exercise files

25
Headers and Footers
26
Working with Print Titles
27
Working with Comments
28
Page Setup Options
29
Fit to Print on One Page
30
Printing Workbooks
31
EXERCISE - Practice Exercise
32
Practice Exercise files

33
Adding and Deleting Rows / Columns
34
Changing Column and Row Widths
35
EXERCISE - Practice Exercise
36
Practice Exercise files

37
Cut, Copy and Paste
38
Copying Formulas
39
EXERCISE - Practice Exercise
40
Practice Exercise files

41
Overview of Formulas
42
Create Formulas Using Functions I
43
Create Formulas Using Functions II
44
Absolute Values
45
EXERCISE - Practice Exercise
46
Practice Exercise files

47
Adding, Deleting and Renaming Sheets
48
Additional Sheet Tab Options
49
3 Dimensional Formulas
50
EXERCISE - Practice Exercise
51
Practice Exercise files

52
Formatting Cells I
53
Formatting Cells II
54
Formatting Numbers
55
Borders and Shading
56
Format as Table
57
Using Styles
58
Using Format Painter
59
Protecting Sheets
60
Using the Fill Handle and Custom Lists
61
EXERCISE - Practice Exercise
62
Practice Exercise files

63
Creating Charts
64
Types of Charts
65
Editing Charts I
66
Editing Charts II
67
Using Graphics to Enhance Charts
68
Linking Chart Titles
69
EXERCISE - Practice Exercise
70
Practice Exercise files

71
Creating Range Names
72
Managing Names
73
Using Names in Formulas
74
EXERCISE - Practice Exercise
75
Practice Exercise files

76
Removing Duplicates
77
Sorting Data
78
Filtering Data
79
Advanced Filters
80
EXERCISE - Practice Exercise
81
Practice Exercise files

82
Creating an Outline
83
Subtotals
84
EXERCISE - Practice Exercise
85
Practice Exercise files

86
Arranging Files
87
New Window Option
88
Custom Views
89
EXERCISE - Practice Exercise
90
Practice Exercise files

91
Creating Formulas between files
92
Working with Links
93
Consolidating Data
94
EXERCISE - Practice Exercise
95
Practice Exercise files

96
Creating IF Statements
97
VLookups
98
Data Validation
99
Formula Auditing
100
EXERCISE - Practice Exercise
101
Practice Exercise files

102
Pivot Tables
103
Pivot Charts
104
EXERCISE - Practice Exercise
105
Practice Exercise files

106
Slicers
107
Goal Seeker
108
Text to Columns
109
Watch Window
110
Customizing Ribbons and Tabs
111
EXERCISE - Practice Exercise
112
Practice Exercise files

113
Excel Shortcuts Every User should know

114
Course Summary

Instructor

Simon Calder

4.8 Average Rating

6 Reviews

70 Students

9 Courses

Simon Calder

Teaching Business Software

Simon Sez IT makes business and technical software simple to learn. We teach people to use the most popular business software including Microsoft Office, Microsoft Project, Photoshop, Web Design and QuickBooks. We've been teaching online for over ten years.

It all started when the owner, Chris "Simon" Calder was working as a Project Manager in IT for one of Los Angeles most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course which he sold on DVD via eBay. Fast forward to now and Simon Sez IT has taught hundreds of thousands of students through its online course platform and popular YouTube channel.


More Courses by Simon Calder:

Excel 2019 Advanced
Excel 2019 Advanced

Move your knowledge beyond the basics and supercharge your Excel capabilities. With this 8-hour, expert-led video tra...

5.0

Average Rating

Excel 2016 Intermediate
Excel 2016 Intermediate

This course takes you well beyond the beginner stage to become an Excel power user. Learn the additional advanced ski...

New Course - Not Enough Reviews yet

Excel 2016 Advanced
Excel 2016 Advanced

Go beyond the basics and supercharge your Excel capabilities. With this expert-led training course, you’ll gain...

New Course - Not Enough Reviews yet

View All Courses

Student Feedback

5.0

Average Rating

Reviews

Annual Subscription to All Courses
$1599

Or subscribe to this course for

$395


Training 5 or more people?

Unlimited access for your entire SAP team including admin platform and premium reporting.

SAP Training for Businesses

Language: English
Level: Beginner
Duration: 7.00 hours
Type:  Instructor-led
Release: Enterprise Software
Category: Business Productivity

SAP students

1,773

student views.
Join them!


Related Courses