Getting Started With Functions and Formulas in Excel: Mini Excel Masterclass Series eLearning Course
Overview
Functions and formulas are the heart of Excel, enabling you to perform calculations, manipulate data, and automate tasks. There are five functions that are the most common when it comes to using Excel, and these are SUM, AVERAGE, MIN, MAX and COUNT.
In this course, we'll tackle these functions, and learn how to use absolute cell references when you need a certain cell to remain constant. This short, 30-minute course will help you get to grips with Excel effectively and efficiently.
Learning Outcomes
- Understand how to use the five most common functions, SUM, AVERAGE, MIN, MAX, and COUNT to construct some basic formulas.
- Practice using Absolute and Mixed references in formulas to lock columns and rows when copying a formula.
Audience
Anyone looking to explore the basics of Excel.
This course has a minimum of 25 learner registrations for us to provide a quotation.
Request a Quotation- Language
- UK
- Date last updated
- 10/12/2023
- Duration
- 30 Minutes
- Suitable Devices
-
- PC
- Phone
- Tablet
- Audio is Required
-
- Yes
- Includes Video
-
- Yes
- Downloadable Resources
-
- Transcripts
- Completion Criteria
-
- Pass final test
- Visit all pages
- Pass Mark
-
- None
- Course Technology
-
- HTML5
- SCORM 1.2
- Can be customised
-
- Available at an Additional Cost
- Accreditation or Endorsements
-
- No
- Languages
-
- English
