{"id":5500,"date":"2023-12-11T10:10:19","date_gmt":"2023-12-11T10:10:19","guid":{"rendered":"https:\/\/www.pickl.ai\/blog\/?post_type=web-story&#038;p=5500"},"modified":"2023-12-11T10:10:20","modified_gmt":"2023-12-11T10:10:20","slug":"data-validation-in-ms-excel","status":"publish","type":"web-story","link":"https:\/\/www.pickl.ai\/blog\/web-stories\/data-validation-in-ms-excel\/","title":{"rendered":"Data Validation in Ms Excel"},"content":{"rendered":"<p><html amp=\"\" lang=\"en\"><head><meta charSet=\"utf-8\"\/><meta name=\"viewport\" content=\"width=device-width,minimum-scale=1,initial-scale=1\"\/><script async=\"\" src=\"https:\/\/cdn.ampproject.org\/v0.js\"><\/script><script async=\"\" src=\"https:\/\/cdn.ampproject.org\/v0\/amp-story-1.0.js\" custom-element=\"amp-story\"><\/script><link href=\"https:\/\/fonts.googleapis.com\/css2?display=swap&amp;family=Roboto%3Awght%40700&amp;family=Alegreya%3Awght%40700\" rel=\"stylesheet\"\/><link href=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/2.png\" rel=\"preload\" as=\"image\"\/>\n<style amp-boilerplate=\"\">body{-webkit-animation:-amp-start 8s steps(1,end) 0s 1 normal both;-moz-animation:-amp-start 8s steps(1,end) 0s 1 normal both;-ms-animation:-amp-start 8s steps(1,end) 0s 1 normal both;animation:-amp-start 8s steps(1,end) 0s 1 normal both}@-webkit-keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}@-moz-keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}@-ms-keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}@-o-keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}@keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}<\/style>\n<p><noscript><\/p>\n<style amp-boilerplate=\"\">body{-webkit-animation:none;-moz-animation:none;-ms-animation:none;animation:none}<\/style>\n<p><\/noscript><\/p>\n<style amp-custom=\"\">\n              h1, h2, h3 { font-weight: normal; }<\/p>\n<p>              amp-story-page {\n                background-color: #131516;\n              }<\/p>\n<p>              amp-story-grid-layer {\n                overflow: visible;\n              }<\/p>\n<p>              @media (max-aspect-ratio: 9 \/ 16)  {\n                @media (min-aspect-ratio: 320 \/ 678) {\n                  amp-story-grid-layer.grid-layer {\n                    margin-top: calc((100% \/ 0.5625 - 100% \/ 0.6666666666666666) \/ 2);\n                  }\n                }\n              }<\/p>\n<p>              @media not all and (min-resolution:.001dpcm) {\n                @media {\n                  p.text-wrapper > span {\n                    font-size: calc(100% - 0.5px);\n                  }\n                }\n              }<\/p>\n<p>              .page-fullbleed-area,\n              .page-background-overlay-area {\n                position: absolute;\n                overflow: hidden;\n                width: 100%;\n                left: 0;\n                height: calc(1.1851851851851851 * 100%);\n                top: calc((1 - 1.1851851851851851) * 100% \/ 2);\n              }<\/p>\n<p>              .element-overlay-area {\n                position: absolute;\n                width: 100%;\n                height: 100%;\n                top: 0;\n                left: 0;\n              }<\/p>\n<p>              .page-safe-area {\n                overflow: visible;\n                position: absolute;\n                top: 0;\n                bottom: 0;\n                left: 0;\n                right: 0;\n                width: 100%;\n                height: calc(0.84375 * 100%);\n                margin: auto 0;\n              }<\/p>\n<p>              .mask {\n                position: absolute;\n                overflow: hidden;\n              }<\/p>\n<p>              .fill {\n                position: absolute;\n                top: 0;\n                left: 0;\n                right: 0;\n                bottom: 0;\n                margin: 0;\n              }<\/p>\n<p>              @media (prefers-reduced-motion: no-preference) {\n                .animation-wrapper {\n                  opacity: var(--initial-opacity);\n                  transform: var(--initial-transform);\n                }\n              }<\/p>\n<p>              amp-story-grid-layer.align-bottom {\n                align-content: end;\n                padding: 0;\n                \/* \n                  AMP CTA Layer will exactly occupy 74px regardless of any device.\n                  To space out captions 74px from the BOTTOM (AMP CTA Layer),\n                  74px from the TOP should also be spaced out and thus: 2 * 74px\n                  will be the desired max-height.\n                *\/\n                max-height: calc(100vh - (2 * 74px));\n              }<\/p>\n<p>              .captions-area {\n                padding: 0 32px 0;\n              }<\/p>\n<p>              amp-story-captions {\n                margin-bottom: 16px;\n                text-align: center;\n              }\n              <\/style>\n<p><meta name=\"web-stories-replace-head-start\"\/><title>Data Validation in Ms Excel<\/title><link rel=\"canonical\" href=\"https:\/\/pickl.ai\/blog\/?post_type=web-story&amp;p=5500\"\/><meta name=\"web-stories-replace-head-end\"\/><\/head><body><amp-story standalone=\"\" publisher=\"Pickl.AI\" publisher-logo-src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2022\/01\/cropped-cropped-favicon.png\" title=\"Data Validation in Ms Excel\" poster-portrait-src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/cropped-2.png\"><amp-story-page id=\"c9cebe1e-d2e1-483f-b389-52fa018a8e04\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#77be92\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-6ce8d812-7db2-4b56-8875-57dd23bf7e41\">\n<div style=\"position:absolute;width:100%;height:100%;left:0%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/2.png\" alt=\"2\" srcSet=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/2.png 1080w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/2-864x1536.png 864w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/2-768x1365.png 768w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/2-576x1024.png 576w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/2-169x300.png 169w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/2-150x267.png 150w\" sizes=\"(min-width: 1024px) 45vh, 100vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\"><\/div>\n<\/div>\n<p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"275eca8a-ff39-48dc-8b04-b85846a7ffff\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#d4e4c0\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-8f76cffc-50e3-4bc2-b49a-d67b08dd819c\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:-4.12621%;top:92.39482%;width:33.25243%;height:22.16828%;opacity:0.6\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;transform:scale3d(-1, 1, 1)\" id=\"el-aa9fae12-68e7-423f-8b49-1ce6b768bded\"><svg style=\"display:block;position:absolute;top:0;height:100%;width:auto\" viewBox=\"0 0 40 40\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><title>Circled Dot<\/title><path d=\"M20 29.5652c5.2827 0 9.5652-4.2825 9.5652-9.5652 0-5.2828-4.2825-9.5653-9.5652-9.5653-5.2828 0-9.5653 4.2825-9.5653 9.5653 0 5.2827 4.2825 9.5652 9.5653 9.5652z\" fill=\"#fff\"><\/path><path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M40 20c0 11.0457-8.9543 20-20 20S0 31.0457 0 20 8.9543 0 20 0s20 8.9543 20 20zm-1.2903 0c0 10.3331-8.3766 18.7097-18.7097 18.7097C9.66693 38.7097 1.29032 30.3331 1.29032 20 1.29032 9.66693 9.66693 1.29032 20 1.29032c10.3331 0 18.7097 8.37661 18.7097 18.70968z\" fill=\"#fff\"><\/path><\/svg><\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:12.37864%;top:61.65049%;width:75.72816%;height:41.74757%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-131702b9-a144-4cc5-98da-a8722b0eab17\">\n<div style=\"position:absolute;width:124.01422%;height:100%;left:-12.00711%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-scaled.jpg\" alt=\"Data-driven marketing and competitor analysis, concepts of marke\" srcSet=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-scaled.jpg 2560w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-2048x1365.jpg 2048w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-1536x1024.jpg 1536w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-1024x683.jpg 1024w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-900x600.jpg 900w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-768x512.jpg 768w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-300x200.jpg 300w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-150x100.jpg 150w\" sizes=\"(min-width: 1024px) 34vh, 76vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:0;width:76.69903%;height:18.93204%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6329113924050633% 0.6329113924050633% 0.6329113924050633% 0.6329113924050633% \/ 1.7094017094017095% 1.7094017094017095% 1.7094017094017095% 1.7094017094017095%\" id=\"el-6745f7d9-4fba-4882-9e37-f89b1ad957f7\">\n<h2 id=\"ms-excel-empowering-data-analysts-worldwide\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.09464003164556899% 0;font-family:&quot;Roboto&quot;,&quot;Helvetica Neue&quot;,&quot;Helvetica&quot;,sans-serif;font-size:0.533981em;line-height:1.19;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; text-decoration: underline; color: #e06e04\">MS Excel: Empowering Data Analysts Worldwide<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:12.37864%;top:25.08091%;width:68.4466%;height:20.22654%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.7092198581560284% 0.7092198581560284% 0.7092198581560284% 0.7092198581560284% \/ 1.6% 1.6% 1.6% 1.6%\" id=\"el-710867a7-12e3-47ab-a48f-ffbfcfedc3d6\">\n<p class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.48528368794326276% 0;font-family:&quot;Alegreya&quot;,serif;font-size:0.275081em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700\">MS Excel is a powerhouse for data analysts, equipped with built-in pivot tables.<\/span><br \/>\n<span style=\"font-weight: 700\">One can efficiently manage, import, export, clean, and analyze data within one application.<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:23.05825%;top:50%;width:50%;height:6.14887%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-44d43c93-48bb-456c-affe-1d4d81bdd1e8\">\n<div class=\"fill\" style=\"background-color:rgba(255,255,183,0.3);will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:28.8835%;top:50.97087%;width:35.19417%;height:4.85437%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:1.3793103448275863% 1.3793103448275863% 1.3793103448275863% 1.3793103448275863% \/ 6.666666666666667% 6.666666666666667% 6.666666666666667% 6.666666666666667%\" id=\"el-57478bd7-f92e-469b-a59d-15a3952ffec0\"><a href=\"https:\/\/ https:\/\/pickl.ai\/blog\/data-validation-in-ms-excel\/\" target=\"_blank\" rel=\"noreferrer noopener\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\"><\/p>\n<h2 id=\"learn-more\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.26185344827586154% 0;font-family:&quot;Roboto&quot;,&quot;Helvetica Neue&quot;,&quot;Helvetica&quot;,sans-serif;font-size:0.436893em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700\">Learn More<\/span><\/span><\/h2>\n<p><\/a><\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:81.31068%;top:103.39806%;width:14.07767%;height:5.17799%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" id=\"el-3146f7ca-59cc-44d0-99c4-fa7e53e24645\"><svg style=\"display:block;position:absolute;top:0;height:100%;width:auto\" viewBox=\"0 0 16 9\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><title>Arrow<\/title><path d=\"M15.8206 4.43678c.2145-.21453.2145-.56235 0-.77688L12.3246.163967c-.2145-.2145284-.5623-.2145284-.7769 0-.2145.214528-.2145.562346 0 .776874l3.1075 3.107499-3.1075 3.1075c-.2145.21453-.2145.56235 0 .77687.2146.21453.5624.21453.7769 0l3.496-3.49593zM.0507812 4.59767H15.4321V3.49901H.0507812v1.09866z\" fill=\"#212121\"><\/path><\/svg><\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:80.82524%;top:-16.99029%;width:33.25243%;height:22.16828%;opacity:0.6\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" id=\"el-1c2a2cda-4bb0-47f9-b505-5aac04c0a32e\"><svg style=\"display:block;position:absolute;top:0;height:100%;width:auto\" viewBox=\"0 0 40 40\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><title>Circled Dot<\/title><path d=\"M20 29.5652c5.2827 0 9.5652-4.2825 9.5652-9.5652 0-5.2828-4.2825-9.5653-9.5652-9.5653-5.2828 0-9.5653 4.2825-9.5653 9.5653 0 5.2827 4.2825 9.5652 9.5653 9.5652z\" fill=\"#fff\"><\/path><path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M40 20c0 11.0457-8.9543 20-20 20S0 31.0457 0 20 8.9543 0 20 0s20 8.9543 20 20zm-1.2903 0c0 10.3331-8.3766 18.7097-18.7097 18.7097C9.66693 38.7097 1.29032 30.3331 1.29032 20 1.29032 9.66693 9.66693 1.29032 20 1.29032c10.3331 0 18.7097 8.37661 18.7097 18.70968z\" fill=\"#fff\"><\/path><\/svg><\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"2333dae7-827e-48da-ae2d-0cf07c7aeb77\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#d4e4c0\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-4797b14d-cb05-4703-ab3c-67a900b2d862\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:12.62136%;top:43.68932%;width:76.69903%;height:12.62136%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6329113924050633% 0.6329113924050633% 0.6329113924050633% 0.6329113924050633% \/ 2.564102564102564% 2.564102564102564% 2.564102564102564% 2.564102564102564%\" id=\"el-d1d3e045-7e4a-4ea6-b2cb-7cdad7d92df1\">\n<h2 id=\"understanding-data-validation\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.09464003164556899% 0;font-family:&quot;Roboto&quot;,&quot;Helvetica Neue&quot;,&quot;Helvetica&quot;,sans-serif;font-size:0.533981em;line-height:1.19;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; text-decoration: underline; color: #3d6184\">Understanding Data Validation<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:12.62136%;top:62.45955%;width:70.87379%;height:24.91909%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.684931506849315% 0.684931506849315% 0.684931506849315% 0.684931506849315% \/ 1.2987012987012987% 1.2987012987012987% 1.2987012987012987% 1.2987012987012987%\" id=\"el-82f60b12-18a9-4425-a664-f5baada14965\">\n<h3 id=\"data-validation-in-ms-excel-ensures-accurate-entries-by-allowing-users-to-define-rules-maintaining-data-integrity-and-preventing-errors-in-spreadsheets\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.5789383561643836% 0;font-family:&quot;Alegreya&quot;,serif;font-size:0.339806em;line-height:1.2;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700\">Data Validation in MS Excel ensures accurate entries by allowing users to define rules, maintaining data integrity and preventing errors in spreadsheets.<\/span><\/span><\/h3>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:20.87379%;top:93.3657%;width:51.69903%;height:6.14887%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-27b7d16c-d3c1-4de8-8d61-68e5d35f7ce3\">\n<div class=\"fill\" style=\"background-color:rgba(13,27,43,0.3);will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:28.39806%;top:94.33657%;width:35.19417%;height:4.85437%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:1.3793103448275863% 1.3793103448275863% 1.3793103448275863% 1.3793103448275863% \/ 6.666666666666667% 6.666666666666667% 6.666666666666667% 6.666666666666667%\" id=\"el-5afbf243-9274-4d03-bf7b-998b5848f84f\"><a href=\"https:\/\/pickl.ai\/blog\/why-is-data-visualization-important\/\" data-tooltip-icon=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/01\/Importance-of-Data-Visualization.jpg\" data-tooltip-text=\"Importance of Data Visualization- Pickl.AI\" target=\"_blank\" rel=\"noreferrer noopener\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\"><\/p>\n<h2 id=\"learn-more-2\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.26185344827586154% 0;font-family:&quot;Roboto&quot;,&quot;Helvetica Neue&quot;,&quot;Helvetica&quot;,sans-serif;font-size:0.436893em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700\">Learn More<\/span><\/span><\/h2>\n<p><\/a><\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:-0.48544%;width:76.69903%;height:36.73139%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-9490a3c3-a6c4-4814-8e22-e3ccbc559c9c\">\n<div style=\"position:absolute;width:111.31884%;height:100%;left:-5.65942%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-scaled.jpg\" alt=\"\" srcSet=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-scaled.jpg 2560w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-2048x1322.jpg 2048w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-1536x991.jpg 1536w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-1024x661.jpg 1024w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-768x496.jpg 768w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-300x194.jpg 300w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-150x97.jpg 150w\" sizes=\"(min-width: 1024px) 35vh, 77vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:81.31068%;top:103.39806%;width:14.07767%;height:5.17799%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" id=\"el-7ba68443-2b71-463b-a080-98e9a9d43821\"><svg style=\"display:block;position:absolute;top:0;height:100%;width:auto\" viewBox=\"0 0 16 9\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><title>Arrow<\/title><path d=\"M15.8206 4.43678c.2145-.21453.2145-.56235 0-.77688L12.3246.163967c-.2145-.2145284-.5623-.2145284-.7769 0-.2145.214528-.2145.562346 0 .776874l3.1075 3.107499-3.1075 3.1075c-.2145.21453-.2145.56235 0 .77687.2146.21453.5624.21453.7769 0l3.496-3.49593zM.0507812 4.59767H15.4321V3.49901H.0507812v1.09866z\" fill=\"#212121\"><\/path><\/svg><\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"14285f23-8ef8-4142-b5a7-e6fe0045b124\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#d4e4c0\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-8c62242e-1316-4d3f-b801-cce784f21943\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:12.62136%;top:44.98382%;width:76.69903%;height:12.62136%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6329113924050633% 0.6329113924050633% 0.6329113924050633% 0.6329113924050633% \/ 2.564102564102564% 2.564102564102564% 2.564102564102564% 2.564102564102564%\" id=\"el-1ec7bcef-e296-471c-b70e-b69ed7a5705a\">\n<h2 id=\"step-by-step-guide-for-data-validation\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.09464003164556899% 0;font-family:&quot;Roboto&quot;,&quot;Helvetica Neue&quot;,&quot;Helvetica&quot;,sans-serif;font-size:0.533981em;line-height:1.19;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; text-decoration: underline; color: #dbca09\">Step-by-Step Guide for Data Validation<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:13.34951%;top:62.62136%;width:73.30097%;height:21.68285%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6622516556291391% 0.6622516556291391% 0.6622516556291391% 0.6622516556291391% \/ 1.4925373134328357% 1.4925373134328357% 1.4925373134328357% 1.4925373134328357%\" id=\"el-05f37e0c-5e97-4afe-a36e-c20066616f50\">\n<h3 id=\"1-select-cells2-access-dialog-box3-set-validation-criteria-4-complete-setup\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.6930463576158946% 0;font-family:&quot;Alegreya&quot;,serif;font-size:0.420712em;line-height:1.2;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700\">1. Select Cells<\/span><br \/>\n<span style=\"font-weight: 700\">2. Access Dialog Box<\/span><br \/>\n<span style=\"font-weight: 700\">3. Set Validation Criteria&nbsp;<\/span><br \/>\n<span style=\"font-weight: 700\">4. Complete Setup<\/span><\/span><\/h3>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:25%;top:93.3657%;width:51.69903%;height:6.14887%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-683bfd00-43f9-465f-9169-ed3aeae0cbe8\">\n<div class=\"fill\" style=\"background-color:rgba(219,202,68,0.3);will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:32.52427%;top:94.33657%;width:35.19417%;height:4.85437%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:1.3793103448275863% 1.3793103448275863% 1.3793103448275863% 1.3793103448275863% \/ 6.666666666666667% 6.666666666666667% 6.666666666666667% 6.666666666666667%\" id=\"el-190e963f-a719-459c-a0a2-cbe34545f8bf\"><a href=\"https:\/\/pickl.ai\/blog\/how-to-perform-data-visualization-in-7-steps\/\" target=\"_blank\" rel=\"noreferrer noopener\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\"><\/p>\n<h2 id=\"learn-more-3\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.26185344827586154% 0;font-family:&quot;Roboto&quot;,&quot;Helvetica Neue&quot;,&quot;Helvetica&quot;,sans-serif;font-size:0.436893em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700\">Learn More<\/span><\/span><\/h2>\n<p><\/a><\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:10.92233%;top:0;width:77.42718%;height:39.96764%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-43accbd6-711c-4ed5-acc2-8ef4ceb5a308\">\n<div style=\"position:absolute;width:100%;height:129.14978%;left:0%;top:-14.57489%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/8502305.jpg\" alt=\"8502305\" srcSet=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/8502305.jpg 2000w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/8502305-1536x1536.jpg 1536w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/8502305-1024x1024.jpg 1024w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/8502305-768x768.jpg 768w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/8502305-300x300.jpg 300w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/8502305-150x150.jpg 150w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/8502305-96x96.jpg 96w\" sizes=\"(min-width: 1024px) 35vh, 77vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:81.31068%;top:103.39806%;width:14.07767%;height:5.17799%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" id=\"el-ac1d3f17-d376-4e4e-8698-d1dd9717760a\"><svg style=\"display:block;position:absolute;top:0;height:100%;width:auto\" viewBox=\"0 0 16 9\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><title>Arrow<\/title><path d=\"M15.8206 4.43678c.2145-.21453.2145-.56235 0-.77688L12.3246.163967c-.2145-.2145284-.5623-.2145284-.7769 0-.2145.214528-.2145.562346 0 .776874l3.1075 3.107499-3.1075 3.1075c-.2145.21453-.2145.56235 0 .77687.2146.21453.5624.21453.7769 0l3.496-3.49593zM.0507812 4.59767H15.4321V3.49901H.0507812v1.09866z\" fill=\"#212121\"><\/path><\/svg><\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"0c01c850-811f-4ac8-b500-c21fb76fd41b\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#fff\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-f6da47be-43c1-4bb4-b0bd-eabff7602ba7\">\n<div class=\"fill\" style=\"will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:17.47573%;top:45.63107%;width:70.87379%;height:8.73786%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.684931506849315% 0.684931506849315% 0.684931506849315% 0.684931506849315% \/ 3.7037037037037033% 3.7037037037037033% 3.7037037037037033% 3.7037037037037033%\" id=\"el-a5768e51-65a6-44b1-ad47-5f57de4c97e2\">\n<h1 id=\"conclusion\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.14276541095890322% 0;font-family:&quot;Roboto&quot;,&quot;Helvetica Neue&quot;,&quot;Helvetica&quot;,sans-serif;font-size:0.744337em;line-height:1.19;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700\">Conclusion<\/span><\/span><\/h1>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:17.47573%;top:55.50162%;width:70.87379%;height:44.33657%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.684931506849315% 0.684931506849315% 0.684931506849315% 0.684931506849315% \/ 0.7299270072992701% 0.7299270072992701% 0.7299270072992701% 0.7299270072992701%\" id=\"el-3e0d1eae-f4a0-4d6a-aa42-a2292598a903\">\n<h3 id=\"mastering-data-validation-in-ms-excel-is-essential-for-maintaining-data-accuracy-and-integrity-this-valuable-tool-prevents-errors-and-ensures-adherence-to-predefined-standards-enhancing-the-reliabil\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.689212328767123% 0;font-family:&quot;Alegreya&quot;,serif;font-size:0.404531em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #c18b17\">Mastering Data Validation in MS Excel is essential for maintaining data accuracy and integrity. This valuable tool prevents errors and ensures adherence to predefined standards, enhancing the reliability of Excel workbooks.<\/span><\/span><\/h3>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:9.95146%;top:5.50162%;width:80.09709%;height:35.59871%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-b8b5adf4-0a99-4bf5-a95f-afaa0a4b8262\">\n<div style=\"position:absolute;width:100%;height:100.01952%;left:0%;top:-0.00976%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-scaled.jpg\" alt=\"sticky_notes_gathering_ideas\" srcSet=\"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-scaled.jpg 2560w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-2048x1365.jpg 2048w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-1536x1024.jpg 1536w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-1024x683.jpg 1024w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-900x600.jpg 900w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-768x512.jpg 768w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-300x200.jpg 300w,https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-150x100.jpg 150w\" sizes=\"(min-width: 1024px) 36vh, 80vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><\/amp-story-page><\/amp-story><\/body><\/html><\/p>\n","protected":false},"excerpt":{"rendered":"Data Validation in Microsoft Excel is a crucial tool for enabling data analysis in organisations. \n","protected":false},"author":1,"featured_media":5506,"template":"","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"web_stories_publisher_logo":935,"web_stories_poster":[],"web_stories_products":[],"footnotes":""},"web_story_category":[],"web_story_tag":[],"class_list":["post-5500","web-story","type-web-story","status-publish","has-post-thumbnail"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Data Validation in Ms Excel - Pickl.AI<\/title>\n<meta name=\"description\" content=\"Data Validation in Microsoft Excel is a crucial tool for enabling data analysis in organisations.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pickl.ai\/blog\/web-stories\/data-validation-in-ms-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Validation in Ms Excel\" \/>\n<meta property=\"og:description\" content=\"Data Validation in Microsoft Excel is a crucial tool for enabling data analysis in organisations.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pickl.ai\/blog\/web-stories\/data-validation-in-ms-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Pickl.AI\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-11T10:10:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/cropped-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"853\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/data-validation-in-ms-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/data-validation-in-ms-excel\\\/\"},\"author\":{\"name\":\"Admin\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/adfcccafe1795b39fe941ddafe76b6ab\"},\"headline\":\"Data Validation in Ms Excel\",\"datePublished\":\"2023-12-11T10:10:19+00:00\",\"dateModified\":\"2023-12-11T10:10:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/data-validation-in-ms-excel\\\/\"},\"wordCount\":128,\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/data-validation-in-ms-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/cropped-2.png\",\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/data-validation-in-ms-excel\\\/\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/data-validation-in-ms-excel\\\/\",\"name\":\"Data Validation in Ms Excel - Pickl.AI\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/data-validation-in-ms-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/data-validation-in-ms-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/cropped-2.png\",\"datePublished\":\"2023-12-11T10:10:19+00:00\",\"dateModified\":\"2023-12-11T10:10:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/data-validation-in-ms-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/data-validation-in-ms-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/data-validation-in-ms-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/cropped-2.png\",\"contentUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/cropped-2.png\",\"width\":640,\"height\":853,\"caption\":\"2\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/data-validation-in-ms-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Stories\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/web-stories\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Data Validation in Ms Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\",\"name\":\"Pickl.AI\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/adfcccafe1795b39fe941ddafe76b6ab\",\"name\":\"Admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/353a2bc4d584bc0705a194ad6cd03043005eae6d6f8ecfe3f0ef286d7d4d1dc8?s=96&d=mm&r=ga50c9c5ae9fb5534aba0f0b45ebbe6d3\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/353a2bc4d584bc0705a194ad6cd03043005eae6d6f8ecfe3f0ef286d7d4d1dc8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/353a2bc4d584bc0705a194ad6cd03043005eae6d6f8ecfe3f0ef286d7d4d1dc8?s=96&d=mm&r=g\",\"caption\":\"Admin\"},\"sameAs\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\"],\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/administrator\\\/transorgstandbyorangeironman\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Data Validation in Ms Excel - Pickl.AI","description":"Data Validation in Microsoft Excel is a crucial tool for enabling data analysis in organisations.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pickl.ai\/blog\/web-stories\/data-validation-in-ms-excel\/","og_locale":"en_US","og_type":"article","og_title":"Data Validation in Ms Excel","og_description":"Data Validation in Microsoft Excel is a crucial tool for enabling data analysis in organisations.","og_url":"https:\/\/www.pickl.ai\/blog\/web-stories\/data-validation-in-ms-excel\/","og_site_name":"Pickl.AI","article_modified_time":"2023-12-11T10:10:20+00:00","og_image":[{"width":640,"height":853,"url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/cropped-2.png","type":"image\/png"}],"twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/data-validation-in-ms-excel\/#article","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/data-validation-in-ms-excel\/"},"author":{"name":"Admin","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/adfcccafe1795b39fe941ddafe76b6ab"},"headline":"Data Validation in Ms Excel","datePublished":"2023-12-11T10:10:19+00:00","dateModified":"2023-12-11T10:10:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/data-validation-in-ms-excel\/"},"wordCount":128,"image":{"@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/data-validation-in-ms-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/cropped-2.png","inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/data-validation-in-ms-excel\/","url":"https:\/\/www.pickl.ai\/blog\/web-stories\/data-validation-in-ms-excel\/","name":"Data Validation in Ms Excel - Pickl.AI","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/data-validation-in-ms-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/data-validation-in-ms-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/cropped-2.png","datePublished":"2023-12-11T10:10:19+00:00","dateModified":"2023-12-11T10:10:20+00:00","breadcrumb":{"@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/data-validation-in-ms-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pickl.ai\/blog\/web-stories\/data-validation-in-ms-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/data-validation-in-ms-excel\/#primaryimage","url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/cropped-2.png","contentUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/cropped-2.png","width":640,"height":853,"caption":"2"},{"@type":"BreadcrumbList","@id":"https:\/\/www.pickl.ai\/blog\/web-stories\/data-validation-in-ms-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pickl.ai\/blog\/"},{"@type":"ListItem","position":2,"name":"Stories","item":"https:\/\/www.pickl.ai\/blog\/web-stories\/"},{"@type":"ListItem","position":3,"name":"Data Validation in Ms Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.pickl.ai\/blog\/#website","url":"https:\/\/www.pickl.ai\/blog\/","name":"Pickl.AI","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pickl.ai\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/adfcccafe1795b39fe941ddafe76b6ab","name":"Admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/353a2bc4d584bc0705a194ad6cd03043005eae6d6f8ecfe3f0ef286d7d4d1dc8?s=96&d=mm&r=ga50c9c5ae9fb5534aba0f0b45ebbe6d3","url":"https:\/\/secure.gravatar.com\/avatar\/353a2bc4d584bc0705a194ad6cd03043005eae6d6f8ecfe3f0ef286d7d4d1dc8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/353a2bc4d584bc0705a194ad6cd03043005eae6d6f8ecfe3f0ef286d7d4d1dc8?s=96&d=mm&r=g","caption":"Admin"},"sameAs":["https:\/\/www.pickl.ai\/blog\/"],"url":"https:\/\/www.pickl.ai\/blog\/administrator\/transorgstandbyorangeironman\/"}]}},"story_data":{"version":47,"pages":[{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","width":1080,"height":1920,"sizes":{"medium":{"file":"2-169x300.png","width":169,"height":300,"filesize":25427,"mimeType":"image\/png","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/2-169x300.png"},"large":{"file":"2-576x1024.png","width":576,"height":1024,"filesize":165724,"mimeType":"image\/png","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/2-576x1024.png"},"thumbnail":{"file":"2-150x150.png","width":150,"height":150,"filesize":16380,"mimeType":"image\/png","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/2-150x150.png"},"medium_large":{"file":"2-768x1365.png","width":768,"height":1365,"filesize":281761,"mimeType":"image\/png","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/2-768x1365.png"},"1536x1536":{"file":"2-864x1536.png","width":864,"height":1536,"filesize":338494,"mimeType":"image\/png","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/2-864x1536.png"},"magine-hero":{"file":"2-1080x600.png","width":1080,"height":600,"filesize":203818,"mimeType":"image\/png","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/2-1080x600.png"},"magine-thumbnail":{"file":"2-900x600.png","width":900,"height":600,"filesize":167673,"mimeType":"image\/png","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/2-900x600.png"},"magine-vertical-thumbnail":{"file":"2-600x800.png","width":600,"height":800,"filesize":173692,"mimeType":"image\/png","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/2-600x800.png"},"web-stories-poster-portrait":{"file":"2-640x853.png","width":640,"height":853,"filesize":194087,"mimeType":"image\/png","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/2-640x853.png"},"web-stories-publisher-logo":{"file":"2-96x96.png","width":96,"height":96,"filesize":8954,"mimeType":"image\/png","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/2-96x96.png"},"web-stories-thumbnail":{"file":"2-150x267.png","width":150,"height":267,"filesize":21189,"mimeType":"image\/png","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/2-150x267.png"},"full":{"file":"2.png","width":1080,"height":1920,"mimeType":"image\/png","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/2.png"}},"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#77be92","blurHash":"UOGdx~WBJ6jc9XoMxafi9roMxafP~EWBIpah","creationDate":1702287347000,"src":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/2.png","id":5503,"alt":"2","local":false},"type":"image","x":4,"y":-60,"width":412,"height":762,"mask":{"type":"rectangle","showInLibrary":true,"name":"Rectangle","path":"M 0,0 1,0 1,1 0,1 0,0 Z","ratio":1,"supportsBorder":true},"id":"6ce8d812-7db2-4b56-8875-57dd23bf7e41","isBackground":true,"isHidden":false}],"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"id":"c9cebe1e-d2e1-483f-b389-52fa018a8e04","defaultBackgroundElement":{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"69daefff-7267-4ecd-a3d8-a2d0c5510d03"},"animations":[]},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"8f76cffc-50e3-4bc2-b49a-d67b08dd819c"},{"opacity":60,"flip":{"vertical":false,"horizontal":true},"rotationAngle":0,"lockAspectRatio":true,"width":137,"sticker":{"type":"fitnessCTA"},"type":"sticker","x":-17,"y":571,"height":137,"id":"aa9fae12-68e7-423f-8b49-1ce6b768bded"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/jpeg","width":2560,"height":1707,"sizes":{"medium":{"file":"datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-300x200.jpg","width":300,"height":200,"filesize":25951,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-300x200.jpg"},"large":{"file":"datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-1024x683.jpg","width":1024,"height":683,"filesize":83893,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-1024x683.jpg"},"thumbnail":{"file":"datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-150x150.jpg","width":150,"height":150,"filesize":20072,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-150x150.jpg"},"medium_large":{"file":"datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-768x512.jpg","width":768,"height":512,"filesize":60807,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-768x512.jpg"},"1536x1536":{"file":"datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-1536x1024.jpg","width":1536,"height":1024,"filesize":136754,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-1536x1024.jpg"},"2048x2048":{"file":"datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-2048x1365.jpg","width":2048,"height":1365,"filesize":199062,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-2048x1365.jpg"},"magine-hero":{"file":"datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-1400x600.jpg","width":1400,"height":600,"filesize":101610,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-1400x600.jpg"},"magine-thumbnail":{"file":"datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-900x600.jpg","width":900,"height":600,"filesize":73061,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-900x600.jpg"},"magine-vertical-thumbnail":{"file":"datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-600x800.jpg","width":600,"height":800,"filesize":70508,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-600x800.jpg"},"web-stories-poster-portrait":{"file":"datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-640x853.jpg","width":640,"height":853,"filesize":75349,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-640x853.jpg"},"web-stories-publisher-logo":{"file":"datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-96x96.jpg","width":96,"height":96,"filesize":16964,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-96x96.jpg"},"web-stories-thumbnail":{"file":"datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-150x100.jpg","width":150,"height":100,"filesize":18379,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-150x100.jpg"},"full":{"file":"datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-scaled.jpg","width":2560,"height":1707,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-scaled.jpg"}},"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#303432","blurHash":"U9D]VU~VD5-p00E1JTD%zUIV_M%fABwuvhof","creationDate":1702287417000,"src":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/datadriven-marketing-competitor-analysis-concepts-marketing-data-analysis-scaled.jpg","id":5504,"alt":"Data-driven marketing and competitor analysis, concepts of marke","local":false},"type":"image","x":51,"y":381,"width":312,"height":258,"mask":{"type":"rectangle","showInLibrary":true,"name":"Rectangle","path":"M 0,0 1,0 1,1 0,1 0,0 Z","ratio":1,"supportsBorder":true},"id":"131702b9-a144-4cc5-98da-a8722b0eab17"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":33,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.19,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; text-decoration: underline; color: #e06e04\">MS Excel: Empowering Data Analysts Worldwide<\/span>","x":48,"y":0,"width":316,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":117,"id":"6745f7d9-4fba-4882-9e37-f89b1ad957f7","marginOffset":0.598124999999996},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Alegreya"},"fontSize":17,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700\">MS Excel is a powerhouse for data analysts, equipped with built-in pivot tables.<\/span>\n<span style=\"font-weight: 700\">One can efficiently manage, import, export, clean, and analyze data within one application.<\/span>","x":51,"y":155,"width":282,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":125,"id":"710867a7-12e3-47ab-a48f-ffbfcfedc3d6"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":255,"g":255,"b":183,"a":0.3}},"width":206,"height":38,"type":"shape","x":95,"y":309,"mask":{"type":"rectangle"},"id":"44d43c93-48bb-456c-affe-1d4d81bdd1e8"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":27,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700\">Learn More<\/span>","x":119,"y":315,"width":145,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"type":"text","height":30,"id":"57478bd7-f92e-469b-a59d-15a3952ffec0","link":{"needsProxy":false,"url":" https:\/\/pickl.ai\/blog\/data-validation-in-ms-excel\/","rel":[],"type":"regular","pageId":null,"icon":null,"desc":null}},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"width":58,"sticker":{"type":"fashionArrowDark"},"type":"sticker","x":335,"y":639,"height":32,"id":"3146f7ca-59cc-44d0-99c4-fa7e53e24645"},{"opacity":60,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"width":137,"sticker":{"type":"fitnessCTA"},"x":333,"y":-105,"height":137,"id":"1c2a2cda-4bb0-47f9-b505-5aac04c0a32e","type":"sticker"}],"backgroundColor":{"color":{"r":212,"g":228,"b":192}},"id":"275eca8a-ff39-48dc-8b04-b85846a7ffff","animations":[]},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"id":"4797b14d-cb05-4703-ab3c-67a900b2d862","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":33,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.19,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; text-decoration: underline; color: #3d6184\">Understanding Data Validation<\/span>","x":52,"y":270,"width":316,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":78,"id":"d1d3e045-7e4a-4ea6-b2cb-7cdad7d92df1","marginOffset":0.598124999999996,"type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Alegreya"},"fontSize":21,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700\">Data Validation in MS Excel ensures accurate entries by allowing users to define rules, maintaining data integrity and preventing errors in spreadsheets.<\/span>","x":52,"y":386,"width":292,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":154,"id":"82f60b12-18a9-4425-a664-f5baada14965","type":"text","marginOffset":-3.5420000000000016},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":13,"g":27,"b":43,"a":0.3}},"width":213,"height":38,"x":86,"y":577,"mask":{"type":"rectangle"},"id":"27b7d16c-d3c1-4de8-8d61-68e5d35f7ce3","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":27,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700\">Learn More<\/span>","x":117,"y":583,"width":145,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":30,"id":"5afbf243-9274-4d03-bf7b-998b5848f84f","link":{"needsProxy":false,"url":"https:\/\/pickl.ai\/blog\/why-is-data-visualization-important\/","rel":[],"type":"regular","pageId":null,"icon":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/01\/Importance-of-Data-Visualization.jpg","desc":"Importance of Data Visualization- Pickl.AI"},"type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/jpeg","width":2560,"height":1652,"sizes":{"medium":{"file":"standard-quality-control-collage-concept-300x194.jpg","width":300,"height":194,"filesize":33639,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-300x194.jpg"},"large":{"file":"standard-quality-control-collage-concept-1024x661.jpg","width":1024,"height":661,"filesize":112864,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-1024x661.jpg"},"thumbnail":{"file":"standard-quality-control-collage-concept-150x150.jpg","width":150,"height":150,"filesize":26646,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-150x150.jpg"},"medium_large":{"file":"standard-quality-control-collage-concept-768x496.jpg","width":768,"height":496,"filesize":79660,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-768x496.jpg"},"1536x1536":{"file":"standard-quality-control-collage-concept-1536x991.jpg","width":1536,"height":991,"filesize":191341,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-1536x991.jpg"},"2048x2048":{"file":"standard-quality-control-collage-concept-2048x1322.jpg","width":2048,"height":1322,"filesize":284798,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-2048x1322.jpg"},"magine-hero":{"file":"standard-quality-control-collage-concept-1400x600.jpg","width":1400,"height":600,"filesize":133320,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-1400x600.jpg"},"magine-thumbnail":{"file":"standard-quality-control-collage-concept-900x600.jpg","width":900,"height":600,"filesize":99547,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-900x600.jpg"},"magine-vertical-thumbnail":{"file":"standard-quality-control-collage-concept-600x800.jpg","width":600,"height":800,"filesize":110634,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-600x800.jpg"},"web-stories-poster-portrait":{"file":"standard-quality-control-collage-concept-640x853.jpg","width":640,"height":853,"filesize":119985,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-640x853.jpg"},"web-stories-publisher-logo":{"file":"standard-quality-control-collage-concept-96x96.jpg","width":96,"height":96,"filesize":22693,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-96x96.jpg"},"web-stories-thumbnail":{"file":"standard-quality-control-collage-concept-150x97.jpg","width":150,"height":97,"filesize":24080,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-150x97.jpg"},"full":{"file":"standard-quality-control-collage-concept-scaled.jpg","width":2560,"height":1652,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-scaled.jpg"}},"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#ccbfc5","blurHash":"U8E{ty?a-.-;%%D%8wV@00WWt8S100xu9aWV","creationDate":"2023-12-07T11:59:38","src":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/standard-quality-control-collage-concept-scaled.jpg","id":5472,"alt":"","local":false},"type":"image","x":48,"y":-3,"width":316,"height":227,"mask":{"type":"rectangle","showInLibrary":true,"name":"Rectangle","path":"M 0,0 1,0 1,1 0,1 0,0 Z","ratio":1,"supportsBorder":true},"id":"9490a3c3-a6c4-4814-8e22-e3ccbc559c9c"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"width":58,"sticker":{"type":"fashionArrowDark"},"x":335,"y":639,"height":32,"id":"7ba68443-2b71-463b-a080-98e9a9d43821","type":"sticker"}],"backgroundColor":{"color":{"r":212,"g":228,"b":192}},"animations":[],"id":"2333dae7-827e-48da-ae2d-0cf07c7aeb77"},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"id":"8c62242e-1316-4d3f-b801-cce784f21943","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":33,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.19,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; text-decoration: underline; color: #dbca09\">Step-by-Step Guide for Data Validation<\/span>","x":52,"y":278,"width":316,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":78,"id":"1ec7bcef-e296-471c-b70e-b69ed7a5705a","marginOffset":0.598124999999996,"type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Alegreya"},"fontSize":26,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700\">1. Select Cells<\/span>\n<span style=\"font-weight: 700\">2. Access Dialog Box<\/span>\n<span style=\"font-weight: 700\">3. Set Validation Criteria&nbsp;<\/span>\n<span style=\"font-weight: 700\">4. Complete Setup<\/span>","x":55,"y":387,"width":302,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":134,"id":"05f37e0c-5e97-4afe-a36e-c20066616f50","marginOffset":-4.347000000000001,"type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundColor":{"color":{"r":219,"g":202,"b":68,"a":0.3}},"width":213,"height":38,"x":103,"y":577,"mask":{"type":"rectangle"},"id":"683bfd00-43f9-465f-9169-ed3aeae0cbe8","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":27,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700\">Learn More<\/span>","x":134,"y":583,"width":145,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":30,"id":"190e963f-a719-459c-a0a2-cbe34545f8bf","link":{"needsProxy":false,"url":"https:\/\/pickl.ai\/blog\/how-to-perform-data-visualization-in-7-steps\/","rel":[],"type":"regular","pageId":null,"icon":null,"desc":null},"type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/jpeg","width":2000,"height":2000,"sizes":{"medium":{"file":"8502305-300x300.jpg","width":300,"height":300,"filesize":15437,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/8502305-300x300.jpg"},"large":{"file":"8502305-1024x1024.jpg","width":1024,"height":1024,"filesize":60732,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/8502305-1024x1024.jpg"},"thumbnail":{"file":"8502305-150x150.jpg","width":150,"height":150,"filesize":8170,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/8502305-150x150.jpg"},"medium_large":{"file":"8502305-768x768.jpg","width":768,"height":768,"filesize":43276,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/8502305-768x768.jpg"},"1536x1536":{"file":"8502305-1536x1536.jpg","width":1536,"height":1536,"filesize":100005,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/8502305-1536x1536.jpg"},"magine-hero":{"file":"8502305-1400x600.jpg","width":1400,"height":600,"filesize":55501,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/8502305-1400x600.jpg"},"magine-thumbnail":{"file":"8502305-900x600.jpg","width":900,"height":600,"filesize":44361,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/8502305-900x600.jpg"},"magine-vertical-thumbnail":{"file":"8502305-600x800.jpg","width":600,"height":800,"filesize":40587,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/8502305-600x800.jpg"},"web-stories-poster-portrait":{"file":"8502305-640x853.jpg","width":640,"height":853,"filesize":44349,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/8502305-640x853.jpg"},"web-stories-publisher-logo":{"file":"8502305-96x96.jpg","width":96,"height":96,"filesize":5942,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/8502305-96x96.jpg"},"web-stories-thumbnail":{"file":"8502305-150x150.jpg","width":150,"height":150,"filesize":8170,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/8502305-150x150.jpg"},"full":{"file":"8502305.jpg","width":2000,"height":2000,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/8502305.jpg"}},"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#f5f2f4","blurHash":"UESiN-Dq%]??.htjVcVb.S$xRBIVHuNGt$xH","creationDate":1702288218000,"src":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/8502305.jpg","id":5505,"alt":"8502305","local":false},"type":"image","x":45,"y":0,"width":319,"height":247,"mask":{"type":"rectangle","showInLibrary":true,"name":"Rectangle","path":"M 0,0 1,0 1,1 0,1 0,0 Z","ratio":1,"supportsBorder":true},"id":"43accbd6-711c-4ed5-acc2-8ef4ceb5a308"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"width":58,"sticker":{"type":"fashionArrowDark"},"x":335,"y":639,"height":32,"id":"ac1d3f17-d376-4e4e-8698-d1dd9717760a","type":"sticker"}],"backgroundColor":{"color":{"r":212,"g":228,"b":192}},"animations":[],"id":"14285f23-8ef8-4142-b5a7-e6fe0045b124"},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"id":"f6da47be-43c1-4bb4-b0bd-eabff7602ba7","type":"shape"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto"},"fontSize":46,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.19,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700\">Conclusion<\/span>","x":72,"y":282,"width":292,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":54,"id":"a5768e51-65a6-44b1-ad47-5f57de4c97e2","marginOffset":0.8337499999999949,"type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Alegreya"},"fontSize":25,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #c18b17\">Mastering Data Validation in MS Excel is essential for maintaining data accuracy and integrity. This valuable tool prevents errors and ensures adherence to predefined standards, enhancing the reliability of Excel workbooks.<\/span>","x":72,"y":343,"width":292,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"height":274,"id":"3e0d1eae-f4a0-4d6a-aa42-a2292598a903","marginOffset":-4.024999999999999,"type":"text"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/jpeg","width":2560,"height":1707,"sizes":{"medium":{"file":"sticky_notes_gathering_ideas-300x200.jpg","width":300,"height":200,"filesize":35255,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-300x200.jpg"},"large":{"file":"sticky_notes_gathering_ideas-1024x683.jpg","width":1024,"height":683,"filesize":82097,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-1024x683.jpg"},"thumbnail":{"file":"sticky_notes_gathering_ideas-150x150.jpg","width":150,"height":150,"filesize":31489,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-150x150.jpg"},"medium_large":{"file":"sticky_notes_gathering_ideas-768x512.jpg","width":768,"height":512,"filesize":64026,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-768x512.jpg"},"1536x1536":{"file":"sticky_notes_gathering_ideas-1536x1024.jpg","width":1536,"height":1024,"filesize":122387,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-1536x1024.jpg"},"2048x2048":{"file":"sticky_notes_gathering_ideas-2048x1365.jpg","width":2048,"height":1365,"filesize":165856,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-2048x1365.jpg"},"magine-hero":{"file":"sticky_notes_gathering_ideas-1400x600.jpg","width":1400,"height":600,"filesize":97705,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-1400x600.jpg"},"magine-thumbnail":{"file":"sticky_notes_gathering_ideas-900x600.jpg","width":900,"height":600,"filesize":72531,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-900x600.jpg"},"magine-vertical-thumbnail":{"file":"sticky_notes_gathering_ideas-600x800.jpg","width":600,"height":800,"filesize":76627,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-600x800.jpg"},"web-stories-poster-portrait":{"file":"sticky_notes_gathering_ideas-640x853.jpg","width":640,"height":853,"filesize":80829,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-640x853.jpg"},"web-stories-publisher-logo":{"file":"sticky_notes_gathering_ideas-96x96.jpg","width":96,"height":96,"filesize":28508,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-96x96.jpg"},"web-stories-thumbnail":{"file":"sticky_notes_gathering_ideas-150x100.jpg","width":150,"height":100,"filesize":28990,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-150x100.jpg"},"full":{"file":"sticky_notes_gathering_ideas-scaled.jpg","width":2560,"height":1707,"mimeType":"image\/jpeg","sourceUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-scaled.jpg"}},"isPlaceholder":false,"isExternal":false,"needsProxy":false,"baseColor":"#e9dac3","blurHash":"UCQ9T7j]~Vjs-.jsn*j[^*j?9ZWXE3fkR%ay","creationDate":"2023-11-30T12:05:22","src":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2023\/11\/sticky_notes_gathering_ideas-scaled.jpg","id":5418,"alt":"sticky_notes_gathering_ideas","local":false},"type":"image","x":41,"y":34,"width":330,"height":220,"mask":{"type":"rectangle","showInLibrary":true,"name":"Rectangle","path":"M 0,0 1,0 1,1 0,1 0,0 Z","ratio":1,"supportsBorder":true},"id":"b8b5adf4-0a99-4bf5-a95f-afaa0a4b8262"}],"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"animations":[],"id":"0c01c850-811f-4ac8-b500-c21fb76fd41b"}],"fonts":{"Roboto":{"family":"Roboto","weights":[100,300,400,500,700,900],"styles":["italic","regular"],"variants":[[0,100],[1,100],[0,300],[1,300],[0,400],[1,400],[0,500],[1,500],[0,700],[1,700],[0,900],[1,900]],"fallbacks":["Helvetica Neue","Helvetica","sans-serif"],"service":"fonts.google.com","metrics":{"upm":2048,"asc":1900,"des":-500,"tAsc":1536,"tDes":-512,"tLGap":102,"wAsc":1946,"wDes":512,"xH":1082,"capH":1456,"yMin":-555,"yMax":2163,"hAsc":1900,"hDes":-500,"lGap":0}},"Alegreya":{"family":"Alegreya","fallbacks":["serif"],"weights":[400,500,600,700,800,900],"styles":["regular","italic"],"variants":[[0,400],[0,500],[0,600],[0,700],[0,800],[0,900],[1,400],[1,500],[1,600],[1,700],[1,800],[1,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1016,"des":-345,"tAsc":1016,"tDes":-345,"tLGap":0,"wAsc":1123,"wDes":345,"xH":452,"capH":637,"yMin":-293,"yMax":962,"hAsc":1016,"hDes":-345,"lGap":0}}},"autoAdvance":true,"defaultPageDuration":7,"currentStoryStyles":{"colors":[]}},"story_poster":{"id":5506,"url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2023\/12\/cropped-2.png","width":640,"height":853,"needsProxy":false},"_links":{"self":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/web-story\/5500","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/web-story"}],"about":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/types\/web-story"}],"author":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/users\/1"}],"version-history":[{"count":1,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/web-story\/5500\/revisions"}],"predecessor-version":[{"id":5507,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/web-story\/5500\/revisions\/5507"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/media\/5506"}],"wp:attachment":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/media?parent=5500"}],"wp:term":[{"taxonomy":"web_story_category","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/web_story_category?post=5500"},{"taxonomy":"web_story_tag","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/web_story_tag?post=5500"}],"wp:lock":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/web-story\/5500\/lock"}],"wp:publisherlogo":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/web-stories\/v1\/media\/935"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}