Karina Adcock
Karina Adcock
  • Видео 375
  • Просмотров 16 930 942

Видео

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/
How to format a doughnut chart in excel
Просмотров 19021 день назад
Make progress charts 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 make a stripe chart in excel
Просмотров 3764 месяца назад
How to make a stripe chart in excel
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
Geometric mean regression in excel
Просмотров 3925 месяцев назад
Geometric mean regression in excel
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

Комментарии

  • @learningtogetheredu
    @learningtogetheredu День назад

    As small RUclipsr who is not yet monetized yet posting similar content I learn a lot from here. Thanks for good the work

  • @myaccess-e7l
    @myaccess-e7l День назад

    Very well to the point explanation. Thank you

  • @pushkarkushwah2128
    @pushkarkushwah2128 День назад

    How can we connect to u

  • @ianl1052
    @ianl1052 День назад

    ...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.

  • @mobarnawi9617
    @mobarnawi9617 2 дня назад

    Wish you all the best 👌🏾

  • @wtfashokjr
    @wtfashokjr 2 дня назад

    i luve your accent

  • @adamshenk9970
    @adamshenk9970 2 дня назад

    bless fantastic thank you

  • @angthanhngoc9329
    @angthanhngoc9329 3 дня назад

    Thank for sharing

  • @milesbaker4686
    @milesbaker4686 3 дня назад

    I have my chart in its own separate sheet - how can I edit the code to accommodate this? Great video thank you

  • @nataliiabudeniuk2193
    @nataliiabudeniuk2193 4 дня назад

    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) ?

  • @mifeijoo
    @mifeijoo 4 дня назад

    After many teacher finally found you. Thank you

  • @JoshuaAugustin-e6y
    @JoshuaAugustin-e6y 5 дней назад

    GET TO KNOW JESUS...NOT RELIGION! HE IS SO MISUNDERSTOOD...HE LOVES YOU MORE THAN YOU CAN IMAGINE

  • @julietdzikolo1060
    @julietdzikolo1060 5 дней назад

    This helped so much,thank you

  • @AMIRFAISALSaufi
    @AMIRFAISALSaufi 5 дней назад

    Thank You So Much!!!

  • @kahunamatata2045
    @kahunamatata2045 6 дней назад

    Thank you, great advice even though my ears are bleeding.

  • @mamadolay5986
    @mamadolay5986 6 дней назад

    Thank you for all this much❤❤

  • @jimklasinski7558
    @jimklasinski7558 6 дней назад

    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!

  • @annaevatt
    @annaevatt 6 дней назад

    Quite possibly the best excel tutorial I've seen. THANK YOU!!!

  • @kwamesherrifawiagah6312
    @kwamesherrifawiagah6312 7 дней назад

    Brilliant video

  • @kwamesherrifawiagah6312
    @kwamesherrifawiagah6312 7 дней назад

    Brilliant video.

  • @josebiscaia670
    @josebiscaia670 7 дней назад

    GREAT!

  • @user-uz2gj7nn7j
    @user-uz2gj7nn7j 8 дней назад

    u should eat something to be energetic so ur voice could be raised

  • @GopiKrish895
    @GopiKrish895 8 дней назад

    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

  • @son3rd285
    @son3rd285 8 дней назад

    This is great, thanks!

  • @barrywagoner5191
    @barrywagoner5191 8 дней назад

    Brilliant, thank you

  • @BjornLaskowski
    @BjornLaskowski 9 дней назад

    Lately, someone who really understood and was able to explain Spearmans Correlation in Excel... PERFECT ! Thank you very much 🙂

  • @raducomsuta1982
    @raducomsuta1982 9 дней назад

    It helps me a lot ordering titles styles.

  • @mbadiou
    @mbadiou 9 дней назад

    Brilliant tutorial - thank you very much

  • @smithlo4092
    @smithlo4092 9 дней назад

    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.

  • @GhumroQadir
    @GhumroQadir 10 дней назад

    Thanks very useful

  • @roderickjonathan7495
    @roderickjonathan7495 10 дней назад

    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

  • @samaelnemo
    @samaelnemo 11 дней назад

    brilliant lovely lady

  • @junglee62
    @junglee62 11 дней назад

    Thanks a lot !!!!!

  • @reelsigfaahi
    @reelsigfaahi 11 дней назад

    Thanks, for this video <3

  • @varunr8322
    @varunr8322 11 дней назад

    That low pitch voice hears funny 😅

  • @rahmadsaleh86
    @rahmadsaleh86 12 дней назад

    if not need to copy the number/text u can just copy and paste as image

  • @stephenrono-ck3bu
    @stephenrono-ck3bu 12 дней назад

    Excellent,I am data analyst and I am jobless connect to data analyst assignment.i will appreciate so much

  • @gopubr
    @gopubr 12 дней назад

    Thankyou

  • @sahilaggarwal2835
    @sahilaggarwal2835 13 дней назад

    Straight to the point with clear instructions. Thats how a YT tutorial should be...THANK YOU so much..

  • @uduakakpan2980
    @uduakakpan2980 13 дней назад

    How did you pull it down after doing that to affect other values

  • @ahyathartono7765
    @ahyathartono7765 13 дней назад

    Totally clear explanation, amazing. Thank you for the tutorial

  • @muhammadzakiahmad8069
    @muhammadzakiahmad8069 14 дней назад

    Quick and Accurate.

  • @pmpbatais1196
    @pmpbatais1196 15 дней назад

    👍👍👍👍👍

  • @cybu6466
    @cybu6466 15 дней назад

    Great stuff, thanks for sharing!

  • @jean7589
    @jean7589 16 дней назад

    your voice..

  • @bende8638
    @bende8638 17 дней назад

    not all heroes wear capes

  • @user-yl3yl3vd8g
    @user-yl3yl3vd8g 17 дней назад

    thank you for this! you really saved my day!! 💗

  • @bidhangtm1250
    @bidhangtm1250 17 дней назад

    Excel goddess holy crap

  • @ImperialAssassi4U
    @ImperialAssassi4U 17 дней назад

    When I press table of contents, it just uses the first heading and nothing else. What to do?

  • @quietkayoss
    @quietkayoss 18 дней назад

    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! 💖