Excel Formular & Function : Excel Formular & Function O&I Section Feb 08
Logon : Logon Window Logon
User Name: user31
Password: rayong02
Data and work book
C:\Excel
Scope : Scope Functions
Formulas
Ranges
What and Why Excel Formula : What and Why Excel Formula Formula is the defined calculation or operation on the worksheet.
Formula compose of = Constant , Reference, Operant and Function
Formulas are use for
To Processing raw data to information.
Analytical and what if (Decision support)
Create report
Functions : Functions Function is the programming module that return value , some functions need parameter
Logical and information
Text Function
Lookup Table
Date and time
Mathematic
Statistic
Logical Function : Logical Function IF
And
Or
Not
Ture()
Information Functions : Information Functions ISBLANK()
ISERR() (Except #NA), ISNA(),ISERROR(),
ISLOGICAL()
ISNONTEXT(), ISTEXT()
ISNUMBER()
Type() (1 = Number, 2 = text, 4 = Logical, 8 = formula, 16 = Error)
Text Function : Text Function TRIM
CLEAN
LEN
REPT
LEFT
RIGHT
MID UPPER
FIND/SEARCH
REPLACE
SUBSTITUTE
Lookup Table : Lookup Table CHOOSE
Vlookup
HLookup
Date & Time : Date & Time DATE
TODAY
DATEVALUE
YEAR
MONTH
DAY
WEEKDAY HOUR
MINUTE
SECOND
TIME
TIMEVALUE
NOW
MATH Function : MATH Function Round,
RoundDown,
RoundUp
INT,
TRUNC
SUM
MOD
RAND
Statistical Function : Statistical Function AVERAGE
MEDIAN
MODE
MAX
MIN
COUNT
STDDEV
Formulas : Formulas Arithmetic
Comparison
Text
Reference
Multiple sheet formulas
Convert Formula to Value
Display worksheet formulas
Conditional format
Range : Range Select Range with key board
3D Range
Select a range using Go to
Data entry in range
Fill Range
Sample
Q&A : Q&A .
Slide 16 : Business Unit Thank You for Your Attention
Slide 17 :