Description

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

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.

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

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

Course Images

Excel - Mastering Formulas and Functions

By Underscore Group

Booking options

Highlights

Description

About The Provider

Tags

Reviews