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.
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
