%3CLINGO-SUB%20id%3D%22lingo-sub-1681253%22%20slang%3D%22en-US%22%3EExcel%20MVP%20Blog%20Roundup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1681253%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20week%2C%20MVPs%20Mynda%20Treacy%2C%20Tony%20de%20Jonker%2C%20and%20Alan%20Murray%20share%20their%20Excel%20knowledge%20with%20us%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fwww.myonlinetraininghub.com%252Fexcel-pivottable-profit-and-loss%26amp%3Bdata%3D04%257C01%257CCuong.Pham%2540microsoft.com%257C572d31d4e9ce4acff15e08d85b23c2ba%257C72f988bf86f141af91ab2d7cd011db47%257C0%257C0%257C637359556436468392%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C1000%26amp%3Bsdata%3DolVuDnBcVF2IAMIV9L4yZT7ArMACEEExvmul56U3b74%253D%26amp%3Breserved%3D0%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3EExcel%20PivotTable%20Profit%20and%20Loss%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F5000748%3FfullName%3DMynda%2520Treacy%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3EMynda%20Treacy%3C%2FA%3E%26nbsp%3Bshows%20how%20to%20create%20an%20easy-to-read%20interactive%20profit%20and%20loss%20statement%20in%20Excel%20using%20PivotTable%2C%20slicers%2C%20and%20conditional%20formatting%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fcmweb.nl%252F2020%252F07%252Fexcel-interactieve-grafieken%252F%26amp%3Bdata%3D04%257C01%257CCuong.Pham%2540microsoft.com%257C572d31d4e9ce4acff15e08d85b23c2ba%257C72f988bf86f141af91ab2d7cd011db47%257C0%257C0%257C637359556436478385%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C1000%26amp%3Bsdata%3DPIwtopnq5SiolSIiSAdKa3TD6q488NDrTVo8jFL8p3U%253D%26amp%3Breserved%3D0%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3EExcel%3A%20Interactieve%20grafieken%3C%2FA%3E%20(Interactive%20Charts)%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F5001225%3FfullName%3DTony%2520Christopher%2520De%2520Jonker%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3ETony%20de%20Jonker%3C%2FA%3E%20walks%20through%20using%20multiple%20graphs%20from%20the%20same%20dataset%20to%20reveal%20hidden%20insights%20in%20your%20data%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fwww.computergaga.com%252Fblog%252Fexcel-vlookup-trick-no-more-counting-columns%252F%26amp%3Bdata%3D04%257C01%257CCuong.Pham%2540microsoft.com%257C572d31d4e9ce4acff15e08d85b23c2ba%257C72f988bf86f141af91ab2d7cd011db47%257C0%257C0%257C637359556436448397%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C1000%26amp%3Bsdata%3DV38wCGzD6ngBgk5Ui3DlbtLEEkJ%252Bd1MiILIL%252BNoqJL4%253D%26amp%3Breserved%3D0%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3EExcel%20VLOOKUP%20Trick%20-%20No%20More%20Counting%20Columns%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F5003785%3FfullName%3DAlan%2520Murray%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3EAlan%20Murray%3C%2FA%3E%26nbsp%3Bshares%20a%20neat%20VLOOKUP%20trick%20to%20select%20a%20column%20for%20the%20data%20to%20return%20instead%20of%20specifying%20a%20column%20index%20number-%20in%20case%20you're%20not%20already%20using%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fannouncing-xlookup%2Fba-p%2F811376%22%20target%3D%22_blank%22%3EXLOOKUP%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFind%20this%20useful%20and%2For%20have%20an%20Excel%20question%3F%20Click%20the%20Like%20button%20and%2For%20leave%20a%20comment%20below%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1681253%22%20slang%3D%22en-US%22%3E%3CP%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheck%20out%20these%20blog%20articles%20by%20Excel%20MVPs%20Mynda%20Treacy%2C%20Tony%20de%20Jonker%2C%20and%20Alan%20Murray%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1681253%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20MVP%20Blog%20Roundup%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

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