Important Instruction

This section is for the I Turn Faculty and students only. Online Sign up is not available. For this technical cordinator need to contacted.

Teachers Login Here

Teachers Login Form

 

Pupils Login Here

Pupils Login Form

 



Learning MS Excel at I Turn Institute

Microsoft Excel is a spreadsheet application developed by Microsoft Inc for Microsoft Windows and MAC OS X. Its use is to do advanced calculation, graphing tools, pivot tables, and a macro programing language referred to as Visual Basic for Applications. The course curriculam in I Turn Institute is one of the most comprehensive and most advanced. Here you will trained from the very basic till the most advance level.Here the training will be on the latest MS Excel 2010. We provide flexible timings avalabilty and limited batch size and 7 days Lab facility. Fill the enqiry form for more details or to fixed a Demo session.


MS Excel Course Highlight

  • Understanding Excel Structure and related Jargons
  • Customize Ribbons, Managing Tabs, Groups and creating your own Tab options.
  • Get to know data Formating options
  • Creating varius kind of Smart art - like Hierarchy structure, process flow etc
  • Exploring Hyperlink options
  • Exploring Auto Fill options - Text, Numbers & Dates
  • Exploring Array Function like TRANSPOSE, FREQUENCY etc
  • Working with TEXT-TO-COLUMN option
  • Data organising with Conditional Formating - using of Functions in it.
  • Text Function like: EXACT, FIND, LEFT, RIGHT, MID, FIND, REPLACE, SUBSTITUTE, LEN, LOWER, UPPER, PROPER,REPT, TRIM, TEXT, SEARCH, CONCATENATE and more
  • Advance TEXT Function and Nesting methodology in it to get the desired result
  • Logical Function like: IF, AND, OR, NOT, IFERROR and more with nested Live examples
  • Equatinal Function like: SUM, COUNT, AVERAGE, MAX, MIN, LARGE, SMALL, SUMIF, AVERAGEIF, COUNTIF, SUMIFS, AVERAGEIFS & COUNTIFS
  • Creation of EMI Calculator and Data Table option to create Loan, Insurance and analytics related table..
  • Lookup & Reference Function like: CHOOSE, COLUMN, COLUMNS, H LOOKUP, VLOOKUP,INDEX, MATCH, LOOOKUP, TRANSPOSE, ROW, ROWS etc
  • Advance Array V-Lookup & Reference Function and its nesting methodology.
  • Troubleshoot Date and Time related problems
  • Working with Date and Time Functions
  • Chart Preparation & Sparklines
  • Organising big data with Pivot Table and exploring Power pivot and Pivot chart..
  • Importance of Goal Seek & Scenario Manager
  • Working with Data Validation and learning its advance custom feature
  • Protect Workbook, Worksheet, any Cell, Hidding Formulas, Password enabled excel file.
  • Recording Macros

Batch Detail (Classroom Training - Noida Centre)

Starting Date Batch Timings Batch Type Duration Register
08-Apr-2017 012:00PM Weekends 2 Month Register Online
10-Apr-2017 10:00AM Weekdays 1 Month Register Online
17-Apr-2017 5:00PM Weekdays 1 Month Register Online
22-Apr-2017 09:30AM Weekends 2 Month Register Online
24-Apr-2017 08:30:00AM Weekdays 1 Month Register Online

MS Excel Online Training- UDEMY (50% OFF)

  • Simple Approach and Advance Level Training Content
  • Do Training at your own pace and conveniance.
  • Lifetime Validity (Unlimited Access)
  • Well Researched video content from very experience faculty
  • Course Completion Certificate