Complete Microsoft Office Bundle

COURSE CURRICULUM

Microsoft Word

• Identify the Components of the Word Interface
• Create a Word Document
• Help
• Navigate and Select Text
• Modify Text
• Find and Replace Text
• Apply Character Formatting
• Align Text Using Tabs
• Display Text as List Items
• Control Paragraph Layout
• Apply Borders and Shading
• Apply Styles
• Manage Formatting
• Insert a Table
• Modify a Table
• Format a Table
• Convert Text to a Table
• Sort a List
• Renumber a List
• Customize a List
• Insert Symbols and Special Characters
• Add Images to a Document
• Apply a Page Border and Color
• Add a Watermark
• Add Headers and Footers
• Control Page Layout
• Check Spelling and Grammar
• Other Proofing Tools
• Check Accessibility
• Customize the Word Interface
• Additional Save Options
• Manage Additional File Types
• Activities – Microsoft Word 2016 for Beginners

Microsoft Excel

• Identify the Elements of the Excel Interface
• Activity – Identify the Elements of the Excel Interface
• Create a Basic Worksheet
• Activity – Create a Basic Worksheet
• Use the Help System
• Activity – Use the Help System
• Create Formulas in a Worksheet
• Activity – Create Formulas in a Worksheet
• Insert Functions in a Worksheet
• Activity – Insert Functions in a Worksheet
• Reuse Formulas
• Activity – Reuse Formulas
• Manipulate Data
• Activity – Manipulate Data
• Insert, Manipulate, and Delete Cells, Columns, and Rows
• Activity – Insert, Manipulate, and Delete Cells, Columns, and Rows
• Search For and Replace Data
• Activity – Search For and Replace Data
• Spell Check a Worksheet
• Activity – Spell Check a Worksheet
• Modify Fonts
• Activity – Modify Fonts
• Add Borders and Colors to Cells
• Activity – Add Borders and Colors to Cells
• Apply Number Formats
• Activity – Apply Number Formats
• Align Cell Contents
• Activity – Align Cell Contents
• Apply Cell Styles
• Activity – Apply Cell Styles
• Define the Basic Page Layout for a Workbook
• Activity – Define the Basic Page Layout for a Workbook
• Refine the Page Layout and Apply Print Options
• Activity – Refine the Page Layout and Apply Print Options
• Format Worksheet Tabs
• Activity – Format Worksheet Tabs
• Manage Worksheets
• Activity – Manage Worksheets
• Manage the View of Worksheets and Workbooks
• Activity – Manage the View of Worksheets and Workbooks
• Customize General and Language Options
• Activity – Customize General and Language Options
• Customize Formula Options
• Activity – Customize Formula Options
• Customize Proofing and Save Options
• Activity – Customize Proofing and Save Options
• Customize the Ribbon and Quick Access Toolbar
• Activity – Customize the Ribbon and Quick Access Toolbar
• Customize the Functionality of Excel by Enabling Add-Ins
• Activity – Customize the Functionality of Excel by Enabling Add-Ins
• Customize Advanced and Trust Center Options
• Activity – Customize Advanced and Trust Center Options
• Activities and Exercise Files – Microsoft Excel 2016 for Beginners

Microsoft PowerPoint

• Navigate the PowerPoint Environment
• ACTIVITY – NAVIGATING THE POWERPOINT 2016 USER INTERFACE
• Create and Save a PowerPoint Presentation
• ACTIVITY – CREATING AND SAVING A POWERPOINT PRESENTATION
• Use Help
• ACTIVITY – USING POWERPOINT HELP
• Select a Presentation Type
• ACTIVITY – SELECTING A PRESENTATION TYPE
• Build a Presentation
• ACTIVITY – BUILDING A PRESENTATION
• Lay Out a Presentation
• ACTIVITY – LAYING OUT A PRESENTATION
• Edit Text
• ACTIVITY – EDITING TEXT
• View and Navigate a Presentation
• ACTIVITY – VIEWING A PRESENTATION
• Format Characters
• ACTIVITY – FORMATTING CHARACTERS
• Format Paragraphs
• ACTIVITY – FORMATTING PARAGRAPHS
• Format Text Boxes
• ACTIVITY – FORMATTING TEXT BOXES
• Insert Images
• ACTIVITY – INSERTING IMAGES
• Insert Shapes
• ACTIVITY – INSERTING SHAPES
• Insert WordArt
• ACTIVITY – INSERT WORDART
• Edit Objects
• ACTIVITY – EDITING OBJECTS
• Format Objects
• ACTIVITY – FORMATTING OBJECTS
• Group Objects
• ACTIVITY – GROUPING OBJECTS
• Arrange Objects
• ACTIVITY – ARRANGING OBJECTS
• Animate Objects
• ACTIVITY – ANIMATING OBJECTS
• Create a Table
• ACTIVITY – CREATING A TABLE
• Format a Table
• ACTIVITY – FORMATTING A TABLE
• Insert a Table from Other Microsoft Office Applications
• ACTIVITY – INSERTING A TABLE FROM MICROSOFT EXCEL
• Create a Chart
• ACTIVITY – CREATING A CHART
• Format a Chart
• ACTIVITY – FORMATTING A CHART
• Manipulate a Chart
• ACTIVITY – MANIPULATING A CHART
• Insert a Chart from Microsoft Excel
• ACTIVITY – INSERTING A CHART FROM MICROSOFT EXCEL
• Review Your Presentation
• ACTIVITY – REVIEWING YOUR PRESENTATION
• Apply Transitions
• ACTIVITY – APPLYING TRANSITIONS
• Print Your Presentation
• ACTIVITY – PRINTING YOUR PRESENTATION
• Deliver Your Presentation
• ACTIVITY – DELIVERING YOUR PRESENTATION
• Activities – Microsoft PowerPoint 2016 for Beginners

