Training Course:Microsoft Office Specialist (Certificate)School/Trainer:University of Alabama College of Continuing Studies
Tuscaloosa, Alabama, United States
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Level 1-Beginning Windows
At the end of this unit, the student will be able to: Highlight text in document, Apply font formats: bold, italic, underline, Use the Spelling and Grammar checker (commands), Highlight text in document, understand beginning hardware troubleshooting, file management and administration features/procedures.
Level 2-Beginning Word
At the end of this unit, the student will be able to: Cut, copy, and paste, Insert pictures from ClipArt Menus: Edit Undo, Redo, Copy, Paste, Insert Picture Activity: Drag and drop editing, Move text, Insert ClipArt, and Resize pictures
Level 3-Beginning Word
At the end of this unit, the student will be able to: Insert date and time, Insert picture from file, Format font and font size, File Save As a template
Level 4-Beginning Word
At the end of this unit, the student will be able to: Locate and insert an existing document, Format newspaper columns, Use Paste Special Beginning Excel: Enter text, dates and numbers, Use AutoFill, Use the Chart Wizard, Modify Charts.
Level 5-Beginning Excel
At the end of this unit, the student will be able to: Format font styles (size, color, and styles), Apply number formats (currency, percent), Format borders and shading, Use AutoSum, Insert and delete rows or columns, Hide and unhide rows and columns, Set up headers and footers, Use references (relative), Use Functions: Average and IF
Level 6-Intermediate Word
At the end of this unit, the student will be able to: Use advanced text alignment, Use Mail Merge: Create main document, Create data source, Sort records to be merged, Merge the document and data. Intermediate Excel: Single and multilevel sorts
Level 7-Intermediate Word
At the end of this unit, the student will be able to: Create and format tables, Add borders and shading, Merge Cells, Save as a Web Page, Create Hyperlinks, Use Design Gallery Live, Practice Working with TABS Using Bookmarks with Hyperlinks
Level 8-Outlook
At the end of this unit, the student will be able to: Read, Compose and Address Mail, Use Address Book, Use mail features: Forward, Reply and Recall, Flag Mail messages, Send Mail, Work with attachments, Work with Contacts, Create a Distribution List, Use Inbox Rules, Handle Junk Mail, Archive Outlook, Instant Messaging
Level 9-Intermediate Excel
At the end of this unit, the student will be able to: Schedule appointments, Schedule events, Recurring appointments, Add and remove attendees. Plan meetings with others, Track the responses, Create Tasks, Assign a task, Work with the Journal, Find an appointment, Customize the calendar view. Intermediate Excel: Use Conditional Formatting, Merge and Center Cells, Use references (relative), Create form controls
Level 10-Intermediate Excel
At the end of this unit, the student will be able to: Rename a worksheet, Copy or Move worksheets, Link worksheets and consolidate data. Advanced Excel: Use Relative References, Absolute References, Work with Scenarios, Use Goal Seek, Use the Auditing Toolbar to trace errors. Calculate Revenue, Create a grand total from several spreadsheets, Understand Absolute and Relative References
Level 11-Beginning PowerPoint
At the end of this unit, the student will be able to: Navigate different views, Create a presentation from a template or a wizard, Use the Outline View, Use Bullets and numbers, Work with Graphics, Work with text boxes, Use the Slide Sorter, Add slide transitions, View the Slide Show, Modify the Slide Master, Insert headers and footers, Apply formatting, Add and group shapes, Animate text and objects, Custom Animation, Animation Effects, On screen navigation tools, Add and Print speaker notes.
Level 12-Advanced Word and Excel
At the end of this unit, the student will be able to: Create and modify forms, Make controls: Drop Down Lists, Date and Time Fields, Protect the document, Activity: Create an on-line form with drop down lists and default text values. Advanced Excel: Create a PivotTable, Use PivotTable auto format, Analyze data with a PivotTable.
Level 13-Advanced Topics
At the end of this unit, the student will be able to: Create and edit styles, Create a Table of Contents, Use Headers and Footers, Create Section Breaks, Use the Document Map. Advanced Excel: Filter the Data, Create Subtotals, Group and Outline Data, Use the VLookup Function
Level 14- Advanced PowerPoint
At the end of this unit, the student will be able to: Use advanced formatting and design, Add new slides from an Outline, from Word, from another presentation, Modify the slide design, customize a presentation with sound, narration, and action buttons. Prepare a presentation for different formats: speaker, kiosk, CD.
Level 15: Beginning Access
At the end of this unit, the student will be able to: Use and design tables, forms, and queries in Microsoft Access, create Queries to find and select records by criteria, write and test update queries.
Level 16: Intermediate Access
At the end of this unit, the student will be able to: Create forms with subforms to represent one-to-many relationships, use criteria, parameters, concatenation, and operators in Query designs: calculate with DateDif(),Left(), and IIF(), improve report designs with Sorting and Grouping.
Level 17: Advanced Access
At the end of this unit, the student will be able to: link information and automate data entry, create a Search Form that uses a Combo Box to filter the records, use Microsoft Access and Word together in a Mail Merge, as well as publish an Access report to Word, optimize a database for multiple users.
...''
Elements of this syllabus are subject to change.
Please go to the school's official website for training price and schedule:
http://www.ccs.ua.edu/
Phone:205-348-6222
School Address:
College of Continuing Studies Professional Development & Conference Services
Box 870388 Tuscaloosa, Alabama 35487-0388 USA
Jobs & Resumes: Tuscaloosa
Houses & Roommates: Tuscaloosa
Search other schools for Microsoft Office Specialist training resources.
Other training courses offered by University of Alabama College of Continuing Studies:
Certified Global Business Professional
Certified Bookkeeper
Business Marketing Design
QuickBooks
AutoCAD 2009
AutoCAD 2007
Insurance Prelicense
Advanced Hospital Coding and CCS Prep
Advanced Coding for the Physician’s Office
Administrative Professional
Microsoft Certified Application Specialist
Administrative Medical Specialist with Medical Billing and Coding
Administrative Dental Assistant
Chemical Plant Operations
CCENT
CCNA
Coding, Reimbursement, and Documentation for Physicians
A+
Linux+
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Facts:
We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day. |
|
|
