Faysal Easy Excel

Please SUBSCRIBE our YouTube Channel for more videos

Please SUBSCRIBE our YouTube Channel for more videos

Please SUBSCRIBE our YouTube Channel for more videos

To create a Battery Chart in Excel means just like you see the charging percentage on your Phone. You can easily identify when you should plug for recharge your phone. Similarly in Sales, we can apply a Battery Chart so that, Team Leader can drive for Sales in time. In this tutorial I will tell you how you can create a Battery Chart in Excel.  Image 1: Interactive Battery Chart in Excel Although I've already written an article in my blog about "Battery Chart", but this is going to be different. I will say this is an Interactive Battery Chart and it will be easy. So, lets start. Here is the Step by Step Tutorial: Step 1: Your first step is making a data table like below image: Image 2: Data table in Excel of Interactive Battery Chart Step 2 : Select F3:I6 data range and Insert a 3D Stacked Column Chart. Image 3 : 3D Stacked Column Chart Step 3 : Click on "Switch Row to Column" button from Design Tab. Step 4 : N...

Yesterday was 14 February, 2020. Valentine's Day. I was thinking about to share an interesting think on this special day. Finally I decided to make the very popular Love Calculator in Microsoft Excel. Sounds interesting. Yea. The process to make Love Calculator in Excel has described below: Image 1: Valentine's Day Love Calculator in Excel This is very easy to create it. But you need to concentrate on it. Here I've used very popular INDEX-MATCH Function and no VBA. So, let's going start. Step 1: Take a new workbook. and plot like below except Yellow background. Yellow background cells are containing formulas. I will describe the formula in next. Image 2: Valentine's Day Love Calculator Fun Game Calculation Step 2: The D2 cell contains a name, here i used "Microsoft". It needs to convert into Numbers through A1:B6 data table. You can change as you like in A1:B6 data table. So, I have used below formula to convert the "Microsoft...

About Infographic Modern CV: When you create an infographic CV or Resume for Job interview, it means you create a document that uses the elements of words, graphics, and storytelling to communicate your skills, educational background, and experiences to the person who will be hiring you. The infographic resume is gaining the most popularity in fields that require creativity and visual thinking such as design, but expectations are also high for this. The concept has not gained much of a following in other fields, however. Figure 1: Rating Bar Chart for Professional Modern resume in Microsoft Excel Today's business world, in many Job sites offer you to download your free infographic CV or Resume from your account. This means, the popularity of this kind of CV or Resume is acceptable for many companies in Bangladesh and as well as other countries. In my office also, I've seen many modern CV using Bar Chart, Circle Chart or Pie Chart, Area Chart, Bubble Char...

No need to know thousands of Keyboard Shortcut Key to use Excel. Remember the scope of learning Microsoft Excel is unlimited. It's like a deep ocean where Excel Formulas, Functions, Charts, VBA, Power BI, Pivot Table, Power Query, Power Pivot, Power View, Features, Add-ons are available. You need to know those important things in Microsoft Excel depends on your needs to full fill your demands. I'm trying to share some important Keyboard Shortcut commands that will be useful for you while you are working in Excel. CTRL + C : Copy cell value CTRL + B : Bold text CTRL + D : Copy upper cell CTRL + R : Copy left cell CTRL + P : Print setup CTRL + N : Take a new workbook CTRL + S : Save current workbook CTRL + A : Select All of current worksheet CTRL + Z : Undo CTRL + Y : Redo CTRL + O : File open dialogbox CTRL + W : Close current workbook CTRL + F : Find CTRL + G : Go to CTRL + HOME : Go to A1 cell of current worksheet CTRL + END : Go to last used cell of a wor...