MS Office; Excel, Word, Access & PowerPoint 2019 - 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**

Learn Excel, PowerPoint, Access and Word 2019 with this tremendous value 4-course bundle from Office experts Simon Sez IT.

Microsoft Office remains the go-to tool for the modern worker, yet so many workers don’t utilize its full potential.

We’re here to make sure you aren’t one of those people.

In this Microsoft Office Beginners bundle, we make the four essential MS Office programs (Excel, Word, PowerPoint and Access) simple to understand. This bundle includes 4, full-length courses to help you achieve your goals.


What's included?

Excel 2019

  • 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

PowerPoint 2019

  • How to navigate around PowerPoint

  • Presentation dos and don'ts

  • Text and bullet edition options

  • How to use graphics, images, objects and shapes

  • Using SmartArt

  • Working with Charts and Graphs

  • How to utilize Master Slides and just how much time this could save you

  • How to add audio and video to a presentation

  • All about transitions between slides

  • Animation, the animation pane and motion paths

  • Setting your slideshow options

  • Presentation preparation and delivery

  • The backstage area of PowerPoint including printing a presentation

Word 2019

  • How to get started with Word 2019

  • Word 2019 basics including navigation, editing and saving

  • Character formatting in Word including Format Painter and AutoCorrect

  • How to properly work with bullets and numbering in Microsoft Word

  • All about formatting paragraphs and managing lists

  • Working with Tables in Word including formatting, converting data and formulas

  • Page appearance including page-breaks, watermarks and styles

  • All about Sectioning a document

  • Inserting graphics, pictures, shapes, icons and 3d models (new for 2019)

  • How to work with envelopes and labels

  • All about mail-merge and operating Word at scale

  • How to create an Index or Contents page

  • Reviewing and Printing in Word and Page Setup

  • Protecting a Word document and basic macros in Word

Microsoft Access

  • Where to start in Microsoft Access and whether to use a template or not

  • How to modify Access to suit your needs

  • All about importing data and the datasheet view

  • How tables work in Access and how to create relationships between them

  • Creating forms and sub-forms that feed data into your tables

  • How to run queries in Access

  • Setting up validations and calculations using expressions in Access

  • Printing from Access

  • To start to use macros and Modal Dialog

  • The basics of the Access web app

  • Exporting and reporting in Access

***Exercise and demo files included***


This bundle includes:

  1. 29+ hours of video tutorials

  2. 300+ individual video lectures

  3. Exercise files to practice what you learned

  4. Certificate of completion


Here’s what our students are saying…

"Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb..... I understood every lesson in the course."

- Yunesh Garusinghe

"I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you."

- Cavin Macwan

"Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!"

- Coreen Teoh


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:

  • Anyone new to Microsoft Office or upgrading from a previous version

