Microsoft Office 365 - 2019
Click on the individual topics for training to see a class description. Get certified in Microsoft Office Basics, Microsoft Office Intermediate, and Microsoft Office Advanced classes. ALL classes offered completely online and at your own pace!
Microsoft Office 365 - 2019 Introductory
DESCRIPTION:
Microsoft Word, Microsoft Excel, Microsoft Access and Microsoft PowerPoint are programs part of the Microsoft Office 365 and Office 2019. This course provides introductory lessons to get you up and running using the main Office applications: Excel, Word, PowerPoint, and Access; includes insights into common tasks and advanced tools; offers useful coverage of each application in the suite. Each of the programs allows you to be more efficient in your day to day routine or running an office. This 14 week class is a great place to start. Get your feet wet with an introductory of each one! At the end of this 14 week course you will receive a completion certificate from Professional Tutor certifying that you have obtained Microsoft Office 2019 Basic Skills.
Microsoft Word 2019
Module 1: Creating and Editing a Document
Module 2: Navigating and Formatting a Document
Module 3: Creating Tables and a Multi-page Report
Module 4: Enhancing Page Layout and Design
Microsoft Excel 2019
Module 1: Getting Started with Excel
Module 2: Formatting Workbook Text and Data
Module 3: Performing Calculations with Formulas and Functions
Module 4: Analyzing and Charting Financial Data
Microsoft Access 2019
Module 1: Creating a Database
Module 2: Building a Database and Defining Table Relationships
Module 3: Maintaining and Querying a Database
Module 4: Creating Forms and Reports
Microsoft PowerPoint 2019
Module 1: Creating a Presentation
Module 2: Adding Media and Special Effects
Microsoft Word, Microsoft Excel, Microsoft Access and Microsoft PowerPoint are programs part of the Microsoft Office 365 and Office 2019. This course provides introductory lessons to get you up and running using the main Office applications: Excel, Word, PowerPoint, and Access; includes insights into common tasks and advanced tools; offers useful coverage of each application in the suite. Each of the programs allows you to be more efficient in your day to day routine or running an office. This 14 week class is a great place to start. Get your feet wet with an introductory of each one! At the end of this 14 week course you will receive a completion certificate from Professional Tutor certifying that you have obtained Microsoft Office 2019 Basic Skills.
Microsoft Word 2019
Module 1: Creating and Editing a Document
Module 2: Navigating and Formatting a Document
Module 3: Creating Tables and a Multi-page Report
Module 4: Enhancing Page Layout and Design
Microsoft Excel 2019
Module 1: Getting Started with Excel
Module 2: Formatting Workbook Text and Data
Module 3: Performing Calculations with Formulas and Functions
Module 4: Analyzing and Charting Financial Data
Microsoft Access 2019
Module 1: Creating a Database
Module 2: Building a Database and Defining Table Relationships
Module 3: Maintaining and Querying a Database
Module 4: Creating Forms and Reports
Microsoft PowerPoint 2019
Module 1: Creating a Presentation
Module 2: Adding Media and Special Effects
Microsoft Office 365 - 2019 Intermediate
DESCRIPTION:
Quality Learning! This class series goes beyond learning Office applications by providing contextual relevance with real world scenarios and assessments. With a deeper focus on employability, this class series demonstrates real world relevance and professionalism with case scenarios written to reflect the top industries hiring for Microsoft Office skills. This is the ideal way to prepare students to transcend point-and-click skills and take advantage of all that Microsoft Office 2019 has to offer. Students will understand why they are learning what they are learning and are prepared to apply their skills and solve problems in real-life situations. At the end of this 13 week course you will receive a completion certificate from Professional Tutor certifying that you have obtained Microsoft Office 2019 Intermediate Skills.
Microsoft Word 2019
Module 5: Working with Templates, Themes and Styles
Module 6: Using Mail Merge
Module 7: Collaborating with Others and Integrating Data
Microsoft Excel 2019
Module 5: Generating Reports from Multiple Worksheets and Workbooks
Module 6: Managing Data with Data Tools
Module 7: Summarizing Data with PivotTables
Module 8: Performing What-If Analyses
Microsoft Access 2019
Module 5: Creating Advanced Queries and Enhancing Table Design
Module 6: Using Form Tools and Creating Custom Forms
Module 7: Creating Custom Reports
Module 8: Sharing, Integrating, and Analyzing Data
Microsoft PowerPoint 2019
Module 3: Applying Advanced Formatting to Objects
Module 4: Advanced Animations and Distributing Presentations
Quality Learning! This class series goes beyond learning Office applications by providing contextual relevance with real world scenarios and assessments. With a deeper focus on employability, this class series demonstrates real world relevance and professionalism with case scenarios written to reflect the top industries hiring for Microsoft Office skills. This is the ideal way to prepare students to transcend point-and-click skills and take advantage of all that Microsoft Office 2019 has to offer. Students will understand why they are learning what they are learning and are prepared to apply their skills and solve problems in real-life situations. At the end of this 13 week course you will receive a completion certificate from Professional Tutor certifying that you have obtained Microsoft Office 2019 Intermediate Skills.
Microsoft Word 2019
Module 5: Working with Templates, Themes and Styles
Module 6: Using Mail Merge
Module 7: Collaborating with Others and Integrating Data
Microsoft Excel 2019
Module 5: Generating Reports from Multiple Worksheets and Workbooks
Module 6: Managing Data with Data Tools
Module 7: Summarizing Data with PivotTables
Module 8: Performing What-If Analyses
Microsoft Access 2019
Module 5: Creating Advanced Queries and Enhancing Table Design
Module 6: Using Form Tools and Creating Custom Forms
Module 7: Creating Custom Reports
Module 8: Sharing, Integrating, and Analyzing Data
Microsoft PowerPoint 2019
Module 3: Applying Advanced Formatting to Objects
Module 4: Advanced Animations and Distributing Presentations
Microsoft Office 365 - 2019 Advanced
DESCRIPTION:
Now students can master the nuances of Microsoft Office quickly with this 13 week course. Each module begins with a brief overview of the principles covered in the lesson and introduces a real-world case scenario to engage students and reinforce critical skills to make them successful in their educational and professional careers. At the end of this 13 week course you will receive a completion certificate from Professional Tutor certifying that you have obtained Microsoft Office 2019 Advanced Skills.
Microsoft Word 2019
Module 8: Customizing Word and Automating Your Work
Module 9: Creating Online Forms Using Advanced Table Techniques
Module 10: Managing Long Documents
Microsoft Excel 2019
Module 9: Exploring Financial Tools and Functions
Module 10: Analyzing Data with Business Intelligence Tools
Module 11: Exploring PivotTable Design
Module 12: Developing an Excel Application
Microsoft Access 2019
Module 9: Using Action Queries and Advanced Table Relationships
Module 10: Automating Tasks with Macros
Module 11: Using and Writing Visual Basic for Applications Code
Module 12: Managing and Securing a Database
Microsoft PowerPoint 2019
Module 5: Integrating PowerPoint with Other Programs
Module 6: Customizing Presentations and the PowerPoint Environment
Now students can master the nuances of Microsoft Office quickly with this 13 week course. Each module begins with a brief overview of the principles covered in the lesson and introduces a real-world case scenario to engage students and reinforce critical skills to make them successful in their educational and professional careers. At the end of this 13 week course you will receive a completion certificate from Professional Tutor certifying that you have obtained Microsoft Office 2019 Advanced Skills.
Microsoft Word 2019
Module 8: Customizing Word and Automating Your Work
Module 9: Creating Online Forms Using Advanced Table Techniques
Module 10: Managing Long Documents
Microsoft Excel 2019
Module 9: Exploring Financial Tools and Functions
Module 10: Analyzing Data with Business Intelligence Tools
Module 11: Exploring PivotTable Design
Module 12: Developing an Excel Application
Microsoft Access 2019
Module 9: Using Action Queries and Advanced Table Relationships
Module 10: Automating Tasks with Macros
Module 11: Using and Writing Visual Basic for Applications Code
Module 12: Managing and Securing a Database
Microsoft PowerPoint 2019
Module 5: Integrating PowerPoint with Other Programs
Module 6: Customizing Presentations and the PowerPoint Environment