Master Excel 2019 PC/Mac with Beginner to Advanced Courses

Finally master spreadsheets on PC or Mac with Excel, Beginners - Advanced 3 course 2019/365 bundle

4.65 (233 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
1,505
students
26 hours
content
Mar 2024
last update
$74.99
regular price

What you will learn

Now includes Excel for Mac 2019 Beginner

Discover new and improved features in Excel 2019

Learn to master data analysis tools like Pivot tables, Slicers, Sparklines and Data Bars in Excel

Learn essential logical functions like IF, SUMIF, COUNTIF

Learn powerful Lookup Functions VLOOKUP, HLOOKUP and INDEX MATCH

Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.

You'll cover all the basics like how to rename, insert, move, and reference an Excel worksheet

Discover how to format dates and numbers in Excel

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.

Discover how to create awesome charts and graphs in Excel

Learn practical methods to sort and filter your data using Microsoft Excel

How to protect and secure your Excel data

Working with dates and times in Microsoft Excel

Averages, percentiles, and LINEST functions

You'll learn financial and statistical functions like calculating depreciation

Learn to visualize your data using Sparklines, data bars and Pivot Charts in Excel

How to import and export data to and from Excel

Description

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

** Feb 2020 - Excel Beginners for Mac 2019 Course added!**


Everything you need to become a spreadsheet guru in Microsoft Excel 2019/365 from Beginner to Advanced users by Excel experts Simon Sez IT.


Excel for Beginners 2019

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


Advanced Excel 2019

With this 8-hour, expert-led video training course, you’ll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis and reporting of financial information.


What You'll Learn

  • What's new/different in Excel 2019

  • Advanced charting and graphing in Excel

  • How to use detailed formatting tools

  • Lookup and advanced lookup functions

  • Financial functions including calculating interest and depreciation

  • Statistical functions

  • Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.

  • How to create awesome visualizations using sparklines and data bars

  • Mastery of PivotTables and Pivot Charts

  • Scenario Manager, Goal Seek and Solver

  • Advanced charts such as Surface, Radar, Bubble and Stock Charts

***Exercise and demo files included in both courses***


This 3-course bundle includes:

  1. 20-hours of video tutorials

  2. Over 200 individual video lectures

  3. Exercise files to practice what you learned

  4. Demo files used by the trainer

  5. Certificates of completion


This Excel mega bundle is designed for students of all Excel capabilities. If you are brand 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, then the start at the beginning.

If you already have a good understanding of MS Excel then you might want to start in the Advanced section where the expert author will help you take your spreadsheeting skills to the next level.


Contents and Overview

Through 200+ lectures and over 20-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

Before moving onto the most business-relevant advanced functions and formulas you might need. This includes:

  • Financial functions (interest depreciation etc.)

  • Statistical functions

  • How to best visualize your data using PivotTables and Pivot Charts

  • Advanced charting

  • And so much more...


Upon completion of this course, you'll have a great grounding in Excel formulas and functions. You’ll be confident in navigating, sharing and using spreadsheets in a variety of ways.

You’ll be able to create charts that have an impact from databases that communicate data and financial records efficiently and effectively.

You will be able to report data in various formats including: tables, graphs and PivotTables. Once completed you'll have advanced understanding of Excel that will positively impact your professional capability.


Here’s what our students are saying…

★★★★★ "A comprehensive and well structured course, and the examples and explanations are clearly presented; and the instructor is very engaging, easy to listen to and even entertaining (which is always a plus for keeping ones interest.”
- Arnold Schwartz

★★★★★ “Instructor explains topics in clearly. The course is relevant and is helpful to people who have no or little experience with Excel like me. Update: The instructor makes learning fun and simple, I have been learning many different functions that are necessary when applying to real life business situations.”
- Daniel Trujillo

★★★★★ “One of the BEST courses I have taken on Excel. This course takes the student through all of the options for charting and data visualization. The examples are structured so there is no redundancy and time wasting steps. Well done!
- Jim Tibbetts



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!

Content

Excel 2019 Beginner: Intro to Excel

Intro to Excel
Essential Information for a Successful Training Experience
Course exercise files
What's New In Excel 2019
Course Overview
Overview of the Excel window
Mouse-Features
Back Stage View
Section 1 - Quiz

Excel 2019 Beginner: Creating Workbooks

Entering Text and Numbers
Creating Basic Formulas
Relative References
Order of Operations
Working with Ranges
Module 2 - Practice Exercise
Section 2 Quiz

Excel 2019 Beginner: Saving Workbooks

Working with the Save and Save As Commands
File Extensions, Share, Export and Publish Files
Module 3 - Practice Exercise
Section 3 Quiz

Excel 2019 Beginner: Navigating Workbooks

Opening a File
Working with Larger Files
Freeze Panes Option
Split Screen Option
Module 4 - Practice Exercise
Section 4 Quiz

Excel 2019 Beginner: Page Setup & Print Options

Headers and Footers
Print Titles
Comments
Page Setup Options
Fit to Print on One Page
Printing Workbooks
Module 5 - Practice Exercise
Section 5 Quiz

Excel 2019 Beginners: Working with Rows, Columns and Cells

Adding and deleting rows columns and cells
Changing Column and-Row Widths
Module 6 - Practice Exercise
Section 6 Quiz

Excel 2019 Beginners: Moving Data

Cut, Copy and Paste
Copying Formulas
Module 7 - Practice Exercise
Section 7 Quiz

Excel 2019 Beginners: Formulas & Functions

Overview of Formulas
Create Formulas Using Functions Part 1
Create Formulas Using Functions Part 2
Absolute Values
Module 8 - Practice Exercise
Section 8 Quiz

Excel 2019 Beginner: Working with Sheets

Adding Deleting and Renaming Sheets
Additional Sheet Tab Options
3 Dimensional Formulas
Module 9 - Practice Exercise
Section 9 Quiz

Excel 2019 Beginner: Formatting Worksheets

Formatting Cells Part 1
Formatting Cells Part 2
Formatting Numbers
Borders and Shading
Format as Table
Using Styles
Using Format Painter
Protecting Sheets
Fill Handle and Custom Lists
Module 10 - Practice Exercise
Section 10 Quiz

Excel 2019 Beginner: Charts

Creating Charts
Types of Charts
Editing Charts Part 1
Editing Charts Part 2
Using Graphics to Enhance Charts
Linking Chart Titles
Module 11 - Practice Exercise
Section 11 Quiz

Excel 2019 Beginner: Working with Names

Creating Range Names
Managing Names
Using Names in Formulas
Module 12 - Practice Exercise
Section 12 Quiz

Excel 2019 Beginner: Sorting and Filtering

Remove Duplicates
Sort Data
Filter Data
Advanced Filters
Module 13 - Practice Exercise
Section 13 Quiz

Excel 2019 Beginner: Outlining and Subtotaling

Creating an Outline
Subtotals
Module 14 - Practice Exercise
Section 14 Quiz

Excel 2019 Beginner: Working with Views

Arranging Files
New Window Option
Custom Views
Module 15 - Practice Exercise
Section 15 Quiz

Excel 2019 Beginner: Linking Files

Creating Formulas Between File
Working with Links
Consolidating Data
Module 16 - Practice Exercise
Section 16 Quiz

Excel 2019 Beginner: Advanced Formula Creation

If Statements
VLookups
Data Validation
Formula Auditing
Module 17 - Practice Exercise
Section 17 Quiz

Excel 2019 Beginner: Pivot Tables

Pivot Tables
Pivot Charts
Module 18 - Practice Exercise
Section 18 Quiz

Excel 2019 Beginner: Additional Excel Features

Slicers
Goal Seeker
Text to Columns
Watch Window
Customizing Ribbons and Tabs
Module 19 - Practice Exercise
Section 19 Quiz

Excel 2019 Beginner: Shortcuts

Excel Shortcuts Every User Should Know

Excel 2019 Beginner: Closing

Closing Video

Excel 2019 Advanced: Introduction to Excel 2019 Advanced Course

Introduction to the Course
Essential Information for a Successful Training Experience
Excel 2019 Advanced Course Exercise Files
Excel 2019 Advanced Course Demo Files
Course Structure

Excel 2019 Advanced: Functions

Functions - Part 1
Functions - Part 2
Autosum
Section 23 Quiz

Excel 2019 Advanced: Date and Time Functions

How Date and Time Works
Basic Date and Time Functions
Complex Date and Time Functions
Section 24 QUiz

Excel 2019 Advanced: Text Functions

Using Text Functions - Part 1
Using Text Functions - Part 2
Section 25 Quiz

Excel 2019 Advanced: Logical Functions

Logical Functions
Exercise 01
Section 26 Quiz

Excel 2019 Advanced: Lookup Functions

Lookup Functions - Part 1
Lookup Functions - Part 2
Exercise 02
Section 27 Quiz

Excel 2019 Advanced: Financial Functions

Financial Functions and Terminology
Personal Financial Functions
Principal and Interest Payments
Depreciation
Exercise 03
Section 28 Quiz

Excel 2019 Advanced: Statistical Functions

Statistical Functions for Description - Part 1
Statistical Functions for Description - Part 2
Statistical Functions for Forecasting - Part 1
Statistical Functions for Forecasting - Part 2
Exercise 04
One Click Forecasting
Statistical Functions for Inference
Section 29 Quiz

Excel 2019 Advanced: Connecting to External Data

Connecting to Other workbooks
Connecting to Access Databases
Connecting Web Data Sources
Get and Transform
Exercise 05
Section 30 Quiz

Excel 2019 Advanced: Tables

Introduction to Tables
Working with Tables
Table References
Table Styles
Exercise 6
Section 31 Quiz

Excel 2019 Advanced: Pivot Tables

Introduction to Pivot Tables
Working with Pivot Tables
Filters and Slicers
Pivot and Charts
Exercise 07
Section 32 Quiz

Excel 2019 Advanced: Data Analysis

What If Analysis
Scenario Manager
Goal Seek
Solver
Exercise 08
Section 33 Quiz

Graphs and Charts

Area Charts
Surface Charts
Radar Charts
Bubble Charts
Sparklines
Stock Charts
Exercise 9
Section 34 Quiz

Excel 2019 Advanced: Excel Web App

Web App - Part 1
Web App - Part 2
Section 35 Quiz

Excel 2019 Advanced: Course Conclusion

Close

Excel 2019 for Mac Beginner: Introduction to Excel

Introduction to Excel for Mac
Essential Information for a Successful Training Experience
Course exercise files
Course demo files
The Difference between PC and Mac Excel
Course Overview
Overview of the Excel window
Mouse and Trackpad Features
Creating a New Workbook
Section Quiz

Excel 2019 for Mac Beginner: Creating Workbooks

Entering Text and Numbers
Creating Basic Formulas
Relative vs Absolute References
Order of Operations
Working with Ranges
Practice Exercise 01
Section Quiz

Excel 2019 for Mac Beginner: Saving Workbooks

Saving and Sharing Spreadsheets
Practice Exercise 02
Section Quiz

Excel 2019 for Mac Beginner: Navigating Large Workbooks

Freeze Panes Option
Split Screen Option
Arranging Windows Option
Practice Exercise 03
Section Quiz

Excel 2019 for Mac Beginner: Page Setup and Print Options

Headers and Footers
Print Titles
Comments
Page Setup Options
Printing Workbooks
Practice Exercise 04
Section Quiz

Excel 2019 for Mac Beginner: Working with Rows, Columns and Cells

Adding and Deleting Rows, Columns and Cells
Changing Column and Row Widths
Practice Exercise 05
Section Quiz

Excel 2019 for Mac Beginner: Moving Data

Cut, Copy and Paste
Copying Formulas
Practice Exercise 06
Section Quiz

Excel 2019 for Mac Beginner: Formulas and Functions

Overview of Formulas
Creating Formulas using Functions - Part 1
Creating Formulas using Functions - Part 2
Practice Exercise 07
Section Quiz

Excel 2019 for Mac Beginner: Working with Sheets

Sheet Tab Options
3 Dimensional Formulas
Practice Exercise 08
Section Quiz

Excel 2019 for Mac Beginner: Formatting Worksheets

Formatting Cells - Part 1
Formatting Cells - Part 2
Number Formatting
Formatting as Table
Using Styles
Conditional Formatting
Using Format Painter
Protecting Sheets
Fill Handle and Custom Lists
Practice Exercise 09
Section Quiz

Excel 2019 For Mac Beginner: Charts

Creating Charts
Editing Charts - Part 1
Editing Charts - Part 2
Practice Exercise 10
Section Quiz

Excel 2019 for Mac Beginner:Sorting and Filtering

Remove Duplicates
Sort Data
Filter Data
Advanced Filter
Practice Exercise 11
Section Quiz

Excel 2019 for Mac Beginner: Conclusion

Course Close

Screenshots

Master Excel 2019 PC/Mac with Beginner to Advanced Courses - Screenshot_01Master Excel 2019 PC/Mac with Beginner to Advanced Courses - Screenshot_02Master Excel 2019 PC/Mac with Beginner to Advanced Courses - Screenshot_03Master Excel 2019 PC/Mac with Beginner to Advanced Courses - Screenshot_04

Reviews

Jack
August 18, 2022
Some of the course documents were incomplete and inconsistent with the instruction if the videos. Specifically, the "Linking Formulas" document in the Mac class.
Kristina
July 5, 2022
This course was great in giving a basic understanding of Excel and I would recommend it to any new user. However, as a MacBook user, I found some of the videos in the advanced section to lack the explanation of the mac equivalent when performing certain tasks. Overall, it was well organized and a fairly put-together course.
Mark
May 26, 2021
After graduating from my senior year being all online, this is pretty much the same, very easy to navigate and understand.
Alfonso
January 26, 2021
The voice is clear, the topics are interesting, if you watch the videos at a 1.25 speed is just perfect for persons who want to have a more dynamic and fast learning. If you are looking to get your hand on Excel for getting a certificate or sth, you must take this course
Laurie
November 19, 2020
Yes, this is just what I was hoping for as I am new to excel. However, I am on a Mac and the "File" button is not on my page. Where would I find that or will that be covered later?
John
August 2, 2020
Good, but noticed she used Ctrl C to copy on a Mac and then Ctrl V to paste. On a Mac, it's the CMD key + C or V
Manar
December 20, 2019
It's a great course to learning excel from scratch, but I if you put resources in some videos so we can work on on it while watching the video it would be better to make sure that we really learned excel
Miss_Andey
October 21, 2019
I have taken other Excel Courses, this one was by far the best and most helpful. Covers all aspects of Excel without assuming one knows anything going into it. I even learned new tricks to teach a few of the "Excel experts" around my office! I would recommend it to those with no Excel experience or even ones that have experience. Easy to follow along, pacing of the instructors was good, and all explanations and instructions were clear.
Steven
August 23, 2019
This course did an excellent job of teaching me how to get the most out of Excel. The first part of the course demonstrated how to use just about every aspect of Excel. The advanced training was good, even though I don't have a use for a lot of it. There are 2 instructors, one for the basic and one for the advanced training. They were both very thorough and knowledgeable about Excel. There are example files so you can follow along with the lectures. A very good course that taught me how to get the most out of Excel. Highly recommend this course.

Charts

Price

Master Excel 2019 PC/Mac with Beginner to Advanced Courses - Price chart

Rating

Master Excel 2019 PC/Mac with Beginner to Advanced Courses - Ratings chart

Enrollment distribution

Master Excel 2019 PC/Mac with Beginner to Advanced Courses - Distribution chart

Related Topics

2256084
udemy ID
3/5/2019
course created date
5/5/2019
course indexed date
Bot
course submited by