Microsoft Office 365-Training Bundle Suite 2019

Microsoft Office 365-Training Bundle Suite 2019

Non-returnable
$995.00
LEARNING OBJECTIVES: After completing this course, you should be able to: Recall ways to create, edit, and print documents in Word Recognize how to create and manage worksheets in Excel Identify the steps to develop presentations in PowerPoint List how to create and manage databases in Access Identify the steps to manage email and calendars in Outlook Describe ways to create professional publications with Publisher 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.
INFORMATION
Become A Pro And Learn Everything About Microsoft Office 365
HOURS
135
DURATION (time given)
6 months
AVERAGE COMPLETION TIME
3 Months
SYLLABUS
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
Quantity
Add to Cart
Product Details
Added to cart
- There was an error adding to cart. Please try again.
Quantity updated
- An error occurred. Please try again later.
Deleted from cart
- Can't delete this product from the cart at the moment. Please try again later.