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

Popular posts from this blog

Free Seminar On Business Analyst Opportunities And Career Prospects | Indiaeve.com

Free seminar On Business Analyst Opportunities and Career Prospects in IT for Non-IT people will be held on 30th Apr 2016 . You want to become a "Business Analyst" to advance your career in Software Industry/IT?  COETL conductucting FREE SEMINAR ON "Business Analyst Opportunities and Career Prospects in IT for Non-IT people. We understand, join to become a Business Analyst is unique to every individual as to your circumstances and background. That is what we belive working with you on one-to-one approach to understand your current circumstances and background. that is why we have a great transition plan specific to suits to reach your Business Analyst goal. Our Business Analyst Program also includes essential instructional Business Analyst Training with live client interactions an conceptual clarity. Surely you will get exposure to Real time Business Scenarios.We will impart correct foundation knowledge and practical skills to become an efficient Busine

Hawaiian Theme Party | Indiaeve.com

Hawaiian Theme Party will be held from 24 June -25 June at Capitol - The Ashok. Be in Delhi, but enjoy the feeling of Hawaii this Friday at Capitol Club.  Props will be provided at the entry desk. The foot tapping music will be played by DJ Anuj and Param. DJ Anuj : Raised in Jaipur, DJ Anuj absorbed since during his college days in 2008 .His passion for Music started when he accidently switch on to a demo software given by his friend, which led him the way he always wanted to be, in the world of dj. He joined a sound provider company to learn the industry instruments better. Quickly developing his skills, he configures his style of music which separates him from the others. His performances of mixing western flavors with slices of Bollywood beats ensured sharing joy to the people. Music brings in him vibes of spirituality, it connects with his conscience, it fills him with zeal, enthusiasm and it's his commitment to music lovers to make them feel that, the song

Gartex India In New Delhi | Events In India - www.indiaeve.com

Gartex India in New Delhi event repeats daily until 29 Aug 2016: 27 Aug, 28 Aug, 29 Aug. GARTEX: Complete Garment Manufacturing Solutions Show    Gartex is a comprehensive tradeshow on garment textile machinery. The show is targeted to address the interests of those who wish to reach out to the textile and garment machinery & accessories market in India.  Acting as the definitive gateway to provide excellent quality and one-stop selling and sourcing platform, the event will showcase products, services and technologies related to the complete production chain.  DIGITEX: An exclusive show on digital textile printing technologies  With a committed focus on promoting the Indian Digital Textile Printing Industry, Digitex will serve as an innovative platform for digital textile printing technologies by showcasing the latest developments in textile printing machinery, inks, software and services.  Fashion ‘Fabs’ Show: The Fabrics Show The Fabrics Show is being launched to cater