• image03

    Open Workshop

    Advanced Excel

    22nd to 23rd July 2017

    Venue: GITS Academy Jayanagar.

  • image03

    Our Popular workshops

    We provide open workshops on Data Analytics and Data Visualization.

About The WorkShop

  • propic
  • propic

Come for these extraordinary, information-packed, intense Programs to increase your efficiency and productivity, improve the quality, accuracy & make better reports.

The Advanced Excel Workshop is designed for executives who already have knowledge of “Microsoft Excel Basics”, and who might want to work with more advanced features of Microsoft Excel that help in enhancing their efficiency of working with worksheets, creating MIS reports, analyzing data, and automating various tasks.

Advance Excel workshop in Bangalore is organised by GITS Academy would be very helpful to participants across various enterprise and functional specializations such as Finance, Marketing, MIS, Operations, Information Technology, Human Relations and Administration.

SCHEDULE

Flat 10% Discount for more than 5 students. - For More Info +91 9590800200
Start DateEnd DateDurationInstructorLocationSeat ConfirmationEnroll
Jun 17Jun 182 DaysPraveen JayaNagar BangaloreRegistration amount to block your seat
INR.1000/-
Book Now >>

INR.7000/-
INR.4500/-
Enroll Now >>

July 1July 22 DaysVenkatesh Instructor's Profile

VENKATESH. by education is a Computer graduate from premier institutions. He has a rich and varied experience in the field of Business Analytics which spans over a period of more than 9 years.

He has extensive knowledge of multiple technologies in Analytics area that includes, Excel VBA, SAS, SAS DI, SSIS Packages, QlikView, Dashboards . His current experience in Risk modeling, credit risk, Identifying data anomalies and define rules for automated and semi-automated resolution through adjustment technique, Preparing reports & dashboards on periodic basis with optimum accuracy and share them with Business Heads, Process owners and stake holders to take important decisions to run the operations.

He has profound capability of teaching difficult concepts in a simple and lucid manner which is great strength of his teaching style. He believes in sharing knowledge and shares a good rapport amongst his clientele and students.

Malleswaram BangaloreRegistration amount to block your seat
INR.1000/-
Book Now >>

INR.7000/-
INR.4500/-
Enroll Now >>

July 22July 232 daysRajesh B Instructor's Profile

Rajesh M. by education is a Computer engineer and an MBA from premier institutions. He has a rich and varied experience in the field of Business Analytics which spans over a period of more than 10 years.
He has extensive knowledge of multiple technologies in Analytics area that includes Excel, R, SAS,Python, Power BI, Tableau,  Qlikview , SQL Server , Business Statistics and Machine Learning. He has been working as a dedicated Corporate trainer and has trained professionals from more than 22 organizations across the country.
He has profound capability of teaching difficult concepts in a simple and lucid manner which is great strength of his teaching style. He believes in sharing knowledge and shares a good rapport amongst his clientele and students.

JayaNagar BangaloreRegistration amount to block your seat
INR.1000/-
Book Now >>

INR.7000/-
INR.4500/-
Enroll Now >>

Training Agenda

Introduction

  • Introduction to Excel User Interface
  • Data Sorting
  • Range & Named Range

09:30 AM 11:30 AM

Tea Break

Data Management

  • Calculated Fields
  • Calculated Items
  • Grouping
  • Formatting – Number/Conditional

11:45 AM 01:00PM

Lunch Break

Data Management

  • Data Validation
  • Data Filtering
  • Conditional Formatting

01:30 PM 03:30PM

Tea Break

data management

  • Formulas
  • Cell References
  • TEXT Functions
  • IF
  • ERROR Functions
  • LOGICAL Functions

03:45 PM 5:30PM

Complete

Data Analysis

  • Pivot Tables
  • Introduction & Creation
  • Slicer

09:30 AM 11:30 AM

Tea Break

data analysis

  • Power Pivot ( 2013 users only )

11:45 AM 01:00PM

Lunch Break

Data Analysis

  • VLOOKUP
  • HLOOKUP
  • COUNTIF
  • SUMIF
  • SUMPRODUCT
  • Nested forumulas
  • Basics of Macros

