Help Icon


Course Title
Administrative Professional with Microsoft Office 2010 Master


This unique program will give you the skills you need to be a successful administrative professional, as well as a master of Microsoft's suite of programs. The Microsoft Office 2010 Master program is the only comprehensive, performance-based certification program approved by Microsoft to validate business computer skills using Excel, Word, PowerPoint, and Outlook. Offered in partnership with ed2go.


Upon successful completion of this course, you'll be able to:

  • Determine how to effectively set goals and make administrative decisions
  • Understand business etiquette
  • Communicate effectively, both verbally and in writing
  • Engage in collaborative planning, communication, and research
  • Create and format professional business documents, including mail merges, Web pages, and interactive forms
  • Create and edit formulas, audit equations, and present information in charts and tables
  • Create and edit Outlook objects, such as e-mail, meetings, tasks, and contacts
  • Create and modify slide presentations, including editing graphics, formatting text and text boxes, and animating objects and transitions


I. Administrative Professional
   A. The Dynamic Workplace
        i. The Workplace—Constantly Changing
        ii. Workplace Team and Environment
        iii. The Virtual Workplace
   B. Workforce Behaviors
        i. Your Professional Image
        ii. Anger, Stress, and Time Management
        iii. Ethical Theories and Behaviors
   C. Communication Essentials
        i. Written Communications
        ii. Verbal Communication and Presentations
        iii. Customer Service
   D. Technology Basics
        i. Technology Update
        ii. Workplace Mail and Copying
        iii. Telecommunications—Technology and Etiquette
   E. Records and Financial Management
        i. Managing Records
        ii. Personal Finance
   F. Meetings and Travel
        i. Event Planning
        ii. Travel Arrangements
   G. Career Advancement
        i. Job Search and Advancement
        ii. Leadership

II. Microsoft Office 2010 Master
    A. Beginning Microsoft Word
         i. Getting Started: How to use the online course
         ii. Go Blue: Formatting Text
         iii. Horses and Zebras: Formatting Pictures
         iv. Mice and Men: Mouse options and tools
         v. Fancy Colors: Picture Tools
         vi. First Prize: Shapes and SmartArt
         vii. First Impressions: Create Business Stationery
    B. Intermediate Microsoft Word
         i. Rain Washes Out Hamburg: Make a Newsletter
         ii. Open for Business: Building blocks and templates
         iii. The Guests Are Invited: Create a Mail Merge
         iv. Add Me to the List: Advanced Mail Merge and troubleshooting
         v. Charlotte’s Web Site: Create a Web Page
         vi. Online All the Time: Word and the Internet
    C. Advanced Microsoft Word
         i. Table for Two: Advanced Table Functions
         ii. The Table is Set: Quick Tables and Quick Styles for Tables
         iii. Doing It With Style: Create Styles
         iv. Going in Style: Headers and Footers, and References
         v. Who Done It? Create an On-Line Form
         vi. Prepare to Share: Proofing Tools and Tack Changes
         vii. Working with Macros: Create and use Macros
    D. Beginning Guide to Microsoft Excel 2010
         i. Getting Started: How to use the online course
         ii. Hello, Excel! Enter data and use basic text formatting
         iii. It All Adds Up: enter data, labels and formulas
         iv. A Question of Balance: Use and audit formulas from Excel's formula library
         v. Charts and Chart Tools: Insert and modify Charts
         vi. Picture the Data: Insert and format pictures
         vii. Shapes, SmartArt, Views: Insert and modify Shapes and SmartArt, change Views
    E. Intermediate Guide to Microsoft Excel 2010
         i. Legs, Eggs, and Pigs: Troubleshooting formulas and data
         ii. Piggy Goes to Market: Use and modify TEXT formulas
         iii. Name that Tune: Create, use and troubleshoot Named Ranges
         iv. Sound Advice: Create and use Lookup Tables, use IF functions
         v. Excel In Print: Use page Layout and Page Set up to modify print settings
         vi. Excel Online: Use and modify Sparklines and hyperlinks
    F. Advanced Guide to Microsoft Excel 2010
         i. Works for Me! Create and modify Tables and apply Quick Styles
         ii. Work Smarter, Not Harder: Use Sort, Filter, Outline, and Goal Seeking Tools
         iii. What Happened? (Pivot Tables) Create and modify Pivot Tables
         iv. What Did You See (Pivot Charts) Create and modify Pivot Charts and Slicers
         v. Working Overtime: Create drop-down lists and use Data Validation
         vi. Prepare to Share: Use reviewing tools and permissions
         vii. Working with Macros: Create and use Macros
    G. Beginning Microsoft PowerPoint
         i. Getting Started: How to use the online course
         ii. P is for Paragraph: Entering text in presentations
         iii. Working with Text Boxes: Formatting Shapes and Themes
         iv. Picture, Picture: Formatting Pictures
         v. Shapes and SmartArt: Formatting and Using SmartArt
         vi. Photo Albums and Views: Create a Photo Album
    H. Advanced Microsoft PowerPoint
         i. Tables and Spreadsheets: Adding and Using Tables
         ii. Charts and Chart Tools: Adding and Formatting Charts
         iii. Reach for the Starts: Slide Masters and Transitions
         iv. Top Ten Reasons: Apply Animations
         v. Animating Multimedia: Adding and Formatting Videos
         vi. Show Time: Delivering Presentations
         vii. Prepare to Share: Proof and Protect Presentations
         viii. Live! Online and in Print: Options for saving and sharing
    I. Microsoft Outlook E-mail
         i. Getting Started: How to use the online course
         ii. Hello, Outlook: Formatting Messages
         iii. Messages and Messengers: Message Options
         iv. From Me to You: Graphics, SmartArt and Attachments
         v. Signed, Seal and Delivered: Organize the Inbox with Rules and Quicksteps
         vi. Contacts and Connections
    J. Working with the Calendar
        i. Eight Days a Week: Scheduling
        ii. Tasks and Time Management
    K. Sharing, Collaboration and Management
         i. Outlook Online
         ii. Outlook in Print
         iii. Advanced Options
         iv. The Administrator: E-mail Accounts, Setup, Backup

Method of Instruction



Class participation