In honor of the Worksheets launch and spreadsheet fans everywhere, we asked finance practitioners at Workday and our customers and partners what their favorite spreadsheet function is and why.

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

Let’s all come together and face it: spreadsheets can be scary. Sure, adding borders and painting cells different colors is easy, and maybe you even know how to use basic functions like SUM and AVG.

TEXTBEFORE and TEXTAFTER are a few more of my favorite Excel functions to clean messy spreadsheets. Excel's newer text ...

Microsoft Excel gives users the flexibility to configure data and perform very basic operations, such as addition, subtraction, multiplication, or division by using shortcuts or custom formulas. This ...

5 basic spreadsheet skills any journalist can apply Data journalist need not be daunting. Learn how to clean and format datasets with these spreadsheet skills for beginners ...

For novices, functions are one of the most intimidating features of OpenOffice.org's Calc. Newcomers quickly learn that functions are a main feature of spreadsheets, but there are almost four hundred, ...

In addition to its basic spreadsheet functions, Microsoft Excel also allows writing formulas to perform functions on existing data.

A basic spreadsheet has one table on it but allows you to add more to customize your organization. As with other spreadsheets, typing an equals symbol invokes the formula editor.

Microsoft adds a new Copilot function to Excel, letting users generate, analyze, and summarize data directly in spreadsheet ...