Blog Topic: Excel

Excel is an invaluable tool for analyzing and displaying data. In Part 1 I covered some essentials Excel skills, such as conditionals, absolute references and the fill handle. In this second part I’ll cover a few more advanced functionalities that mimic database manipulations. You can also find these examples in the downloadable spreadsheet. 1. VLOOKUP

Excel is a powerful program. It’s like an onion, peeling back layers to reveal increasingly specialized functions. The minute you think you’ve mastered it, you discover a new set of functions. It can take years to learn it and unfortunately there’s not usually a class on learning Excel in university. Students have to pick things