loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Advanced Excel Workshop in Pune for working professionals

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Excel4all Training & Consulting

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

course photo

Advanced Excel Workshop in Pune for working professionals

C D A, Pune - 411001

5,000
No Reviews Yet
1 Interested

About the Course


Unleash the power of Excel and become an Excel Pro 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 Excel4 all 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.


Topics Covered


• 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 combination of multiple functions • Pivot Table • If & Nested If • Sumif & Countif • Charts • 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 UN-authorised access. • Macros ( Basic, Run and Record Macro, Editing a macro, Designing your first macro program, Demonstration of macro tools)


Who should 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


Pre-requisites


Must Aware of the basic of Excel


What you need to bring


Laptop with MS Office 2010 version Installed."""


Key Takeaways


Soft Copies of the precise and handy reference material. Post Training Support for 90 days.

Gallery
Document

Advanced Excel Workshop in Pune...

Advanced Excel Workshop in Pun...


Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


Document

Advanced Excel Workshop in Pune...

Advanced Excel Workshop in Pun...


There are no Reviews yet. Be the First to Review

Date and Time

Saturday 10 Jun, 2017 -
Sunday 11 Jun, 2017

09:30 AM-05:30 PM

Register

Hurry, only 10 seats left!

Have a Question? Enquire Now

digital certificate Get Digital Certificate after course completion

cash back LifeTime Access. No Limits!

About the Trainer

Prabhas Panda

BCOM,PGDCA,CA, MBA,SAP(FICO)


He is a corporate trainer and facilitator with a creative bent of mind along with strong communication skills and understanding of various facets of training in alignment with the organizational goals.Having 15 years of experience as MS-Office trainer and 7 years of count as an automation consultant imparted training to different verticals of the industries. He strives for quality in everything he does. With wide exposure to the corporate culture, his training suits the various levels of competency among st the trainees. His coaching style and delivery method is quite unique and always welcomed by the professionals.

Seats Left10

Students Interested 1

100% Money Back
Guarentee
Call at 080-46614806
to book on phone

Course Id: 23980