Excel MVP Blog Roundup

This post has been republished via RSS; it originally appeared at: Excel Blog articles.

This week, MVPs Mynda Treacy, Tony de Jonker, and Alan Murray share their Excel knowledge with us

 

Excel PivotTable Profit and Loss
Mynda Treacy shows how to create an easy-to-read interactive profit and loss statement in Excel using PivotTable, slicers, and conditional formatting

 

Excel: Interactieve grafieken (Interactive Charts)
Tony de Jonker walks through using multiple graphs from the same dataset to reveal hidden insights in your data

 

Excel VLOOKUP Trick - No More Counting Columns
Alan Murray shares a neat VLOOKUP trick to select a column for the data to return instead of specifying a column index number- in case you're not already using XLOOKUP

 

Find this useful and/or have an Excel question? Click the Like button and/or leave a comment below

 

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.