MS EXCEL 2013 – INTERMEDIATE & ADVANCED

Loading Events

« All Events

MS EXCEL 2013 – INTERMEDIATE & ADVANCED

November 27, 2017 @ 9:00 am - November 28, 2017 @ 5:00 pm

Introduction:

The Intermediate program aims to give the new spreadsheet user a thorough grounding in the Intermediate level of creating and working with spreadsheets using Microsoft Excel 2013. Learners will be guided for the commonly used functions and formulas in Excel 2013.

While the Advanced program is designed for those with intermediate knowledge of Excel who wish to progress to the most complicated functions and features in Excel 2013.

Learning Objectives:

For Intermediate level, by the end of the program, learner will be able to: For Advanced level, by the end of the program, learner will be able to:
  • use the IF and VLOOKUP/HLOOKUP functions;
  • manipulate information;
  • apply sorting;
  • filter data;
  • apply charting elements;
  • use Spark lines to show data trend.
  • apply conditional formatting;
  • group and ungroup cells;
  • perform calculation by consolidation;
  • create a simple PivotTable and PivotChart;
  • use analysis tools.

Target Group:

Learners who wants to create a report and perform calculation by using the Excel functions and features.

Pre-requisite:

  • Learners should already know how to use Microsoft Windows and mouse & keyboard (for Intermediate level).
  • Learners should already know the Intermediate level of Microsoft Excel (for Advanced level).

 

Details

Date:
27 - 28 November 2017
Time:
9:00 am - 5:00 pm
Event Category:

Venue

PENANG SKILLS DEVELOPMENT CENTRE (PSDC)
1, Jalan Sultan Azlan Shah,
11900 Bayan lepas,
Penang, Malaysia
Go to Top