IT Training

EXCEL - INTRODUCTION

AIM To allow users to develop skills and the knowledge required to perform basic spreadsheet activities.
WHO SHOULD ATTEND? Delegates who need basic training in the Microsoft Excel package to develop spreadsheets.
OBJECTIVES By the end of the course, participants will be able to ;
  • Enter & format data in a spreadsheet.
  • Perform calculations on data.
  • Create & print graphs.
CONTENT During the course delegates, will cover the following topics: -
  • Creating & Editing Spreadsheet Data.
  • Using Formulae To Perform Calculations.
  • Using Functions.
  • Sorting Data.
  • Create & Modify Charts.
  • Printing Worksheets & Charts.
DURATION 1 Day

EXCEL - ADVANCED

AIM To broaden participant's skills and knowledge of the more advanced features of Microsoft Excel.
WHO SHOULD ATTEND? Delegates who need to create complex spreadsheets & who have a basic understanding of Excel or have attended the Introductory course.
OBJECTIVES By the end of the course, participants will be able to ;
  • Create complex spreadsheets using functions and formulae.
  • Summarise data using sub-totals & pivot tables.
  • Control entry in a spreadsheet (data validation).
  • Automate procedures using macros.
CONTENT During the course, delegates will cover the following topics:-
  • Create / Use Formulae & Functions.
  • Understand IF / SUMIF / LOOKUP & Nested functions.
  • Use Scenario & View Managers.
  • Sorting Data & Calculating Sub-Totals.
  • Filtering Data – Creating Custom Filters.
  • Analyse / Summarise Data Using Pivot Tables.
  • Create & Format Charts.
  • Protect Worksheets / Workbooks.
  • Data Validation Functionality.
  • Create / Use & Modify Macros.
DURATION 1 Day

 

< BACK