Skip to main content

Advanced Excel 2010 Training | Indiaeve.com


Advanced Excel 2010 Training for Working Professionals on Sundays.Unleash the power of Excel and become an Excel Pro.

Advance Excel Workshop in Pune - 14th & 21st February 2016 (Sundays)

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 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 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.

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. 

Comments

Post a Comment

Popular posts from this blog

Why should you choose IndiaEve for upcoming events?

We know that plenty of event ticketing portals are available in the market. It’s quite difficult to find the exact one which will surely meet your needs. There is some unique reason for you to choose Indiaeve . Here listing some of the top reasons for you to consider IndiaEve for your upcoming events. User is our priority: It’s a user friendly site. The organizers can organize and sell their events online which means; you can list your event on Indiaeve and start selling your tickets within seconds. The organizers will get complete control of your event page like ticketing management, event management etc. While enabling booking process on Indiaeve, you can view your customer details. We never hide the details of your customers from you. IndiaEve establishes a long term relationship with our customers and keeps them updated on all the upcoming events in India. We try to give complete feel of system from initial stage itself! Categories offered by IndiaEve: It is a...
10 comments
Read more

Elusive Nightlife | Indiaeve.com

Elusive Nightlife ,The Anniversary Party will be held on May 07 2016 at 09:00 pm at SinQ Beach Club. Call it coincidence or call it fate, but if you are in Goa on 7th May then you can consider yourself very fortunate. Your plan for weekend is pretty much set at SinQ because going to the Elusive Nightlife 1st anniversary party is an absolute no-brainer. A mouthwatering line-up (TBA) to tear you down and make you dance as it's our first birthday - from night till the wee hours of the morning. Join us as we celebrate a year of Elusive Nights, The Get Together Goa, Pre Saojoao bash, Saojoaobash, Colorland Goa, Beach Please, Let The Bass Go Boom and many more.. Thanks to everyone who came to any of our event in the recent past. See you for a piece of cake and there is no way you can miss out on our birthday bash! Call it coincidence or call it fate, but if you are in Goa on 7th May then you can consider yourself very fortunate. Your plan for weekend...
10 comments
Read more

Let’s Play Holi!

India has plentiful festivals and cultural occasions to celebrate. Have you wondered how blessed India is to have so many diverse culture, language, region and religion? Diversity has indeed blessed India with so many occasions for getting together and events to celebrate. Holi, for instance, is one national Hindu festival that enunciates the real meaning of “festival of colors”, “festival of spring” and “festival of love”. Holi is not confined as a festival that is celebrated among Hindus alone, but Non-Hindus also share the love and spirit for the festival. The colours, the splish-splash, the Holi games and there is a lot more that makes you fall in love with Holi. Let us get to the big question- Why do we celebrate Holi? The reason why Holi is celebrated is pointed out in the ancient book of ‘Bhagavata Purana’. There was an ‘Asura’ king called Hiranyakashipu who had a very special boon- he could neither be killed by a man nor an animal! This made Hiranyakashipu invi...
Post a Comment
Read more