From lookup functions to multi-part formulas, I wish I knew about these Excel formulas earlier because they make me feel like a data wizard whenever I use them. Rather than a traditional mathematical ...

Using formulas in Excel is pretty simple. To get started, click on the cell where you want the result to appear, type an equal sign ( = ), then enter your formula (like =A1+B1 ), and press Enter.

Excel allows you to use the PRODUCT() function for all of your money values, regardless of their location. For example, if you have "$532.44" in column A2 and "$21.99" in column B2, type the ...

How to Use Trig Functions in Excel. Excel has built-in functions for sine and cosine, ... Click in cell C2 to use the Sine function. Click the "Math & Trig" button and select "SIN." ...

How to use the LOG10 functions in Excel. Enter your data or use existing data. Type into the cell where you want to place the result =LOG10(A4).; Press Enter to see the result.

Use the Insert Function button under the Formulas tab to select a function from Excel’s menu list: =COUNT(B4:B13) Counts the numbers in a range (ignores blank/empty cells).

In Microsoft Excel, the Math and Trig functions allow users to do many mathematical calculations including basic arithmetic, sums and products, exponent and logarithms, and trigonometric ratios.

In Excel, the Function key F1 and the white question mark at the top right side of the Ribbon menu offer access the online Help menus. You can type a subject, command, feature, ...