Excel - Mastering Formulas and Functions

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

Constructing formulas

Using functions

Common Excel functions

Using the function wizard vs the formula bar

Formulas in tables

Using absolute references in formulas

Using partial absolute referencing

Naming ranges

Using range names in formulas

Single and multi-cell ranges

Creating formulas with percentages

Percentage breakdowns

Percentage increases

Formatting as a percentage

Using XLOOKUP to insert information from other spreadsheets

Calculating with dates

Using date functions

Using conditional formulas

Using functions in conditional formatting

COUNT

COUNTA

COUNTBLANK

Using the auditing facility

Tracing how formulas are made up

Tracing precedents and dependants

Evaluating formulas

Error checking

Showing formulas on a sheet