« Back to Programs

MOS 20-Hour Fast Track 03/18-04/08/17

Excel is the most widely used spreadsheet application in business today.  Learn more advanced functions and how features in the Data Tab can help you with data analysis, financial analysis and making business decisions.  Our Hybrid course integrates the best features of classroom instruction with online activities that compliment and re-inforce the material.

Course time frame:

• 20 hours total
• 5 hours/week for 4 weeks split evenly between classroom and online learning
  • 2.5 hours classroom Saturday morning
  • 2.5 hours online using Blackboard

Course topics include the following:

1. Advanced Functions

• Logical Functions; IF, AND, OR
• Lookup Functions: VLOOKUP, HLOOKUP, LOOKUP
• Creating Nested Functions
• Cross-worksheet calculations

2. Tables and PivotTables

• Selections and Filtering
• Calculated field options
• Power Pivot and Managing a Data Model

3. Presenting Data Visually

• Conditional Formatting
• Charts
• SmartArt
• PivotCharts
• Slicer
• Timeline

4. Working with External Data

• Importing Text
• Web Queries
• Linking Excel data to other Office documents
• Connecting to a Database

5. Productivity and Customization

• Working with Templates
• Creating and applying Macros

6. Data Tools and Analysis

• Sorting, Filtering and custom sequences
• Performing calculations on filtered data
• Data Validation
• Goal Seek
• Scenario Manager

You can register for the MOS exam by following this link.

Instructor : Frank Asciutto
Dates : 03/18/17 to 04/08/17
Days : Sat,Online
From : 9:00 AM - 2:30 PM
Fee : $ 450.00
Course Number : T126

Class is unavailable at this time please call 973-720-2354 for more information or other course options

« Back to Programs