Times of India: "Sophisticated online financial planning software" --> FREE Limited time offer: Sign Up Now
Career Development » Training » Advanced Excel workshop for Professionals in Pune

1439 Views
  0 Replies

+1
Vote Vote
Advanced Excel workshop for Professionals in Pune
Prabhas
Prabhas Picture
4 Posts
back to top
Posted 08-07-2016Reply

Unleash the power of Excel and become an Excel Pro



Advance Excel Workshop in Pune – 31st July & 07th August 2016



Objective:

Microsoft Excel, is the widely used program across the world, which is used for performing numerous computations, manipulations and compilation of data. There are so many useful features that are available on this spreadsheet application, which go unused. Hence Excel4all has designed a two days’ workshop not only to empower the participants with the unexplored features, tools, hidden functions and tips and tricks in Microsoft Excel but also to save TAT, work smart and fast and also can apprehend the significant growth in their productivity. JOIN the workshop and make the difference at your workplace.



Who Can Attend:

This workshop would be very useful to participants across various industries and functional specializations such as MIS, Finance, Marketing, Operations, Human Relations, Information Technology and Administration.



Contents in Brief:

• Excel 2010 Quick Overview with exploration of QAT.

• Overlook basics

• Fill Series

• Absolute Referencing

• Define Name

• Date Functions, Formatting and customisation

• Data Formatting, types, and clean

• Text Functions

• Condition Formatting with formulas

• Data Sorting & Filter along with advanced filter

• Data Validation to prevent errors and saving TAT

• Vlookup & Hlookup with Dynamic Criteria.

• Pivot Table with MAQ Features.

• If & Nested If

• Sumif & Countif

• Charts with 3D, Paretto, Combo, Pie and Formula based Graphs etc.

• Advance Filter with Formula.

• Advance Sorting with multi level sorting and sorting from left to right

• Group & Outline and Auto outlining

• Consolidation of multiple workbooks and worksheets

• Subtotal for preparing a quick summary out of any data

• Custom List to define your own list and work conveniently

• Link & Hyperlink to create a link and share information

• Sharing & Protection to protect data from unauthorised access.

• Macros ( Basic, Run and Record Macro, Editing a macro, Designing your first macro program, Demonstration of macro tools)



Course Benefits:

• Workshop is at a 3 Star Business class hotel with professional ambiance and amenities.

• Comprehensive Course Coverage

• Certified Master Instructor

• Hands-on-Training

• Excel Tips, Tricks and Best Practices

• Post training Support for 90 days

• Soft Copies of the reference manual and hands in exercise.

• ROI is more than 100% definitely.



Course Investment:

INR 5,000 / Participant.

Breakfast, Snacks, Lunch will be complementary



Venue:

Hotel Sagar Plaza, No:1, Bund Garden Road, Camp, Pune-411001

Near New Zilla Parishad or opposite to SGS Mall.

Seats are limited. Please be hurry.



Terms & Conditions:

Once registration is confirmed, cancellations or refunds will not be entertained.

Participants need to bring laptop installed with MS Office 2010.

Participants need to report the venue by 9.30 AM.



For any further details, queries or clarifications and Registration:

Please Call : +91-7875726961 or +91-9049824030

Email Us: Training.Pune@yahoo.com or Excel4all@outlook.com

Visit Us: http://www.excel4all.in/



Source: www.excel4all.in
Attached Files
Advanced Excel Workshop.pdf (453.7 KB, 3 views)
 
+1
Vote Vote
Lessnote

Recently in HR Forums

Praveen gave to Suresh's reply to forum topic Recruitment proposal to colleges
11 days ago
Praveen gave to Suresh's reply to forum topic Recruitment proposal to colleges
11 days ago
Nijanth gave to Kartheka's reply to forum topic Standard Salary Structure
19-09-2017
Nijanth gave to Kedar's reply to forum topic Standard Salary Structure
19-09-2017
Jun gave to Koti's reply to forum topic Standard Salary Structure
14-09-2017
 
Recent (10) | HR | Both
HR | Both   1 of 10