Course Code: 954

Excel Formulas: Basic

Class Dates:
1/2/2019
2/7/2019
3/7/2019
Length:
1 Days
Cost:
$295.00
Class Time:
Technology:
Office
Delivery:

Overview

  • Course Overview
  • Learn how to use formulas to do basic math in Excel, how to make formula results update automatically, and how to use predefined formulas called functions that do things like calculate the amount of monthly payments. Learn how to use functions in your formula's. You'll explore specific types of formulas that can help you on multiple levels, such as financial and array formulas.

    You'll learn how to apply formulas to charts and pivot tables, troubleshoot your formulas, develop custom functions, and much more.
  • Audience
  • Anyone who is familiar with the basics of Excel, but would like to expand their knowledge.

    Users would include people from a wide variety of job roles from almost all areas of professional, student, and personal life. Some of the roles users might take on include, but are not limited to:
    • Accountants
    • Clerical, Office professionals
    • Consultants
    • Executives/Managers
    • Help desk personnel
    • Instructors/Trainers
    • Program/Project Managers
    • Sales
    • Students
    • Other members of the general population
    • Charting
    • Create analytical, financial, etc. reports
    • Data entry
    • Family budget
    • Format numerical (financial, statistical, etc.) reports
    • Forms
    • Graphing
    • Process data
    • Reporting
    • Technical support
    • Trending

Prerequisites

  • Familiarity with Excel basics.
  • Recommended Courses:

Course Details