Excel 2016 - Refresh (virtual classroom)

Basic knowledge of Excel

Review the basic Excel features

• Managing tables
  • Selecting and moving
  • Fill handle and series
  • Copy, move data
  • Paste special
*
• Managing worksheets
  • Add, delete, rename
  • Copy & move, hide & unhide sheets
  • Assign a tab color
*
• Functions
  • Insert a basic formula
  • Insert a basic function (Autosum …)
*
• Formatting tables
  • Formatting cells
  • Autoformat
*
• Printing
  • Page setup & print, manage headers & footers
  • The Page layout view
*