Checking Status...........
Buy Hitachi Window Air Conditioner at its lowest price
  Follow us : Facebook  Twitter  Google Plus  RSS Feed
AD Id #40491 | Share | | 0 Votes
Advance Excel in 10 Days with professional Database and Expert Faculty (Study Material Available)
Education & Learning >> Short Term Programs | Delhi & NCR»Janakpuri | 21-Oct-2010

Advance MS Excel Course Content

Advanced Functions
 IF Function & Nested IF Statements
And & Or Functions
Lookup Functions (Horizontal And Vertical Lookup)
Index Function
Array Function
Conditional Formatting

3D Ranges

Create & Maintain (Within Worksheets In a Single File & Between External Files)
Consolidate Data (via 3D Ranges & Using The Consolidate Tool)

Pivot Tables
Create Pivot Table
Work With Row/ Column Fields
Data Fields
Customise Table Display

Organising Workbooks
Create Templates
Protect Ranges & Worksheets

Enter & Select Records Using The Input Form
Sort Data Into Lists
Filter Data - Autofilter, Advanced Filter
DataBase Functions
Validation Rules

Goal Seeking

Create Scenarios
Create Summary Report
Merge Scenarios
Protect Scenarios

Create Macros Record

Relative Referencing
Assign To Toolbars/ Keyboard
Make Available To All New Documents/ Current Document Only

Group Row/ Column Data To Create Outline Levels Based On Worksheet Formulae
Display Summary Rows And Summary Styles

Custom Views
Create, Modify, Delete
Include Hidden Rows, Columns, Filter Settings

Report Manager
Create, Modify, Delete
Create Sections (Sheet, View1, Scenario)
Add Sections
Specify Page Numbering



Email id:,


Related Ads found for "Advance Excel in 10 Days with professional Database and Expert Faculty (Study Material Available) "

AFCAT + SSB Coaching offered by retd officers [3 years ago]
AFCAT + SSB Coaching offered by retd officersvisitwww.ssbcoaching.comssb interview + AFCAT + PABT + Books and CDs45 days course15 Dec on wordsRs. 15,500 onlycontactdefence academy coimbatoreat 094437
excelNaval Services Selection Board Interview Coaching offered by experts  [3 years ago]
Naval Services Selection Board Interview Coaching offered by experts Gp testsmock interviewspyscho matric testsscreening testspabtcomplete package offered atdefence academy coimbatoreduration - 10 dayscontact colonel jayavelat 094437 20076visit
spoken English and interview training offered [3 years ago]
Spoken English Training offered bydefence academy coimbatore094437 20076 Medical College Entrance Exam Kit-2014 094437 20076
Combined defence services written exam coaching academy- at Coimbatore [3 years ago]
Combined defence services CDSE - II written exam coaching academy- at Coimbatore Defence Academy Coimbatore offers 45 days crash course for CDSE - II contact 094437 20076
Free B.Tech with stipend after + 2 for boys offered [4 years ago]
Free B.Tech with stipend after + 2 for boys offeredIndian NAVYIndian Army OffersFree Tech With StipendNo written testOnly an Interviewwe, at the Defence Academy offerServices Selection Board Interview Trainingduration 10 dayswith food , study ki and accm we charge Rs. 8000 onlywe have all the three ...
Corporate training + SSB Interview Coaching combination training [4 years ago]
Junior executive programme that offers an opportunity for the young graduates to get trained to become officers in the armed forces. we train you to face the Selection process of Any MNC company Interview Any type of Services Selection Board Interview + Adventure trip inbuilt in it. contact : 94437 ...
English communication Skills Trainer Hyderabad [4 years ago]
Excel in the Art of Effective CommunicationAccent Training for BPO and CALL CENTER EmployeesSpoken English Coaching Programs and AccentGrammar, Presentation skills and Conversation PERSONAL CLASSES ONE ON ONE AND online training conductedContact : Anita Soi Masab TankHyderabadPhone: 66774372/ 9704...
Sainik- RMS- RIMC Entrance Coaching for 2013 admission [4 years ago]
Services Selection Board Interview- Preparation CDs Four Cds that will guide you step by step to achieve success at the SSB Interviews Conducted by the ARMY NAVY AIR FORCE COAST GUARD NATIONAL DEFENCE ACADEMY INDIAN MILITARY ACADEMY NAVAL ACADEMY ARMY CAD...
Sorry ! This ad has expired or Pending.
Post Ad

   Hot Searches
excel advance excel