Capture2

How to Fix “Microsoft Excel is waiting for another application to complete an OLE action”

1st troubleshooting 1. Open the Excel sheet and go the File menu. In the File menu, click on Options. 2. An Excel Options dialog box will appear. Go to the Advanced tab and scroll down to the General area. Over there check Ignore other applications that use Dynamic Data Exchange (DDE). 3. Restart Excel. 2nd troubleshooting, if you are using Google Drive Google Drive […]

Capture2

How to Split a Column with Multiple Values into Rows (Excel)

I have received some sales data from John, my favourite imaginary salesperson.  He’s decided to merge some of his data. I have a list of companies on each line, instead of one row for each company.  I want to have one row per company so that I can link to other company data. I start […]

Capture2

How to Remove Duplicates by Using Power Query for Excel

Open up the Power Query Editor. Go to Home > Remove Rows > Remove Duplicates STEP 4: Click Close & Load from the Home tab and this will open up a brand new worksheet in your Excel workbook with the cleaned table. You now have your new table with the remove duplicates power query! This completes our tutorial on How to Remove Duplicates […]

Capture2

PERCENTILE vs PERCENTILE.INC vs PERCENTILE.EXC

PERCENTILE.EXC and PERCENTILE.INC differs only in the way the possibly-non-integer rank is calculated. For PERCENTILE.INC (and PERCENTILE) the calculated rank is K*(N-1)+1. For PERCENTILE.EXC the calculated rank is K*(N+1). Percentile Percentile is a statistics term used to describe the Nth observation in a data set after sorting in ascending order. For example, 40th percentile (P40) […]

Capture2

Import Data From a Folder with Multiple Files (Excel)

Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Use Power Query to combine multiple files with the same schema stored in a single folder into one table. For example, each month you want to combine budget workbooks from multiple departments, where the columns are the same, but the number of rows and values differ […]

Capture2

How to Build a Power BI Dashboard for Mobile Correctly

4 steps to build Power BI dashboard for Mobile correctly In this article, we will learn how to Optimize a Power BI dashboard for mobile phones.  What is a Power BI dashboard?  How to create a power bi dashboard for mobile phones? What is a Power BI dashboard? A Power BI dashboard is a feature of the […]