Microsoft® Excel Basic Formulas

The Basic Formulas class will acquaint the user with an overview of Excel formulas where cell addresses are featured for effective formula copying. Relative vs. absolute referencing is discussed and demonstrated as well as exposure to general formula functions such as SUM, AVERAGE, MAX, MIN, and COUNT. The user will also be shown various Date functions such as TODAY, NOW, MONTH, YEAR, and DAY.

Objective: Upon completion of this course the novice Excel user will be able to complete spreadsheets by using a variety of formulas featuring basic computation along with using built-in Excel Functions.

  • Copying formulas using the Fill Handle
  • Relative vs. Absolute References
  • Using AUTOSUM
  • Basic Functions
    1. AVERAGE
    2. MAX
    3. MIN
    4. COUNT
    5. Date Functions
      1. TODAY & NOW
      2. MONTH, YEAR, and DAY
      3. The DATE Function
  • Conditional Formatting

Knowledge Source Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

Course Information
  • Course Level:Basic
  • Prerequisite:None
  • Credit:2 CPE Hours
  • Fee:$99
  • Delivery:Virtual Instructor-Led Live
  • Recommend Field of StudyComputer Software and Applications
  • Program Knowledge LevelBasic
  • Advanced PreparationDownload and install class files a minimum of 3 working days prior to class.
  • Refund PolicyRequests for cancellations must be submitted in writing and received by Knowledge Source Inc. five (5) days prior to the date of the event to receive a full refund (less a 10% processing fee). Refunds are not given for no-shows. Special circumstances and cancellation requests may be emailed to info@knowledgesourceinc.com or by calling 919-878-7100. Refunds will be issued within 30 days after the course.

Related Courses