Proudly serving the D.C. metro
area for over 25 years.


Softek Services, Inc.
1156 15th Street, NW, Suite 100
Washington, DC 20005
(202) 747-5000

Computer Training Software Consulting Database Programming

Get tips on our Facebook Find us on Google+ Tweet Us Read Reviews on Yelp Softek on Linkedin

  • Instructor-led Training Instructor-led Training
  • Join a Public Class Join a Public Class
  • Private Group Classes Private Group Classes
  • Transition Classes Transition Classes
  • Virtual Training Virtual Training
  • Customization & Documentation Customization & Documentation
  • Web and Database Development Web and Database Development
  • We Have Classrooms We Have Classrooms
     

Microsoft Excel for Mac Intermediate

Version 2011

1 Day, 9:00-4:00, 6 Hours

This Instructor-led course, through lecture and hands-on exploration, will teach students the skills needed to work with advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.

Course objectives:

  • Use Advanced Formulas
  • Organize Worksheet and Table Data using Various Techniques
  • Create and Modify Charts
  • Insert and Modify Graphic Objects in a Worksheet
  • Customize and Enhance Workbooks

Calculating Data with Advanced Formulas

  • Apply Cell and Range Names
  • Calculate Data Across Worksheets
  • Use Specialized Functions  
  • Analyze Data with Logical and Lookup Functions

Organizing Worksheet and Table Data

  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Data  
  • Use Functions to Calculate Data
  • Create a PivotTable Report

Presenting Data Using Charts

  • Create a Chart
  • Modify Charts
  • Format Charts

Inserting Graphic Objects

  • Insert and Modify Pictures and Clip Art  
  • Draw and Modify Shapes
  • Illustrate Workflow Using SmartArt Graphics
  • Layer and Group Graphic Objects

Customizing and Enhancing the Excel Environment

  • Customize the Excel Environment  
  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates

View Upcoming Schedule or Register for a Class

Is this the right course for you? Please contact our office at (202) 747-5000 if you have any questions.

Back to Agenda

Investment

Public Class

This class is only offered for private groups.

Private Group Classes

Conducted at Your Office

$1400 flat fee for up to 8 students
$1600 flat fee for up to 12 students
$100 per additional student

Conducted at Softek’s Facility

$1550 flat fee for up to 8 students
$1750 flat fee for up to 12 students
$100 per additional student

Have more or fewer students? Or, need to schedule more than one training day? Fill out our quote request form for a price quote based on your training needs. 

Why choose Softek?

  • Live, in-person training
  • Instructors with 10+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee