Schedule of Trainings and Seminars


Time:

8:00AM-5:00PM

Start Date:

August 14, 2018

End Date:

August 15, 2018

Status

closed

Course Details


Course Name

Advanced MS Excel 2013

Type of Course Module

advanced Course Module

Course Description

MS Excel 2013 is designed to help the user get professional looking results faster. It provides new features that let the user easily draw more persuasive graphs and charts, guiding decision-makers thru better data visualization. Check details in pivot tables in a click of a mouse.

Course Outline

MS Excel 2013 and older versions

  • Organizing Data
  • Performing Calculations on Data
  • Data Validation
  • V look up
  • Working with Data Form
  • Creating / Revising Pivot Tables
  • Using Auto Filter & Advanced Filters
  • Using Slicers
  • Importing and Exporting Data
  • Using Multiple Workbooks
  • Analyzing Data
  • Using Conditional and Custom Formats
  • Working with Graphics and Charts

Prerequisite:

  • Participants should be able to perform basic calculations using MS Excel

Methodology:

Discussion, demonstration and hands-on exercises

Duration

2 days

Registration Fee

3,500.00

Contact Person

Joseph Argente

Contact Number

831-9988

This entry was posted in . Bookmark the permalink.