{"id":14,"date":"2018-04-29T21:32:27","date_gmt":"2018-04-29T21:32:27","guid":{"rendered":"http:\/\/theaccountantstoolkit.com\/?page_id=14"},"modified":"2020-05-10T20:44:10","modified_gmt":"2020-05-10T20:44:10","slug":"test-page","status":"publish","type":"page","link":"https:\/\/analyststoolkit.com\/","title":{"rendered":"Home Page"},"content":{"rendered":"<div style=\"width: 525px;\" class=\"wp-video\"><video class=\"wp-video-shortcode\" id=\"video-14-1\" width=\"525\" height=\"295\" preload=\"metadata\" controls=\"controls\"><source type=\"video\/mp4\" src=\"https:\/\/analyststoolkit.com\/wp-content\/uploads\/2018\/10\/Sequence-7.mp4?_=1\" \/><a href=\"https:\/\/analyststoolkit.com\/wp-content\/uploads\/2018\/10\/Sequence-7.mp4\">https:\/\/analyststoolkit.com\/wp-content\/uploads\/2018\/10\/Sequence-7.mp4<\/a><\/video><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"#page-jump\"><img loading=\"lazy\" decoding=\"async\" width=\"827\" height=\"74\" src=\"https:\/\/analyststoolkit.com\/wp-content\/uploads\/2019\/07\/Button.png\" alt=\"\" class=\"wp-image-284\" srcset=\"https:\/\/analyststoolkit.com\/wp-content\/uploads\/2019\/07\/Button.png 827w, https:\/\/analyststoolkit.com\/wp-content\/uploads\/2019\/07\/Button-300x27.png 300w, https:\/\/analyststoolkit.com\/wp-content\/uploads\/2019\/07\/Button-768x69.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/figure><\/div>\n\n\n\n<p>As an Financial Analyst and Accountant working within various different roles over the last 20 years I have come to rely on Microsoft Excel as the daily tool of the trade that I simply could not live without<\/p>\n\n\n\n<p>However, also over the years I have noticed that it is a generic product and often there were specific tasks related to the Finance professional's world that I was performing on a regular basis in an inefficient manner<\/p>\n\n\n\n<p>If you are anything like me then this type of inefficiency drives you crazy! If I have to perform a task more than once then I will be looking for a way to automate it<\/p>\n\n\n\n<p>Over time this became a toolkit that I developed that would save me time and effort on a daily basis and give me the edge over other people in the workplace<\/p>\n\n\n\n<p>Now I'm giving you the opportunity to get access to this toolkit to give you that same edge and have your colleagues wonder just how do you manage to whizz your way around Excel tasks the way you do!<\/p>\n\n\n\n<p class=\"has-medium-font-size\"><strong>Do you work with data that you need to convert into a journal?<\/strong><\/p>\n\n\n\n<p>I often find myself going through the same process roughly along these lines:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Gather raw data<\/li><li>Convert data into a clean format<\/li><li>Remove any noise<\/li><li>Pivot the data<\/li><li>Compare with a prior period to understand what has changed<\/li><li>Convert into a journal entry<\/li><\/ul>\n\n\n\n<p class=\"has-medium-font-size\"><strong>How can we make this process easier?<\/strong><\/p>\n\n\n\n<p>Built into the toolkit are a number of automatic features that will allow you to do the following<\/p>\n\n\n\n<p><strong>Convert data into a clean format<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Switch between numbers and text<\/li><li>Convert between US and UK date formats<\/li><li>Round numbers to 2 decimal places<\/li><\/ul>\n\n\n\n<p><strong>Remove any noise<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Match ranges of data to spot differences<\/li><li>Auto match debits and credits that net to zero <\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"640\" src=\"https:\/\/analyststoolkit.com\/wp-content\/uploads\/2019\/07\/ezgif.com-video-to-gif.gif\" alt=\"\" class=\"wp-image-315\"\/><\/figure>\n\n\n\n<p><strong>Pivot the data<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li> Instant Pivot Table formatting <\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"405\" height=\"177\" src=\"https:\/\/analyststoolkit.com\/wp-content\/uploads\/2019\/07\/Annotation-2019-07-01-225504.png\" alt=\"\" class=\"wp-image-258\" srcset=\"https:\/\/analyststoolkit.com\/wp-content\/uploads\/2019\/07\/Annotation-2019-07-01-225504.png 405w, https:\/\/analyststoolkit.com\/wp-content\/uploads\/2019\/07\/Annotation-2019-07-01-225504-300x131.png 300w\" sizes=\"auto, (max-width: 405px) 100vw, 405px\" \/><\/figure>\n\n\n\n<p><strong>Compare with a prior period to understand what has changed<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Auto reconcile data sets<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-video\"><video height=\"1024\" style=\"aspect-ratio: 1280 \/ 1024;\" width=\"1280\" autoplay controls loop src=\"https:\/\/analyststoolkit.com\/wp-content\/uploads\/2019\/07\/2019-07-01-23-22-49.mp4\"><\/video><\/figure>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"#page-jump\"><img loading=\"lazy\" decoding=\"async\" width=\"827\" height=\"74\" src=\"https:\/\/analyststoolkit.com\/wp-content\/uploads\/2019\/07\/Button-1.png\" alt=\"\" class=\"wp-image-287\" srcset=\"https:\/\/analyststoolkit.com\/wp-content\/uploads\/2019\/07\/Button-1.png 827w, https:\/\/analyststoolkit.com\/wp-content\/uploads\/2019\/07\/Button-1-300x27.png 300w, https:\/\/analyststoolkit.com\/wp-content\/uploads\/2019\/07\/Button-1-768x69.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/figure><\/div>\n\n\n\n<p><strong>Convert into a journal entry<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Split out Debits\\Credits<\/li><li>Crunch Debits\\Credits into 1 column<\/li><li>Reverse Debits\\Credits<\/li><li>Concatenate Account Codes<\/li><li>Separate Account Codes<\/li><li>Get a quick Net sum of Debits\\Credits <\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Shrink large workbooks<\/li><li>Copy Sums<\/li><li>Copy Concatenations<\/li><li>Break Excel Password protection<\/li><li>Toggle Number\\Text\\Date Formats<\/li><li>Show\\Hide Hidden Names<\/li><li>Delete Broken Names (TBC)<\/li><li>Auto Create Dynamic Ranges<\/li><li>Round Data<\/li><li>Close Multiple Workbooks at once<\/li><li>Hide\\Unhide Multiple\\All sheets<\/li><li>Protect\\Unprotect Multiple sheets<\/li><li>Normalise Ranges<\/li><li>Unique Items Function<\/li><li>Auto Create T-Accounts<\/li><li>Copy sums to the clipboard to be pasted elsewhere <\/li><li>Copy individual account code segments to be pasted as a concatenated code <\/li><\/ul>\n\n\n\n<h2 class=\"has-text-align-center wp-block-heading\" id=\"page-jump\"><strong>Here's what you get with ATK<\/strong><\/h2>\n\n\n\n<p>The Analyst's Toolkit (ATK) is an Excel Add-in that is compatible with Excel 2007, 2010, 2013 and 2016 for Windows.<\/p>\n\n\n\n<h4 class=\"has-text-align-center wp-block-heading\"><strong>ATK Standard Version<\/strong><\/h4>\n\n\n\n<div class=\"wp-block-media-text alignwide\"><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"800\" src=\"https:\/\/analyststoolkit.com\/wp-content\/uploads\/2020\/05\/Analyst.png\" alt=\"\" class=\"wp-image-425\" srcset=\"https:\/\/analyststoolkit.com\/wp-content\/uploads\/2020\/05\/Analyst.png 800w, https:\/\/analyststoolkit.com\/wp-content\/uploads\/2020\/05\/Analyst-300x300.png 300w, https:\/\/analyststoolkit.com\/wp-content\/uploads\/2020\/05\/Analyst-150x150.png 150w, https:\/\/analyststoolkit.com\/wp-content\/uploads\/2020\/05\/Analyst-768x768.png 768w, https:\/\/analyststoolkit.com\/wp-content\/uploads\/2020\/05\/Analyst-100x100.png 100w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<ul class=\"wp-block-list\"><li>Journal Manipulation (DR\\CR) tools<\/li><li>Pivot table tools<\/li><li>Data tools<\/li><li>Worksheet management<\/li><li>Name managers<\/li><li>Other Utilities<\/li><li>Special function library<\/li><\/ul>\n<\/div><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"has-text-align-center\"><form action=\"https:\/\/www.paypal.com\/cgi-bin\/webscr\" method=\"post\" target=\"_top\">\n<input type=\"image\" src=\"https:\/\/www.paypal.com\/en_US\/i\/btn\/btn_xpressCheckout.gif\" border=\"0\" name=\"submit\" title=\"PayPal - The safer, easier way to pay online!\" alt=\"Buy Now\" \/>\n\n<input type=\"hidden\" name=\"encrypted\" value=\"-----BEGIN PKCS7-----MIIMyQYJKoZIhvcNAQcEoIIMujCCDLYCAQExggEwMIIBLAIBADCBlDCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb20CAQAwDQYJKoZIhvcNAQEBBQAEgYCdp7Bbg6C83cUUfKmvOd8xHM9Lt0wXXkl7hltdRfmlBIeJYqo0cs9bXgTdx1F+Ud8Hce0JuDcoN\/67mgeB\/TsSQ57f4E8nW44iJTVajcClgS50VALQoVF16wozbzXlGIXGxTmRl\/d0SPYMzYALAax7sshoZNw39AnKrE3VfpVn6TELMAkGBSsOAwIaBQAwggZFBgkqhkiG9w0BBwEwFAYIKoZIhvcNAwcECFuZU8m2jxAVgIIGIK\/\/\/xYzp\/A+37VBGCVdI6wLkNixiLFkyZPLL3E5nHx2Fv3kJHi3Vdnhdf6ytZO9JXkqC4YkCOa5Q8JjXQsNRBTfHcDcqVpaI8VHANtPNOd76HQJ8syzE2aIpA2WPGDOMyUH40\/DwVEwlD12S4Y9f02Amrb3pxACHnY6V4XOfCehrrQbvu7IoNSuQBGvW55BaGIBRqUFJvoseAcIuSPmb2pGKz3qEJ2Wa\/igPCkGj6RFtXcoMgTmO2b0e86btg\/PtIslxXvMwyG1PGRF+LMO5Ly2S3KrlBUSPil8pVjMKyZhlAPVgMWlU\/QidV5y7tv4Qhk+3V3IxzhTjTp9hbtYtRzKWo8UVidlO30owHZ9uW2IrDMNt2\/kefwGEXHl\/wlYIdfPOxY1y0bMQKg\/uC1fcmZjMLsFcxiN9NrPHpN6jXjBx4+NheKQRhEsIaSpnymHLw3ilGYvrPCnDGg5AJ38VFlUGfH0ska2GUDohQNderzV8PYH0cncsYcvZ1jIbloW+3ZK\/+gNakSlVjrbqZJQQ6GSLBz6V\/0g1PT\/3OWasTKTEUuQ5OR2lelNaQ4v9oCIikogy8+YphJYxn3zBeeO6B\/X24rdiCVMql4u1jtZPg6KDD6cChe0WMMMReLMEFLELF2QkI7IVLWF0uSRP07URO2pi9SWeJt81BiporQGKvFEDzJ\/c06wj9LB\/x\/L6RgXZAaHNXRl5S19EGI8YgCaImeaNeona0YQ17IkabOZ2bMp0Qe4PM3Zjb6PQBcSXaITWSP8pmo23Kn+k\/0DJ1+BXrO7QM2VKVeh+bZ4QquY7w9NCgdKMKPz97XKlkrFu9OYoZuRhUlk3\/nH37R\/dQM24naTI7GQUc7X1c9xHG5JUvjrjtWKmSjojQ0\/yLb2yXzfJEAH4ba32TIYt4aUjuKP8MGxbpnqwFAJunyI4justb6QMJmjlUyXd22s+Q+m3juOGpc9t80JidzlVOfB1g+CjSpaor4N\/qYXoQxkuwmQjSCBZwo2NYnzG09BhXAJrEJz92w8XagxHigVamP+a9e6woIOyWkr3v3lUnmL3Vns+nXIchDrLe1MCt0jQ865BZpxJvokfdRFzCamYfow6wGP9coa+yQU+gEECC1AnkKIp2dk+UObCxEKKt+MZKznZovlDCcEvI76bomkA2EdI1nUcN+Mm8AFUUM5nVIRObgYrvcKJp8bBiBj\/+S818xAo7G5Fn5qrdaaO+5cSobnxwcN3EugtjPMxpNhHqQbA9GGb3+F4s2SiNKzmDU1Q6ChRIKvuhCE9s2pXnv+gSuRb9yDkLcdlasX3DbbffMxdYcgy8506feh6yXxFlxsyf4\/9jxaS96qFgezY8m15zjWjLUsJzh9XzVq\/2CV6W7CxLV\/TY+uE182nnBDVWTgdaNv8lc3D4W2\/vtXAls0GYl7\/5CQP\/8jSa1mScnAoT6wnbSy8Sh7qraD9KvGiW68Qwiou7Y7rgfmHmIrSDbIyQoCOua7PLCW0I0G19n+uHbSWFYUeqvpelg\/Iwz8PCIgT05Q8jKy7XEgObHlsDiLzo5sGLd2LOn7BLnKpwo7haEQTjicwgoe\/oudBiNPPHAW1RkmPeU7IdkPHY\/j9OD1KSMLjIjlgrCmtcM3cUee4LwAE\/HnAz28x5+DdABmT2fSlmqeFBWzwSYPnrTrSAEx1Ip4LQJp7CoNyvoXzXuIqN83GzOVKLB+9yF8ZfpXhWyk5+d4VnbBdcyMbzsO793kwqgpuPPXmbeIi5u8WLjBQF\/8qaF\/eBzsFjHfuM0DR8g0Uad4ZEojsWT+Vwinhd94CQh8dR5zVrZfJR7KFfVaiEMpofRIxkWCcPHTRHq193ysPOoyLcbz3fs5HEC2CeUSM1SrFqPvW+Vz83nunwWGzJhxO0uYTjHymS8UbithA1S0km1Y5XZBhxIMhjVGQvdAVMmx+nQ\/Wxb3MNJ5xeB3\/CfyPpr8q++MFH3Ke6eNQQHfufycHWlKDqg+P5elnIKf\/+8J2fIAlKIqQ\/gQvtsnZDsvB5dugw9FY0D3kCVifsqBj0yZBiHS4JZa4y736jggKR\/jDymvgzSDydadYDO2h8jaSUzlOhyBoIIDhzCCA4MwggLsoAMCAQICAQAwDQYJKoZIhvcNAQEFBQAwgY4xCzAJBgNVBAYTAlVTMQswCQYDVQQIEwJDQTEWMBQGA1UEBxMNTW91bnRhaW4gVmlldzEUMBIGA1UEChMLUGF5UGFsIEluYy4xEzARBgNVBAsUCmxpdmVfY2VydHMxETAPBgNVBAMUCGxpdmVfYXBpMRwwGgYJKoZIhvcNAQkBFg1yZUBwYXlwYWwuY29tMB4XDTA0MDIxMzEwMTMxNVoXDTM1MDIxMzEwMTMxNVowgY4xCzAJBgNVBAYTAlVTMQswCQYDVQQIEwJDQTEWMBQGA1UEBxMNTW91bnRhaW4gVmlldzEUMBIGA1UEChMLUGF5UGFsIEluYy4xEzARBgNVBAsUCmxpdmVfY2VydHMxETAPBgNVBAMUCGxpdmVfYXBpMRwwGgYJKoZIhvcNAQkBFg1yZUBwYXlwYWwuY29tMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDBR07d\/ETMS1ycjtkpkvjXZe9k+6CieLuLsPumsJ7QC1odNz3sJiCbs2wC0nLE0uLGaEtXynIgRqIddYCHx88pb5HTXv4SZeuv0Rqq4+axW9PLAAATU8w04qqjaSXgbGLP3NmohqM6bV9kZZwZLR\/klDaQGo1u9uDb9lr4Yn+rBQIDAQABo4HuMIHrMB0GA1UdDgQWBBSWn3y7xm8XvVk\/UtcKG+wQ1mSUazCBuwYDVR0jBIGzMIGwgBSWn3y7xm8XvVk\/UtcKG+wQ1mSUa6GBlKSBkTCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb22CAQAwDAYDVR0TBAUwAwEB\/zANBgkqhkiG9w0BAQUFAAOBgQCBXzpWmoBa5e9fo6ujionW1hUhPkOBakTr3YCDjbYfvJEiv\/2P+IobhOGJr85+XHhN0v4gUkEDI8r2\/rNk1m0GA8HKddvTjyGw\/XqXa+LSTlDYkqI8OwR8GEYj4efEtcRpRYBxV8KxAW93YDWzFGvruKnnLbDAF6VR5w\/cCMn5hzGCAZowggGWAgEBMIGUMIGOMQswCQYDVQQGEwJVUzELMAkGA1UECBMCQ0ExFjAUBgNVBAcTDU1vdW50YWluIFZpZXcxFDASBgNVBAoTC1BheVBhbCBJbmMuMRMwEQYDVQQLFApsaXZlX2NlcnRzMREwDwYDVQQDFAhsaXZlX2FwaTEcMBoGCSqGSIb3DQEJARYNcmVAcGF5cGFsLmNvbQIBADAJBgUrDgMCGgUAoF0wGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMjYwNDIzMTIwOTI5WjAjBgkqhkiG9w0BCQQxFgQUjRk4AbS1Q03bdTiP2YdOWMAgzIwwDQYJKoZIhvcNAQEBBQAEgYBFn1z06dBU\/bZwnxn0k2pE5KIIMEfHR8MP7Poa1yH2qcKjJwHlHOZjCKmnPDDbKDYqAo+hcVWWGGy5ArlqiXrBHwLUcUqhG6y2dEKG95rcyNczBB9P7n1gY\/hSikHh7y+Oj4rs1IfZXA1rN+SphqqEwU72lJZxh8zV8X3yhTzPgg==-----END PKCS7-----\" \/>\n<input type=\"hidden\" name=\"cmd\" value=\"_s-xclick\" \/>\n<\/form><\/p>\n","protected":false},"excerpt":{"rendered":"<p>As an Financial Analyst and Accountant working within various different roles over the last 20 years I have come to rely on Microsoft Excel as the daily tool of the trade that I simply could not live without However, also over the years I have noticed that it is a generic product and often there &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/analyststoolkit.com\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Home Page&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-14","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/analyststoolkit.com\/index.php\/wp-json\/wp\/v2\/pages\/14","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/analyststoolkit.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/analyststoolkit.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/analyststoolkit.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/analyststoolkit.com\/index.php\/wp-json\/wp\/v2\/comments?post=14"}],"version-history":[{"count":61,"href":"https:\/\/analyststoolkit.com\/index.php\/wp-json\/wp\/v2\/pages\/14\/revisions"}],"predecessor-version":[{"id":427,"href":"https:\/\/analyststoolkit.com\/index.php\/wp-json\/wp\/v2\/pages\/14\/revisions\/427"}],"wp:attachment":[{"href":"https:\/\/analyststoolkit.com\/index.php\/wp-json\/wp\/v2\/media?parent=14"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}