Microsoft Excel Functions 3.1

Share With Your Friends

This class will cover Excel functions that help manage advanced calculations and data manipulation.  While an experienced Excel user could most likely make “something” work, the functions covered will make many situations more efficient.  This course tends to be intense and fast-paced and may include troubleshooting problems as they arise (as is common in the Excel environment.)  Attendees are encouraged to be proactive and come with questions related to their own Excel questions.

Although this course is designed for Excel 2013 2010, many participants find the content transferrable to Office 2007 through Office 2013.  Please check with the Instructor or BTC office before registering if you have any questions since it easier to answer your concerns before the class begins than finding out the class content is not what you are looking for.  Designed for PC based computers (sorry not for Mac/Apple).

Functions covered (these functions are typical and may change slightly based on participant need):

  • If
  • And
  • SumIf
  • SumProduct
  • VLookup
  • Text functions used primarily for cleaning up data, often imported from another source
  • Time and date functions used primarily for re-formatting data that has been imported

Prerequisites: MS Excel 2  or instructor permission.

Fall 2016 Dates:

  • November 2 & 4, 9 am – noon
  • December 7 & 9, 9 am – noon

​Spring 2017 Dates:

  • March 8 & 10, 1 – 4 pm
  • July 24 & 25, 9 am – noon

Price:  $125

Register Today!

Business & Industry Training
31 College Drive
Concord, NH 03301-7412
(603) 230-4022
Fax: (603) 230-9304
nhtibtc@ccsnh.edu
Office of Workforce Development