Faysal Easy Excel

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