Microsoft Office Training Series

$175.00

ITU’s Microsoft office training series contains certification courses in Excel, Access, Word, PowerPoint & Outlook and allows you to prepare for your Microsoft Office Specialist(MOS) certification. TOIT’s Microsoft office training series contains certification courses in Excel, Access, Word, PowerPoint & Outlook and allows you to prepare for your Microsoft Office Specialist(MOS) certification. This Microsoft 70-347: Enabling Office 365 Services course is the perfect choice for IT professionals seeking to assess, plan, deploy and manage Office 365 services and their corresponding dependencies, needs and technical resources. In this Microsoft 70-346 course you will learn how to evaluate, plan, deploy, and operate the Office 365 services, including its dependencies, requirements, and supporting technologies. This course prepares you for the MS-346 certification exam. Master PowerPoint 2016 with this comprehensive course covering the three main sections: Basic, Intermediate and Advanced. Get an in-depth review of the software while learning to navigate its interface effectively and insert a variety of objects. Create dynamic presentations that will leave your viewers impressed as you learn about design, customization, and presentation techniques!

Category:

Description

Overview

ITU’s Microsoft office training series contains certification courses in Excel, Access, Word, PowerPoint & Outlook and allows you to prepare for your Microsoft Office Specialist(MOS) certification. TOIT’s Microsoft office training series contains certification courses in Excel, Access, Word, PowerPoint & Outlook and allows you to prepare for your Microsoft Office Specialist(MOS) certification. This Microsoft 70-347: Enabling Office 365 Services course is the perfect choice for IT professionals seeking to assess, plan, deploy and manage Office 365 services and their corresponding dependencies, needs and technical resources. In this Microsoft 70-346 course you will learn how to evaluate, plan, deploy, and operate the Office 365 services, including its dependencies, requirements, and supporting technologies. This course prepares you for the MS-346 certification exam. Master PowerPoint 2016 with this comprehensive course covering the three main sections: Basic, Intermediate and Advanced. Get an in-depth review of the software while learning to navigate its interface effectively and insert a variety of objects. Create dynamic presentations that will leave your viewers impressed as you learn about design, customization, and presentation techniques!

Your Training Instructors

Josh Schofer

Cybersecurity | Cloud Trainer

Josh has 15 plus years in account management and client support with over 5 years specifically in the healthcare industry. Josh provides hands-on leadership to the healthcare team at NetDirector by focusing on client success and innovative solutions. As the Healthcare Operations Manager, Josh ensures that each client implementation is completed as efficiently as possible with the greatest impact to the client. He holds a Bachelor of Arts degree from the University of South Florida.

Lindsay Hurley

Instructor

  • 119 Traning Hours
  • 649 Videos
  • 54 Topics
  • 1,368 Practice Questions

Course Description

This Microsoft Office training Series includes 18 courses

In today’s competitive economic atmosphere, having certifications to vouch for your skills is key to distinguishing yourself from the competition in the job market. Microsoft certifications not only demonstrate an employee’s marketability, but also validate their experience and proficiency to a potential employer. This Microsoft Office training series will help your master your Microsoft Office skillset. TOIT understands the professional needs of our students and has created this bundle specifically for business, HR, sales, office administration or accounting professionals to learn the skills necessary to obtain those positions they are passionate about. With this bundle you will acquire relevant management tools as well as certifications that will boost your chances of attaining that dream role!

Computers drastically revolutionize the modern office, enabling us to work with greater speed and accuracy than ever before. Yet without knowledge of relevant skills and platforms, many people are struggling through projects that could take a few minutes if they were properly equipped. TOIT’s online classes are self-paced, comprehensive and specifically tailored to help professionals gain the skills they need in order to become certified on Microsoft technologies.

Learn to harness the power of Microsoft Office Suite with our Ultimate Microsoft Office training series. With comprehensive lessons on Word, Excel, PowerPoint, Outlook and more you will increase your skill level and become a pro in no time!

Prepare for your Microsoft Office Specialist (MOS) certification

