#  @karinaadcock Karina Adcock
Karina Adcock posts on YouTube about how to, microsoft, data, how to make the most. They currently have [------] followers and [---] posts still getting attention that total [-----] engagements in the last [--] hours.
### Engagements: [-----] [#](/creator/youtube::UCYAl8iUrm2t7y0aTo_1WsGw/interactions)
- [--] Week [------] -2.30%
- [--] Month [-------] +17%
- [--] Months [---------] -7%
- [--] Year [---------] +2,232%
### Mentions: [--] [#](/creator/youtube::UCYAl8iUrm2t7y0aTo_1WsGw/posts_active)
- [--] Months [--] -5.30%
- [--] Year [--] +481%
### Followers: [------] [#](/creator/youtube::UCYAl8iUrm2t7y0aTo_1WsGw/followers)
- [--] Week [------] +0.17%
- [--] Month [------] +0.68%
- [--] Months [------] +5.90%
- [--] Year [------] +16%
### CreatorRank: [-------] [#](/creator/youtube::UCYAl8iUrm2t7y0aTo_1WsGw/influencer_rank)
### Social Influence
**Social category influence**
[technology brands](/list/technology-brands) [stocks](/list/stocks) [social networks](/list/social-networks) [finance](/list/finance)
**Social topic influence**
[how to](/topic/how-to), [microsoft](/topic/microsoft) #556, [data](/topic/data), [how to make](/topic/how-to-make) #832, [excel](/topic/excel), [bar](/topic/bar), [min](/topic/min), [list](/topic/list), [lambda](/topic/lambda), [symbol](/topic/symbol)
**Top accounts mentioned or mentioned by**
[@namea1](/creator/undefined) [@name](/creator/undefined)
**Top assets mentioned**
[Microsoft Corp. (MSFT)](/topic/microsoft) [Alphabet Inc Class A (GOOGL)](/topic/$googl) [Alpha Technology Group Limited (ATGL)](/topic/alpha)
### Top Social Posts
Top posts by engagements in the last [--] hours
"Linear Interpolation in Excel Fill in Missing Values =IFERROR(FORECAST.LINEAR(A2C2:D2E2:F2)NA()) linear interpolation linear interpolation"
[YouTube Link](https://youtube.com/watch?v=WhPqljMldPQ) 2022-11-16T14:00Z 59.4K followers, 87.5K engagements
"How to make chapters sections and subsections in word In this video I show you how to make chapters sections and subsections using the heading styles in word and format them the way you want. Useful to know for making a thesis/ dissertation in word. After making the headings you can use the navigation pane to move to different places in the document which is useful if you have a very long document. I wouldn't normally number the abstract but this is just an example of how to make the sections not necessarily how they should be numbered or formatted."
[YouTube Link](https://youtube.com/watch?v=Yh7OgpwNgg0) 2018-01-17T17:52Z 59.4K followers, 1.4M engagements
"How to make table captions and a list of tables in word In this video I show you how to make table captions and a list of tables in word. You firstly need to add captions and change the label option to 'Table'. Then you need to go to the references tab and select 'insert table of figures' and make sure 'Table' is selected. The tables will then be automatically renumbered and the list of tables can then be updated is the captions or page numbers change. This is a very useful feature for writing a thesis/ dissertation."
[YouTube Link](https://youtube.com/watch?v=oCyxpMfuNfY) 2018-02-21T16:00Z 59.4K followers, 1.3M engagements
"Copy Chart Formatting in Excel #shorts copy chart format excel format painter for chart apply same format on the chart copy chart format excel format painter for chart apply same format on the chart"
[YouTube Link](https://youtube.com/watch?v=PuFG4O5vSVU) 2023-02-27T14:00Z 59.4K followers, 103.5K engagements
"TRIM function in Excel How to remove extra spaces from text in excel #exceltips #exceltutorials trim function trim formula trim function excel trim formula excel trim function in excel trim formula in excel excel trim formula excel trim function remove extra spaces in excel excel remove extra spaces remove extra spaces from text in excel formula to remove extra spaces in text excel microsoft excel excel functions excel formulas excel tutorial excel short short excel trim excel short trim excel use trim function in excel how to remove extra spaces trim function trim formula trim function excel"
[YouTube Link](https://youtube.com/watch?v=hHtSP5S-u4I) 2023-08-14T13:00Z 59.4K followers, 153.6K engagements
"How to make a table of contents in word In this video I show you how to make an automatic table of contents in word. You firstly need to change the 'normal' text style so the size and font of the table of contents will be the same as the rest of the text. Then you need to go to references and select table of contents. An automatic table of contents is then created using the heading styles and the contents can be reformatted. The table of contents can be updated if the number of pages or the sections change. This is a very useful feature for writing a thesis/ dissertation. Also if you press"
[YouTube Link](https://youtube.com/watch?v=vfAdcbOUc0Q) 2018-01-24T18:07Z 59.4K followers, 3.7M engagements
"Copy folder structure without files in Windows Windows Command Prompt xcopy "source/folder/path" "destination/folder/path" /t /e copy folder structure command prompt windows command prompt cmd windows copy folders without files copy just folder structure folder structure no files copy folders but no files copy folders but not files folder structure but not files copy folder structure with no files xcopy copy folders with command prompt copy just folders using command prompt duplicate folder structure copy folder structure command prompt windows command prompt cmd windows copy folders without"
[YouTube Link](https://youtube.com/watch?v=4gKgOrIUv60) 2023-03-22T14:00Z 59.4K followers, 70.8K engagements
"How to make an academic poster in powerpoint In this video I show you a simple [--] step process for making an academic poster for a conference specifically in PowerPoint. Step [--] - 0:07 SIZE Step [--] - 1:21 CONTENT & LAYOUT Step [--] - 2:47 EXTRA CONTENT Step [--] - 6:10 IMAGES Step [--] - 7:17 FONT Step [--] - 9:18 COLORS Step [--] - 10:44 LINE UP Step [--] - 12:31 PDF ------------------------------------------------------------------------- #powerpointtutorials #powerpointtipsandtricks SUBSCRIBE: https://goo.gl/c46YPs VIDEO INFO: The poster is related to my PhD research."
[YouTube Link](https://youtube.com/watch?v=_WnhoIbfcoM) 2018-11-28T15:00Z 59.4K followers, 2.7M engagements
"Sequential numbers with gaps across columns in excel =IF(Q5=""""MAX(N$5:N$16P$4:P4)+1) excel sequences excel sequences across columns number sequences in excel sequences with gaps sequential numbers in excel excel sequential numbers sequential numbers with gaps sequential numbers multiple columns excel sequences excel sequences across columns number sequences in excel sequences with gaps sequential numbers in excel excel sequential numbers sequential numbers with gaps sequential numbers multiple columns"
[YouTube Link](https://youtube.com/watch?v=i8b5aiHqsTg) 2025-11-05T14:01Z 59.4K followers, [---] engagements
"How to make a word cloud in microsoft word Use a free add-in called Pro Word Cloud to make a word cloud in word. The size of the word shows how often the word appears in the text. The most common words have the largest font size. -------------------------------------------------------------------------------- #msword #microsoftword #mswordtutorials SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] The writing is related to my PhD research --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO"
[YouTube Link](https://youtube.com/watch?v=x2MytGw45YE) 2019-07-10T13:00Z 59.4K followers, 291K engagements
"IMPORTTEXT & IMPORTCSV functions in excel Example 1: one file with dropdown list =IMPORTTEXT(A2&A3-2) Example 2: from a webpage =IMPORTTEXT("https://gml.noaa.gov/aftp/data/trace_gases/co2/flask/surface/txt/co2_mlo_surface-flask_1_ccgg_month.txt" 049132054) Same link further back: https://gml.noaa.gov/aftp/data/trace_gases/co2/flask/surface/txt/ Example 3: multiple files =CHOOSECOLS(VSTACK(IMPORTTEXT(A1)IMPORTTEXT(A21)IMPORTTEXT(A31)IMPORTTEXT(A41)IMPORTTEXT(A51)IMPORTTEXT(A61)IMPORTTEXT(A71)IMPORTTEXT(A81))2347) importtext importext importcsv excel import csv import text import text files"
[YouTube Link](https://youtube.com/watch?v=XofpiQQJLas) 2026-01-20T19:00Z 59.4K followers, [---] engagements
"How to make a CALENDAR formula in excel LAMBDA =LAMBDA(dateVSTACK(HSTACK(TEXT(date"mmmm")YEAR(date)"""""""""") "Mon""Tue""Wed""Thu""Fri""Sat""Sun" LET(firstEOMONTH(date-1)+1 seqSEQUENCE(67first-WEEKDAY(first3)1) IF(MONTH(seq)=MONTH(date)TEXT(seq"d")""))))(B2)"
[YouTube Link](https://youtube.com/watch?v=fZ2AvIvYQng) 2024-05-01T13:00Z 59.2K followers, [----] engagements
"Using IMAGE to make a chart with different sized shapes in excel The Solar System: Planet Sizes =IMAGE("https://upload.wikimedia.org/wikipedia/commons/d/d5/Rond_bleu_ciel.png"3A4/100) https://science.nasa.gov/resource/solar-system-sizes/"
[YouTube Link](https://youtube.com/watch?v=jHKbSCOpp28) 2024-11-27T14:00Z 59.2K followers, [---] engagements
"Use AutoCorrect to save formulas in Excel Add formulas to AutoCorrect spell check in Excel so they can be saved and used in different workbooks =LET(dateA1DATEDIF(dateTODAY()"y")&" years "&DATEDIF(dateTODAY()"ym")&" months "&DATEDIF(dateTODAY()"md")&" days") =LET(dateINDIRECT(ADDRESS(ROW()COLUMN()-1))DATEDIF(dateTODAY()"y")&" years "&DATEDIF(dateTODAY()"ym")&" months "&DATEDIF(dateTODAY()"md")&" days") ="Grade""Mark";"A"70;"B"60;"C"50;"D"40 (Can't have less than or greater than symbols in youtube description)"
[YouTube Link](https://youtube.com/watch?v=xiHpBOZkkw8) 2023-04-19T13:00Z 59.2K followers, [----] engagements
"How to reorder parts of a filename using Windows Powershell Get-ChildItem Rename-Item -NewName ($_.basename.split('_')10 -join '_') + $_.Extension"
[YouTube Link](https://youtube.com/watch?v=-MdOWezuBzM) 2024-09-25T13:00Z 55.8K followers, [---] engagements
"Average with Errors in Excel #shorts =AGGREGATE(16A1:A10)"
[YouTube Link](https://youtube.com/watch?v=-YVxGJ7nojs) 2023-02-13T14:00Z 54.3K followers, [----] engagements
"How to line up tables in excel using python Python is only available in some versions of excel pd.merge(xl("A1:B13" headers=True)xl("D1:E10" headers=True)how='outer').fillna('unknown') pd.concat(xl("A1:E5" headers=True)xl("A7:E10" headers=True)ignore_index=True).fillna('') excel python python in excel line up tables line up columns combine tables together combine tables join tables tables in excel columns in excel excel python python in excel line up tables line up columns combine tables together combine tables join tables tables in excel columns in excel"
[YouTube Link](https://youtube.com/watch?v=-iPb9JVJA-k) 2025-08-13T13:00Z 59.4K followers, [---] engagements
"How to find the last number in a column in excel =TAKE(B.:.B-1) =LOOKUP(1E+300F:F) =XLOOKUP(TRUEJ.:.J less than symbol 10J.:.J-1) last number in column last number excel last number column excel last number in excel last value in column find last value last non-empty cell get last number excel last number in column last number excel last number column excel last number in excel last value in column find last value last non-empty cell get last number excel"
[YouTube Link](https://youtube.com/watch?v=2vwjtqcLnHY) 2025-07-23T13:00Z 59.4K followers, [---] engagements
"How to quickly make multiple charts in excel In this video I show you how to copy the same chart multiple times and then change the cell references it is linked to in order to make lots of similar charts. -------------------------------------------------------------------------------- #exceltips #exceltutorials #excelcharts SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] These data are related to my PhD research --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - How to make panel"
[YouTube Link](https://youtube.com/watch?v=3u4TU1PbhAk) 2019-05-29T13:00Z 57.4K followers, 138.9K engagements
"How to make a step chart in excel Quick manual method. Make two copies of the same values. Delete the first date and the last number from one set of values and line them up. Then plot the whole table as a line chart to make a step chart. Note: If this doesn't work for you try changing the x-axis options from text to date. --------------------------------------------------------------------------------- #exceltips #exceltutorials #excelcharts SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] Beta Channel Version 2103"
[YouTube Link](https://youtube.com/watch?v=4Ve-EM94VkA) 2021-03-31T12:00Z 55.8K followers, 57.7K engagements
"How to make a dynamic heat map in excel - dynamic array formulas How to show ozone concentrations for different months of the year. Using excels new FILTER formula and a data validation drop down list to make it dynamic. Then using conditional formatting to make the heat map. Microsoft excel recently introduced dynamic array formulas including the FILTER formula. They are currently only available to a random selection of people on the Office Insider Office [---] program or on google sheets. --------------------------------------------------------------------------------- #exceltipsandtricks"
[YouTube Link](https://youtube.com/watch?v=62G8edt2go8) 2018-10-31T15:00Z 52.3K followers, [----] engagements
"How to make subplots using pandas in python import pandas as pd import matplotlib.pyplot as plt df = pd.read_excel('C:python scriptsVT-24-25.xlsx''Sheet1'index_col=0) df.plot(subplots=Truefigsize=(3218)layout=(105)sharex=Truemarker='o'color='red') plt.subplots_adjust(hspace=0) plt.show() python pandas python python pandas subplots in python panel chart in python panel chart subplots subplots python subplots pandas python pandas python python pandas subplots in python panel chart in python panel chart subplots subplots python subplots pandas"
[YouTube Link](https://youtube.com/watch?v=6DMxyB4XIlE) 2025-08-20T13:00Z 59.4K followers, [---] engagements
"FILTER in Excel FILTER excel filter excel excel filter filter in excel filter function filter formula filter formula in excel FILTER excel filter excel excel filter filter in excel filter function filter formula filter formula in excel"
[YouTube Link](https://youtube.com/watch?v=71KELfWojeA) 2025-09-29T13:00Z 59.4K followers, [----] engagements
"How to summarize data using power query in excel Filter files in a folder and combine then together. Average data to hours for plotting in chart"
[YouTube Link](https://youtube.com/watch?v=81eP2iFl0kc) 2025-03-26T14:00Z 52.5K followers, [---] engagements
"Replace multiple words in excel using REDUCE =REDUCE(A2$C$7:$C$10LAMBDA(accumulatorvalueSUBSTITUTE(accumulatorvalueOFFSET(value01))))"
[YouTube Link](https://youtube.com/watch?v=8Kfmu-nbDzU) 2025-04-16T13:00Z 53K followers, [---] engagements
"How to edit a map in powerpoint In this video I show you how to edit a vector graphic/ svg file in powerpoint using the convert to shape feature. This is a new feature in powerpoint that lets you edit pictures. In this example I take [--] maps online and change them so they look different and convey a completely different message to the original maps. These maps wouldn't work very well for showing a lot of detailed information but they would be great for infographics presentations posters etc. --------------------------------------------------------------------------------- The links I used in"
[YouTube Link](https://youtube.com/watch?v=BRIfH70pSY4) 2018-05-02T14:30Z 55.7K followers, 89.7K engagements
"How to make national emergencies chart in excel National emergencies declared by US Presidents [----] - [----] Power Query XLOOKUP COUNTIFS Stacked Bar Chart excel XLOOKUP power query data from web COUNTIFS stacked bar chart stacked bar chart excel national emergency chart national emergencies figure emergencies declared by presidents graphic number of national emergencies diagram excel XLOOKUP power query data from web COUNTIFS stacked bar chart stacked bar chart excel national emergency chart national emergencies figure emergencies declared by presidents graphic number of national emergencies"
[YouTube Link](https://youtube.com/watch?v=BRpQ-WwWc_Y) 2025-08-27T13:00Z 59.4K followers, [---] engagements
"Extracting data from a table REGEXTEST FILTER COUNTIF GROUPBY =TEXTBEFORE(A2"_") =REGEXTEST(C2"ALMAALSX") =UNIQUE(FILTER(B1:C3223D1:D3223)) =COUNTIF($F$2:$F$390F2) =FILTER(F1#H1:H390 greater than 1) =GROUPBY(J2:J75K2:K75ARRAYTOTEXT0) arrange data regextest groupby rearrange data format data excel microsoft excel filter formula textbefore formula unique formula regex formulas in excel regex in excel regex excel groupby function groupby excel extract data arrange data regextest groupby rearrange data format data excel microsoft excel filter formula textbefore formula unique formula regex"
[YouTube Link](https://youtube.com/watch?v=DfB0od0YCjM) 2025-06-11T13:00Z 59.4K followers, [---] engagements
"How to make a reference list for beginners How to make a reference list without reference manager software In this video I show you an easy method for making a reference list in word. First copy and paste the full reference from google scholar. Then sort the list of references alphabetically. #referencelist #mswordtutorial #googlescholar --------------------------------------------------------------------------------- SUBSCRIBE: https://goo.gl/c46YPs --------------------------------------------------------------------------------- RELATED VIDEOS - This video is part of a playlist: Writing a"
[YouTube Link](https://youtube.com/watch?v=GR9JEY6CThE) 2017-01-08T11:28Z 48.1K followers, 117.3K engagements
"How to convert excel dates into decimal dates I have found three methods to convert excels dates into decimal dates where the year is represented by the whole number and the months and days are represented by everything after the decimal place as a fraction of a year. Method 1=(date/365.25)+1900 Method 2=year+(month/12)-(1/12)+(day/365.25) Method 3=YEARFRAC(date01)+1900 --------------------------------------------------------------------------------- #exceltutorials #exceltipsandtricks #excelformulas SUBSCRIBE: https://goo.gl/c46YPs VIDEO INFO: These data are related to my PhD research."
[YouTube Link](https://youtube.com/watch?v=GjYJ-oTBlP0) 2018-01-31T17:34Z 55.5K followers, 28.8K engagements
"How to line up the columns from two tables in excel =XLOOKUP(B12$B$1:$I$1$B$2:$I$5"") =SORT(UNIQUE(HSTACK(B1:I1B7:H7)1)1) line up columns excel combine tables join tables in excel combine multiple tables fix misaligned columns align columns in excel align columns align two tables align two ranges of data merge tables merge tables by matching column headers merge two tables combine two tables excel based on column headings line up columns excel combine tables join tables in excel combine multiple tables fix misaligned columns align columns in excel align columns align two tables align two"
[YouTube Link](https://youtube.com/watch?v=H9eEgRTFlYE) 2025-07-30T13:00Z 59.4K followers, [---] engagements
"REPLACE function in Excel"
[YouTube Link](https://youtube.com/watch?v=LiH3CQuEm3Y) 2023-08-07T13:00Z 53.5K followers, 11.8K engagements
"How to make subplots using matplotlib in python import matplotlib.pyplot as plt fig ((ax1ax2)(ax3ax4)) = plt.subplots(22 figsize=(103) sharex=True sharey=True) plt.subplots_adjust(wspace=0.01hspace=0) x = [-----] y1 = [------] y2 = [------] ax1.plot(xy1) ax2.plot(xy2) ax3.plot(xy1) ax4.plot(xy2) ax1.set_title("axis1") plt.suptitle("super title") plt.show()"
[YouTube Link](https://youtube.com/watch?v=LuPBzxTA-nA) 2023-11-15T14:00Z 53.3K followers, [----] engagements
"Check if multiple cells are equal in excel EXACT formula for more than two cells =AND(EXACT(A3A3:D3)) =AND(A3=A3:D3) =COUNTIF(A3:D3A3)=4 =COUNTA(UNIQUE(A3:D31))=1 =MIN(A3:D3)=MAX(A3:D3) compare values multiple cells equal multiple values same EXACT formula more than two values same number excel compare multiple values in excel EXACT more than two are all cells equal is content in each cell the same every cell the same multiple values in same compare values multiple cells equal multiple values same EXACT formula more than two values same number excel compare multiple values in excel EXACT more"
[YouTube Link](https://youtube.com/watch?v=Oqy9_Xz7FYM) 2025-05-21T13:00Z 59.4K followers, [----] engagements
"How to get a range to repeat multiple times using a formula in excel =TOCOL(C5:C7&EXPAND(""1B2"")1) =TOCOL(IF(SEQUENCE(1B20)C5:C7)1) Microsoft Office [---] Beta Channel Version 2309"
[YouTube Link](https://youtube.com/watch?v=Os8Yo3RiAVw) 2023-08-16T13:00Z 53.9K followers, 55.9K engagements
"Simple pivot table using an excel macro In this video I show you how to use a simple macro to create a pivot table and quickly format it. Then how to slightly edit the VBA code in-order to make the macro work for a table with any number of rows so the table can have a dynamic range. ------------------------------------------------------------------------- #exceltutorials #excelmacros #excelpivottables SUBSCRIBE: https://goo.gl/c46YPs VIDEO INFO: These data are related to my PhD research. ------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY"
[YouTube Link](https://youtube.com/watch?v=P0wue0zkcKA) 2018-08-22T20:00Z 55.9K followers, 108.4K engagements
"Reformatting my dataset in excel (for the ICOS Portal) =TEXT(J2"yyyy-mm-ddThh:mm:ssZ") =YEAR(J2) =MONTH(J2) =DAY(J2) =HOUR(J2) =MINUTE(J2) =LET(dateJ2yYEAR(date)hHOUR(date)minMINUTE(date)secSECOND(date)fstDATE(y11)doyINT(date)-fstsoy(doy*86400)+(h*3600)+(min*60)+secleapDATE(y1231)-fst+1fracsoy/(leap*86400)y+frac) =IFERROR(ROUND(J21)"") reorganise data rearrange table organize dataset reformatting dataset format dataset formatting data excel microsoft excel office [---] reorganise data rearrange table organize dataset reformatting dataset format dataset formatting data excel microsoft excel"
[YouTube Link](https://youtube.com/watch?v=PHYRRA_qv_4) 2025-06-04T13:00Z 59.4K followers, [---] engagements
"Excel: How many working days left in the year"
[YouTube Link](https://youtube.com/watch?v=RHyVYJITOVY) 2023-10-23T13:00Z 47.9K followers, [----] engagements
"How to make a variance chart in excel Target vs Actual - Clustered Column Chart with Error Bars variance chart variance chart excel variance chart in excel excel variance chart variance charts target vs actual chart target vs actual chart excel excel red arrows green arrows bar chart with arrows red and green arrows target vs actual variance chart variance chart excel variance chart in excel excel variance chart variance charts target vs actual chart target vs actual chart excel excel red arrows green arrows bar chart with arrows red and green arrows target vs actual"
[YouTube Link](https://youtube.com/watch?v=SArLYkxl1EY) 2025-09-10T13:01Z 59.4K followers, [----] engagements
"How to separate date and time in excel"
[YouTube Link](https://youtube.com/watch?v=TqB1irGix5o) 2023-10-09T13:00Z 52.3K followers, 39.4K engagements
"How to remove every other column in excel [--] methods Delete alternative columns in excel 0:00 Method [--] - Go to Special 0:33 Method [--] - Find All 1:28 Method [--] - Sort left to right 2:55 Method [--] - CHOOSECOLS"
[YouTube Link](https://youtube.com/watch?v=Tz2zcqqotb8) 2025-03-19T14:00Z 52.2K followers, [---] engagements
"How to rename photos to the date taken $shell = New-Object -ComObject shell.application $ukCulture = Globalization.CultureInfo'en-GB' Get-ChildItem ForEach $folder = $shell.NameSpace($_.DirectoryName) $RawDate = ($folder.GetDetailsOf($folder.ParseName($_.Name)12) -Replace "w /:") $datetime = DateTime::Parse($RawDate$ukCulture) $DateTaken = $datetime.ToString("yyyy-MM-dd HH.mm") Rename-Item $_.FullName ($DateTaken + $_.Extension) Find out what the code is for your country:"
[YouTube Link](https://youtube.com/watch?v=UKvkPnbQqwI) 2021-01-27T14:00Z 54.2K followers, 30K engagements
"Scatter plot with third variable as color Python Matplotlib How to make and customize a color map and color bar in python Choosing Colormaps in Matplotlib: https://matplotlib.org/3.1.0/tutorials/colors/colormaps.html ------------------------------------------------------------------------------------------------------------------- import matplotlib.pyplot as plt x = [-------------] y = [-----------] colors = [--------------] plt.scatter(xy s=200 c=colors cmap=plt.cm.get_cmap("cool"5)) cbar = plt.colorbar(orientation="vertical" extend="both" pad=0.05 shrink=1 aspect=20 format="%.3f")"
[YouTube Link](https://youtube.com/watch?v=VolIkTkYqMw) 2021-03-03T14:00Z 47.7K followers, 37K engagements
"How to calculate deming regression in excel =LET(xvaluesA2:A13yvaluesB2:B13xvarianceA16yvarianceB16 avgxAVERAGE(xvalues)avgyAVERAGE(yvalues) rSUMPRODUCT(xvalues-avgxyvalues-avgy) kxvariance/yvariance uDEVSQ(xvalues)vDEVSQ(yvalues) hk*v-u (h+SQRT(h2+4*k*r2))/(2*k*r)) deming regression deming regression excel deming regression in excel excel deming regression regressions in excel excel trend line total least squares regression linear trendline trendline including errors regression with uncertainties orthogonal regression excel deming regression deming regression excel deming regression in excel"
[YouTube Link](https://youtube.com/watch?v=Wh4j-iyuefI) 2025-09-24T13:01Z 59.4K followers, [---] engagements
"How to make hyperlinks to multiple files in excel =HYPERLINK() formula Links to all the files in a folder and sub-folders. Use windows command prompt to get a list of file names with their file paths. Use Text to Columns to get the file names on their own. dir/b/s/o clip --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - List of filenames from folder into Excel (Windows) https://youtu.be/771XysaD1DU"
[YouTube Link](https://youtube.com/watch?v=XZSDTxTVjtc) 2021-02-10T14:00Z 55.7K followers, 119.8K engagements
"Trick to quickly make a long nested formula in excel =TEXTJOIN(""TRUE"=""SUBSTITUTE(""SUBSTITUTE(""SUBSTITUTE(""SUBSTITUTE(""SUBSTITUTE(""SUBSTITUTE(""A2:A17""D3""E3";")D4""E4";")D5""E5";")D6""E6";")D7""E7";")D8""E8)") nested formula trick trick for nested formulas long formula how to quickly make long formulas how to easily make nested formulas quick nested formula excel make nested formula in excel trick for making long formula excel making nested formula nested formula nested formula excel nested formula in excel how to make nested formula in excel nested formula trick trick for nested"
[YouTube Link](https://youtube.com/watch?v=XZrOde3pzgU) 2025-05-07T13:00Z 59.4K followers, [----] engagements
"How to make a range chart in excel Using Clustered Column Chart Temperature data: nw3weather.co.uk/wx14.php range chart excel excel temperature range chart clustered column chart column chart in excel range charts temperature chart min-max chart min max chart chart showing minimum and maximum range make bar chart without bars going to zero range chart excel excel temperature range chart clustered column chart column chart in excel range charts temperature chart min-max chart min max chart chart showing minimum and maximum range make bar chart without bars going to zero"
[YouTube Link](https://youtube.com/watch?v=XlfUS55s_Y8) 2025-09-03T13:01Z 59.4K followers, [---] engagements
"For how many decimal places are the numbers the same in excel LAMBDA =SUM((ROUNDDOWN(B1SEQUENCE(15))=ROUNDDOWN(C1SEQUENCE(15)))*1) =LAMBDA(num_1num_2SUM((ROUNDDOWN(num_1SEQUENCE(15))=ROUNDDOWN(num_2SEQUENCE(15)))*1)) excel decimal places count decimal places same to how many decimal places compare numbers how many decimal places decimal places the same excel decimal places count decimal places same to how many decimal places compare numbers how many decimal places decimal places the same"
[YouTube Link](https://youtube.com/watch?v=Y18kl3c89EM) 2025-10-01T13:01Z 59.4K followers, [---] engagements
"14 NEW FORMULAS IN EXCEL [--]. TEXTSPLIT [--]. TEXTBEFORE [--]. TEXTAFTER [--]. VSTACK [--]. HSTACK [--]. TOROW [--]. TOCOL [--]. WRAPROWS [--]. WRAPCOLS [--]. TAKE [--]. DROP [--]. CHOOSEROWS [--]. CHOOSECOLS [--]. EXPAND Office insider: https://insider.office.com/en-us/ Announcement: https://techcommunity.microsoft.com/t5/excel-blog/announcing-new-text-and-array-functions/ba-p/3186066"
[YouTube Link](https://youtube.com/watch?v=ZyBCmq_JpsM) 2022-04-06T13:00Z 56.2K followers, [----] engagements
"How to get a sequence of numbers in a table in Microsoft Word Select column - Go to Home - Paragraph - Numbering - Numbering Library --------------------------------------------------------------------------------- #msword #microsoftword #mswordtutorial SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] Beta Channel Version [----] --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - Advanced Find & Replace with wildcards in Microsoft Word https://youtu.be/xeP9yyg6lF4"
[YouTube Link](https://youtube.com/watch?v=_7cFM-ua8mM) 2021-06-09T12:00Z 56.1K followers, 135.8K engagements
"How to make cross references in word In this video I show you how to make cross references in word. Cross referencing is when you refer in the text to another place in the text. This can be a figure a table a section an equation etc. This needs to be do in academic writing to link different parts of the document together. However often while writing the number of the figure/table/section/equation can change and it can be time consuming to go back and renumber all the sections so word allows you to create dynamic cross references that will update if the number changes. The cross references in"
[YouTube Link](https://youtube.com/watch?v=_gHqsqFNZy0) 2018-03-21T15:30Z 54.3K followers, 519.8K engagements
"Tricks for formatting data labels in excel charts excel excel chart excel charts data labels format data labels different data labels change data labels data labels in charts data labels excel excel excel chart excel charts data labels format data labels different data labels change data labels data labels in charts data labels excel"
[YouTube Link](https://youtube.com/watch?v=aBpNIA8Qie4) 2025-09-17T13:00Z 59.4K followers, [----] engagements
"Get axis labels to be multiple colors in Excel Make some of the numbers on an axis a different color excel excel chart chart axis numbers different colors axis labels two colors axis different colors make axis numbers multiple colors axis labels different colors excel excel chart chart axis numbers different colors axis labels two colors axis different colors make axis numbers multiple colors axis labels different colors"
[YouTube Link](https://youtube.com/watch?v=bK3YaMtpaOw) 2025-09-22T13:01Z 59.4K followers, [---] engagements
"Conditional formatting of rows based on changing values in excel =IF(C4=C3H3H3+1) =ISODD($H2)"
[YouTube Link](https://youtube.com/watch?v=bRgT5IH-QpE) 2024-12-18T14:00Z 56K followers, [----] engagements
"How to make a map in excel with latitude and longitude co-ordinates How to use excel 3D Map to make a 2D map. In this video I plot on a map the longitude and latitude locations of places air samples were collected from in a number of different research campaigns. I use the 3D Map feature in excel to make a 2D map using a list of longitude and latitude coordinates in an excel spreadsheet and plot dots on the map. I also change the size and colour of the dots and add annotations and images to the map. I then show you how to change the map background and how to customise the map background and"
[YouTube Link](https://youtube.com/watch?v=f2bZ7EkIcpU) 2017-08-02T16:55Z 55.5K followers, 268.8K engagements
"How to make a timeline in powerpoint Use a scatter chart and text boxes connected together with lines --------------------------------------------------------------------------------- #powerpoint #powerpointtutorials SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - How to make an academic poster in powerpoint https://youtu.be/_WnhoIbfcoM - [--] second countdown timer in PowerPoint https://youtu.be/qv1D29bxyjI - How to edit a map in"
[YouTube Link](https://youtube.com/watch?v=fMC-Bn86Q4w) 2020-06-24T14:18Z 56.4K followers, 387K engagements
"How to make a parliament chart in flourish Also called an arc-dot chart. Shows the number of people from each political party as different coloured dots"
[YouTube Link](https://youtube.com/watch?v=gAVjX53Eu_s) 2024-06-25T13:00Z 52.2K followers, [---] engagements
"How to randomly sort people into groups in excel Lambda =WRAPROWS(SORTBY(A2:A30RANDARRAY(ROWS(A2:A30)))3"")=LAMBDA(list_of_namesnum_of_groupsWRAPROWS(SORTBY(list_of_namesRANDARRAY(ROWS(list_of_names)))num_of_groups""))"
[YouTube Link](https://youtube.com/watch?v=gXF-7on5Dg0) 2024-10-23T13:00Z 57K followers, [----] engagements
"How to make a wind rose in excel In this video I show you how to make a wind rose in excel. I have wind direction and wind speed data which I put into a pivot table and then I use a radar chart to make a wind rose. A wind rose graph is used to show the distribution of wind speed and wind direction for a time period at a particular location. --------------------------------------------------------------------------------- If you want to see how I changed my wind direction in degrees into wind direction categories watch this video: https://youtu.be/qPS-rylzKvE This video is part of a playlist:"
[YouTube Link](https://youtube.com/watch?v=goLqJp2g87c) 2018-03-13T17:55Z 56.2K followers, 184.8K engagements
"How to make a population pyramid in excel World population data: https://www.populationpyramid.net/world/2025/ excel microsoft excel make population pyramid population pyramid butterfly chart population chart tornado chart diverging bar chart butterfly chart excel tornado chart excel diverging bar charts make a butterfly chart population pyramid in excel butterfly chart in excel make a tornado chart population pyramids population pyramid chart population pyramid charts pryamid excel microsoft excel make population pyramid population pyramid butterfly chart population chart tornado chart"
[YouTube Link](https://youtube.com/watch?v=hmg54CoaiW4) 2025-07-09T13:01Z 59.4K followers, [----] engagements
"Compare tables to find missing rows in Excel compare tables find missing rows find missing values differences between tables excel compare tables find missing rows find missing values differences between tables excel"
[YouTube Link](https://youtube.com/watch?v=jP-wDb2gEe0) 2025-10-13T13:01Z 59.4K followers, [---] engagements
"How to conditionally format a bubble chart in excel In this video I show you how to create multiple series on a bubble graph that overlap to make it appear as if the chart has conditional formatting. In this example I use a bubble chart I made in a previous video to show smaller concentrations as a lighter blue and larger concentrations as a darker blue. --------------------------------------------------------------------------------- #exceltutorial #excelbubblechart #excelconditionalformatting SUBSCRIBE: https://goo.gl/c46YPs VIDEO INFO: These data are related to my PhD research"
[YouTube Link](https://youtube.com/watch?v=jdpGIcZGofA) 2017-05-17T15:35Z 55.3K followers, [----] engagements
"Make first letter in a cell into a capital letter in excel 0:00 Method [--] - Word 0:41 Method [--] - Flash Fill 1:30 Method [--] - REPLACE 2:48 Method [--] - REGEXREPLACE =REPLACE(A211UPPER(LEFT(A21))) =REGEXREPLACE(A2"w""u$0") capitalize first letter upper case excel regex in excel change case in excel change case of only first letter make only first letter capital first letter capital capital letter excel make only one word upper case excel first letter in cell capital excel uppercase excel capitalise first letter excel capitalize first letter upper case excel regex in excel change case in excel"
[YouTube Link](https://youtube.com/watch?v=o0fDfHxCxp8) 2025-05-14T13:01Z 59.4K followers, [----] engagements
"CHOOSEROWS in Excel chooserows CHOOSEROWS excel chooserows formula chooserows function choose rows in excel choose rows formula in excel chooserows CHOOSEROWS excel chooserows formula chooserows function choose rows in excel choose rows formula in excel"
[YouTube Link](https://youtube.com/watch?v=pt-eNTc-TKM) 2025-10-06T13:01Z 59.4K followers, [---] engagements
"Make a font of your own handwriting using Microsoft Font Maker In this video I show you how to make a custom font using Microsoft Font Maker which can be downloaded for free from the Microsoft Store. You need a touch screen laptop/ computer and stylus digital pen in order to get this to work. Then you can save the font as a *.ttf file and then use it for other applications e.g. Microsoft Word. --------------------------------------------------------------------------------- #microsoftfontmaker #customfonts #windows10 SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider"
[YouTube Link](https://youtube.com/watch?v=tnhqLJIf7Uk) 2019-01-09T15:00Z 56.6K followers, 138K engagements
"How to change NaN into null in Power Query = Table.TransformColumns(#"Changed Type" "CO2.ppm" each if Number.IsNaN(_) then null else _ type number)"
[YouTube Link](https://youtube.com/watch?v=ujMPIK_OekQ) 2023-09-27T13:00Z 53.6K followers, [----] engagements
"How to find and replace multiple words in excel with power query =List.Accumulate(Table.ToRecords(TableFindReplace) #"Changed Type" (TableToChangeTableFindReplace) = LESS THAN SYMBOL Table.ReplaceValue(TableToChangeTableFindReplaceOld WordsTableFindReplaceNew WordsReplacer.ReplaceText"Column Name")) substitute multiple words replace multiple words find and replace multiple words at once excel replace multiple pieces of text substitute multiple characters bulk replace replace multiple words in one go replace multiple words in excel find and replace power query find & replace words with power"
[YouTube Link](https://youtube.com/watch?v=vI-2sZ515wU) 2025-04-30T13:01Z 59.4K followers, [---] engagements
"How to get axes to overlap using matplotlib in python import matplotlib.pyplot as plt plt.rc('axes'facecolor='none') fig = plt.figure() ax1 = fig.add_axes(0010.4) #left bottom width height ax2 = fig.add_axes(00.310.4) ax3 = fig.add_axes(00.610.4) x = [----] y_1 = [----] y_2 = [--------] y_3 = [------------] ax1.plot(xy_1color='red') ax2.plot(xy_2color='blue') ax3.plot(xy_3color='green') ax1.spines'top'.set_visible(False) ax2.spines'top'.set_visible(False) ax2.spines'bottom'.set_visible(False) ax3.spines'bottom'.set_visible(False) ax3.xaxis.set_ticks_position('top')"
[YouTube Link](https://youtube.com/watch?v=vuTPeLmNSIU) 2025-08-06T13:01Z 59.4K followers, [---] engagements
"How to make a parliament chart in excel Also called an arc-dot chart. Shows the number of people from each political party as different coloured dots. https://policyviz.com/2019/03/21/arc-dot-chart-in-excel/"
[YouTube Link](https://youtube.com/watch?v=vzBy2Hti6Ww) 2024-06-19T13:00Z 52.3K followers, [----] engagements
"Round to the nearest [--] in Excel round nearest ten round nearest [---] round to the closest multiple of [--] excel round nearest ten round nearest [---] round to the closest multiple of [--] excel"
[YouTube Link](https://youtube.com/watch?v=wjNYWWJIDDw) 2025-09-15T13:02Z 59.4K followers, [----] engagements
"Advanced Find & Replace with wildcards in Microsoft Word How to use wildcards in find and replace in microsoft word. --------------------------------------------------------------------------------- #msword #microsoftword #mswordtutorial SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - Find a word only if it is the first word in a paragraph in Microsoft Word https://youtu.be/6Ewc8JBClEw - This video is part of a playlist: Writing"
[YouTube Link](https://youtube.com/watch?v=xeP9yyg6lF4) 2020-10-16T18:00Z 54.8K followers, 52K engagements
"Split column on every other delimiter in power query excel power query split list power query every other delimiter split list in power query split column power query excel power query split list power query every other delimiter split list in power query split column power query"
[YouTube Link](https://youtube.com/watch?v=xrQDK8S-P0I) 2025-10-08T13:02Z 59.4K followers, [---] engagements
"How to split text in excel - [--] methods Flash Fill Text-to-Columns Power Query Formula Macro Google sheets UDF Separate words into multiple columns Method 1: Flash Fill 00:00 Method 2: Text-to-Columns 00:39 Method 3: Power Query 01:17 Method 4: Formula 02:40 Method 5: Macro 03:01 Method 6: Google sheets 09:44 Method 7: UDF 10:30 -------------------------------------------------------------------------------------------------------------- =TRIM(MID(SUBSTITUTE($J5" "REPT(" "LEN($J5)))(COLUMNS($J4:J4)-1)*LEN($J5)+1LEN($J5)))"
[YouTube Link](https://youtube.com/watch?v=y4KSW50YoW8) 2020-08-20T18:00Z 55.6K followers, 343K engagements
"Get table to repeat x number of times in excel excel repeat table repeat range repeat range in excel repeat table in excel copy range multiple times multiple copies of range same table multiple times excel repeat table repeat range repeat range in excel repeat table in excel copy range multiple times multiple copies of range same table multiple times"
[YouTube Link](https://youtube.com/watch?v=zk-nZJ-ucW0) 2025-09-01T13:02Z 59.4K followers, [---] engagements
"Change all formulas to absolute cell references in Excel absolute cell references cell references with dollar signs formulas all absolute all formulas absolute multiple formulas have absolute cell references excel multiple formulas absolute all cell references absolute multiple cell references absolute absolute cell references cell references with dollar signs formulas all absolute all formulas absolute multiple formulas have absolute cell references excel multiple formulas absolute all cell references absolute multiple cell references absolute"
[YouTube Link](https://youtube.com/watch?v=-5CBsoYjZIw) 2025-12-01T14:00Z 59.4K followers, [----] engagements
"How to make a dot plot in excel How to create connected dot plots in excel by modifying a scatter chart. The data and the inspiration for this chart came from Our World in Data: https://ourworldindata.org/top-incomes-more-women-but-still-very-male-dominatedutm_source=OWID+Newsletter&utm_campaign=74007742ea-biweekly-digest-2021-07-02&utm_medium=email&utm_term=0_2e166c1fc1-74007742ea-523788678 --------------------------------------------------------------------------------- #exceltips #exceltutorials #excelcharts SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] Beta Channel Version 2109"
[YouTube Link](https://youtube.com/watch?v=0nS2zOScvzk) 2021-08-18T13:00Z 58.7K followers, 22.6K engagements
"Get a random subgroup in Excel random group excel random group random group excel random groups select random random selection random names excel random group excel random group random group excel random groups select random random selection random names excel"
[YouTube Link](https://youtube.com/watch?v=4UJ95phCYgE) 2025-10-20T13:00Z 59.4K followers, [----] engagements
"How to split paragraph of text across multiple rows in excel LAMBDA =LAMBDA(txtnumBYROW(WRAPROWS(TEXTSPLIT(txt" ")num"")LAMBDA(arrayTEXTJOIN(" "FALSEarray))))"
[YouTube Link](https://youtube.com/watch?v=4Uc8kK_sOLU) 2024-05-22T13:00Z 57.5K followers, [---] engagements
"How to repeat the same number multiple times in excel Multiple methods: Fill Handle Ctrl + Enter =cell reference SEQUENCE & RANDARRAY --------------------------------------------------------------------------------- #exceltips #exceltutorials #excelformulas SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] Beta Channel Version [----] --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - How to autofill numbers in excel https://youtu.be/JUFUTUC2Rxs - How to get repeating numbers in excel 123123"
[YouTube Link](https://youtube.com/watch?v=4yaceJErMw4) 2021-05-26T12:00Z 59K followers, 221.5K engagements
"Remove duplicate values in Excel remove duplicates excel remove duplicates in excel get unique values excel remote duplicates excel data tools remove duplicates excel remove duplicates in excel get unique values excel remote duplicates excel data tools"
[YouTube Link](https://youtube.com/watch?v=5ANCyslVELY) 2025-11-17T14:00Z 59.4K followers, 11.5K engagements
"New Excel Feature - Focus Cell Only available in some versions of excel"
[YouTube Link](https://youtube.com/watch?v=6B5kr6pETuU) 2024-10-27T14:00Z 58K followers, [----] engagements
"How to make comments in Adobe Acrobat Reader Sticky Notes Highlights Underline Strikethrough Replace & Insert --------------------------------------------------------------------------------- #adobereader #adobetutorial SUBSCRIBE: https://goo.gl/c46YPs This pdf document was written as part of my PhD research --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE - How to use comments and track changes in Microsoft Word https://youtu.be/qQA7UrAaN0s - This video is part of a playlist: Writing a thesis in Word"
[YouTube Link](https://youtube.com/watch?v=6F3u8Rn0dqY) 2020-06-30T13:00Z 57.5K followers, 63.8K engagements
"Calculate current value from depreciation rate and original value in excel =E13*(1-$B$9/100) =B7*(1-B9/100)(YEAR(TODAY())-B8) =B7*POWER(1-B9/100YEAR(TODAY())-B8) =B7-VDB(B701000YEAR(TODAY())-B8B9TRUE) depreciation rate salvage value present value future value excel depreciation rate salvage value present value future value excel"
[YouTube Link](https://youtube.com/watch?v=6aF_V2SvR3Y) 2025-12-03T14:00Z 59.4K followers, [---] engagements
"Get all the factors of a number in excel =LET(numH1ARRAYTOTEXT(FILTER(SEQUENCE(num)MOD(numSEQUENCE(num))=0))) factors excel prime number excel excel prime number excel factors all factors excel factors in excel get factors in excel excel all factors number factors factors of numbers factors of a number factors excel prime number excel excel prime number excel factors all factors excel factors in excel get factors in excel excel all factors number factors factors of numbers factors of a number"
[YouTube Link](https://youtube.com/watch?v=6q-r1rIAPEU) 2025-11-26T14:00Z 59.4K followers, [---] engagements
"How to make a countdown timer in powerpoint using VBA Sub countdown() Dim future As Date future = DateAdd("n" [--] Now()) Do Until future _less than symbol_ Now() DoEvents ActivePresentation.Slides(1).Shapes("rectangle").TextFrame.TextRange = Format(future - Now() "nn:ss") Loop End Sub _The less than symbol is not allowed in a YouTube description_ -------------------------------------------------------------------------------- #powerpoint #powerpointtutorials SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] Beta Channel Version 2107"
[YouTube Link](https://youtube.com/watch?v=7iBKFKobArw) 2021-07-21T13:00Z 59.1K followers, 18.6K engagements
"How to create a dropdown box in excel In this video I show you how to use the combo box in the developer tab in excel to make a dropdown bar that will change what is plotted in a graph to make a dynamic chart using a vlookup formula. =VLOOKUP($AD$2$AD$4:$BC$16COLUMNS($AE$1:AE$1)+1FALSE) #exceltutorial #excelformulas #excelcharts --------------------------------------------------------------------------------- SUBSCRIBE: https://goo.gl/c46YPs --------------------------------------------------------------------------------- RELATED VIDEOS - This video is part of a playlist: Daily cycles of"
[YouTube Link](https://youtube.com/watch?v=9pJJ6iKotXI) 2017-01-04T20:32Z 59K followers, [----] engagements
"How to make cells square in excel Method 1: Make rows and columns the same number of pixels. Method 2: Change View to Page Layout and set Column Width and Row Height to the same size. --------------------------------------------------------------------------------- #exceltips #exceltutorials SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] ---------------------------------------------------------------------------------"
[YouTube Link](https://youtube.com/watch?v=A9lYFe1riZ8) 2020-07-08T17:57Z 58.2K followers, 197.6K engagements
"Tricks for number patterns in formulas in excel =MOD(SEQUENCE(12101)3)*2+2 =INT(SEQUENCE(12111/3)) =CHOOSEROWS(I1:K132;2;5;5;8;8;11;11) =TOCOL(SEQUENCE(5)&EXPAND(""13"")1) =LET(aINT(SEQUENCE(61/3))VSTACK(aaa)) =(INT(SEQUENCE(121/3))*3-2)+SEQUENCE(30) =MAKEARRAY(1010LAMBDA(rcr*c))"
[YouTube Link](https://youtube.com/watch?v=AiMw_gIcpI0) 2025-10-30T15:00Z 59.4K followers, [---] engagements
"How to remove blank/ zero values from a graph in excel How to stop an excel chart from plotting the blank values in a table. In some situations a chart in excel will plot blank cells as zero values even if there not real data points and this can mess up the chart. There are a couple of ways you can stop this from happening by using an IF formula around the formula you already have to change every zero into #N/A as graphs in excel wont plot #N/A. You can also change the settings of the chart or the settings of the worksheet to try and get rid of them depending on the situation."
[YouTube Link](https://youtube.com/watch?v=BlBWZN2eldY) 2017-03-08T17:13Z 59.2K followers, 242.5K engagements
"How to make a chart with [--] axis in excel Create two charts and line them up over the top of each other --------------------------------------------------------------------------------- #exceltutorials #exceltips #excelcharts SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] These data are related to my PhD research --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - How to make multiple charts using vba in excel https://youtu.be/5_p8hltGY4s - How to quickly make multiple charts in"
[YouTube Link](https://youtube.com/watch?v=CpR8QvC6pAA) 2019-09-18T17:00Z 58.8K followers, 687.8K engagements
"Copy list of filenames from folder into Excel (Windows) [--]. Select all the files and then go to Home and Copy Path. Paste into Excel and use Find & Replace (Ctrl + H) to remove the file path. [--]. Copy file path into google chrome and then copy the list of files size and date modified. [--]. To get files in subfolders as well search for a full stop/ period which will find all the files and then copy the path into excel. --------------------------------------------------------------------------------- SUBSCRIBE: https://goo.gl/c46YPs"
[YouTube Link](https://youtube.com/watch?v=F7SE5h7AUBg) 2020-12-04T14:00Z 59K followers, 430.4K engagements
"How to calculate the significance of the Spearman's correlation in excel How to calculate the t-test and the p-value for a spearman's correlation to find out if your values are actually significantly correlated. Formulas in this video: n =COUNT(B2:B24) rho =CORREL(RANK.AVG(A2:A24A2:A24)RANK.AVG(B2:B24B2:B24)) t-stat =F3*SQRT((F2-2)/(1-F32)) p-value =T.DIST.2T(ABS(F4)F2-2) For more information about calculating the spearman's correlation: http://www.real-statistics.com/correlation/spearmans-rank-correlation/spearmans-rank-correlation-detailed/ Real Stats excel add-in:"
[YouTube Link](https://youtube.com/watch?v=Im2hCSeT1v0) 2019-04-24T13:00Z 58.9K followers, 26.4K engagements
"How to make a bubble chart map in excel How to make a bubble chart map with latitude and longitude coordinates in excel. In this video I plotted data from an aircraft campaign in which air samples were taken at regular intervals during a flight. I plotted the data with the longitude and latitude of the location where each of the samples was taken from as the axis and the concentrations of a compound as the size of the bubbles. I also put an image of a map behind my graph and matched the grid references up with the longitude and latitude on the graph so the bubbles would be in about the"
[YouTube Link](https://youtube.com/watch?v=KdW2GRivAnM) 2017-04-05T15:06Z 57.8K followers, [----] engagements
"List of filenames from folder and subfolders into Excel Use Power Query to get a list of files in a folder and subfolders with information such as date modified and file size. The list will update if you add or remove files. --------------------------------------------------------------------------------- #exceltips #exceltutorials SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - Copy list of filenames from folder into Excel"
[YouTube Link](https://youtube.com/watch?v=NQ3uOFpDRXM) 2020-12-09T14:00Z 58.8K followers, 48.2K engagements
"How to get axis labels on only part of the axis in an excel chart Use custom number formatting to make only some of the numbers on an axis visible in a chart in excel. --------------------------------------------------------------------------------- #exceltips #exceltutorials #excelcharts SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] These data are related to my PhD research --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - How to make a chart with [--] axis in excel"
[YouTube Link](https://youtube.com/watch?v=NZPOcq6DHrk) 2019-10-30T14:00Z 57.7K followers, [----] engagements
"How to add asterisks to a correlation table to show the significance in excel How to calculate the correlation from the p value. In this video I show you how to calculate the r critical value to find out how big the correlation needs to be to be significant at p [----] and p [----]. Then how to add conditional formatting to change the number formatting to add asterisks after the significant correlations in the correlation table. r critical value =T.INV(1-alpha/2n-2)/SQRT(T.INV(1-alpha/2n-2)2+n-2) Pearson Correlation - r Critical and p Value of r in Excel"
[YouTube Link](https://youtube.com/watch?v=OtgAp_E5erU) 2019-05-15T13:00Z 58.9K followers, 45K engagements
"What are CFCs HCFCs HFCs and PFCs This video is a very brief introduction to four different kinds of halocarbons: what their names stand for; the differences in their atmospheric lifetimes; and the differences in their ozone depleting potentials. For more information: http://www.ipcc.ch/ipccreports/sres/emission/index.phpidp=123 This video is part of a playlist: The Ozone Hole https://www.youtube.com/playlistlist=PLVe64sIb7fSYa-rr9cbSOigAtjRNwpuXv Another video: What are CFCs https://youtu.be/YL9g7JGLPp4"
[YouTube Link](https://youtube.com/watch?v=QAQeynpIpkc) 2017-09-07T20:36Z 59.1K followers, 10.6K engagements
"Find numbers missing from a sequence in excel =LET(rangeA2:A44UNIQUE(VSTACK(rangeSEQUENCE(MAX(range)-MIN(range)+1MIN(range)))TRUE)) =LAMBDA(rangeUNIQUE(VSTACK(rangeSEQUENCE(MAX(range)-MIN(range)+1MIN(range)))TRUE))(A2:A44) missing numbers excel find missing numbers missing values in a sequence missing from a sequence missing numbers in a sequence missing numbers excel find missing numbers missing values in a sequence missing from a sequence missing numbers in a sequence"
[YouTube Link](https://youtube.com/watch?v=UxhCXJplcvo) 2025-11-12T14:00Z 59.4K followers, [----] engagements
"UNIQUE in Excel UNIQUE in excel excel UNIQUE unique formula unique function remove duplicates unique formula in excel unique function in excel remove duplicates with formula excel UNIQUE in excel excel UNIQUE unique formula unique function remove duplicates unique formula in excel unique function in excel remove duplicates with formula excel"
[YouTube Link](https://youtube.com/watch?v=VFPWRfDbYso) 2025-11-10T14:01Z 59.4K followers, [----] engagements
"How to make bar charts more interesting in excel Create a bar chart with rounded corners and data labels"
[YouTube Link](https://youtube.com/watch?v=XNZwXimNeI0) 2024-04-24T13:00Z 51.2K followers, 19.1K engagements
"What are CFCs This video is a brief introduction to CFCs. What are CFCs When did CFCs first start being used What were CFCs used for Why aren't CFCs being used anymore How are concentrations of CFCs in the atmosphere changing For more information see: https://en.wikipedia.org/wiki/Chlorofluorocarbon This video is part of a playlist: The Ozone Hole https://www.youtube.com/playlistlist=PLVe64sIb7fSYa-rr9cbSOigAtjRNwpuXv The previous videos in this series are: [--]. The Layers of the Atmosphere: https://youtu.be/_Y0w74Gie30 [--]. The Ozone Layer: https://youtu.be/x33mQDnajGM [--]. CFC numbering system:"
[YouTube Link](https://youtube.com/watch?v=YL9g7JGLPp4) 2017-07-19T16:38Z 57.4K followers, 27.2K engagements
"How to unpivot multiple columns in excel =INDEX(G5:R9G13:G32I13:K32) =TOCOL(UNIQUE(G4:R41)&S5:S91) excel excel tutorial unpivot multiple columns unpivot table rearrange table rearrange data excel excel tutorial unpivot multiple columns unpivot table rearrange table rearrange data"
[YouTube Link](https://youtube.com/watch?v=ZLe38QYiE7w) 2025-10-22T13:01Z 59.4K followers, [---] engagements
"Bold start of words in Microsoft Word (Bionic Reading) Sub BoldStart() For Each wd In ActiveDocument.Range.Words For i = [--] To Int((Len(wd) + 1) / 2) wd.Characters(i).Font.Bold = True Next i Next wd End Sub bionic reading microsoft word microsoft word vba microsoft word macro bold first half of words bold start of every word word bold start vba first letters bold ms word first letters bold bold the start of words first letter bold first word bold bionic reading microsoft word microsoft word vba microsoft word macro bold first half of words bold start of every word word bold start vba first"
[YouTube Link](https://youtube.com/watch?v=ZqeYS653TgA) 2025-12-17T14:01Z 59.4K followers, [---] engagements
"How to add references into word using google scholar and mendeley How to make a reference list in Microsoft word. Using google scholar to copy and paste citations. Or using Mendeley reference manager plug-in to insert a bibliography. -------------------------------------------------------------------------------- #msword #microsoftword #mswordtutorial SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - How to convert a pdf into a"
[YouTube Link](https://youtube.com/watch?v=cGA6oqGzh4Y) 2019-07-24T13:00Z 58.5K followers, 642.1K engagements
"Keyboard shortcut to move columns & rows in Excel excel move columns rearrange columns reorder columns columns in excel reorder rows in excel insert rows excel move columns rearrange columns reorder columns columns in excel reorder rows in excel insert rows"
[YouTube Link](https://youtube.com/watch?v=ce9pmRisN34) 2025-11-03T14:01Z 59.4K followers, [----] engagements
"GROUPBY in Excel GROUPBY GROUPBY in excel excel GROUPBY GROUPBY excel groupby function groupby formula groupby formula in excel GROUPBY GROUPBY in excel excel GROUPBY GROUPBY excel groupby function groupby formula groupby formula in excel"
[YouTube Link](https://youtube.com/watch?v=fYkd_NTxn2E) 2025-12-15T14:01Z 59.4K followers, [----] engagements
"SEQUENCE in Excel sequence in excel SEQUENCE excel excel SEQUENCE sequence function sequence formula sequence formula in excel excel sequence in excel SEQUENCE excel excel SEQUENCE sequence function sequence formula sequence formula in excel excel"
[YouTube Link](https://youtube.com/watch?v=g1LCNOy9mm4) 2025-10-27T14:01Z 59.4K followers, [----] engagements
"Heatmap in Excel #shorts"
[YouTube Link](https://youtube.com/watch?v=iUE0cD0Y2No) 2023-01-30T14:00Z 59K followers, [----] engagements
"How to use advanced filter to remove blanks in excel =A1"" To use advanced filter to get rid of blank cells make the heading in the criteria range a blank cell and then use the formula =A1"" which means is cell A1 less than or greater than two quotation marks i.e. is cell A1 not equal to a blank. Make the cell reference the cell in the top row of the column you want to filter. To filter more than one column us =AND(A1""B1"") -------------------------------------------------------------------------------- #exceltips #exceltutorials #msexcel SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office 365"
[YouTube Link](https://youtube.com/watch?v=inC2jMxm5eE) 2019-08-14T13:00Z 57.5K followers, 33.9K engagements
"Symbol bar chart in a cell in excel =REPT(""3)"
[YouTube Link](https://youtube.com/watch?v=mmayx-awc_Q) 2023-05-22T13:00Z 58.1K followers, 32.2K engagements
"Check if two columns are the same in Excel #shorts =EXACT()"
[YouTube Link](https://youtube.com/watch?v=n-GovQXm_os) 2023-03-13T14:00Z 57.7K followers, 40.4K engagements
"Get values to repeat in Excel excel repeat values repeat cells repeat values in excel repeating values repeat values excel excel repeating values repeating values formula excel repeat values repeat cells repeat values in excel repeating values repeat values excel excel repeating values repeating values formula"
[YouTube Link](https://youtube.com/watch?v=n1FlFZUf-G0) 2025-12-22T14:01Z 59.4K followers, [---] engagements
"How to make a forest plot in excel Turn a bar chart into a forest plot --------------------------------------------------------------------------------- #exceltutorials #excelcharts #exceltips SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] Beta Channel Version [----] ---------------------------------------------------------------------------------"
[YouTube Link](https://youtube.com/watch?v=nGuDa9f5sYk) 2022-01-26T14:00Z 58.3K followers, 84.7K engagements
"How to match up data with different dates and times in excel How to combine two different sets of data when one set of data has gaps in it. In this video I combine modelled wind direction with hourly ozone concentrations at Weybourne in the UK 2010-2014. As wind direction results aren't produced as often as hourly ozone concentrations there are some gaps in the data. In order to line up the wind directions with the ozone concentrations I use an INDEX MATCH formula to line up the dates and times. =INDEX(wind data MATCH(date & time dates & times 0)) #exceltutorial #excelformulas"
[YouTube Link](https://youtube.com/watch?v=nTmpuNUSMCc) 2015-10-14T18:19Z 58.7K followers, 96.3K engagements
"Make formulas with discontinuous cell references in excel excel discontinous cell references split cell references cell references without a pattern interrupted cell references formulas with weird cell references excel discontinous cell references split cell references cell references without a pattern interrupted cell references formulas with weird cell references"
[YouTube Link](https://youtube.com/watch?v=pZmN2DBa-38) 2025-12-08T14:01Z 59.4K followers, [----] engagements
"Join text together in Excel using CONCAT"
[YouTube Link](https://youtube.com/watch?v=qAwdSbUN3u4) 2023-07-03T13:00Z 57.7K followers, [----] engagements
"Get ID number using REGEXEXTRACT in Excel =REGEXEXTRACT(C2"wd4") REGEXEXTRACT excel REGEXEXTRACT excel excel regexextract regexextract in excel REGEXEXTRACT formula example of REGEXEXTRACT REGEXEXTRACT example REGEX excel excel regex regex in excel regex formula in excel REGEXEXTRACT function REGEXEXTRACT excel REGEXEXTRACT excel excel regexextract regexextract in excel REGEXEXTRACT formula example of REGEXEXTRACT REGEXEXTRACT example REGEX excel excel regex regex in excel regex formula in excel REGEXEXTRACT function"
[YouTube Link](https://youtube.com/watch?v=tKwSLuPRUm4) 2025-11-24T14:01Z 59.4K followers, [----] engagements
"Copy text from pdf into word without splitting across multiple lines Use Find and Replace to replace all paragraph marks (p) with spaces to get rid of line breaks in Microsoft Word fix formatting when copying text from pdf into word microsoft word remove paragraph marks remove line breaks change paragraph marks to spaces find and replace stop text splitting across lines from multiple lines to one paragraph coping from pdf to word fix formatting when copying text from pdf into word microsoft word remove paragraph marks remove line breaks change paragraph marks to spaces find and replace stop"
[YouTube Link](https://youtube.com/watch?v=tRShUescrXY) 2025-12-10T14:01Z 59.4K followers, [---] engagements
"Analyzing data in excel example XLOOKUP AVERAGEIF TEXT FILTER =IF(B3=B2D2D2+1) =XLOOKUP(D2$J$2#$P$2:$P$14) =IF(ISEVEN(D2)F2NA()) =IF(ISODD(D2)F2NA()) =UNIQUE(D2:D10281) =XLOOKUP($J$2#$D$2:$D$10281$B$2:$B$10281) =TEXT(L2"mmm yyyy")&" - "&TEXT(M2"mmm yyyy") =COUNTIF($D$2:$D$10281J2) =AVERAGEIF($D$2:$D$10281J2$C$2:$C$10281) =STDEV.P(FILTER($C$2:$C$10281$D$2:$D$10281=J2)) analyze data excel analyse data in excel xlookup averageif excel formulas excel functions using excel for science analyze data excel analyse data in excel xlookup averageif excel formulas excel functions using excel for science"
[YouTube Link](https://youtube.com/watch?v=wwZvO42NKl0) 2025-06-18T13:01Z 59.4K followers, [---] engagements
"How to use quickchart.io to make charts that aren't available in excel =IMAGE(B7&B8) /chartv=3&c= type: 'funnel' data: labels: 'Leads' 'Emails' 'Calls' 'Quotes''Sales' datasets: data: [---] [----] [----] [----] [----] backgroundColor: 'rgb(139 [--] 0)' 'rgb(205 [--] 92)' 'rgb(240 [---] 128)' 'rgb(250 [---] 114)' 'rgb(255 [---] 122)' options: indexAxis: 'x' quickchart.io quickchart funnel chart excel microsoft excel funnel chart in excel IMAGE function IMAGE formula IMAGE function in excel quickchart.io quickchart funnel chart excel microsoft excel funnel chart in excel IMAGE function IMAGE formula IMAGE"
[YouTube Link](https://youtube.com/watch?v=ww_rclhbDjQ) 2025-06-25T13:01Z 59.4K followers, [---] engagements
"How to make the font of the axis labels different colors in an excel chart Use custom number formatting: Red=700;Color43400;0 Overlap the secondary and primary axis --------------------------------------------------------------------------------- #exceltips #exceltutorials #excelcharts SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - How to get axis labels on only part of the axis in an excel chart https://youtu.be/NZPOcq6DHrk -"
[YouTube Link](https://youtube.com/watch?v=z4Vptz3PIgY) 2019-12-18T14:00Z 57.4K followers, 30.9K engagements
"List of filenames from folder into Excel Copy Folder Path into excel. Add "*" onto end of folder path. Make a named range using the formula =FILES() and then use the named range to get a list of file names. --------------------------------------------------------------------------------- #exceltips #exceltutorials SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - Copy list of filenames from folder into Excel (Windows)"
[YouTube Link](https://youtube.com/watch?v=zDWlH0C0toU) 2020-12-16T14:00Z 58.8K followers, 30.1K engagements
"How to do integrations in IAU Part [--] How all the features work and integrating the first compound. I have made these videos to help me and the people I work with remember how to use this software"
[YouTube Link](https://youtube.com/watch?v=g74fjEeMMGY) 2018-01-02T19:38Z 59.3K followers, [---] engagements
"How to make a calendar heatmap in excel Using a VLOOKUP formula conditional formatting and custom number formatting. Average daily temperature in England in [----] https://www.metoffice.gov.uk/hadobs/hadcet/data/download.html --------------------------------------------------------------------------------- #exceltips #exceltutorials #excelcharts SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - How to make a calendar heatmap in excel"
[YouTube Link](https://youtube.com/watch?v=nKZPQyt-ZKY) 2020-03-30T13:00Z 59.3K followers, [----] engagements
"How to make a dynamic chart using slicers in excel Convert the values into an excel table. Then on the 'Table Design' tab select 'Insert Slicer'. Make a chart for the whole of the table. Then you can use the slicer to filter the table and the chart. --------------------------------------------------------------------------------- #exceltips #exceltutorials #excelcharts SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] These data are related to my PhD research --------------------------------------------------------------------------------- IF YOU LIKED"
[YouTube Link](https://youtube.com/watch?v=3JEC-iFLolA) 2019-12-24T14:00Z 59.4K followers, 112.3K engagements
"Roll of the dice in excel Use the Segoe UI Symbol font to get the six sides of the dice ⚀⚁⚂⚃⚄⚅ Then use the =RANDBETWEEN(16) formula to get random numbers between [--] and [--]. After that use a VLOOKUP formula to find the side of the dice. Finally copy the dice as linked pictures and press F9 to 'roll the dice' --------------------------------------------------------------------------------- #exceltips #exceltutorials #excelformulas SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version 2006"
[YouTube Link](https://youtube.com/watch?v=68nly1L7bJo) 2020-05-28T13:00Z 59.4K followers, 22.1K engagements
"Delete notes from all slides in powerpoint File - Info - Check for Issues - Inspect Document - Presentation Notes - Inspect - Remove All powerpoint delete notes powerpoint remove notes slide notes presentation notes all notes at once speaker notes notes from all slides in one go remove all notes presenter notes get rid of delete notes multiple slides powerpoint delete notes powerpoint remove notes slide notes presentation notes all notes at once speaker notes notes from all slides in one go remove all notes presenter notes get rid of delete notes multiple slides"
[YouTube Link](https://youtube.com/watch?v=97uIcRpBEl8) 2026-02-11T14:00Z 59.4K followers, [--] engagements
"How to make a map in excel using a bubble chart In this video I show you how to use a bubble chart in excel to make a map using longitude and latitude coordinates. I change the background of the chart into an image of a map and then change the x and y axis to control the position of the data points. I also show you how to remove the axis labels add multiple series to the graph and add labels to the map. --------------------------------------------------------------------------------- #exceltutorials #excelbubblecharts #excelmaps SUBSCRIBE: https://goo.gl/c46YPs"
[YouTube Link](https://youtube.com/watch?v=ErEeyQmvlRI) 2017-08-16T18:38Z 59.4K followers, 28.1K engagements
"How to import multiple text files into excel How to put lots of text files into a single excel spreadsheet all in one go. Sometimes you have data in lots of separate text files and you want to be able to put that data together in an excel document without having to copy and paste each text file individually. You can do this using Power Query. This is a really useful feature in Excel [----] which lets you organize large amounts of data. This only works if all your text files have the same columns. This works with .txt and .csv files."
[YouTube Link](https://youtube.com/watch?v=nC7Bzb35e68) 2017-03-01T16:00Z 59.4K followers, 188.1K engagements
"How to create a table of contents in excel with hyperlinks Using Power Query to make a list of sheets in an excel spreadsheet. =HYPERLINK("#'"&@Name&"'A1"@Name) --------------------------------------------------------------------------------- #exceltips #exceltutorials #excelformulas SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] Beta Channel Version [----] --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - How to make hyperlinks to multiple files in excel https://youtu.be/XZSDTxTVjtc table of contents in excel"
[YouTube Link](https://youtube.com/watch?v=oZXuS8yeKZo) 2021-02-17T14:00Z 59.4K followers, 85.8K engagements
"TEXTSPLIT in Excel Using the TEXTSPLIT function in Excel to split text by a delimiter textsplit in excel excel textsplit textsplit formula textsplit function text split in excel split text using formula in excel text split formula in excel textsplit function in excel textsplit formula excel split text by delimiter text split delimiter textsplit in excel excel textsplit textsplit formula textsplit function text split in excel split text using formula in excel text split formula in excel textsplit function in excel textsplit formula excel split text by delimiter text split delimiter"
[YouTube Link](https://youtube.com/watch?v=tGAINdrrjPs) 2023-07-17T13:00Z 59.4K followers, 341K engagements
"How to rename multiple files at once using Excel (Windows) Change file names in Windows Command Prompt: ren "old filename.ext" "new filename.ext" Use Excel to make multiple copies of this code then paste it back into Command Prompt. --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - How to rename multiple files in Windows https://youtu.be/I9ffWZ_Bt6 - List of filenames from folder into Excel (Windows) https://youtu.be/771XysaD1DU microsoft excel windows command prompt rename files rename files in windows rename files"
[YouTube Link](https://youtube.com/watch?v=znhqGrF4gVQ) 2021-01-13T14:00Z 59.4K followers, 463.4K engagements
"Delete notes from all slides in powerpoint File - Info - Check for Issues - Inspect Document - Presentation Notes - Inspect - Remove All powerpoint delete notes powerpoint remove notes slide notes presentation notes all notes at once speaker notes notes from all slides in one go remove all notes presenter notes get rid of delete notes multiple slides powerpoint delete notes powerpoint remove notes slide notes presentation notes all notes at once speaker notes notes from all slides in one go remove all notes presenter notes get rid of delete notes multiple slides"
[YouTube Link](https://youtube.com/watch?v=97uIcRpBEl8) 2026-02-11T14:00Z 59.4K followers, [--] engagements
"IMPORTTEXT & IMPORTCSV functions in excel Example 1: one file with dropdown list =IMPORTTEXT(A2&A3-2) Example 2: from a webpage =IMPORTTEXT("https://gml.noaa.gov/aftp/data/trace_gases/co2/flask/surface/txt/co2_mlo_surface-flask_1_ccgg_month.txt" 049132054) Same link further back: https://gml.noaa.gov/aftp/data/trace_gases/co2/flask/surface/txt/ Example 3: multiple files =CHOOSECOLS(VSTACK(IMPORTTEXT(A1)IMPORTTEXT(A21)IMPORTTEXT(A31)IMPORTTEXT(A41)IMPORTTEXT(A51)IMPORTTEXT(A61)IMPORTTEXT(A71)IMPORTTEXT(A81))2347) importtext importext importcsv excel import csv import text import text files"
[YouTube Link](https://youtube.com/watch?v=XofpiQQJLas) 2026-01-20T19:00Z 59.4K followers, [---] engagements
"Get values to repeat in Excel excel repeat values repeat cells repeat values in excel repeating values repeat values excel excel repeating values repeating values formula excel repeat values repeat cells repeat values in excel repeating values repeat values excel excel repeating values repeating values formula"
[YouTube Link](https://youtube.com/watch?v=n1FlFZUf-G0) 2025-12-22T14:01Z 59.4K followers, [---] engagements
"Bold start of words in Microsoft Word (Bionic Reading) Sub BoldStart() For Each wd In ActiveDocument.Range.Words For i = [--] To Int((Len(wd) + 1) / 2) wd.Characters(i).Font.Bold = True Next i Next wd End Sub bionic reading microsoft word microsoft word vba microsoft word macro bold first half of words bold start of every word word bold start vba first letters bold ms word first letters bold bold the start of words first letter bold first word bold bionic reading microsoft word microsoft word vba microsoft word macro bold first half of words bold start of every word word bold start vba first"
[YouTube Link](https://youtube.com/watch?v=ZqeYS653TgA) 2025-12-17T14:01Z 59.4K followers, [---] engagements
"GROUPBY in Excel GROUPBY GROUPBY in excel excel GROUPBY GROUPBY excel groupby function groupby formula groupby formula in excel GROUPBY GROUPBY in excel excel GROUPBY GROUPBY excel groupby function groupby formula groupby formula in excel"
[YouTube Link](https://youtube.com/watch?v=fYkd_NTxn2E) 2025-12-15T14:01Z 59.4K followers, [----] engagements
"Copy text from pdf into word without splitting across multiple lines Use Find and Replace to replace all paragraph marks (p) with spaces to get rid of line breaks in Microsoft Word fix formatting when copying text from pdf into word microsoft word remove paragraph marks remove line breaks change paragraph marks to spaces find and replace stop text splitting across lines from multiple lines to one paragraph coping from pdf to word fix formatting when copying text from pdf into word microsoft word remove paragraph marks remove line breaks change paragraph marks to spaces find and replace stop"
[YouTube Link](https://youtube.com/watch?v=tRShUescrXY) 2025-12-10T14:01Z 59.4K followers, [---] engagements
"Make formulas with discontinuous cell references in excel excel discontinous cell references split cell references cell references without a pattern interrupted cell references formulas with weird cell references excel discontinous cell references split cell references cell references without a pattern interrupted cell references formulas with weird cell references"
[YouTube Link](https://youtube.com/watch?v=pZmN2DBa-38) 2025-12-08T14:01Z 59.4K followers, [----] engagements
"Calculate current value from depreciation rate and original value in excel =E13*(1-$B$9/100) =B7*(1-B9/100)(YEAR(TODAY())-B8) =B7*POWER(1-B9/100YEAR(TODAY())-B8) =B7-VDB(B701000YEAR(TODAY())-B8B9TRUE) depreciation rate salvage value present value future value excel depreciation rate salvage value present value future value excel"
[YouTube Link](https://youtube.com/watch?v=6aF_V2SvR3Y) 2025-12-03T14:00Z 59.4K followers, [---] engagements
"Change all formulas to absolute cell references in Excel absolute cell references cell references with dollar signs formulas all absolute all formulas absolute multiple formulas have absolute cell references excel multiple formulas absolute all cell references absolute multiple cell references absolute absolute cell references cell references with dollar signs formulas all absolute all formulas absolute multiple formulas have absolute cell references excel multiple formulas absolute all cell references absolute multiple cell references absolute"
[YouTube Link](https://youtube.com/watch?v=-5CBsoYjZIw) 2025-12-01T14:00Z 59.4K followers, [----] engagements
"Get all the factors of a number in excel =LET(numH1ARRAYTOTEXT(FILTER(SEQUENCE(num)MOD(numSEQUENCE(num))=0))) factors excel prime number excel excel prime number excel factors all factors excel factors in excel get factors in excel excel all factors number factors factors of numbers factors of a number factors excel prime number excel excel prime number excel factors all factors excel factors in excel get factors in excel excel all factors number factors factors of numbers factors of a number"
[YouTube Link](https://youtube.com/watch?v=6q-r1rIAPEU) 2025-11-26T14:00Z 59.4K followers, [---] engagements
"Get ID number using REGEXEXTRACT in Excel =REGEXEXTRACT(C2"wd4") REGEXEXTRACT excel REGEXEXTRACT excel excel regexextract regexextract in excel REGEXEXTRACT formula example of REGEXEXTRACT REGEXEXTRACT example REGEX excel excel regex regex in excel regex formula in excel REGEXEXTRACT function REGEXEXTRACT excel REGEXEXTRACT excel excel regexextract regexextract in excel REGEXEXTRACT formula example of REGEXEXTRACT REGEXEXTRACT example REGEX excel excel regex regex in excel regex formula in excel REGEXEXTRACT function"
[YouTube Link](https://youtube.com/watch?v=tKwSLuPRUm4) 2025-11-24T14:01Z 59.4K followers, [----] engagements
"Remove duplicate values in Excel remove duplicates excel remove duplicates in excel get unique values excel remote duplicates excel data tools remove duplicates excel remove duplicates in excel get unique values excel remote duplicates excel data tools"
[YouTube Link](https://youtube.com/watch?v=5ANCyslVELY) 2025-11-17T14:00Z 59.4K followers, 11.5K engagements
"Find numbers missing from a sequence in excel =LET(rangeA2:A44UNIQUE(VSTACK(rangeSEQUENCE(MAX(range)-MIN(range)+1MIN(range)))TRUE)) =LAMBDA(rangeUNIQUE(VSTACK(rangeSEQUENCE(MAX(range)-MIN(range)+1MIN(range)))TRUE))(A2:A44) missing numbers excel find missing numbers missing values in a sequence missing from a sequence missing numbers in a sequence missing numbers excel find missing numbers missing values in a sequence missing from a sequence missing numbers in a sequence"
[YouTube Link](https://youtube.com/watch?v=UxhCXJplcvo) 2025-11-12T14:00Z 59.4K followers, [----] engagements
"UNIQUE in Excel UNIQUE in excel excel UNIQUE unique formula unique function remove duplicates unique formula in excel unique function in excel remove duplicates with formula excel UNIQUE in excel excel UNIQUE unique formula unique function remove duplicates unique formula in excel unique function in excel remove duplicates with formula excel"
[YouTube Link](https://youtube.com/watch?v=VFPWRfDbYso) 2025-11-10T14:01Z 59.4K followers, [----] engagements
"Sequential numbers with gaps across columns in excel =IF(Q5=""""MAX(N$5:N$16P$4:P4)+1) excel sequences excel sequences across columns number sequences in excel sequences with gaps sequential numbers in excel excel sequential numbers sequential numbers with gaps sequential numbers multiple columns excel sequences excel sequences across columns number sequences in excel sequences with gaps sequential numbers in excel excel sequential numbers sequential numbers with gaps sequential numbers multiple columns"
[YouTube Link](https://youtube.com/watch?v=i8b5aiHqsTg) 2025-11-05T14:01Z 59.4K followers, [---] engagements
"Keyboard shortcut to move columns & rows in Excel excel move columns rearrange columns reorder columns columns in excel reorder rows in excel insert rows excel move columns rearrange columns reorder columns columns in excel reorder rows in excel insert rows"
[YouTube Link](https://youtube.com/watch?v=ce9pmRisN34) 2025-11-03T14:01Z 59.4K followers, [----] engagements
"Tricks for number patterns in formulas in excel =MOD(SEQUENCE(12101)3)*2+2 =INT(SEQUENCE(12111/3)) =CHOOSEROWS(I1:K132;2;5;5;8;8;11;11) =TOCOL(SEQUENCE(5)&EXPAND(""13"")1) =LET(aINT(SEQUENCE(61/3))VSTACK(aaa)) =(INT(SEQUENCE(121/3))*3-2)+SEQUENCE(30) =MAKEARRAY(1010LAMBDA(rcr*c))"
[YouTube Link](https://youtube.com/watch?v=AiMw_gIcpI0) 2025-10-30T15:00Z 59.4K followers, [---] engagements
"SEQUENCE in Excel sequence in excel SEQUENCE excel excel SEQUENCE sequence function sequence formula sequence formula in excel excel sequence in excel SEQUENCE excel excel SEQUENCE sequence function sequence formula sequence formula in excel excel"
[YouTube Link](https://youtube.com/watch?v=g1LCNOy9mm4) 2025-10-27T14:01Z 59.4K followers, [----] engagements
"How to unpivot multiple columns in excel =INDEX(G5:R9G13:G32I13:K32) =TOCOL(UNIQUE(G4:R41)&S5:S91) excel excel tutorial unpivot multiple columns unpivot table rearrange table rearrange data excel excel tutorial unpivot multiple columns unpivot table rearrange table rearrange data"
[YouTube Link](https://youtube.com/watch?v=ZLe38QYiE7w) 2025-10-22T13:01Z 59.4K followers, [---] engagements
"Get a random subgroup in Excel random group excel random group random group excel random groups select random random selection random names excel random group excel random group random group excel random groups select random random selection random names excel"
[YouTube Link](https://youtube.com/watch?v=4UJ95phCYgE) 2025-10-20T13:00Z 59.4K followers, [----] engagements
"Compare tables to find missing rows in Excel compare tables find missing rows find missing values differences between tables excel compare tables find missing rows find missing values differences between tables excel"
[YouTube Link](https://youtube.com/watch?v=jP-wDb2gEe0) 2025-10-13T13:01Z 59.4K followers, [---] engagements
"Split column on every other delimiter in power query excel power query split list power query every other delimiter split list in power query split column power query excel power query split list power query every other delimiter split list in power query split column power query"
[YouTube Link](https://youtube.com/watch?v=xrQDK8S-P0I) 2025-10-08T13:02Z 59.4K followers, [---] engagements
"CHOOSEROWS in Excel chooserows CHOOSEROWS excel chooserows formula chooserows function choose rows in excel choose rows formula in excel chooserows CHOOSEROWS excel chooserows formula chooserows function choose rows in excel choose rows formula in excel"
[YouTube Link](https://youtube.com/watch?v=pt-eNTc-TKM) 2025-10-06T13:01Z 59.4K followers, [---] engagements
"For how many decimal places are the numbers the same in excel LAMBDA =SUM((ROUNDDOWN(B1SEQUENCE(15))=ROUNDDOWN(C1SEQUENCE(15)))*1) =LAMBDA(num_1num_2SUM((ROUNDDOWN(num_1SEQUENCE(15))=ROUNDDOWN(num_2SEQUENCE(15)))*1)) excel decimal places count decimal places same to how many decimal places compare numbers how many decimal places decimal places the same excel decimal places count decimal places same to how many decimal places compare numbers how many decimal places decimal places the same"
[YouTube Link](https://youtube.com/watch?v=Y18kl3c89EM) 2025-10-01T13:01Z 59.4K followers, [---] engagements
"FILTER in Excel FILTER excel filter excel excel filter filter in excel filter function filter formula filter formula in excel FILTER excel filter excel excel filter filter in excel filter function filter formula filter formula in excel"
[YouTube Link](https://youtube.com/watch?v=71KELfWojeA) 2025-09-29T13:00Z 59.4K followers, [----] engagements
"How to calculate deming regression in excel =LET(xvaluesA2:A13yvaluesB2:B13xvarianceA16yvarianceB16 avgxAVERAGE(xvalues)avgyAVERAGE(yvalues) rSUMPRODUCT(xvalues-avgxyvalues-avgy) kxvariance/yvariance uDEVSQ(xvalues)vDEVSQ(yvalues) hk*v-u (h+SQRT(h2+4*k*r2))/(2*k*r)) deming regression deming regression excel deming regression in excel excel deming regression regressions in excel excel trend line total least squares regression linear trendline trendline including errors regression with uncertainties orthogonal regression excel deming regression deming regression excel deming regression in excel"
[YouTube Link](https://youtube.com/watch?v=Wh4j-iyuefI) 2025-09-24T13:01Z 59.4K followers, [---] engagements
"Get axis labels to be multiple colors in Excel Make some of the numbers on an axis a different color excel excel chart chart axis numbers different colors axis labels two colors axis different colors make axis numbers multiple colors axis labels different colors excel excel chart chart axis numbers different colors axis labels two colors axis different colors make axis numbers multiple colors axis labels different colors"
[YouTube Link](https://youtube.com/watch?v=bK3YaMtpaOw) 2025-09-22T13:01Z 59.4K followers, [---] engagements
"Tricks for formatting data labels in excel charts excel excel chart excel charts data labels format data labels different data labels change data labels data labels in charts data labels excel excel excel chart excel charts data labels format data labels different data labels change data labels data labels in charts data labels excel"
[YouTube Link](https://youtube.com/watch?v=aBpNIA8Qie4) 2025-09-17T13:00Z 59.4K followers, [----] engagements
"Round to the nearest [--] in Excel round nearest ten round nearest [---] round to the closest multiple of [--] excel round nearest ten round nearest [---] round to the closest multiple of [--] excel"
[YouTube Link](https://youtube.com/watch?v=wjNYWWJIDDw) 2025-09-15T13:02Z 59.4K followers, [----] engagements
"How to make a variance chart in excel Target vs Actual - Clustered Column Chart with Error Bars variance chart variance chart excel variance chart in excel excel variance chart variance charts target vs actual chart target vs actual chart excel excel red arrows green arrows bar chart with arrows red and green arrows target vs actual variance chart variance chart excel variance chart in excel excel variance chart variance charts target vs actual chart target vs actual chart excel excel red arrows green arrows bar chart with arrows red and green arrows target vs actual"
[YouTube Link](https://youtube.com/watch?v=SArLYkxl1EY) 2025-09-10T13:01Z 59.4K followers, [----] engagements
"Separate numbers and letters using REGEXEXTRACT in excel =REGEXEXTRACT(A1"pn+"1) =REGEXEXTRACT(A1"pl+"1) extract numbers extract letters separate letters and numbers separate letters separate numbers separate numbers and letters numbers from letters letters from numbers regex in excel regexextract regexextract excel excel extract numbers extract letters separate letters and numbers separate letters separate numbers separate numbers and letters numbers from letters letters from numbers regex in excel regexextract regexextract excel excel"
[YouTube Link](https://youtube.com/watch?v=0HA9YCJ4-nY) 2025-09-08T13:00Z 59.4K followers, [----] engagements
"How to make a range chart in excel Using Clustered Column Chart Temperature data: nw3weather.co.uk/wx14.php range chart excel excel temperature range chart clustered column chart column chart in excel range charts temperature chart min-max chart min max chart chart showing minimum and maximum range make bar chart without bars going to zero range chart excel excel temperature range chart clustered column chart column chart in excel range charts temperature chart min-max chart min max chart chart showing minimum and maximum range make bar chart without bars going to zero"
[YouTube Link](https://youtube.com/watch?v=XlfUS55s_Y8) 2025-09-03T13:01Z 59.4K followers, [---] engagements
"Get table to repeat x number of times in excel excel repeat table repeat range repeat range in excel repeat table in excel copy range multiple times multiple copies of range same table multiple times excel repeat table repeat range repeat range in excel repeat table in excel copy range multiple times multiple copies of range same table multiple times"
[YouTube Link](https://youtube.com/watch?v=zk-nZJ-ucW0) 2025-09-01T13:02Z 59.4K followers, [---] engagements
"How to make national emergencies chart in excel National emergencies declared by US Presidents [----] - [----] Power Query XLOOKUP COUNTIFS Stacked Bar Chart excel XLOOKUP power query data from web COUNTIFS stacked bar chart stacked bar chart excel national emergency chart national emergencies figure emergencies declared by presidents graphic number of national emergencies diagram excel XLOOKUP power query data from web COUNTIFS stacked bar chart stacked bar chart excel national emergency chart national emergencies figure emergencies declared by presidents graphic number of national emergencies"
[YouTube Link](https://youtube.com/watch?v=BRpQ-WwWc_Y) 2025-08-27T13:00Z 59.4K followers, [---] engagements
"How to make subplots using pandas in python import pandas as pd import matplotlib.pyplot as plt df = pd.read_excel('C:python scriptsVT-24-25.xlsx''Sheet1'index_col=0) df.plot(subplots=Truefigsize=(3218)layout=(105)sharex=Truemarker='o'color='red') plt.subplots_adjust(hspace=0) plt.show() python pandas python python pandas subplots in python panel chart in python panel chart subplots subplots python subplots pandas python pandas python python pandas subplots in python panel chart in python panel chart subplots subplots python subplots pandas"
[YouTube Link](https://youtube.com/watch?v=6DMxyB4XIlE) 2025-08-20T13:00Z 59.4K followers, [---] engagements
"How to line up tables in excel using python Python is only available in some versions of excel pd.merge(xl("A1:B13" headers=True)xl("D1:E10" headers=True)how='outer').fillna('unknown') pd.concat(xl("A1:E5" headers=True)xl("A7:E10" headers=True)ignore_index=True).fillna('') excel python python in excel line up tables line up columns combine tables together combine tables join tables tables in excel columns in excel excel python python in excel line up tables line up columns combine tables together combine tables join tables tables in excel columns in excel"
[YouTube Link](https://youtube.com/watch?v=-iPb9JVJA-k) 2025-08-13T13:00Z 59.4K followers, [---] engagements
"How to get axes to overlap using matplotlib in python import matplotlib.pyplot as plt plt.rc('axes'facecolor='none') fig = plt.figure() ax1 = fig.add_axes(0010.4) #left bottom width height ax2 = fig.add_axes(00.310.4) ax3 = fig.add_axes(00.610.4) x = [----] y_1 = [----] y_2 = [--------] y_3 = [------------] ax1.plot(xy_1color='red') ax2.plot(xy_2color='blue') ax3.plot(xy_3color='green') ax1.spines'top'.set_visible(False) ax2.spines'top'.set_visible(False) ax2.spines'bottom'.set_visible(False) ax3.spines'bottom'.set_visible(False) ax3.xaxis.set_ticks_position('top')"
[YouTube Link](https://youtube.com/watch?v=vuTPeLmNSIU) 2025-08-06T13:01Z 59.4K followers, [---] engagements
"How to line up the columns from two tables in excel =XLOOKUP(B12$B$1:$I$1$B$2:$I$5"") =SORT(UNIQUE(HSTACK(B1:I1B7:H7)1)1) line up columns excel combine tables join tables in excel combine multiple tables fix misaligned columns align columns in excel align columns align two tables align two ranges of data merge tables merge tables by matching column headers merge two tables combine two tables excel based on column headings line up columns excel combine tables join tables in excel combine multiple tables fix misaligned columns align columns in excel align columns align two tables align two"
[YouTube Link](https://youtube.com/watch?v=H9eEgRTFlYE) 2025-07-30T13:00Z 59.4K followers, [---] engagements
"How to find the last number in a column in excel =TAKE(B.:.B-1) =LOOKUP(1E+300F:F) =XLOOKUP(TRUEJ.:.J less than symbol 10J.:.J-1) last number in column last number excel last number column excel last number in excel last value in column find last value last non-empty cell get last number excel last number in column last number excel last number column excel last number in excel last value in column find last value last non-empty cell get last number excel"
[YouTube Link](https://youtube.com/watch?v=2vwjtqcLnHY) 2025-07-23T13:00Z 59.4K followers, [---] engagements
"How to make a population pyramid in excel World population data: https://www.populationpyramid.net/world/2025/ excel microsoft excel make population pyramid population pyramid butterfly chart population chart tornado chart diverging bar chart butterfly chart excel tornado chart excel diverging bar charts make a butterfly chart population pyramid in excel butterfly chart in excel make a tornado chart population pyramids population pyramid chart population pyramid charts pryamid excel microsoft excel make population pyramid population pyramid butterfly chart population chart tornado chart"
[YouTube Link](https://youtube.com/watch?v=hmg54CoaiW4) 2025-07-09T13:01Z 59.4K followers, [----] engagements
"My YouTube Analytics [----] Views subscribers revenue impressions click-through-rate RMP etc. youtube analytics youtube studio youtube analytics small channel youtube analytics educational channel how much money do small youtube channels make youtube money youtube make money youtube how much money youtube studio [----] youtube analytics [----] how much money do youtube channels make youtube channel analytics youtube RPM youtube analytics youtube studio youtube analytics small channel youtube analytics educational channel how much money do small youtube channels make youtube money youtube make money"
[YouTube Link](https://youtube.com/watch?v=SoK_RmthxfU) 2025-07-02T13:00Z 59.4K followers, [---] engagements
"How to use quickchart.io to make charts that aren't available in excel =IMAGE(B7&B8) /chartv=3&c= type: 'funnel' data: labels: 'Leads' 'Emails' 'Calls' 'Quotes''Sales' datasets: data: [---] [----] [----] [----] [----] backgroundColor: 'rgb(139 [--] 0)' 'rgb(205 [--] 92)' 'rgb(240 [---] 128)' 'rgb(250 [---] 114)' 'rgb(255 [---] 122)' options: indexAxis: 'x' quickchart.io quickchart funnel chart excel microsoft excel funnel chart in excel IMAGE function IMAGE formula IMAGE function in excel quickchart.io quickchart funnel chart excel microsoft excel funnel chart in excel IMAGE function IMAGE formula IMAGE"
[YouTube Link](https://youtube.com/watch?v=ww_rclhbDjQ) 2025-06-25T13:01Z 59.4K followers, [---] engagements
"Analyzing data in excel example XLOOKUP AVERAGEIF TEXT FILTER =IF(B3=B2D2D2+1) =XLOOKUP(D2$J$2#$P$2:$P$14) =IF(ISEVEN(D2)F2NA()) =IF(ISODD(D2)F2NA()) =UNIQUE(D2:D10281) =XLOOKUP($J$2#$D$2:$D$10281$B$2:$B$10281) =TEXT(L2"mmm yyyy")&" - "&TEXT(M2"mmm yyyy") =COUNTIF($D$2:$D$10281J2) =AVERAGEIF($D$2:$D$10281J2$C$2:$C$10281) =STDEV.P(FILTER($C$2:$C$10281$D$2:$D$10281=J2)) analyze data excel analyse data in excel xlookup averageif excel formulas excel functions using excel for science analyze data excel analyse data in excel xlookup averageif excel formulas excel functions using excel for science"
[YouTube Link](https://youtube.com/watch?v=wwZvO42NKl0) 2025-06-18T13:01Z 59.4K followers, [---] engagements
"Extracting data from a table REGEXTEST FILTER COUNTIF GROUPBY =TEXTBEFORE(A2"_") =REGEXTEST(C2"ALMAALSX") =UNIQUE(FILTER(B1:C3223D1:D3223)) =COUNTIF($F$2:$F$390F2) =FILTER(F1#H1:H390 greater than 1) =GROUPBY(J2:J75K2:K75ARRAYTOTEXT0) arrange data regextest groupby rearrange data format data excel microsoft excel filter formula textbefore formula unique formula regex formulas in excel regex in excel regex excel groupby function groupby excel extract data arrange data regextest groupby rearrange data format data excel microsoft excel filter formula textbefore formula unique formula regex"
[YouTube Link](https://youtube.com/watch?v=DfB0od0YCjM) 2025-06-11T13:00Z 59.4K followers, [---] engagements
"Reformatting my dataset in excel (for the ICOS Portal) =TEXT(J2"yyyy-mm-ddThh:mm:ssZ") =YEAR(J2) =MONTH(J2) =DAY(J2) =HOUR(J2) =MINUTE(J2) =LET(dateJ2yYEAR(date)hHOUR(date)minMINUTE(date)secSECOND(date)fstDATE(y11)doyINT(date)-fstsoy(doy*86400)+(h*3600)+(min*60)+secleapDATE(y1231)-fst+1fracsoy/(leap*86400)y+frac) =IFERROR(ROUND(J21)"") reorganise data rearrange table organize dataset reformatting dataset format dataset formatting data excel microsoft excel office [---] reorganise data rearrange table organize dataset reformatting dataset format dataset formatting data excel microsoft excel"
[YouTube Link](https://youtube.com/watch?v=PHYRRA_qv_4) 2025-06-04T13:00Z 59.4K followers, [---] engagements
"Check if multiple cells are equal in excel EXACT formula for more than two cells =AND(EXACT(A3A3:D3)) =AND(A3=A3:D3) =COUNTIF(A3:D3A3)=4 =COUNTA(UNIQUE(A3:D31))=1 =MIN(A3:D3)=MAX(A3:D3) compare values multiple cells equal multiple values same EXACT formula more than two values same number excel compare multiple values in excel EXACT more than two are all cells equal is content in each cell the same every cell the same multiple values in same compare values multiple cells equal multiple values same EXACT formula more than two values same number excel compare multiple values in excel EXACT more"
[YouTube Link](https://youtube.com/watch?v=Oqy9_Xz7FYM) 2025-05-21T13:00Z 59.4K followers, [----] engagements
"Make first letter in a cell into a capital letter in excel 0:00 Method [--] - Word 0:41 Method [--] - Flash Fill 1:30 Method [--] - REPLACE 2:48 Method [--] - REGEXREPLACE =REPLACE(A211UPPER(LEFT(A21))) =REGEXREPLACE(A2"w""u$0") capitalize first letter upper case excel regex in excel change case in excel change case of only first letter make only first letter capital first letter capital capital letter excel make only one word upper case excel first letter in cell capital excel uppercase excel capitalise first letter excel capitalize first letter upper case excel regex in excel change case in excel"
[YouTube Link](https://youtube.com/watch?v=o0fDfHxCxp8) 2025-05-14T13:01Z 59.4K followers, [----] engagements
"Trick to quickly make a long nested formula in excel =TEXTJOIN(""TRUE"=""SUBSTITUTE(""SUBSTITUTE(""SUBSTITUTE(""SUBSTITUTE(""SUBSTITUTE(""SUBSTITUTE(""A2:A17""D3""E3";")D4""E4";")D5""E5";")D6""E6";")D7""E7";")D8""E8)") nested formula trick trick for nested formulas long formula how to quickly make long formulas how to easily make nested formulas quick nested formula excel make nested formula in excel trick for making long formula excel making nested formula nested formula nested formula excel nested formula in excel how to make nested formula in excel nested formula trick trick for nested"
[YouTube Link](https://youtube.com/watch?v=XZrOde3pzgU) 2025-05-07T13:00Z 59.4K followers, [----] engagements
"How to find and replace multiple words in excel with power query =List.Accumulate(Table.ToRecords(TableFindReplace) #"Changed Type" (TableToChangeTableFindReplace) = LESS THAN SYMBOL Table.ReplaceValue(TableToChangeTableFindReplaceOld WordsTableFindReplaceNew WordsReplacer.ReplaceText"Column Name")) substitute multiple words replace multiple words find and replace multiple words at once excel replace multiple pieces of text substitute multiple characters bulk replace replace multiple words in one go replace multiple words in excel find and replace power query find & replace words with power"
[YouTube Link](https://youtube.com/watch?v=vI-2sZ515wU) 2025-04-30T13:01Z 59.4K followers, [---] engagements
"Find and Replace multiple words using VBA in excel Sub FindReplace() For r = [--] To [--] Range("A2:A7").Replace Cells(r 3) Cells(r 4) Next End Sub find replace vba substitute multiple words replace multiple words find and replace multiple words at once excel replace multiple pieces of text substitute multiple characters bulk replace replace multiple words in one go replace multiple words in excel vba macro find replace marco find and replace vba find and replace in vba find and replace with vba find & replace using macro find & replace with macro find replace vba substitute multiple words replace"
[YouTube Link](https://youtube.com/watch?v=Ef_2VOYFLAE) 2025-04-23T13:00Z 59.4K followers, [----] engagements
Limited data mode. Full metrics available with subscription: lunarcrush.com/pricing
@karinaadcock Karina Adcock
Karina Adcock posts on YouTube about how to, microsoft, data, how to make the most. They currently have [------] followers and [---] posts still getting attention that total [-----] engagements in the last [--] hours.
Engagements: [-----] #
- [--] Week [------] -2.30%
- [--] Month [-------] +17%
- [--] Months [---------] -7%
- [--] Year [---------] +2,232%
Mentions: [--] #
- [--] Months [--] -5.30%
- [--] Year [--] +481%
Followers: [------] #
- [--] Week [------] +0.17%
- [--] Month [------] +0.68%
- [--] Months [------] +5.90%
- [--] Year [------] +16%
CreatorRank: [-------] #
Social Influence
Social category influence technology brands stocks social networks finance
Social topic influence how to, microsoft #556, data, how to make #832, excel, bar, min, list, lambda, symbol
Top accounts mentioned or mentioned by @namea1 @name
Top assets mentioned Microsoft Corp. (MSFT) Alphabet Inc Class A (GOOGL) Alpha Technology Group Limited (ATGL)
Top Social Posts
Top posts by engagements in the last [--] hours
"Linear Interpolation in Excel Fill in Missing Values =IFERROR(FORECAST.LINEAR(A2C2:D2E2:F2)NA()) linear interpolation linear interpolation"
YouTube Link 2022-11-16T14:00Z 59.4K followers, 87.5K engagements
"How to make chapters sections and subsections in word In this video I show you how to make chapters sections and subsections using the heading styles in word and format them the way you want. Useful to know for making a thesis/ dissertation in word. After making the headings you can use the navigation pane to move to different places in the document which is useful if you have a very long document. I wouldn't normally number the abstract but this is just an example of how to make the sections not necessarily how they should be numbered or formatted."
YouTube Link 2018-01-17T17:52Z 59.4K followers, 1.4M engagements
"How to make table captions and a list of tables in word In this video I show you how to make table captions and a list of tables in word. You firstly need to add captions and change the label option to 'Table'. Then you need to go to the references tab and select 'insert table of figures' and make sure 'Table' is selected. The tables will then be automatically renumbered and the list of tables can then be updated is the captions or page numbers change. This is a very useful feature for writing a thesis/ dissertation."
YouTube Link 2018-02-21T16:00Z 59.4K followers, 1.3M engagements
"Copy Chart Formatting in Excel #shorts copy chart format excel format painter for chart apply same format on the chart copy chart format excel format painter for chart apply same format on the chart"
YouTube Link 2023-02-27T14:00Z 59.4K followers, 103.5K engagements
"TRIM function in Excel How to remove extra spaces from text in excel #exceltips #exceltutorials trim function trim formula trim function excel trim formula excel trim function in excel trim formula in excel excel trim formula excel trim function remove extra spaces in excel excel remove extra spaces remove extra spaces from text in excel formula to remove extra spaces in text excel microsoft excel excel functions excel formulas excel tutorial excel short short excel trim excel short trim excel use trim function in excel how to remove extra spaces trim function trim formula trim function excel"
YouTube Link 2023-08-14T13:00Z 59.4K followers, 153.6K engagements
"How to make a table of contents in word In this video I show you how to make an automatic table of contents in word. You firstly need to change the 'normal' text style so the size and font of the table of contents will be the same as the rest of the text. Then you need to go to references and select table of contents. An automatic table of contents is then created using the heading styles and the contents can be reformatted. The table of contents can be updated if the number of pages or the sections change. This is a very useful feature for writing a thesis/ dissertation. Also if you press"
YouTube Link 2018-01-24T18:07Z 59.4K followers, 3.7M engagements
"Copy folder structure without files in Windows Windows Command Prompt xcopy "source/folder/path" "destination/folder/path" /t /e copy folder structure command prompt windows command prompt cmd windows copy folders without files copy just folder structure folder structure no files copy folders but no files copy folders but not files folder structure but not files copy folder structure with no files xcopy copy folders with command prompt copy just folders using command prompt duplicate folder structure copy folder structure command prompt windows command prompt cmd windows copy folders without"
YouTube Link 2023-03-22T14:00Z 59.4K followers, 70.8K engagements
"How to make an academic poster in powerpoint In this video I show you a simple [--] step process for making an academic poster for a conference specifically in PowerPoint. Step [--] - 0:07 SIZE Step [--] - 1:21 CONTENT & LAYOUT Step [--] - 2:47 EXTRA CONTENT Step [--] - 6:10 IMAGES Step [--] - 7:17 FONT Step [--] - 9:18 COLORS Step [--] - 10:44 LINE UP Step [--] - 12:31 PDF ------------------------------------------------------------------------- #powerpointtutorials #powerpointtipsandtricks SUBSCRIBE: https://goo.gl/c46YPs VIDEO INFO: The poster is related to my PhD research."
YouTube Link 2018-11-28T15:00Z 59.4K followers, 2.7M engagements
"Sequential numbers with gaps across columns in excel =IF(Q5=""""MAX(N$5:N$16P$4:P4)+1) excel sequences excel sequences across columns number sequences in excel sequences with gaps sequential numbers in excel excel sequential numbers sequential numbers with gaps sequential numbers multiple columns excel sequences excel sequences across columns number sequences in excel sequences with gaps sequential numbers in excel excel sequential numbers sequential numbers with gaps sequential numbers multiple columns"
YouTube Link 2025-11-05T14:01Z 59.4K followers, [---] engagements
"How to make a word cloud in microsoft word Use a free add-in called Pro Word Cloud to make a word cloud in word. The size of the word shows how often the word appears in the text. The most common words have the largest font size. -------------------------------------------------------------------------------- #msword #microsoftword #mswordtutorials SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] The writing is related to my PhD research --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO"
YouTube Link 2019-07-10T13:00Z 59.4K followers, 291K engagements
"IMPORTTEXT & IMPORTCSV functions in excel Example 1: one file with dropdown list =IMPORTTEXT(A2&A3-2) Example 2: from a webpage =IMPORTTEXT("https://gml.noaa.gov/aftp/data/trace_gases/co2/flask/surface/txt/co2_mlo_surface-flask_1_ccgg_month.txt" 049132054) Same link further back: https://gml.noaa.gov/aftp/data/trace_gases/co2/flask/surface/txt/ Example 3: multiple files =CHOOSECOLS(VSTACK(IMPORTTEXT(A1)IMPORTTEXT(A21)IMPORTTEXT(A31)IMPORTTEXT(A41)IMPORTTEXT(A51)IMPORTTEXT(A61)IMPORTTEXT(A71)IMPORTTEXT(A81))2347) importtext importext importcsv excel import csv import text import text files"
YouTube Link 2026-01-20T19:00Z 59.4K followers, [---] engagements
"How to make a CALENDAR formula in excel LAMBDA =LAMBDA(dateVSTACK(HSTACK(TEXT(date"mmmm")YEAR(date)"""""""""") "Mon""Tue""Wed""Thu""Fri""Sat""Sun" LET(firstEOMONTH(date-1)+1 seqSEQUENCE(67first-WEEKDAY(first3)1) IF(MONTH(seq)=MONTH(date)TEXT(seq"d")""))))(B2)"
YouTube Link 2024-05-01T13:00Z 59.2K followers, [----] engagements
"Using IMAGE to make a chart with different sized shapes in excel The Solar System: Planet Sizes =IMAGE("https://upload.wikimedia.org/wikipedia/commons/d/d5/Rond_bleu_ciel.png"3A4/100) https://science.nasa.gov/resource/solar-system-sizes/"
YouTube Link 2024-11-27T14:00Z 59.2K followers, [---] engagements
"Use AutoCorrect to save formulas in Excel Add formulas to AutoCorrect spell check in Excel so they can be saved and used in different workbooks =LET(dateA1DATEDIF(dateTODAY()"y")&" years "&DATEDIF(dateTODAY()"ym")&" months "&DATEDIF(dateTODAY()"md")&" days") =LET(dateINDIRECT(ADDRESS(ROW()COLUMN()-1))DATEDIF(dateTODAY()"y")&" years "&DATEDIF(dateTODAY()"ym")&" months "&DATEDIF(dateTODAY()"md")&" days") ="Grade""Mark";"A"70;"B"60;"C"50;"D"40 (Can't have less than or greater than symbols in youtube description)"
YouTube Link 2023-04-19T13:00Z 59.2K followers, [----] engagements
"How to reorder parts of a filename using Windows Powershell Get-ChildItem Rename-Item -NewName ($.basename.split('')10 -join '') + $.Extension"
YouTube Link 2024-09-25T13:00Z 55.8K followers, [---] engagements
"Average with Errors in Excel #shorts =AGGREGATE(16A1:A10)"
YouTube Link 2023-02-13T14:00Z 54.3K followers, [----] engagements
"How to line up tables in excel using python Python is only available in some versions of excel pd.merge(xl("A1:B13" headers=True)xl("D1:E10" headers=True)how='outer').fillna('unknown') pd.concat(xl("A1:E5" headers=True)xl("A7:E10" headers=True)ignore_index=True).fillna('') excel python python in excel line up tables line up columns combine tables together combine tables join tables tables in excel columns in excel excel python python in excel line up tables line up columns combine tables together combine tables join tables tables in excel columns in excel"
YouTube Link 2025-08-13T13:00Z 59.4K followers, [---] engagements
"How to find the last number in a column in excel =TAKE(B.:.B-1) =LOOKUP(1E+300F:F) =XLOOKUP(TRUEJ.:.J less than symbol 10J.:.J-1) last number in column last number excel last number column excel last number in excel last value in column find last value last non-empty cell get last number excel last number in column last number excel last number column excel last number in excel last value in column find last value last non-empty cell get last number excel"
YouTube Link 2025-07-23T13:00Z 59.4K followers, [---] engagements
"How to quickly make multiple charts in excel In this video I show you how to copy the same chart multiple times and then change the cell references it is linked to in order to make lots of similar charts. -------------------------------------------------------------------------------- #exceltips #exceltutorials #excelcharts SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] These data are related to my PhD research --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - How to make panel"
YouTube Link 2019-05-29T13:00Z 57.4K followers, 138.9K engagements
"How to make a step chart in excel Quick manual method. Make two copies of the same values. Delete the first date and the last number from one set of values and line them up. Then plot the whole table as a line chart to make a step chart. Note: If this doesn't work for you try changing the x-axis options from text to date. --------------------------------------------------------------------------------- #exceltips #exceltutorials #excelcharts SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] Beta Channel Version 2103"
YouTube Link 2021-03-31T12:00Z 55.8K followers, 57.7K engagements
"How to make a dynamic heat map in excel - dynamic array formulas How to show ozone concentrations for different months of the year. Using excels new FILTER formula and a data validation drop down list to make it dynamic. Then using conditional formatting to make the heat map. Microsoft excel recently introduced dynamic array formulas including the FILTER formula. They are currently only available to a random selection of people on the Office Insider Office [---] program or on google sheets. --------------------------------------------------------------------------------- #exceltipsandtricks"
YouTube Link 2018-10-31T15:00Z 52.3K followers, [----] engagements
"How to make subplots using pandas in python import pandas as pd import matplotlib.pyplot as plt df = pd.read_excel('C:python scriptsVT-24-25.xlsx''Sheet1'index_col=0) df.plot(subplots=Truefigsize=(3218)layout=(105)sharex=Truemarker='o'color='red') plt.subplots_adjust(hspace=0) plt.show() python pandas python python pandas subplots in python panel chart in python panel chart subplots subplots python subplots pandas python pandas python python pandas subplots in python panel chart in python panel chart subplots subplots python subplots pandas"
YouTube Link 2025-08-20T13:00Z 59.4K followers, [---] engagements
"FILTER in Excel FILTER excel filter excel excel filter filter in excel filter function filter formula filter formula in excel FILTER excel filter excel excel filter filter in excel filter function filter formula filter formula in excel"
YouTube Link 2025-09-29T13:00Z 59.4K followers, [----] engagements
"How to summarize data using power query in excel Filter files in a folder and combine then together. Average data to hours for plotting in chart"
YouTube Link 2025-03-26T14:00Z 52.5K followers, [---] engagements
"Replace multiple words in excel using REDUCE =REDUCE(A2$C$7:$C$10LAMBDA(accumulatorvalueSUBSTITUTE(accumulatorvalueOFFSET(value01))))"
YouTube Link 2025-04-16T13:00Z 53K followers, [---] engagements
"How to edit a map in powerpoint In this video I show you how to edit a vector graphic/ svg file in powerpoint using the convert to shape feature. This is a new feature in powerpoint that lets you edit pictures. In this example I take [--] maps online and change them so they look different and convey a completely different message to the original maps. These maps wouldn't work very well for showing a lot of detailed information but they would be great for infographics presentations posters etc. --------------------------------------------------------------------------------- The links I used in"
YouTube Link 2018-05-02T14:30Z 55.7K followers, 89.7K engagements
"How to make national emergencies chart in excel National emergencies declared by US Presidents [----] - [----] Power Query XLOOKUP COUNTIFS Stacked Bar Chart excel XLOOKUP power query data from web COUNTIFS stacked bar chart stacked bar chart excel national emergency chart national emergencies figure emergencies declared by presidents graphic number of national emergencies diagram excel XLOOKUP power query data from web COUNTIFS stacked bar chart stacked bar chart excel national emergency chart national emergencies figure emergencies declared by presidents graphic number of national emergencies"
YouTube Link 2025-08-27T13:00Z 59.4K followers, [---] engagements
"Extracting data from a table REGEXTEST FILTER COUNTIF GROUPBY =TEXTBEFORE(A2"_") =REGEXTEST(C2"ALMAALSX") =UNIQUE(FILTER(B1:C3223D1:D3223)) =COUNTIF($F$2:$F$390F2) =FILTER(F1#H1:H390 greater than 1) =GROUPBY(J2:J75K2:K75ARRAYTOTEXT0) arrange data regextest groupby rearrange data format data excel microsoft excel filter formula textbefore formula unique formula regex formulas in excel regex in excel regex excel groupby function groupby excel extract data arrange data regextest groupby rearrange data format data excel microsoft excel filter formula textbefore formula unique formula regex"
YouTube Link 2025-06-11T13:00Z 59.4K followers, [---] engagements
"How to make a reference list for beginners How to make a reference list without reference manager software In this video I show you an easy method for making a reference list in word. First copy and paste the full reference from google scholar. Then sort the list of references alphabetically. #referencelist #mswordtutorial #googlescholar --------------------------------------------------------------------------------- SUBSCRIBE: https://goo.gl/c46YPs --------------------------------------------------------------------------------- RELATED VIDEOS - This video is part of a playlist: Writing a"
YouTube Link 2017-01-08T11:28Z 48.1K followers, 117.3K engagements
"How to convert excel dates into decimal dates I have found three methods to convert excels dates into decimal dates where the year is represented by the whole number and the months and days are represented by everything after the decimal place as a fraction of a year. Method 1=(date/365.25)+1900 Method 2=year+(month/12)-(1/12)+(day/365.25) Method 3=YEARFRAC(date01)+1900 --------------------------------------------------------------------------------- #exceltutorials #exceltipsandtricks #excelformulas SUBSCRIBE: https://goo.gl/c46YPs VIDEO INFO: These data are related to my PhD research."
YouTube Link 2018-01-31T17:34Z 55.5K followers, 28.8K engagements
"How to line up the columns from two tables in excel =XLOOKUP(B12$B$1:$I$1$B$2:$I$5"") =SORT(UNIQUE(HSTACK(B1:I1B7:H7)1)1) line up columns excel combine tables join tables in excel combine multiple tables fix misaligned columns align columns in excel align columns align two tables align two ranges of data merge tables merge tables by matching column headers merge two tables combine two tables excel based on column headings line up columns excel combine tables join tables in excel combine multiple tables fix misaligned columns align columns in excel align columns align two tables align two"
YouTube Link 2025-07-30T13:00Z 59.4K followers, [---] engagements
"REPLACE function in Excel"
YouTube Link 2023-08-07T13:00Z 53.5K followers, 11.8K engagements
"How to make subplots using matplotlib in python import matplotlib.pyplot as plt fig ((ax1ax2)(ax3ax4)) = plt.subplots(22 figsize=(103) sharex=True sharey=True) plt.subplots_adjust(wspace=0.01hspace=0) x = [-----] y1 = [------] y2 = [------] ax1.plot(xy1) ax2.plot(xy2) ax3.plot(xy1) ax4.plot(xy2) ax1.set_title("axis1") plt.suptitle("super title") plt.show()"
YouTube Link 2023-11-15T14:00Z 53.3K followers, [----] engagements
"Check if multiple cells are equal in excel EXACT formula for more than two cells =AND(EXACT(A3A3:D3)) =AND(A3=A3:D3) =COUNTIF(A3:D3A3)=4 =COUNTA(UNIQUE(A3:D31))=1 =MIN(A3:D3)=MAX(A3:D3) compare values multiple cells equal multiple values same EXACT formula more than two values same number excel compare multiple values in excel EXACT more than two are all cells equal is content in each cell the same every cell the same multiple values in same compare values multiple cells equal multiple values same EXACT formula more than two values same number excel compare multiple values in excel EXACT more"
YouTube Link 2025-05-21T13:00Z 59.4K followers, [----] engagements
"How to get a range to repeat multiple times using a formula in excel =TOCOL(C5:C7&EXPAND(""1B2"")1) =TOCOL(IF(SEQUENCE(1B20)C5:C7)1) Microsoft Office [---] Beta Channel Version 2309"
YouTube Link 2023-08-16T13:00Z 53.9K followers, 55.9K engagements
"Simple pivot table using an excel macro In this video I show you how to use a simple macro to create a pivot table and quickly format it. Then how to slightly edit the VBA code in-order to make the macro work for a table with any number of rows so the table can have a dynamic range. ------------------------------------------------------------------------- #exceltutorials #excelmacros #excelpivottables SUBSCRIBE: https://goo.gl/c46YPs VIDEO INFO: These data are related to my PhD research. ------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY"
YouTube Link 2018-08-22T20:00Z 55.9K followers, 108.4K engagements
"Reformatting my dataset in excel (for the ICOS Portal) =TEXT(J2"yyyy-mm-ddThh:mm:ssZ") =YEAR(J2) =MONTH(J2) =DAY(J2) =HOUR(J2) =MINUTE(J2) =LET(dateJ2yYEAR(date)hHOUR(date)minMINUTE(date)secSECOND(date)fstDATE(y11)doyINT(date)-fstsoy(doy86400)+(h3600)+(min60)+secleapDATE(y1231)-fst+1fracsoy/(leap86400)y+frac) =IFERROR(ROUND(J21)"") reorganise data rearrange table organize dataset reformatting dataset format dataset formatting data excel microsoft excel office [---] reorganise data rearrange table organize dataset reformatting dataset format dataset formatting data excel microsoft excel"
YouTube Link 2025-06-04T13:00Z 59.4K followers, [---] engagements
"Excel: How many working days left in the year"
YouTube Link 2023-10-23T13:00Z 47.9K followers, [----] engagements
"How to make a variance chart in excel Target vs Actual - Clustered Column Chart with Error Bars variance chart variance chart excel variance chart in excel excel variance chart variance charts target vs actual chart target vs actual chart excel excel red arrows green arrows bar chart with arrows red and green arrows target vs actual variance chart variance chart excel variance chart in excel excel variance chart variance charts target vs actual chart target vs actual chart excel excel red arrows green arrows bar chart with arrows red and green arrows target vs actual"
YouTube Link 2025-09-10T13:01Z 59.4K followers, [----] engagements
"How to separate date and time in excel"
YouTube Link 2023-10-09T13:00Z 52.3K followers, 39.4K engagements
"How to remove every other column in excel [--] methods Delete alternative columns in excel 0:00 Method [--] - Go to Special 0:33 Method [--] - Find All 1:28 Method [--] - Sort left to right 2:55 Method [--] - CHOOSECOLS"
YouTube Link 2025-03-19T14:00Z 52.2K followers, [---] engagements
"How to rename photos to the date taken $shell = New-Object -ComObject shell.application $ukCulture = Globalization.CultureInfo'en-GB' Get-ChildItem ForEach $folder = $shell.NameSpace($.DirectoryName) $RawDate = ($folder.GetDetailsOf($folder.ParseName($.Name)12) -Replace "w /:") $datetime = DateTime::Parse($RawDate$ukCulture) $DateTaken = $datetime.ToString("yyyy-MM-dd HH.mm") Rename-Item $.FullName ($DateTaken + $.Extension) Find out what the code is for your country:"
YouTube Link 2021-01-27T14:00Z 54.2K followers, 30K engagements
"Scatter plot with third variable as color Python Matplotlib How to make and customize a color map and color bar in python Choosing Colormaps in Matplotlib: https://matplotlib.org/3.1.0/tutorials/colors/colormaps.html ------------------------------------------------------------------------------------------------------------------- import matplotlib.pyplot as plt x = [-------------] y = [-----------] colors = [--------------] plt.scatter(xy s=200 c=colors cmap=plt.cm.get_cmap("cool"5)) cbar = plt.colorbar(orientation="vertical" extend="both" pad=0.05 shrink=1 aspect=20 format="%.3f")"
YouTube Link 2021-03-03T14:00Z 47.7K followers, 37K engagements
"How to calculate deming regression in excel =LET(xvaluesA2:A13yvaluesB2:B13xvarianceA16yvarianceB16 avgxAVERAGE(xvalues)avgyAVERAGE(yvalues) rSUMPRODUCT(xvalues-avgxyvalues-avgy) kxvariance/yvariance uDEVSQ(xvalues)vDEVSQ(yvalues) hkv-u (h+SQRT(h2+4kr2))/(2k*r)) deming regression deming regression excel deming regression in excel excel deming regression regressions in excel excel trend line total least squares regression linear trendline trendline including errors regression with uncertainties orthogonal regression excel deming regression deming regression excel deming regression in excel"
YouTube Link 2025-09-24T13:01Z 59.4K followers, [---] engagements
"How to make hyperlinks to multiple files in excel =HYPERLINK() formula Links to all the files in a folder and sub-folders. Use windows command prompt to get a list of file names with their file paths. Use Text to Columns to get the file names on their own. dir/b/s/o clip --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - List of filenames from folder into Excel (Windows) https://youtu.be/771XysaD1DU"
YouTube Link 2021-02-10T14:00Z 55.7K followers, 119.8K engagements
"Trick to quickly make a long nested formula in excel =TEXTJOIN(""TRUE"=""SUBSTITUTE(""SUBSTITUTE(""SUBSTITUTE(""SUBSTITUTE(""SUBSTITUTE(""SUBSTITUTE(""A2:A17""D3""E3";")D4""E4";")D5""E5";")D6""E6";")D7""E7";")D8""E8)") nested formula trick trick for nested formulas long formula how to quickly make long formulas how to easily make nested formulas quick nested formula excel make nested formula in excel trick for making long formula excel making nested formula nested formula nested formula excel nested formula in excel how to make nested formula in excel nested formula trick trick for nested"
YouTube Link 2025-05-07T13:00Z 59.4K followers, [----] engagements
"How to make a range chart in excel Using Clustered Column Chart Temperature data: nw3weather.co.uk/wx14.php range chart excel excel temperature range chart clustered column chart column chart in excel range charts temperature chart min-max chart min max chart chart showing minimum and maximum range make bar chart without bars going to zero range chart excel excel temperature range chart clustered column chart column chart in excel range charts temperature chart min-max chart min max chart chart showing minimum and maximum range make bar chart without bars going to zero"
YouTube Link 2025-09-03T13:01Z 59.4K followers, [---] engagements
"For how many decimal places are the numbers the same in excel LAMBDA =SUM((ROUNDDOWN(B1SEQUENCE(15))=ROUNDDOWN(C1SEQUENCE(15)))*1) =LAMBDA(num_1num_2SUM((ROUNDDOWN(num_1SEQUENCE(15))=ROUNDDOWN(num_2SEQUENCE(15)))*1)) excel decimal places count decimal places same to how many decimal places compare numbers how many decimal places decimal places the same excel decimal places count decimal places same to how many decimal places compare numbers how many decimal places decimal places the same"
YouTube Link 2025-10-01T13:01Z 59.4K followers, [---] engagements
"14 NEW FORMULAS IN EXCEL [--]. TEXTSPLIT [--]. TEXTBEFORE [--]. TEXTAFTER [--]. VSTACK [--]. HSTACK [--]. TOROW [--]. TOCOL [--]. WRAPROWS [--]. WRAPCOLS [--]. TAKE [--]. DROP [--]. CHOOSEROWS [--]. CHOOSECOLS [--]. EXPAND Office insider: https://insider.office.com/en-us/ Announcement: https://techcommunity.microsoft.com/t5/excel-blog/announcing-new-text-and-array-functions/ba-p/3186066"
YouTube Link 2022-04-06T13:00Z 56.2K followers, [----] engagements
"How to get a sequence of numbers in a table in Microsoft Word Select column - Go to Home - Paragraph - Numbering - Numbering Library --------------------------------------------------------------------------------- #msword #microsoftword #mswordtutorial SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] Beta Channel Version [----] --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - Advanced Find & Replace with wildcards in Microsoft Word https://youtu.be/xeP9yyg6lF4"
YouTube Link 2021-06-09T12:00Z 56.1K followers, 135.8K engagements
"How to make cross references in word In this video I show you how to make cross references in word. Cross referencing is when you refer in the text to another place in the text. This can be a figure a table a section an equation etc. This needs to be do in academic writing to link different parts of the document together. However often while writing the number of the figure/table/section/equation can change and it can be time consuming to go back and renumber all the sections so word allows you to create dynamic cross references that will update if the number changes. The cross references in"
YouTube Link 2018-03-21T15:30Z 54.3K followers, 519.8K engagements
"Tricks for formatting data labels in excel charts excel excel chart excel charts data labels format data labels different data labels change data labels data labels in charts data labels excel excel excel chart excel charts data labels format data labels different data labels change data labels data labels in charts data labels excel"
YouTube Link 2025-09-17T13:00Z 59.4K followers, [----] engagements
"Get axis labels to be multiple colors in Excel Make some of the numbers on an axis a different color excel excel chart chart axis numbers different colors axis labels two colors axis different colors make axis numbers multiple colors axis labels different colors excel excel chart chart axis numbers different colors axis labels two colors axis different colors make axis numbers multiple colors axis labels different colors"
YouTube Link 2025-09-22T13:01Z 59.4K followers, [---] engagements
"Conditional formatting of rows based on changing values in excel =IF(C4=C3H3H3+1) =ISODD($H2)"
YouTube Link 2024-12-18T14:00Z 56K followers, [----] engagements
"How to make a map in excel with latitude and longitude co-ordinates How to use excel 3D Map to make a 2D map. In this video I plot on a map the longitude and latitude locations of places air samples were collected from in a number of different research campaigns. I use the 3D Map feature in excel to make a 2D map using a list of longitude and latitude coordinates in an excel spreadsheet and plot dots on the map. I also change the size and colour of the dots and add annotations and images to the map. I then show you how to change the map background and how to customise the map background and"
YouTube Link 2017-08-02T16:55Z 55.5K followers, 268.8K engagements
"How to make a timeline in powerpoint Use a scatter chart and text boxes connected together with lines --------------------------------------------------------------------------------- #powerpoint #powerpointtutorials SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - How to make an academic poster in powerpoint https://youtu.be/_WnhoIbfcoM - [--] second countdown timer in PowerPoint https://youtu.be/qv1D29bxyjI - How to edit a map in"
YouTube Link 2020-06-24T14:18Z 56.4K followers, 387K engagements
"How to make a parliament chart in flourish Also called an arc-dot chart. Shows the number of people from each political party as different coloured dots"
YouTube Link 2024-06-25T13:00Z 52.2K followers, [---] engagements
"How to randomly sort people into groups in excel Lambda =WRAPROWS(SORTBY(A2:A30RANDARRAY(ROWS(A2:A30)))3"")=LAMBDA(list_of_namesnum_of_groupsWRAPROWS(SORTBY(list_of_namesRANDARRAY(ROWS(list_of_names)))num_of_groups""))"
YouTube Link 2024-10-23T13:00Z 57K followers, [----] engagements
"How to make a wind rose in excel In this video I show you how to make a wind rose in excel. I have wind direction and wind speed data which I put into a pivot table and then I use a radar chart to make a wind rose. A wind rose graph is used to show the distribution of wind speed and wind direction for a time period at a particular location. --------------------------------------------------------------------------------- If you want to see how I changed my wind direction in degrees into wind direction categories watch this video: https://youtu.be/qPS-rylzKvE This video is part of a playlist:"
YouTube Link 2018-03-13T17:55Z 56.2K followers, 184.8K engagements
"How to make a population pyramid in excel World population data: https://www.populationpyramid.net/world/2025/ excel microsoft excel make population pyramid population pyramid butterfly chart population chart tornado chart diverging bar chart butterfly chart excel tornado chart excel diverging bar charts make a butterfly chart population pyramid in excel butterfly chart in excel make a tornado chart population pyramids population pyramid chart population pyramid charts pryamid excel microsoft excel make population pyramid population pyramid butterfly chart population chart tornado chart"
YouTube Link 2025-07-09T13:01Z 59.4K followers, [----] engagements
"Compare tables to find missing rows in Excel compare tables find missing rows find missing values differences between tables excel compare tables find missing rows find missing values differences between tables excel"
YouTube Link 2025-10-13T13:01Z 59.4K followers, [---] engagements
"How to conditionally format a bubble chart in excel In this video I show you how to create multiple series on a bubble graph that overlap to make it appear as if the chart has conditional formatting. In this example I use a bubble chart I made in a previous video to show smaller concentrations as a lighter blue and larger concentrations as a darker blue. --------------------------------------------------------------------------------- #exceltutorial #excelbubblechart #excelconditionalformatting SUBSCRIBE: https://goo.gl/c46YPs VIDEO INFO: These data are related to my PhD research"
YouTube Link 2017-05-17T15:35Z 55.3K followers, [----] engagements
"Make first letter in a cell into a capital letter in excel 0:00 Method [--] - Word 0:41 Method [--] - Flash Fill 1:30 Method [--] - REPLACE 2:48 Method [--] - REGEXREPLACE =REPLACE(A211UPPER(LEFT(A21))) =REGEXREPLACE(A2"w""u$0") capitalize first letter upper case excel regex in excel change case in excel change case of only first letter make only first letter capital first letter capital capital letter excel make only one word upper case excel first letter in cell capital excel uppercase excel capitalise first letter excel capitalize first letter upper case excel regex in excel change case in excel"
YouTube Link 2025-05-14T13:01Z 59.4K followers, [----] engagements
"CHOOSEROWS in Excel chooserows CHOOSEROWS excel chooserows formula chooserows function choose rows in excel choose rows formula in excel chooserows CHOOSEROWS excel chooserows formula chooserows function choose rows in excel choose rows formula in excel"
YouTube Link 2025-10-06T13:01Z 59.4K followers, [---] engagements
"Make a font of your own handwriting using Microsoft Font Maker In this video I show you how to make a custom font using Microsoft Font Maker which can be downloaded for free from the Microsoft Store. You need a touch screen laptop/ computer and stylus digital pen in order to get this to work. Then you can save the font as a *.ttf file and then use it for other applications e.g. Microsoft Word. --------------------------------------------------------------------------------- #microsoftfontmaker #customfonts #windows10 SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider"
YouTube Link 2019-01-09T15:00Z 56.6K followers, 138K engagements
"How to change NaN into null in Power Query = Table.TransformColumns(#"Changed Type" "CO2.ppm" each if Number.IsNaN(_) then null else _ type number)"
YouTube Link 2023-09-27T13:00Z 53.6K followers, [----] engagements
"How to find and replace multiple words in excel with power query =List.Accumulate(Table.ToRecords(TableFindReplace) #"Changed Type" (TableToChangeTableFindReplace) = LESS THAN SYMBOL Table.ReplaceValue(TableToChangeTableFindReplaceOld WordsTableFindReplaceNew WordsReplacer.ReplaceText"Column Name")) substitute multiple words replace multiple words find and replace multiple words at once excel replace multiple pieces of text substitute multiple characters bulk replace replace multiple words in one go replace multiple words in excel find and replace power query find & replace words with power"
YouTube Link 2025-04-30T13:01Z 59.4K followers, [---] engagements
"How to get axes to overlap using matplotlib in python import matplotlib.pyplot as plt plt.rc('axes'facecolor='none') fig = plt.figure() ax1 = fig.add_axes(0010.4) #left bottom width height ax2 = fig.add_axes(00.310.4) ax3 = fig.add_axes(00.610.4) x = [----] y_1 = [----] y_2 = [--------] y_3 = [------------] ax1.plot(xy_1color='red') ax2.plot(xy_2color='blue') ax3.plot(xy_3color='green') ax1.spines'top'.set_visible(False) ax2.spines'top'.set_visible(False) ax2.spines'bottom'.set_visible(False) ax3.spines'bottom'.set_visible(False) ax3.xaxis.set_ticks_position('top')"
YouTube Link 2025-08-06T13:01Z 59.4K followers, [---] engagements
"How to make a parliament chart in excel Also called an arc-dot chart. Shows the number of people from each political party as different coloured dots. https://policyviz.com/2019/03/21/arc-dot-chart-in-excel/"
YouTube Link 2024-06-19T13:00Z 52.3K followers, [----] engagements
"Round to the nearest [--] in Excel round nearest ten round nearest [---] round to the closest multiple of [--] excel round nearest ten round nearest [---] round to the closest multiple of [--] excel"
YouTube Link 2025-09-15T13:02Z 59.4K followers, [----] engagements
"Advanced Find & Replace with wildcards in Microsoft Word How to use wildcards in find and replace in microsoft word. --------------------------------------------------------------------------------- #msword #microsoftword #mswordtutorial SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - Find a word only if it is the first word in a paragraph in Microsoft Word https://youtu.be/6Ewc8JBClEw - This video is part of a playlist: Writing"
YouTube Link 2020-10-16T18:00Z 54.8K followers, 52K engagements
"Split column on every other delimiter in power query excel power query split list power query every other delimiter split list in power query split column power query excel power query split list power query every other delimiter split list in power query split column power query"
YouTube Link 2025-10-08T13:02Z 59.4K followers, [---] engagements
"How to split text in excel - [--] methods Flash Fill Text-to-Columns Power Query Formula Macro Google sheets UDF Separate words into multiple columns Method 1: Flash Fill 00:00 Method 2: Text-to-Columns 00:39 Method 3: Power Query 01:17 Method 4: Formula 02:40 Method 5: Macro 03:01 Method 6: Google sheets 09:44 Method 7: UDF 10:30 -------------------------------------------------------------------------------------------------------------- =TRIM(MID(SUBSTITUTE($J5" "REPT(" "LEN($J5)))(COLUMNS($J4:J4)-1)*LEN($J5)+1LEN($J5)))"
YouTube Link 2020-08-20T18:00Z 55.6K followers, 343K engagements
"Get table to repeat x number of times in excel excel repeat table repeat range repeat range in excel repeat table in excel copy range multiple times multiple copies of range same table multiple times excel repeat table repeat range repeat range in excel repeat table in excel copy range multiple times multiple copies of range same table multiple times"
YouTube Link 2025-09-01T13:02Z 59.4K followers, [---] engagements
"Change all formulas to absolute cell references in Excel absolute cell references cell references with dollar signs formulas all absolute all formulas absolute multiple formulas have absolute cell references excel multiple formulas absolute all cell references absolute multiple cell references absolute absolute cell references cell references with dollar signs formulas all absolute all formulas absolute multiple formulas have absolute cell references excel multiple formulas absolute all cell references absolute multiple cell references absolute"
YouTube Link 2025-12-01T14:00Z 59.4K followers, [----] engagements
"How to make a dot plot in excel How to create connected dot plots in excel by modifying a scatter chart. The data and the inspiration for this chart came from Our World in Data: https://ourworldindata.org/top-incomes-more-women-but-still-very-male-dominatedutm_source=OWID+Newsletter&utm_campaign=74007742ea-biweekly-digest-2021-07-02&utm_medium=email&utm_term=0_2e166c1fc1-74007742ea-523788678 --------------------------------------------------------------------------------- #exceltips #exceltutorials #excelcharts SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] Beta Channel Version 2109"
YouTube Link 2021-08-18T13:00Z 58.7K followers, 22.6K engagements
"Get a random subgroup in Excel random group excel random group random group excel random groups select random random selection random names excel random group excel random group random group excel random groups select random random selection random names excel"
YouTube Link 2025-10-20T13:00Z 59.4K followers, [----] engagements
"How to split paragraph of text across multiple rows in excel LAMBDA =LAMBDA(txtnumBYROW(WRAPROWS(TEXTSPLIT(txt" ")num"")LAMBDA(arrayTEXTJOIN(" "FALSEarray))))"
YouTube Link 2024-05-22T13:00Z 57.5K followers, [---] engagements
"How to repeat the same number multiple times in excel Multiple methods: Fill Handle Ctrl + Enter =cell reference SEQUENCE & RANDARRAY --------------------------------------------------------------------------------- #exceltips #exceltutorials #excelformulas SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] Beta Channel Version [----] --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - How to autofill numbers in excel https://youtu.be/JUFUTUC2Rxs - How to get repeating numbers in excel 123123"
YouTube Link 2021-05-26T12:00Z 59K followers, 221.5K engagements
"Remove duplicate values in Excel remove duplicates excel remove duplicates in excel get unique values excel remote duplicates excel data tools remove duplicates excel remove duplicates in excel get unique values excel remote duplicates excel data tools"
YouTube Link 2025-11-17T14:00Z 59.4K followers, 11.5K engagements
"New Excel Feature - Focus Cell Only available in some versions of excel"
YouTube Link 2024-10-27T14:00Z 58K followers, [----] engagements
"How to make comments in Adobe Acrobat Reader Sticky Notes Highlights Underline Strikethrough Replace & Insert --------------------------------------------------------------------------------- #adobereader #adobetutorial SUBSCRIBE: https://goo.gl/c46YPs This pdf document was written as part of my PhD research --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE - How to use comments and track changes in Microsoft Word https://youtu.be/qQA7UrAaN0s - This video is part of a playlist: Writing a thesis in Word"
YouTube Link 2020-06-30T13:00Z 57.5K followers, 63.8K engagements
"Calculate current value from depreciation rate and original value in excel =E13*(1-$B$9/100) =B7*(1-B9/100)(YEAR(TODAY())-B8) =B7*POWER(1-B9/100YEAR(TODAY())-B8) =B7-VDB(B701000YEAR(TODAY())-B8B9TRUE) depreciation rate salvage value present value future value excel depreciation rate salvage value present value future value excel"
YouTube Link 2025-12-03T14:00Z 59.4K followers, [---] engagements
"Get all the factors of a number in excel =LET(numH1ARRAYTOTEXT(FILTER(SEQUENCE(num)MOD(numSEQUENCE(num))=0))) factors excel prime number excel excel prime number excel factors all factors excel factors in excel get factors in excel excel all factors number factors factors of numbers factors of a number factors excel prime number excel excel prime number excel factors all factors excel factors in excel get factors in excel excel all factors number factors factors of numbers factors of a number"
YouTube Link 2025-11-26T14:00Z 59.4K followers, [---] engagements
"How to make a countdown timer in powerpoint using VBA Sub countdown() Dim future As Date future = DateAdd("n" [--] Now()) Do Until future less than symbol Now() DoEvents ActivePresentation.Slides(1).Shapes("rectangle").TextFrame.TextRange = Format(future - Now() "nn:ss") Loop End Sub The less than symbol is not allowed in a YouTube description -------------------------------------------------------------------------------- #powerpoint #powerpointtutorials SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] Beta Channel Version 2107"
YouTube Link 2021-07-21T13:00Z 59.1K followers, 18.6K engagements
"How to create a dropdown box in excel In this video I show you how to use the combo box in the developer tab in excel to make a dropdown bar that will change what is plotted in a graph to make a dynamic chart using a vlookup formula. =VLOOKUP($AD$2$AD$4:$BC$16COLUMNS($AE$1:AE$1)+1FALSE) #exceltutorial #excelformulas #excelcharts --------------------------------------------------------------------------------- SUBSCRIBE: https://goo.gl/c46YPs --------------------------------------------------------------------------------- RELATED VIDEOS - This video is part of a playlist: Daily cycles of"
YouTube Link 2017-01-04T20:32Z 59K followers, [----] engagements
"How to make cells square in excel Method 1: Make rows and columns the same number of pixels. Method 2: Change View to Page Layout and set Column Width and Row Height to the same size. --------------------------------------------------------------------------------- #exceltips #exceltutorials SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] ---------------------------------------------------------------------------------"
YouTube Link 2020-07-08T17:57Z 58.2K followers, 197.6K engagements
"Tricks for number patterns in formulas in excel =MOD(SEQUENCE(12101)3)*2+2 =INT(SEQUENCE(12111/3)) =CHOOSEROWS(I1:K132;2;5;5;8;8;11;11) =TOCOL(SEQUENCE(5)&EXPAND(""13"")1) =LET(aINT(SEQUENCE(61/3))VSTACK(aaa)) =(INT(SEQUENCE(121/3))3-2)+SEQUENCE(30) =MAKEARRAY(1010LAMBDA(rcrc))"
YouTube Link 2025-10-30T15:00Z 59.4K followers, [---] engagements
"How to remove blank/ zero values from a graph in excel How to stop an excel chart from plotting the blank values in a table. In some situations a chart in excel will plot blank cells as zero values even if there not real data points and this can mess up the chart. There are a couple of ways you can stop this from happening by using an IF formula around the formula you already have to change every zero into #N/A as graphs in excel wont plot #N/A. You can also change the settings of the chart or the settings of the worksheet to try and get rid of them depending on the situation."
YouTube Link 2017-03-08T17:13Z 59.2K followers, 242.5K engagements
"How to make a chart with [--] axis in excel Create two charts and line them up over the top of each other --------------------------------------------------------------------------------- #exceltutorials #exceltips #excelcharts SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] These data are related to my PhD research --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - How to make multiple charts using vba in excel https://youtu.be/5_p8hltGY4s - How to quickly make multiple charts in"
YouTube Link 2019-09-18T17:00Z 58.8K followers, 687.8K engagements
"Copy list of filenames from folder into Excel (Windows) [--]. Select all the files and then go to Home and Copy Path. Paste into Excel and use Find & Replace (Ctrl + H) to remove the file path. [--]. Copy file path into google chrome and then copy the list of files size and date modified. [--]. To get files in subfolders as well search for a full stop/ period which will find all the files and then copy the path into excel. --------------------------------------------------------------------------------- SUBSCRIBE: https://goo.gl/c46YPs"
YouTube Link 2020-12-04T14:00Z 59K followers, 430.4K engagements
"How to calculate the significance of the Spearman's correlation in excel How to calculate the t-test and the p-value for a spearman's correlation to find out if your values are actually significantly correlated. Formulas in this video: n =COUNT(B2:B24) rho =CORREL(RANK.AVG(A2:A24A2:A24)RANK.AVG(B2:B24B2:B24)) t-stat =F3*SQRT((F2-2)/(1-F32)) p-value =T.DIST.2T(ABS(F4)F2-2) For more information about calculating the spearman's correlation: http://www.real-statistics.com/correlation/spearmans-rank-correlation/spearmans-rank-correlation-detailed/ Real Stats excel add-in:"
YouTube Link 2019-04-24T13:00Z 58.9K followers, 26.4K engagements
"How to make a bubble chart map in excel How to make a bubble chart map with latitude and longitude coordinates in excel. In this video I plotted data from an aircraft campaign in which air samples were taken at regular intervals during a flight. I plotted the data with the longitude and latitude of the location where each of the samples was taken from as the axis and the concentrations of a compound as the size of the bubbles. I also put an image of a map behind my graph and matched the grid references up with the longitude and latitude on the graph so the bubbles would be in about the"
YouTube Link 2017-04-05T15:06Z 57.8K followers, [----] engagements
"List of filenames from folder and subfolders into Excel Use Power Query to get a list of files in a folder and subfolders with information such as date modified and file size. The list will update if you add or remove files. --------------------------------------------------------------------------------- #exceltips #exceltutorials SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - Copy list of filenames from folder into Excel"
YouTube Link 2020-12-09T14:00Z 58.8K followers, 48.2K engagements
"How to get axis labels on only part of the axis in an excel chart Use custom number formatting to make only some of the numbers on an axis visible in a chart in excel. --------------------------------------------------------------------------------- #exceltips #exceltutorials #excelcharts SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] These data are related to my PhD research --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - How to make a chart with [--] axis in excel"
YouTube Link 2019-10-30T14:00Z 57.7K followers, [----] engagements
"How to add asterisks to a correlation table to show the significance in excel How to calculate the correlation from the p value. In this video I show you how to calculate the r critical value to find out how big the correlation needs to be to be significant at p [----] and p [----]. Then how to add conditional formatting to change the number formatting to add asterisks after the significant correlations in the correlation table. r critical value =T.INV(1-alpha/2n-2)/SQRT(T.INV(1-alpha/2n-2)2+n-2) Pearson Correlation - r Critical and p Value of r in Excel"
YouTube Link 2019-05-15T13:00Z 58.9K followers, 45K engagements
"What are CFCs HCFCs HFCs and PFCs This video is a very brief introduction to four different kinds of halocarbons: what their names stand for; the differences in their atmospheric lifetimes; and the differences in their ozone depleting potentials. For more information: http://www.ipcc.ch/ipccreports/sres/emission/index.phpidp=123 This video is part of a playlist: The Ozone Hole https://www.youtube.com/playlistlist=PLVe64sIb7fSYa-rr9cbSOigAtjRNwpuXv Another video: What are CFCs https://youtu.be/YL9g7JGLPp4"
YouTube Link 2017-09-07T20:36Z 59.1K followers, 10.6K engagements
"Find numbers missing from a sequence in excel =LET(rangeA2:A44UNIQUE(VSTACK(rangeSEQUENCE(MAX(range)-MIN(range)+1MIN(range)))TRUE)) =LAMBDA(rangeUNIQUE(VSTACK(rangeSEQUENCE(MAX(range)-MIN(range)+1MIN(range)))TRUE))(A2:A44) missing numbers excel find missing numbers missing values in a sequence missing from a sequence missing numbers in a sequence missing numbers excel find missing numbers missing values in a sequence missing from a sequence missing numbers in a sequence"
YouTube Link 2025-11-12T14:00Z 59.4K followers, [----] engagements
"UNIQUE in Excel UNIQUE in excel excel UNIQUE unique formula unique function remove duplicates unique formula in excel unique function in excel remove duplicates with formula excel UNIQUE in excel excel UNIQUE unique formula unique function remove duplicates unique formula in excel unique function in excel remove duplicates with formula excel"
YouTube Link 2025-11-10T14:01Z 59.4K followers, [----] engagements
"How to make bar charts more interesting in excel Create a bar chart with rounded corners and data labels"
YouTube Link 2024-04-24T13:00Z 51.2K followers, 19.1K engagements
"What are CFCs This video is a brief introduction to CFCs. What are CFCs When did CFCs first start being used What were CFCs used for Why aren't CFCs being used anymore How are concentrations of CFCs in the atmosphere changing For more information see: https://en.wikipedia.org/wiki/Chlorofluorocarbon This video is part of a playlist: The Ozone Hole https://www.youtube.com/playlistlist=PLVe64sIb7fSYa-rr9cbSOigAtjRNwpuXv The previous videos in this series are: [--]. The Layers of the Atmosphere: https://youtu.be/_Y0w74Gie30 [--]. The Ozone Layer: https://youtu.be/x33mQDnajGM [--]. CFC numbering system:"
YouTube Link 2017-07-19T16:38Z 57.4K followers, 27.2K engagements
"How to unpivot multiple columns in excel =INDEX(G5:R9G13:G32I13:K32) =TOCOL(UNIQUE(G4:R41)&S5:S91) excel excel tutorial unpivot multiple columns unpivot table rearrange table rearrange data excel excel tutorial unpivot multiple columns unpivot table rearrange table rearrange data"
YouTube Link 2025-10-22T13:01Z 59.4K followers, [---] engagements
"Bold start of words in Microsoft Word (Bionic Reading) Sub BoldStart() For Each wd In ActiveDocument.Range.Words For i = [--] To Int((Len(wd) + 1) / 2) wd.Characters(i).Font.Bold = True Next i Next wd End Sub bionic reading microsoft word microsoft word vba microsoft word macro bold first half of words bold start of every word word bold start vba first letters bold ms word first letters bold bold the start of words first letter bold first word bold bionic reading microsoft word microsoft word vba microsoft word macro bold first half of words bold start of every word word bold start vba first"
YouTube Link 2025-12-17T14:01Z 59.4K followers, [---] engagements
"How to add references into word using google scholar and mendeley How to make a reference list in Microsoft word. Using google scholar to copy and paste citations. Or using Mendeley reference manager plug-in to insert a bibliography. -------------------------------------------------------------------------------- #msword #microsoftword #mswordtutorial SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - How to convert a pdf into a"
YouTube Link 2019-07-24T13:00Z 58.5K followers, 642.1K engagements
"Keyboard shortcut to move columns & rows in Excel excel move columns rearrange columns reorder columns columns in excel reorder rows in excel insert rows excel move columns rearrange columns reorder columns columns in excel reorder rows in excel insert rows"
YouTube Link 2025-11-03T14:01Z 59.4K followers, [----] engagements
"GROUPBY in Excel GROUPBY GROUPBY in excel excel GROUPBY GROUPBY excel groupby function groupby formula groupby formula in excel GROUPBY GROUPBY in excel excel GROUPBY GROUPBY excel groupby function groupby formula groupby formula in excel"
YouTube Link 2025-12-15T14:01Z 59.4K followers, [----] engagements
"SEQUENCE in Excel sequence in excel SEQUENCE excel excel SEQUENCE sequence function sequence formula sequence formula in excel excel sequence in excel SEQUENCE excel excel SEQUENCE sequence function sequence formula sequence formula in excel excel"
YouTube Link 2025-10-27T14:01Z 59.4K followers, [----] engagements
"Heatmap in Excel #shorts"
YouTube Link 2023-01-30T14:00Z 59K followers, [----] engagements
"How to use advanced filter to remove blanks in excel =A1"" To use advanced filter to get rid of blank cells make the heading in the criteria range a blank cell and then use the formula =A1"" which means is cell A1 less than or greater than two quotation marks i.e. is cell A1 not equal to a blank. Make the cell reference the cell in the top row of the column you want to filter. To filter more than one column us =AND(A1""B1"") -------------------------------------------------------------------------------- #exceltips #exceltutorials #msexcel SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office 365"
YouTube Link 2019-08-14T13:00Z 57.5K followers, 33.9K engagements
"Symbol bar chart in a cell in excel =REPT(""3)"
YouTube Link 2023-05-22T13:00Z 58.1K followers, 32.2K engagements
"Check if two columns are the same in Excel #shorts =EXACT()"
YouTube Link 2023-03-13T14:00Z 57.7K followers, 40.4K engagements
"Get values to repeat in Excel excel repeat values repeat cells repeat values in excel repeating values repeat values excel excel repeating values repeating values formula excel repeat values repeat cells repeat values in excel repeating values repeat values excel excel repeating values repeating values formula"
YouTube Link 2025-12-22T14:01Z 59.4K followers, [---] engagements
"How to make a forest plot in excel Turn a bar chart into a forest plot --------------------------------------------------------------------------------- #exceltutorials #excelcharts #exceltips SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] Beta Channel Version [----] ---------------------------------------------------------------------------------"
YouTube Link 2022-01-26T14:00Z 58.3K followers, 84.7K engagements
"How to match up data with different dates and times in excel How to combine two different sets of data when one set of data has gaps in it. In this video I combine modelled wind direction with hourly ozone concentrations at Weybourne in the UK 2010-2014. As wind direction results aren't produced as often as hourly ozone concentrations there are some gaps in the data. In order to line up the wind directions with the ozone concentrations I use an INDEX MATCH formula to line up the dates and times. =INDEX(wind data MATCH(date & time dates & times 0)) #exceltutorial #excelformulas"
YouTube Link 2015-10-14T18:19Z 58.7K followers, 96.3K engagements
"Make formulas with discontinuous cell references in excel excel discontinous cell references split cell references cell references without a pattern interrupted cell references formulas with weird cell references excel discontinous cell references split cell references cell references without a pattern interrupted cell references formulas with weird cell references"
YouTube Link 2025-12-08T14:01Z 59.4K followers, [----] engagements
"Join text together in Excel using CONCAT"
YouTube Link 2023-07-03T13:00Z 57.7K followers, [----] engagements
"Get ID number using REGEXEXTRACT in Excel =REGEXEXTRACT(C2"wd4") REGEXEXTRACT excel REGEXEXTRACT excel excel regexextract regexextract in excel REGEXEXTRACT formula example of REGEXEXTRACT REGEXEXTRACT example REGEX excel excel regex regex in excel regex formula in excel REGEXEXTRACT function REGEXEXTRACT excel REGEXEXTRACT excel excel regexextract regexextract in excel REGEXEXTRACT formula example of REGEXEXTRACT REGEXEXTRACT example REGEX excel excel regex regex in excel regex formula in excel REGEXEXTRACT function"
YouTube Link 2025-11-24T14:01Z 59.4K followers, [----] engagements
"Copy text from pdf into word without splitting across multiple lines Use Find and Replace to replace all paragraph marks (p) with spaces to get rid of line breaks in Microsoft Word fix formatting when copying text from pdf into word microsoft word remove paragraph marks remove line breaks change paragraph marks to spaces find and replace stop text splitting across lines from multiple lines to one paragraph coping from pdf to word fix formatting when copying text from pdf into word microsoft word remove paragraph marks remove line breaks change paragraph marks to spaces find and replace stop"
YouTube Link 2025-12-10T14:01Z 59.4K followers, [---] engagements
"Analyzing data in excel example XLOOKUP AVERAGEIF TEXT FILTER =IF(B3=B2D2D2+1) =XLOOKUP(D2$J$2#$P$2:$P$14) =IF(ISEVEN(D2)F2NA()) =IF(ISODD(D2)F2NA()) =UNIQUE(D2:D10281) =XLOOKUP($J$2#$D$2:$D$10281$B$2:$B$10281) =TEXT(L2"mmm yyyy")&" - "&TEXT(M2"mmm yyyy") =COUNTIF($D$2:$D$10281J2) =AVERAGEIF($D$2:$D$10281J2$C$2:$C$10281) =STDEV.P(FILTER($C$2:$C$10281$D$2:$D$10281=J2)) analyze data excel analyse data in excel xlookup averageif excel formulas excel functions using excel for science analyze data excel analyse data in excel xlookup averageif excel formulas excel functions using excel for science"
YouTube Link 2025-06-18T13:01Z 59.4K followers, [---] engagements
"How to use quickchart.io to make charts that aren't available in excel =IMAGE(B7&B8) /chartv=3&c= type: 'funnel' data: labels: 'Leads' 'Emails' 'Calls' 'Quotes''Sales' datasets: data: [---] [----] [----] [----] [----] backgroundColor: 'rgb(139 [--] 0)' 'rgb(205 [--] 92)' 'rgb(240 [---] 128)' 'rgb(250 [---] 114)' 'rgb(255 [---] 122)' options: indexAxis: 'x' quickchart.io quickchart funnel chart excel microsoft excel funnel chart in excel IMAGE function IMAGE formula IMAGE function in excel quickchart.io quickchart funnel chart excel microsoft excel funnel chart in excel IMAGE function IMAGE formula IMAGE"
YouTube Link 2025-06-25T13:01Z 59.4K followers, [---] engagements
"How to make the font of the axis labels different colors in an excel chart Use custom number formatting: Red=700;Color43400;0 Overlap the secondary and primary axis --------------------------------------------------------------------------------- #exceltips #exceltutorials #excelcharts SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - How to get axis labels on only part of the axis in an excel chart https://youtu.be/NZPOcq6DHrk -"
YouTube Link 2019-12-18T14:00Z 57.4K followers, 30.9K engagements
"List of filenames from folder into Excel Copy Folder Path into excel. Add "*" onto end of folder path. Make a named range using the formula =FILES() and then use the named range to get a list of file names. --------------------------------------------------------------------------------- #exceltips #exceltutorials SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - Copy list of filenames from folder into Excel (Windows)"
YouTube Link 2020-12-16T14:00Z 58.8K followers, 30.1K engagements
"How to do integrations in IAU Part [--] How all the features work and integrating the first compound. I have made these videos to help me and the people I work with remember how to use this software"
YouTube Link 2018-01-02T19:38Z 59.3K followers, [---] engagements
"How to make a calendar heatmap in excel Using a VLOOKUP formula conditional formatting and custom number formatting. Average daily temperature in England in [----] https://www.metoffice.gov.uk/hadobs/hadcet/data/download.html --------------------------------------------------------------------------------- #exceltips #exceltutorials #excelcharts SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - How to make a calendar heatmap in excel"
YouTube Link 2020-03-30T13:00Z 59.3K followers, [----] engagements
"How to make a dynamic chart using slicers in excel Convert the values into an excel table. Then on the 'Table Design' tab select 'Insert Slicer'. Make a chart for the whole of the table. Then you can use the slicer to filter the table and the chart. --------------------------------------------------------------------------------- #exceltips #exceltutorials #excelcharts SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version [----] These data are related to my PhD research --------------------------------------------------------------------------------- IF YOU LIKED"
YouTube Link 2019-12-24T14:00Z 59.4K followers, 112.3K engagements
"Roll of the dice in excel Use the Segoe UI Symbol font to get the six sides of the dice ⚀⚁⚂⚃⚄⚅ Then use the =RANDBETWEEN(16) formula to get random numbers between [--] and [--]. After that use a VLOOKUP formula to find the side of the dice. Finally copy the dice as linked pictures and press F9 to 'roll the dice' --------------------------------------------------------------------------------- #exceltips #exceltutorials #excelformulas SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] [----] Office Insider Version 2006"
YouTube Link 2020-05-28T13:00Z 59.4K followers, 22.1K engagements
"Delete notes from all slides in powerpoint File - Info - Check for Issues - Inspect Document - Presentation Notes - Inspect - Remove All powerpoint delete notes powerpoint remove notes slide notes presentation notes all notes at once speaker notes notes from all slides in one go remove all notes presenter notes get rid of delete notes multiple slides powerpoint delete notes powerpoint remove notes slide notes presentation notes all notes at once speaker notes notes from all slides in one go remove all notes presenter notes get rid of delete notes multiple slides"
YouTube Link 2026-02-11T14:00Z 59.4K followers, [--] engagements
"How to make a map in excel using a bubble chart In this video I show you how to use a bubble chart in excel to make a map using longitude and latitude coordinates. I change the background of the chart into an image of a map and then change the x and y axis to control the position of the data points. I also show you how to remove the axis labels add multiple series to the graph and add labels to the map. --------------------------------------------------------------------------------- #exceltutorials #excelbubblecharts #excelmaps SUBSCRIBE: https://goo.gl/c46YPs"
YouTube Link 2017-08-16T18:38Z 59.4K followers, 28.1K engagements
"How to import multiple text files into excel How to put lots of text files into a single excel spreadsheet all in one go. Sometimes you have data in lots of separate text files and you want to be able to put that data together in an excel document without having to copy and paste each text file individually. You can do this using Power Query. This is a really useful feature in Excel [----] which lets you organize large amounts of data. This only works if all your text files have the same columns. This works with .txt and .csv files."
YouTube Link 2017-03-01T16:00Z 59.4K followers, 188.1K engagements
"How to create a table of contents in excel with hyperlinks Using Power Query to make a list of sheets in an excel spreadsheet. =HYPERLINK("#'"&@Name&"'A1"@Name) --------------------------------------------------------------------------------- #exceltips #exceltutorials #excelformulas SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office [---] Beta Channel Version [----] --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - How to make hyperlinks to multiple files in excel https://youtu.be/XZSDTxTVjtc table of contents in excel"
YouTube Link 2021-02-17T14:00Z 59.4K followers, 85.8K engagements
"TEXTSPLIT in Excel Using the TEXTSPLIT function in Excel to split text by a delimiter textsplit in excel excel textsplit textsplit formula textsplit function text split in excel split text using formula in excel text split formula in excel textsplit function in excel textsplit formula excel split text by delimiter text split delimiter textsplit in excel excel textsplit textsplit formula textsplit function text split in excel split text using formula in excel text split formula in excel textsplit function in excel textsplit formula excel split text by delimiter text split delimiter"
YouTube Link 2023-07-17T13:00Z 59.4K followers, 341K engagements
"How to rename multiple files at once using Excel (Windows) Change file names in Windows Command Prompt: ren "old filename.ext" "new filename.ext" Use Excel to make multiple copies of this code then paste it back into Command Prompt. --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - How to rename multiple files in Windows https://youtu.be/I9ffWZ_Bt6 - List of filenames from folder into Excel (Windows) https://youtu.be/771XysaD1DU microsoft excel windows command prompt rename files rename files in windows rename files"
YouTube Link 2021-01-13T14:00Z 59.4K followers, 463.4K engagements
"Delete notes from all slides in powerpoint File - Info - Check for Issues - Inspect Document - Presentation Notes - Inspect - Remove All powerpoint delete notes powerpoint remove notes slide notes presentation notes all notes at once speaker notes notes from all slides in one go remove all notes presenter notes get rid of delete notes multiple slides powerpoint delete notes powerpoint remove notes slide notes presentation notes all notes at once speaker notes notes from all slides in one go remove all notes presenter notes get rid of delete notes multiple slides"
YouTube Link 2026-02-11T14:00Z 59.4K followers, [--] engagements
"IMPORTTEXT & IMPORTCSV functions in excel Example 1: one file with dropdown list =IMPORTTEXT(A2&A3-2) Example 2: from a webpage =IMPORTTEXT("https://gml.noaa.gov/aftp/data/trace_gases/co2/flask/surface/txt/co2_mlo_surface-flask_1_ccgg_month.txt" 049132054) Same link further back: https://gml.noaa.gov/aftp/data/trace_gases/co2/flask/surface/txt/ Example 3: multiple files =CHOOSECOLS(VSTACK(IMPORTTEXT(A1)IMPORTTEXT(A21)IMPORTTEXT(A31)IMPORTTEXT(A41)IMPORTTEXT(A51)IMPORTTEXT(A61)IMPORTTEXT(A71)IMPORTTEXT(A81))2347) importtext importext importcsv excel import csv import text import text files"
YouTube Link 2026-01-20T19:00Z 59.4K followers, [---] engagements
"Get values to repeat in Excel excel repeat values repeat cells repeat values in excel repeating values repeat values excel excel repeating values repeating values formula excel repeat values repeat cells repeat values in excel repeating values repeat values excel excel repeating values repeating values formula"
YouTube Link 2025-12-22T14:01Z 59.4K followers, [---] engagements
"Bold start of words in Microsoft Word (Bionic Reading) Sub BoldStart() For Each wd In ActiveDocument.Range.Words For i = [--] To Int((Len(wd) + 1) / 2) wd.Characters(i).Font.Bold = True Next i Next wd End Sub bionic reading microsoft word microsoft word vba microsoft word macro bold first half of words bold start of every word word bold start vba first letters bold ms word first letters bold bold the start of words first letter bold first word bold bionic reading microsoft word microsoft word vba microsoft word macro bold first half of words bold start of every word word bold start vba first"
YouTube Link 2025-12-17T14:01Z 59.4K followers, [---] engagements
"GROUPBY in Excel GROUPBY GROUPBY in excel excel GROUPBY GROUPBY excel groupby function groupby formula groupby formula in excel GROUPBY GROUPBY in excel excel GROUPBY GROUPBY excel groupby function groupby formula groupby formula in excel"
YouTube Link 2025-12-15T14:01Z 59.4K followers, [----] engagements
"Copy text from pdf into word without splitting across multiple lines Use Find and Replace to replace all paragraph marks (p) with spaces to get rid of line breaks in Microsoft Word fix formatting when copying text from pdf into word microsoft word remove paragraph marks remove line breaks change paragraph marks to spaces find and replace stop text splitting across lines from multiple lines to one paragraph coping from pdf to word fix formatting when copying text from pdf into word microsoft word remove paragraph marks remove line breaks change paragraph marks to spaces find and replace stop"
YouTube Link 2025-12-10T14:01Z 59.4K followers, [---] engagements
"Make formulas with discontinuous cell references in excel excel discontinous cell references split cell references cell references without a pattern interrupted cell references formulas with weird cell references excel discontinous cell references split cell references cell references without a pattern interrupted cell references formulas with weird cell references"
YouTube Link 2025-12-08T14:01Z 59.4K followers, [----] engagements
"Calculate current value from depreciation rate and original value in excel =E13*(1-$B$9/100) =B7*(1-B9/100)(YEAR(TODAY())-B8) =B7*POWER(1-B9/100YEAR(TODAY())-B8) =B7-VDB(B701000YEAR(TODAY())-B8B9TRUE) depreciation rate salvage value present value future value excel depreciation rate salvage value present value future value excel"
YouTube Link 2025-12-03T14:00Z 59.4K followers, [---] engagements
"Change all formulas to absolute cell references in Excel absolute cell references cell references with dollar signs formulas all absolute all formulas absolute multiple formulas have absolute cell references excel multiple formulas absolute all cell references absolute multiple cell references absolute absolute cell references cell references with dollar signs formulas all absolute all formulas absolute multiple formulas have absolute cell references excel multiple formulas absolute all cell references absolute multiple cell references absolute"
YouTube Link 2025-12-01T14:00Z 59.4K followers, [----] engagements
"Get all the factors of a number in excel =LET(numH1ARRAYTOTEXT(FILTER(SEQUENCE(num)MOD(numSEQUENCE(num))=0))) factors excel prime number excel excel prime number excel factors all factors excel factors in excel get factors in excel excel all factors number factors factors of numbers factors of a number factors excel prime number excel excel prime number excel factors all factors excel factors in excel get factors in excel excel all factors number factors factors of numbers factors of a number"
YouTube Link 2025-11-26T14:00Z 59.4K followers, [---] engagements
"Get ID number using REGEXEXTRACT in Excel =REGEXEXTRACT(C2"wd4") REGEXEXTRACT excel REGEXEXTRACT excel excel regexextract regexextract in excel REGEXEXTRACT formula example of REGEXEXTRACT REGEXEXTRACT example REGEX excel excel regex regex in excel regex formula in excel REGEXEXTRACT function REGEXEXTRACT excel REGEXEXTRACT excel excel regexextract regexextract in excel REGEXEXTRACT formula example of REGEXEXTRACT REGEXEXTRACT example REGEX excel excel regex regex in excel regex formula in excel REGEXEXTRACT function"
YouTube Link 2025-11-24T14:01Z 59.4K followers, [----] engagements
"Remove duplicate values in Excel remove duplicates excel remove duplicates in excel get unique values excel remote duplicates excel data tools remove duplicates excel remove duplicates in excel get unique values excel remote duplicates excel data tools"
YouTube Link 2025-11-17T14:00Z 59.4K followers, 11.5K engagements
"Find numbers missing from a sequence in excel =LET(rangeA2:A44UNIQUE(VSTACK(rangeSEQUENCE(MAX(range)-MIN(range)+1MIN(range)))TRUE)) =LAMBDA(rangeUNIQUE(VSTACK(rangeSEQUENCE(MAX(range)-MIN(range)+1MIN(range)))TRUE))(A2:A44) missing numbers excel find missing numbers missing values in a sequence missing from a sequence missing numbers in a sequence missing numbers excel find missing numbers missing values in a sequence missing from a sequence missing numbers in a sequence"
YouTube Link 2025-11-12T14:00Z 59.4K followers, [----] engagements
"UNIQUE in Excel UNIQUE in excel excel UNIQUE unique formula unique function remove duplicates unique formula in excel unique function in excel remove duplicates with formula excel UNIQUE in excel excel UNIQUE unique formula unique function remove duplicates unique formula in excel unique function in excel remove duplicates with formula excel"
YouTube Link 2025-11-10T14:01Z 59.4K followers, [----] engagements
"Sequential numbers with gaps across columns in excel =IF(Q5=""""MAX(N$5:N$16P$4:P4)+1) excel sequences excel sequences across columns number sequences in excel sequences with gaps sequential numbers in excel excel sequential numbers sequential numbers with gaps sequential numbers multiple columns excel sequences excel sequences across columns number sequences in excel sequences with gaps sequential numbers in excel excel sequential numbers sequential numbers with gaps sequential numbers multiple columns"
YouTube Link 2025-11-05T14:01Z 59.4K followers, [---] engagements
"Keyboard shortcut to move columns & rows in Excel excel move columns rearrange columns reorder columns columns in excel reorder rows in excel insert rows excel move columns rearrange columns reorder columns columns in excel reorder rows in excel insert rows"
YouTube Link 2025-11-03T14:01Z 59.4K followers, [----] engagements
"Tricks for number patterns in formulas in excel =MOD(SEQUENCE(12101)3)*2+2 =INT(SEQUENCE(12111/3)) =CHOOSEROWS(I1:K132;2;5;5;8;8;11;11) =TOCOL(SEQUENCE(5)&EXPAND(""13"")1) =LET(aINT(SEQUENCE(61/3))VSTACK(aaa)) =(INT(SEQUENCE(121/3))3-2)+SEQUENCE(30) =MAKEARRAY(1010LAMBDA(rcrc))"
YouTube Link 2025-10-30T15:00Z 59.4K followers, [---] engagements
"SEQUENCE in Excel sequence in excel SEQUENCE excel excel SEQUENCE sequence function sequence formula sequence formula in excel excel sequence in excel SEQUENCE excel excel SEQUENCE sequence function sequence formula sequence formula in excel excel"
YouTube Link 2025-10-27T14:01Z 59.4K followers, [----] engagements
"How to unpivot multiple columns in excel =INDEX(G5:R9G13:G32I13:K32) =TOCOL(UNIQUE(G4:R41)&S5:S91) excel excel tutorial unpivot multiple columns unpivot table rearrange table rearrange data excel excel tutorial unpivot multiple columns unpivot table rearrange table rearrange data"
YouTube Link 2025-10-22T13:01Z 59.4K followers, [---] engagements
"Get a random subgroup in Excel random group excel random group random group excel random groups select random random selection random names excel random group excel random group random group excel random groups select random random selection random names excel"
YouTube Link 2025-10-20T13:00Z 59.4K followers, [----] engagements
"Compare tables to find missing rows in Excel compare tables find missing rows find missing values differences between tables excel compare tables find missing rows find missing values differences between tables excel"
YouTube Link 2025-10-13T13:01Z 59.4K followers, [---] engagements
"Split column on every other delimiter in power query excel power query split list power query every other delimiter split list in power query split column power query excel power query split list power query every other delimiter split list in power query split column power query"
YouTube Link 2025-10-08T13:02Z 59.4K followers, [---] engagements
"CHOOSEROWS in Excel chooserows CHOOSEROWS excel chooserows formula chooserows function choose rows in excel choose rows formula in excel chooserows CHOOSEROWS excel chooserows formula chooserows function choose rows in excel choose rows formula in excel"
YouTube Link 2025-10-06T13:01Z 59.4K followers, [---] engagements
"For how many decimal places are the numbers the same in excel LAMBDA =SUM((ROUNDDOWN(B1SEQUENCE(15))=ROUNDDOWN(C1SEQUENCE(15)))*1) =LAMBDA(num_1num_2SUM((ROUNDDOWN(num_1SEQUENCE(15))=ROUNDDOWN(num_2SEQUENCE(15)))*1)) excel decimal places count decimal places same to how many decimal places compare numbers how many decimal places decimal places the same excel decimal places count decimal places same to how many decimal places compare numbers how many decimal places decimal places the same"
YouTube Link 2025-10-01T13:01Z 59.4K followers, [---] engagements
"FILTER in Excel FILTER excel filter excel excel filter filter in excel filter function filter formula filter formula in excel FILTER excel filter excel excel filter filter in excel filter function filter formula filter formula in excel"
YouTube Link 2025-09-29T13:00Z 59.4K followers, [----] engagements
"How to calculate deming regression in excel =LET(xvaluesA2:A13yvaluesB2:B13xvarianceA16yvarianceB16 avgxAVERAGE(xvalues)avgyAVERAGE(yvalues) rSUMPRODUCT(xvalues-avgxyvalues-avgy) kxvariance/yvariance uDEVSQ(xvalues)vDEVSQ(yvalues) hkv-u (h+SQRT(h2+4kr2))/(2k*r)) deming regression deming regression excel deming regression in excel excel deming regression regressions in excel excel trend line total least squares regression linear trendline trendline including errors regression with uncertainties orthogonal regression excel deming regression deming regression excel deming regression in excel"
YouTube Link 2025-09-24T13:01Z 59.4K followers, [---] engagements
"Get axis labels to be multiple colors in Excel Make some of the numbers on an axis a different color excel excel chart chart axis numbers different colors axis labels two colors axis different colors make axis numbers multiple colors axis labels different colors excel excel chart chart axis numbers different colors axis labels two colors axis different colors make axis numbers multiple colors axis labels different colors"
YouTube Link 2025-09-22T13:01Z 59.4K followers, [---] engagements
"Tricks for formatting data labels in excel charts excel excel chart excel charts data labels format data labels different data labels change data labels data labels in charts data labels excel excel excel chart excel charts data labels format data labels different data labels change data labels data labels in charts data labels excel"
YouTube Link 2025-09-17T13:00Z 59.4K followers, [----] engagements
"Round to the nearest [--] in Excel round nearest ten round nearest [---] round to the closest multiple of [--] excel round nearest ten round nearest [---] round to the closest multiple of [--] excel"
YouTube Link 2025-09-15T13:02Z 59.4K followers, [----] engagements
"How to make a variance chart in excel Target vs Actual - Clustered Column Chart with Error Bars variance chart variance chart excel variance chart in excel excel variance chart variance charts target vs actual chart target vs actual chart excel excel red arrows green arrows bar chart with arrows red and green arrows target vs actual variance chart variance chart excel variance chart in excel excel variance chart variance charts target vs actual chart target vs actual chart excel excel red arrows green arrows bar chart with arrows red and green arrows target vs actual"
YouTube Link 2025-09-10T13:01Z 59.4K followers, [----] engagements
"Separate numbers and letters using REGEXEXTRACT in excel =REGEXEXTRACT(A1"pn+"1) =REGEXEXTRACT(A1"pl+"1) extract numbers extract letters separate letters and numbers separate letters separate numbers separate numbers and letters numbers from letters letters from numbers regex in excel regexextract regexextract excel excel extract numbers extract letters separate letters and numbers separate letters separate numbers separate numbers and letters numbers from letters letters from numbers regex in excel regexextract regexextract excel excel"
YouTube Link 2025-09-08T13:00Z 59.4K followers, [----] engagements
"How to make a range chart in excel Using Clustered Column Chart Temperature data: nw3weather.co.uk/wx14.php range chart excel excel temperature range chart clustered column chart column chart in excel range charts temperature chart min-max chart min max chart chart showing minimum and maximum range make bar chart without bars going to zero range chart excel excel temperature range chart clustered column chart column chart in excel range charts temperature chart min-max chart min max chart chart showing minimum and maximum range make bar chart without bars going to zero"
YouTube Link 2025-09-03T13:01Z 59.4K followers, [---] engagements
"Get table to repeat x number of times in excel excel repeat table repeat range repeat range in excel repeat table in excel copy range multiple times multiple copies of range same table multiple times excel repeat table repeat range repeat range in excel repeat table in excel copy range multiple times multiple copies of range same table multiple times"
YouTube Link 2025-09-01T13:02Z 59.4K followers, [---] engagements
"How to make national emergencies chart in excel National emergencies declared by US Presidents [----] - [----] Power Query XLOOKUP COUNTIFS Stacked Bar Chart excel XLOOKUP power query data from web COUNTIFS stacked bar chart stacked bar chart excel national emergency chart national emergencies figure emergencies declared by presidents graphic number of national emergencies diagram excel XLOOKUP power query data from web COUNTIFS stacked bar chart stacked bar chart excel national emergency chart national emergencies figure emergencies declared by presidents graphic number of national emergencies"
YouTube Link 2025-08-27T13:00Z 59.4K followers, [---] engagements
"How to make subplots using pandas in python import pandas as pd import matplotlib.pyplot as plt df = pd.read_excel('C:python scriptsVT-24-25.xlsx''Sheet1'index_col=0) df.plot(subplots=Truefigsize=(3218)layout=(105)sharex=Truemarker='o'color='red') plt.subplots_adjust(hspace=0) plt.show() python pandas python python pandas subplots in python panel chart in python panel chart subplots subplots python subplots pandas python pandas python python pandas subplots in python panel chart in python panel chart subplots subplots python subplots pandas"
YouTube Link 2025-08-20T13:00Z 59.4K followers, [---] engagements
"How to line up tables in excel using python Python is only available in some versions of excel pd.merge(xl("A1:B13" headers=True)xl("D1:E10" headers=True)how='outer').fillna('unknown') pd.concat(xl("A1:E5" headers=True)xl("A7:E10" headers=True)ignore_index=True).fillna('') excel python python in excel line up tables line up columns combine tables together combine tables join tables tables in excel columns in excel excel python python in excel line up tables line up columns combine tables together combine tables join tables tables in excel columns in excel"
YouTube Link 2025-08-13T13:00Z 59.4K followers, [---] engagements
"How to get axes to overlap using matplotlib in python import matplotlib.pyplot as plt plt.rc('axes'facecolor='none') fig = plt.figure() ax1 = fig.add_axes(0010.4) #left bottom width height ax2 = fig.add_axes(00.310.4) ax3 = fig.add_axes(00.610.4) x = [----] y_1 = [----] y_2 = [--------] y_3 = [------------] ax1.plot(xy_1color='red') ax2.plot(xy_2color='blue') ax3.plot(xy_3color='green') ax1.spines'top'.set_visible(False) ax2.spines'top'.set_visible(False) ax2.spines'bottom'.set_visible(False) ax3.spines'bottom'.set_visible(False) ax3.xaxis.set_ticks_position('top')"
YouTube Link 2025-08-06T13:01Z 59.4K followers, [---] engagements
"How to line up the columns from two tables in excel =XLOOKUP(B12$B$1:$I$1$B$2:$I$5"") =SORT(UNIQUE(HSTACK(B1:I1B7:H7)1)1) line up columns excel combine tables join tables in excel combine multiple tables fix misaligned columns align columns in excel align columns align two tables align two ranges of data merge tables merge tables by matching column headers merge two tables combine two tables excel based on column headings line up columns excel combine tables join tables in excel combine multiple tables fix misaligned columns align columns in excel align columns align two tables align two"
YouTube Link 2025-07-30T13:00Z 59.4K followers, [---] engagements
"How to find the last number in a column in excel =TAKE(B.:.B-1) =LOOKUP(1E+300F:F) =XLOOKUP(TRUEJ.:.J less than symbol 10J.:.J-1) last number in column last number excel last number column excel last number in excel last value in column find last value last non-empty cell get last number excel last number in column last number excel last number column excel last number in excel last value in column find last value last non-empty cell get last number excel"
YouTube Link 2025-07-23T13:00Z 59.4K followers, [---] engagements
"How to make a population pyramid in excel World population data: https://www.populationpyramid.net/world/2025/ excel microsoft excel make population pyramid population pyramid butterfly chart population chart tornado chart diverging bar chart butterfly chart excel tornado chart excel diverging bar charts make a butterfly chart population pyramid in excel butterfly chart in excel make a tornado chart population pyramids population pyramid chart population pyramid charts pryamid excel microsoft excel make population pyramid population pyramid butterfly chart population chart tornado chart"
YouTube Link 2025-07-09T13:01Z 59.4K followers, [----] engagements
"My YouTube Analytics [----] Views subscribers revenue impressions click-through-rate RMP etc. youtube analytics youtube studio youtube analytics small channel youtube analytics educational channel how much money do small youtube channels make youtube money youtube make money youtube how much money youtube studio [----] youtube analytics [----] how much money do youtube channels make youtube channel analytics youtube RPM youtube analytics youtube studio youtube analytics small channel youtube analytics educational channel how much money do small youtube channels make youtube money youtube make money"
YouTube Link 2025-07-02T13:00Z 59.4K followers, [---] engagements
"How to use quickchart.io to make charts that aren't available in excel =IMAGE(B7&B8) /chartv=3&c= type: 'funnel' data: labels: 'Leads' 'Emails' 'Calls' 'Quotes''Sales' datasets: data: [---] [----] [----] [----] [----] backgroundColor: 'rgb(139 [--] 0)' 'rgb(205 [--] 92)' 'rgb(240 [---] 128)' 'rgb(250 [---] 114)' 'rgb(255 [---] 122)' options: indexAxis: 'x' quickchart.io quickchart funnel chart excel microsoft excel funnel chart in excel IMAGE function IMAGE formula IMAGE function in excel quickchart.io quickchart funnel chart excel microsoft excel funnel chart in excel IMAGE function IMAGE formula IMAGE"
YouTube Link 2025-06-25T13:01Z 59.4K followers, [---] engagements
"Analyzing data in excel example XLOOKUP AVERAGEIF TEXT FILTER =IF(B3=B2D2D2+1) =XLOOKUP(D2$J$2#$P$2:$P$14) =IF(ISEVEN(D2)F2NA()) =IF(ISODD(D2)F2NA()) =UNIQUE(D2:D10281) =XLOOKUP($J$2#$D$2:$D$10281$B$2:$B$10281) =TEXT(L2"mmm yyyy")&" - "&TEXT(M2"mmm yyyy") =COUNTIF($D$2:$D$10281J2) =AVERAGEIF($D$2:$D$10281J2$C$2:$C$10281) =STDEV.P(FILTER($C$2:$C$10281$D$2:$D$10281=J2)) analyze data excel analyse data in excel xlookup averageif excel formulas excel functions using excel for science analyze data excel analyse data in excel xlookup averageif excel formulas excel functions using excel for science"
YouTube Link 2025-06-18T13:01Z 59.4K followers, [---] engagements
"Extracting data from a table REGEXTEST FILTER COUNTIF GROUPBY =TEXTBEFORE(A2"_") =REGEXTEST(C2"ALMAALSX") =UNIQUE(FILTER(B1:C3223D1:D3223)) =COUNTIF($F$2:$F$390F2) =FILTER(F1#H1:H390 greater than 1) =GROUPBY(J2:J75K2:K75ARRAYTOTEXT0) arrange data regextest groupby rearrange data format data excel microsoft excel filter formula textbefore formula unique formula regex formulas in excel regex in excel regex excel groupby function groupby excel extract data arrange data regextest groupby rearrange data format data excel microsoft excel filter formula textbefore formula unique formula regex"
YouTube Link 2025-06-11T13:00Z 59.4K followers, [---] engagements
"Reformatting my dataset in excel (for the ICOS Portal) =TEXT(J2"yyyy-mm-ddThh:mm:ssZ") =YEAR(J2) =MONTH(J2) =DAY(J2) =HOUR(J2) =MINUTE(J2) =LET(dateJ2yYEAR(date)hHOUR(date)minMINUTE(date)secSECOND(date)fstDATE(y11)doyINT(date)-fstsoy(doy86400)+(h3600)+(min60)+secleapDATE(y1231)-fst+1fracsoy/(leap86400)y+frac) =IFERROR(ROUND(J21)"") reorganise data rearrange table organize dataset reformatting dataset format dataset formatting data excel microsoft excel office [---] reorganise data rearrange table organize dataset reformatting dataset format dataset formatting data excel microsoft excel"
YouTube Link 2025-06-04T13:00Z 59.4K followers, [---] engagements
"Check if multiple cells are equal in excel EXACT formula for more than two cells =AND(EXACT(A3A3:D3)) =AND(A3=A3:D3) =COUNTIF(A3:D3A3)=4 =COUNTA(UNIQUE(A3:D31))=1 =MIN(A3:D3)=MAX(A3:D3) compare values multiple cells equal multiple values same EXACT formula more than two values same number excel compare multiple values in excel EXACT more than two are all cells equal is content in each cell the same every cell the same multiple values in same compare values multiple cells equal multiple values same EXACT formula more than two values same number excel compare multiple values in excel EXACT more"
YouTube Link 2025-05-21T13:00Z 59.4K followers, [----] engagements
"Make first letter in a cell into a capital letter in excel 0:00 Method [--] - Word 0:41 Method [--] - Flash Fill 1:30 Method [--] - REPLACE 2:48 Method [--] - REGEXREPLACE =REPLACE(A211UPPER(LEFT(A21))) =REGEXREPLACE(A2"w""u$0") capitalize first letter upper case excel regex in excel change case in excel change case of only first letter make only first letter capital first letter capital capital letter excel make only one word upper case excel first letter in cell capital excel uppercase excel capitalise first letter excel capitalize first letter upper case excel regex in excel change case in excel"
YouTube Link 2025-05-14T13:01Z 59.4K followers, [----] engagements
"Trick to quickly make a long nested formula in excel =TEXTJOIN(""TRUE"=""SUBSTITUTE(""SUBSTITUTE(""SUBSTITUTE(""SUBSTITUTE(""SUBSTITUTE(""SUBSTITUTE(""A2:A17""D3""E3";")D4""E4";")D5""E5";")D6""E6";")D7""E7";")D8""E8)") nested formula trick trick for nested formulas long formula how to quickly make long formulas how to easily make nested formulas quick nested formula excel make nested formula in excel trick for making long formula excel making nested formula nested formula nested formula excel nested formula in excel how to make nested formula in excel nested formula trick trick for nested"
YouTube Link 2025-05-07T13:00Z 59.4K followers, [----] engagements
"How to find and replace multiple words in excel with power query =List.Accumulate(Table.ToRecords(TableFindReplace) #"Changed Type" (TableToChangeTableFindReplace) = LESS THAN SYMBOL Table.ReplaceValue(TableToChangeTableFindReplaceOld WordsTableFindReplaceNew WordsReplacer.ReplaceText"Column Name")) substitute multiple words replace multiple words find and replace multiple words at once excel replace multiple pieces of text substitute multiple characters bulk replace replace multiple words in one go replace multiple words in excel find and replace power query find & replace words with power"
YouTube Link 2025-04-30T13:01Z 59.4K followers, [---] engagements
"Find and Replace multiple words using VBA in excel Sub FindReplace() For r = [--] To [--] Range("A2:A7").Replace Cells(r 3) Cells(r 4) Next End Sub find replace vba substitute multiple words replace multiple words find and replace multiple words at once excel replace multiple pieces of text substitute multiple characters bulk replace replace multiple words in one go replace multiple words in excel vba macro find replace marco find and replace vba find and replace in vba find and replace with vba find & replace using macro find & replace with macro find replace vba substitute multiple words replace"
YouTube Link 2025-04-23T13:00Z 59.4K followers, [----] engagements
Limited data mode. Full metrics available with subscription: lunarcrush.com/pricing