{"id":49,"date":"2009-11-21T15:44:00","date_gmt":"2009-11-21T20:44:00","guid":{"rendered":"http:\/\/www.debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/"},"modified":"2018-05-22T14:55:34","modified_gmt":"2018-05-22T18:55:34","slug":"online-excel-tutorials","status":"publish","type":"post","link":"https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/","title":{"rendered":"Online Excel Tutorials"},"content":{"rendered":"<p>Do you learn about Excel online, through blog posts, websites, or video libraries? I\u2019d really appreciate your comments on these two questions:<\/p>\n<p>A. What kind of online Excel tutorials do you like best (explained below)?<br \/>\n<script src=\"http:\/\/static.polldaddy.com\/p\/2288410.js\" type=\"text\/javascript\"><\/script><\/p>\n<p><noscript><br \/>\n<a href=\"http:\/\/answers.polldaddy.com\/poll\/2288410\/\">What type of online Excel tutorials do you like best?<\/a><\/p>\n<p><span style=\"font:9px;\">(<a href=\"http:\/\/www.polldaddy.com\">polls<\/a>)<\/span><br \/>\n<\/noscript><br \/>\nB. Have you always liked that type of online instruction, or did your preference change at some point in the Excel learning curve?<\/p>\n<h2>Written Instructions<\/h2>\n<p>When I started the <a title=\"Contextures website\" href=\"http:\/\/www.contextures.com\/tiptech.html\">Contextures website<\/a>, my Excel tutorials had simple written instructions, with key points illustrated with screen shots. Sometimes I\u2019d add a circle or arrow to the screen shot, or a line and label, to make things clearer.<\/p>\n<p>For example, here\u2019s a tutorial for <a title=\"Excel conditional formatting examples\" href=\"http:\/\/www.contextures.com\/xlCondFormat03.html\">Excel conditional formatting examples<\/a>.\u00a0 It has lots of words, and a few pictures. You can skim through the page to find a specific topic, or work your way from\u00a0 top to bottom, trying the examples.<\/p>\n<p>There\u2019s also a link to a sample file that readers can download, to follow the tutorials.<\/p>\n<h2>Short Video Tutorials<\/h2>\n<p>A few years ago I dabbled briefly with <a href=\"https:\/\/www.techsmith.com\/video-editor.html\">Camtasia Studio<\/a>, and created a short pivot table tutorial. It explained how to <a title=\"change pivot table data fields from vertical to horizontal\" href=\"http:\/\/www.contextures.com\/xlVideo001.html\">change pivot table data fields from vertical to horizontal<\/a> (warning \u2013 the sound comes on immediately). Apparently I was speaking into a tin can while recording it, but it is short, and to the point.<\/p>\n<p>In early 2008, I started recording Excel video tutorials again, using a newer version of <a title=\"Camtasia Studio\" href=\"https:\/\/www.techsmith.com\/video-editor.html\">Camtasia Studio<\/a>. The quality was a bit better, and I posted them on my <a title=\"Contextures YouTube channel\" href=\"http:\/\/www.youtube.com\/contextures\">Contextures YouTube channel<\/a>, and embedded them in my website.<\/p>\n<p>The feedback has been very positive, and the videos have been viewed thousands of times.<\/p>\n<h2>Interactive Learning<\/h2>\n<p>Recently, I heard about <a title=\"ViewletCam\" href=\"http:\/\/www.qarbon.com\/presentation-software\/vc\/\">ViewletCam<\/a> software that lets you create interactive videos. The output can be SWF (Flash) files, so you could put them on the website directly, since they\u2019re much smaller than video files.<\/p>\n<p>I haven\u2019t tried this software, but it might be a good middle ground, where words aren\u2019t enough and a video is too much.<\/p>\n<p>Maybe people remember things better if they try them onscreen, instead of reading or watching.<\/p>\n<h2>Webinar<\/h2>\n<p>Have you attended any Excel webinars? I&#8217;ve signed up for a few non-Excel webinars, of varying quality, but nothing Excel related. In a webinar, you could see an Excel technique demonstrated, and ask any questions that you had.<\/p>\n<h2>What Do You Prefer?<\/h2>\n<p>So, going back to my original questions, I\u2019d love to hear what you think. It\u2019s not a scientific survey, just gathering opinions, so please vote, and comment on both questions, or just one, or make up your own question and answer that. \ud83d\ude09<\/p>\n<p>A) Do any of these online Excel training tools appeal to you?<\/p>\n<p>B) If so, have you always preferred that type of online Excel training?<\/p>\n<p>Thanks!<\/p>\n<p>____________<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Do you learn about Excel online, through blog posts, websites, or video libraries? I\u2019d really appreciate your comments on these two questions: A. What kind of online Excel tutorials do you like best (explained below)? What type of online Excel tutorials do you like best? (polls) B. Have you always liked that type of online &hellip; <a href=\"https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Online Excel Tutorials&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,7],"tags":[],"class_list":["post-49","post","type-post","status-publish","format-standard","hentry","category-excel-blog","category-excel-training"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Online Excel Tutorials - Debra D&#039;s Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Online Excel Tutorials - Debra D&#039;s Blog\" \/>\n<meta property=\"og:description\" content=\"Do you learn about Excel online, through blog posts, websites, or video libraries? I\u2019d really appreciate your comments on these two questions: A. What kind of online Excel tutorials do you like best (explained below)? What type of online Excel tutorials do you like best? (polls) B. Have you always liked that type of online &hellip; Continue reading &quot;Online Excel Tutorials&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/\" \/>\n<meta property=\"og:site_name\" content=\"Debra D&#039;s Blog\" \/>\n<meta property=\"article:published_time\" content=\"2009-11-21T20:44:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-05-22T18:55:34+00:00\" \/>\n<meta name=\"author\" content=\"Debra Dalgleish\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Debra Dalgleish\" \/>\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:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/\"},\"author\":{\"name\":\"Debra Dalgleish\",\"@id\":\"https:\/\/debradalgleish.com\/blog\/#\/schema\/person\/607518faf75f53db05e302bfeeeedfbc\"},\"headline\":\"Online Excel Tutorials\",\"datePublished\":\"2009-11-21T20:44:00+00:00\",\"dateModified\":\"2018-05-22T18:55:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/\"},\"wordCount\":478,\"commentCount\":9,\"articleSection\":[\"Excel blog\",\"Excel training\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/\",\"url\":\"https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/\",\"name\":\"Online Excel Tutorials - Debra D&#039;s Blog\",\"isPartOf\":{\"@id\":\"https:\/\/debradalgleish.com\/blog\/#website\"},\"datePublished\":\"2009-11-21T20:44:00+00:00\",\"dateModified\":\"2018-05-22T18:55:34+00:00\",\"author\":{\"@id\":\"https:\/\/debradalgleish.com\/blog\/#\/schema\/person\/607518faf75f53db05e302bfeeeedfbc\"},\"breadcrumb\":{\"@id\":\"https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/debradalgleish.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Online Excel Tutorials\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/debradalgleish.com\/blog\/#website\",\"url\":\"https:\/\/debradalgleish.com\/blog\/\",\"name\":\"Debra D&#039;s Blog\",\"description\":\"Behind the Scenes in My Online Business\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/debradalgleish.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/debradalgleish.com\/blog\/#\/schema\/person\/607518faf75f53db05e302bfeeeedfbc\",\"name\":\"Debra Dalgleish\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/debradalgleish.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ff2207a34010cd731d030e1b1ae451195f5e30385dd3fcc1077b31dc759b47d6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ff2207a34010cd731d030e1b1ae451195f5e30385dd3fcc1077b31dc759b47d6?s=96&d=mm&r=g\",\"caption\":\"Debra Dalgleish\"},\"url\":\"https:\/\/debradalgleish.com\/blog\/author\/debra-dalgleish\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Online Excel Tutorials - Debra D&#039;s Blog","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:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/","og_locale":"en_US","og_type":"article","og_title":"Online Excel Tutorials - Debra D&#039;s Blog","og_description":"Do you learn about Excel online, through blog posts, websites, or video libraries? I\u2019d really appreciate your comments on these two questions: A. What kind of online Excel tutorials do you like best (explained below)? What type of online Excel tutorials do you like best? (polls) B. Have you always liked that type of online &hellip; Continue reading \"Online Excel Tutorials\"","og_url":"https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/","og_site_name":"Debra D&#039;s Blog","article_published_time":"2009-11-21T20:44:00+00:00","article_modified_time":"2018-05-22T18:55:34+00:00","author":"Debra Dalgleish","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Debra Dalgleish","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/#article","isPartOf":{"@id":"https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/"},"author":{"name":"Debra Dalgleish","@id":"https:\/\/debradalgleish.com\/blog\/#\/schema\/person\/607518faf75f53db05e302bfeeeedfbc"},"headline":"Online Excel Tutorials","datePublished":"2009-11-21T20:44:00+00:00","dateModified":"2018-05-22T18:55:34+00:00","mainEntityOfPage":{"@id":"https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/"},"wordCount":478,"commentCount":9,"articleSection":["Excel blog","Excel training"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/","url":"https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/","name":"Online Excel Tutorials - Debra D&#039;s Blog","isPartOf":{"@id":"https:\/\/debradalgleish.com\/blog\/#website"},"datePublished":"2009-11-21T20:44:00+00:00","dateModified":"2018-05-22T18:55:34+00:00","author":{"@id":"https:\/\/debradalgleish.com\/blog\/#\/schema\/person\/607518faf75f53db05e302bfeeeedfbc"},"breadcrumb":{"@id":"https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/debradalgleish.com\/blog\/2009\/11\/21\/online-excel-tutorials\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/debradalgleish.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Online Excel Tutorials"}]},{"@type":"WebSite","@id":"https:\/\/debradalgleish.com\/blog\/#website","url":"https:\/\/debradalgleish.com\/blog\/","name":"Debra D&#039;s Blog","description":"Behind the Scenes in My Online Business","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/debradalgleish.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/debradalgleish.com\/blog\/#\/schema\/person\/607518faf75f53db05e302bfeeeedfbc","name":"Debra Dalgleish","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/debradalgleish.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ff2207a34010cd731d030e1b1ae451195f5e30385dd3fcc1077b31dc759b47d6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ff2207a34010cd731d030e1b1ae451195f5e30385dd3fcc1077b31dc759b47d6?s=96&d=mm&r=g","caption":"Debra Dalgleish"},"url":"https:\/\/debradalgleish.com\/blog\/author\/debra-dalgleish\/"}]}},"_links":{"self":[{"href":"https:\/\/debradalgleish.com\/blog\/wp-json\/wp\/v2\/posts\/49","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/debradalgleish.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/debradalgleish.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/debradalgleish.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/debradalgleish.com\/blog\/wp-json\/wp\/v2\/comments?post=49"}],"version-history":[{"count":8,"href":"https:\/\/debradalgleish.com\/blog\/wp-json\/wp\/v2\/posts\/49\/revisions"}],"predecessor-version":[{"id":968,"href":"https:\/\/debradalgleish.com\/blog\/wp-json\/wp\/v2\/posts\/49\/revisions\/968"}],"wp:attachment":[{"href":"https:\/\/debradalgleish.com\/blog\/wp-json\/wp\/v2\/media?parent=49"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/debradalgleish.com\/blog\/wp-json\/wp\/v2\/categories?post=49"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/debradalgleish.com\/blog\/wp-json\/wp\/v2\/tags?post=49"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}