logo


your one source for IT & AV

Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey | Standby Discounts

Excel MegaBytes: Advanced Formulas & Functions

SS Course: 3000738

Course Overview

TOP

During this 2-hour live, hands-on training, our top-rated instructor will teach how to use popular advanced Excel functions and formulas. Students are encouraged to ask questions at any time during the training.

                                                                  

Scheduled Classes

TOP
06/06/24 - HA2 - Virtual Instructor-Led - Virtual Instructor-Led (click to enroll)
09/05/24 - HC3 - Virtual Instructor-Led - Virtual Instructor-Led (click to enroll)

What You'll Learn

TOP

During this live training you will learn to:

  • Use the AND function
  • Use Nested IF functions
  • Use SUMIFS functions
  • Use COUNTIFS functions
  • Use the MATCH function
  • Use the EXACT function
  • Use the TRIM function

Outline

TOP
Viewing outline for:
  • Using the AND function
  • Using Nested IF functions
  • Using SUMIFS functions
  • Using COUNTIFS functions
  • Using the MATCH function
  • Using the EXACT function
  • Using the TRIM function

Prerequisites

TOP

None

    Who Should Attend

    TOP

    Students looking for a quick introduction of using advanced functions and formulas in Excel.

    Next Step Courses

    TOP

    Other Bits & Bytes sessions and Microsoft Office courses.