Can you open existing Excel files, save and navigate to Workbooks

Can you create workbooks – new and from templates

Do you understand the Ribbon, mini toolbar, contextual tabs

Can you copy, paste, special paste, edit data

Can you select data, add columns and rows, resize cells, add sheets

Can you create a basic formula to add, subtract, multiply and divide

Have you used autofill and autocomplete

Add, edit, remove comments

Can you use Format Painter, create & modify styles

Create/format a chart, save chart as a template

Split & freeze panes, use page layout, print preview, add headers/footer

Create/modify a table

Understand Mathematical Operators

Have used Relative and Absolute References

Have used Auto functions (autosum, max, min, average)

Create basic text, financial, date, logical functions

Sort and filtered basic data, create custom filters, use Excel as a database

Add/format text boxes & WordArt

Consolidate Data, remove duplicates, convert text to columns

Created a Basic PivotTable, PivotChart

Track changes, compare two workbooks

Record a simple macro, edit, run a macro

Use PowerPivot

Use Power BI

Use / Create Dashboards

Protect a spreadsheet/workbook

Create Scenarios, use Goal Seek, Solver and V Lookup, Slicer

I am comfortable using a keyboard and mouse

I know how to download an app

I know how to test my microphone and camera

I have used Zoom before