Excel Functions and Text Functions
Understanding Excel's preset functions can help you effectively manage the data in your spreadsheets. These articles discuss function syntax, nesting functions, and how to create your own userdefined functions.
Computer Science

PHP Programming Language

Perl Programming Language

Python Programming

Java Programming

JavaScript Programming

Delphi Programming

C & C++ Programming

Ruby Programming

Visual Basic

Graphic Design

Web Design

Databases

Office Software

Open Source

Spreadsheets

Desktop Publishing

Presentation Software

Animation

Broadband

Assistive Technologies

List
Use Excel's VALUE Function to Convert Text to Numbers

List
How to Extract Text With Excel's LEFT/LEFTB Function

List
How to Extract Text With Excel's MID and MIDB Functions

List
Use the Excel TRUNC Function to Remove Decimals Without Rounding

Article
#NULL!, #REF!, #DIV/0!, and ##### Errors in Excel

List
How to Nest Multiple IF Functions in Excel

List
Remove Unicode/ASCII Character #127 in Excel

List
Excel MROUND Function

List
Use Excel's MAX Function Shortcut to Find the Largest Values

List
Excel COS Function: Find the Cosine of an Angle

List
Excel MONTH Function

Article
An Overview of Serial Number and Serial Date in Excel

List
How to Generate Random Numbers With Excel's RAND Function

List
Finding the Average Value with Excel's AVERAGE Function

List
Excel RANK Function

List
Use the INT Function to Round Down to the Nearest Integer in Excel

List
Rounding Numbers in Excel

List
Round Numbers to the Nearest Even Integer in Excel

List
How to Divide in Excel With the QUOTIENT Function

List
Dos and Dont's of Entering Data in Excel

List
Excel EDATE Function

List
Excel TAN Function: Find the Tangent of an Angle

List
Round Numbers Up to the Nearest 5 or 10 in Excel

List
Excel SIN Function: Find the Sine of an Angle

List
Excel FLOOR Function

List
Find Specific Data with Excel HLOOKUP

List
Convert Angles from Degrees to Radians in Excel

List
Excel TRANSPOSE Function: Flip Rows or Columns of Data

List
The Excel MODE.MULT Function

List
Use Today's Date in Worksheet Calculations in Excel

List
Nesting the AND, OR and IF Functions in Excel

List
Excel MIN Function Shortcut: Find the Smallest Values

List
Excel MATCH Function: Finding the Location of Data

List
Round Numbers Up in Excel

List
Count Cells of Data with Excel's SUMPRODUCT Function

List
Find Data in a List with the INDEX Function

List
How to Calculate Weighted Averages in Excel With SUMPRODUCT

List
How to Find Data with VLOOKUP in Excel

List
Excel Clean Function

List
Using DATEDIF to Count Days, Months, or Years in Excel

List
Excel SUM OFFSET Formula

List
Learn How to Remove Extra Spaces from Excel

List
Counting All Types of Data with COUNTA in Excel

Article
How Integers Are Used in Spreadsheets

List
Excel SUBSTITUTE Function

List
The Excel RIGHT Function

List
Excel Lookup Formula with Multiple Criteria

List
Excel Two Way Lookup Using VLOOKUP Part 1

List
Excel's CHAR and CODE Functions

List
Excel LEN Function: Count Characters in a Cell

List
Excel WorkDay Function: Find Project Start/End Dates

List
Generate Random Numbers With Excel's RANDBETWEEN Function

List
Excel AND and OR Functions

List
Find the Average (Mode) with Excel's MODE.SNGL Function

List
Calculate the Number of Days between Two Dates in Excel

List
How to Round Numbers Down in Excel With the ROUNDDOWN Function

List
Combining the ROUND and SUM Functions in Excel

List
Excel SUMIF: Sum Values that Meet Specified Criteria

List
Excel Median Function: Find the Middle (Average) Value

List
Excel AVERAGEIFS: Find the Average for Specific Criteria

List
Excel OFFSET Function

List
Excel SUMIFS: Sum Only Values Meeting Multiple Criteria

List
Excel Two Way Lookup Using VLOOKUP Part 2

List
Excel YEARFRAC Function

List
Excel AVERAGEIF: Find the Average for Specific Criteria

List
Convert Text to Numbers With Excel Paste Special

List
Excel DCOUNT Function Tutorial

List
How to Use the DGET Function in Excel

List
Count Data that Meets Specific Criteria with Excel's COUNTIFS Function

List
Count Data in Selected Cells with Excel COUNTIF

List
Calculate Your Current Age with the Excel DATEDIF Function

Article
Find the Remainder When Dividing in Excel

Article
Legend and Legend Key in Excel Spreadsheets

Article
Print Gridlines and Headings in Excel

Article
Insertion Point Definition and Use in Excel

List
Excel Online COUNTBLANK Function

Article
Use of Labels in Excel and Google Spreadsheets
Learn more about Computer Science

PHP Programming Language

Perl Programming Language

Python Programming

Java Programming

JavaScript Programming

Delphi Programming

C & C++ Programming

Ruby Programming

Visual Basic

Graphic Design

Web Design

Databases

Office Software

Open Source

Spreadsheets

Desktop Publishing

Presentation Software

Animation

Broadband

Assistive Technologies