How to get a yearly balance in Excel Our simple data set has transactions for only one year, 2020, but that doesn’t matter. We can expect only one balance for the data set.

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you plenty of options.

In Microsoft Excel, learn how to report time values by the hour using the underlying date serial value.

Bookkeepers, project managers, HR departments and more use the Excel Date & Time functions WEEKNUM, ISOWEEKNUM, WORKDAY, WORKDAY.INTL to calculate time. Here's how.