Faysal Easy Excel

How to SUM by matching partial text in Excel In this tutorial, I'm going to share another tips on how to sum by matching partial text in Excel . First of all, Microsoft Excel has a function called, "SUMIFS". Also has SUMIF. But I'll work here with "SUMIFS". This function allows us to sum a specific range. Based on some specific conditions. The situation of your condition is different in real life. As a result, I'm writing how to sum by matching partial text in excel tutorial. How to sum by matching partial text example:   if you want to SUM only the BD based name shown in the list below, what will you do?  Image 1:  How to SUM by matching partial text in Excel Well, in this case You can do by following below steps: So, 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...

How to Create a Checklist in Excel Checklists in Excel: First of all I would like to say, Microsoft Excel is a powerful tool. Because, It is not just for numbers, but additionally for organizing your tasks. Due to you have to do many works in corporate office, you may need a tracker. To track your daily official task, you can simply create a Checklists in Excel with our simple and very easy tutorial. Yes you can use it for non-public and professional duties. So, I created a "To Do List" or "Checklist in Excel" to track my all corporate task. Due to many friends of mine unable to watch my YouTube video tutorial, hence I decided to share it with my blog. You can also watch my YouTube video tutorial and download the free excel templates. You can customize this checklist in Excel by way of selecting exceptional codecs, colorings, and layouts as you want. Image 1: ToDo list template tutorial in excel Step-by-Step Tutorial to Creating an easy Checklist in E...

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

    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!

  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

 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.  

  Loading Chart is also known as Progress Chart. In this tutorial I've shared how you can decorate a Loading Chart in Excel 2016.

    In this video we will show you the Step by Step process involved in creating a Doughnut Chart. Please SUBSCRIBE our YouTube channel for more upcoming videos. #faysaleasyexcel #exceltricks #exceltips #exceltraining #excelskills #doughnuts #excelcharts #doughnuts #microsoftexcel   Please SUBSCRIBE our YouTube Channel for more upcoming videos.

    In this video, you will learn how to design a Doughnut Chart quickly in Excel 2016. This is simple but looks attractive. You can try it to impress your Boss or clients.   Please SUBSCRIBE our YouTube channel for many more charts.

    Design your new excel Pie Chart like a Pro for your Business Review Presentation in 2022.

In this tutorial you will learn, how to join, combine or merge cell values from two different cells or more than two different cells into one single cell in Excel 2016. There are many ways to combine or merge two cell values into one cell in Excel. In this tutorial I will explain 3 ways that will let you join data from several columns into one without losing data. These are CONCATENATE Function , Custom Formula and Flash Fill .     A. CONCATENATE Function to Combine Two or More Columns into One: If you have a data table with "First Name" and "Last Name" like below image and you want a new column where "First Name" and "Last Name" will combine row by row with a space into one, then follow the below steps: 1. In C3 cell enter this formula: =CONCATENATE(A3," ",B3) 2. Press Enter. CONCATENATE Function joins the cell values. In this example CONCATENATE Function first joins A3 cell value, then a space between a quotation marks (" ...

Remove duplicate values but keep one value: So, In Microsoft Excel when you start data analysis based on one column, it is very important to keep your data clean and must follow the data table rules. Otherwise your query on data table will show you wrong result. One of the data table rule is, every record or row will be unique based on one column. In Microsoft Excel you can check and remove duplicate values or rows based on one column. This feature in Microsoft Excel is called Remove Duplicate. It is a built-in tool of Microsoft Excel which helps you to clean up your data quickly. It is very easy to use. In this tutorial I'll show you how you can remove duplicates rows in excel and keep first record or row only from each duplicate records or rows based on one column. How to use Remove Duplicate in Excel 2016 Let's start with a simple example here. Below is a data table where few columns contains duplicate values. We can remove these duplicate values but keep the first value bas...

In Excel, you often work with a data table for data analysis. While working on data table, you my need to populate your data table through importing or manually entering them which is called data typing. It is true that, this will take time. But do you know that, there are few features in Excel which allows you to auto fill up your data table?. Yes, there are few features available in Microsoft Excel which allows you to auto fill your data table and save time while working on worksheet. Such as, One Input Data Table , Two Input Data Table , Goal Seek , AutoFill etc.   In this lesson, I'll help you to learn how to use AutoFill in Excel and save your time. It is very simple to use. Just a double click you need to do it. AutoFill is really a powerful tool in Microsoft Excel. It will populate your data table in seconds and save your time while working on worksheet.   AutoFill is a great feature in Microsoft Excel which allows you to fill series of numbers, dates and other data...