{"id":4016,"date":"2020-01-24T00:02:00","date_gmt":"2020-01-24T05:02:00","guid":{"rendered":"https:\/\/exceltheatre.com\/blog\/?p=4016"},"modified":"2024-11-21T10:52:23","modified_gmt":"2024-11-21T15:52:23","slug":"excel-tweets-roundup-20200124","status":"publish","type":"post","link":"https:\/\/exceltheatre.com\/blog\/archives\/2020\/01\/24\/excel-tweets-roundup-20200124\/","title":{"rendered":"Excel Tweets Roundup 20200124"},"content":{"rendered":"<p>No matter how long you&#8217;ve been using Excel, it can still make you cry sometimes. To feel better, learn a new advanced formula, and sing about Pivot Charts.<\/p>\n<p><!--more--><\/p>\n<h3>This Week\u2019s Tweets<\/h3>\n<p>Here are my favourite Excel tweets, from all the ones that I saw on Twitter this week.<\/p>\n<p>________________________________________________<\/p>\n<blockquote class=\"twitter-tweet\" data-partner=\"tweetdeck\">\n<p dir=\"ltr\" lang=\"en\">After using Excel for 10 years. There is still so much I don&#8217;t know.<\/p>\n<p>\u2014 Pritam Pyaare (@TheGeniusStupid) <a href=\"https:\/\/twitter.com\/TheGeniusStupid\/status\/1220212602938253312?ref_src=twsrc%5Etfw\">January 23, 2020<\/a><\/p><\/blockquote>\n<p><script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p>________________________________________________<\/p>\n<blockquote class=\"twitter-tweet\" data-partner=\"tweetdeck\">\n<p dir=\"ltr\" lang=\"en\">Today at work I hand wrote something instead of making an excel sheet and my supervisor called me barbaric<\/p>\n<p>\u2014 No, I&#8217;m Dirty Dan (@MeganGoss63) <a href=\"https:\/\/twitter.com\/MeganGoss63\/status\/1220063979546075136?ref_src=twsrc%5Etfw\">January 22, 2020<\/a><\/p><\/blockquote>\n<p><script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p>________________________________________________<\/p>\n<blockquote class=\"twitter-tweet\" data-partner=\"tweetdeck\">\n<p dir=\"ltr\" lang=\"en\">Me struggling through this Excel spreadsheet for work. <a href=\"https:\/\/t.co\/hZpKbpRjkw\">pic.twitter.com\/hZpKbpRjkw<\/a><\/p>\n<p>\u2014 King B (@KingB2u_) <a href=\"https:\/\/twitter.com\/KingB2u_\/status\/1220361352293896193?ref_src=twsrc%5Etfw\">January 23, 2020<\/a><\/p><\/blockquote>\n<p><script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p>________________________________________________<\/p>\n<blockquote class=\"twitter-tweet\" data-partner=\"tweetdeck\">\n<p dir=\"ltr\" lang=\"en\">It is staggering to me to think about how much work gets done in big companies by Excel, filling in gaps that IT can&#8217;t reach. And there are no meetings without PowerPoint slides on a wall. Without those 2 applications, our entire economy would collapse tomorrow.<\/p>\n<p>\u2014 David Krider (@DavidKrider1) <a href=\"https:\/\/twitter.com\/DavidKrider1\/status\/1220358735673069575?ref_src=twsrc%5Etfw\">January 23, 2020<\/a><\/p><\/blockquote>\n<p><script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p>________________________________________________<\/p>\n<blockquote class=\"twitter-tweet\" data-partner=\"tweetdeck\">\n<p dir=\"ltr\" lang=\"en\">Me when I work on an excel sheet using only keyboard shortcuts <a href=\"https:\/\/t.co\/qDsgPqmcZj\">pic.twitter.com\/qDsgPqmcZj<\/a><\/p>\n<p>\u2014 b \u00b2 (@_beckstar) <a href=\"https:\/\/twitter.com\/_beckstar\/status\/1220036947974000640?ref_src=twsrc%5Etfw\">January 22, 2020<\/a><\/p><\/blockquote>\n<p><script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p>________________________________________________<\/p>\n<blockquote class=\"twitter-tweet\" data-partner=\"tweetdeck\">\n<p dir=\"ltr\" lang=\"en\">I used a cheat sheet to get through my computing class in college and now I regret it because I forgot to do a lot of things on Excel that I now need for work<\/p>\n<p>\u2014 \u200e\u200eEdith \u200e\u2728 (@valp_edithh) <a href=\"https:\/\/twitter.com\/valp_edithh\/status\/1220030533666627584?ref_src=twsrc%5Etfw\">January 22, 2020<\/a><\/p><\/blockquote>\n<p><script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p>________________________________________________<\/p>\n<blockquote class=\"twitter-tweet\" data-partner=\"tweetdeck\">\n<p dir=\"ltr\" lang=\"en\">When I lost my job in 2012, I learned 10 advanced excel formulas over a weekend on YouTube and became a Retail\/Wholesale planner in a few weeks. Changed my life, immediately added $20k to my salary.<br \/>\nPlease learn some skills on YouTube. It&#8217;s free. <a href=\"https:\/\/t.co\/pEWF8dEFJT\">https:\/\/t.co\/pEWF8dEFJT<\/a><\/p>\n<p>\u2014 Sailor Moon Krystle (@KrystleEmerald) <a href=\"https:\/\/twitter.com\/KrystleEmerald\/status\/1219694969931411458?ref_src=twsrc%5Etfw\">January 21, 2020<\/a><\/p><\/blockquote>\n<p><script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p>________________________________________________<\/p>\n<blockquote class=\"twitter-tweet\" data-partner=\"tweetdeck\">\n<p dir=\"ltr\" lang=\"en\">Put it out of its misery by trying to code in VBA Excel<\/p>\n<p>\u2014 Nerdy Otamatone (@NerdyOtamatone) <a href=\"https:\/\/twitter.com\/NerdyOtamatone\/status\/1219455336849059841?ref_src=twsrc%5Etfw\">January 21, 2020<\/a><\/p><\/blockquote>\n<p><script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p>________________________________________________<\/p>\n<blockquote class=\"twitter-tweet\" data-partner=\"tweetdeck\">\n<p dir=\"ltr\" lang=\"en\">Lol I have to provide a use-case for why I requested Microsoft Office at work&#8230; umm I\u2019m an accountant and we kinda use excel sometimes!? <a href=\"https:\/\/t.co\/gOelDKkbUC\">pic.twitter.com\/gOelDKkbUC<\/a><\/p>\n<p>\u2014 Jake (@jakey_poo13) <a href=\"https:\/\/twitter.com\/jakey_poo13\/status\/1220055734223720448?ref_src=twsrc%5Etfw\">January 22, 2020<\/a><\/p><\/blockquote>\n<p><script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p>________________________________________________<\/p>\n<blockquote class=\"twitter-tweet\" data-partner=\"tweetdeck\">\n<p dir=\"ltr\" lang=\"en\">When I was young I watched &#8220;Top Gun&#8221; and wanted to be a fighter pilot when I grew up, so I&#8217;m not sure which movie I watched between then and now that made me absolutely fired up to work with Excel spreadsheets every day<\/p>\n<p>\u2014 Dad Bod Time Machine (@TimeBod) <a href=\"https:\/\/twitter.com\/TimeBod\/status\/1220043293419024384?ref_src=twsrc%5Etfw\">January 22, 2020<\/a><\/p><\/blockquote>\n<p><script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p>________________________________________________<\/p>\n<blockquote class=\"twitter-tweet\" data-partner=\"tweetdeck\">\n<p dir=\"ltr\" lang=\"en\">my boyfriend FaceTimed my mom at 6 am to teach her excel shortcuts before work and I just <a href=\"https:\/\/t.co\/NMrtj0S7Vl\">pic.twitter.com\/NMrtj0S7Vl<\/a><\/p>\n<p>\u2014 Bri Policarpio (@shortforbrianna) <a href=\"https:\/\/twitter.com\/shortforbrianna\/status\/1220025109127151616?ref_src=twsrc%5Etfw\">January 22, 2020<\/a><\/p><\/blockquote>\n<p><script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p>________________________________________________<\/p>\n<blockquote class=\"twitter-tweet\" data-partner=\"tweetdeck\">\n<p dir=\"ltr\" lang=\"en\">Always said my dream career is in research but today I&#8217;ve been brought to tears 3 times while trying to make a bar chart in excel so maybe it&#8217;s time for a rethink<\/p>\n<p>\u2014 amz (@amyrebeccaw__) <a href=\"https:\/\/twitter.com\/amyrebeccaw__\/status\/1220032917700796416?ref_src=twsrc%5Etfw\">January 22, 2020<\/a><\/p><\/blockquote>\n<p><script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p>________________________________________________<\/p>\n<blockquote class=\"twitter-tweet\" data-partner=\"tweetdeck\">\n<p dir=\"ltr\" lang=\"en\">Guys I have 2 more hours of work and can I just say they don&#8217;t organise ANYTHING and they print so much in paper?? Yall can use excel and not kill trees <a href=\"https:\/\/t.co\/YFPDRIQ41e\">pic.twitter.com\/YFPDRIQ41e<\/a><\/p>\n<p>\u2014 elisaaaaa (@elisathereina) <a href=\"https:\/\/twitter.com\/elisathereina\/status\/1220267557388599296?ref_src=twsrc%5Etfw\">January 23, 2020<\/a><\/p><\/blockquote>\n<p><script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p>________________________________________________<\/p>\n<blockquote class=\"twitter-tweet\" data-partner=\"tweetdeck\">\n<p dir=\"ltr\" lang=\"en\">If you work with Excel at all, I think it&#8217;s important that you know that the word &#8220;Pivotchart&#8221; can be sung perfectly to the tune of &#8220;Baby Shark&#8221;.<\/p>\n<p>I have to live with that knowledge, now you do too, enjoy trying to unhear it when you&#8217;re working~<\/p>\n<p>\u2014 exCeeDingly fluffy (@seadragom) <a href=\"https:\/\/twitter.com\/seadragom\/status\/1220343398353330176?ref_src=twsrc%5Etfw\">January 23, 2020<\/a><\/p><\/blockquote>\n<p><script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<h3>Video: Pivot Chart Number Format<\/h3>\n<p>When you create a pivot chart from a pivot table, the numbers on the chart&#8217;s axis have the same number format as the pivot table&#8217;s numbers.<\/p>\n<p>This short video shows the steps for changing the pivot chart number format, and there are <a href=\"https:\/\/www.contextures.com\/excelpivotchartnumberformat.html\" target=\"_blank\" rel=\"noopener\">written steps on the Contextures site<\/a>.<\/p>\n<p><iframe loading=\"lazy\" title=\"Change Pivot Chart Number Format\" width=\"840\" height=\"473\" src=\"https:\/\/www.youtube.com\/embed\/s3u9D55A6jI?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p><strong>Video Timeline:<\/strong><\/p>\n<ul>\n<li>0:00 Introduction<\/li>\n<li>0:22 Create a Pivot Chart<\/li>\n<li>0:41 Change Number Format<\/li>\n<li>1:16 Number Format Chart Only<\/li>\n<li>1:35 Number Options<\/li>\n<li>1:53 Custom Number Format<\/li>\n<li>2:36 Get the Workbook<\/li>\n<\/ul>\n<p>________________________________________________<\/p>\n<h3>Excel Tweets Roundup<\/h3>\n<p>Thanks for reading this week&#8217;s Excel tweets roundup, and did you have a favourite?<\/p>\n<p>Pivot Chart, doo doo doo doo doo doo<\/p>\n<p><a href=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2020\/01\/exceltwitter20200124a.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"exceltwitter20200124a\" src=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2020\/01\/exceltwitter20200124a_thumb.jpg\" alt=\"exceltwitter20200124a\" width=\"400\" height=\"400\" border=\"0\" \/><\/a><\/p>\n<p>________________________________________________<\/p>\n<p><a href=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2020\/01\/exceltwitter20200124b.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border: 0px currentcolor; display: inline; background-image: none;\" title=\"Pivot Chart, doo doo doo doo doo doo\" src=\"https:\/\/exceltheatre.com\/blog\/wp-content\/uploads\/2020\/01\/exceltwitter20200124b_thumb.jpg\" alt=\"Pivot Chart, doo doo doo doo doo doo\" width=\"400\" height=\"200\" border=\"0\" \/><\/a><\/p>\n<p>________________________________________________<\/p>\n","protected":false},"excerpt":{"rendered":"<p>No matter how long you&#8217;ve been using Excel, it can still make you cry sometimes. To feel better, learn a new advanced formula, and sing about Pivot Charts.<\/p>\n","protected":false},"author":2,"featured_media":4014,"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":[16],"tags":[],"class_list":["post-4016","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-humor"],"_links":{"self":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4016","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=4016"}],"version-history":[{"count":5,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4016\/revisions"}],"predecessor-version":[{"id":4580,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4016\/revisions\/4580"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media\/4014"}],"wp:attachment":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media?parent=4016"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/categories?post=4016"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/tags?post=4016"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}