Category:

Excel training is one of the most important training which is desired by all organization irrespective of what profession we are going to work. One we move further to deal with data, reporting and data analysis the Advance Excel Training is required.

BINT is one of the prestigious institutes in Bangalore which provides training on all MS Office packages that includes MS Word, Excel, Powerpoint. It has the experienced and professional faculty who are capable to make the student ready to take the challenge of the professional world. It focuses 70 % on practical and 30 % on a theory which makes the BINT stand out among other institutes.

Coursed Content Under Advance Excel Training

Formulas FunctionsBasic FunctionsAdvance
  • sum
  • sumif
  • replace
  • find,
  • len,
  • Month,
  • year,
  • vlookup,
  • hlookup,
  • rand,
  • ifiserror,
  • match,
  • Transpose etc
  • Pivot Table
  • Conditional Formatting
  • Name Function
  • Macros
  • Creating hyperlink
  • Creating Chart, Bar diagram,
    Pie chart etc
  • Creating Header and Footer
  • Inserting Wordart and Object
  • Creating Organization chart
    – Sub ordinate and Peers
  • Data Validation Function
  • Merger and Wrap Text
  • Protecting sheet, cell, worksheet
  • Filter, auto filter
  • Import and export data
  • Sort
  • Locking and unlocking sheet,
    cell, worksheet
  • Split and Freeze Plain
  • Creating and converting PDF from excel
  • Adding, editing Comment in cell
  • Grouping and Ungrouping Cell

 

 

There are no reviews yet.

Be the first to review “Advance Excell”