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

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

You’re working with Excel since long, but would like some fresh inspiration? You had an Excel training 15 years ago and wonder what all these new buttons coul