Тёмный
Toms Data World
Toms Data World
Toms Data World
Подписаться
Here is where you will come to learn all about how to use data to make our world better
SQL, Excel, Process
Proof that the election IS RIGGED !!!
3:57
14 дней назад
Excel Tables
10:23
21 день назад
Lookups
12:41
Месяц назад
Excel's wonderful IF statment
12:16
Месяц назад
Text To Columns
5:18
2 месяца назад
M5L1   Text Functions
13:11
2 месяца назад
TIME to build a clock in Excel!
23:18
2 месяца назад
M4L5 Aggregation functions
11:39
2 месяца назад
M4L4   Named Ranges
5:56
2 месяца назад
M4L3   Absolute Referencing
9:25
2 месяца назад
M4L2 Function Builder
13:47
2 месяца назад
M4L1   Formula Basics
4:33
2 месяца назад
M3L6 Conditional Formatting
16:20
2 месяца назад
M3L5 Formating Borders
9:32
2 месяца назад
M3L4 Formatting Dates
5:11
2 месяца назад
M3L3 Formatting Numbers
7:50
2 месяца назад
M3L2 FormatAlignment
5:51
2 месяца назад
M3L1 FormatFonts
8:31
2 месяца назад
M2L5 PasteSpecial
9:02
2 месяца назад
M2L4 Filtering
11:02
2 месяца назад
M2L2 Freeze Panes
3:44
2 месяца назад
M2L3 Sorting
8:23
2 месяца назад
M2L1 Insert Delete
5:59
2 месяца назад
Комментарии
@EricHartwigExcelConsulting
@EricHartwigExcelConsulting 20 дней назад
Great video! thank you creating/sharing! I am a serious fan of tables, named ranges, and all of the awesome things you can do with them and I think this is a great overview of some of the things you can do with tables.
@usmaniqbal1836
@usmaniqbal1836 22 дня назад
Perfect 👍 please share data file for practice.
@TomsDataWorld
@TomsDataWorld 20 дней назад
Hello! Thanks for the feedback! I am somewhat new to GitHub, BUT I put the example files here github.com/Thinkleclt/ExcelCafe Should be public, you need : 05 Advanced Formulas. let me know if that doesn't work Tom
@EricHartwigExcelConsulting
@EricHartwigExcelConsulting Месяц назад
Thank you for creating/sharing this video! Great examples! Index & Match are two of my favorite functions! Although more recently I am using LET, FILTER, and LAMBDA which are a blast to use all together!
@TomsDataWorld
@TomsDataWorld Месяц назад
Hey Eric, thanks for watching it! I've done some work with LET and LAMBDA. Definitely cool, but I have not come up with a great use case for them.
@EricHartwigExcelConsulting
@EricHartwigExcelConsulting 11 дней назад
@@TomsDataWorld Challenge accepted!
@aman_mashetty5185
@aman_mashetty5185 2 месяца назад
Great video..!! best part the calculation for seconds and minute
@TomsDataWorld
@TomsDataWorld 2 месяца назад
I was actually a little surprised at how tricky it was, BUT also really fun to figure it out. Glad you enjoyed it!
@mearnest91
@mearnest91 2 месяца назад
Super clear
@jessebee4335
@jessebee4335 3 месяца назад
Wow! What a great tip. I've actually seen these before but it was a long time ago and I'd forgotten all about this neat trick.
@whowhatwhenwhyhow9265
@whowhatwhenwhyhow9265 6 месяцев назад
Great videos and teacher. Thank you
@seyiabayomi
@seyiabayomi 7 месяцев назад
Great video. This is the first time I've seen this approach.
@TomsDataWorld
@TomsDataWorld 7 месяцев назад
Awesome thanks! And beleive me.. it came from experience. I learned the hard way how resource intensive unions CAN be. Let me know if you want to learn about any other database topics
@TomsDataWorld
@TomsDataWorld 7 месяцев назад
Thanks for the feedback Sarah!!
@mearnest91
@mearnest91 7 месяцев назад
Very clear explanation - this is great
@TomsDataWorld
@TomsDataWorld 7 месяцев назад
Glad you like it!
@sarahqmangrum
@sarahqmangrum 7 месяцев назад
Thanks for sharing! Straight forward explanation with easy to follow examples.
@TomsDataWorld
@TomsDataWorld 7 месяцев назад
Thanks Sarah! and thanks for the inspiration!
@mearnest91
@mearnest91 7 месяцев назад
Tom, this is an excellent crash course. Thank you.
@mearnest91
@mearnest91 7 месяцев назад
Great tip!
@TomsDataWorld
@TomsDataWorld 7 месяцев назад
Glad you liked it! Keep watching!!
@seyiabayomi
@seyiabayomi 8 месяцев назад
Thanks for sharing and keep up the good work. In the coming videos, will you share the file(s) so viewers can follow along?
@TomsDataWorld
@TomsDataWorld 8 месяцев назад
Hello David! Thank you for the feedback! I am building this course out in RU-vid so you get to be along for the ride, buy you are correct! The file is key. I have added it to my teachable site as a free download. Let me know if you have any issues.
@kajodata
@kajodata 8 месяцев назад
Really cool and simply explained!