SOLUTION: Start using the IFERROR function Continue reading Excel – Hiding errors using the IFERROR function
I recently ran an Advanced Excel course where I was asked “what is the quickest way to pull data from multiple worksheets into a summary worksheet?” Excel offers several solutions for consolidating and summarizing data from different worksheets and workbooks. Continue reading Excel – How to summarize data from multiple worksheets (Part 1 of 2)
Turning formulas into values is a very common procedure to most users of Excel. Paste Values allows you to replace a formula with the result. For example, a cell containing the formula “=3*2” can copied and using Paste Values the formula result, i.e. “6” will be pasted into the cell, replacing the formula.
Here’s a fabulous (and very popular) tip to save you time when you paste values in Excel. Continue reading Excel – Paste Values shortcut in Excel
Anyone that regularly imports data into Excel will be familiar with the process of “data cleaning”. This is where you need to remove spaces and irrelevant data in order to get the data fit for use in Excel.
I recently had an excellent question regarding working with data imported into Excel where negative numbers are imported with the negative sign to the right of the number, e.g. 500-. These numbers are commonly referred to as “mirrored negatives”. Continue reading Excel – How do I move the negative sign in front of the number?