Day 1                                                                          
  • Start Excel
  • Work in Excel user interface
  • Create workbooks
  • Modify workbooks
  • Enter and revise data
  • Manage data by using Flash Fill
  • Modify worksheets
  • Move data within a workbook
  • Find and Replace data
  • Define Excel tables

Day 2

  • Format cells
  • Format Numbers
  • Conditional Formatting
  • Data Validation

Day 3

  • Filters
  • Sort worksheet data
  • Sort data by using custom lists
  • Organize data into levels – Subtotal
  • Manipulate worksheet data (Remove Duplicates, Column to Text)
  • Name groups of data
  • Consolidate multiple sets of data into a single workbook
  • Print

Day 4

  • Create formulas to calculate values
  • Working with formulas
    • Copy functions
    • Absolute references
    • Using names in formulas
    • Using formulas with tables.
    • Errors in formulas

Day 5

  • Scenarios
  • Goal Seek
  • Solver
  • Analyze data by using data tables.
  • Create Charts
  • Summarize your data by using sparklines

Day 6

  • PivoteTables
  • Macros
  • Manage comments
  • Add protection to workbooks and worksheets
  • Change default Excel options