In this video we look at an Excel feature that should be more popular. Unfortunately, the advanced nature and unusual behavior of structured references make Excel Tables difficult for many users.
I explain the reason that Table formulas can cause so much confusion and inconsistency with formulas. And I share best practices on when to use Tables versus when to avoid them. DOWNLOAD THE WORKBOOK ► https://www.excelcampus.com/tables/st...
🔗LINKS
🔎 Get free weekly Excel tips: https://www.excelcampus.com/newsletter/
💡 Free 60-minute Excel training session:
📖 Join Our Comprehensive Excel Training Program: https://www.excelcampus.com/elevate
00:00 Introduction
01:15 Structured Referencing
02:45 Corporate Budgeting Example
06:03 When to use Tables
06:47 Possible Solutions
Поделиться в:
Доступные форматы для скачивания:
Скачать видео mp4
Информация по загрузке:
Скачать аудио mp3
Похожие видео
array(10) {
[0]=>
object(stdClass)#5246 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "PxwTV2Aiar4"
["related_video_title"]=>
string(53) "5 Excel Secrets You'll Be Embarrassed You Didn't Know"
["posted_time"]=>
string(19) "1 год назад"
["channelName"]=>
string(18) "Excel Campus - Jon"
}
[1]=>
object(stdClass)#5219 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "7jF62HvHG3Q"
["related_video_title"]=>
string(49) "Say Goodbye to IF Statements in Excel with SWITCH"
["posted_time"]=>
string(19) "1 год назад"
["channelName"]=>
string(14) "Teacher's Tech"
}
[2]=>
object(stdClass)#5244 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "a3-nkc_VUF0"
["related_video_title"]=>
string(123) "Эти ОШИБКИ совершает КАЖДЫЙ новичок в Excel. Избавься от них НАВСЕГДА!"
["posted_time"]=>
string(25) "2 недели назад"
["channelName"]=>
string(54) "Эксперт ЭКСЕЛЬ и ГУГЛ-ТАБЛИЦЫ"
}
[3]=>
object(stdClass)#5251 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "OunPCgWRrSc"
["related_video_title"]=>
string(42) "Avoid this Costly XLOOKUP Mistake in Excel"
["posted_time"]=>
string(28) "10 месяцев назад"
["channelName"]=>
string(18) "Excel Campus - Jon"
}
[4]=>
object(stdClass)#5230 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "D1Sr_Y7V74s"
["related_video_title"]=>
string(43) "What Excel AI Should You Use? A Quick Guide"
["posted_time"]=>
string(25) "2 недели назад"
["channelName"]=>
string(17) "Accounting Digest"
}
[5]=>
object(stdClass)#5248 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "lyE0izBxzxY"
["related_video_title"]=>
string(47) "Microsoft Excel - Dynamic Structured References"
["posted_time"]=>
string(19) "1 год назад"
["channelName"]=>
string(4) "BCTI"
}
[6]=>
object(stdClass)#5243 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "_5z-oaPET7A"
["related_video_title"]=>
string(93) "Ты забудешь слово РАБОТА. ChatGPT + Excel (Эксель + Чат ГПТ)"
["posted_time"]=>
string(27) "8 месяцев назад"
["channelName"]=>
string(34) "Никита и Нейросети"
}
[7]=>
object(stdClass)#5253 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "4fezP875xOQ"
["related_video_title"]=>
string(59) "4 Hours Chopin for Studying, Concentration & Relaxation"
["posted_time"]=>
string(21) "3 года назад"
["channelName"]=>
string(12) "HALIDONMUSIC"
}
[8]=>
object(stdClass)#5229 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "4Oaveqn2YwY"
["related_video_title"]=>
string(125) "Эти 5 СЕКРЕТНЫХ функций в Excel НИКТО не использует. Вот, что они делают!"
["posted_time"]=>
string(25) "4 недели назад"
["channelName"]=>
string(54) "Эксперт ЭКСЕЛЬ и ГУГЛ-ТАБЛИЦЫ"
}
[9]=>
object(stdClass)#5247 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "B90uiETo9OI"
["related_video_title"]=>
string(71) "Нечеткая текстовая кластеризация в Excel"
["posted_time"]=>
string(21) "7 дней назад"
["channelName"]=>
string(14) "Nikolay Pavlov"
}
}
