Microsoft Office for Professional Users

Hours: 32 / Access Length: 7 Weeks / Delivery: Monthly, Mentor Supported
Retail Price: $375.00

Course Overview:

Students will advance their Microsoft Office skills by exploring more advanced topics in Word, Excel and Access. In Word students will create newsletters, web pages and macros. In Excel, students will create 3-D workbooks and link Excel files, create formulas using the financial functions, manage worksheets that contain databases and create macros. In Access, students will create relational databases, and create queries, forms and reports that use relational databases. Students will be introduced to Access macros and VBA. Students will need a basic understanding of Word, Excel and Access to complete this class. Students will need a copy of Office. A 30-day trial version is available.

ATTENTION: This course has a strict start and end date.  When a student enrolls into this course, they will need to work with one of our Training Assessment Managers (TAMs) to choose a start date before they can be enrolled in their course.

Course Outline:

• Students will demonstrate what they can do with Microsoft Office
• Students will use Microsoft Word to present and manipulate information in columns and tables.
• Students will add graphics, equations and charts to their Word documents.
• Students will use formulas and functions and dress up the appearance of their spreadsheets.
• Students will filter and subtotal list data.
• Students will add visual elements including charts and SmartObjects to their presentations.
• Students will explore options for presenting with PowerPoint.
• Students will use Outlook to manage their schedule and tasks.
• Students will create forms and define queries.
• Students will use OneNote to create notebooks and create and manage notes.
• Students will create a final project using what they learned in the class.

All necessary materials are included.

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.