Rates start at 0% APR. Prequalify now. Choose monthly plans from 4–12 months. Total out of pocket cost is $3,120.
Final pricing is given at time of purchase and may vary from the example pricing given above.
MS 7000
Microsoft Office Specialist
courses taken
COURSES
DURATION
MS 7000
1
MS 7000
Microsoft Word - Levels 1-3
16 hours
Length
1 week
Duration
Microsoft Word Level 1: This course is designed to introduce students to the basic functionality and user interface of Microsoft Word 2019. In this course, students will learn the basics of saving and opening documents and review the interface. Students will practice text navigation, selection, entry, and various other text formatting and editing commands and features. Additionally, students will work with bulleted and numbered lists, tables, and their various features and options. Students will also work with graphics and the various tools available in Word 2019 to format and edit them. Lastly, this course will cover various options for viewing documents, proofing options for documents, and settings to prepare document for distribution and publication.
Microsoft Word Level 2: This is the intermediate course in the Microsoft Word 2019 series. This course expands upon the topics covered in the Word 2019 Introduction course. In this course, students will work with, create, manage, and customize Styles, Templates, and Themes. Students will also work with various types of data in Word using Tables, advanced Copy and Paste commands, and Charts. Students will then review advanced document layout options in Word and various collaboration tools. Lastly, students will work with graphic elements such as pictures, text boxes, shapes, the Drawing Canvas, SmartArt, Text Effects, Typography Effects, WordArt, and Equations. Additional graphic element features such as grouping, layering, and moving objects will also be covered.
Microsoft Word Level 3: In this advanced course, students will automate with Microsoft Word through the use of building blocks, Quick Parts, fields, and Macros. Students will also utilize reference tools such as bookmarks, hyperlinks, cross references, footnotes, endnotes, bibliography tools, sources, and placeholders. Students will also learn techniques to manage long documents through a table of contents, indexing, and captions. Students will also work with Outline View and master documents, Mail Merge, and forms.
Learn the basics of saving and opening documents
Work with, create, manage, and customize Styles, Templates, and Themes
Automate with Microsoft Word through the use of building blocks, Quick Parts, fields, and Macros
Work with Outline View and master documents, Mail Merge, and forms
MS 7000
2
MS 7000
Microsoft Excel - Levels 1-3
32 hours
Length
2 weeks
Duration
Microsoft Excel Level 1: Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks.
Microsoft Excel Level 2: This course is designed to be the intermediate level of Excel 2019. Students will learn how to link workbooks and worksheets, work with named ranges, and intermediate Logical and Lookup functions and formulas. Students will also be introduced to and work with Tables and PivotTables, including sorting and filtering. Additionally, students will work with Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment.
Microsoft Excel Level 3: This course will teach students advanced concepts and formulas in Microsoft Excel 2019. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks.
Understand how to create, save, enter data, and print spreadsheets
Create formulas and use functions to calculate in Excel
Learn functions such as SUMIF, AVERAGEIF, and COUNTIF
Advanced use of PivotTables and PowerPivot add-in
Work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks
MS 7000
1
MS 7000
Microsoft Outlook - Levels 1-2
16 hours
Length
1 week
Duration
Microsoft Outlook Level 1: This course is designed to teach students the basics of Microsoft Outlook 2019 and help them gain familiarity with the Outlook environment and basic functionality. Students will learn the basics of email, how to use the Help feature, how to create and send messages, and how to work with attachments. Students will also learn organizational techniques through the use of folders, views, categories, flags, and searching. Additionally, students will review printing options, automatic replies, contact creation and management, calendar use and management, task and note creation and management, message options, and email signatures.
Microsoft Outlook Level 2: In this course, students will expand upon their existing knowledge and learn and use advanced features of Microsoft Outlook 2019. Students will modify and manage message options, track and delivery options, voting options, contact options, calendar options, and other advanced Outlook features. Students will also review advanced calendar and task usage, rules and automation, cleanup commands, sharing options, advanced graphic options, junk mail options, import and export features, and how to back up their Outlook data.
Understand the basics of email, how to use the Help feature, how to create and send messages
Learn organizational techniques through the use of folders, views, categories, flags, and searching
Review advanced calendar and task usage, rules and automation, cleanup commands
Utilize advanced graphic options, junk mail options, import and export features
MS 7000
1
MS 7000
Microsoft PowerPoint - Levels 1-2
16 hours
Length
1 week
Duration
Microsoft PowerPoint Level 1: In this course, students will get started with PowerPoint 2019 and become familiar with the Ribbon, interface, and navigation options. Additionally, students will create a presentation and work with various features and commands to make it easier to work in PowerPoint. Students will also review presentation editing options, text formatting options, various graphic options and insertion methods, how to add, edit, and format tables and charts in a presentation, and various presentation preparation and delivery options.
Microsoft PowerPoint Level 2: In this course, students will learn the various collaboration tools in Microsoft PowerPoint 2019 such as reusing slides, creating slides from Word, and working with Excel. Students will learn to utilize the power of Slide Masters, create custom themes, and design custom templates. In addition, students will learn to create exciting presentations by animating text and objects, add slide transitions, and use advanced graphic features including SmartArt, and audio and video. Finally, students will present like a pro by using advanced presentation features including annotations, hyperlinks and action buttons, timings, recordings, and creating videos, and review additional advanced slideshow options.
Become familiar with the Ribbon, interface, and navigation options
Review presentation editing options, text formatting options, various graphic options and insertion methods
Learn the various collaboration tools such as reusing slides, creating slides from Word, and working with Excel
Present like a pro by using advanced presentation features including annotations, hyperlinks and action buttons, and more
MS 7000
2
MS 7000
Microsoft Access - Levels 1-3
32 hours
Length
2 weeks
Duration
Microsoft Access Level 1: This course is an introduction to Microsoft Access 2019. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 2019 Intermediate course.
Microsoft Access Level 2: This course is designed to teach students intermediate level skills in Microsoft Access 2019. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 2019 Advanced course.
Microsoft Access Level 3: Access 2019 Advanced will further build upon the topics covered in the Access 2019 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create and modify Switchboards, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), and use Table Events.
Become familiar with various database components, concepts, and terminology
Create databases, create objects, perform calculations, navigate and work with tables
Learn how to automate processes with Macros, advanced form techniques, and advanced report techniques
Review how to improve the structure of an Access database
Configure security and multi-user environments and automate processes with VBA (Visual Basic for Applications)