Advance Excel Course

In this course, you will learn the concept of Advance Excel

Get Industry Ready

Seekho Computer is the best computer training institute in New Delhi which aims at providing computer training to students, professionals, housewives & everyone who require it in their day to day life. We have so far trained many students who are working in corporates.

Advanced Excel Skills

Course Modules

  • Fill Serial No.
  • CHAR
  • CODE
  • CONCATENATE
  • EXACT
  • FIND
  • LEFT
  • LEN
  • LOWER
  • MID
  • PROPER
  • REPLACE
  • REPT
  • RIGHT
  • SEARCH
  • SUBSTITUTE
  • T
  • TEXT
  • TRIM
  • UPPER
  • VALUE
  • DATE
  • DATEVALUE
  • DATEDIF
  • DAY
  • DAYS
  • EDATE
  • EOMONTH
  • MONTH
  • NETWORKDAYS
  • NETWORKDAYS.INTL
  • NOW
  • TODAY
  • WEEKDAY
  • WEEKNUM
  • WORKDAY
  • WORKDAY.INTL
  • YEAR
  • ABS
  • AGGREGATE
  • EVEN
  • FACT
  • INT
  • MOD
  • ODD
  • PI
  • POWER
  • PRODUCT
  • RAND
  • RANDBETWEEN
  • ROUNDDOWN
  • ROUNDUP
  • SQRT
  • SUBTOTAL
  • SUM
  • SUMIF
  • SUMIFS
  • SUMPRODUCT
  • AVERAGE
  • AVERAGEA
  • AVERAGEIF
  • AVERAGEIFS
  • COUNT
  • COUNTA
  • COUNTIF
  • COUNTIFS
  • COUNTBLANKS
  • LARGE
  • MAX
  • MIN
  • MEDIAN
  • SMALL
  • BIN2DEC
  • DEC2BIN
  • RANK
  • ISBLANK
  • ISERROR
  • ISEVEN
  • ISODD
  • ISNUMBER
  • ISTEXT
  • N
  • CHOOSE
  • COLUMN
  • COLUMNS
  • HLOOKUP
  • INDEX
  • INDIRECT
  • MATCH
  • OFFSET
  • ROW
  • ROWS
  • TRANSPOSE
  • VLOOKUP
  • XLOOKUP
  • AND
  • FALSE
  • IF
  • IFERROR
  • OR
  • TRUE
  • FV
  • NPER
  • NPV
  • PMT
  • PV
  • RATE
  • ***Format Painter
  • Cut/Copy/Paste
  • Formatting
  • Alignments
  • Text Orientation
  • ***Conditional Formatting
  • ***Format as a Table
  • Clear
  • Fill- Series
  • ***Flash Fill
  • Auto Sum (Alt + =)
  • Find & Select & Replace (Ctrl + F, Ctrl + H)
  • Delete
  • Wrap Text
  • Merge and Center

***Pivot table

Table (ctrl + T)

***Chart

***Hyperlink

Picture

Shape

***Smart Art

Word Art

Symbol

Equation

***Slicer (Pivot)

  • Print preview
  • Cell Width
  • Margin (Top/Bot/Left/Right)
  • Orientation
  • Hide or unhide (Row/Column) as per need
  • Size (a4)
  • ***Print area
  • Clear print area
  • Background
  • Remove background
  • ***Print title
  • Header and footer
  • ***Watermark
  • Page Break
  • ***Name Manager
  • Type 1 -Name Box
  • Type 2-Define Name
  • Type 3-Name Manager
  • Type 4- Create from Selection
  • Trace Precedents
  • Trace Dependents
  • ***Show Formula
  • ***Evaluate Formula
  • ***Error Checking
  • ***Sorting / Adv Sorting
  • ***Filter / Adv Filter
  • ***Data Validation
  • ***Remove Duplicates
  • Consolidate
  • ***What if Analysis
  • Group
  • Ungroup
  • Subtotal
  • Forecast (Function)
  • Flash Fill
  • ***Text To Column

***Protect Sheet

***Protect Workbook

***Protect File

***Custom Protection

***Freeze Panes

***Top Row

First Column

Custom (Row and Column)

Unfreeze Panes

CONNECT WITH US