Computer classes and home tutoring: Word, Excel, Access, Powerpoint, Outlook, Photoshop, Quickbooks and more
Home Adult Classes Corporate Services Tutoring Computer Repair Contact Us Tips Jobs



All Classes must be Paid by Employer




Computer Training At our Facility

Walking distance from LIRR

We bring Computers and Projector & screen to you

All training can be Customized

One on One Training Available


Fix your Computer at



Computer Teach : Classes : Excel Formulas 2013 class

Excel Formulas 2013   Enroll

Course #: EF13

Day & Time: Fridays: 9:00am-12:00pm

Dates: Dec 1 or Dec 15 or Dec 29

Total Hours: One 3-hour class

Software: Microsoft™ Office 2013

Price: $285

  1. Working with Functions and Formulas
    1. Using Formulas in Excel, Part 1
      1. Understanding Relative and Absolute Cell References
      2. Understanding Basic Mathematical Operators
      3. Using Formulas with Multiple Cell References
      4. Understanding the Formula Auditing Buttons
    2. Using Formulas in Excel, Part 2
      1. Fixing Formula Errors
      2. Modifying Error Checking Options
      3. Displaying and Printing Formulas
    3. Exploring Excel Functions(SUM, AVERAGE, COUNT, MAX, MIN, NOW, TODAY)
    4. Working with Names and Ranges
    5. Using Functions in Excel (IF, Nested IF)
  2. Advanced Excel Tasks
    1. Using Advanced Functions (AND, OR, NOT, TRUE, FALSE, IF, IFERROR, Database formulas)
    2. Using the VLOOKUP Function
Computer Teach : Classes : Excel Formulas 2013 class
 

Copyright © Computer Teach 2017. All rights reserved.


Computer Teach
39 Great Neck Rd
Great Neck, NY 11021

Phone: 516.773.9847, 212.533.2171 Fax: 516.706.0820

Serving Great Neck, Nassau County, Suffolk County, Queens, New York, Long Island, Brooklyn, Bronx, Westchester, Staten Island, Northern New Jersey.