Microsoft Office 365-Training Bundle Suite 2019

If you're looking for a way to get up to speed quickly on the newest version of Microsoft Office, this course offers step-by-step instructions to make it easy. Office 2019 has new features and tools to master, and whether you're upgrading from an earlier version or encountering the Office applications for the first time, you'll appreciate this simplified approach. This course covers: Microsoft Word 2019 Microsoft Excel 2019 Microsoft PowerPoint 2019 Microsoft Outlook 2019 Microsoft Access 2019 Microsoft Publisher 2019 Microsoft Office holds more than 90 percent of the market for Windows-based productivity suites. Our MS Office 2019 course makes this technology easy to understand, even for those who are new to computers. NOTE: This course does NOT include the MS Office programs themselves. Students will need to have Office 2019 already installed on their computers.

Module 1: Office 365 Lesson 1: Common Office Tasks • All About Office 365 • Office Interface • Saving Your Files • Manipulating the Text • Handling Case or Capitalization • Entering Symbols and Foreign Characters • Undoing and Repeating Commands • Correcting Typos • AutoCorrect Command Lesson 2: One Step Beyond • Customizing the Ribbon • Customizing the Quick Access Toolbar • Ways of Distributing Your Work • Working with Publisher • Printing a Publication • Filing Sharing and Collaborating • OneDrive • Sharing Files and Folders with Other Lesson 3: Working with Charts and Graphs • Creating a Chart • Saving a Chart as a Template • Chart Tricks • SmartArt Diagram • Handling Graphics and Photos • Touching Up a Picture • Drawing and Manipulating Lines, Shapes and Objects • WordArt Lesson 4: Working with Publisher • Introducing Frames • Creating a Publication • Redesigning a Publication • Formatting Text • Text Wraps • Placeholder Pictures • Frames • Decorating the Text • Design Checker Lesson 5: Working with Access • Tables and Queries • Forms • Creating a Database File • Designing a Database • Field Properties • Entering Data • Sorting • Querying • Filtering for Data Lesson 6: SharePoint for End Users • SharePoint Overview • Creating Your First Site • Adding Content to the Team Site Module 2: Word Lesson 1: Working with Word Part I • Getting Started with Word 2019 • Formatting Text and Paragraphs • Working More Efficiently • Managing Lists • Adding Tables • Inserting Graphic Objects • Controlling Page Appearance • Preparing to Publish a Document Lesson 2: Working with Word Part II • Organizing Content Using Tables and Charts • Customizing Formats Using Styles and Themes • Inserting Content Using Quick Parts • Using Templates to Automate Document Formatting • Controlling the Flow of a Document • Simplifying and Managing Long Documents • Using Mail Merge to Create Letters, Envelopes, and Labels Lesson 3: Working with Word Part III • Manipulating Images • Using Custom Graphic Elements • Collaborating on Documents • Adding Document References and Links • Securing a Document • Using Forms to Manage Content • Automating Repetitive Tasks with Macros Module 3: Excel Lesson 1: Working With Excel Part I • Getting Started with Microsoft Office Excel 2019 • Performing Calculations • Modifying a Worksheet • Formatting a Worksheet • Printing Workbooks • Managing Workbooks • Adding Borders and Colors to Worksheets • Basic Excel Customization Lesson 2: Working with Excel Part II • Working with Functions • Working with Lists • Analyzing Data • Visualizing Data with Charts • Using PivotTables and PivotCharts • Working with Graphical Objects • Using Array Formulas Lesson 3: Working with Excel Part III • Working with Multiple Worksheets and Workbooks • Sharing and Protecting Workbooks • Automating Workbook Functionality • Using Lookup Functions and Formula Auditing • Forecasting Data • Creating Sparklines and Mapping Data • Importing and Exporting Data • Internationalizing Workbooks • Working with Power Pivot • Advanced Customization Options • Working with Forms and Controls Module 4: PowerPoint Lesson 1: Working With PowerPoint Part I • Getting Started with PowerPoint 2019 • Developing a PowerPoint Presentation • Performing Advanced Text Editing Operations • Adding and Arranging Graphical Elements • Modifying Graphical Elements • Preparing to Deliver Your Presentation Lesson 2: Working with PowerPoint Part II • Customizing Design Templates • Using Ink to Hand Draw Elements • Adding Tables • Adding Charts • Working with Media • Building Advanced Transitions and Animations • Finalizing a Presentation • Customizing Presentation Navigation • Securing and Distributing a Presentation Module 5: Outlook Lesson 1: Working With Outlook Part I • Getting Started With Outlook 2019 • Formatting Messages • Working with Attachments and Illustrations • Customizing Message Options • Organizing Messages • Managing Your Contacts • Working with the Calendar • Working with Tasks and Notes Lesson 2: Working with Outlook Part II • Modifying Message Properties and Customizing Outlook • Organizing, Searching, and Managing Messages • Managing Your Mailbox • Automating Message Management • Working with Calendar Settings • Managing Contacts • Managing Activities Using Tasks • Sharing Outlook Items • Managing Outlook Data Files

All required reference materials are provided with this program. Technical requirements: Internet Connection • Broadband or High-Speed (DSL, Cable, Wireless) Hardware Requirements • Processor - 2GHz Processor or Higher • Memory - 1 GB RAM Minimum Recommended Software Requirements • Operating Systems - Windows 7, 8 or 10; Mac OS x 10 or higher • Microsoft Office 2007, 2010 or 2013 or a Word Processing application to save and open Microsoft Office formats (.doc, .docx, .xls, .xlsx, .ppt, .pptx) • Internet Browsers - Google Chrome is highly recommended • Cookies MUST be enabled • Pop-ups MUST be allowed (Pop-up Blocker disabled) • Adobe PDF Reader

This class is an independent-study course. Students will have all the resources needed to successfully complete the course within the online material. A student helpdesk is available for technical support during the course enrollment.