Download Excel File: https://excelisfun.net/files/EMT1757.xlsx
Learn keyboard shortcuts to bring Excel Tables, Defined Names or Dynamic Spilled Arrays from the worksheet into the Power Query Editor:
(00:00) Intro
(00:03) From Sheet Power Query command to bring Excel Table into Power Query. Continue reading “Power Query From Sheet option Import Tables, Defined Names or Dynamic Arrays. Fast Keyboard EMT 1757”
Download Excel File: https://excelisfun.net/files/EMT1756.xlsx
Learn how to import an Excel file from OneDrive into a PivotTable using Power Query. This trick came from Wyn Hopkins, Excel MVP. See how to create a PivotTable Report with survey data to Continue reading “Power Query to Import Excel File From OneDrive SharePoint into PivotTable, Refresh New Data EMT 1756”
Download Excel File: https://excelisfun.net/files/EMT1755.xlsx
Learn how to import a file or a folder filled with files into Excel using Power Query.
(00:00) Introduction
(00:06) Import file from OneDrive. Use From Web Power Query Connector.
(01:25) Import files from Folder from OneDrive. Continue reading “Import OneDrive File or Folder using Power Query. EMT 1755”
Download Excel File: https://excelisfun.net/files/EMT1754.xlsx
Learn how to create a logical formula to apply conditional formatting like a chess board or checker board.
(00:00) Introduction
(00:30) ROWS & COLUMNS functions.
(02:28) MOD function to get remainder.
(03:09) Conditional Formatting dialog box
(04:24) Summary
Download Excel File: https://excelisfun.net/files/EMT1753.xlsx
Learn how to Insert a Colon using an Excel Formula. Use the REPLACE function and the LEN function. Convert Text Time to Time Value using a math operation.
(00:00) Introduction
(00:07) Use the REPLACE function and Continue reading “Insert a Colon using an Excel Formula. Convert Text Time to Time Value. EMT 1753”
Check out the finals of the Financial Modeling World Cup: https://www.youtube.com/watch?v=TaW8zwnOA7M
I was a host for an Excel Competition that aired live on YouTube. Besides being one of the nerdiest & geekiest things I’ve been involved in, it Continue reading “Excel Changing Formula References By Dragging The Mouse – 2427”
Download Excel File: https://excelisfun.net/files/EMT1752.xlsx
Learn how to filter a data set by rows and column and extract the data of to the side. See the Microsoft 365 Excel solution using the FILTER function. Then see a solution that Continue reading “Filter by rows and columns: Excel Formula for Any Version of Excel! Excel Magic Trick 1752”
Download Excel File: https://excelisfun.net/files/EMT1751.xlsx
Learn how to Lookup Last Price In Column Based On Criteria In Other Columns.
1. (00:00) Intro
2. (00:30) Formula that works in any version, using LOOKUP function
3. (02:57) Microsoft 365 formula, using XLOOKUP
4. (03:56) Summary Continue reading “Lookup Last Price In Column Based On Criteria In Other Columns. LOOKUP or XLOOKUP? EMT 1751”
This weekend, Fantasy Football teams will be doing their draft. If you are using the ESPN website to manage your draft, the Draft Recap Report could use some formatting.
Download our free Excel template from: http://www.mrexcel.com/download-center/2021/08/BetterESPNDraftRecap.xlsx
Watch the video Continue reading “Better ESPN Fantasy Draft Recap In Excel Free Download – 2426”
Long ago, Excel offered a full screen mode. The Ribbon would completely disappear and you could get the maximum number of rows in the grid visible. The feature was removed in Excel 2013. Today, it is back! At least in Continue reading “Excel Full Screen Mode Returns – Episode 2425”
I have a problem in Excel. About a week ago, the vertical scroll bar on an Excel worksheet stopped working. I lost the scrolling ability from top to bottom. So when I try to drag the right scroll bar from Continue reading “Excel Vertical Scroll Bar Stops Working – 2423”
Download Excel File: https://excelisfun.net/files/EMT1750.xlsx
Learn how to compare to lists and extract items in both lists, or exact the items that are not in both lists. Formula #1: Extract items in List 1 that are in List 2. Continue reading “Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750”