Lunch 'n Learn - Excel: basic tables

Lunch 'n Learn - Excel: basic tables

• 1.
  Windows Handy shortcutsand file handling
• 2.
  Excel Basic tables
• 3.
  All about rowsand columns • Sheets • Add/delete/(re)name a sheet • Cells, Rows & Columns • Select a cell/row/column • Add/Insert a row/column • Hide/unhide a row/column • Navigate • Ctrl+down/up/left/right • Ctrl+end/home • Status bar icons • Average/Count/Sum • Formula bar
• 4.
  How to dosome easy formatting • Format cells • Number formats • Alignment • Left/right • Top/middle/bottom • Wrap text • <alt+enter> -> new line in cell • Width/Height • Cell/row/column • Auto adjust • Merge/Unmerge
• 5.
  How to createreal tables with nice features • Format as table • Total row • Filtering • Remove a filter • How to see filter is active • Sorting • Easy • Advanced • Conditional formatting • Cell styles
• 6.
  Printing • Setprinting area • Page setup • Orientation • Scaling • Header/Footer • Print titles • Page order
• 7.
  Data handling •Paste special • Values • Transpose • Formulas • Text to columns • Fill • Drag • Series
• 8.
  Q&A Future questions? • ICT intranet  Training  ICT Service Lunch ‘n Learn • Helpdesk http://ict.coleurope.eu helpdesk.be@coleurope.eu Tel 050 47 70 00