logo
ABD
LiveZilla Live Chat Software



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
While System Source is working from home, we are still available for all of your calls and support needs.

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
10/20/21 - VIR - Virtual Online Training - Virtual Instructor-Led
11/09/21 - VIR - Virtual Online Training - Virtual Instructor-Led
12/09/21 - VIR - Virtual Online Training - Virtual Instructor-Led

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