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

Administrative Professional with Microsoft Office 2010 Master

George Mason University

Enroll Now!

Have More Questions?
855.520.6806
Career Training Program
Program Code: GES829
Hours: 380
Fees: $2095.00 USD

Outline

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
          iOutlook Online
          ii.  Outlook in Print
          iii.  Advanced Options
          iv.  The Administrator: E-mail Accounts, Setup, Backup

Contact Us

Submit