A co-worker sent you a file with subtotals. How do you get rid of them?
Why are there 3 numbered buttons to the left of column A in Excel?
Why are there minus buttons and vertical lines to the left of column Continue reading “Excel Removing Subtotals – 2431”
Accountants love the subtotals feature in Excel. We love to see details but add a little summary information. I have a lot of friends who think Subtotals should be deprecated and that anytime you use subtotals, you should be using Continue reading “Excel Subtotals Are Awesome – 2428”
Candace is using a third-party Bingo app to generate numbers for a bingo game. Some people are complaining that the app is not fair and that it is calling some numbers too frequently. Candace manually keyed the numbers into Excel Continue reading “Easy Frequency Distribution For Bingo Numbers in Excel – 2430”
Broadway Gypsy asks if there is a way to create a “minute by minute changing up/down stock price arrow in Excel”?
In this video, Bill shows how to use Icon Sets and the SIGN function to add up/down arrows next to Continue reading “Minute by Minute Stock Price Arrows In Excel – 2429”
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”