Excel formulas, in simplest definition, set of instructions that you give to Excel and may contain one or multiple Excel functions with a certain data. Learning formulas is basically about learning how to give Excel instructions to get certain thing done.

As we all admit the critical significance of Excel in almost every niche of life professional or not, it is essential to learn Excel formulas as well. Without proper knowledge you cannot take better advantage of this spreadsheet software that is very capable. Once you learn the basics then only limit is how far your creative mind can go with Excel and Excel formulas and functions. It is almost limitless.

Clicking each category will expand it where you can access each function and formula leading its page with examples and explanation.

[vc_tta_accordion color=”vista-blue” gap=”5″ active_section=”” no_fill=”true” collapsible_all=”true” el_class=”formula-acc”][vc_tta_section i_icon_fontawesome=”fa fa-calculator” title=”Excel Financial Functions” tab_id=”1453408293819-09b47deb-5fa5″ add_icon=”true”]

ACCRINT
ACCRINTM
DB
DDB
Fv Formula
Ipmt Formula
Npv Formula
Pmt Formula
Ppmt Formula
SLN
SYD
VDB

[/vc_tta_section][vc_tta_section i_icon_fontawesome=”fa fa-question” title=”Excel Logical Functions” tab_id=”1453408293971-979215cc-4f5b” add_icon=”true”]

AND
FALSE
IF
IFERROR
IFNA
NOT
OR
TRUE

[/vc_tta_section][vc_tta_section i_icon_fontawesome=”fa fa-font” title=”Excel Text Functions” tab_id=”1453409121156-a0c8d26c-1ea3″ add_icon=”true”]

CONCATENATE
FIND
FIXED
LEFT
LEN
LOWER
MID
PROPER
REPLACE
REPT
RIGHT
SEARCH
SUBSTITUTE
T
TEXT
TRIM
UPPER
VALUE

[/vc_tta_section][vc_tta_section i_icon_fontawesome=”fa fa-calendar” title=”Excel Date and Time Functions” tab_id=”1453409123005-9abea1e6-9f66″ add_icon=”true”]

Day
Hour
Minute
Month
Networkdays
Now
Second
Today
Weekday
Year

[/vc_tta_section][vc_tta_section i_icon_fontawesome=”fa fa-search” title=”Excel LOOKUP and Reference Functions” tab_id=”1453409849818-67bc3760-27ca” add_icon=”true”]

ADDRESS
CHOOSE
COLUMN
FORMULATEXT
GETPIVOTDATA
HLOOKUP
INDEX
INDIRECT
LOOKUP
MATCH
OFFSET
ROW
TRANSPOSE
VLOOKUP

[/vc_tta_section][vc_tta_section i_type=”typicons” i_icon_typicons=”typcn typcn-divide” title=”Excel Math and Trigonometry Functions” tab_id=”1453410021049-36c6d369-9c2f” add_icon=”true”]

Average Formula
Int Formula
Mod Formula
Rand Formula
Round Formula
Sum Formula

[/vc_tta_section][vc_tta_section i_icon_fontawesome=”fa fa-info” title=”Excel Information and Statistical Functions” tab_id=”1453412075423-84bdf369-71a2″ add_icon=”true”]

CELL
COUNT
COUNTA
COUNTBLANK
FREQUENCY
ISBLANK
ISERR
ISERROR
ISNA
ISTEXT
LARGE
MAX
MIN
N
NA
SMALL

[/vc_tta_section][/vc_tta_accordion]
[vc_tta_accordion active_section=”0″ collapsible_all=”true”][vc_tta_section title=”Explore Excel Formulas in Alphabetical Order” tab_id=”1455619585906-c05c6342-8410″]

ACCRINT
ACCRINTM
ADDRESS
AND
Average
CELL
CHOOSE
COLUMN
CONCATENATE
COUNT
COUNTA
COUNTBLANK
Day
DB
DDB
FALSE
FIND
FIXED
FORMULATEXT
FREQUENCY
Fv
GETPIVOTDATA
HLOOKUP
Hour
IF
IFERROR
IFNA
INDEX
INDIRECT
Int
Ipmt
ISBLANK
ISERR
ISERROR
ISNA
ISTEXT
LARGE
LEFT
LEN
LOOKUP
LOWER
MATCH
MAX
MID
MIN
Minute
Mod
Month
N
NA
Networkdays
NOT
Now
Npv
OFFSET
OR
Pmt
Ppmt
PROPER
Rand
REPLACE
REPT
RIGHT
Round
ROW
SEARCH
Second
SLN
SMALL
SUBSTITUTE
Sum
SYD
T
TEXT
Today
TRANSPOSE
TRIM
TRUE
UPPER
VALUE
VDB
VLOOKUP
Weekday
Year

[/vc_tta_section][/vc_tta_accordion]