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

Microsoft Office 2010 Master Certification Training

Union County College

Enroll Now!

Have More Questions?
855.520.6806
Career Training Program
Program Code: GES828
Hours: 300
Fees: $1695.00 USD

Outline

I.  Beginning Microsoft Word
    
1.  Getting Started: How to use the online course
     2.  Go Blue: Formatting Text
     3.  Horses and Zebras: Formatting Pictures
     4.  Mice and Men: Mouse options and tools
     5.  Fancy Colors: Picture Tools
     6.  First Prize: Shapes and SmartArt
     7.  First Impressions: Create Business Stationery

II.  Intermediate Microsoft Word
   
  1.  Rain Washes Out Hamburg: Make a Newsletter
     2.  Open for Business: Building blocks and templates
     3.  The Guests Are Invited: Create a Mail Merge
     4.  Add Me to the List: Advanced Mail Merge and troubleshooting
     5.  Charlotte’s Web Site: Create a Web Page
     6.  Online All the Time: Word and the Internet

III.  Advanced Microsoft Word
    
1.  Table for Two: Advanced Table Functions
     2.  The Table is Set: Quick Tables and Quick Styles for Tables
     3.  Doing It With Style: Create Styles
     4.  Going in Style: Headers and Footers, and References
     5.  Who Done It? Create an On-Line Form
     6.  Prepare to Share: Proofing Tools and Tack Changes
     7.  Working with Macros: Create and use Macros

IV.  Beginning Guide to Microsoft Excel 2010
    
1.  Getting Started: How to use the online course
     2.  Hello, Excel! Enter data and use basic text formatting
     3.  It All Adds Up: enter data, labels and formulas
     4.  A Question of Balance: Use and audit formulas from Excel’s formula library
     5.  Charts and Chart Tools: Insert and modify Charts
     6.  Picture the Data: Insert and format pictures
     7.  Shapes, SmartArt, Views: Insert and modify Shapes and SmartArt, change Views

V.  Intermediate Guide to Microsoft Excel 2010
    
1.  Legs, Eggs, and Pigs: Troubleshooting formulas and data
     2.  Piggy Goes to Market: Use and modify TEXT formulas
     3.  Name that Tune: Create, use and troubleshoot Named Ranges
     4.  Sound Advice: Create and use Lookup Tables, use IF functions
     5.  Excel In Print: Use page Layout and Page Set up to modify print settings
     6.  Excel Online: Use and modify Sparklines and hyperlinks

VI.  Advanced Guide to Microsoft Excel 2010
    
1.  Works for Me! Create and modify Tables and apply Quick Styles
     2.  Work Smarter, Not Harder: Use Sort, Filter, Outline, and Goal Seeking Tools
     3.  What Happened? (Pivot Tables) Create and modify Pivot Tables
     4.  What Did You See (Pivot Charts) Create and modify Pivot Charts and Slicers
     5.  Working Overtime: Create drop-down lists and use Data Validation
     6.  Prepare to Share: Use reviewing tools and permissions
     7.  Working with Macros: Create and use Macros

VII.  Beginning Microsoft PowerPoint
    
1.  Getting Started: How to use the online course
     2.  P is for Paragraph: Entering text in presentations
     3.  Working with Text Boxes: Formatting Shapes and Themes
     4.  Picture, Picture: Formatting Pictures
     5.  Shapes and SmartArt: Formatting and Using SmartArt
     6.  Photo Albums and Views: Create a Photo Album

VIII.  Advanced Microsoft PowerPoint
    
1.  Tables and Spreadsheets: Adding and Using Tables
     2.  Charts and Chart Tools: Adding and Formatting Charts
     3.  Reach for the Starts: Slide Masters and Transitions
     4.  Top Ten Reasons: Apply Animations
     5.  Animating Multimedia: Adding and Formatting Videos
     6.  Show Time: Delivering Presentations
     7.  Prepare to Share: Proof and Protect Presentations
     8.  Live! Online and in Print: Options for saving and sharing

IX.  Microsoft Outlook E-mail
    
1.  Getting Started: How to use the online course
     2.  Hello, Outlook: Formatting Messages
     3.  Messages and Messengers: Message Options
     4.  From Me to You: Graphics, SmartArt and Attachments
     5.  Signed, Seal and Delivered: Organize the Inbox with Rules and Quicksteps
     6.  Contacts and Connections

X.  Working with the Calendar
   
  1.  Eight Days a Week: Scheduling
     2.  Tasks and Time Management

XI.  Sharing, Collaboration and Management
     1.  Outlook Online
     2.  Outlook in Print
     3.  Advanced Options
     4.  The Administrator: E-mail Accounts, Setup, Backup

Contact Us

Submit