Call (+91) 99 9947 8409 Email adhyayananeducationtrust.com Query Click to Send Query Pay Click to Pay Online

Advanced Excel

WHAT IS ADVANCED EXCEL?

Excel is a software program from Microsoft that is part of the Microsoft Office suite of software programs. Developed by Microsoft and first released on September 30, 1985, Excel is capable of creating and editing spreadsheets that are saved with a .xls or .xlsx file extension. General uses of Excel include cell-based calculation, pivot tables, and various graphing tools. Unlike a word processor, such as Microsoft Word, the Excel documents consist of columns and rows of data, made up of individual cells. Each of these cells can contain either text or numerical values that can be calculated using formulas.

 

Download Syllabus

Excel-master-course.pdf

 

 

Core & Advance Excel

  • SUM
  • SUMIF
  • SUMIFS
  • COUNT
  • COUNTA
  • COUNTABLANK
  • COUNTIF
  • COUNTIFS
  • AVERAGE
  • AVERAGEA
  • AVERAGEIF
  • AVERAGEIFS
  • SUBTOTAL
  • AGGREGATE
  • RAND
  • RANDBETWEEN
  • ROUNDUP
  • ROUNDDOWN
  • ROUND
  • SUMPRODUCT
  • MOD
  • SQRT
  • POWER
  • FACT
  • CONVERT
  • ROMAN
  • CHAR
  • CLEAN
  • CODE
  • CONCATENATE
  • FIND
  • SEARCH
  • SUBTITUTE
  • REPLACE
  • LEN
  • RIGHT
  • LEFT
  • MID
  • LOWER
  • UPPER
  • PROPER
  • TEXT
  • TRIM
  • VALUE
  • DATE
  • DAY
  • MONTH
  • YEAR
  • EDATE
  • EOMONTH
  • NETWROKDAYS
  • WORKDAY
  • WEEKNUM
  • WEEKDAY
  • HOUR
  • MINUTE
  • SECOND
  • NOW
  • TODAY
  • TIME
  • AND
  • OR
  • IF
  • IFERROR
  • NOT
  • NESTED IF
  • VLOOKUP
  • HLOOKUP
  • INDEX
  • MATCH
  • OFFSET
  • INDIRECT
  • ADDRESS
  • COLUMN
  • COLUMNS |ROW
  • ROWS
  • CHOOSE
  • ARRAYS
  • CONCEPT IN LOOKUP FORMULA

START PLANNING YOUR NEW DREAM

We strive to provide Our Customers with Top Notch Support to make their Theme