Excel - Formulas and Functions

Level - Intermediate
This course focuses on expanding your knowledge of Microsoft Excel’s functions and understanding how to write well-structured formulas.

Date
Duration

1 Day

Time
Location
Participants
Total

Overview

The Excel - Formulas and Functions course will help you to create well-structured formulas using relative and absolute referencing and named ranges. It will help you to understand and use various functions in formulas, including the Insert Function feature.

Content

  • Understand relative and absolute cell referencing in formulas
  • Create and use named ranges in formulas
  • Understand the structure of formulas and functions
  • Calculate totals using AutoSum
  • Use functions: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, IF, COUNTIF, SUMIF and VLOOKUP
  • Use the Insert Function feature
  • Trouble-shoot formula errors using formula auditing.

Learning Outcomes

Participants should be able to:

  • Create well-structured formulas using relative and absolute referencing, and using named ranges.
  • Understand and use functions in formulas.
Related Results

Level - Advanced
This course concentrates on creating PivotTables and PivotCharts to present business data for analysis. It also focuses on how best to manage the underpinning business data using List Management techniques.

Level - Advanced
This course is all about time-savers in Microsoft Word. It shows how to automate standard documents and how to create your own shortcuts for frequently used tasks which you then can add to your toolbar or ribbon. This course is for you, if you are a confident Word user.

Level - Fundamental
Explore key project management terminology and Microsoft Project's main features, including how to set up a schedule and resource pool, assign resources to tasks and how to track projects.

Level - Advanced
This course builds on the Power BI Desktop - Level 1 course. It introduces you to more advanced DAX (Data Analysis Expressions) concepts including variable and advanced functions. 

Courses - Frequently Asked Questions

Get answers to common queries.

FAQs