{
  "action": "Product-ShowQuickView",
  "queryString": "pid=B08BDVMZP4",
  "locale": "default",
  "product": {
    "uuid": "61577b6ab66f948faa72e105cd",
    "id": "B08BDVMZP4",
    "productName": "Beginner'S Guide to Google Sheets",
    "productType": "standard",
    "brand": "Does Not Apply",
    "price": {
      "sales": {
        "value": 27.95,
        "currency": "AUD",
        "formatted": "A$27.95",
        "decimalPrice": "27.95"
      },
      "list": {
        "value": 34.6,
        "currency": "AUD",
        "formatted": "A$34.60",
        "decimalPrice": "34.60"
      }
    },
    "renderedPrice": "    <div class=\"price\">\n        \n        \n<span>\n    \n\n    \n        \n        <del>\n            <span class=\"strike-through list\">\n                <span class=\"value\" content=\"34.60\">\n                    <span class=\"sr-only\">\n                        Price reduced from\n                    </span>\n                    A$34.60\n\n\n                    <span class=\"sr-only\">\n                        to\n                    </span>\n                </span>\n            </span>\n        </del>\n    \n\n    \n    <span class=\"sales\">\n        \n        \n        \n            <span class=\"value\" content=\"27.95\"></span>\n        \n        A$27.95\n\n\n    </span>\n</span>\n\n    </div>\n\n\n",
    "images": {
      "large": [
        {
          "alt": "Beginner'S Guide to Google Sheets",
          "url": "/on/demandware.static/-/Sites-storefront-catalog-m-en/default/dw60acf976/images/large/8dcd9d28100db4448457af253b2f6636.png",
          "index": "0",
          "title": "Beginner'S Guide to Google Sheets",
          "absURL": "https://staging.emega.com.au/on/demandware.static/-/Sites-storefront-catalog-m-en/default/dw60acf976/images/large/8dcd9d28100db4448457af253b2f6636.png"
        },
        {
          "alt": "Beginner'S Guide to Google Sheets",
          "url": "/on/demandware.static/-/Sites-storefront-catalog-m-en/default/dwad5f672f/images/large/fcc354bbb2d621e1a76c456338cdaac2.png",
          "index": "1",
          "title": "Beginner'S Guide to Google Sheets",
          "absURL": "https://staging.emega.com.au/on/demandware.static/-/Sites-storefront-catalog-m-en/default/dwad5f672f/images/large/fcc354bbb2d621e1a76c456338cdaac2.png"
        }
      ],
      "small": [
        {
          "alt": "Beginner'S Guide to Google Sheets",
          "url": "/on/demandware.static/-/Sites-storefront-catalog-m-en/default/dw60acf976/images/large/8dcd9d28100db4448457af253b2f6636.png",
          "index": "0",
          "title": "Beginner'S Guide to Google Sheets",
          "absURL": "https://staging.emega.com.au/on/demandware.static/-/Sites-storefront-catalog-m-en/default/dw60acf976/images/large/8dcd9d28100db4448457af253b2f6636.png"
        },
        {
          "alt": "Beginner'S Guide to Google Sheets",
          "url": "/on/demandware.static/-/Sites-storefront-catalog-m-en/default/dwad5f672f/images/large/fcc354bbb2d621e1a76c456338cdaac2.png",
          "index": "1",
          "title": "Beginner'S Guide to Google Sheets",
          "absURL": "https://staging.emega.com.au/on/demandware.static/-/Sites-storefront-catalog-m-en/default/dwad5f672f/images/large/fcc354bbb2d621e1a76c456338cdaac2.png"
        }
      ]
    },
    "selectedQuantity": 1,
    "minOrderQuantity": 1,
    "maxOrderQuantity": 10,
    "variationAttributes": null,
    "longDescription": "<div> <div> <div> <span>Google Sheets is a wonderful tool but if you are new to it, it can be a little daunting. In this book I'll take you step-by-step through the different areas of Google Sheets, starting from the very basics to more advanced areas, so that you are able to use Google Sheets with confidence.Updated with the latest changes to Sheets, including removing duplications, trimming whitespace, version and cell edit history, suggested formulas, row & column grouping, and editing page breaks. Plus, all the screenshots have been redone to make them even easier to read and to show the latest version of Sheets. June 2019.Contents:1-The basics2-Cell formatting3-Formatting your data4-Basic functions and formulas5-Controlling rows and columns (part 1)6-Controlling rows and columns (part 2)7-Cell referencing8-Moving, copying, pasting9-Moving beyond one sheet10-Printing11-Downloading, emailing & sharing12-Filtering your data13-Conditional formatting & custom formulas14-Sorting your data15-Merging your data16-Notes and comments17-Sparklines18-Creating charts (part 1)19-Creating charts (part 2)20-Alternating Colours in a table21-Inserting hyperlinks22-The Explore tool23-Data validation24-Removing duplications & trimming whitespace25-Version & cell edit history</span> </div> </div> </div><div><h2>Item Details</h2><ul><li><strong>Publisher:</strong> Independently published</li><li><strong>Dimensions:</strong> 21.59 x 1.14 x 27.94 cm</li><li><strong>Language:</strong> English</li><li><strong>Print length:</strong> 198 pages</li><li><strong>Item weight:</strong> 689 g</li><li><strong>Book Type:</strong> Paperback</li><li><strong>ISBN-13:</strong> 979-8653987212</li><li><strong>Publication date:</strong> 14 June 2020</li></ul></div>",
    "shortDescription": null,
    "rating": 5,
    "promotions": null,
    "attributes": null,
    "availability": {
      "messages": [
        "In Stock"
      ],
      "inStockDate": null
    },
    "available": true,
    "options": [],
    "quantities": [
      {
        "value": "1",
        "selected": true,
        "url": "/on/demandware.store/Sites-eMEGA-Site/default/Product-Variation?pid=B08BDVMZP4&quantity=1"
      },
      {
        "value": "2",
        "selected": false,
        "url": "/on/demandware.store/Sites-eMEGA-Site/default/Product-Variation?pid=B08BDVMZP4&quantity=2"
      },
      {
        "value": "3",
        "selected": false,
        "url": "/on/demandware.store/Sites-eMEGA-Site/default/Product-Variation?pid=B08BDVMZP4&quantity=3"
      },
      {
        "value": "4",
        "selected": false,
        "url": "/on/demandware.store/Sites-eMEGA-Site/default/Product-Variation?pid=B08BDVMZP4&quantity=4"
      },
      {
        "value": "5",
        "selected": false,
        "url": "/on/demandware.store/Sites-eMEGA-Site/default/Product-Variation?pid=B08BDVMZP4&quantity=5"
      },
      {
        "value": "6",
        "selected": false,
        "url": "/on/demandware.store/Sites-eMEGA-Site/default/Product-Variation?pid=B08BDVMZP4&quantity=6"
      },
      {
        "value": "7",
        "selected": false,
        "url": "/on/demandware.store/Sites-eMEGA-Site/default/Product-Variation?pid=B08BDVMZP4&quantity=7"
      },
      {
        "value": "8",
        "selected": false,
        "url": "/on/demandware.store/Sites-eMEGA-Site/default/Product-Variation?pid=B08BDVMZP4&quantity=8"
      },
      {
        "value": "9",
        "selected": false,
        "url": "/on/demandware.store/Sites-eMEGA-Site/default/Product-Variation?pid=B08BDVMZP4&quantity=9"
      },
      {
        "value": "10",
        "selected": false,
        "url": "/on/demandware.store/Sites-eMEGA-Site/default/Product-Variation?pid=B08BDVMZP4&quantity=10"
      }
    ],
    "selectedProductUrl": "/eMEGA/B08BDVMZP4.html?%2FeMEGA%2FB08BDVMZP4.html=undefined&quantity=undefined",
    "readyToOrder": true,
    "online": true,
    "pageTitle": null,
    "pageDescription": null,
    "pageKeywords": null,
    "pageMetaTags": [
      {},
      {},
      {},
      {}
    ],
    "template": null
  },
  "addToCartUrl": {},
  "resources": {
    "info_selectforstock": "Select Styles for Availability",
    "assistiveSelectedText": "selected"
  },
  "quickViewFullDetailMsg": "View Full Details",
  "closeButtonText": "Close Quickview Dialog",
  "enterDialogMessage": "Start of Quickview dialog window. Select Close to cancel and close the window.",
  "template": "product/quickView.isml",
  "renderedTemplate": "<div class=\"product-quickview product-standard col product-wrapper product-detail\" data-pid=\"B08BDVMZP4\">\n    <div class=\"row\">\n        <!-- Product Images Carousel -->\n        \n\n<div class=\"primary-images col-12 col-sm-6 cst-gallery-wrap\">\n\n    \n    <div id=\"pdpCarousel-B08BDVMZP4\" class=\"carousel slide cst-original-carousel\" data-interval=\"0\"\n        data-prev=\"Previous\"\n        data-next=\"Next\">\n        \n            <ol class=\"carousel-indicators\" aria-hidden=\"true\">\n                \n                    <li data-target=\" #pdpCarousel-B08BDVMZP4\" data-slide-to=\"0\"\n                        class='active'></li>\n                \n                    <li data-target=\" #pdpCarousel-B08BDVMZP4\" data-slide-to=\"1\"\n                        class=''></li>\n                \n            </ol>\n        \n        <div class=\"carousel-inner\" role=\"listbox\">\n            \n                <div class='carousel-item active'>\n                    <img src=\"/on/demandware.static/-/Sites-storefront-catalog-m-en/default/dw60acf976/images/large/8dcd9d28100db4448457af253b2f6636.png\" class=\"d-block img-fluid\" alt=\"Beginner'S Guide to Google Sheets image number 0\"\n                        itemprop=\"image\" />\n                </div>\n            \n                <div class='carousel-item '>\n                    <img src=\"/on/demandware.static/-/Sites-storefront-catalog-m-en/default/dwad5f672f/images/large/fcc354bbb2d621e1a76c456338cdaac2.png\" class=\"d-block img-fluid\" alt=\"Beginner'S Guide to Google Sheets image number 1\"\n                        itemprop=\"image\" />\n                </div>\n            \n        </div>\n        \n            <a class=\"carousel-control-prev\" href=\" #pdpCarousel-B08BDVMZP4\" role=\"button\" data-slide=\"prev\">\n                <span class=\"fa icon-prev\" aria-hidden=\"true\"></span>\n                <span class=\"sr-only\">Previous</span>\n            </a>\n            <a class=\"carousel-control-next\" href=\" #pdpCarousel-B08BDVMZP4\" role=\"button\" data-slide=\"next\">\n                <span class=\"fa icon-next\" aria-hidden=\"true\"></span>\n                <span class=\"sr-only\">Next</span>\n            </a>\n        \n    </div>\n\n    \n    <div class=\"cst-gallery\" id=\"cst-gallery-B08BDVMZP4\" data-pid=\"B08BDVMZP4\" data-title=\"Beginner'S Guide to Google Sheets\"\n        data-first-img=\"/on/demandware.static/-/Sites-storefront-catalog-m-en/default/dw60acf976/images/large/8dcd9d28100db4448457af253b2f6636.png\">\n\n        \n        <div class=\"cst-gallery__thumbs\" id=\"cst-thumbs-B08BDVMZP4\">\n            \n                \n                    <button class=\"cst-gallery__thumb is-active\"\n                type=\"button\" data-index=\"0\" data-large=\"/on/demandware.static/-/Sites-storefront-catalog-m-en/default/dw60acf976/images/large/8dcd9d28100db4448457af253b2f6636.png\"\n                aria-label=\"Image 1\">\n                <img src=\"/on/demandware.static/-/Sites-storefront-catalog-m-en/default/dw60acf976/images/large/8dcd9d28100db4448457af253b2f6636.png\" alt=\"Beginner'S Guide to Google Sheets\" loading=\"lazy\" />\n                </button>\n                \n            \n                \n                    <button class=\"cst-gallery__thumb \"\n                type=\"button\" data-index=\"1\" data-large=\"/on/demandware.static/-/Sites-storefront-catalog-m-en/default/dwad5f672f/images/large/fcc354bbb2d621e1a76c456338cdaac2.png\"\n                aria-label=\"Image 2\">\n                <img src=\"/on/demandware.static/-/Sites-storefront-catalog-m-en/default/dwad5f672f/images/large/fcc354bbb2d621e1a76c456338cdaac2.png\" alt=\"Beginner'S Guide to Google Sheets\" loading=\"lazy\" />\n                </button>\n                \n            \n            \n        </div>\n\n        \n        <div class=\"cst-gallery__main\">\n            <div class=\"cst-gallery__main-inner\" id=\"cst-main-inner-B08BDVMZP4\">\n                <img class=\"cst-gallery__main-img\" id=\"cst-main-img-B08BDVMZP4\"\n                    src=\"/on/demandware.static/-/Sites-storefront-catalog-m-en/default/dw60acf976/images/large/8dcd9d28100db4448457af253b2f6636.png\" alt=\"Beginner'S Guide to Google Sheets\" />\n                <div class=\"cst-gallery__zoom-panel\" id=\"cst-zoom-panel-B08BDVMZP4\">\n                    <img class=\"cst-gallery__zoom-img\" id=\"cst-zoom-img-B08BDVMZP4\"\n                        src=\"/on/demandware.static/-/Sites-storefront-catalog-m-en/default/dw60acf976/images/large/8dcd9d28100db4448457af253b2f6636.png\" alt=\"\" />\n                </div>\n                <div class=\"cst-gallery__fullview-overlay\" id=\"cst-fullview-B08BDVMZP4\">\n                    <svg width=\"16\" height=\"16\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\"\n                        stroke-width=\"2.5\">\n                        <circle cx=\"11\" cy=\"11\" r=\"8\" />\n                        <line x1=\"21\" y1=\"21\" x2=\"16.65\" y2=\"16.65\" />\n                        <line x1=\"11\" y1=\"8\" x2=\"11\" y2=\"14\" />\n                        <line x1=\"8\" y1=\"11\" x2=\"14\" y2=\"11\" /></svg>\n                    Click to see full view\n                </div>\n            </div>\n        </div>\n    </div>\n\n    \n\n    <script type=\"application/json\" id=\"cst-imgs-B08BDVMZP4\">\n        [{\"url\":\"/on/demandware.static/-/Sites-storefront-catalog-m-en/default/dw60acf976/images/large/8dcd9d28100db4448457af253b2f6636.png\",\"alt\":\"Beginner'S Guide to Google Sheets\"},{\"url\":\"/on/demandware.static/-/Sites-storefront-catalog-m-en/default/dwad5f672f/images/large/fcc354bbb2d621e1a76c456338cdaac2.png\",\"alt\":\"Beginner'S Guide to Google Sheets\"}]\n        </script>\n\n\n</div>\n\n        <!-- Product Name and Number -->\n        <div class=\"col-sm-6\">\n            <div class=\"row\">\n                <div class=\"col\">\n                    <section>\n                        <h1 class=\"product-name\">Beginner'S Guide to Google Sheets</h1>\n                    </section>\n                </div>\n            </div>\n\n            <div class=\"detail-panel\">\n                <!-- Attributes -->\n                <section class=\"attributes\">\n\n                    <div class=\"row\">\n    <div class=\"col\">\n        \n    </div>\n</div>\n\n\n                        \n\n                        <div class=\"d-sm-none row availability align-self-end \" data-ready-to-order=\"true\" data-available=\"true\">\n                            \n<div class=\"col-4\">\n    <span class=\"availability non-input-label\">\n        Availability:\n    </span>\n</div>\n<div class=\"col-8\">\n    <ul class=\"list-unstyled availability-msg\">\n        <li>\n            \n                \n                    <div>In Stock</div>\n                \n            \n        </li>\n    </ul>\n</div>\n\n\n                        </div>\n\n                    <hr>\n\n                    <!-- Applicable Promotions -->\n                    <div class=\"row\">\n                        <div class=\"col-12 promotions\">\n                            <div class=\"align-self-center\">\n                                \n\n                            </div>\n                        </div>\n                    </div>\n                </section>\n\n                \n                    <!-- Options -->\n                    \n                \n            </div>\n        </div>\n    </div>\n\n    \n\n    \n</div>\n<div class=\"modal-footer row align-items-end\">\n    \n\n    <div class=\"hidden-xs-down col availability align-self-end global-availability\" data-ready-to-order=\"true\" data-available=\"true\">\n        <div class=\"row\">\n            \n<div class=\"col-4\">\n    <span class=\"availability non-input-label\">\n        Availability:\n    </span>\n</div>\n<div class=\"col-8\">\n    <ul class=\"list-unstyled availability-msg\">\n        <li>\n            \n                \n                    <div>In Stock</div>\n                \n            \n        </li>\n    </ul>\n</div>\n\n\n        </div>\n    </div>\n\n    <div class=\"col\">\n        <div class=\"row align-items-end\">\n            <!-- Quantity -->\n            <div class=\"hidden-xs-down col-4\">\n                \n                    \n<label for=\"quantity-1\">Quantity</label>\n<select class=\"quantity-select custom-select form-control\" id=\"quantity-1\">\n    \n        <option value=\"1\"\n                data-url=\"/on/demandware.store/Sites-eMEGA-Site/default/Product-Variation?pid=B08BDVMZP4&amp;quantity=1\"\n                selected\n        >\n            1\n        </option>\n    \n        <option value=\"2\"\n                data-url=\"/on/demandware.store/Sites-eMEGA-Site/default/Product-Variation?pid=B08BDVMZP4&amp;quantity=2\"\n                \n        >\n            2\n        </option>\n    \n        <option value=\"3\"\n                data-url=\"/on/demandware.store/Sites-eMEGA-Site/default/Product-Variation?pid=B08BDVMZP4&amp;quantity=3\"\n                \n        >\n            3\n        </option>\n    \n        <option value=\"4\"\n                data-url=\"/on/demandware.store/Sites-eMEGA-Site/default/Product-Variation?pid=B08BDVMZP4&amp;quantity=4\"\n                \n        >\n            4\n        </option>\n    \n        <option value=\"5\"\n                data-url=\"/on/demandware.store/Sites-eMEGA-Site/default/Product-Variation?pid=B08BDVMZP4&amp;quantity=5\"\n                \n        >\n            5\n        </option>\n    \n        <option value=\"6\"\n                data-url=\"/on/demandware.store/Sites-eMEGA-Site/default/Product-Variation?pid=B08BDVMZP4&amp;quantity=6\"\n                \n        >\n            6\n        </option>\n    \n        <option value=\"7\"\n                data-url=\"/on/demandware.store/Sites-eMEGA-Site/default/Product-Variation?pid=B08BDVMZP4&amp;quantity=7\"\n                \n        >\n            7\n        </option>\n    \n        <option value=\"8\"\n                data-url=\"/on/demandware.store/Sites-eMEGA-Site/default/Product-Variation?pid=B08BDVMZP4&amp;quantity=8\"\n                \n        >\n            8\n        </option>\n    \n        <option value=\"9\"\n                data-url=\"/on/demandware.store/Sites-eMEGA-Site/default/Product-Variation?pid=B08BDVMZP4&amp;quantity=9\"\n                \n        >\n            9\n        </option>\n    \n        <option value=\"10\"\n                data-url=\"/on/demandware.store/Sites-eMEGA-Site/default/Product-Variation?pid=B08BDVMZP4&amp;quantity=10\"\n                \n        >\n            10\n        </option>\n    \n</select>\n\n                \n            </div>\n\n            <div class=\"col-8 mx-auto\">\n                <!-- Prices -->\n                <div class=\"prices\">\n                    \n                    \n\n    <div class=\"price\">\n        \n        \n<span>\n    \n\n    \n        \n        <del>\n            <span class=\"strike-through list\">\n                <span class=\"value\" content=\"34.60\">\n                    <span class=\"sr-only\">\n                        Price reduced from\n                    </span>\n                    A$34.60\n\n\n                    <span class=\"sr-only\">\n                        to\n                    </span>\n                </span>\n            </span>\n        </del>\n    \n\n    \n    <span class=\"sales\">\n        \n        \n        \n            <span class=\"value\" content=\"27.95\"></span>\n        \n        A$27.95\n\n\n    </span>\n</span>\n\n    </div>\n\n\n                </div>\n\n                <!-- Cart and [Optionally] Apple Pay -->\n                \n                    \n<div class=\"row cart-and-ipay\">\n    <div class=\"col-sm-12\">\n        <input type=\"hidden\" class=\"add-to-cart-url\" value=\"/on/demandware.store/Sites-eMEGA-Site/default/Cart-AddProduct\">\n        <button class=\"add-to-cart-global btn btn-primary\"\n                data-pid=\"B08BDVMZP4\"\n                >\n            <i class=\"fa fa-shopping-bag\"></i>\n            \n                Add to Cart\n            \n        </button>\n    </div>\n</div>\n\n                \n            </div>\n        </div>\n    </div>\n</div>\n",
  "productUrl": "/eMEGA/B08BDVMZP4.html"
}