![Karina Adcock](/img/default-banner.jpg)
- Видео 375
- Просмотров 16 930 942
Karina Adcock
Великобритания
Добавлен 10 дек 2011
Excel, PowerPoint, Word, etc. Videos of random things I've learnt while studying for my PhD on ozone depleting substances.
How much money do I make from YouTube
Amount each year, per 1000 views, from ads, premium & shorts
Просмотров: 115
Видео
How to make a parliament chart in flourish
Просмотров 141День назад
Also, called an arc-dot chart. Shows the number of people from each political party as different coloured dots.
How to make a parliament chart in excel
Просмотров 33914 дней назад
Also, called an arc-dot chart. Shows the number of people from each political party as different coloured dots. policyviz.com/2019/03/21/arc-dot-chart-in-excel/
Fill empty cells with the values from above or below in excel
Просмотров 210Месяц назад
Copy values up or down a column
How to split paragraph of text across multiple rows in excel | LAMBDA
Просмотров 284Месяц назад
=LAMBDA(txt,num,BYROW(WRAPROWS(TEXTSPLIT(txt," "),num,""),LAMBDA(array,TEXTJOIN(" ",FALSE,array))))
Google Chrome Keyboard Shortcuts | Windows PC
Просмотров 212Месяц назад
Keyboard shortcuts that you can use in Google Chrome
How to add multiple straight lines to an excel chart
Просмотров 337Месяц назад
Make a fake data series and add really long error bars that go all the way across the chart.
How to make a CALENDAR formula in excel | LAMBDA
Просмотров 6582 месяца назад
=LAMBDA(date,VSTACK(HSTACK(TEXT(date,"mmmm"),YEAR(date),"","","","",""), {"Mon","Tue","Wed","Thu","Fri","Sat","Sun"}, LET(first,EOMONTH(date,-1) 1, seq,SEQUENCE(6,7,first-WEEKDAY(first,3),1), IF(MONTH(seq)=MONTH(date),TEXT(seq,"d"),""))))(B2)
How to make bar charts more interesting in excel
Просмотров 2,5 тыс.2 месяца назад
Create a bar chart with rounded corners and data labels
How to calculate total least squares regression in excel
Просмотров 3202 месяца назад
=LET(xvalues,A2:A18,yvalues,B2:B18,w,DEVSQ(yvalues)-DEVSQ(xvalues),r,2*COVARIANCE.P(xvalues,yvalues)*COUNT(xvalues),(w SQRT(w^2 r^2))/r)
How to use animation to make bullet points more interesting in powerpoint
Просмотров 3462 месяца назад
Animate bullet point text in powerpoint to make it look like the text is being written, to change the font color one at a time, or to make bullet points appear one at a time.
How to count the number of times text appears in a cell in excel
Просмотров 2843 месяца назад
=COLUMNS(TEXTSPLIT(A2,"Shirt"))-1 =LAMBDA(range,text,SUM((LEN(range)-LEN(SUBSTITUTE(range,text,"")))/LEN(text)))(A7:A8,"BMC")
Change size and position of data labels using vba in excel
Просмотров 3923 месяца назад
Sub data_labels() Dim s As Series Dim i As Integer Set s = ActiveSheet.ChartObjects("Chart 1").Chart.FullSeriesCollection(1) For i = 1 To s.Points.Count s.Points(i).DataLabel.Width = 130 s.Points(i).DataLabel.Height = 15 s.Points(i).DataLabel.Left = s.Points(i).Left - 130 s.Points(i).DataLabel.Top = s.Points(i).Top - 8 Next i End Sub
How to make a correlation matrix in python
Просмотров 1,7 тыс.3 месяца назад
import pandas as pd import matplotlib.pyplot as plt import seaborn as sns import numpy as np data = pd.read_excel("C:/Users/Karina Adcock/Documents/data analysis/samples/data.xlsx","Sheet1") my_matrix = data.corr(method="spearman").round(2) #my_matrix.style.background_gradient(cmap="Greens") #pd.plotting.scatter_matrix(my_matrix, figsize=(8,8)) my_mask = np.triu(np.ones_like(my_matrix,dtype=boo...
How to change wind in degrees into wind directions in excel
Просмотров 9043 месяца назад
How to change wind in degrees into wind directions in excel
How to sum values based on cell color in excel | 3 methods
Просмотров 9743 месяца назад
How to sum values based on cell color in excel | 3 methods
How to find the closest date in excel
Просмотров 1,2 тыс.4 месяца назад
How to find the closest date in excel
Plot latitude and longitude points on a world map using Flourish
Просмотров 3074 месяца назад
Plot latitude and longitude points on a world map using Flourish
How to get the difference between two dates in excel
Просмотров 6455 месяцев назад
How to get the difference between two dates in excel
How to customise margins in Microsoft Word
Просмотров 1,3 тыс.5 месяцев назад
How to customise margins in Microsoft Word
Add data labels to the last data point in every series in a chart using vba
Просмотров 5635 месяцев назад
Add data labels to the last data point in every series in a chart using vba
How to recreate this nobel prize chart in excel
Просмотров 8486 месяцев назад
How to recreate this nobel prize chart in excel
How to make a powerpoint presentation look more professional using slide master
Просмотров 1,4 тыс.6 месяцев назад
How to make a powerpoint presentation look more professional using slide master
How to change the default pivot table layout in excel
Просмотров 3946 месяцев назад
How to change the default pivot table layout in excel
How to copy files without the folder structure in Windows
Просмотров 2 тыс.7 месяцев назад
How to copy files without the folder structure in Windows
How to make subplots using matplotlib in python
Просмотров 6127 месяцев назад
How to make subplots using matplotlib in python
How to make a split axis in a chart in excel
Просмотров 3,8 тыс.7 месяцев назад
How to make a split axis in a chart in excel
As small RUclipsr who is not yet monetized yet posting similar content I learn a lot from here. Thanks for good the work
Very well to the point explanation. Thank you
How can we connect to u
...and worth every penny. Christmas is no excuse to stop learning. I'm retired but I don't let that stop me. I hope you continue to be so successful and wish you all the best for the future.
Wish you all the best 👌🏾
i luve your accent
bless fantastic thank you
Thank for sharing
I have my chart in its own separate sheet - how can I edit the code to accommodate this? Great video thank you
Thank you for great explanation. Could you please write how to format date data on the graph that it has become by years (as you did in the video) ?
After many teacher finally found you. Thank you
GET TO KNOW JESUS...NOT RELIGION! HE IS SO MISUNDERSTOOD...HE LOVES YOU MORE THAN YOU CAN IMAGINE
This helped so much,thank you
Thank You So Much!!!
Thank you, great advice even though my ears are bleeding.
Thank you for all this much❤❤
I watched several videos as I needed a list of week ending dates and finally figured out that by using your formula of the start date +7 and copying it, I was able to get exactly what I needed!
Quite possibly the best excel tutorial I've seen. THANK YOU!!!
Brilliant video
Brilliant video.
GREAT!
u should eat something to be energetic so ur voice could be raised
Thank you for showing me how to replace in formulae. This is a new > i have learned from you. Pls do keep posting like these new stuffs
This is great, thanks!
Brilliant, thank you
Lately, someone who really understood and was able to explain Spearmans Correlation in Excel... PERFECT ! Thank you very much 🙂
It helps me a lot ordering titles styles.
Brilliant tutorial - thank you very much
Thank you very much for the video. I have to watch it again several times. I will try to understand what I should do if I want multiple parties in this arc-dot chart.
Thanks very useful
I can't imagine I wasted close to 30 mins to create a table of content whiles it could be done in just a minute. Thanks for the video
brilliant lovely lady
Thanks a lot !!!!!
Thanks, for this video <3
That low pitch voice hears funny 😅
if not need to copy the number/text u can just copy and paste as image
Excellent,I am data analyst and I am jobless connect to data analyst assignment.i will appreciate so much
Thankyou
Straight to the point with clear instructions. Thats how a YT tutorial should be...THANK YOU so much..
How did you pull it down after doing that to affect other values
Rt
Totally clear explanation, amazing. Thank you for the tutorial
Quick and Accurate.
👍👍👍👍👍
Great stuff, thanks for sharing!
your voice..
not all heroes wear capes
thank you for this! you really saved my day!! 💗
Excel goddess holy crap
When I press table of contents, it just uses the first heading and nothing else. What to do?
This was an EXCEL-ENT tutorial!! Thank you for creating this video, it gave me a basic start to creating a table of contents. I have questions which is what made this a very good learning experience! 💖