P.A.C.E(IIM Alumni Venture) announces a 2-Day workshop on MS-Excel on 19th July

 Greetings from P.A.C.E (www.pacegurus.com) , An IIM Alumni Venture for Financial Trainings

About Us:

 

P.A.C.E (An IIM Alumni Venture) is set up with an objective to provide Comprehensive Training & Consulting Services in the areas of Investment & Quantitative Finance. We have a Training Facility in Kukatpally, Hyderabad and we train students for various Finance & Insurance Certifications like CFA, CFP, FRM, CAIA, PRM, NCFM, III, Actuarial Sciences, Financial Modeling with Excel, Business Analyst, Project Management and various other courses.

 

Workshop Details:

 

Topic: Basic & Advanced Excel

Duration: 2 Days (19^th & 20^th July 2010)

Venue: P.A.C.E, KPHB, Hyderabad (Our Address is Furnished Below)

Timing: 9AM to 5PM

Fee: Rs. 3,000 per Participant

Discount: 10% if registering in group of five.

 

Objective of the workshop

 

Ø  Enhance MS Excel skills through Exercises on various Topics

Ø  Getting a good understanding of Basic as well as Advanced Functions & Features of Excel

Ø  Increase the comfort level of participants in using the best practices

Ø  Aids the participants to perform their spread sheet related tasks more efficiently

 

Faculty Profile

 

Vamsidhar Ambatipudi (Founder – Director of P.A.C.E)

 

Ø  Alumnus of IIM Indore (2001 batch pass out)

Ø  B.Tech (Computer Science from AU College of Engineering)

Ø  9+ years of experience in IT Industry in Financial Services Sector

Ø  Possesses various National & International Certifications in Finance, Insurance, IT & Quality

Ø  Provided Services to Fortune 500 Clients in the BFSI Sector

Ø  Visiting Faculty in Finance at various Business Schools in Hyderabad

Ø  Conducted Corporate Trainings at companies like Satyam, Polaris, ICICI Prudential, PWC etc

Ø  Guided many MBA students in their Summer Internship projects

 

 

Course Content for the Workshop

 

Basic Excel
Excel Menu Commands	Workbook & Worksheet
Formatting  & Validations	Protections
Charting in Excel
Using the Chart Wizard	Chart Options & Formatting
Different Chart Types	Usage of Multiple Axes
Basic Excel Functions
Logical Functions	Arithmetic Functions
Date Functions	Text Functions
Aggregation Functions	Statistical Functions
Basic Excel Tools
Conditional Formatting	Sorting & Filtering
Pivot Table	Names Manager
Advanced Formulae
Lookup Functions	Referencing Functions
Database Functions	Financial Functions
Advanced Excel Tools
Auditing & Tracing Errors	Importing & Exporting Data
Goal Seek	Data Table
Scenario Manager	Solver
Introduction to Macros
Recording a Macro	Running the Macro
Basic Editing of the Macro	Assignment of Macro

 

 

Contact Details

 

P.A.C.E

 Flat No: 203,  Uday Krishna Commercial Complex,

 Behind Bank of India, Above K S Bakers,

 Near KPHB Bus stop, Kukatpally,

Hyderabad.

 

Cell No:     98480-12123.

Website:    www.pacegurus.com

 

 

Click here to unsubscribe