How to create a live link from an Excel workbook to a Word document.
This video is to accompany the article in the July 2023 issue of Strategic Finance Magazine: https://www.sfmagazine.com/articles/2023/july/excel-embedding-a-range-in-a-word-document
This is how I get fueled up over the weekend for a week of work making Excel videos: Racing the Washington State Qualifier Race and then riding the Skatepark in Port Angeles. excelisfun, but BMXisfun too!!!!
Microsoft Excel Tutorial: Adding Filterable Text to a Picture in Cell
The new Picture in Cell feature would not work with the Filter drop-downs. A new feature allows you to add text to each picture using the Alt Text panel. This Alt Text will appear in the Filter drop-downs, in XLOOKUP results, in the Pivot Table Filter, and in Pivot Table Slicers.
To download this workbook: https://www.mrexcel.com/youtube/xZxKhm9_Xkk/
Table of Contents
(0:00) Problem Statement: Filtering by Picture
(0:53) Use Alt Text to add Text to Picture in cell
(1:17) Alt Text appears in Filter drop-down
(1:44) Getting Picture from XLOOKUP
(2:15) Use Image in Continue reading “Excel Improvements To Picture In Cell – 2608”
Download Excel File: https://excelisfun.net/files/EMT1825.xlsx
Learn about how Power Query Dates are different from Excel Worksheet Dates. Learn that dates in Power Query range from 1/1/0001 to 12/31/9999. Learn how to add and subtract dates in Power Query, Excel too.
Topics:
1. (00:00) Introduction
2. (00:16) Excel & Lotus 1-2-3 Dates have two problems. Power Query solved these problems.
3. (00:53) Date Serial Numbers are Different in Power Query.
4. (01:47) Date Data Type
5. (02:08) Extract Year from Date
6. (02:20) Subtract Two Dates using Duration.Days function.
7. (02:57) Add Days to a Date using Date.AddDays function
8. (03:36) Adding and Subtracting Dates in the Excel Worksheet
9. Continue reading “Power Query Dates Are Better Than Excel Worksheet Dates! Excel Magic Trick 1825”
Download Excel File: https://excelisfun.net/files/EMT1824.xlsx
Learn how to take a random sample from a population based on a uniform distribution. See 4 Methods. 2 that work in any version of Excel and 2 that work in M 365 Excel.
Topics:
1. (00:00) Introduction
2. (00:14) RAND and RANDARRAY functions create random numbers based on a uniform distribution.
3. (00:31) M 365 Excel Formula #1: TAKE, SORTBY, RANDARRAY Functions.
4. (02:26) Formula for any version of Excel #1: SMALL, RAND, MATCH, INDEX, ROWS, IF and ROWS functions.
5. (05:30) M 365 Excel Formula #1: XMATCH, SMALL, RAND, INDEX, IF and ROWS Functions. Also see an array Continue reading “Excel Formula to Take a Random Sample: 4 Methods. Excel Magic Trick 1824”
Download Excel File: https://excelisfun.net/files/EMT1823.xlsx
Learn about how to create a formula to randomly lookup items without repeat. Lookup pictures or any item. See the functions LET, ROWS, RANDARRAY, SORT, INDEX, XMATCH.
Topics:
1. (00:00) Introduction
2. (00:12) Formula to do random lookup with no repeats. See the functions LET, ROWS, RANDARRAY, SORT, INDEX, XMATCH.
3. (02:36) Closing, Video Links
#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #freeclass #freecourse #freeclasses #excelclasses #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp #sortfunction #indexfunction #matchfunction #XMATCH