logo


your one source for IT & AV

About Us | Careers | Contact Us | Locations  
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: Basic Formulas

SS Course: 3000670

Course Overview

TOP
During this two-hour live hands-on training, our top-rated instructor will teach basic formulas. Watch the demonstration and gain experience as you work along with the instructor. Students are encouraged to ask questions during this hands-on session.                                                                  

Scheduled Classes

TOP
02/16/23 - HA1 - Virtual Intructor-Led - Virtual Intrustor-Led (click to enroll)
05/17/23 - HA1 - Virtual Intructor-Led - Virtual Intrustor-Led (click to enroll)

What You'll Learn

TOP
  • Perform basic Functions
  • AutoCalculate
  • Autofill
  • Create a Relative Cell Reference
  • Create an Absolute Cell References

Outline

TOP
Viewing outline for:
  1. Performing basic functions
    • PEMDAS
  2. AutoCalculate
    • using syntax: sum, min, max, average
  3. Autofill
    • Days/Months of the year
    • Auto count
  4. Create a Relative Cell Reference
    • Copy using autofill
    • Copy/paste
  5. Create an Absolute Cell References
    • Using Autofill

Prerequisites

TOP

    Who Should Attend

    TOP
    This course is designed for new users wishing to learn basic excel formulas.

    Next Step Courses

    TOP