Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of all data in a PivotTable. In fact, the only thing you need to type is the ...

On the Draw tab, there are various drawing tools that you can use, namely: Select tool: Select objects such as ink, shapes, and text area. They are useful when working with objects behind the text. To ...

So, select any cell in your formatted Excel table, and in the Insert Tab on the ribbon, click the top half of the split ...

Adding a search field to your spreadsheet can greatly improve data navigation and usability. In this guide, you’ll learn how to create a dynamic search box that filters data based on your input, using ...

How to display multiple grand total rows in a Microsoft Excel PivotTable Your email has been sent Microsoft Excel PivotTables do a great job of turning data into meaningful information, but they have ...

In Microsoft WExcek, you can make adjustments to your images. You can add artistic effects, make corrections, add color, make images transparent, compress pictures, change pictures, and reset pictures ...

You’ve spent hours working on an Excel workbook on a MacBook, but now it’s gone. Or, when you exit an Excel file, you unintentionally select “Don’t Save”. Is this to say that your entire effort has ...

How to use conditional formatting to highlight rank in Microsoft Excel Your email has been sent Microsoft Excel’s RANK.EQ() function shows the relationship between values by ranking those items by ...

Learn the secrets of Excel structured tables to save time, eliminate errors, and create smarter, more dynamic spreadsheets.