Jan's Working with Numbers

Open Excel

• Open Excel from Start menu/Start screen
• Open a spreadsheet from a disk
• Open a spreadsheet from the Internet
• Open a spreadsheet from Recent files
• Save a spreadsheet with a new name

Select Cell

• Select a cell with-
       mouse
       keys
       cell reference
       name
• Create a cell name
• Select all cells
• Select all data cells

Select Range

• Select a range of cells with -
       dragging
       keys
       range reference
       name
• Name a range
• Select non-adjacent cells
• Extend or reduce a selection

Select Row/Column

• Select a row or column
• Select adjacent rows or columns with -
        drag
        keys
• Select non-adjacent rows or columns 

Select Sheet

• Select a sheet
• Select adjacent sheets
• Select non-adjacent sheets 
• De-select a group of sheets

Views

• Switch to a different view: Status bar buttons
• Keep part of a sheet from printing with Page Break View
• Add a header with an automatic date in Page Layout view
• Toggle Full Screen on and off
• Split the view into 4 parts
• Split the view into 2 parts
• Freeze panes to keep column and row titles in view
• Open Print Preview

AutoSum

• Use AutoSum to total a column
• Use AutoSum to total a row
• Change range references in a formula

Sort

• Sort cells
• Sort rows
• Why sorting cells containing formulas is a bad idea

Chart

• Select data to create a chart
• Create a pie chart
• Move a chart on a sheet
• Move a chart to a separate sheet
• Pick a chart layout
• Edit a chart title
• Format and position data labels - all or single
• Change the chart sytle
• Change the workbook theme
• Format a single data point
• Create a header that includes a field
• Print a chart

Number Formats

• Change number formats
• What each number format button does 
• Use Format Painter to copy formatting