Course Overview

Formula Foundations and Functions introduces you to the essential skills needed for efficient data management in Excel 365. You will explore how to apply and manage formulas, understand the dynamic nature of arithmetic operations, and get acquainted with Excel functions like SUM, AVERAGE, and COUNT. The course covers the use of absolute and relative references, clarifying how these can affect data manipulation. With lessons on using tools like the Autofill handle and function wizard, you'll be well-equipped to streamline your workflow and ensure data consistency.  

By the end of this course, you will be able to efficiently manage calculations and data presentations in Excel. You will gain practical skills that simplify complex operations, such as using the Insert Function dialog box and Excel's auto-complete feature and keyboard shortcuts for faster formula entry. This training aims to boost productivity by reducing errors and shortening the time taken on repetitive tasks. Acquiring these skills will enable you to create dynamic spreadsheets that can be easily updated as your data evolves.

Learning Objectives:

In this course, you will learn how to:

  • Learn Excel's relative reference features.
  • Efficiently use Autofill for formulas.
  • Understand the dynamics of basic arithmetic operations.
  • Grasp formula and function differences.
  • Utilize absolute references in calculations.
  • Explore Excel's diverse function categories.
  • Perform efficient text transformations in Excel.
  • Employ the Insert Function dialog box efficiently.

This course has a minimum of 25 learner registrations for us to provide a quotation.

Request a Quotation
Language
UK
Date last updated
9/12/2025
Duration
35 Minutes
Suitable Devices
  • PC
  • Phone
  • Tablet
Audio is Required
  • Yes
Includes Video
  • Yes
Downloadable Resources
  • Instructor Files
Completion Criteria
  • Visit all pages
Pass Mark
  • 70% pass mark required
Course Technology
  • HTML5
  • SCORM 1.2
Can be customised
  • No
Accreditation or Endorsements
  • No
Languages
  • English
Image of a SkillStation dashboard

Let's get started

with a demo and a 30-day free trial.

Cookies

To provide you with the best experience, we use cookies. You can read the details on our
Privacy Notice.