Jan's Working with Numbers

    Formulas

Lesson Objectives

• Copy a sheet
• Sort data  - first column, multiple columns, custom list
• Create groups that have Subtotals  
• Expand/Collapse groups
• Format cell borders
• Format data groups
• Create a pivot table & pivot chart
• Filter data
• Insert slicers 
• AutoCalculate  
• Insert and format AutoShape  
• Insert, move, & resize image
• Select cells underneath an image
• What can go wrong with formulas - copy or link, merging cells, sorting, or inserting cells, rows, columns
• Fix broken formulas