EXCEL TUTORIAL - creating a pace / speed athletics spreadsheet using FLASH FILL

Ben Ryder

Подписаться 17 тыс.

Просмотров 33 тыс.

50% 1

Видео Поделиться Скачать Добавить в

Опубликовано:

22 июн 2017

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 23

@mateuswitiski5263 10 месяцев назад

Thanks for this. Way more useful than most running log sheets out there

@Lumencraft- 4 месяца назад

Best excel tutorial ever!! Thank you.

@BrahimBessrour 15 дней назад

Thanks for sharing

@timwilson1974 5 лет назад

Thanks for this Ben - Very helpful at getting to the point and providing the solution.

@upward-trend 4 года назад

Great info thanks. I did not know about flash fill. Another and easier way to get average speed is to directly convert pace to speed. To do this insert the formula =1/(H2*24) into cell I2

@8strings 5 лет назад

Thank you very much Ben. You are a genius.

@prvdev 3 года назад

not all heroes wear capes

@benjohnston7742 4 года назад

Your a hero the fraction of a day thing saved hours of work

@CuteNoririn 5 лет назад

This is awesome, it works! thank you!

@earlymorningproductions9355 4 года назад

Brilliant! Thank you!

@averagenorserunner2907 3 года назад

Very helpful, and well explained. Thanks!

@allanpark6046 4 года назад

Excellent. Thank you.

@mattdriver9763 4 года назад

This was really helpful, how would you then plot the pace on a graph?

@jamesbcd 6 лет назад

Helpful thanks

@martinvalach7550 2 года назад

Thanks!

@manonvito7020 4 года назад

thank you

@heeravishwanath6339 4 года назад

Can you please share the sample Excel file?

@suly4346 2 года назад

The problem is that some of my races are in miles AND Kilometres so how do I do this without creating two separate columns

@benaryder 2 года назад

I don't believe there is a way of specifying the unit in the cell. I'd split into two columns and convert into km

@marcelvannieuwenhuizen5828 2 года назад

Hi Can I ask, I want you use min, sec and milliseconds, how can I do this?

@benaryder 2 года назад

At 0:55 when you format the time cell, use the format mm:ss.000 (if you truly do want milliseconds. For centiseconds, you'd use mm:ss.00)

@marcelvannieuwenhuizen5828 2 года назад

@@benaryder Hi Ben Thank you for replying. After some playing around and reading post I eventually got to that conclusion, only to run into another. I am using excel and looking at the following problem as soon as I enter my mm:ss,000 it shows the rounded of sec in the formula bar, as soos as I try to correct it or press enter the rounded of sec are used and I loose my real millisecond value. It seams like many people have experienced it before.