Cell References in Excel Formulas When you create a formula in an Excel cell, you'll frequently include a reference to another cell in the spreadsheet.

How to Use Variables in Excel. Knowing how to use Excel's variables gives you the ability to make your formulas – and by extension the spreadsheets containing those formulas – much easier to ...

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

How do you define name and use in Excel formula? In order to define and use name in Excel, you need to choose a cell first. Then, click on the Name box and type a name as per your requirements.

Macros in Excel can perform functions like inserting pictures, copying data from one cell to another, etc. In order to write an effective macro to insert images in excel, you will need to use a loop.

When you think of double quotation marks, you probably remember your English lessons in school. However, in Microsoft Excel, ...

SERIESSUM function returns the sum of a power series based on the formula. Learn how to use the SERIESSUM function in Excel.

To use the Function Arguments wizard to build a VLOOKUP formula in Microsoft Excel, use these steps: Open Excel.

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

Learn about the weighted average cost of capital (WACC) formula in Excel and use it to estimate the average cost of raising funds through debt and equity.