Jan's Illustrated Computer Literacy 101 Logo:Jegsworks Jan's Illustrated Computer Literacy 101
Home > Jan's CompLit 101 > Working with Numbers > Formulas
Icon: Arrow - Previous pagePrevious    NextIcon: Arrow - Next page

Jan's Working with Numbers

    Formulas

Project Objectives

  • Copy a sheet
  • Sort data  - first column, multiple columns, custom list
  • Create data groups that have Subtotals  
  • Expand/Collapse data groups
  • Format cell borders
  • Format data groups
  • Create a pivot table and pivot chart
  • Filter data
  • Insert slicers  (Excel 2010, 2013, 2016)
  • AutoCalculate  
  • Insert and format AutoShape  
  • Insert, move, and 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

In Excel Project 4 you will look at grouping your data in useful ways, especially for subtotals.  You will find that thoughtful formatting and spacing of parts will help make your spreadsheet easier to use. Images and AutoShapes can enhance your sheets. You will look at how making changes to your sheet can break your formulas. So, of course, you will learn how to repair broken formulas.