{"id":4365,"date":"2022-03-25T00:01:00","date_gmt":"2022-03-25T04:01:00","guid":{"rendered":"https:\/\/exceltheatre.com\/blog\/?p=4365"},"modified":"2022-03-23T15:10:31","modified_gmt":"2022-03-23T19:10:31","slug":"fun-with-excel-magic-tricks-on-tiktok","status":"publish","type":"post","link":"https:\/\/exceltheatre.com\/blog\/archives\/2022\/03\/25\/fun-with-excel-magic-tricks-on-tiktok\/","title":{"rendered":"Fun With Excel Magic Tricks on TikTok"},"content":{"rendered":"<p>If you use TikTok, have you stumbled across any Microsoft Excel tip videos yet? It&#8217;s a fun way to pick up a few new Excel tips and tricks for your spreadsheet toolkit!<\/p>\n<p><!--more--><\/p>\n<h3>Miss Excel<\/h3>\n<p>The first Excel TikTok-er that I heard about was <a href=\"https:\/\/www.tiktok.com\/@miss.excel\">Miss Excel<\/a> (Kat Norton). She has over 765K followers on TikTok, and her videos have 1.5M likes! It&#8217;s great to see so many people enjoying Excel tips and tricks!<\/p>\n<p>In her popular TikTok videos, Miss Excel doesn&#8217;t just show you a handy, but boring, Excel trick. Instead, she uses music, humour, props and dancing, to entertain you, while showing you that shortcut or tip.<\/p>\n<h3>Excel Magic<\/h3>\n<p>For example, in this short video, Miss Excel shows you the &#8220;magic&#8221; of the Alt key shortcuts in Excel.<\/p>\n<blockquote class=\"tiktok-embed\" style=\"min-width: 325px; max-width: 605px;\" cite=\"https:\/\/www.tiktok.com\/@miss.excel\/video\/7061276721269525806\" data-video-id=\"7061276721269525806\">\n<section><a title=\"@miss.excel\" href=\"https:\/\/www.tiktok.com\/@miss.excel\" target=\"_blank\" rel=\"noopener\">@miss.excel<\/a> Excel Magic with the Alt keys <a title=\"howto\" href=\"https:\/\/www.tiktok.com\/tag\/howto\" target=\"_blank\" rel=\"noopener\">#howto<\/a> <a title=\"\u266c Abracadabra - Qveen Herby - Clip - Abracadabra\" href=\"https:\/\/www.tiktok.com\/music\/Abracadabra-Qveen-Herby-Clip-7019219640208099330\" target=\"_blank\" rel=\"noopener\">\u266c Abracadabra &#8211; Qveen Herby &#8211; Clip &#8211; Abracadabra<\/a><\/section>\n<\/blockquote>\n<p><script async=\"\" src=\"https:\/\/www.tiktok.com\/embed.js\"><\/script><\/p>\n<h3>Excel Mistakes<\/h3>\n<p>Miss Excel can also show you what you should NOT do in Excel. In this video, she shows 4 common Excel mistakes:<\/p>\n<ol>\n<li>Forget Absolute References<\/li>\n<li>Columns too thin for data<\/li>\n<li>Paste Hidden cells<\/li>\n<li>More than 1 piece of data in cell<\/li>\n<\/ol>\n<p>That list might look boring, but the TikTok video makes it fun!<\/p>\n<blockquote class=\"tiktok-embed\" style=\"min-width: 325px; max-width: 605px;\" cite=\"https:\/\/www.tiktok.com\/@miss.excel\/video\/7007874094028836102\" data-video-id=\"7007874094028836102\">\n<section><a title=\"@miss.excel\" href=\"https:\/\/www.tiktok.com\/@miss.excel\" target=\"_blank\" rel=\"noopener\">@miss.excel<\/a> Don\u2019t make these Excel Mistakes! \u200d\u2640\ufe0f <a title=\"excel\" href=\"https:\/\/www.tiktok.com\/tag\/excel\" target=\"_blank\" rel=\"noopener\">#excel<\/a> <a title=\"learnontiktok\" href=\"https:\/\/www.tiktok.com\/tag\/learnontiktok\" target=\"_blank\" rel=\"noopener\">#learnontiktok<\/a> <a title=\"tiktokpartner\" href=\"https:\/\/www.tiktok.com\/tag\/tiktokpartner\" target=\"_blank\" rel=\"noopener\">#tiktokpartner<\/a> <a title=\"learnhow\" href=\"https:\/\/www.tiktok.com\/tag\/learnhow\" target=\"_blank\" rel=\"noopener\">#learnhow<\/a> <a title=\"\u266c Dj maybach 9 - Jay Parker\" href=\"https:\/\/www.tiktok.com\/music\/Dj-maybach-9-6964449252240100101\" target=\"_blank\" rel=\"noopener\">\u266c Dj maybach 9 &#8211; Jay Parker<\/a><\/section>\n<\/blockquote>\n<p><script async=\"\" src=\"https:\/\/www.tiktok.com\/embed.js\"><\/script><\/p>\n<h3>Quick Excel Lessons<\/h3>\n<p>You can learn about Excel functions and features from Miss Excel&#8217;s quick lessons too.<\/p>\n<p>In this video, she shows a quick example of combining text from two cell, and putting a space character between them.<\/p>\n<p><strong>Note<\/strong>: This uses the TEXTJOIN function, which is available in Excel 365, but not in older versions of Excel.<\/p>\n<blockquote class=\"tiktok-embed\" style=\"min-width: 325px; max-width: 605px;\" cite=\"https:\/\/www.tiktok.com\/@miss.excel\/video\/6962248211734023430\" data-video-id=\"6962248211734023430\">\n<section><a title=\"@miss.excel\" href=\"https:\/\/www.tiktok.com\/@miss.excel\" target=\"_blank\" rel=\"noopener\">@miss.excel<\/a> Make your cells come together! <a title=\"excel\" href=\"https:\/\/www.tiktok.com\/tag\/excel\" target=\"_blank\" rel=\"noopener\">#excel<\/a> <a title=\"learnontiktok\" href=\"https:\/\/www.tiktok.com\/tag\/learnontiktok\" target=\"_blank\" rel=\"noopener\">#learnontiktok<\/a> <a title=\"tiktokpartner\" href=\"https:\/\/www.tiktok.com\/tag\/tiktokpartner\" target=\"_blank\" rel=\"noopener\">#tiktokpartner<\/a> <a title=\"\u266c Come Together - Gary Clark Jr.\" href=\"https:\/\/www.tiktok.com\/music\/Come-Together-6490383143467109133\" target=\"_blank\" rel=\"noopener\">\u266c Come Together &#8211; Gary Clark Jr.<\/a><\/section>\n<\/blockquote>\n<p><script async=\"\" src=\"https:\/\/www.tiktok.com\/embed.js\"><\/script><\/p>\n<h3>Video: Get Started with TEXTJOIN Function<\/h3>\n<p>If you&#8217;re not on TikTok, or if you&#8217;d like a more detailed explanation, see <a href=\"https:\/\/www.contextures.com\/xlcombine01.html\">the TEXTJOIN function examples on my Contextures site<\/a>.<\/p>\n<p>In this screen show, the formula combines all the weekday names, with a &#8220;comma &amp; space&#8221; separator, and it ignores any blank cells.<\/p>\n<ul>\n<li><strong>=TEXTJOIN(&#8220;, &#8220;,TRUE,A2:A8)<\/strong><\/li>\n<\/ul>\n<p><a href=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2022\/03\/textjoindays04.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"TEXTJOIN function example list of weekdays\" src=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2022\/03\/textjoindays04_thumb.png\" alt=\"TEXTJOIN function example list of weekdays\" width=\"425\" height=\"275\" border=\"0\" \/><\/a><\/p>\n<p>You can watch my short video below, that goes step-by-step, to help you get started with the Excel TEXTJOIN function.<\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/9SrKn1tDSaw?rel=0\" width=\"450\" height=\"283\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<h3>More TEXTJOIN Examples<\/h3>\n<p>And after you&#8217;re comfortable with the TEXTJOIN basics, this video shows a more advanced example of combining text with a formula.<\/p>\n<p>Instead of combining all the cells, the formula checks for specific criteria within the selected data range.<\/p>\n<p>There are sample files for both videos on <a href=\"https:\/\/www.contextures.com\/xlcombine01.html\">the Combine Text in Excel page<\/a>, on my Contextures site.<\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/E9G8LB0MMY8?rel=0\" width=\"450\" height=\"283\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>____________________<\/p>\n<h3>Fun With Excel Magic Tricks on TikTok<\/h3>\n<p><a href=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2022\/03\/excelmagictiktok01b.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"Fun With Excel Magic Tricks on TikTok\" src=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2022\/03\/excelmagictiktok01b_thumb.jpg\" alt=\"Fun With Excel Magic Tricks on TikTok\" width=\"400\" height=\"200\" border=\"0\" \/><\/a><\/p>\n<p>____________________<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you use TikTok, have you stumbled across any Microsoft Excel tip videos yet? It&#8217;s a fun way to pick up a few new Excel tips and tricks for your spreadsheet toolkit!<\/p>\n","protected":false},"author":2,"featured_media":4363,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_kadence_starter_templates_imported_post":false,"footnotes":""},"categories":[23],"tags":[],"class_list":["post-4365","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tips"],"_links":{"self":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4365","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/comments?post=4365"}],"version-history":[{"count":3,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4365\/revisions"}],"predecessor-version":[{"id":4370,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4365\/revisions\/4370"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media\/4363"}],"wp:attachment":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media?parent=4365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/categories?post=4365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/tags?post=4365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}