Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Microsoft Excel 2019/365 for Absolute Beginners

Name: Microsoft Excel 2019/365 for Absolute Beginners
Rating: 4.5 (31 reviews)

Start your spreadsheet journey with this Excel 2021 training course for beginners!

Created bySimon Sez IT

Last updated 3/2024

English

English [Auto],

What you'll learn

Discover new and improved features in Excel 2019
How to effectively use Excel 2019 on a touchscreen device.
How create, save, and open a workbook.
Learn how to personalize your use of Excel using Excel Options.
How to use and how to customize the Quick Access Toolbar.
Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
The basics of entering and editing data in a workbook.
Discover how to format dates and numbers.
Learn practical methods in which you can backup and recover your Excel spreadsheets.
Effectively use autofill and flashfill so you are more productive.
Discover the essentials of using fomulas and functions.
How to rename, insert, move, and reference an Excel 2019 worksheet.
Discover how to create charts and graphs
Learn practical methods to sort and filter your data
How to protect and secure your Excel data

Course content

23 sections • 107 lectures • 12h 41m total length

Intro to Excel1:00
Discover the basics and essential features of Excel 2019, guided by an experienced instructor, with practical tips and a look at what's new for absolute beginners.
WATCH ME: Essential Information for a Successful Training Experience2:03
DOWNLOAD ME: Course Exercise Files0:23
Downloadable course transcripts0:19
Free Keyboard Shortcut Guides0:18
What's New In Excel 20197:52
Course Overview1:16
Overview of the Excel window8:25
Mouse-Features3:12
Back Stage View2:37
Explore the backstage view in Excel to open, create new workbooks with templates for calendars and budgets, and use options for save, print, share, export, publish, and close the file.
Section 1 Quiz

Entering Text and Numbers4:32
Creating Basic Formulas6:49
Learn to create basic Excel formulas using cell references and the equals sign to add and subtract numbers, applying relative references to profits from sales and expenses.
Relative References3:01
Explore relative references in Excel by copying formulas across columns and rows with the fill handle. Learn when to use absolute references and the order of operations.
Order of Operations4:48
Working with Ranges4:14
Module 2 - Practice Exercise1:35
practice the module 2 exercise by building a blank workbook with monthly sales and expenses, calculating profit, summing totals, and projecting April using the order of operations.
Section 2 Quiz

Working with the Save and Save As Commands4:34
File Extensions, Share, Export and Publish Files3:44
Learn to save and export Excel workbooks, choose formats like CSV and PDF, share via SharePoint or email, and publish with Power BI for self-service dashboards.
Module 3 - Practice Exercise0:59
Save your workbook by using save as, create a desktop folder named my sales report, ensure the file extension is .xlsx, and review sharing, export, and publish options.
Section 3 Quiz

Opening a File5:33
Working with Larger Files5:34
Freeze Panes Option3:16
Split Screen Option3:22
Use split screen to view two areas of a workbook at once with horizontal and vertical splits. Turn off by splitting again or dragging the splitter.
Module 4 - Practice Exercise2:50
Navigate workbooks to review the terms of loan and the five year loan schedule, link C9 to D3, and use freeze panes and split view.
Section 4 Quiz

Headers and Footers7:23
Learn how to add headers and footers, edit page setup and print options, and customize dates, times, file names, and page numbers for professional Excel prints.
Print Titles2:52
Comments5:23
Page Setup Options7:30
Master Excel page setup basics, including margins, orientation, size, print area, and headers and footers, then control page breaks, background images, grid lines, borders, and scaling for print-ready spreadsheets.
Fit to Print on One Page3:59
Printing Workbooks3:55
Module 5 - Practice Exercise1:53
Apply page layout techniques to a loan workbook by editing headers and footers, adding date and name, centering vertically, setting rows four through seven as print titles, print and save.
Section 5 Quiz

Cut, Copy and Paste7:07
Explore cutting, copying, and pasting in Excel, using the clipboard to move or duplicate data across cells and even between programs, via four simple steps.
Copying Formulas5:09
Learn how to copy formulas using the fill handle, understand relative references, and use paste options like values, formulas, transpose, and formatting to move data in Excel.
Module 7 - Practice Exercise1:20
Section 7 Quiz

Overview of Formulas2:48
Explore formulas and functions in Excel, starting with the equals sign and simple additions, then use functions to compute data across the same sheet, different sheets, or a different file.
Create Formulas Using Functions Part 110:04
Learn to create formulas with functions in Excel, using AutoSum to add ranges and apply average, max, and count. Explore selecting ranges, dragging formulas, and the insert function dialog.
Create Formulas Using Functions Part 25:24
Master formulas and functions in Excel 2019/365 by using function arguments to perform calculations with sum, max, min, and if statements, and applying relative references.
Absolute Values5:16
Learn how to create absolute references in Excel to calculate a 15 percent commission based on totals, and copy formulas without shifting.
Module 8 - Practice Exercise1:20
Section 8 Quiz

