e-CREATORS COMPUTER INSTITUTE

THEORY WITH PRACTICAL
Home Gallery Student's Project Tie Ups Blogs Placements About Us ☰

come & visit

"Let's Invest Your Precious Time." Enquiry Form Login


Advance Excel Contents

  • FACT
  • FACTDOUBLE
  • SUM
  • PRODUCT
  • LCM
  • SUBTRACTION
  • DIVIDE
  • MOD
  • POWER
  • PI
  • RANDBETWEEN
  • ROMAN
  • AND
  • OR
  • TRUE
  • XOR
  • IFERROR
  • COUNTIF
  • COUNT
  • IF
  • IFS
  • NESTED IF
  • SEARCH
  • UPPER
  • PROPER
  • LOWER
  • LEFT
  • RIGHT
  • MID
  • REPT
  • REPLACE
  • TRIM
  • TI
  • SUBSTITUTE
  • CHAR
  • CODE
  • DOLLAR
  • LEN
  • DATE
  • TIME
  • MONTH
  • YEAR
  • DAY
  • HOUR
  • MINUTE
  • DATEVALUE
  • DATEDIF
  • EOMONTH
  • EDAY
  • WEEKDAY
  • NETWORKDAYS
  • DAYS
  • DAYS360
  • TODAY
  • NOW
  • AVERAGE
  • AVERAGEIF
  • AVERAGEIFS
  • COUNT
  • COUNTIF
  • COUNTIFS
  • MIN
  • MAX
  • SUMMIN
  • SUMMAX
  • COUNTBLANK
  • COUNTA
  • PMT
  • PPMT
  • IPMT
  • IRR
  • DB
  • NPV
  • ACCRINT
  • DDB
  • SLN
  • DDB
  • VLOOKUP WITH MATCH
  • INDEX WITH MATCH
  • VLOOKUP WITH COLUMNS
  • IF WITH SUM
  • IF WITH OR
  • IF WITH AND
  • IF WITH NOT
  • IF WITH IF
  • IF WITH IF AND PERCENTAGE
  • SEARCH WITH RIGHT
  • MATCH WITH EXACT
  • SUM WITH MAX
  • MAX WITH SUM
  • SUM WITH MIN
  • MIN WITH SUM
  • IF WITH MULTI CONDITION
  • REVERSE VLOOKUP
  • VLOOKUP WITH ARRAY
  • VLOOKUP
  • HLOOKUP
  • XLOOKUP
  • INDEX
  • MATCH
  • ROW
  • COLUMN
  • ROWS
  • COLUMNS
  • TRANSPONSE

  • Ribbon Tour
  • Quick Filtering
  • Filtering by Multiple Criteria
  • Saving the Filtered Data
  • Performing Calculations on Filtered Data

  • Defined
  • Basic PivotTable Data
  • Inserting a Pivot Table
  • PivotTable Geography

  • Adding row labels
  • Adding column data
  • Changing formulas in columns
  • Changing headers
  • Number formats

  • Adding Multiple row labels
  • Collapsing and expanding
  • Drill down to data
  • Sorting & refreshing

  • Grouping by dates
  • Grouping by ranges
  • Show items with no detail
  • Show values in empty cells
  • Grouping across columns

  • User defined groups
  • Adding / removing subtotals

  • Using formulas on Pivoted data

  • Displaying multiple row labels in columns
  • Tabular form

  • Report Filters
  • Report Slicers
  • Expanding Filter Results to individual Tabs
  • CONSOLIDATION BETWEEN SHEET
  • CONSOLIDATION WITH LINK OF WORKBOOK
  • CONSOLIDATION BETWEEN WORKBOOK