Faysal Easy Excel

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...

Waffle Chart is a good way to represent your single cell value. It is an alternative of Doughnut Chart. This chart cant be decorated beautifully by using Autoshape in Excel. In this tutorial I'll help you how to create a Hanging Frame Waffle Chart in Excel with Autoshape. Step by step process : First of all take a new spreadsheet and plot like below image:     Figure 1: Primary Plotting Main chart will display in F10:O19 cell range. Select this range and use Fill color and Text color as light gray. After that, take border inside color as White. Outside Border color as dark gray. In F19 cell type 1%. In G19 cell use =F19+1%. Copy G19 cell with formula and paste H19:O19 cell so that, O19 cell shows 10%. Now in F18 cell use =O19+1%. In G18 cell use =F18+1%. Copy the G18 cell and paste right to H18:O19. Then Copy the cell range F18:O18. Select F10:O17. Paste it. Now in F7 cell type "ACHIEVEMENT" and Select font color as Light Orange. In F8 ...

|||| Please SUBSCRIBE our YouTube Channel for more videos |||| https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw

Problem: When you double click an icon or excel file name for a Microsoft Excel workbook, then displays a blank screen where you expect the file content to appear like below image: Figure 1: Opened just Excel program not the file I expected Solution: To resolve this problem, try the following ways, as appropriate, in the given order. Way 1: Ignore Dynamic Data Exchange (DDE) Option from Excel: Step 1: In the upper-left corner of the Excel window, select File , then Options . Step 2: On the left side of the Options window, select Advanced to open the Advanced window. Step 3: In the Advanced window, scroll down to the General section. Step 4: Clear the "Ignore other applications that use Dynamic Data Exchange (DDE)" check box, then select the OK button at the bottom of the window. Figure 2: Ignore other applications that use Dynamic Data Exchange (DDE) Way 2: Repair User Experience Virtualization (UE-V) : St...

Are you looking for a tutorial that will help you to create a Sales Forecasting Chart in Excel? Simple, Just watch this video and create it by yourself: |||| Please SUBSCRIBE our YouTube Channel for more videos |||| https://www.youtube.com/channel/UCIWaA5KCwZzBGwtmGIOFjQw