Start Date: October 30,31, November 1,2, 2017

Mon-Thurs – 6:00 – 9:00 pm, 4 nights

Location: Concord High School

Room: W3112

Instructor: James Ramanek

Objective:

  • To learn new functions (If, Vlookup, Hlookup, Value, Date, Text functions, nested functions, logical operators)
  • Provide insight into constructing complex formulas and functions
  • To learn how to use linking formulas to link worksheets and files
  • How to use the form command
    To learn how to create and use Subtotals
  • To learn how to create and use Filters, Auto Filters and Advanced Filters
    How import text files into Excel
  • To learn how to create and use mixed cell references