{"id":4477,"date":"2015-12-24T12:59:38","date_gmt":"2015-12-24T12:59:38","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/wp\/?p=4477"},"modified":"2017-09-05T12:09:41","modified_gmt":"2017-09-05T12:09:41","slug":"wish-you-happy-holidays","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/","title":{"rendered":"Wish you Merry Christmas & happy Holidays"},"content":{"rendered":"
\"Happy

Happy Holidays<\/p><\/div>\n

To wish you and your family a very Happy Holidays and Merry Christmas, I have prepared an Animated Christmas tree lights with snow man, snow flakes etc. in excel sheet with the help of simple bubble graphs, formulas and a simple VBA code to Start and Stop the animation. Wish you a very Happy Holidays and Merry Christmas !! Enjoy and have fun with this animated Christmas tree \ud83d\ude42<\/p>\n

Inspiration to make this awesome thing in Excel came from THE EXCEL (Graphs, Charts, Dashboards etc.) GURU CHANDOO.<\/a> Though this is not as awesome as Chandoo make them in Excel using graphs etc. You can refer his blog to become awesome in excel “as his tag line says…Become awesome in Excel :). Thanks Chandoo for coming up with so many great ideas and tips always.<\/p>\n

Downaload this excel sheet to play with this cool Christmas animation and enjoy your holiday period<\/a><\/h2>\n

\nProvide your feedback, how did you find this piece of work \ud83d\ude42
\n<\/strong><\/p>\n

For those who are interested in seeing how it was made… here is a brief description about it..<\/p>\n

How is it made? <\/h3>\n

Stars, Balls and Bells:<\/h2>\n

1. All the Stars, Shining Bells etc, are made using 3-D Bubble graph.
\n2. For bells, stars etc., to oscillate on a circular path like a pendulum, I have taken x and Y axis using formula y= SQRT((ABS(1-x*x))).
\n3. To give them a look of Stars, Balls and Bells, I have uploaded pictures in the Bubble graph rather than filling different colors.
\n3. To oscillate on specific time interval, I have used a VBA code.<\/p>\n

Glowing Bulbs<\/h2>\n

1. Glowing bulbs are also created using Bubble Graph.
\n2. To make them glow in different size, I have used RAND() key to generate random size number.
\n3. I have embedded 2 different colors of bulb picture in the Bubble graph and added a glow outside of them.<\/p>\n

Snow flakes Background <\/h2>\n

Using simple REPT() and RANDBETWEEN() formula, I have displayed different characters like, Snow man, Snow Flakes etc in different cells in whole background.<\/p>\n<\/span>","protected":false},"excerpt":{"rendered":"

To wish you and your family a very Happy Holidays and Merry Christmas, I have prepared an Animated Christmas tree lights with snow man, snow flakes etc. in excel sheet with the help of simple bubble graphs, formulas and a simple VBA code to Start and Stop the animation. Wish you a very Happy Holidays […]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1672,1681],"tags":[],"class_list":["post-4477","post","type-post","status-publish","format-standard","hentry","category-excel-formula","category-personal"],"yoast_head":"\nWish you Merry Christmas & happy Holidays - Let's excel in Excel<\/title>\n<meta name=\"description\" content=\"An Animated Christmas tree lights with snow man, snow flakes etc. in excel sheet to wish you Merry Christmas and Happy Holidays. Enjoy and have fun with this animated Christmas tree :)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wish you Merry Christmas & happy Holidays\" \/>\n<meta property=\"og:description\" content=\"An Animated Christmas tree lights with snow man, snow flakes etc. in excel sheet to wish you Merry Christmas and Happy Holidays. Enjoy and have fun with this animated Christmas tree :)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2015-12-24T12:59:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-09-05T12:09:41+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2015\/12\/Happy-Holidays-300x217.png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Wish you Merry Christmas & happy Holidays\",\"datePublished\":\"2015-12-24T12:59:38+00:00\",\"dateModified\":\"2017-09-05T12:09:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/\"},\"wordCount\":346,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/12\/Happy-Holidays-300x217.png\",\"articleSection\":[\"Excel Formula\",\"Personal\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/\",\"name\":\"Wish you Merry Christmas & happy Holidays - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/12\/Happy-Holidays-300x217.png\",\"datePublished\":\"2015-12-24T12:59:38+00:00\",\"dateModified\":\"2017-09-05T12:09:41+00:00\",\"description\":\"An Animated Christmas tree lights with snow man, snow flakes etc. in excel sheet to wish you Merry Christmas and Happy Holidays. Enjoy and have fun with this animated Christmas tree :)\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/12\/Happy-Holidays-300x217.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/12\/Happy-Holidays-300x217.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Formula\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-formula\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Wish you Merry Christmas & happy Holidays\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Wish you Merry Christmas & happy Holidays - Let's excel in Excel","description":"An Animated Christmas tree lights with snow man, snow flakes etc. in excel sheet to wish you Merry Christmas and Happy Holidays. Enjoy and have fun with this animated Christmas tree :)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/","og_locale":"en_US","og_type":"article","og_title":"Wish you Merry Christmas & happy Holidays","og_description":"An Animated Christmas tree lights with snow man, snow flakes etc. in excel sheet to wish you Merry Christmas and Happy Holidays. Enjoy and have fun with this animated Christmas tree :)","og_url":"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2015-12-24T12:59:38+00:00","article_modified_time":"2017-09-05T12:09:41+00:00","og_image":[{"url":"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2015\/12\/Happy-Holidays-300x217.png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Wish you Merry Christmas & happy Holidays","datePublished":"2015-12-24T12:59:38+00:00","dateModified":"2017-09-05T12:09:41+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/"},"wordCount":346,"commentCount":0,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/12\/Happy-Holidays-300x217.png","articleSection":["Excel Formula","Personal"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/","url":"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/","name":"Wish you Merry Christmas & happy Holidays - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/12\/Happy-Holidays-300x217.png","datePublished":"2015-12-24T12:59:38+00:00","dateModified":"2017-09-05T12:09:41+00:00","description":"An Animated Christmas tree lights with snow man, snow flakes etc. in excel sheet to wish you Merry Christmas and Happy Holidays. Enjoy and have fun with this animated Christmas tree :)","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/12\/Happy-Holidays-300x217.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2015\/12\/Happy-Holidays-300x217.png"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2015\/12\/wish-you-happy-holidays\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Formula","item":"https:\/\/vmlogger.com\/excel\/excel-formula\/"},{"@type":"ListItem","position":3,"name":"Wish you Merry Christmas & happy Holidays"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/4477"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=4477"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/4477\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=4477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=4477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=4477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}