{"product_id":"create-dynamic-excel-dashboards-a-simplified-step-by-step-guide-kindle-edition","title":"CREATE DYNAMIC EXCEL DASHBOARDS: A simplified step-by-step guide","description":"\u003cdiv class=\"a-fixed-left-grid\" data-mce-fragment=\"1\"\u003e\n\u003cdiv class=\"a-fixed-left-grid-inner\" data-mce-fragment=\"1\"\u003e\n\u003cdiv id=\"ppdFixedGridRightColumn\" class=\"a-fixed-left-grid-col a-col-right\" data-mce-fragment=\"1\"\u003e\n\u003cdiv id=\"bookDescription_feature_div\" class=\"celwidget\" data-feature-name=\"bookDescription\" data-csa-c-id=\"nfw2zl-6ccvkj-5gdra7-j567wk\" data-cel-widget=\"bookDescription_feature_div\" data-mce-fragment=\"1\"\u003e\n\u003cdiv data-a-expander-name=\"book_description_expander\" data-a-expander-collapsed-height=\"140\" class=\"a-expander-collapsed-height a-row a-expander-container a-spacing-base a-expander-partial-collapse-container\" data-mce-fragment=\"1\"\u003e\n\u003cdiv aria-expanded=\"false\" class=\"a-expander-content a-expander-partial-collapse-content\" data-mce-fragment=\"1\"\u003e\n\u003cdiv class=\"a-fixed-left-grid\"\u003e\n\u003cdiv class=\"a-fixed-left-grid-inner\"\u003e\n\u003cdiv class=\"a-fixed-left-grid-col a-col-right\" id=\"ppdFixedGridRightColumn\"\u003e\n\u003cdiv data-cel-widget=\"bookDescription_feature_div\" data-csa-c-id=\"4vgtxq-78pdsn-kxp11d-u92c92\" data-csa-c-is-in-initial-active-row=\"false\" data-csa-c-asin=\"1628251840\" data-csa-c-slot-id=\"bookDescription_feature_div\" data-csa-c-content-id=\"bookDescription\" data-csa-c-type=\"widget\" data-feature-name=\"bookDescription\" class=\"celwidget\" id=\"bookDescription_feature_div\"\u003e\n\u003cdiv class=\"a-expander-collapsed-height a-row a-expander-container a-spacing-base a-expander-partial-collapse-container\" data-a-expander-collapsed-height=\"140\" data-a-expander-name=\"book_description_expander\"\u003e\n\u003cdiv class=\"a-expander-content a-expander-partial-collapse-content\" aria-expanded=\"false\"\u003e\n\u003cdiv id=\"bookDescriptionBox\" itemprop=\"reviewBody\"\u003e\n\u003cspan\u003eThis book is born out of helping a lot of my clients to develop interactive Excel reports from their usual dull tables that are normally ignored by management while making decisions. It is therefore written with the pains of a working profession in mind.\u003c\/span\u003e\u003cbr\u003e\u003cspan\u003eIn it, I have connected the dots on how to leverage on Excel formulas and features to create an interactive Excel dashboard. The end goal is to set up a dashboard that will only require pasting of new data to refresh the various KPIs being tracked, without having to rework the analysis behind these metrics!\u003c\/span\u003e\u003cbr\u003e\u003cspan\u003eYou will thus find it useful if you are looking forward to significantly cut down on the time taken not only to create reports, but time taken during management meetings as managers ask for various views of your data.\u003c\/span\u003e\u003cbr\u003e\u003cspan\u003eAs an analyst, you will then be able to focus on what really matters to you and the business -i.e. drawing insights from data and advising management decisions.\u003c\/span\u003e\u003cbr\u003e\u003cspan\u003eIt covers:\u003c\/span\u003e\u003cbr\u003e\u003cspan\u003e1.How to prep your data for further reporting. That includes cleaning and adding auxiliary columns.\u003c\/span\u003e\u003cbr\u003e\u003cspan\u003e2.Data analysis techniques available in Excel with a special focus on hidden PivotTable features such as displaying %, showing YoY growth rates, connecting a slicer to multiple reports and making these slicers static on the dashboard page, among others.\u003c\/span\u003e\u003cbr\u003e\u003cspan\u003e3.Features to make the Excel dashboard dynamic and interactive\u003c\/span\u003e\u003cbr\u003e\u003cspan\u003e4.Protecting and sharing the dashboard file, including a macro to print the dashboard view.\u003c\/span\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv class=\"bookDetailsBox\"\u003e\n\u003cdiv class=\"bookProperty property_categories\"\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv id=\"similarities_feature_div\" class=\"celwidget\" data-feature-name=\"similarities\" data-csa-c-id=\"f05fdc-26r1jl-v5nlvi-fcpmd9\" data-cel-widget=\"similarities_feature_div\" data-mce-fragment=\"1\"\u003e\n\u003cdiv class=\"celwidget\" data-csa-c-id=\"yaxzt2-nyo184-ky4ij0-uknyle\" data-cel-widget=\"sims-consolidated-1_csm_instrumentation_wrapper\" data-mce-fragment=\"1\" cel_widget_id=\"sims-consolidated-1_csm_instrumentation_wrapper\"\u003e\n\u003cdiv class=\"celwidget pd_rd_w-OyxkH pf_rd_p-6b3eefea-7b16-43e9-bc45-2e332cbf99da pf_rd_r-NC22MC8ZYH4WHD6YDHV9 pd_rd_r-aef32571-4181-4c7a-abac-7617fe13765d pd_rd_wg-wgxb0 c-f\" data-csa-c-content-id=\"amzn1.sym.6b3eefea-7b16-43e9-bc45-2e332cbf99da\" data-csa-c-slot-id=\"product-bundle-1\" data-csa-c-type=\"widget\" data-csa-c-painter=\"p13n-desktop-sims-fbt-cards\" data-csa-c-id=\"kkioka-5htnqn-hucmr9-c20ka\" data-cel-widget=\"p13n-desktop-sims-fbt_DPSims_0\" data-mce-fragment=\"1\" cel_widget_id=\"p13n-desktop-sims-fbt_DPSims_0\"\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e","brand":"Bookread","offers":[{"title":"PDF","offer_id":56754672894283,"sku":null,"price":29.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1031\/1204\/8971\/files\/51wIcj7QjRL._SY346.jpg?v=1773063504","url":"https:\/\/bookread.io\/products\/create-dynamic-excel-dashboards-a-simplified-step-by-step-guide-kindle-edition","provider":"bookread","version":"1.0","type":"link"}