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 I create and populate tables? And, once a table is created, how do we custom filter, format, and design those tables so they look professional in a report? We’ll show you how it’s done.

Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the ...

Format Painter applies the same formatting to multiple text or objects. Learn how to use Format Painter in Word, PowerPoint, and Excel.

A row-by-row formatting rule is as easy to apply as a column-by-column in Microsoft Excel, but you might not get the results you thought you would.

If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot.

A practical way of formatting sales reports in Excel involves working in progressively larger units. Use the Home tab's controls to format on the character level.

You can change the date & time format in Google Sheets & Excel Online using this guide. Use different date & time formats in spreadsheets.