Microsoft Office Tutorials and References
In Depth Information
10. Understanding Functions
10. Understanding Functions
Excel is used on 500 million desktops around the world. People in all career
types use Excel, as do many home users who take advantage of Excel s
powerful features to track their finances, investments, and more. Part of Ex-
cel s versatility is its wide range of built-in functions.
Excel 2013 offers 463 built-in calculation functions. This number grows with
each new release. For example, 49 functions are new in Excel 2013. Some of
these functions are invented by Microsoft. Some are added to keep Excel com-
pliant with the Open Document Format standard.
Here are some interesting functions added in recent versions:
Excel 2013 added the WEBSERVICE function to retrieve data from the
Web. When it s combined with the ENCODEURL and FILTERXML func-
tions, you can retrieve more data from the Internet from within your
Excel functions. Read more about these functions in Chapter 12 , Using
Powerful Functions: Logical, Lookup, Web, and Database Functions .
Excel 2013 added the ISFORMULA and FORMULATEXT functions. The
first function enables you to use conditional formatting to highlight
formula cells and replaces an old Excel 4 Macro trick.
FORMULATEXT is great for documenting worksheets and is used ex-
tensively in the creation of this topic to display the formula next to a
cell. Both are covered in Chapter 12 .
BASE and DECIMAL are flexible replacements for converting between
binary, decimal, and hexadecimal. Unlike the BIN2DEC functions, BASE
and DECIMAL can handle any number system, from Base 2 to Base 36.
They are covered in Chapter 15 , Using Trig, Matrix, and Engineering
Functions . In an ironic twist, the Open Document standard added
ARABIC to convert back from roman numerals to decimal. Read about it
in Chapter 11 , Using Everyday Functions: Math, Date and Time, and
Text Functions .
Excel 2013 now handles bit math with BITAND, BITOR, BITXOR,
BITLSHIFT, and BITRSHIFT, as covered in Chapter 15 . The XOR function
for exclusive OR is new and is covered in Chapter 12 .
Trigonometry becomes a bit easier in Excel 2013. Trig fans might recall
that 1/SIN is called a Cosecant. You won t have to divide by 1 any-
Search JabSto ::




Custom Search