Language: English
Short Description: This course thoroughly covers, step-by-step, the newest version of Microsoft Office. 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 ways to create, edit, and print documents in Word. You'll learn to create and manage worksheets in Excel. You will master developing presentations in PowerPoint
and creating databases in Access. You'll also learn tips and tricks for creating professional publications with Publisher, and managing email and calendars in Outlook.
Microsoft Office holds over 90 percent of the market for Windows-based productivity suites. This MS Office 2019 course makes the Office applications easy to understand and use.
NOTE: This course does NOT include the MS Office programs themselves. Students will need to have Office 2019 already installed on their computers.
Instructor Description: This class supported by an Educational Mentor. Educational mentors have worked or are working in the subject they mentor. Educational Mentors review student work, student progress, and interact with students as needed. They respond to any questions or concerns you might have, as well as encouraging and motivating students to succeed.
Requirements
This program requires access to Microsoft Office 365: 2019 Suite. This software is not included with the program tuition.
The technical requirements for this program are as follows:
Internet Connection
Hardware Requirements
Processor - 2GHz Processor or Higher
Memory - 1 GB RAM Minimum Recommended
PC/Windows Software Requirements
Operating Systems - Windows 7 or higher
MAC Software Requirements
Operating Systems - Mac OS x 10 or higher with Windows
Hide Syllabus
Lesson 1
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
Hide Syllabus