Start Your Excel Journey with Excel 2019/365 for Beginners

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course 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:

  1. 7-hours of video tutorials

  2. 95 individual video lectures

  3. Exercise files to practice what you learned

  4. Demo files used by the trainer

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

Expected Outcomes

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