Some tricks with the new Stocks data type in Microsoft Excel. How to refresh the current stock price in Excel. How to change the Stock Market Exchange for one security.
Tag: Productivity
Refreshing Stock Data In Excel 2265
Some tricks with the new Stocks data type in Microsoft Excel. How to refresh the current stock price in Excel. How to change the Stock Market Exchange for one security.
Excel Data Types Geography 2264
A second look at the new Geography Data Types in Excel.
Excel Slicer Selections In Title 2263
When you filter a pivot table to many items, the title of (Multiple Items) is nearly useless. Which items? Printing the whole slicer can take up a lot of space. Today, I combine a Mike Alexander trick with TEXTJOIN to create a title that shows which items are selected in the slicer.
Excel Ctrl Click to Unselect Cells – 2262
You are selecting multiple ranges in Excel using Ctrl. Then, you accidentally click some cells that should not be in the selection. Previously, you would have to start over. Now, you can Ctrl+Click to Unselect if you are using Office 365.
Pivot Table Filter Between Two Dollar Amounts – Episode 2261
Myrna from El Paso Texas wonders how to create an Excel pivot table that only shows customers between $10K and $100K.
Excel Artificial Intelligence With Ideas
Find interesting trends in your Excel data using the new artificial intelligence feature called Ideas.
Excel Pivot Table Fill In Empty Cells 2259
Three Excel tricks today: Fill in the empty cells when you have multiple row fields in a pivot table. Fill in the empty cells because there were not any sales. And Change the Pivot Table Defaults for all future pivot tables.
Excel Document Location – Episode 2258
An awesome trick from Candace & Robert in Topeka of how to copy the path to your workbook using Document Location on the Quick Access Toolbar in Excel.
Excel Fill Text On Subtotal Rows – Episode 2257
Revisiting a topic from Episode 1995 – how do you bring the customer name field down into the subtotal rows? Kimberly from Oklahoma City and Sarah from Omaha collaborate for a faster way.
Excel Fill Monday Weds Fri Dates – 2256
There is a well-known trick in Excel to fill just weekdays. But what if your work week is not Monday through Friday? Today, a trick with WORKDAY.INTL in Excel to fill Monday, Wednesday, Friday.
Excel Filter to Over $20K – Podcast 2255
An awesome tip from Kris and Taylor in New Mexico – how to use the AutoFilter to filter to all rows above $20K in Excel.