How-To Geek on MSN

How to Use the VALUE Function in Microsoft Excel

Excel's VALUE function has only one argument: where a is the value stored as text that you want to convert into a number. This can be hard-coded inside double quotes or a reference to a cell ...
InfoWorld

What is functional programming? A practical guide

Functions are fundamental to code organization; they exist in all higher order programming languages. Generally, functional programming means using functions to the best effect for creating clean and ...
Computerworld

How to use Excel formulas and functions

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions. One of the ...
JournalofAccountancy

Using Excel’s TEXTBEFORE AND TEXTAFTER functions to easily tame messy data

Q. How do the TEXTBEFORE and TEXTAFTER functions in Excel work? A. Excel’s TEXTBEFORE and TEXTAFTER functions allow users to quickly split up text in ways that used to require combinations of ...
Visual Studio Magazine

4 New T-SQL Functions

SQL Server 2012 was released last April, making it the 11th major release of the product. Every new version has delivered new functionality that should excite developers, and this release is no ...
TheServerSide

How to use Java's functional Consumer interface example

Community driven content discussing all aspects of software development from DevOps to design patterns. Quite often a Java Stream or other component needs an object passed to it in order to perform ...