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

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

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
  • 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.