Microsoft Excel has a function "SUMIFS". Which allows us to sum a specific range based on some specific conditions. But you may have different criteria to SUM a range.  For example: if you want to SUM only the BD based name shown in the list below, what will you do? Image 1: Name list with country code As you can see, I have to check all cells and find if the string “BD” appears in the cell or not, and if it does, I need to include the value in the adjacent cell in column B while doing the sum. The above example is a case of a partial match, where I need to sum cells based on the par ..read more

    Infographic Column Chart in Excel 2021 | Cylinder Chart in Exce Please SUBSCRIBE our YouTube channel for more videos ..read more

    Learn how to create an engaging and informative Infographic Sales Performance Bar Chart in Excel 2021 with this step-by-step tutorial. In this video, we'll guide you through the process of creating a professional-looking bar chart that highlights your sales performance data, complete with customizable elements like color-coding and labels. Plus, we're also sharing a link to download the Microsoft Excel workbook for free, so you can use the chart for your own business or personal use. Follow along and take your data visualization skills to the next level ..read more

  New Excel Chart Tutorial just published on YouTube channel. Download your free copy. Please SUBSCRIBE and download more than 100 infographic Microsoft Excel Charts absolutely FREE. #faysaleasyexcel #exceltips #exceltricks #exceltutorial #msexcel #excelcharts #charts https://docs.google.com/spreadsheets/d/1xtlT43N9_CSbPw1_Exb5OqD9i1rW5wgG/edit?usp=sharing&ouid=110777291355617494364&rtpof=true&sd=true ..read more

..read more

..read more

..read more

..read more

..read more

 In this video you will learn how to highlight or plot the high or low point in a single column chart. I've used 2D Stacked Column Chart in Excel 2016 in this technique. Hope you will enjoy it.   ..read more