Microsoft Outlook

• Navigate the Outlook Interface
• ACTIVITY – NAVIGATING THE OUTLOOK INTERFACE
• Perform Basic E-mail Functions
• ACTIVITY – PERFORMING BASIC E-MAIL FUNCTIONS
• Use Outlook Help
• ACTIVITY – GETTING HELP IN MICROSOFT OUTLOOK 2016
• Create an E-mail Message
• ACTIVITY – CREATING AN E-MAIL MESSAGE
• Check Spelling and Grammar
• ACTIVITY – CHECK SPELLING AND GRAMMAR
• Format Message Content
• ACTIVITY – FORMAT MESSAGE CONTENT
• Attach Files and Items
• ACTIVITY – ATTACHING A FILE TO A MESSAGE
• Enhance an E-mail Message
• ACTIVITY – ENHANCING AN E-MAIL MESSAGE
• Manage Automatic Message Content
• ACTIVITY – MANAGING AUTOMATIC MESSAGE CONTENT
• Customize Reading Options
• ACTIVITY – CUSTOMIZING READING OPTIONS
• Work with Attachments
• ACTIVITY – WORKING WITH ATTACHMENTS
• Manage Your Message Responses
• ACTIVITY – MANAGING YOUR MESSAGE RESPONSES
• Manage Messages Using Tags, Flags, and Other Commands
• ACTIVITY – MANAGING MESSAGES USING TAGS, FLAGS AND OTHER COMMANDS
• Organize Messages Using Folders
• ACTIVITY – ORGANIZING MESSAGES USING FOLDERS
• View the Calendar
• ACTIVITY – CUSTOMIZING YOUR CALENDAR VIEW
• Manage Appointments
• ACTIVITY – MANAGING APPOINTMENTS
• Manage Meetings
• ACTIVITY – CREATING AND MANAGING MEETINGS
• Print Your Calendar
• ACTIVITY – PRINTING YOUR CALENDAR
• Create and Update Contacts
• ACTIVITY – CREATING AND UPDATING CONTACTS
• View and Organize Contacts
• ACTIVITY – VIEW AND ORGANIZE CONTACTS
• Create Tasks
• ACTIVITY – CREATING TASKS
• Manage Tasks
• ACTIVITY – MANAGING TASKS
• Manage Notes
• ACTIVITY – CREATING AND MANAGING NOTES
• Customize the Outlook Interface
• ACTIVITY – CUSTOMIZING THE OUTLOOK INTERFACE
• Create and Manage Quick Steps
• ACTIVITY – CREATING AND MANAGING QUICK STEPS
• Activities – Microsoft Outlook 2016 for Beginners

Microsoft Access

• Orientation to Microsoft Access
• Create a Simple Access Database
• Get Help in Microsoft Access
• Modify Table Data
• Working With Records
• Sort and Filter Records
• Create Lookups
• Join Data from Different Tables in a Query
• Sort and Filter Data in a Query
• Perform Calculations in a Query
• Create Parameter Queries
• Create Action Queries
• Create Find Duplicate and Find Unmatched Queries
• Summarize Data
• Create a Report
• Add Controls to a Report
• Enhance the Appearance of a Report
• The Access Options Dialog Box
• Create a Table
• Modify a Table and Fields
• Create Table Relationships
• Create Query Joins
• Join Tables That Have No Common Fields
• Relate Data within a Table
• Work with Subdatasheets
• Create Subqueries
• Data Normalization
• Create a Junction Table
• Import Data into Access
• Export Data to Text File Formats
• Export Access Data to Excel
• Create a Mail Merge
• Organize Report Information
• Format Reports
• Include Charts in a Report
• Add a Calculated Field to a Report
• Add a Subreport to an Existing Report
• Create a Mailing Label Report
• Publish a Report as PDF
• Activities – Microsoft Access 2016 for Beginners

Word Templates

• Word Templates

Excel Templates

• Excel Templates

PowerPoint Templates

• PowerPoint Templates

Mock Exam
Final Exam