I’m happy to announce the publication of my new eBook, “How to Combine Data from Different Sources Using Excel.”
This tutorial covers one of my favorite functions in Excel, VLOOKUP. I have found over the years that a strong understanding of this command enabled me to work with data much more effectively. Now, when doing analysis, I’m not limited to just information from a single source because I use Excel to pull in and integrate data from other sources. I love this because I can look at more factors and answer more questions.
I felt there would be some value in putting out a tutorial that focused on the business process rather than just the software commands. Many of the tutorials currently available for Excel are fairly technical in the way they approach the material. This can make it hard to understand how or especially why you might use a particular command.
Instead of digging right into the technical details, “How to Combine Data from Different Sources Using Excel” presents one straightforward example from start to finish. Of course, it fully covers all the parameters of the commands referenced along the way, but this approach puts the technical information in context, making it is easier to understand.
There are also a number of sections devoted to trouble-shooting, which will enable most readers to get up and running quickly.