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!

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

Expected Outcomes

  1. 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 Show more Show less 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 Show more Show less Course content 22 sections • 102 lectures • 10h 40m total length Expand all sections Intro to Excel 9 lectures • 27min Intro to Excel Preview 01:00 WATCH ME: Essential Information for a Successful Training Experience 02:03 Course Exercise Files 00:23 Downloadable course transcripts 00:15 What's New In Excel 2019 Preview 07:52 Course Overview Preview 01:16 Overview of the Excel window 08:25 Mouse-Features 03:12 Back Stage View 02:37 Section 1 Quiz 4 questions Creating Workbooks 6 lectures • 25min Entering Text and Numbers 04:32 Creating Basic Formulas Preview 06:49 Relative References Preview 03:01 Order of Operations 04:48 Working with Ranges 04:14 Module 2 - Practice Exercise 01:35 Section 2 Quiz 3 questions Saving Workbooks 3 lectures • 9min Working with the Save and Save As Commands 04:34 File Extensions, Share, Export and Publish Files 03:44 Module 3 - Practice Exercise 00:59 Section 3 Quiz 1 question Navigating Workbooks 5 lectures • 21min Opening a File 05:33 Working with Larger Files 05:34 Freeze Panes Option 03:16 Split Screen Option 03:22 Module 4 - Practice Exercise 02:50 Section 4 Quiz 1 question Page Setup & Print Options 7 lectures • 33min Headers and Footers 07:23 Print Titles 02:52 Comments 05:23 Page Setup Options 07:30 Fit to Print on One Page 03:59 Printing Workbooks 03:55 Module 5 - Practice Exercise 01:53 Section 5 Quiz 3 questions Working with Rows, Columns and Cells 3 lectures • 11min Adding and deleting rows columns and cells 06:12 Changing Column and-Row Widths 03:45 Module 6 - Practice Exercise 01:11 Section 6 Quiz 2 questions Moving Data 3 lectures • 14min Cut, Copy and Paste 07:07 Copying Formulas 05:09 Module 7 - Practice Exercise 01:20 Section 7 Quiz 1 question Formulas & Functions 5 lectures • 25min Overview of Formulas 02:48 Create Formulas Using Functions Part 1 10:04 Create Formulas Using Functions Part 2 05:24 Absolute Values 05:16 Module 8 - Practice Exercise 01:20 Section 8 Quiz 4 questions Working with Sheets 4 lectures • 16min Adding Deleting and Renaming Sheets 04:09 Additional Sheet Tab Options 05:19 3 Dimensional Formulas 05:28 Module 9 - Practice Exercise 01:31 Section 9 Quiz 3 questions Formatting Worksheets 10 lectures • 1hr 2min Formatting Cells Part 1 10:04 Formatting Cells Part 2 03:38 Formatting Numbers 09:24 Borders and Shading 07:08 Format as Table 06:07 Using Styles 03:49 Using Format Painter 04:29 Protecting Sheets 09:01 Fill Handle and Custom Lists 07:17 Module 10 - Practice Exercise 01:10 Section 10 Quiz 2 questions 12 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,739 Students 171 Courses Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781aa2c2e4f06f1',m:'8aad50d5827aabc8c223111d907e5b578c042253-1627848153-1800-AXua0fzGgeSc/eAeRHc1qojpFgh55+obDAB4zybi8TCl12/5Pbn8oERfiA+qosOcyryEvDWVfvezFzKjQ43gXtfQavo9xhV27BJb26SgL/S0BbIFiqZt8k4TuXbI/u9Y5vtQROBZ0S1K0/Oi4ygYYPgpUelAwL7yWBw2Jn1eDitP',s:[0x5d2a9ce56c,0x50eaaecfb4],}})();
  2. 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 Show more Show less 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 Show more Show less Course content 22 sections • 102 lectures • 10h 40m total length Expand all sections Intro to Excel 9 lectures • 27min Intro to Excel Preview 01:00 WATCH ME: Essential Information for a Successful Training Experience 02:03 Course Exercise Files 00:23 Downloadable course transcripts 00:15 What's New In Excel 2019 Preview 07:52 Course Overview Preview 01:16 Overview of the Excel window 08:25 Mouse-Features 03:12 Back Stage View 02:37 Section 1 Quiz 4 questions Creating Workbooks 6 lectures • 25min Entering Text and Numbers 04:32 Creating Basic Formulas Preview 06:49 Relative References Preview 03:01 Order of Operations 04:48 Working with Ranges 04:14 Module 2 - Practice Exercise 01:35 Section 2 Quiz 3 questions Saving Workbooks 3 lectures • 9min Working with the Save and Save As Commands 04:34 File Extensions, Share, Export and Publish Files 03:44 Module 3 - Practice Exercise 00:59 Section 3 Quiz 1 question Navigating Workbooks 5 lectures • 21min Opening a File 05:33 Working with Larger Files 05:34 Freeze Panes Option 03:16 Split Screen Option 03:22 Module 4 - Practice Exercise 02:50 Section 4 Quiz 1 question Page Setup & Print Options 7 lectures • 33min Headers and Footers 07:23 Print Titles 02:52 Comments 05:23 Page Setup Options 07:30 Fit to Print on One Page 03:59 Printing Workbooks 03:55 Module 5 - Practice Exercise 01:53 Section 5 Quiz 3 questions Working with Rows, Columns and Cells 3 lectures • 11min Adding and deleting rows columns and cells 06:12 Changing Column and-Row Widths 03:45 Module 6 - Practice Exercise 01:11 Section 6 Quiz 2 questions Moving Data 3 lectures • 14min Cut, Copy and Paste 07:07 Copying Formulas 05:09 Module 7 - Practice Exercise 01:20 Section 7 Quiz 1 question Formulas & Functions 5 lectures • 25min Overview of Formulas 02:48 Create Formulas Using Functions Part 1 10:04 Create Formulas Using Functions Part 2 05:24 Absolute Values 05:16 Module 8 - Practice Exercise 01:20 Section 8 Quiz 4 questions Working with Sheets 4 lectures • 16min Adding Deleting and Renaming Sheets 04:09 Additional Sheet Tab Options 05:19 3 Dimensional Formulas 05:28 Module 9 - Practice Exercise 01:31 Section 9 Quiz 3 questions Formatting Worksheets 10 lectures • 1hr 2min Formatting Cells Part 1 10:04 Formatting Cells Part 2 03:38 Formatting Numbers 09:24 Borders and Shading 07:08 Format as Table 06:07 Using Styles 03:49 Using Format Painter 04:29 Protecting Sheets 09:01 Fill Handle and Custom Lists 07:17 Module 10 - Practice Exercise 01:10 Section 10 Quiz 2 questions 12 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,739 Students 171 Courses Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781aa2c2e4f06f1',m:'8aad50d5827aabc8c223111d907e5b578c042253-1627848153-1800-AXua0fzGgeSc/eAeRHc1qojpFgh55+obDAB4zybi8TCl12/5Pbn8oERfiA+qosOcyryEvDWVfvezFzKjQ43gXtfQavo9xhV27BJb26SgL/S0BbIFiqZt8k4TuXbI/u9Y5vtQROBZ0S1K0/Oi4ygYYPgpUelAwL7yWBw2Jn1eDitP',s:[0x5d2a9ce56c,0x50eaaecfb4],}})();
  3. 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 Show more Show less 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 Show more Show less Course content 22 sections • 102 lectures • 10h 40m total length Expand all sections Intro to Excel 9 lectures • 27min Intro to Excel Preview 01:00 WATCH ME: Essential Information for a Successful Training Experience 02:03 Course Exercise Files 00:23 Downloadable course transcripts 00:15 What's New In Excel 2019 Preview 07:52 Course Overview Preview 01:16 Overview of the Excel window 08:25 Mouse-Features 03:12 Back Stage View 02:37 Section 1 Quiz 4 questions Creating Workbooks 6 lectures • 25min Entering Text and Numbers 04:32 Creating Basic Formulas Preview 06:49 Relative References Preview 03:01 Order of Operations 04:48 Working with Ranges 04:14 Module 2 - Practice Exercise 01:35 Section 2 Quiz 3 questions Saving Workbooks 3 lectures • 9min Working with the Save and Save As Commands 04:34 File Extensions, Share, Export and Publish Files 03:44 Module 3 - Practice Exercise 00:59 Section 3 Quiz 1 question Navigating Workbooks 5 lectures • 21min Opening a File 05:33 Working with Larger Files 05:34 Freeze Panes Option 03:16 Split Screen Option 03:22 Module 4 - Practice Exercise 02:50 Section 4 Quiz 1 question Page Setup & Print Options 7 lectures • 33min Headers and Footers 07:23 Print Titles 02:52 Comments 05:23 Page Setup Options 07:30 Fit to Print on One Page 03:59 Printing Workbooks 03:55 Module 5 - Practice Exercise 01:53 Section 5 Quiz 3 questions Working with Rows, Columns and Cells 3 lectures • 11min Adding and deleting rows columns and cells 06:12 Changing Column and-Row Widths 03:45 Module 6 - Practice Exercise 01:11 Section 6 Quiz 2 questions Moving Data 3 lectures • 14min Cut, Copy and Paste 07:07 Copying Formulas 05:09 Module 7 - Practice Exercise 01:20 Section 7 Quiz 1 question Formulas & Functions 5 lectures • 25min Overview of Formulas 02:48 Create Formulas Using Functions Part 1 10:04 Create Formulas Using Functions Part 2 05:24 Absolute Values 05:16 Module 8 - Practice Exercise 01:20 Section 8 Quiz 4 questions Working with Sheets 4 lectures • 16min Adding Deleting and Renaming Sheets 04:09 Additional Sheet Tab Options 05:19 3 Dimensional Formulas 05:28 Module 9 - Practice Exercise 01:31 Section 9 Quiz 3 questions Formatting Worksheets 10 lectures • 1hr 2min Formatting Cells Part 1 10:04 Formatting Cells Part 2 03:38 Formatting Numbers 09:24 Borders and Shading 07:08 Format as Table 06:07 Using Styles 03:49 Using Format Painter 04:29 Protecting Sheets 09:01 Fill Handle and Custom Lists 07:17 Module 10 - Practice Exercise 01:10 Section 10 Quiz 2 questions 12 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,739 Students 171 Courses Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781aa2c2e4f06f1',m:'8aad50d5827aabc8c223111d907e5b578c042253-1627848153-1800-AXua0fzGgeSc/eAeRHc1qojpFgh55+obDAB4zybi8TCl12/5Pbn8oERfiA+qosOcyryEvDWVfvezFzKjQ43gXtfQavo9xhV27BJb26SgL/S0BbIFiqZt8k4TuXbI/u9Y5vtQROBZ0S1K0/Oi4ygYYPgpUelAwL7yWBw2Jn1eDitP',s:[0x5d2a9ce56c,0x50eaaecfb4],}})();
  4. 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 Show more Show less 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 Show more Show less Course content 22 sections • 102 lectures • 10h 40m total length Expand all sections Intro to Excel 9 lectures • 27min Intro to Excel Preview 01:00 WATCH ME: Essential Information for a Successful Training Experience 02:03 Course Exercise Files 00:23 Downloadable course transcripts 00:15 What's New In Excel 2019 Preview 07:52 Course Overview Preview 01:16 Overview of the Excel window 08:25 Mouse-Features 03:12 Back Stage View 02:37 Section 1 Quiz 4 questions Creating Workbooks 6 lectures • 25min Entering Text and Numbers 04:32 Creating Basic Formulas Preview 06:49 Relative References Preview 03:01 Order of Operations 04:48 Working with Ranges 04:14 Module 2 - Practice Exercise 01:35 Section 2 Quiz 3 questions Saving Workbooks 3 lectures • 9min Working with the Save and Save As Commands 04:34 File Extensions, Share, Export and Publish Files 03:44 Module 3 - Practice Exercise 00:59 Section 3 Quiz 1 question Navigating Workbooks 5 lectures • 21min Opening a File 05:33 Working with Larger Files 05:34 Freeze Panes Option 03:16 Split Screen Option 03:22 Module 4 - Practice Exercise 02:50 Section 4 Quiz 1 question Page Setup & Print Options 7 lectures • 33min Headers and Footers 07:23 Print Titles 02:52 Comments 05:23 Page Setup Options 07:30 Fit to Print on One Page 03:59 Printing Workbooks 03:55 Module 5 - Practice Exercise 01:53 Section 5 Quiz 3 questions Working with Rows, Columns and Cells 3 lectures • 11min Adding and deleting rows columns and cells 06:12 Changing Column and-Row Widths 03:45 Module 6 - Practice Exercise 01:11 Section 6 Quiz 2 questions Moving Data 3 lectures • 14min Cut, Copy and Paste 07:07 Copying Formulas 05:09 Module 7 - Practice Exercise 01:20 Section 7 Quiz 1 question Formulas & Functions 5 lectures • 25min Overview of Formulas 02:48 Create Formulas Using Functions Part 1 10:04 Create Formulas Using Functions Part 2 05:24 Absolute Values 05:16 Module 8 - Practice Exercise 01:20 Section 8 Quiz 4 questions Working with Sheets 4 lectures • 16min Adding Deleting and Renaming Sheets 04:09 Additional Sheet Tab Options 05:19 3 Dimensional Formulas 05:28 Module 9 - Practice Exercise 01:31 Section 9 Quiz 3 questions Formatting Worksheets 10 lectures • 1hr 2min Formatting Cells Part 1 10:04 Formatting Cells Part 2 03:38 Formatting Numbers 09:24 Borders and Shading 07:08 Format as Table 06:07 Using Styles 03:49 Using Format Painter 04:29 Protecting Sheets 09:01 Fill Handle and Custom Lists 07:17 Module 10 - Practice Exercise 01:10 Section 10 Quiz 2 questions 12 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,739 Students 171 Courses Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781aa2c2e4f06f1',m:'8aad50d5827aabc8c223111d907e5b578c042253-1627848153-1800-AXua0fzGgeSc/eAeRHc1qojpFgh55+obDAB4zybi8TCl12/5Pbn8oERfiA+qosOcyryEvDWVfvezFzKjQ43gXtfQavo9xhV27BJb26SgL/S0BbIFiqZt8k4TuXbI/u9Y5vtQROBZ0S1K0/Oi4ygYYPgpUelAwL7yWBw2Jn1eDitP',s:[0x5d2a9ce56c,0x50eaaecfb4],}})();
  5. 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 Show more Show less 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 Show more Show less Course content 22 sections • 102 lectures • 10h 40m total length Expand all sections Intro to Excel 9 lectures • 27min Intro to Excel Preview 01:00 WATCH ME: Essential Information for a Successful Training Experience 02:03 Course Exercise Files 00:23 Downloadable course transcripts 00:15 What's New In Excel 2019 Preview 07:52 Course Overview Preview 01:16 Overview of the Excel window 08:25 Mouse-Features 03:12 Back Stage View 02:37 Section 1 Quiz 4 questions Creating Workbooks 6 lectures • 25min Entering Text and Numbers 04:32 Creating Basic Formulas Preview 06:49 Relative References Preview 03:01 Order of Operations 04:48 Working with Ranges 04:14 Module 2 - Practice Exercise 01:35 Section 2 Quiz 3 questions Saving Workbooks 3 lectures • 9min Working with the Save and Save As Commands 04:34 File Extensions, Share, Export and Publish Files 03:44 Module 3 - Practice Exercise 00:59 Section 3 Quiz 1 question Navigating Workbooks 5 lectures • 21min Opening a File 05:33 Working with Larger Files 05:34 Freeze Panes Option 03:16 Split Screen Option 03:22 Module 4 - Practice Exercise 02:50 Section 4 Quiz 1 question Page Setup & Print Options 7 lectures • 33min Headers and Footers 07:23 Print Titles 02:52 Comments 05:23 Page Setup Options 07:30 Fit to Print on One Page 03:59 Printing Workbooks 03:55 Module 5 - Practice Exercise 01:53 Section 5 Quiz 3 questions Working with Rows, Columns and Cells 3 lectures • 11min Adding and deleting rows columns and cells 06:12 Changing Column and-Row Widths 03:45 Module 6 - Practice Exercise 01:11 Section 6 Quiz 2 questions Moving Data 3 lectures • 14min Cut, Copy and Paste 07:07 Copying Formulas 05:09 Module 7 - Practice Exercise 01:20 Section 7 Quiz 1 question Formulas & Functions 5 lectures • 25min Overview of Formulas 02:48 Create Formulas Using Functions Part 1 10:04 Create Formulas Using Functions Part 2 05:24 Absolute Values 05:16 Module 8 - Practice Exercise 01:20 Section 8 Quiz 4 questions Working with Sheets 4 lectures • 16min Adding Deleting and Renaming Sheets 04:09 Additional Sheet Tab Options 05:19 3 Dimensional Formulas 05:28 Module 9 - Practice Exercise 01:31 Section 9 Quiz 3 questions Formatting Worksheets 10 lectures • 1hr 2min Formatting Cells Part 1 10:04 Formatting Cells Part 2 03:38 Formatting Numbers 09:24 Borders and Shading 07:08 Format as Table 06:07 Using Styles 03:49 Using Format Painter 04:29 Protecting Sheets 09:01 Fill Handle and Custom Lists 07:17 Module 10 - Practice Exercise 01:10 Section 10 Quiz 2 questions 12 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,739 Students 171 Courses Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781aa2c2e4f06f1',m:'8aad50d5827aabc8c223111d907e5b578c042253-1627848153-1800-AXua0fzGgeSc/eAeRHc1qojpFgh55+obDAB4zybi8TCl12/5Pbn8oERfiA+qosOcyryEvDWVfvezFzKjQ43gXtfQavo9xhV27BJb26SgL/S0BbIFiqZt8k4TuXbI/u9Y5vtQROBZ0S1K0/Oi4ygYYPgpUelAwL7yWBw2Jn1eDitP',s:[0x5d2a9ce56c,0x50eaaecfb4],}})();
  6. 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 Show more Show less 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 Show more Show less Course content 22 sections • 102 lectures • 10h 40m total length Expand all sections Intro to Excel 9 lectures • 27min Intro to Excel Preview 01:00 WATCH ME: Essential Information for a Successful Training Experience 02:03 Course Exercise Files 00:23 Downloadable course transcripts 00:15 What's New In Excel 2019 Preview 07:52 Course Overview Preview 01:16 Overview of the Excel window 08:25 Mouse-Features 03:12 Back Stage View 02:37 Section 1 Quiz 4 questions Creating Workbooks 6 lectures • 25min Entering Text and Numbers 04:32 Creating Basic Formulas Preview 06:49 Relative References Preview 03:01 Order of Operations 04:48 Working with Ranges 04:14 Module 2 - Practice Exercise 01:35 Section 2 Quiz 3 questions Saving Workbooks 3 lectures • 9min Working with the Save and Save As Commands 04:34 File Extensions, Share, Export and Publish Files 03:44 Module 3 - Practice Exercise 00:59 Section 3 Quiz 1 question Navigating Workbooks 5 lectures • 21min Opening a File 05:33 Working with Larger Files 05:34 Freeze Panes Option 03:16 Split Screen Option 03:22 Module 4 - Practice Exercise 02:50 Section 4 Quiz 1 question Page Setup & Print Options 7 lectures • 33min Headers and Footers 07:23 Print Titles 02:52 Comments 05:23 Page Setup Options 07:30 Fit to Print on One Page 03:59 Printing Workbooks 03:55 Module 5 - Practice Exercise 01:53 Section 5 Quiz 3 questions Working with Rows, Columns and Cells 3 lectures • 11min Adding and deleting rows columns and cells 06:12 Changing Column and-Row Widths 03:45 Module 6 - Practice Exercise 01:11 Section 6 Quiz 2 questions Moving Data 3 lectures • 14min Cut, Copy and Paste 07:07 Copying Formulas 05:09 Module 7 - Practice Exercise 01:20 Section 7 Quiz 1 question Formulas & Functions 5 lectures • 25min Overview of Formulas 02:48 Create Formulas Using Functions Part 1 10:04 Create Formulas Using Functions Part 2 05:24 Absolute Values 05:16 Module 8 - Practice Exercise 01:20 Section 8 Quiz 4 questions Working with Sheets 4 lectures • 16min Adding Deleting and Renaming Sheets 04:09 Additional Sheet Tab Options 05:19 3 Dimensional Formulas 05:28 Module 9 - Practice Exercise 01:31 Section 9 Quiz 3 questions Formatting Worksheets 10 lectures • 1hr 2min Formatting Cells Part 1 10:04 Formatting Cells Part 2 03:38 Formatting Numbers 09:24 Borders and Shading 07:08 Format as Table 06:07 Using Styles 03:49 Using Format Painter 04:29 Protecting Sheets 09:01 Fill Handle and Custom Lists 07:17 Module 10 - Practice Exercise 01:10 Section 10 Quiz 2 questions 12 more sections Instructor Simon Sez IT 490,000+ Students | Wordwide Use 180 Countries |150+ Courses 4.4 Instructor Rating 54,023 Reviews 507,739 Students 171 Courses Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781aa2c2e4f06f1',m:'8aad50d5827aabc8c223111d907e5b578c042253-1627848153-1800-AXua0fzGgeSc/eAeRHc1qojpFgh55+obDAB4zybi8TCl12/5Pbn8oERfiA+qosOcyryEvDWVfvezFzKjQ43gXtfQavo9xhV27BJb26SgL/S0BbIFiqZt8k4TuXbI/u9Y5vtQROBZ0S1K0/Oi4ygYYPgpUelAwL7yWBw2Jn1eDitP',s:[0x5d2a9ce56c,0x50eaaecfb4],}})();
  7. 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 Show more Show less 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 Show more Show less Course content 22 sections • 102 lectures • 10h 40m total length Expand all sections Intro to Excel 9 lectures • 27min Intro to Excel Preview 01:00 WATCH ME: Essential Information for a Successful Training Experience 02:03 Course Exercise Files 00:23 Downloadable course transcripts 00:15 What's New In Excel 2019 Preview 07:52 Course Overview Preview 01:16 Overview of the Excel window 08:25 Mouse-Features 03:12 Back Stage View 02:37 Section 1 Quiz 4 questions Creating Workbooks 6 lectures • 25min Entering Text and Numbers 04:32 Creating Basic Formulas Preview 06:49 Relative References Preview 03:01 Order