Excel LET function, Connect to PDF, Power BI datasets and Power BI Data Types

The Excel Semi Annual Channel updates have arrived including LET, Power BI Datatypes and an alternative to Analyze in Excel

Also connect to PDF is available

Official Updates for Semi Annual Channel
https://docs.microsoft.com/en-us/officeupdates/semi-annual-enterprise-channel?WT.mc_id=M365-MVP-5002589
Links to the videos I mention:

Autocorrect Formula Magic: https://youtu.be/3xK_e7HQgSE
Organization Data Types: https://youtu.be/FE3jgq1exRM
Connect to PBI Dataset: https://youtu.be/5U-TIDvb5j8
00:00 Intro
00:26 How to check for updates
01:54 LET function
05:15 Get Data From PDF
07:13 Organization data types
08:58 Power BI Dataset Connection
Note: MyWorkspace can now be connected to by Free Users
https://techcommunity.microsoft.com/t5/excel-blog/excel-and-power-bi-connected-features-coming-soon-for-users-with/ba-p/2700903
Follow me on LinkedIn
https://www.linkedin.com/in/wynhopkins/

Twitter
https://twitter.com/wynhopkins

Access Analytic Training
https://accessanalytic.com.au/training

Видео Excel LET function, Connect to PDF, Power BI datasets and Power BI Data Types канала Access Analytic Learn