{"id":11697,"date":"2017-03-26T22:54:21","date_gmt":"2017-03-26T22:54:21","guid":{"rendered":"http:\/\/tayosolagbade.com\/sdnuggets\/?p=11697"},"modified":"2017-03-26T22:54:21","modified_gmt":"2017-03-26T22:54:21","slug":"video-excel-heaven-tutorial-09-using-relative-absolute-cell-addressing-to-save-your-time-and-effort-in-ms-excel","status":"publish","type":"post","link":"http:\/\/tayosolagbade.com\/sdnuggets\/video-excel-heaven-tutorial-09-using-relative-absolute-cell-addressing-to-save-your-time-and-effort-in-ms-excel\/","title":{"rendered":"[VIDEO] Excel Heaven Tutorial \u00a009: Using Relative & Absolute Cell Addressing\u00a0To Save Your Time and Effort In MS Excel"},"content":{"rendered":"

[Photo below] Screenshot of MS Excel Workbook for this week's Tutorial \u00a009 titled \"Using Relative<\/b> & Absolute Cell Addressing\u00a0<\/b>To Save Your<\/b> Time and Effort In MS Excel\"<\/b><\/p>\n

\"xlh-tut09-26thmarch2017\"<\/p>\n

The formula shown uses mixed cell addressing to generate dynamic cell output, as its location changes, by changing key cells it refers to in computing the desired values.<\/em><\/strong><\/p>\n

You build it in ONE cell, and simply copy it across ALL rows and columns in your spreadsheet report table.<\/p>\n

It's the smartest way to make use of your time and effort as a solutions developer with a focus of results.<\/p>\n

In the screenshot tutorial video I created for this tutorial (sent to my Excel Heaven Club members), I explain the thinking involved in building this kind of formula, by demonstrating using dummy tabulated data for drinks sales by dates.<\/p>\n

Click here to request a copy of the example workbook and video<\/a>.<\/p>\n

\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"

[Photo below] Screenshot of MS Excel Workbook for this week's Tutorial \u00a009 titled \"Using Relative & Absolute Cell Addressing\u00a0To Save Your Time and Effort In MS Excel\" The formula shown uses mixed cell addressing to generate dynamic cell output, as its location changes, by changing key cells it refers to in computing the desired values. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,1375,266,10],"tags":[2825,2826,1998],"class_list":["post-11697","post","type-post","status-publish","format-standard","hentry","category-employeescareer-persons","category-excel-vb-solutions","category-my-dn-travel-news","category-self-development","tag-excel-heaven-tutorial-09","tag-using-relative-absolute-cell-addressing-to-save-your-time-and-effort-in-ms-excel","tag-video"],"aioseo_notices":[],"views":1292,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/11697","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/comments?post=11697"}],"version-history":[{"count":2,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/11697\/revisions"}],"predecessor-version":[{"id":11700,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/11697\/revisions\/11700"}],"wp:attachment":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/media?parent=11697"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/categories?post=11697"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/tags?post=11697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}