Microsoft Office Suite

Hours: 150 / Access Length: 12 Months / Delivery: Open, Mentor Supported
Retail Price: $1,195.00

Course Overview:

This course provides training for the features of Microsoft Office’s Word 2013. Microsoft Word 2013 is a word-processing program, designed to help you create professional-quality documents. With the finest document-formatting tools, Word helps you organize and write your documents more efficiently. Word also includes powerful editing and revising tools so that you can collaborate with others easily.

This course trains you how to use the features of Microsoft Excel 2013. Excel 2013 is an incredibly powerful tool for getting meaning out of vast amounts of data. But it also works really well for simple calculations and tracking almost any kind of information. The key for unlocking all that potential is the grid of cells. Cells can contain numbers, text or formulas. You put data in your cells and group them in rows and columns. That allows you to add up your data, sort and filter it, put it in tables, and build great-looking charts.

This course provides training for the features of Microsoft Office’s PowerPoint 2013. PowerPoint 2013 is a visual and graphical application, primarily used for creating presentations. With PowerPoint, you can create, view, and present slide shows that combine text, shapes, pictures, graphs, animation, charts, videos, and much more!

This course trains you how to use the features of Microsoft Outlook 2013. Microsoft Outlook 2013 organizes your emails, calendars, contacts, tasks, and to-do lists, all in one place. It all starts with your email account. From there you can start working with emails, turning them into tasks or appointments, and storing the people you interact with in your contacts, so you never have to remember an email address or phone number.

This course trains you how to use the features of Microsoft Access 2013. Microsoft Access is a tool to manage information that helps you store information for reference, reporting and analysis. It can help you to overcome limitations you may find when you try to manage large amounts of information in Excel or other spreadsheets. This course will teach you basic to advanced features of Access, and will cover what you need to know as efficiently as possible. 

This course includes:

• Visual Demonstrations & Multimedia Presentations
• Quizzes & Exam Simulators
• Social Learning & Networking
• Flash Cards & Educational Games
• Enhanced Navigation and Controls

Upon successful completion of the Microsoft Office Suite course, students will be prepared to choose to sit for one of the Microsoft Office certification exams to become a Microsoft® Office Specialist (MOS).

Course Outline:

Word 2013 Introduction

• Intro Word
• Screen Layout
• Page Setup And Text Entry
• Autocorrect Text Formatting
• More Font Formatting
• Fonts Part 3
• Font Attributes Using Right Click
• Paragraph Attributes
• Customizing Bullets And Numbers
• Reveal Codes Putting It All Together And Saving
• Viewing Rulers
• Formatting Images
• Inserting Images
• Tabs
• Window Views And Putting It All Together Part1
• Window Views And Putting It All Together Part 2

Word 2013 Intermediate

• 2.1 Intro To Word 2013 Intermediate
• 2.2 Review Introduction To Styles
• 2.3 Headers And Footers
• 2.4 Section Breaks Section Footers
• 2.5 More Objects Word Intermediate
• 2.6 Tables In Word Intermediate
• 2.7 Inserting Text Boxes Word Intermediate
• 2.8 Additional Page Attributes Word Intermediate
• 2.9 Intro To Customizing Attributes
• 2.10 Continuing Autocorrect Options
• 2.11 View Options In Navigation Pane
• 2.12 Mail Merge Part 1
• 2.13 Mail Merge Part 2
• 2.14 Mail Merge Part 3
• 2.15 Table Of Contents Part 1
• 2.16 Columns Part 1
• 2.17 Working With Outlines

Word 2013 Advanced

• 3.1 Word Advance Introduction
• 3.2 End Notes Foot Notes
• 3.3 Captions Part 2
• 3.4 Citations
• 3.5 Table Of Authorities
• 3.6 Reference Page Index Table
• 3.7 Track Changes
• 3.8 Compare
• 3.9 Advance Mail Merge Part 1
• 3.10 Advance Mail Merge Part 2
• 3.11 Advance Smart Art
• 3.12 Templates
• 3.13 Custom Configuration

Excel Introduction

• Intro To Excel Overview Of Screen
• Ribbon Elements
• Entering Data And Editing Font Attributes
• Number Formats
• Formatting Cells
• Printing
• Formulas Part 1
• Formulas Part 2
• Rearranging Data
• More Formulas
• More Formulas Part 2 Review And Sort
• More Formulas Part3 Concatenate
• Chart Part 1
• Chart Part 2
• Chart Part 3
• Summary

Excel Intermediate

• 2.1 Introduction
• 2.2 Review
• 2.3 Formulas Across Worksheets Part 1
• 2.4 Formulas Across Worksheets Part 2
• 2.5 Conditional Formatting
• 2.6 Data Validation
• 2.7 Named Ranges
• 2.8 CSV Files
• 2.9 Text To Column
• 2.10 Grouping Data
• 2.11 More Charts Beyond Building Blocks
• 2.12 Working With Windows Part 1
• 2.13 Working With Windows Part 2
• 2.14 Headers Footers And Protecting Data

Excel Advanced

