Q. I receive Excel spreadsheets regularly that contain dates. I have to manually look up the day of the week that represents these dates. Are there any functions that can help speed this process along ...

When you use Microsoft Excel to store and analyze business data, your workbooks and worksheets often contain date information. Although your original data may need to display full month, day and year ...

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, data summaries created via PIVOTBY automatically update to reflect changes ...

Many financial systems do a fine job of generating standard reports, but accountants often need more. In those cases, accountants can create custom solutions in Excel, but that approach has drawbacks.

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

Whether the calendars available in retail shops are too cutesy for your office or you missed the end-of-the-year calendar sale blitz, you're never too far from a custom calendar of your own. Tap into ...

How to return monthly sales averages for the last n years in Microsoft Excel Your email has been sent Averaging is easy business in Microsoft Excel. Thanks to the AVERAGEIF() and AVEREAGEIFS() ...