Tips4India
Checking Status...........
Buy Hitachi Window Air Conditioner at its lowest price
   Keyword        
  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
Subtotals
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
Styles
Protect Ranges & Worksheets

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

Goal Seeking
Solver
What-If

Scenarios
Create Scenarios
Create Summary Report
Merge Scenarios
Protect Scenarios

Macros
Create Macros Record

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

Outlines
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

 

YATCH INFOTECH

ADDRESS: RZ B1/48, RAGHU NAGAR, PANKHA ROAD,NEAR JANAK CINEMA, NEW DELHI-45 
CONTACT NO:
01124526399,9818085925
Email id: admissions@yatchinfotech.in, yatchinfotech@gmail.com
Website: www.yatchinfotech.in

 



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

Spoken Hindi classes in Trivandrum city [4 months ago]
Learn Spoken Hindi using the speed methodLearn in small groupsLearn from the beginningContact Tel.0471-230 5052Mob.9037514243Mob.9995542410
Spoken classes in Trivandrum city [4 months ago]
Learn Spoken English in one month using the speed method from a foreign experienced expertLearn to speak in 30 hoursFor higher speed learn for 120 hoursLearn to speak English without thinkingAnybody can learnLear public speaking with gesturesContact Tel.0471-2305052Mob.9037514243Mob.9995542410
साल बचाये इसी वर्ष करें Govt.University Approved  [5 months ago]
साल बचायेइसी वर्ष करें Govt.University Approved 10th,12th,B.A.,B.COM,B.SC,B.TECH,MBA,LLB,D.PHARMA,B.ED,M.ED,M.A,M.COM,B.PED,Much More..CALL @ +91 9887572191,+91 9887572173,+91 9772658090E-Mail-edu74233@gmail.com
ON/OFF LINE TRAINING ON PHP [6 months ago]
Training for Freshers and Experienced Person: • Advanced PHP • Php AJAX • Joomla • Jquery • Php MySQL • osCommerce • Apache tomcat • PHP Real Time Projects • PHP Web 2.0 • Smarty • Wordpress • Moodle • Drupal CMS • Codelgniter Fram...
AngularJs Training in Chennai [6 months ago]
Do You Want to learn Advance JavaScript Web application platform? Zuan Education offering Angular Js Training with Real time project. Call +90 9884868777 for Course Registration.
Online Test series for tspsc group 1 and group 2 examination [7 months ago]
Online Test Series For TSPSC & APSCC Group 1 and Group 2 Exams We Conduct For the Online Mock Test For Students aspiring for the Government Jobs weekly Topic Wise Test followed by the Grand Test at End. Reach us at www.thetestseries.in www.Facebook.com/thetestseries.inFee:130 rupees onlythis is one ...
Embedded Systems Training with placement assistance [8 months ago]
We are offering Hardware and Software courses with placement assistance..Our tieup companies are WIPRO,ACCENTURE,CTS,TCS,AMNET,ROBERT BOSCG,CATERPILLAR.If anyone interested please contact
Major training on Python Programming [8 months ago]
Build your career at Python Programming and be an expert in it. Appin technology lab conducting the major training on Python and the main goal of this is to provide the best knowledge to our students. for more information contact us on 0755-4209565, 9755996968. or www.atlbhopal.com.
Sorry ! This ad has expired or Pending.
 
Post Ad


   Hot Searches
excel advance excel