• References
o Relative references
o Mixed references
o Absolute references
• Logical functions
o IF, Nested IF
o AND, OR, NOT
o IF with AND, OR, NOT
• Statistical functions
o SUM
o SUMIF
o SUMIFS
o COUNT
o COUNTA
o COUNTBLANK
o COUNTIF
o COUNTIFS
o AVERAGE
o AVERAGEIF
o AVERAGEIFS
o MIN
o MAX
o MEDIAN
o STDEV
o VAR
o SMALL
o LARGE
o FREQUENCY
• Text Functions
o LEN
o LEFT, RIGHT, MID
o UPPER, LOWER, PROPER
o TRIM
o SEARCH, FIND
o SUBSTITUTE, REPLACE
o CONCATINATE
o REPT
o CHAR
o T, TEXT
o VALUE
o EXACT
o NUMBERVALUE
• Combining above functions and create complex functions
o Extract First word
o Extract Middle word
o Extract Last word
o Word Count
o Data Cleanup
o Case Sensitive IF function
o Partial Match with IF Function
o Dependent Dropdown list
o Debug and Evaluate Formula & Functions
o Trace Dependents
o Error Checking
o Trace Error
• Information Functions
o IFERROR, ISERROR, ISERR, ISNA, ERROR.TYPE
o ISTEXT, ISNONTEXT, ISBLANK
o ISEVEN, ISODD, ISNUMBER
o ISLOGICAL, ISFORMULA, ISREF
o N, NA, TYPE
• Lookup Functions
o VLOOKUP with FALSE and TRUE
o VLOOKUP with Wild Card Characters
o HLOOKUP
o MATCH with match type 0, -1, 1
o INDEX Variant 1
o INDEX Variant 2
o 2D Lookup
o Dynamic VLOOKUP
o VLOOKUP With Multiple Criteria
• Reference Functions
o OFFSET
o CHOOSE
o INDIRECT
o ROW, ROWS
o COLUMN, COLUMNS
o TRANSPOSE
o AREA
o ADDRESS
• Math Functions
o ROUND, ROUNDUP, ROUNDDOWN
o FLOOR, CEILING
o EVEN, ODD
o LCM, GCD
o FACT
o INT, DECIMAL
o SQRT, POWER, EXP
o MOD, QUOTIENT
o RAND, RANDBETWEEN
• Date and Time Functions
o DAY, MONTH, YEAR, HOUR, MINUTE, SECOND
o DAYS, DAY360, DATEDIFF
o WORKDAY, NETWORKDAYS
o WEEKNUMBER, WEEKDAY
o TIMEVALUE, DATEVALUE
o NOW, TIME, DATE, TODAY
• Database Functions
o DSUM
o DCOUNT
o DAVERAGE
o DMAX
o DMIN
o DPRODUCT
o DSTDEV
o DVAR
• Financial Functions
o Future Value (FV)
o Present Value (PV)
o Payment(PMT)
o Net Present Value (NPV)
o Internal Rate of Return (IRR)
o Number of Period (NPER)
o Interest Rate Per Period (RATE)
o Straight Line Depreciation (SLN)
What is special in this course compare to other trainers?
• 26+ Years real-time experienced Software Professional.
• Teaching from the basic to advanced topic in methodological way.
• Create complex functions with simple steps
• All concepts will be explained with realtime data
• Each complex functions concept will be explained in step by step in depth.
• On the spot practice
• Case Studies and Assignment for each concepts
• Online objective type test to check you knowledge
• Interview tips
Who should take up Excel course?
Software Engineers and Data Analysts
Business Intelligence Professionals
Financial Specialist
Students
Any one who wants learn excel in depth
What are the prerequisites?
Basic computer knowledge and installing software is required.
Participants should aware Basic Excel functionalities like Cut,Copy,Paste,Insert Rows, Delete Rows, Hide Rows, Formating (Font, Color, Alignment, Merge Cells), Sort, Find, Replace, Page Layout