One-hour training sessions

Topics covered:

• Excel Datasets
  • Resizing columns
  • Moving columns and rows
  • Editing a cell
  • Adding and removing columns
  • Split a cell value into two columns
  • Formula references in a dataset
  • Fill down a formula
  • Format a column 
  • Show formulas in the cells
  • Move around the dataset
  • Highlight rows/columns
  • Using the built-in calculator
  • Reference a dataset

• Excel Tables
  • Create an Excel table
  • Built-in filtering
  • Filtering on 'Date' data
  • Formulas in an Excel table
  • Adding to the end of the table
  • Add rows and columns in a table
  • FlashFill options
  • Reference an Excel table

Topics covered:

• Standard Charts
  • Adding a standard chart
  • Recommended charts
  • Recommendations depend on data
  • Normal charts
  • Switch rows and columns
  • Adding to a blank chart
  • Setting the chart title
  • Changing the chart elements
  • Resizing the chart
  • Formatting chart elements
  • Adding charts as a standalone tab
  • Change chart type
  • Adding more data to the chart

• PivotTables and PivotCharts
  • Standard charts not appropriate
  • Adding a PivotTable and PivotChart
  • Change value field settings
  • Remove totals from PivotTable
  • Remove PivotChart buttons
  • Add or remove chart elements
  • Add data to the table/chart
  • Moving data labels