Home

Welcome to my website! This site is all about Microsoft Excel and its awesomeness and making you “Excel”  in Excel.

Blog

VLOOKUP Function

Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID. In its simplest form, the VLOOKUP function says:   =VLOOKUP(What you want to look up, …

Delete a Pivot table

When you no longer need a PivotTable, select the entire PivotTable, and press the Delete key to remove it. If you get a “Cannot change this part of a PivotTable report” message, make sure the entire PivotTable is selected. Press Ctrl+A, and press Delete again.   If you’re using a device that doesn’t have a …