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

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

  •  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