{"id":10564,"date":"2016-10-02T18:26:27","date_gmt":"2016-10-02T18:26:27","guid":{"rendered":"http:\/\/tayosolagbade.com\/sdnuggets\/?p=10564"},"modified":"2016-10-02T18:26:27","modified_gmt":"2016-10-02T18:26:27","slug":"tutorial-02-using-named-ranges-for-super-spreadsheet-optimisation-and-automation","status":"publish","type":"post","link":"http:\/\/tayosolagbade.com\/sdnuggets\/tutorial-02-using-named-ranges-for-super-spreadsheet-optimisation-and-automation\/","title":{"rendered":"[Tutorial 02] Using Named Ranges for Super Spreadsheet Optimisation and Automation"},"content":{"rendered":"<p><em>[NB: These are excerpts from a full tutorial emailed to members of my <a href=\"http:\/\/tayosolagbade.com\/sdnuggets\/welcome-to-my-ms-excel-heaven-visual-basic-automation-club-introductory-videos-you-need-to-watch\/\" target=\"_blank\">Excel Heaven Visual Basic Automation Club<\/a>. They received the MS Excel Workbook example, a Video Demo, as well as an AMR Audio Recording in which I explained the best practice philosoophy that guides my unconventional approach to developing custom spreadsheet automation. <a href=\"http:\/\/tayosolagbade.com\/contact.htm\" target=\"_blank\">Click here to request copies you can download<\/a>]<\/em><\/p>\n<p>In this tutorial I introduce one of the most powerful tools you can use to seriously boost your work related productivity in using MS Excel either as a user or as a <a href=\"http:\/\/excelheaven.tayosolagbade.com\" target=\"_blank\">VBA solutions developer\/programmer<\/a>.<\/p>\n<p>The\u00a0 simple database table used in this case study illustrate how NAMED RANGES\u00a0 can make working with your spreadsheet data\u00a0 much easier and less stressful\/confusing or indeed error prone.<\/p>\n<p>In addition, use of named ranges can help you use VBA coding more efficiently and effectively, to control MS Excel for your custom automation needs.<\/p>\n<p><strong>Below: Screensot showing a named range (nfAge) in the example workbook sent to club members, which defines the range comprising cells A9:A16 inthe spreadsheet table.<\/strong><\/p>\n<p><a href=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/10\/formularbar-namebox.png\" rel=\"attachment wp-att-10566\"><img decoding=\"async\" class=\"alignnone size-full wp-image-10566\" src=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/10\/formularbar-namebox.png\" alt=\"formularbar-namebox\" width=\"580\" srcset=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/10\/formularbar-namebox.png 592w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/10\/formularbar-namebox-289x300.png 289w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/10\/formularbar-namebox-145x150.png 145w\" sizes=\"(max-width: 592px) 100vw, 592px\" \/><\/a><\/p>\n<p><strong>Below: Screenshot of the annotated interface for the MS Excel Workbook in which this entire case study was treated.<\/strong><\/p>\n<p><a href=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/10\/xlh-tut02-2ndOctober2016.png\" rel=\"attachment wp-att-10569\"><img decoding=\"async\" class=\"alignnone size-full wp-image-10569\" src=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/10\/xlh-tut02-2ndOctober2016.png\" alt=\"xlh-tut02-2ndoctober2016\" width=\"580\" srcset=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/10\/xlh-tut02-2ndOctober2016.png 1184w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/10\/xlh-tut02-2ndOctober2016-300x245.png 300w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/10\/xlh-tut02-2ndOctober2016-768x626.png 768w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/10\/xlh-tut02-2ndOctober2016-1024x835.png 1024w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/10\/xlh-tut02-2ndOctober2016-150x122.png 150w\" sizes=\"(max-width: 1184px) 100vw, 1184px\" \/><\/a><\/p>\n<p><strong>Below: Screenshot of the tutorial demonstration video I created in which I showed the steps for creating named ranges in a duplicate version of the original table shown above.<\/strong><\/p>\n<p>This has been emailed to members of my Excel-VB club, along with a copy of the MS Excel workbook containing the examples shown.<\/p>\n<p><a href=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/10\/xlh02-2ndOct2016-video-demo.png\" rel=\"attachment wp-att-10568\"><img decoding=\"async\" class=\"alignnone size-full wp-image-10568\" src=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/10\/xlh02-2ndOct2016-video-demo.png\" alt=\"xlh02-2ndoct2016-video-demo\" width=\"580\" srcset=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/10\/xlh02-2ndOct2016-video-demo.png 991w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/10\/xlh02-2ndOct2016-video-demo-300x268.png 300w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/10\/xlh02-2ndOct2016-video-demo-768x685.png 768w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2016\/10\/xlh02-2ndOct2016-video-demo-150x134.png 150w\" sizes=\"(max-width: 991px) 100vw, 991px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/tayosolagbade.com\/contact.htm\" target=\"_blank\">Click here to request copies of the full tutorial you can download<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>[NB: These are excerpts from a full tutorial emailed to members of my Excel Heaven Visual Basic Automation Club. They received the MS Excel Workbook example, a Video Demo, as well as an AMR Audio Recording in which I explained the best practice philosoophy that guides my unconventional approach to developing custom spreadsheet automation. Click [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,8,1375,1,266,10],"tags":[],"class_list":["post-10564","post","type-post","status-publish","format-standard","hentry","category-employeescareer-persons","category-entrepreneurs","category-excel-vb-solutions","category-general-2","category-my-dn-travel-news","category-self-development"],"aioseo_notices":[],"views":950,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/10564","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=10564"}],"version-history":[{"count":4,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/10564\/revisions"}],"predecessor-version":[{"id":10573,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/10564\/revisions\/10573"}],"wp:attachment":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/media?parent=10564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/categories?post=10564"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/tags?post=10564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}