Microsoft Excel formulas and features that you need to know

Microsoft Excel is ubiquitous, but it's far more than a simple spreadsheet app — a huge array of powerful features lay within its cells.

There are thousands of Excel tools at your disposal, so where should you start? Let's take a look at some of the basic formulas and advanced features of Microsoft Excel.

• SUM, COUNT and AVERAGE
• Adding IF
• Proper, UPPER and lower
• Search with VLOOKUP
• CONCATENATE
• Creating 3D Maps
• Freezing panes in Excel
• Using Pivot Tables
• Generating a Waterfall Chart
• Conditional Formatting

Basic Excel formulas

Before you attempt to hit the ground running, it's advisable to have a look at some of the basics to get you started.

The order and layout of a function and its arguments are known as the syntax. With Microsoft Excel, functions are built-in formulas which initiate the requested action on the information found in your worksheet. Formulas in Excel start with an equal sign (=), then continues with either a function name (SUM, COUNT, IF) or math operators and numbers. If we were to dissect this formula:

=COUNTIF(A1:E1, "Forecast")

We can break a formula down into the following parts:

from Windows Central - News, Forums, Reviews, Help for Windows Phone http://ift.tt/2qE1KBn
via IFTTT