EXCEL I AVANCUAR

KURSE ONLINE

RREGJISTRIM PER KURSE

Session 1 – Excel basics

  • Introduction to spreadsheets
  • Office and Excel overview
  • Basic text and cell formatting
  • Basic arithmetic calculation
  • Special paste
  • Freeze pane
  • Auto completion of series
  • Sort and filter
  • Charts
  • Data validation

 

Session 2 – Advanced Excel capabilities

  • Conditional formatting
  • Importing data and text to columns
  • functions
    o Mathematical
    o String
    o IF, AND, OR
    o Searching: match, search, vlookup
    o Dates
    o Misc
  • Pivot tables
  • Recording and editing Macros