Unlock your potential and become a more competent employee with Microsoft Office Suite. With this Microsoft Office training, our Microsoft Certification Career Advancement Bundle provides certification courses for Excel, Access, Word, PowerPoint, and Outlook that will help you prepare to receive a MOS certificate. With these tools under your belt you can expedite tasks in no time!

Completing the online Microsoft Office training courses will give you valuable knowledge.

  • Demonstrate knowledge of functions of Office 365 and structure
  • Developing your skill sets for common business processes
  • With this program, you can get ready to pass your Microsoft Office Specialist (MOS) certification.

Course Outline

Microsoft Excel 2019 Course Outline

Module 1: Beginner
  •    1.0 Intro
  •    1.1 The Ribbon
  •    1.2 Saving Files
  •    1.3 Entering and Formatting Data
  •    1.4 Printing from Excel & Using Page Layout View
  •    1.5 Formulas Explained
  •    1.6 Working with Formulas and Absolute References
  •    1.7 Specifying and Using Named Range
  •    1.8 Correct a Formula Error
  •    1.9 What is a Function
  •    1.10 Insert Function & Formula Builder
  •    1.11 How to Use a Function- AUTOSUM, COUNT, AVERAGE
  •    1.12 Create and Customize Charts
Module 2: Intermediate
  •    2.0 Recap
  •    2.1 Navigating and editing in two or more worksheets
  •    2.2 View options – Split screen, view multiple windows
  •    2.3 Moving or copying worksheets to another workbook
  •    2.4 Create a link between two worksheets and workbooks
  •    2.5 Creating summary worksheets
  •    2.6 Freezing Cells
  •    2.7 Add a hyperlink to another document
  •    2.8 Filters
  •    2.9 Grouping and ungrouping data
  •    2.10 Creating and customizing all different kinds of charts
  •    2.11 Adding graphics and using page layout to create visually appealing pages
  •    2.12 Using Sparkline formatting
  •    2.13 Converting tabular data to an Excel table
  •    2.14 Using Structured References
  •    2.15 Applying Data Validation to cells
  •    2.16 Comments – Add, review, edit
  •    2.17 Locating errors
Module 3: Advanced
  •    3.1 Recap
  •    3.2 Conditional (IF) functions
  •    3.3 Nested condition formulas
  •    3.4 Date and Time functions
  •    3.5 Logical functions
  •    3.6 Informational functions
  •    3.7 VLOOKUP & HLOOKUP
  •    3.8 Custom drop down lists
  •    3.9 Create outline of data
  •    3.10 Convert text to columns
  •    3.11 Protecting the integrity of the data
  •    3.12 What is it, how we use it and how to create a new rule
  •    3.13 Clear conditional formatting & Themes
  •    3.14 What is a Pivot Table and why do we want one
  •    3.15 Create and modify data in a Pivot Table
  •    3.16 Formatting and deleting a Pivot Table
  •    3.17 Create and modify Pivot Charts
  •    3.18 Customize Pivot Charts
  •    3.19 Pivot Charts and Data Analysis
  •    3.20 What is it and what do we use it for
  •    3.21 Scenarios
  •    3.22 Goal Seek
  •    3.23 Running preinstalled Macros
  •    3.24 Recording and assigning a new Macro
  •    3.25 Save a Workbook to be Macro enabled
  •    3.26 Create a simple Macro with Visual Basics for Applications (VBA)
  •    3.27 Outro

Microsoft Word 2019 Course Outline

Module 1: Beginner
  •    1.01 Instructor Intro
  •    1.02 Course Intro
  •    1.1 Explaining the Ribbon
  •    1.2 Creating a Document
  •    1.3 Saving Files
  •    1.4 Page Views
  •    1.5 Formatting Text
  •    1.6 Ruler, Margins and Tab Stops
  •    1.7 Moving and Duplicating Text
  •    1.8 Line Spacing and Paragraph Formatting
  •    1.9 Basic Editing
  •    1.10 Insert a Basic Table and Graphics
  •    1.11 Working with Styles
Module 2: Intermediate

Go to Top