• 3.1 Pivot Tables Part 1
• 3.2 Pivot Tables Part 2
• 3.3 Sparklines
• 3.4 Trancing Formulas
• 3.5 What If Scenario
• 3.6 External Data Sources
• 3.7 Customizing Menus And Options
• 3.8 Customizing Menus And Options Part 2
• 3.9 Macros

PowerPoint 2013 Introduction

• What Is PowerPoint
• Screen Elements
• Starting A New Presentation
• Layouts
• Objects Part 1
• Objects Part 2
• Objects Part 3
• Slide Design
• Slide Transitions
• Animations Part 1
• Animations Part 2
• View And Slideshow

PowerPoint Intermediate

• 2.1 Understanding Slide Masters
• 2.2 Slide Maters
• 2.3 Animations Part 2
• 2.4 Animations Part 2 Continued
• 2.5 Hotspots And Actions
• 2.6 Views
• 2.7 Printing Options

PowerPoint Advanced

• 3.1 Introduction To Advance And Inserting Charts
• 3.2 Setting Up Slide Shows Part 1
• 3.3 Setting Up Slide Shows Part 2
• 3.4 Advance Animations Part 3
• 3.5 Templates Vs Shows
• 3.6 Reviewing Information And Compare
• 3.7 Copy And Paste Across Presentations
• 3.8 Customizing PowerPoint
• 3.9 Adding Media Video
• 3.10 Adding Media Audio Part 1
• 3.11 Adding Media Audio Part 2

Outlook Introduction

• Introduction To Outlook
• Understanding Email Setting Outlook
• Configuring Interface Part 1
• Configuring Interface Part 2
• Email Window Part 1
• Email Window Part 2
• Managing The Inbox
• Using The Calendar Part 1
• Using The Calendar Part 2
• Contacts Part 1
• Contacts Part 2
• Task List

Outlook Intermediate

• 2.1 Adding An Account From Scratch
• 2.2 Multiple Email Accounts In One Window
• 2.3 Searching For Mail
• 2.4 Managing The Folders Views In Inbox
• 2.5 Using Priority And Receipts
• 2.6 Calendars
• 2.7 Contacts Part 1
• 2.8 Contacts Part 2

Outlook Advanced

• 3.1 Mail Part 1 Auto Replies
• 3.2 Mail Part 2 Signatures
• 3.3 Views And Options Part 1
• 3.4 Views And Options Part 2
• 3.5 Calendar Part 1
• 3.6 Calendar Part 2
• 3.7 Calendar Options
• 3.8 Contacts
• 3.9 Contacts Options
• 3.10 Advanced Options Part 1
• 3.11 Advanced Options Part 2

Access Introduction

•  1.1 Access 2013 Introduction
•  1.2 What Are Databases
•  1.3 The Interface Window
•  1.4 Setting Up The Database Part 1
•  1.5 Setting Up The Database Part 2
•  1.6 Creating Forms
•  1.7 Understanding Table Relationships
•  1.8 Introduction To Queries
•  1.9 Introduction To Reports

Access Intermediate

•  2.1 Introduction Table Tools Intermediate
•  2.2 Table Tools Part 2
•  2.3 Table Tools Part 3
•  2.4 Forms And Design Intermediate Part 1
•  2.5 Forms And Design Intermediate Part 2
•  2.6 Forms Data Entry Part 1
•  2.7 Forms Data Entry Part 2
•  2.8 Queries
•  2.9 Reports From Queries Part 1
•  2.10 Reports From Queries Part 2
•  2.11 Reports From Queries Part 3
•  2.12 Specialized Form

Access Advanced

•  3.1 Advance Introduction And Subforms
•  3.2 Subforms
•  3.3 Additional Types Of Queries
•  3.4 Form And Macros Part 1
•  3.5 Form And Macros Part 2
•  3.6 Advance Forms
•  3.7 Reports Advance Part 1
•  3.8 Reports Advance Part 2
•  3.9 Updating Reports
•  3.10 Customization And Conclusion

All necessary materials are included.

Certifications:

The content in the certification course will prepare students to take the associated industry recognized exam.  Please note that the individual state requirements may vary.  Students will be responsible to check with their state’s governing body for state specific requirements.

Upon successful completion of the Microsoft Office Suite course, students will be prepared to choose to sit for one of the Microsoft Office certification exams to become a Microsoft® Office Specialist (MOS).

Only one exam is required for the MOS certification.

System Requirements:

• Cable and DSL internet connections are recommended for the best experience.

• CPU: 1 GHz or higher
• RAM: 2 GB or higher
• Resolution: 1280 x 720 or higher
• Speakers / Headphones
• Microphone (Webinar / Live Online sessions)

• Microsoft Windows 7 or 10 (Home, Pro)
• Mac OSX 10 or higher.
• Latest Chrome OS
• Latest Linux Distributions

NOTE: While we understand that our courses can be viewed on Android and iPhone devices, we do not recommend the use of these devices for our courses. The size of these devices do not provide a good learning environment for students taking online or live online based courses.

• Latest Google Chrome is recommended for the best experience.
• Latest Mozilla FireFox
• Latest Microsoft Edge
• Latest Apple Safari

• Office suite software (Microsoft Office, OpenOffice, or LibreOffice)
• PDF reader program (Adobe Reader, FoxIt)
• Courses may require other software that is denoted in the above course outline.