Discover the directions your career can take.

The Synergy Pro app gives professionals a range of options and possibilities to find the one that fits you best.

MS Excel (24 Hours)

Microsoft Excel is a spreadsheet program included in Microsoft Office suite of applications. Spreadsheets will provide you with the values arranged in rows and columns that can be changed mathematically using both basic and complex arithmetic operations.

In addition to the standard spreadsheet features, Excel offers programming support via Microsoft's Visual Basic for Applications (VBA), the ability to access data from external sources via Microsoft’s Dynamic Data Exchange (DDE).

Microsoft Excel was first released for Macintosh systems in the year 1985, followed by the first Windows version in 1987.

Course Objective

Participants will learn to how to use advanced functions of Excel to improve productivity, enhance spreadsheets with templates, charts, graphics, and excel formulas and streamline their operational work.

They will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Students will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel advanced functionality to simplify and streamline their day-to-day work.

Course content

Subjects/Topics/Software covered

Advanced Excel

  • Grouping & Outlining and Subtotals
  • What-If Analysis
  • PivotTables
  • Formulas and Functions
  • Advanced Range and Array Function
  • Advanced Excel Tasks
  • Creating HLOOKUP and VLOOKUP Functions
  • VBA Macros in Excel

Deliverables

  • Easy to understand courseware
  • Training with the focus on useful features

Who can enroll?

This course is designed for working professionals & students who is interested in learning the Advanced Excel techniques to increase productivity and improve efficiency by streamlining the workflow.

Apply Now.

Online Learning Upskill From home Join Now
Benchmark Synergy Mock
test portal
Register Now

Students Speaks

The PMI, PMP, ACP, CAPM, PMBOK are registered marks of the Project Management Institute, Inc. The PMI Registered Educational Provider Logo is a registered mark of the Project Management Institute, Inc. The PMI logo is a registered mark of the Project Management Institute, Inc.
Copyright © 2018 Synergy. All rights reserved. | A division of CADD Centre
x close