Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Emojis, Excel, Power Query & Dynamic Arrays. It's true!. That video is uploaded by Excel On Fire at 2019-06-17T07:54:06-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [c-tnA1zfrzs]
| Name | Emojis, Excel, Power Query & Dynamic Arrays. It's true! |
| Video Uploader | Video From Excel On Fire |
| Upload Date | This Video Uploaded At 17-06-2019 14:54:06 |
| Video Discription | Did you ever think that you could write a formula with a picture of grapes and have the result be a picture of a train? It's possible to add emojis in Excel. But it gets better! This isn't like adding a picture just to make things pretty. No no. The emojis can be used like text or numbers. (Thanks to Frédéric Le Guen for his blogpost that opened these possibilities. See his blogpost here: https://www.excel-exercise.com/add-emojis-to-your-charts-formulas/) This video shows 8 uses for emojis in Excel: - Emojis can be used as values (text or numbers) - Column headers - Slicers - Formulas - Dynamic Arrays. I show both the FILTER and UNIQUE functions. - Dropdown lists - Power Query - Excel Online Thanks to Frédéric Le Guen for his blogpost that opened these possibilities. See his blogpost here: https://www.excel-exercise.com/add-emojis-to-your-charts-formulas/ For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course: https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning Website: http://ozdusoleil.com My book: Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336 My old blog: http://datascopic.net/blog-2-2 c-tnA1zfrzs |
| Category | Education |
| Tags | Emojis in Excel | Emojis in Power Query | Emojis in Excel formulas | Excel Dynamic Arrays | FILTER function in Excel | Oz du Soleil | Excel on Fire | dynamic arrays | new excel calculation engine | excel array formulas | VLOOKUP formula | VLOOKUP | formula with emojis | emoticons in Excel | touch keyboard windows 10 | touch keyboard with Excel |
