Cademy logoCademy Marketplace

Course Images

Excel - Mastering Formulas and Functions

Excel - Mastering Formulas and Functions

By Underscore Group

  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • Delivered Online or In-Person

  • Delivered at organisers' location

  • Horsham

  • Full day

Description

Ideal for those already using Excel but who really want to get to grips with formulas and functions.



course image

Course overview

Duration: 1 day (6.5 hours)

Our Excel Mastering Formulas and Functions course looks at how to confidently use formulas and functions within Excel.

It looks at how to correctly construct formulas and explains how to build common formulas such as working with percentages.  It investigates a range of built in Excel functions and shows you how to use the formula auditing tools to help when things go wrong. 

This course is aimed at existing users of Excel who want to further their skills. Participants should be able to confidently create and amend worksheets.


course image

Objectives

By the end of the course you will be able to:

  • Construct Formulas
  • Use a range of common Functions
  • Work with absolute and relative references in formulas
  • Create percentage calculations
  • Use named ranges in formulas
  • Use the XLOOKUP command
  • Create formulas with date and use date functions
  • Use formulas in conditional formatting
  • Use a range of Count functions
  • Use the formula auditing tools


course image

Content

Formulas vs Functions

  • Constructing formulas
  • Using functions
  • Common Excel functions
  • Using the function wizard vs the formula bar
  • Formulas in tables

Absolute vs relative references in formulas

  • Using absolute references in formulas
  • Using partial absolute referencing

Range Naming

  • Naming ranges
  • Using range names in formulas
  • Single and multi-cell ranges

Working with percentages

  • Creating formulas with percentages
  • Percentage breakdowns
  • Percentage increases
  • Formatting as a percentage

Using Lookups

  • Using XLOOKUP to insert information from other spreadsheets

Calculating with dates

  • Calculating with dates
  • Using date functions

Using formulas in conditional formatting

  • Using conditional formulas
  • Using functions in conditional formatting

Count functions

  • COUNT
  • COUNTA
  • COUNTBLANK

Formula auditing

  • Using the auditing facility
  • Tracing how formulas are made up
  • Tracing precedents and dependants
  • Evaluating formulas
  • Error checking
  • Showing formulas on a sheet


About The Provider

Underscore Group
We offer bespoke programmes and off-the-shelf training courses to help you build sustainable capability in your teams. 
Read more about Underscore Group

Tags

Reviews

+ Add Review