Expected Outcomes

  1. Learn the essential Microsoft Office Skills in this four-course bundle: Excel, Word, PowerPoint and Access Learn practical methods to backup and recover your Excel spreadsheets and never lose data. Effectively use autofill and flashfill so you are more productive in Microsoft Excel. Discover the essentials of using formulas and functions in Excel Discover how to create stunning charts and graphs in Excel Learn practical methods to sort and filter your data in Excel Discover new features in PowerPoint 2019 including Icons and 3D Models Learn how to insert shapes, graphics and pictures to add some "zing" to your PowerPoint Add charts, graphs and tables to your PowerPoint presentation information in a non-text format Wow your audience by adding animations, audio and video to PowerPoint Discover practical tips to present your PowerPoint presentation to your audience Learn time saving techniques including how to copy slides, and exporting your presentation Master the most common uses of Microsoft Word Learn Word tools including using columns, indents, footers, borders and watermarks. How to create a mail merge in Microsoft Word Learn how to correctly Print envelopes and labels in Word Learn to protect your Word document from changes Insert professional pictures and graphics in your Word document Make your Word documents look amazing by inserting and editing tables Sorting information and running queries in Access Navigating the Access 2019 interface Discover how to into import data from Excel in Access Learn Queries, use validations, how to create and print reports in Access How to compact, repair and backup your Access database How to create a linked table in Access Show more Show less Requirements Excel, Word, PowerPoint and Access installed on your machine. Preferably Office 2019 or Office 365 Description **This course includes practice exercises and LIFETIME access** Learn Excel, PowerPoint, Access and Word 2019 with this tremendous value 4-course bundle from Office experts Simon Sez IT. Microsoft Office remains the go-to tool for the modern worker, yet so many workers don’t utilize its full potential. We’re here to make sure you aren’t one of those people. In this Microsoft Office Beginners bundle, we make the four essential MS Office programs (Excel, Word, PowerPoint and Access) simple to understand. This bundle includes 4, full-length courses to help you achieve your goals. What's included? Excel 2019 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 PowerPoint 2019 How to navigate around PowerPoint Presentation dos and don'ts Text and bullet edition options How to use graphics, images, objects and shapes Using SmartArt Working with Charts and Graphs How to utilize Master Slides and just how much time this could save you How to add audio and video to a presentation All about transitions between slides Animation, the animation pane and motion paths Setting your slideshow options Presentation preparation and delivery The backstage area of PowerPoint including printing a presentation Word 2019 How to get started with Word 2019 Word 2019 basics including navigation, editing and saving Character formatting in Word including Format Painter and AutoCorrect How to properly work with bullets and numbering in Microsoft Word All about formatting paragraphs and managing lists Working with Tables in Word including formatting, converting data and formulas Page appearance including page-breaks, watermarks and styles All about Sectioning a document Inserting graphics, pictures, shapes, icons and 3d models (new for 2019) How to work with envelopes and labels All about mail-merge and operating Word at scale How to create an Index or Contents page Reviewing and Printing in Word and Page Setup Protecting a Word document and basic macros in Word Microsoft Access Where to start in Microsoft Access and whether to use a template or not How to modify Access to suit your needs All about importing data and the datasheet view How tables work in Access and how to create relationships between them Creating forms and sub-forms that feed data into your tables How to run queries in Access Setting up validations and calculations using expressions in Access Printing from Access To start to use macros and Modal Dialog The basics of the Access web app Exporting and reporting in Access ***Exercise and demo files included*** This bundle includes: 29+ hours of video tutorials 300+ individual video lectures Exercise files to practice what you learned Certificate of completion Here’s what our students are saying… "Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb..... I understood every lesson in the course." - Yunesh Garusinghe "I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you." - Cavin Macwan "Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!" - Coreen Teoh 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: Anyone new to Microsoft Office or upgrading from a previous version Show more Show less Course content 81 sections • 333 lectures • 33h 42m total length Expand all sections Excel 2019: Introduction 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 Quiz 4 questions Excel 2019 Beginner: Creating Workbooks 6 lectures • 25min Entering Text and Numbers 04:32 Creating Basic Formulas Preview 06:49 Relative References 03:01 Order of Operations 04:48 Working with Ranges 04:14 Module 2 - Practice Exercise 01:35 Section Quiz 3 questions Excel 2019 Beginner: 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 Quiz 1 question Excel 2019 Beginner: 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 Quiz 1 question Excel 2019 Beginner: 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 Quiz 3 questions Excel 2019 Beginners: 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 Quiz 2 questions Excel 2019 Beginners: Moving Data 3 lectures • 14min Cut, Copy and Paste 07:07 Copying Formulas 05:09 Module 7 - Practice Exercise 01:20 Section Quiz 1 question Excel 2019 Beginners: 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 Quiz 4 questions Excel 2019 Beginner: Working with Sheets 5 lectures • 21min Working with the Save and Save As Commands 04:34 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 Quiz 3 questions Excel 2019 Beginner: 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 Quiz 2 questions 71 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:'6781134add5f0089',m:'ad1b5d1957bd9f89ccd4bccb1d6831adb1855063-1627841975-1800-AfAqaDPD2vTpBy34fj/e7pQY9XvjH+43M40KTQSfLrTuZn7XuM0q7iWSMZd+ecX5Td5iLbI8JHPyka88BfvyN7iVIUaiv7LpnT+t+fT3ioClwWADS8KSflxSokhOwR6MrMdkpMLDrQQbSItsabLwknoJXsqEoIo4COqAv/dEuz6KSd/U+Nc9y+TUYbNYZXu57g==',s:[0xd1820fabb9,0x21ba06422d],}})();
  2. Learn practical methods to backup and recover your Excel spreadsheets and never lose data. Effectively use autofill and flashfill so you are more productive in Microsoft Excel. Discover the essentials of using formulas and functions in Excel Discover how to create stunning charts and graphs in Excel Learn practical methods to sort and filter your data in Excel Discover new features in PowerPoint 2019 including Icons and 3D Models Learn how to insert shapes, graphics and pictures to add some "zing" to your PowerPoint Add charts, graphs and tables to your PowerPoint presentation information in a non-text format Wow your audience by adding animations, audio and video to PowerPoint Discover practical tips to present your PowerPoint presentation to your audience Learn time saving techniques including how to copy slides, and exporting your presentation Master the most common uses of Microsoft Word Learn Word tools including using columns, indents, footers, borders and watermarks. How to create a mail merge in Microsoft Word Learn how to correctly Print envelopes and labels in Word Learn to protect your Word document from changes Insert professional pictures and graphics in your Word document Make your Word documents look amazing by inserting and editing tables Sorting information and running queries in Access Navigating the Access 2019 interface Discover how to into import data from Excel in Access Learn Queries, use validations, how to create and print reports in Access How to compact, repair and backup your Access database How to create a linked table in Access Show more Show less Requirements Excel, Word, PowerPoint and Access installed on your machine. Preferably Office 2019 or Office 365 Description **This course includes practice exercises and LIFETIME access** Learn Excel, PowerPoint, Access and Word 2019 with this tremendous value 4-course bundle from Office experts Simon Sez IT. Microsoft Office remains the go-to tool for the modern worker, yet so many workers don’t utilize its full potential. We’re here to make sure you aren’t one of those people. In this Microsoft Office Beginners bundle, we make the four essential MS Office programs (Excel, Word, PowerPoint and Access) simple to understand. This bundle includes 4, full-length courses to help you achieve your goals. What's included? Excel 2019 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 PowerPoint 2019 How to navigate around PowerPoint Presentation dos and don'ts Text and bullet edition options How to use graphics, images, objects and shapes Using SmartArt Working with Charts and Graphs How to utilize Master Slides and just how much time this could save you How to add audio and video to a presentation All about transitions between slides Animation, the animation pane and motion paths Setting your slideshow options Presentation preparation and delivery The backstage area of PowerPoint including printing a presentation Word 2019 How to get started with Word 2019 Word 2019 basics including navigation, editing and saving Character formatting in Word including Format Painter and AutoCorrect How to properly work with bullets and numbering in Microsoft Word All about formatting paragraphs and managing lists Working with Tables in Word including formatting, converting data and formulas Page appearance including page-breaks, watermarks and styles All about Sectioning a document Inserting graphics, pictures, shapes, icons and 3d models (new for 2019) How to work with envelopes and labels All about mail-merge and operating Word at scale How to create an Index or Contents page Reviewing and Printing in Word and Page Setup Protecting a Word document and basic macros in Word Microsoft Access Where to start in Microsoft Access and whether to use a template or not How to modify Access to suit your needs All about importing data and the datasheet view How tables work in Access and how to create relationships between them Creating forms and sub-forms that feed data into your tables How to run queries in Access Setting up validations and calculations using expressions in Access Printing from Access To start to use macros and Modal Dialog The basics of the Access web app Exporting and reporting in Access ***Exercise and demo files included*** This bundle includes: 29+ hours of video tutorials 300+ individual video lectures Exercise files to practice what you learned Certificate of completion Here’s what our students are saying… "Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb..... I understood every lesson in the course." - Yunesh Garusinghe "I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you." - Cavin Macwan "Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!" - Coreen Teoh 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: Anyone new to Microsoft Office or upgrading from a previous version Show more Show less Course content 81 sections • 333 lectures • 33h 42m total length Expand all sections Excel 2019: Introduction 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 Quiz 4 questions Excel 2019 Beginner: Creating Workbooks 6 lectures • 25min Entering Text and Numbers 04:32 Creating Basic Formulas Preview 06:49 Relative References 03:01 Order of Operations 04:48 Working with Ranges 04:14 Module 2 - Practice Exercise 01:35 Section Quiz 3 questions Excel 2019 Beginner: 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 Quiz 1 question Excel 2019 Beginner: 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 Quiz 1 question Excel 2019 Beginner: 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 Quiz 3 questions Excel 2019 Beginners: 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 Quiz 2 questions Excel 2019 Beginners: Moving Data 3 lectures • 14min Cut, Copy and Paste 07:07 Copying Formulas 05:09 Module 7 - Practice Exercise 01:20 Section Quiz 1 question Excel 2019 Beginners: 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 Quiz 4 questions Excel 2019 Beginner: Working with Sheets 5 lectures • 21min Working with the Save and Save As Commands 04:34 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 Quiz 3 questions Excel 2019 Beginner: 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 Quiz 2 questions 71 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:'6781134add5f0089',m:'ad1b5d1957bd9f89ccd4bccb1d6831adb1855063-1627841975-1800-AfAqaDPD2vTpBy34fj/e7pQY9XvjH+43M40KTQSfLrTuZn7XuM0q7iWSMZd+ecX5Td5iLbI8JHPyka88BfvyN7iVIUaiv7LpnT+t+fT3ioClwWADS8KSflxSokhOwR6MrMdkpMLDrQQbSItsabLwknoJXsqEoIo4COqAv/dEuz6KSd/U+Nc9y+TUYbNYZXu57g==',s:[0xd1820fabb9,0x21ba06422d],}})();
  3. Effectively use autofill and flashfill so you are more productive in Microsoft Excel. Discover the essentials of using formulas and functions in Excel Discover how to create stunning charts and graphs in Excel Learn practical methods to sort and filter your data in Excel Discover new features in PowerPoint 2019 including Icons and 3D Models Learn how to insert shapes, graphics and pictures to add some "zing" to your PowerPoint Add charts, graphs and tables to your PowerPoint presentation information in a non-text format Wow your audience by adding animations, audio and video to PowerPoint Discover practical tips to present your PowerPoint presentation to your audience Learn time saving techniques including how to copy slides, and exporting your presentation Master the most common uses of Microsoft Word Learn Word tools including using columns, indents, footers, borders and watermarks. How to create a mail merge in Microsoft Word Learn how to correctly Print envelopes and labels in Word Learn to protect your Word document from changes Insert professional pictures and graphics in your Word document Make your Word documents look amazing by inserting and editing tables Sorting information and running queries in Access Navigating the Access 2019 interface Discover how to into import data from Excel in Access Learn Queries, use validations, how to create and print reports in Access How to compact, repair and backup your Access database How to create a linked table in Access Show more Show less Requirements Excel, Word, PowerPoint and Access installed on your machine. Preferably Office 2019 or Office 365 Description **This course includes practice exercises and LIFETIME access** Learn Excel, PowerPoint, Access and Word 2019 with this tremendous value 4-course bundle from Office experts Simon Sez IT. Microsoft Office remains the go-to tool for the modern worker, yet so many workers don’t utilize its full potential. We’re here to make sure you aren’t one of those people. In this Microsoft Office Beginners bundle, we make the four essential MS Office programs (Excel, Word, PowerPoint and Access) simple to understand. This bundle includes 4, full-length courses to help you achieve your goals. What's included? Excel 2019 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 PowerPoint 2019 How to navigate around PowerPoint Presentation dos and don'ts Text and bullet edition options How to use graphics, images, objects and shapes Using SmartArt Working with Charts and Graphs How to utilize Master Slides and just how much time this could save you How to add audio and video to a presentation All about transitions between slides Animation, the animation pane and motion paths Setting your slideshow options Presentation preparation and delivery The backstage area of PowerPoint including printing a presentation Word 2019 How to get started with Word 2019 Word 2019 basics including navigation, editing and saving Character formatting in Word including Format Painter and AutoCorrect How to properly work with bullets and numbering in Microsoft Word All about formatting paragraphs and managing lists Working with Tables in Word including formatting, converting data and formulas Page appearance including page-breaks, watermarks and styles All about Sectioning a document Inserting graphics, pictures, shapes, icons and 3d models (new for 2019) How to work with envelopes and labels All about mail-merge and operating Word at scale How to create an Index or Contents page Reviewing and Printing in Word and Page Setup Protecting a Word document and basic macros in Word Microsoft Access Where to start in Microsoft Access and whether to use a template or not How to modify Access to suit your needs All about importing data and the datasheet view How tables work in Access and how to create relationships between them Creating forms and sub-forms that feed data into your tables How to run queries in Access Setting up validations and calculations using expressions in Access Printing from Access To start to use macros and Modal Dialog The basics of the Access web app Exporting and reporting in Access ***Exercise and demo files included*** This bundle includes: 29+ hours of video tutorials 300+ individual video lectures Exercise files to practice what you learned Certificate of completion Here’s what our students are saying… "Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb..... I understood every lesson in the course." - Yunesh Garusinghe "I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you." - Cavin Macwan "Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!" - Coreen Teoh 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: Anyone new to Microsoft Office or upgrading from a previous version Show more Show less Course content 81 sections • 333 lectures • 33h 42m total length Expand all sections Excel 2019: Introduction 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 Quiz 4 questions Excel 2019 Beginner: Creating Workbooks 6 lectures • 25min Entering Text and Numbers 04:32 Creating Basic Formulas Preview 06:49 Relative References 03:01 Order of Operations 04:48 Working with Ranges 04:14 Module 2 - Practice Exercise 01:35 Section Quiz 3 questions Excel 2019 Beginner: 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 Quiz 1 question Excel 2019 Beginner: 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 Quiz 1 question Excel 2019 Beginner: 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 Quiz 3 questions Excel 2019 Beginners: 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 Quiz 2 questions Excel 2019 Beginners: Moving Data 3 lectures • 14min Cut, Copy and Paste 07:07 Copying Formulas 05:09 Module 7 - Practice Exercise 01:20 Section Quiz 1 question Excel 2019 Beginners: 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 Quiz 4 questions Excel 2019 Beginner: Working with Sheets 5 lectures • 21min Working with the Save and Save As Commands 04:34 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 Quiz 3 questions Excel 2019 Beginner: 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 Quiz 2 questions 71 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:'6781134add5f0089',m:'ad1b5d1957bd9f89ccd4bccb1d6831adb1855063-1627841975-1800-AfAqaDPD2vTpBy34fj/e7pQY9XvjH+43M40KTQSfLrTuZn7XuM0q7iWSMZd+ecX5Td5iLbI8JHPyka88BfvyN7iVIUaiv7LpnT+t+fT3ioClwWADS8KSflxSokhOwR6MrMdkpMLDrQQbSItsabLwknoJXsqEoIo4COqAv/dEuz6KSd/U+Nc9y+TUYbNYZXu57g==',s:[0xd1820fabb9,0x21ba06422d],}})();
  4. Discover the essentials of using formulas and functions in Excel Discover how to create stunning charts and graphs in Excel Learn practical methods to sort and filter your data in Excel Discover new features in PowerPoint 2019 including Icons and 3D Models Learn how to insert shapes, graphics and pictures to add some "zing" to your PowerPoint Add charts, graphs and tables to your PowerPoint presentation information in a non-text format Wow your audience by adding animations, audio and video to PowerPoint Discover practical tips to present your PowerPoint presentation to your audience Learn time saving techniques including how to copy slides, and exporting your presentation Master the most common uses of Microsoft Word Learn Word tools including using columns, indents, footers, borders and watermarks. How to create a mail merge in Microsoft Word Learn how to correctly Print envelopes and labels in Word Learn to protect your Word document from changes Insert professional pictures and graphics in your Word document Make your Word documents look amazing by inserting and editing tables Sorting information and running queries in Access Navigating the Access 2019 interface Discover how to into import data from Excel in Access Learn Queries, use validations, how to create and print reports in Access How to compact, repair and backup your Access database How to create a linked table in Access Show more Show less Requirements Excel, Word, PowerPoint and Access installed on your machine. Preferably Office 2019 or Office 365 Description **This course includes practice exercises and LIFETIME access** Learn Excel, PowerPoint, Access and Word 2019 with this tremendous value 4-course bundle from Office experts Simon Sez IT. Microsoft Office remains the go-to tool for the modern worker, yet so many workers don’t utilize its full potential. We’re here to make sure you aren’t one of those people. In this Microsoft Office Beginners bundle, we make the four essential MS Office programs (Excel, Word, PowerPoint and Access) simple to understand. This bundle includes 4, full-length courses to help you achieve your goals. What's included? Excel 2019 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 PowerPoint 2019 How to navigate around PowerPoint Presentation dos and don'ts Text and bullet edition options How to use graphics, images, objects and shapes Using SmartArt Working with Charts and Graphs How to utilize Master Slides and just how much time this could save you How to add audio and video to a presentation All about transitions between slides Animation, the animation pane and motion paths Setting your slideshow options Presentation preparation and delivery The backstage area of PowerPoint including printing a presentation Word 2019 How to get started with Word 2019 Word 2019 basics including navigation, editing and saving Character formatting in Word including Format Painter and AutoCorrect How to properly work with bullets and numbering in Microsoft Word All about formatting paragraphs and managing lists Working with Tables in Word including formatting, converting data and formulas Page appearance including page-breaks, watermarks and styles All about Sectioning a document Inserting graphics, pictures, shapes, icons and 3d models (new for 2019) How to work with envelopes and labels All about mail-merge and operating Word at scale How to create an Index or Contents page Reviewing and Printing in Word and Page Setup Protecting a Word document and basic macros in Word Microsoft Access Where to start in Microsoft Access and whether to use a template or not How to modify Access to suit your needs All about importing data and the datasheet view How tables work in Access and how to create relationships between them Creating forms and sub-forms that feed data into your tables How to run queries in Access Setting up validations and calculations using expressions in Access Printing from Access To start to use macros and Modal Dialog The basics of the Access web app Exporting and reporting in Access ***Exercise and demo files included*** This bundle includes: 29+ hours of video tutorials 300+ individual video lectures Exercise files to practice what you learned Certificate of completion Here’s what our students are saying… "Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb..... I understood every lesson in the course." - Yunesh Garusinghe "I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you." - Cavin Macwan "Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!" - Coreen Teoh 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: Anyone new to Microsoft Office or upgrading from a previous version Show more Show less Course content 81 sections • 333 lectures • 33h 42m total length Expand all sections Excel 2019: Introduction 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 Quiz 4 questions Excel 2019 Beginner: Creating Workbooks 6 lectures • 25min Entering Text and Numbers 04:32 Creating Basic Formulas Preview 06:49 Relative References 03:01 Order of Operations 04:48 Working with Ranges 04:14 Module 2 - Practice Exercise 01:35 Section Quiz 3 questions Excel 2019 Beginner: 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 Quiz 1 question Excel 2019 Beginner: 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 Quiz 1 question Excel 2019 Beginner: 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 Quiz 3 questions Excel 2019 Beginners: 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 Quiz 2 questions Excel 2019 Beginners: Moving Data 3 lectures • 14min Cut, Copy and Paste 07:07 Copying Formulas 05:09 Module 7 - Practice Exercise 01:20 Section Quiz 1 question Excel 2019 Beginners: 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 Quiz 4 questions Excel 2019 Beginner: Working with Sheets 5 lectures • 21min Working with the Save and Save As Commands 04:34 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 Quiz 3 questions Excel 2019 Beginner: 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 Quiz 2 questions 71 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:'6781134add5f0089',m:'ad1b5d1957bd9f89ccd4bccb1d6831adb1855063-1627841975-1800-AfAqaDPD2vTpBy34fj/e7pQY9XvjH+43M40KTQSfLrTuZn7XuM0q7iWSMZd+ecX5Td5iLbI8JHPyka88BfvyN7iVIUaiv7LpnT+t+fT3ioClwWADS8KSflxSokhOwR6MrMdkpMLDrQQbSItsabLwknoJXsqEoIo4COqAv/dEuz6KSd/U+Nc9y+TUYbNYZXu57g==',s:[0xd1820fabb9,0x21ba06422d],}})();
  5. Discover how to create stunning charts and graphs in Excel Learn practical methods to sort and filter your data in Excel Discover new features in PowerPoint 2019 including Icons and 3D Models Learn how to insert shapes, graphics and pictures to add some "zing" to your PowerPoint Add charts, graphs and tables to your PowerPoint presentation information in a non-text format Wow your audience by adding animations, audio and video to PowerPoint Discover practical tips to present your PowerPoint presentation to your audience Learn time saving techniques including how to copy slides, and exporting your presentation Master the most common uses of Microsoft Word Learn Word tools including using columns, indents, footers, borders and watermarks. How to create a mail merge in Microsoft Word Learn how to correctly Print envelopes and labels in Word Learn to protect your Word document from changes Insert professional pictures and graphics in your Word document Make your Word documents look amazing by inserting and editing tables Sorting information and running queries in Access Navigating the Access 2019 interface Discover how to into import data from Excel in Access Learn Queries, use validations, how to create and print reports in Access How to compact, repair and backup your Access database How to create a linked table in Access Show more Show less Requirements Excel, Word, PowerPoint and Access installed on your machine. Preferably Office 2019 or Office 365 Description **This course includes practice exercises and LIFETIME access** Learn Excel, PowerPoint, Access and Word 2019 with this tremendous value 4-course bundle from Office experts Simon Sez IT. Microsoft Office remains the go-to tool for the modern worker, yet so many workers don’t utilize its full potential. We’re here to make sure you aren’t one of those people. In this Microsoft Office Beginners bundle, we make the four essential MS Office programs (Excel, Word, PowerPoint and Access) simple to understand. This bundle includes 4, full-length courses to help you achieve your goals. What's included? Excel 2019 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 PowerPoint 2019 How to navigate around PowerPoint Presentation dos and don'ts Text and bullet edition options How to use graphics, images, objects and shapes Using SmartArt Working with Charts and Graphs How to utilize Master Slides and just how much time this could save you How to add audio and video to a presentation All about transitions between slides Animation, the animation pane and motion paths Setting your slideshow options Presentation preparation and delivery The backstage area of PowerPoint including printing a presentation Word 2019 How to get started with Word 2019 Word 2019 basics including navigation, editing and saving Character formatting in Word including Format Painter and AutoCorrect How to properly work with bullets and numbering in Microsoft Word All about formatting paragraphs and managing lists Working with Tables in Word including formatting, converting data and formulas Page appearance including page-breaks, watermarks and styles All about Sectioning a document Inserting graphics, pictures, shapes, icons and 3d models (new for 2019) How to work with envelopes and labels All about mail-merge and operating Word at scale How to create an Index or Contents page Reviewing and Printing in Word and Page Setup Protecting a Word document and basic macros in Word Microsoft Access Where to start in Microsoft Access and whether to use a template or not How to modify Access to suit your needs All about importing data and the datasheet view How tables work in Access and how to create relationships between them Creating forms and sub-forms that feed data into your tables How to run queries in Access Setting up validations and calculations using expressions in Access Printing from Access To start to use macros and Modal Dialog The basics of the Access web app Exporting and reporting in Access ***Exercise and demo files included*** This bundle includes: 29+ hours of video tutorials 300+ individual video lectures Exercise files to practice what you learned Certificate of completion Here’s what our students are saying… "Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb..... I understood every lesson in the course." - Yunesh Garusinghe "I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you." - Cavin Macwan "Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!" - Coreen Teoh 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: Anyone new to Microsoft Office or upgrading from a previous version Show more Show less Course content 81 sections • 333 lectures • 33h 42m total length Expand all sections Excel 2019: Introduction 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 Quiz 4 questions Excel 2019 Beginner: Creating Workbooks 6 lectures • 25min Entering Text and Numbers 04:32 Creating Basic Formulas Preview 06:49 Relative References 03:01 Order of Operations 04:48 Working with Ranges 04:14 Module 2 - Practice Exercise 01:35 Section Quiz 3 questions Excel 2019 Beginner: 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 Quiz 1 question Excel 2019 Beginner: 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 Quiz 1 question Excel 2019 Beginner: 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 Quiz 3 questions Excel 2019 Beginners: 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 Quiz 2 questions Excel 2019 Beginners: Moving Data 3 lectures • 14min Cut, Copy and Paste 07:07 Copying Formulas 05:09 Module 7 - Practice Exercise 01:20 Section Quiz 1 question Excel 2019 Beginners: 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 Quiz 4 questions Excel 2019 Beginner: Working with Sheets 5 lectures • 21min Working with the Save and Save As Commands 04:34 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 Quiz 3 questions Excel 2019 Beginner: 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 Quiz 2 questions 71 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:'6781134add5f0089',m:'ad1b5d1957bd9f89ccd4bccb1d6831adb1855063-1627841975-1800-AfAqaDPD2vTpBy34fj/e7pQY9XvjH+43M40KTQSfLrTuZn7XuM0q7iWSMZd+ecX5Td5iLbI8JHPyka88BfvyN7iVIUaiv7LpnT+t+fT3ioClwWADS8KSflxSokhOwR6MrMdkpMLDrQQbSItsabLwknoJXsqEoIo4COqAv/dEuz6KSd/U+Nc9y+TUYbNYZXu57g==',s:[0xd1820fabb9,0x21ba06422d],}})();
  6. Learn practical methods to sort and filter your data in Excel Discover new features in PowerPoint 2019 including Icons and 3D Models Learn how to insert shapes, graphics and pictures to add some "zing" to your PowerPoint Add charts, graphs and tables to your PowerPoint presentation information in a non-text format Wow your audience by adding animations, audio and video to PowerPoint Discover practical tips to present your PowerPoint presentation to your audience Learn time saving techniques including how to copy slides, and exporting your presentation Master the most common uses of Microsoft Word Learn Word tools including using columns, indents, footers, borders and watermarks. How to create a mail merge in Microsoft Word Learn how to correctly Print envelopes and labels in Word Learn to protect your Word document from changes Insert professional pictures and graphics in your Word document Make your Word documents look amazing by inserting and editing tables Sorting information and running queries in Access Navigating the Access 2019 interface Discover how to into import data from Excel in Access Learn Queries, use validations, how to create and print reports in Access How to compact, repair and backup your Access database How to create a linked table in Access Show more Show less Requirements Excel, Word, PowerPoint and Access installed on your machine. Preferably Office 2019 or Office 365 Description **This course includes practice exercises and LIFETIME access** Learn Excel, PowerPoint, Access and Word 2019 with this tremendous value 4-course bundle from Office experts Simon Sez IT. Microsoft Office remains the go-to tool for the modern worker, yet so many workers don’t utilize its full potential. We’re here to make sure you aren’t one of those people. In this Microsoft Office Beginners bundle, we make the four essential MS Office programs (Excel, Word, PowerPoint and Access) simple to understand. This bundle includes 4, full-length courses to help you achieve your goals. What's included? Excel 2019 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 PowerPoint 2019 How to navigate around PowerPoint Presentation dos and don'ts Text and bullet edition options How to use graphics, images, objects and shapes Using SmartArt Working with Charts and Graphs How to utilize Master Slides and just how much time this could save you How to add audio and video to a presentation All about transitions between slides Animation, the animation pane and motion paths Setting your slideshow options Presentation preparation and delivery The backstage area of PowerPoint including printing a presentation Word 2019 How to get started with Word 2019 Word 2019 basics including navigation, editing and saving Character formatting in Word including Format Painter and AutoCorrect How to properly work with bullets and numbering in Microsoft Word All about formatting paragraphs and managing lists Working with Tables in Word including formatting, converting data and formulas Page appearance including page-breaks, watermarks and styles All about Sectioning a document Inserting graphics, pictures, shapes, icons and 3d models (new for 2019) How to work with envelopes and labels All about mail-merge and operating Word at scale How to create an Index or Contents page Reviewing and Printing in Word and Page Setup Protecting a Word document and basic macros in Word Microsoft Access Where to start in Microsoft Access and whether to use a template or not How to modify Access to suit your needs All about importing data and the datasheet view How tables work in Access and how to create relationships between them Creating forms and sub-forms that feed data into your tables How to run queries in Access Setting up validations and calculations using expressions in Access Printing from Access To start to use macros and Modal Dialog The basics of the Access web app Exporting and reporting in Access ***Exercise and demo files included*** This bundle includes: 29+ hours of video tutorials 300+ individual video lectures Exercise files to practice what you learned Certificate of completion Here’s what our students are saying… "Highly recommended this course to everyone.This is the best course i ever had. Good English that we can understand. Suberb..... I understood every lesson in the course." - Yunesh Garusinghe "I really love the way you describe all the things. the language of the instructions were really simple. I really gain a new knowledge and understanding from this course. I am really looking forward to apply this all in my work. Thank you." - Cavin Macwan "Nervous at first, had no idea how to do or work it . The instructor made it easy to follow along!" - Coreen Teoh 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: Anyone new to Microsoft Office or upgrading from a previous version Show more Show less Course content 81 sections • 333 lectures • 33h 42m total length Expand all sections Excel 2019: Introduction 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 Quiz 4 questions Excel 2019 Beginner: Creating Workbooks 6 lectures • 25min Entering Text and Numbers 04:32 Creating Basic Formulas Preview 06:49 Relative References 03:01 Order of Operations 04:48 Working with Ranges 04:14 Module 2 - Practice Exercise 01:35 Section Quiz 3 questions Excel 2019 Beginner: 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 Quiz 1 question Excel 2019 Beginner: 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 Quiz 1 question Excel 2019 Beginner: 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 Quiz 3 questions Excel 2019 Beginners: 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 Quiz 2 questions Excel 2019 Beginners: Moving Data 3 lectures • 14min Cut, Copy and Paste 07:07 Copying Formulas 05:09 Module 7 - Practice Exercise 01:20 Section Quiz 1 question Excel 2019 Beginners: 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 Quiz 4 questions Excel 2019 Beginner: Working with Sheets 5 lectures • 21min Working with the Save and Save As Commands 04:34 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 Quiz 3 questions Excel 2019 Beginner: 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 Quiz 2 questions 71 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:'6781134add5f0089',m:'ad1b5d1957bd9f89ccd4bccb1d6831adb1855063-1627841975-1800-AfAqaDPD2vTpBy34fj/e7pQY9XvjH+43M40KTQSfLrTuZn7XuM0q7iWSMZd+ecX5Td5iLbI8JHPyka88BfvyN7iVIUaiv7LpnT+t+fT3ioClwWADS8KSflxSokhOwR6MrMdkpMLDrQQbSItsabLwknoJXsqEoIo4COqAv/dEuz6KSd/U+Nc9y+TUYbNYZXu57g==',s:[0xd1820fabb9,0x21ba06422d],}})();
  7. Discover new features in PowerPoint 2019 including Icons and 3D Models Learn how to insert shapes, graphics and pictures to add some "zing" to your PowerPoint Add charts, graphs and tables to your PowerPoint presentation information in a non-text format Wow your audience by adding animations, audio and video to PowerPoint Discover practical tips to present your PowerPoint presentation to yo