Microsoft Excel Course (6-7 hours) Level 3 (Advanced / Dependant PC User)

Microsoft Excel Course (6-7 hours)
Level 3 (Advanced / Dependant PC User)

  •  Recap from earlier course
  •  Customisation of Excel
  •  Advanced Formulas
  •  Define a range name
  •  Advanced functions (IF, VLOOKUP, SUMIF,)
  •  Nested Functions (Auto comparison of data)
  •  Lookup tables (find and match data)
  •  Workbook Management Tools
  •  Create and display a view
  •  Picture editing tools
  •  Protecting a workbook
  •  Protecting part of a workbook
  •  Data Validation
  •  Create a Pivot table (electronic reports)
  •  Macros (Auto command sequences)

return to full listing

Aston Recruitment Accreditation
Web Design by 1PCS© Aston Recruitment & Training Ltd 2010