Advance Excel Course for Professionals | Sharp HRD Services
COURSES

Sharp Institute of Individual & Organisational
Development OPC PVT. LTD. (SIIOD)

Presents

One Full day workshop on “ADVANCED EXCEL FOR PROFESSIONALS “


Date: 26th May 2019 (Sunday)

Timing: 9:00 am to 06:00 pm

Duration:- 1 Day Only

Course Fee: Rs.2,500/-

Please reply on Email: training@sharpfacility.com

Certificates will be issued to the participants!

INTRODUCTION

This training programme is set with an objective in mind to make you aware of the functions in advanced MS Excel and give you knowledge of its features so that you can use them in your day to day work and enhance your Excel skills with smart and fast working.

We guarantee, at least 20% to 40% day to day excel working time can be saved after one day workshop.

As the seats are limited, kindly book your seats in advance so as to confirm the registration.

Note:-Please bring your laptop preloaded with MS Office 2007 or onwards.

Tea/Coffee/Snacks, Lunch, & Notepad/ Pen will be provided to all participants From our end.

MS EXCEL WORKSHOP CONTENTS

  1. Advance Functions: SUMIFS, COUNTIFS, INDEX, MATCH, AGGREGATE and many more…
  2. Data Validation
  3. Data Consolidation
  4. Protection of workbook and worksheets
  5. Auto fill, Custom lists, and Create series
  6. Data linking
  7. Formula and functions
After completing the training programme certificates will be given.
  1. Lookup table
  2. Pivot Table and charts
  3. Text functions
  4. Keyboard shortcuts
  5. Advanced Sorting and Filtering.
  6. Slicer & Sparklines
  7. Conditional Formatting
  8. Macros basics It will be through PPT presentation, verbal discussions and hands on Practice on Laptop.

Kindly provide below details for Registration:

Brochure View

Get Connect with us on: