Remove Duplicates in Excel 2003
In Excel 2003, if there are duplicate items in a list, you can delete them by using an Advanced Filter.
To remove the duplicates, follow the steps in this short Excel video tutorial.
______________
In Excel 2003, if there are duplicate items in a list, you can delete them by using an Advanced Filter.
To remove the duplicates, follow the steps in this short Excel video tutorial.
______________
When you link to data in a pivot table, you may see a GETPIVOTDATA formula, instead of a simple cell reference. To turn this feature off, follow the instructions in this short video. For written instructions, please see Turn Off GetPivotData Formulas for Excel Pivot Tables. ________________
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.”
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 ______________
If you copy data from another program to Excel, Excel might treat the numbers as text, and totals that use these numbers will be incorrect. This video shows the simple steps to change the text "numbers" to real numbers. For written instructions, visit Convert Text to Numbers ______________________
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…
You can quickly change values in Excel, without using formulas. Follow the steps in this short video to add, subtract, multiply or divide, by a specific amount or percentage. For detailed instructions, please visit Excel data entry tips. ______________