Episode 9 Price Volume Mix analysis and waterfall

𝗘𝗽𝗶𝘀𝗼𝗱𝗲 𝟵: 𝗣𝗿𝗶𝗰𝗲-𝗩𝗼𝗹𝘂𝗺𝗲 𝗠𝗶𝘅 𝗣𝗩𝗠 𝗮𝗻𝗮𝗹𝘆𝘀𝗶𝘀 𝗮𝗻𝗱 𝗱𝘆𝗻𝗮𝗺𝗶𝗰 𝘄𝗮𝘁𝗲𝗿𝗳𝗮𝗹𝗹
with 𝗳𝗿𝗲𝗲 𝗲𝘅𝗰𝗲𝗹 𝘄𝗼𝗿𝗸𝘀𝗵𝗲𝗲𝘁
𝐎𝐮𝐫 𝐭𝐨𝐩𝐢𝐜𝐬 𝐭𝐨𝐝𝐚𝐲
PVM Price Volume Mix Analysis (Per products)
Sales Bridge Analysis
PVM Analysis per customers
PVM using data validation list
Complicated SUMPRODUCT function
Waterfall analysis chart
Excel Custom Number Format
Also, discussing important topics with global professional experts
Sales-Mix variance + potential root causes of unfavorable sales-volume variance (by 𝑩𝒓𝒚𝒂𝒏 𝑳𝒂𝒑𝒊𝒅𝒖𝒔)
Cash is King! But how do you improve it? by (𝐀𝐧𝐝𝐞𝐫𝐬 𝐋𝐢𝐮-𝐋𝐢𝐧𝐝𝐛𝐞𝐫𝐠)
Excel Waterfall Chart by (𝐌𝐲𝐧𝐝𝐚 𝐓𝐫𝐞𝐚𝐜𝐲)
Variance analysis 3 crucial questions by (𝐀𝐬𝐢𝐟 𝐌𝐚𝐬𝐚𝐧𝐢)
Here-below the LINKEDIN post related to this video (to receive your free excel worksheet)
www.linkedin.c...)