Redwing

What is the camera in Excel

Setting up and using the camera

Using the camera

What are custom views

Creating three Custom Views

Using Custom view with filtering

Adding records to a custom view

About Dynamic Array functions

About the FILTER function

Using the FILTER function with 1 criteria

Using the FILTER function with 2 criteria

Using the FILTER function with numbers

Using the FILTER function with dates

Using the FILTER function and if empty argument 1

Using the FILTER function and if empty argument 2

Using the FILTER function and a controlling cell

About the UNIQUE function

Using the UNIQUE function

Using the UNIQUE function on rows

Using the UNIQUE function on columns

About the SORT function

Using SORT to sort ascending

Using SORT to sort a table

Using SORT and FILTER combined

Using SORT and UNIQUE combined

About XMATCH function

Using XMATCH to compare two lists

About XLOOKUP

An introduction to XLOOKUP

A basic XLOOKUP formula

XLOOKUP will look left and right

Remove N\A error when using XLOOKUP

Using XLOOKUP for first and last occurance

XLOOKUP in a low match

About and using trace precedents

Using trace precedents between worksheets

Using trace precedents between multiple worksheets

Using trace precedents between open workbooks

Using trace precedents when a workbook is closed

Opening a linked workbook

About and using trace dependents

Using trace dependents between worksheets

Removing precedent arrows

Using trace precedents between workbooks

Use Precedents and dependents together

Removing all precedent arrows

Show all formulas in a worksheet

Showing formula errors

Finding formulas with Circular Reference

Using Error Checking

Using Evaluate Formula

What is Data Validation?

Allowing only whole numbers

Allowing decimals

Allowing percentages

Allowing time

Specific text length

Allowing input between dates

Allowing input after a specific date

Setting up an Input message

Setting up an error alert

About the error alert warning symbols

Error alert warning

Error alert Information

Error alert options

Data validation in Excel tables

Remove all data validation

Circle invalid data

Finding cells with data validation

The data validation triangle

Creating a dropdown list in a cell

Creating a dynamic dropdown list in a cell

Creating a dropdown list from a source list

Using Auto Outline

Creating manual outlines

Ungrouping outlines

Creating a dashboard - step 1

Creating a dashboard - step 2

Creating a dashboard - step 3

Percentage of grand total

Percentage of column total

Percentage or row total

Percentage of parent total

Percentage of parent column total

Percentage of parent total

Comparing two fields 1

Comparing two fields 2

Comparing two fields 3

Running totals 1

Running totals 2

Ranking

an Introduction to calculated fields

Creating a calculated field 1

Creating a calculated field 2

Showing calculated fields