fbpx

Microsoft Excel

Insert Formula Using Cell References

Insert a formula to link cells within a sheet

Insert a formula to link cells between sheets

Insert a formula using data from different sheets

Use an Absolute Cell Reference

Insert Formula Using Date Cells

Use date cells in a formula

Insert the TODAY Function in a cell

Insert the TODAY Function in a formula

Use the SUM Function

Edit the range of cells used in the SUM Function

Use the SUM Function to add non-adjacent cells

Use the SUM Function to add a range of cells in a different sheet

Use the SUM Function to add a column in a different sheet

Use the SUMIF Function

Insert the SUMIF Function using text criteria

Insert the SUMIF Function using a cell reference as the criteria

Use the VLOOKUP Function

Use the VLOOKUP Function to display data within the same sheet

Use the VLOOKUP Function to display data from a different sheet

Use the VLOOKUP Function to display data from a different file

Use Column References within a VLOOKUP Function

Use the VLOOKUP Function to compare lists of data

Use the IF Function

Use the IF Function to display a number

Use logical operators

Use the IF Function to display a message

Use the IF Function to display a blank message

Use Conditional Formatting

Create a basic rule

View / Modify a rule

Delete a rule

Link Conditional Formatting to a cell

Apply more than 1 rule

Use PivotTables

Prepare data to be used in a PivotTable

Insert a PivotTable in a new worksheet

Insert a PivotTable in an existing worksheet

Move a PivotTable

Delete a PivotTable

Refresh a PivotTable

Use the Change Data Source tool

Use a Basic Filter

Use a Label Filter

Use a Value Filter

Insert a Column Field

Insert Report Filters

Insert Row Fields

Collapse and Expand Fields

Change the Summarize Values By setting

Use Show Details to display data linked to a value

Create a PivotChart