MS Excel Courses

Microsoft Excel is a spreadsheet program that allows users to organize, format, and calculate data

Excel is a spreadsheet program from Microsoft and a component of its Office product group for business applications. microsoft and excel training enables users to format, organize and calculate data in a spreadsheet.

MS Excel Intro/Intermediate Training – Course Outline

Duration: One Day

View details

Target Audience & Purpose

Excel Intro / Intermediate is for people new to Spreadsheets, & for self-taught users to enhance their knowledge. It is a pre-requisite for the Advanced course.

Objectives

By the end of this course participants should be able to:

  • Recognise the main areas of the Excel window & workbook
  • Enter, edit & delete data in a workbook
  • Create workbooks using formulae & functions, including SUM, AVERAGE, MAX & MIN
  • Enhance the presentation of workbook data
  • Create, display & enhance charts, print worksheets
  • Set up & work with multiple worksheets
  • Freeze titles on a worksheet
  • Sort & subtotal data
  • Add comments to a worksheet

MS Excel Advanced – Course Outline

Duration: 2 Days

View details

Target Audience & Purpose

Excel Advanced is for people who can already create moderately complex spreadsheets, and want to add more sophistication and automation.

Objectives

By the end of this course participants should be able to:

  • Use outlines, range names, databases & the data form
  • Use AutoFilter & advanced filters
  • Work with Data Series
  • Use advanced functions
  • Modify charts
  • Use Scenarios & Goal Seek
  • Use templates, data tables & solve problems
  • Use automatic formatting & styles
  • Work with views, consolidate worksheets
  • Create & revise PivotTables
  • Use, record & edit macros

MS Excel VBA – Course Outline

Duration: 2 Days

View details

Target Audience & Purpose

Excel VBA training is for highly skilled developers who wish to add high-end automation.

Objectives

By the end of this course participants should be able to:

  • Work with the VBA editor
  • Understand VBA concepts and features
  • Create procedures and sub routines
  • Work with variables
  • Work with Excel objects
  • Use standard programming techniques and concepts
  • Create custom forms
  • Program custom forms
  • Make macros start automatically