CALL NOW!
855.520.6806
  • TRAINING PROGRAMS
  • FINANCIAL ASSISTANCE
  • MILITARY
  • LOGIN

Microsoft Office Specialist 2010 (MOS) Certification Training

College of Staten Island - CUNY

Enroll Now!

Have More Questions?
855.520.6806
Career Training Program
Program Code: GES906
Hours: 380
Fees: $1995.00 USD

Outline

I. Beginning Microsoft Word

a) Getting Started: How to use the online course

b) Go Blue: Formatting Text

c) Horses and Zebras: Formatting Pictures

d) Mice and Men: Mouse options and tools

e) Fancy Colors: Picture Tools

f) First Prize: Shapes and SmartArt

g) First Impressions: Create Business Stationery

II. Intermediate Microsoft Word

a) Rain Washes Out Hamburg: Make a Newsletter

b) Open for Business: Building blocks and templates

c) The Guests Are Invited: Create a Mail Merge

d) Add Me to the List: Advanced Mail Merge and troubleshooting

e) Charlotte’s Web Site: Create a Web Page

f) Online All the Time: Word and the Internet

III. Advanced Microsoft Word

a) Table for Two: Advanced Table Functions

b) The Table is Set: Quick Tables and Quick Styles for Tables

c) Doing It With Style: Create Styles

d) Going in Style: Headers and Footers, and References

e) Who Done It? Create an On-Line Form

f) Prepare to Share: Proofing Tools and Tack Changes

g) Working with Macros: Create and use Macros

IV. Beginning Guide to Microsoft Excel 2010

a) Getting Started: How to use the online course

b) Hello, Excel! Enter data and use basic text formatting

c) It All Adds Up: enter data, labels and formulas

d) A Question of Balance: Use and audit formulas from Excel’s formula library

e) Charts and Chart Tools: Insert and modify Charts

f) Picture the Data: Insert and format pictures

g) Shapes, SmartArt, Views: Insert and modify Shapes and SmartArt, change Views

V.  Intermediate Guide to Microsoft Excel 2010

a) Legs, Eggs, and Pigs: Troubleshooting formulas and data

b) Piggy Goes to Market: Use and modify TEXT formulas

c) Name that Tune: Create, use and troubleshoot Named Ranges

d) Sound Advice: Create and use Lookup Tables, use IF functions

e) Excel In Print: Use page Layout and Page Set up to modify print settings

f) Excel Online: Use and modify Sparklines and hyperlinks

VI. Advanced Guide to Microsoft Excel 2010

a) Works for Me! Create and modify Tables and apply Quick Styles

b) Work Smarter, Not Harder: Use Sort, Filter, Outline, and Goal Seeking Tools

c) What Happened? (Pivot Tables) Create and modify Pivot Tables

d) What Did You See (Pivot Charts) Create and modify Pivot Charts and Slicers

e) Working Overtime: Create drop-down lists and use Data Validation

f) Prepare to Share: Use reviewing tools and permissions

g) Working with Macros: Create and use Macros

VII. Beginning Microsoft PowerPoint

a) Getting Started: How to use the online course

b) P is for Paragraph: Entering text in presentations

c) Working with Text Boxes: Formatting Shapes and Themes

d) Picture, Picture: Formatting Pictures

e) Shapes and SmartArt: Formatting and Using SmartArt

f) Photo Albums and Views: Create a Photo Album

VIII. Advanced Microsoft PowerPoint

a) Tables and Spreadsheets: Adding and Using Tables

b) Charts and Chart Tools: Adding and Formatting Charts

c) Reach for the Starts: Slide Masters and Transitions

d) Top Ten Reasons: Apply Animations

e) Animating Multimedia: Adding and Formatting Videos

f) Show Time: Delivering Presentations

g) Prepare to Share: Proof and Protect Presentations

h) Live! Online and in Print: Options for saving and sharing

IX. Microsoft Outlook E-mail

a) Getting Started: How to use the online course

b) Hello, Outlook: Formatting Messages

c) Messages and Messengers: Message Options

d) From Me to You: Graphics, SmartArt and Attachments

e) Signed, Seal and Delivered: Organize the Inbox with Rules and Quicksteps

f) Contacts and Connections 

X. Working with the Calendar

a) Eight Days a Week: Scheduling

b) Tasks and Time Management

XI. Sharing, Collaboration and Management

a) Outlook Online

b) Outlook in Print

c) Advanced Options

d) The Administrator: Email Accounts, Setup, Backup

XII. Beginning Microsoft Access

a) Getting Started: How to use the online course

b) Hello, Access: Introduction to Tables

c) Tables and Table Design: Adding Fields

d) Table and More Tables: Design View

e) Forms and Form Design: Layout View

f) Designing for Real Users: Edit the Form Properties

g) Queries and Query Design: Ask questions

h) More Queries: Use Criteria and Parameters

i) Reports and Report Design: Layout View

j) Reports and More Reports: Use Design View

k) Managing Databases: Save and Save As

XIII. Intermediate Microsoft Access

a) Hello, Again, Hello: Introduction to one-to-many relationships

b) One-From-Many Relationships: Create a Combo Box

c) Forms and Subforms, Part 1: Representing one-to-many

d) Forms and Subforms, Part 2: Creating the Search Form

e) Forms and Subforms, Part 3: Link the Form and Subform

f) Meet the Stars: Create a Switchboard Form

g) The Opening Scene: Manage the database environment

h) Dress Rehearsal: How to TEST your software

i) Report Totals: Use a Query to calculate the Total

j) Report Design Options: Use Design View

XIV. Advanced Microsoft Access

a) You say Goodbye, and I say Hello!: Normalize a database

b) Relating Tables in a Database: Key data

c) Primary Keys and Relationships

d) The Receipt Form, Part 1: Design the Subform

e) The Receipt Form, Part 2: Design the Form and link the two Forms

f) The Receipt Printout, Part 1: Design the Report

g) The Receipt Print, Part 2: Design the Subreport and link the two Reports

h) The Producers: Working with Dates

i) Prepare to Share: Visualize the results and export the Reports

j) Strategies for Archiving: Use Action Queries

k) The Performance Network: Optimize for Multi-Users

Contact Us

Submit