Exploring the Microsoft/NASA Day of Data Dataset from https://techcommunity.microsoft.com/t5/day-of-data/bd-p/DayofData
Today (November 1, 2020) marks 20 continuous years of having a human on the International Space Station (ISS). For today’s video, I explore the NASA data set to see: Continue reading “Have There Really Been Someone On The ISS For The Last 20 Years – Episode 2377”
To play along, read the trivia questions and download the data set here: https://techcommunity.microsoft.com/t5/day-of-data/space-trivia/m-p/1781544
In case you have problems solving any of the trivia questions, I’ve created a video showing the answers. Jump to the section for any Continue reading “Answers to Day Of Data Space Trivia Questions”
Duel 195 is scheduled for next Friday. For those of you who don’t want to go a week without a Dueling Excel podcast, Bill tries a reaction video to Duel 58 – Excel Sort by Formula – from December 2010.
Download Continue reading “Reaction Video To Duel 58 Sort With A Formula – 2373”
Are you wanting to use streaming data? Patrick looks at Streaming Dataflows! A new way to integrate streaming data into your Power BI reports!
Streaming dataflows (preview)
https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-streaming
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Continue reading “Exploring Streaming Dataflows in Power BI”
Tina C asks if there is a better way to add a page break every 35 rows. Way back in episode 360, I showed a few methods. But today, one line of VBA in the Immediate Window seems much easier. Continue reading “Excel Page Break by Rows with VBA”
Evil Angel on YouTube asks if you can do a VLOOKUP in a Pivot Table Calculated Field. I am fairly sure this won’t work in a regular pivot table based on the pivot table cache. But if you build a Continue reading “Excel VLOOKUP In Pivot Table Calculated Field? – 2456”
Today a question from someone who frequently uses three currency styles in Excel: USD, EGP, and SAR. Excel makes it easy to choose USD, GBP, EUR, CHF but if your currency is not in that drop-down, then you are scrolling Continue reading “Excel Easily Choose Which Currency – 2455”
My courses on Retrieve: https://mrexcel.retrieve.com/store/#/
For a special holiday-week treat, change the color of the gridlines in Excel to red. It could drive your co-workers insane.
Actually, as time goes by, the gridlines are becoming more faint. Changing the Continue reading “Red Gridlines In Excel – 2454”
Today, a quick tip for sorting left to right in Excel.
With the correct headings, it is a faster way to rearrange columns.
Check out all 12 expert tricks at: https://www.youtube.com/watch?v=nOIEeUHyye0
My course on Retrieve: https://mrexcel.retrieve.com/
Check out my Excel Guides on Retrieve: https://mrexcel.retrieve.com/#/
A question from the Las Vegas IMA: How do you do date rollups in Excel when the company is on a fiscal year that does not end on December 31?
This Continue reading “Excel Pivot Table Fiscal Year Date Rollups – 2452”
How to create your own custom data types in Excel using ScriptLab and the Javascript API.
Important Links:
Try out the workbook with my custom data types: https://1drv.ms/x/s!As7G72Sl487JliYRnUs0P4hYYNQj?e=rIL25J
Github for the example using a Custom Function:
<a href="https://gist.github.com/smozgur/a34ad495fb75e19c3e21904875ef0170" Continue reading “Wow! Excel Custom Data Types From JavaScript API – 2451”
The data types gallery with Geography, Stocks, Currency, and Wolfram is mildly interesting. But I think the real goal is to get your own company data in the Data Type. I want it to be a very rich experience, just Continue reading “Excel Custom Data Types From Power BI – 2450”