10 Techniques the Pros Know about Microsoft Excel

In this book, you've seen how to apply different Excel techniques to be able to easily combine data from several sources into one worksheet (VLOOKUP), and how to make sure that the data you bring in is in the right format - either by handling it with functions like TRIM, LOWER, UPPER, etc. or by restricting choices by using drop down lists. If you want to put your formulae in place, ready for use, but you don't yet have the data to plug into them, then ISERROR and IFERROR let you avoid...
More Description

In this book, you've seen how to apply different Excel techniques to be able to easily combine data from several sources into one worksheet (VLOOKUP), and how to make sure that the data you bring in is in the right format - either by handling it with functions like TRIM, LOWER, UPPER, etc. or by restricting choices by using drop down lists. If you want to put your formulae in place, ready for use, but you don't yet have the data to plug into them, then ISERROR and IFERROR let you avoid those arcane Excel error messages and replace them with something much more user friendly. Finally, for formatting ease and readability for both you and anyone else who uses your spreadsheet, you saw how Format Painter, AutoFilters, and Subtotals and Outlines can draw attention to particular information on your spreadsheet or easily mask other data without deleting them. You'll get the most out of this book if you put the techniques into practice for yourself. Pick the ones that are likely to be the most useful for you first of all. and start with simple cases, like the ones used here. Step by step, you can build them up to more complex ones. Check at each step that you're getting the result you should. If at the next step something unexpected happens, you just have to undo the last step and figure out how to fix it, rather than trying to dive into a complicated formula where it's often hard to know where to begin. Happy exceling! and feel free to let us know how you get on!