|
Word 2007/2010 Part 1
Overview: Introduction to creating and
editing documents in Microsoft Word. Students will learn how to apply
character and paragraph formatting in order to create professional looking
letters and reports etc.
Topics Covered:
Word basics
Creating documents
Editing documents
Formatting documents
Sections
Writing tools
Drawing tools
Duration: 6 hrs
Word 2007/2010 Part 2
Overview: Intermediate
features of Word.
Topics Covered:
Intermediate editing & formatting
Tables
Columns
Styles & Templates
Outlines
Reports
Internet features
Additional features
Duration: 6 hrs
Word 2007/2010 Part 3
Overview: Advanced features in Word.
Topics Covered:
Advanced editing & formatting
Advanced tables
Advanced reports
Charts & pictures
Mail merge
Forms
Workgroup projects
More advanced features
Duration: 6 hrs
Excel 2007/2010 Part 1
Overview: Introduction to data
analysis in Microsoft Excel. Students will learn basic spreadsheet skills
and how to manipulate data in electronic spreadsheets.
Topics Covered:
Excel basics
Modifying worksheets
Creating formulas
Building worksheets
Worksheet shortcuts
Enhancing worksheets
Printing
Excel functions
Duration: 6 hrs
Excel
2007/2010 Part 2
Overview: Intermediate features of Excel.
Topics Covered:
Intermediate editing & formatting
Absolute & mixed referencing
More advanced functions
Charting
Linking worksheets
Worksheet display
Internet features
Additional features
Duration: 6 hrs
Excel 2007/2010 Part 3
Overview: Advanced features of Excel
Topics Covered:
Advanced editing & formatting
Named ranges
Lookup functions
Templates
Auditing
Linking workbooks
Analyzing data/Pivot Tables
Importing/exporting data
Duration: 6 hrs
Excel
2007/2010 Collaboration & Macros
Overview: This half-day course
examines workgroup and security features of Excel as well as creating basic
macros.
Topics Covered:
Tracking changes
Protecting and sharing workbooks
Merging revised copies of workbooks
Creating personal & workbook macros
Creating a macros toolbar & menu bar
Duration:
3.5 hrs
Access 2007/2010 Part 1
Overview: Introduction to creating
databases in Microsoft Access. Students will learn how to create and use database
objects, including tables, queries, forms, and reports.
Topics Covered:
Access basics
Creating a database
Tables
Forms
Modifying & manipulating data
Filters & queries
Reports
Additional features
Duration: 6 hrs
Access
2007/2010 Part 2
Overview: Intermediate & Advanced features of Access.
Topics Covered:
Modifying the design of a table
Working with multiple tables
Relating tables
Working with a custom form
Further query techniques
Further report techniques
Macros and the Switchboard
Additional features
Duration: 6 hrs
PowerPoint
2007/2010 Part 1
Overview: Introduction to creating
presentations in Microsoft PowerPoint. Students will learn how to create
and edit slides, incorporate clip art, charts, and run a slide show.
Topics Covered:
PowerPoint basics
Creating slides
Drawing
Tables
Charts
Clip art
Design templates
Slide shows
Additional features
Duration: 6 hrs
PowerPoint
2007/2010 Part 2
Overview: Advanced features of PowerPoint.
Topics Covered:
Using data from other applications
Organization chart
Adding special effects to text
Autoshapes
Including sounds & movies
Slide show techniques
Working with other PowerPoint users
Additional features
Duration: 6 hrs
Outlook 2007/2010 Part 1
Overview: Introduction to Microsoft
Outlook. Students will learn the fundamentals of Outlook office software.
Topics Covered:
Outlook basics
Sending & receiving mail
Manipulating & managing mail
Calendar & scheduling
Contacts
Tasks
Journal
Notes
Duration: 6 hrs
Outlook
2007/2010 Part
2
Overview: Advanced features of Outlook
Topics Covered:
Inbox & contacts folder
Tasks & calendars folders
Creating MS Office documents from Outlook
Customizing Outlook
Duration: 6 hrs
|