1. BASIC SPREADSHEET SKILLS

• Enter spreadsheet data edit.
• clear and delete spreadsheet data.
• Insert and delete columns and rows.
• Adjust column widths and row heights.
• Change worksheet layout.

2. FORMATTING CELLS

• Correctly apply cell font formatting
• Correctly apply numeric formatting.
• Correctly apply advanced cell formats using the Format Cells window
• Clear out formats from cells accurately.
• Copy formatting using the Format Painter.

3. WORKING WITH WORKSHEETS

• Insert and rename new worksheets efficiently.
• Delete worksheets.
• Link worksheets to copy data onto multiple sheets.
• Change worksheet layout and alignment.

4. WORKING WITH BASIC EXCEL FUNCTIONS

• The IF functions.
• Accurately enter SUM, Sumif
• MIN, MAX, AVERAGE, Average if
• COUNTA, Countif, countblank
•  TODAY functions.

5. CREATING CHARTS

• Creating and modifying charts
• Adding trendlines
• Visualizing multiple data sets
• Using Sparklines

• Conditional formatting
• Creating named ranges
• Using named ranges in formulas.

7. DOCUMENTING AND AUDITING

• Best practice spreadsheet design
• Viewing, adding, editing, and deleting comments
• Auditing features
• Tracing formula errors
• Protecting a worksheet
• Protecting cell ranges.