$50

Microsoft Excel - Essential Formulas (2 Part Series) - 2 for 1 Price

Event Information

Share this event

Date and Time

Location

Location

Online

Nashville, TN

View Map

Refund Policy

Refund Policy

No Refunds

Friends Who Are Going
Event description

Description

This session reviews the top advanced Excel functions needed in order to have a competitive resume. These are functions that are heavily used in a Fortune 500 setting. We will use real world data from Fortune 500 companies to practice these advanced functions.

This is a 2 part session. Session I will cover VLOOKUPS and Session II will cover LOGIC Functions (IF, SUMIF, COUNTIF, and AVERAGEIF statements)

Requirement: Students must have basic Excel knowledge prior to the course (i.e. opening spreadsheets, data entry within cells, workbook vs. worksheet knowledge, and worksheet navigation)

Session I - VLOOKUP and Index & Match Function

Duration: 2 hours

  • The formula
  • INDEX
  • MATCH
  • Name Manager

Session II - LOGIC Statements

Duration: 2.5 hours

  • References
  • SUMIF(s), AVERAGEIF(s), COUNTIF(s)
  • IF Statements
  • Error Corrections

THIS MEETING WILL BE CONDUCTED THROUGH THE GOTOMEETING PLATFORM.

Please have Microsoft 2010 or newer downloaded prior to the start of class. PCs are required. No Macs.

Share with friends

Date and Time

Location

Online

Nashville, TN

View Map

Refund Policy

No Refunds

Save This Event

Event Saved