Offer Price at just Rs. 999/- Limited Period Offer !!!
Offer Price at just Rs. 999/- Limited Period Offer!!!

ADVANCE EXCEL TRAINING
Usefull for Entreprenuer and HR Professional
Learn excel concepts and forumla whcih are used in HR and day to day work for business.
ADVANCE EXCEL TRAINING
Usefull for Entreprenuer and HR Professional
Learn excel concepts and forumla whcih are used in HR and day to day work for business.

Detailed Content of Advance Excel Seminar

  • Excel Introduction
  • Cell Formatting
  • Format Cell
  • Custom List
  • Conditional Formatting with Formula
  • Fill Option
  • Justify Data
  • Protect Sheet/ Cell/ Workbook
  • Calculation of Pension
  • Font, alignment, table making, spell check, line removal

  • count
  • Counta
  • Countblank
  • Countif
  • Countifs
  • istext
  • Today
  • Now

  • SUMIF
  • SUMIFS
  • AVERAGE IF
  • DSUM Formula
  • Daverage
  • Dget
  • Match & Index
  • Lookup
  • Hlookup
  • Pivot Table
  • Query
  • Vlookup with 7 Examples
  • Mail Merge Excel data go into word
  • Data Merge Jan to december in one sheet

  • Upper
  • Lower
  • LEN
  • TRIM
  • Concatenate Function
  • Text to Column
  • Hyperlink
  • LEFT/RIGHT/MID FUNCTION
  • Flash Fill
  • SUM Formulas
  • Average Formulas
  • Min/ Max Formula
  • SUM Product
  • Conditional formatting

  • IF Function
  • IF & "AND" Function
  • IF AND & OR Function

  • Charts
  • Secondary Axis Chart etc…

  • Online Exam and Certificate thereafter

Who Will Buy

HR Professional

Entreprenuers

Benefits

  • ​Making You Better at Organizing Data.
  • ​Career enhancement
  • ​Get Mail & Telephonic support
  • ​Use Excel to Grow a Business
  • ​ Handle Small and Big Data Better with Excel
  • ​ Assignment & Certificate
Register for Free Demo Course

Address: 102, Panchali Shopping Center, Above Nagrik Stores, Near Ashok Cinema, Thane West

Email : hr@apt-resources.com Contact us @ 8655040102/ 8355987442