01:30 PM 03:30PM

Tea Break

Conclusion

  • Case studies
  • Questions
  • Answers

03:45 PM 5:30PM

Complete

WHY GITS ACADEMY

GITS Academy brings to you world class education in professional trainings and certification.

You get a wide range of practice questions, Mock Tests, Flashcards as Memory Joggers, etc. Participants will also get an e-learning access to the course which helps them go through the course anytime anywhere with ease. One can have access the course on a tab, laptop, phone etc. People who are not able to attend the classroom trainings, for them we provide Virtual Classroom Training Sessions.

Why Us

  • We Provide Microsoft Certified Trainer.
  • Trainers have Industry experiences and experts.
  • Will provide Practical Hand-on Session.
  • Explanation with Real World Examples.
  • Preparation for Microsoft Certification.

Learning Objectives

This Advanced Excel workshop will help the participants to be able to do the following:

  • Learn performing complex calculations more efficiently and
    intelligently, using various Excel functions.
  • Understand how to organize and analyze large volumes of data.
  • Learn to create MIS reports.
  • Learn to Design and using templates.
  • Consolidate and manage data from multiple workbooks.

Achievements

  • We have conducted 600 Corporate Training.
  • Trained almost 20,000+ Professionals.
  • Have Overseas Training Experience.
  • Leading Advanced Excel Training in India & International.

Enquiry

Want to know Something Else ??

Message Sending...

Key take aways

  • Learn Advanced Microsoft Excel 2016 by a Real time / Corporate working professionals
  • Do not worry even if you miss any class because of any emergency – we will provide you class recordings through our LMS, which can be accessed from anywhere.
  • Get Microsoft office specialist certification (MOS) *
  • Training material & MOS Certification study material would be shared with you in the form of soft copy, which gives you easy accessibility & mobility to all the concepts.
  • Knowledge sharing / Overview of the opportunities available in the industry for Excel & other related technologies will be provided at the workshop.

FAQ

The website will indicate when a course is fully booked.

It would be ideal if you Visit the Course Page, You will discover the Training Calendar, in view of your plausibility, you can book your seat, with online payment choice, a receipt will issued for the charge paid the successful payment.

A few courses may not be on our present timetable. If so, you can demand to join the mailing list and we will advise you when the following course is arranged. Or mail us: training@gitsacademy.com

Your booking will be confirmed on full payment of fees. You will receive confirmation of your email with further information, including course timetable, training agenda, and Contact person.

Normally workshop will be conducted 10.00AM -6.00 PM , with lunch and two tea breaks.

Full interest is a need for all courses. On the other hand, because of any unavoidable reason participants are not able to attend the class, recorded session will be suited to the same session.

Money can be requested to transfer to another person only atleast one week in advance Post that it wouldnt be permissible at any case.

Courses open each month. Classes are held all weekdays and weekends (Saturday-Sundays), Information about course costs, installment arrangements, dates and nearby timetables are accessible on Respective Course Pages.

Classes are held at our two Centers – GITS Academy Malleswaram Branch, contact: 9900867154 & GITS Academy Jayanagar contact: 9632240775

We conducted training with a limited batch size, normally batch size is up to 10 participants per classroom.

We enthusiastically welcome group participation per Course, we do offer upto 10% Discount for four to ten participants.

If you cancel your registration 7 days before your Courses begin, you will receive a full refund issued as a refund to your credit card or by check.

When you complete each Course, we will provide you with a printed certificate stating that you completed the Course.

All disputes related to policy or payment would be decided by GITS Academy.

Register

Early Bird

  • Access For All Session
  • Free Tea / Coffee / Lunch
  • Free Wifi Access

4000

Register Now

Regular

  • Access For All Session
  • Free Tea / Coffee / Lunch
  • Free Wifi Access

4500

Register Now

Group

  • Access For All Session
  • Free Tea / Coffee / Lunch
  • Free Wifi Access
  • Coupon Code – ‘get500

4000

Register Now

Be Up to date

Message Sending...

Note : We Will Never Spam . You can Unsubscribe at Any Time

2017 © GITS ACADEMY . All rights reserved.