Contents:
Overview of the Basics
- ‘Save-as’ techniques such as Excel Templates, Excel Binary workbook
- Understanding Compatibility mode, Extension types, File Conversion
- Enabling & working on Drag handlers, Double click method
Types of important functions
- Arithmetic functions
- Logical Functions
- DB-Functions (Database functions)
- Text Functions
Hlookup and Vlookup
- Hlookup
- Vlookup
- Understanding FALSE (0) v/s TRUE (1) in VLOOKUP (or HLOOKUP)
- Using the Name Range concept in VLOOKUP (or HLOOKUP)
Sort and Filter
- Sorting
- Filtering
- An example of Advanced Filter
Pivot Table
- Introduction to Pivot Table field list and Pivot Layout
- Creating a Pivot report out of a given data
- Working with various features of Pivot like Grouping, Ungrouping
- Creating Multiple sheet wise reports out of one Pivot
- Modifying the given data range into a TABLE to make a dynamic Pivot
- Charts and different types of Charts
Introduction to Macros
- What is Macro
- Basics of recording macro
Other useful functions
- Customizing lists
- Referencing techniques, Array (matrix) technique
- Creating drop down lists
- Applying conditional formatting
- Consolidation
- Entire Workbook Protection (Document Encryption) & Specific Sheet Protection
- Determining day of the week from a given date
- Calculating the difference between two dates in terms of days, months & years
Methodology: Instructor led classroom program with hands-on activities on participants’ laptop
Medium of Instruction: English and Hindi
Participation Level : • Working professionals, managers or anyone who has basic knowledge of MS Excel
Participants should have basic knowledge of MS Excel
Participants need to arrange their own laptop
Registration Fee : Early Bird Discount: Rs. 4,900 plus GST at prevailing rate per participant if the fees are paid on or before early bird date
Rs. 5,900/- plus GST at prevailing rate per participant which includes refreshments, buffet lunch & reference material.
The facility to pay fees after the program date may be provided on payment of additional convenience fees. For further details, please contact our office. Overnight stay arrangement, if any, needs to be managed by participant.
Cheque/Demand draft should be drawn in favour of “SATVAM Consulting Private Limited” payable at Mumbai. Our Income Tax PAN is AAICS5300G & Service Tax Assessee code is AAICS5300GST001
Cancellation policy: Fee is non-refundable or non-adjustable in any manner. However, replacement of the participant is allowed in same batch. The company reserves the right to alter the venue, cancel or postpone the program with the limited liability to refund the total fees.
Prior registration for the program is mandatory
Nomination :
Please send nomination along with the cheque and name/contact numbers/ email ids of the participants at
SATVAM Consulting Private Limited – Corporate Training Section
61, Whispering Palms Shopping Centre, Near Oriental Bank of Commerce,
Lokhandwala Township, Akurli Road, Kandivali (East), Mumbai – 400101
Telephone nos.: 022 – 6698 1100 (6 Lines) Fax: 022 – 6698 1105
Email: seminar@satvamindia.com /seminar@satvam.com Website: www.satvam.com
Nomination will be confirmed on first come first serve basis on receipt of cheque/DD.
The option to make payment through NEFT available, please contact us for bank details
Faculty profile :
- Expert Faculty from SATVAM Consulting
In-house Training Program : br />
In-house Training Program:
If you have more than 10 employees to whom this program is relevant, we will conduct customised training programme for your company’s staff. Please contact us to work out further details – Email seminar@satvam.com / seminar@satvamindia.com or call 022-66981100
Our forthcoming programs : br />
Our forthcoming programs:
For complete training calendar & brochure, visit our website www.satvam.com or call on 022-6698 1100 or drop an email at seminar@satvamindia.com or seminar@satvam.com