LOADING
Click here to view your shopping cart contents and to proceed to the Checkout. All prices are once-off and there is no time limit on the use of our templates.
 
  • Excel 2010 | Excel Functions
Our Excel training resources include more than 80 Excel 2010 tutorials that provide comprehensive guidance on how to use more than 100 Excel functions. These functions are an integral part of designing worksheets and performing calculations in Microsoft Excel. A thorough understanding of Excel functions is therefore an essential component of Excel skills. In order to use Excel functions effectively, you need to develop an understanding of the purpose of each function, when to use which function and the function arguments that need to be specified when entering or inserting a function. Our comprehensive and practical online tutorials are guaranteed to enhance your Excel function skills. This page includes a list of all the Excel functions that are covered in our Excel 2010 training tutorials.
 
 
  • Math Functions
  • AUTOSUM
  • SUM
  • SUBTOTAL
  • ABS
  • ROUND
  • ROUNDUP
  • ROUNDDOWN
  • TRUNC
  • MROUND
  • INT
  • TRUNC
  • EVEN
  • ODD
  • RAND
  • RANDBETWEEN
  • SQRT
  • Text Functions
  • TEXT
  • VALUE
  • DOLLAR
  • FIXED
  • CONCATENATE
  • & Character
  • UPPER
  • LOWER
  • PROPER
  • TRIM
  • LEN
  • LEFT
  • RIGHT
  • MID
  • FIND
  • REPLACE
  • SEARCH
  • Date Functions
  • DATE
  • TIME
  • TODAY
  • NOW
  • YEAR
  • MONTH
  • DAY
  • HOUR
  • MINUTE
  • SECOND
  • WEEKDAY
  • WEEKNUM
  • DATEVALUE
  • NETWORKDAYS
  • YEARFRAC
 
 
  • Logical Functions
  • IF
  • IF(IF)
  • AND
  • OR
  • NOT
  • Lookup Functions
  • LOOKUP
  • VLOOKUP
  • HLOOKUP
  • TRANSPOSE
  • OFFSET
  • SUM(OFFSET)
  • MATCH
  • COLUMN
  • ROW
  • Statistical Functions
  • SUMIF
  • SUMIFS
  • COUNTIF
  • SUMPRODUCT
  • COUNT
  • COUNTA
  • COUNTBLANK
  • AVERAGE
  • MIN
  • MAX
  • MEDIAN
  • MODE
 
 
  • Database Functions
  • DSUM
  • DCOUNT
  • DCOUNTA
  • DAVERAGE
  • DMAX
  • DMIN
  • DGET
  • Financial Functions
  • PMT
  • PV
  • RATE
  • NPER
  • PPMT
  • IPMT
  • CUMPRINC
  • CUMIPMT
  • FV
  • NPV
  • IRR
  • Information Functions
  • ERROR.TYPE
  • ISBLANK
  • ISERR
  • ISERROR
  • ISNA
  • ISLOGICAL
  • ISNUMBER
  • ISTEXT
  • ISNONTEXT
  • TYPE
 
         
You have 0 templates in your cart