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 Bits & Bytes: Advanced Formulas & Functions

SS Course: 1000165

Course Overview

TOP

During this one-hour live webinar session, our top-rated instructor will demonstrate how to use some advanced Excel functions and formulas. Students are encouraged to ask questions in the chat window at any time during the demonstration.

This is a demonstration style webinar and Q&A Session only, no software/files required.

                                                                  

Scheduled Classes

TOP
05/22/24 - VIR - Virtual Online Training - Virtual Instructor-Led (click to enroll)
07/18/24 - VIR - Virtual Online Training - Virtual Instructor-Led (click to enroll)
09/11/24 - VIR - Virtual Online Training - Virtual Instructor-Led (click to enroll)

What You'll Learn

TOP

During this live demonstration 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.