Upon successful completion of this course, students will be able to:
The Environment
Document Basics
Editing Text
Format Text
Building Tables
Working with Images
Modifications
Upon successful completion of this course, the student will be able to:
Basic-Intermediate Levels
Excel Formula basics
The five most used formulas
Multiple Excel Worksheets & Workbooks
Using multiple workbooks
Linking worksheets using 3-D formulas
Linking workbooks
Excel Advanced Formatting
Using special number formats
Using formatting functions
Working with styles
Working with themes
Excel Outlining and Sub totalling
Outlining and consolidating data
Creating subtotals
Upon successful completion of this course, students will be able to:
Create a new publication
Use a template or a blank page
Learn how to align, group and arrange objects of all types
Incorporate picture tools and modify those images
Insert, fit and format pictures including clip art
Prepare pictures for publication
Use other office programs to make advanced edits
Organize information using tables, a grid of columns and rows
Insert, modify and change the appearance of tables
Learn the advantages and disadvantages of Publisher
Learn how to work with the Publisher Environment
Learn use of the Viewing Tools
Review the “backstage view” or file menu
Learn how to create a new publisher
Work with text in Publisher
Incorporate and use shapes and objects
Practice how to use pictures in their publications
Insert and use tables in their publications
Learn about the Publisher Interface
Consider layouts, print supplies, printing and converting to PDF
Upon successful completion of this course, students will be able to:
Review Ribbon Tabs and locate the new 2013 features
Divide slide shows into section
Set up slide transitions
Animate slide elements
Associate multiple animations with the same element
Use the animations painter
Apply advanced animation techniques to your slides
Embed an audio file in a slide show presentation
Modify an embedded audio file
Embed an audio file in a slide show presentation
Modify a video file in a slide show presentation
Modify an embedded video file a video file
Compress embedded media
Prepare a slide show into a video
Convert a slide show into a video
Broadcast a slide show
Describe Outlook’s mail view
Create an email message
Differentiate between HTML, RTF and plain text message formats
Use automatic formatting and templates
Send email messages
Attach files to messages
Create and use signatures
Describe how Outlook receives messages
Preview email attachments
Use desktop alerts
Reply to and forward messages you receive
Send and receive messages with multiple email accounts
Change your default email account
Use send/receive groups
Define new send/receive groups
Edit send/receive group settings
Explain how grouping messages makes email more efficient
Group messages for conversations
Create folders for email messages
Explain the importance of message handling rules
Create rules
Organize rules
Flag an email message
Navigate within the Contacts view of Outlook
Create a new contact from scratch
Create a new contact from an email message
Import an electronic business card
Flag a contact for follow-up
Categorize your contacts
Work with vCards
Search for a specific contact
Prevent the duplication of contacts
Build an Outlook distribution list
Send an email message to an entire distribution or only to select members of the list
Send a distribution list via email
Upon successful completion of this course, students will be able to:
Exploring the Access Environment
Building Tables
Retrieving the Data You Want
Working with Forms
Designing Reports