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.

New Course - Not Enough Reviews Yet

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

#Description
Introduction to Excel 2019
1 Introduction Preview
2 What is 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 EXERCISE - Practice Exercise
13 Excercise Document
14 EXERCISE - Practice Exercise Solution
Saving Workbooks
15 Working with Save and Save As Commands
16 File Extensions, Share, Export & Publish Files
17 EXERCISE - Practice Exercise
18 Exercise Document
Navigating Workbooks
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
Page Setup & Print Options
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
Working with Rows, Columns and Cells
33 Adding and Deleting Rows / Columns
34 Changing Column and Row Widths
35 EXERCISE - Practice Exercise
36 Practice Exercise files
Moving Data
37 Cut, Copy and Paste
38 Copying Formulas
39 EXERCISE - Practice Exercise
40 Practice Exercise files
Formulas & Functions
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
Working with Sheets
47 Adding, Deleting and Renaming Sheets
48 Additional Sheet Tab Options
49 3 Dimensional Formulas
50 EXERCISE - Practice Exercise
51 Practice Exercise files
Formatting Worksheets
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
Charts
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
Working with Names
71 Creating Range Names
72 Managing Names
73 Using Names in Formulas
74 EXERCISE - Practice Exercise
75 Practice Exercise files
Sorting and Filtering
76 Removing Duplicates
77 Sorting Data
78 Filtering Data
79 Advanced Filters
80 EXERCISE - Practice Exercise
81 Practice Exercise files
Outlining and Subtotaling
82 Creating an Outline
83 Subtotals
84 EXERCISE - Practice Exercise
85 Practice Exercise files
Working with Views
86 Arranging Files
87 New Window Option
88 Custom Views
89 EXERCISE - Practice Exercise
90 Practice Exercise files
Linking Files
91 Creating Formulas between files
92 Working with Links
93 Consolidating Data
94 EXERCISE - Practice Exercise
95 Practice Exercise files
Advanced Formula Creation
96 Creating IF Statements
97 VLookups
98 Data Validation
99 Formula Auditing
100 EXERCISE - Practice Exercise
101 Practice Exercise files
Pivot Tables
102 Pivot Tables
103 Pivot Charts
104 EXERCISE - Practice Exercise
105 Practice Exercise files
Additional Excel Features
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
Shortcuts
113 Excel Shortcuts Every User should know
Summary
114 Course Summary

Instructor

Simon Calder

No Reviews Yet

2 Reviews

8 Students

2 Courses

Simon Calder

President

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

New Course - Not Enough Reviews yet

View All Courses

Student Feedback

New Course - Not Enough Reviews Yet

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

147

student views.
Join them!


Related Courses