Excel can take large data sets. But getting hold of required data can be tricky. Here, different possibilities are explained: The filter and the VLOOKUP() which

To explain complex context and relations, there is a tool already on each office workplace: PowerPoint. But many users are not aware of what it can really achie

Too often, users need to perform the same tasks again and again. It's not only boring, it takes up the time that could be used differently! In this book, you wi

In today's offices, much time is spent finding and structuring information in given data. Pivot Tables and Charts are the tool of choice to get it done. Their r

Often, Excel is used to evaluate given data. Which values are critical? Can I see at a glance what the development was like? Can I highlight a whole row if one