Formatting Cells Part 110:04
Formatting Cells Part 23:38
Learn to format cells with wrap text, merge and center, shrink to fit, and custom text orientation and rotation degree to control alignment in your worksheets.
Formatting Numbers9:24
Borders and Shading7:08
Master borders and shading to format worksheets, print grid lines, apply borders around selections, and use fill colors and patterns for standout, customizable cells.
Format as Table6:07
Using Styles3:49
Select a range, apply built-in styles from the home tab to quickly format tables, customize with bold, italics, color, borders, and center alignment, or create and reuse your own styles.
Using Format Painter4:29
Protecting Sheets9:01
Protect sheets, cells, and workbooks in Excel while unlocking only the edited cells. Use go to special for constants and formulas, apply passwords, and enable allow edit ranges, SharePoint collaboration.
Fill Handle and Custom Lists7:17
Module 10 - Practice Exercise1:10
Section 10 Quiz

Requirements

Microsoft Excel 2019/365 desktop version for Windows installed and ready to use on your computer.

Description

**This course includes practice exercises and LIFETIME access**

Get the basics of Microsoft Excel 2019 down in this detailed, course from Excel experts Simon Sez IT.

With this 7-hour Microsoft Excel 2019/365 course, you’ll gain a fantastic grounding in Microsoft Excel. This in-depth course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. This course is perfect if you’re brand new to Excel or are upgrading from an older version.

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

***Exercise and demo files included***

This course includes:

7-hours of video tutorials
95 individual video lectures
Exercise files to practice what you learned
Demo files used by the trainer
Certificate of completion

This course is designed for students that are new to Microsoft Excel or who are upgrading from a previous version and want to keep up to date with Excel 2019 and 365 developments. If you’re brand new to spreadsheets this course is perfect for you as our expert author guides you through the important areas of Excel.

Contents and Overview

Through 95 lectures and over 7-hours of content, this course will teach you to understand spreadsheet basics, including:

Creating your first workbook and how to navigate Excel
Page and print setup - just print the bits of Excel you mean to!
Moving data around and adding and deleting
Introduction to formulas and functions, what you need to know.
How to create amazing looking charts and graphs
And so much more...

Upon completion of this course, you’ll have an intermediate understanding of Microsoft Excel 2019/365 and a certificate to prove it!

Description

Unlock the power of Microsoft Excel and watch your productivity soar!

BUSINESSES RUN ON MICROSOFT EXCEL. Microsoft Excel remains the go-to tool for crunching numbers for millions of office workers.
PERFECT FOR BEGINNERS. This course covers basic and intermediate level skills across MS Excel 2019365.
MAKING SOFTWARE SIMPLE. Our approach to teaching is all about making complex software simple to use. Our expert tutors don’t rush through content, instead they take the time to explain how things work in simple, plain English.
EVERYTHING IS INCLUDED. You don’t get just a how-to video from Simon Sez IT. Modules include downloadable practice exercises so you can put into practice what you learn straight away. If that’s not enough you’ll also get Certificates of Completion - proof that you’ve learnt those valuable Microsoft Excel skills.
A GREAT GIFT IDEA. Not shopping for you? No problem, give the gift of learning with Simon Sez IT and help the ones you love succeed.

Here’s what our students are saying…

★★★★★ "Hi. My name is Crockett and I live in New Orleans, Louisiana. I just want to take the time to thank this instructor for taking the time to give this course. I feel that my monies were well spent.
Thanks again and I highly recommend this class for anyone wanting to expand their knowledge in Excel.”
- Carlos Crocket

★★★★★ “The content is comprehensive and informative. The speaker has a clear voice and at the perfect speed. The training is so engaging I'm looking forward to complete the next lectures.
Many thanks!”
- Helena M Tome

★★★★★ “The instructor explained the content in a logical way and included tips and reminders about different functionality used in the different versions of Excel. ”
- Carla Schanstra

Did you know?

Simon Sez IT teaches all sorts of software, including:

- Microsoft Excel

- Microsoft PowerPoint

- Microsoft Word

- Microsoft Project

- Microsoft Outlook

- QuickBooks

- Photoshop Elements

- Web Development Languages

- And so much more!

Who this course is for:

Those new to using Microsoft Excel.
No previous knowledge of Excel required. This course is created for absolute beginners.
If you want to refresh your memory and understanding of Excel.
Users of earlier versions of Excel looking to update their skills to 2019/365

Microsoft Excel 2019/365 for Absolute Beginners

What you'll learn

Explore related topics

Course content

Intro to Excel10 lectures • 27min

Creating Workbooks6 lectures • 25min

Saving Workbooks3 lectures • 9min

Navigating Workbooks5 lectures • 21min

Page Setup & Print Options7 lectures • 33min

Working with Rows, Columns and Cells3 lectures • 11min

Moving Data3 lectures • 14min

Formulas & Functions5 lectures • 25min

Working with Sheets4 lectures • 16min

Formatting Worksheets10 lectures • 1hr 2min

Requirements

Description

Who this course is for: