When you open a file in Excel, you might see an "Enable or Disable a Macro” message, but you know that there are no macros in the file.
Follow the steps in this video, to prevent this message from appearing.
For written instructions see: Remove Excel macro warning
______________
In an Excel pivot table, you can use built-in custom calculations, for a different view of the data. For example, in this video I set up the pivot table to show what % of monthly sales were Binders, and what % for each colour – red, blue, and black. You can get the sample file…
Bill Jelen is the the king of all Excel media! In addition to his MrExcel website, and his book publishing empire, and his Excel podcasts, Bill has been on YouTube since July 23, 2006 – almost 15 years ago! Let’s take a look at it.
If you get pivot table refresh errors, this video shows how to troubleshoot those errors and try to fix them. For example, one common error is, “The PivotTable field name is not valid”. Or, you might see this error: “PivotTable report cannot overlap another PivotTable report.”
Use the Excel IF function when you want to test something. The IF formula will show one result if the test result is True, and a different result if the test result is False. For example: Check if cell D7 is empty. If it is, the result is an empty string. If not, multiply C7…
An Excel worksheet might have headings in column A, and subheadings in column B, with blank cells under each heading. If you want to sort or filter that data, you’ll need to fill in the blank cells. This short video shows you a quick way to clean up the data. For written instructions please read…
In Excel 2003, or earlier versions, you can move the color and border palettes close to the cells you’re formatting. To see the steps, watch this short Excel video tutorial. For written instructions, see the move the color and border palettes in Excel notes on the Contextures website. ______