Faysal Easy Excel
186 FOLLOWERS
A source of learning Microsoft Excel. You can learn VLookup, SUMIFS, SUMPRODUCT, INDEX-MATCH, PivotTable, Charts, etc from here.
Faysal Easy Excel
1M ago
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
Faysal Easy Excel
1y ago
Infographic Column Chart in Excel 2021 | Cylinder Chart in Exce
Please SUBSCRIBE our YouTube channel for more videos ..read more
Faysal Easy Excel
1y ago
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
Faysal Easy Excel
1y ago
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
Faysal Easy Excel
1y ago
Faysal Easy Excel
1y ago
Faysal Easy Excel
1y ago
Faysal Easy Excel
2y ago
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