Terms & Conditions

Invite friends

About The Event

Introduction

Organizations today have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. Data analysis & representation is indispensible to facilitate decision making and strategy development. It’s very challenging to turn a huge amount of data to useful information without the help of Excel.

In this course, you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts, graphics, data analysis and formulas. Demonstration will be based on MS Office version.

Participants need to bring their own laptop with MS Office installed, for better understanding and practical experience. The participants may also bring with them live data pertaining to their organization, so that these can be studied during the workshop, as to how it can be worked out with better solutions.

This program is for anyone who is already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks.

Program Objectives

This Advanced Excel training program will empower the participants to be able to do the following:

Performing complex calculations more efficiently, use various Excel functions.

Organizing and analyzing large volumes of data.

Creating MIS reports.

Designing and using templates.

Consolidating and managing data from multiple workbooks.

Prerequisites

Participants attending this training should be familiar with the basic operations in Microsoft Excel, such as simple calculations, formatting and printing.