{"id":7192,"date":"2023-01-17T05:00:00","date_gmt":"2023-01-16T23:30:00","guid":{"rendered":"https:\/\/aiyoit.com\/tutorial\/?p=7192"},"modified":"2023-08-16T15:11:44","modified_gmt":"2023-08-16T09:41:44","slug":"what-is-the-use-of-data-tab-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/aiyoit.com\/tutorial\/what-is-the-use-of-data-tab-in-microsoft-excel\/","title":{"rendered":"What is the use of Data Tab in Microsoft Excel?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"7192\" class=\"elementor elementor-7192\">\n\t\t\t\t\t\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-6fb08d57 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6fb08d57\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4dac2309\" data-id=\"4dac2309\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-69ba286f elementor-shape-circle elementor-grid-0 e-grid-align-center elementor-widget elementor-widget-social-icons\" data-id=\"69ba286f\" data-element_type=\"widget\" data-widget_type=\"social-icons.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-widget-social-icons.elementor-grid-0 .elementor-widget-container,.elementor-widget-social-icons.elementor-grid-mobile-0 .elementor-widget-container,.elementor-widget-social-icons.elementor-grid-tablet-0 .elementor-widget-container{line-height:1;font-size:0}.elementor-widget-social-icons:not(.elementor-grid-0):not(.elementor-grid-tablet-0):not(.elementor-grid-mobile-0) .elementor-grid{display:inline-grid}.elementor-widget-social-icons .elementor-grid{grid-column-gap:var(--grid-column-gap,5px);grid-row-gap:var(--grid-row-gap,5px);grid-template-columns:var(--grid-template-columns);justify-content:var(--justify-content,center);justify-items:var(--justify-content,center)}.elementor-icon.elementor-social-icon{font-size:var(--icon-size,25px);line-height:var(--icon-size,25px);width:calc(var(--icon-size, 25px) + (2 * var(--icon-padding, .5em)));height:calc(var(--icon-size, 25px) + (2 * var(--icon-padding, .5em)))}.elementor-social-icon{--e-social-icon-icon-color:#fff;display:inline-flex;background-color:#69727d;align-items:center;justify-content:center;text-align:center;cursor:pointer}.elementor-social-icon i{color:var(--e-social-icon-icon-color)}.elementor-social-icon svg{fill:var(--e-social-icon-icon-color)}.elementor-social-icon:last-child{margin:0}.elementor-social-icon:hover{opacity:.9;color:#fff}.elementor-social-icon-android{background-color:#a4c639}.elementor-social-icon-apple{background-color:#999}.elementor-social-icon-behance{background-color:#1769ff}.elementor-social-icon-bitbucket{background-color:#205081}.elementor-social-icon-codepen{background-color:#000}.elementor-social-icon-delicious{background-color:#39f}.elementor-social-icon-deviantart{background-color:#05cc47}.elementor-social-icon-digg{background-color:#005be2}.elementor-social-icon-dribbble{background-color:#ea4c89}.elementor-social-icon-elementor{background-color:#d30c5c}.elementor-social-icon-envelope{background-color:#ea4335}.elementor-social-icon-facebook,.elementor-social-icon-facebook-f{background-color:#3b5998}.elementor-social-icon-flickr{background-color:#0063dc}.elementor-social-icon-foursquare{background-color:#2d5be3}.elementor-social-icon-free-code-camp,.elementor-social-icon-freecodecamp{background-color:#006400}.elementor-social-icon-github{background-color:#333}.elementor-social-icon-gitlab{background-color:#e24329}.elementor-social-icon-globe{background-color:#69727d}.elementor-social-icon-google-plus,.elementor-social-icon-google-plus-g{background-color:#dd4b39}.elementor-social-icon-houzz{background-color:#7ac142}.elementor-social-icon-instagram{background-color:#262626}.elementor-social-icon-jsfiddle{background-color:#487aa2}.elementor-social-icon-link{background-color:#818a91}.elementor-social-icon-linkedin,.elementor-social-icon-linkedin-in{background-color:#0077b5}.elementor-social-icon-medium{background-color:#00ab6b}.elementor-social-icon-meetup{background-color:#ec1c40}.elementor-social-icon-mixcloud{background-color:#273a4b}.elementor-social-icon-odnoklassniki{background-color:#f4731c}.elementor-social-icon-pinterest{background-color:#bd081c}.elementor-social-icon-product-hunt{background-color:#da552f}.elementor-social-icon-reddit{background-color:#ff4500}.elementor-social-icon-rss{background-color:#f26522}.elementor-social-icon-shopping-cart{background-color:#4caf50}.elementor-social-icon-skype{background-color:#00aff0}.elementor-social-icon-slideshare{background-color:#0077b5}.elementor-social-icon-snapchat{background-color:#fffc00}.elementor-social-icon-soundcloud{background-color:#f80}.elementor-social-icon-spotify{background-color:#2ebd59}.elementor-social-icon-stack-overflow{background-color:#fe7a15}.elementor-social-icon-steam{background-color:#00adee}.elementor-social-icon-stumbleupon{background-color:#eb4924}.elementor-social-icon-telegram{background-color:#2ca5e0}.elementor-social-icon-thumb-tack{background-color:#1aa1d8}.elementor-social-icon-tripadvisor{background-color:#589442}.elementor-social-icon-tumblr{background-color:#35465c}.elementor-social-icon-twitch{background-color:#6441a5}.elementor-social-icon-twitter{background-color:#1da1f2}.elementor-social-icon-viber{background-color:#665cac}.elementor-social-icon-vimeo{background-color:#1ab7ea}.elementor-social-icon-vk{background-color:#45668e}.elementor-social-icon-weibo{background-color:#dd2430}.elementor-social-icon-weixin{background-color:#31a918}.elementor-social-icon-whatsapp{background-color:#25d366}.elementor-social-icon-wordpress{background-color:#21759b}.elementor-social-icon-xing{background-color:#026466}.elementor-social-icon-yelp{background-color:#af0606}.elementor-social-icon-youtube{background-color:#cd201f}.elementor-social-icon-500px{background-color:#0099e5}.elementor-shape-rounded .elementor-icon.elementor-social-icon{border-radius:10%}.elementor-shape-circle .elementor-icon.elementor-social-icon{border-radius:50%}<\/style>\t\t<div class=\"elementor-social-icons-wrapper elementor-grid\">\n\t\t\t\t\t\t\t<span class=\"elementor-grid-item\">\n\t\t\t\t\t<a class=\"elementor-icon elementor-social-icon elementor-social-icon-facebook elementor-animation-buzz elementor-repeater-item-01b5564\" href=\"https:\/\/www.facebook.com\/aiyoit\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-screen-only\">Facebook<\/span>\n\t\t\t\t\t\t<i class=\"fab fa-facebook\"><\/i>\t\t\t\t\t<\/a>\n\t\t\t\t<\/span>\n\t\t\t\t\t\t\t<span class=\"elementor-grid-item\">\n\t\t\t\t\t<a class=\"elementor-icon elementor-social-icon elementor-social-icon-instagram elementor-animation-buzz elementor-repeater-item-8a90b95\" href=\"https:\/\/www.instagram.com\/aiyoitns\/\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-screen-only\">Instagram<\/span>\n\t\t\t\t\t\t<i class=\"fab fa-instagram\"><\/i>\t\t\t\t\t<\/a>\n\t\t\t\t<\/span>\n\t\t\t\t\t\t\t<span class=\"elementor-grid-item\">\n\t\t\t\t\t<a class=\"elementor-icon elementor-social-icon elementor-social-icon-youtube elementor-animation-buzz elementor-repeater-item-567c5bb\" href=\"https:\/\/www.youtube.com\/channel\/UCiagcH73PZUdTzRySS8Axig\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-screen-only\">Youtube<\/span>\n\t\t\t\t\t\t<i class=\"fab fa-youtube\"><\/i>\t\t\t\t\t<\/a>\n\t\t\t\t<\/span>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-264137f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"264137f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2efdb43\" data-id=\"2efdb43\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fce2b32 elementor-widget elementor-widget-heading\" data-id=\"fce2b32\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">MS Excel Data Tab<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cd3d05c elementor-widget elementor-widget-text-editor\" data-id=\"cd3d05c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>MS Excel\u00a0Data\u00a0Tab \u0915\u093e Use External Sources \u0938\u0947 Data \u0915\u094b Import \u0915\u0930\u0928\u0947 \u0914\u0930 \u0909\u0938\u0947 \u0905\u092a\u0928\u0940 \u0906\u0935\u0936\u094d\u092f\u0915\u0924\u093e \u0905\u0928\u0941\u0938\u093e\u0930 Shape \u0926\u0947\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0964 \u0907\u0938\u0915\u0947 \u0905\u0932\u093e\u0935\u093e \u0939\u092e Data \u092e\u0947\u0902 Sort &amp; Filter, Advance Filter, Data Validation, Group etc. Option \u0915\u094b Use \u0915\u0930\u0924\u0947 \u0939\u0948\u0964 Excel \u092e\u0947\u0902 Data Tab Formulas \u0914\u0930 Review Tab \u0915\u0947 \u092c\u0940\u091a \u092e\u0947 \u092e\u094c\u091c\u0942\u0926 \u0939\u094b\u0924\u093e \u0939\u0948\u0964 \u0906\u092a \u0938\u0940\u0927\u0947 Mouse \u0938\u0947 Click \u0915\u0930\u0915\u0947 \u0907\u0938\u0947 Open \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948, \u092f\u093e Keyboard \u0938\u0947\u00a0Alt + A\u00a0Key \u0915\u094b \u0926\u092c\u093e\u0915\u0930 \u092d\u0940 \u0907\u0938\u0947 Open \u0915\u093f\u092f\u093e \u091c\u093e \u0938\u0915\u0924\u093e \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7e4c577 elementor-widget elementor-widget-image\" data-id=\"7e4c577\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"99\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Data-Tab-1024x99.png\" class=\"attachment-large size-large wp-image-7213\" alt=\"Data Tab in MS Excel\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Data-Tab-1024x99.png 1024w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Data-Tab-300x29.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Data-Tab-150x14.png 150w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Data-Tab-768x74.png 768w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Data-Tab-1536x148.png 1536w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Data-Tab-2048x197.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d0dda59 elementor-widget elementor-widget-text-editor\" data-id=\"d0dda59\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>MS Excel\u00a0Data\u00a0Tab \u092e\u0947\u0902 \u0939\u092e\u0947\u0902\u00a05\u00a0section \u0926\u0947\u0916\u0928\u0947 \u0915\u094b \u092e\u093f\u0932\u0924\u0947 \u0939\u0948 \u2013<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7929285 elementor-widget elementor-widget-text-editor\" data-id=\"7929285\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li>Get External Data<\/li><li>Connections<\/li><li>Sort &amp; Filter<\/li><li>Data Tools<\/li><li>Outline<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5b888ff elementor-widget elementor-widget-heading\" data-id=\"5b888ff\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Get External Data <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-inner-section elementor-element elementor-element-05bd038 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"05bd038\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-81a0f81\" data-id=\"81a0f81\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1fc05bf elementor-widget elementor-widget-text-editor\" data-id=\"1fc05bf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u092f\u0939 MS Excel Data Tab \u0915\u093e \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u093e Section \u0939\u0948 \u091c\u094b \u0939\u092e\u0947\u0902 External Sources \u0938\u0947 Data Import \u0915\u0930\u0928\u0947 \u0915\u094b Allow \u0915\u0930\u0924\u093e \u0939\u0948\u0964 \u0905\u0915\u094d\u0938\u0930 \u0939\u092e\u0947\u0902 \u0915\u093f\u0938\u0940 \u0905\u0928\u094d\u092f File \u092f\u093e \u0905\u0928\u094d\u092f Source \u091c\u0948\u0938\u0947 MS Access, Web, Text, \u0906\u0926\u093f \u0938\u0947 Data Import \u0915\u0930\u0928\u0947 \u0915\u0940 \u0906\u0935\u0936\u094d\u092f\u0915\u0924\u093e \u0939\u094b\u0924\u0940 \u0939\u0948 \u0910\u0938\u0947 \u092e\u0947\u0902 Excel \u0915\u093e \u092f\u0939 Group \u0939\u092e\u0947\u0902 \u092e\u0926\u0926 \u0915\u0930\u0924\u093e \u0939\u0948\u0964 \u0907\u0938\u092e\u0947\u0902 \u0939\u092e\u0947\u0902\u00a05 Option\u00a0\u0926\u0947\u0916\u0928\u0947 \u0915\u094b \u092e\u093f\u0932\u0924\u0947 \u0939\u0948 \u2013<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-8a22a96\" data-id=\"8a22a96\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9128697 elementor-widget elementor-widget-image\" data-id=\"9128697\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"348\" height=\"103\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Get-External-Data.png\" class=\"attachment-large size-large wp-image-7203\" alt=\"Get External Data in Data Tab\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Get-External-Data.png 348w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Get-External-Data-300x89.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Get-External-Data-150x44.png 150w\" sizes=\"(max-width: 348px) 100vw, 348px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<div class=\"elementor-element elementor-element-f3a04e0 elementor-widget elementor-widget-heading\" data-id=\"f3a04e0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">From Access<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0fdbb02 elementor-widget elementor-widget-text-editor\" data-id=\"0fdbb02\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u092f\u0926\u093f \u0906\u092a \u0905\u092a\u0928\u0940 Excel Sheet \u092e\u0947\u0902 Microsoft Access \u0915\u0940 \u0915\u093f\u0938\u0940 File \u0915\u094b Import \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948, \u0924\u094b \u0907\u0938 Option \u0915\u093e Use \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bc9702e elementor-widget elementor-widget-heading\" data-id=\"bc9702e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">From Web<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8f87f57 elementor-widget elementor-widget-text-editor\" data-id=\"8f87f57\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u092f\u0926\u093f \u0906\u092a Internet \u0938\u0947 \u0915\u093f\u0938\u0940 Web Page \u0915\u0947 Data \u0915\u094b \u0905\u092a\u0928\u0940 Excel Sheet \u092e\u0947\u0902 Import \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948, \u0924\u094b \u0909\u0938\u0915\u0947 \u0932\u093f\u090f \u0906\u092a \u0907\u0938 Option \u0915\u093e Use \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-57af69f elementor-widget elementor-widget-heading\" data-id=\"57af69f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">From Text<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f02e691 elementor-widget elementor-widget-text-editor\" data-id=\"f02e691\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Option \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u0906\u092a \u0915\u093f\u0938\u0940 Text File \u0915\u094b \u0905\u092a\u0928\u0947 Worksheet \u092e\u0947\u0902 Import \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-734b376 elementor-widget elementor-widget-heading\" data-id=\"734b376\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">From Other Sources<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6cc88f8 elementor-widget elementor-widget-text-editor\" data-id=\"6cc88f8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Option \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u0906\u092a \u0905\u0928\u094d\u092f Sources \u091c\u0948\u0938\u0947 SQL Server, Analysis Services, XML File, Microsoft Query, \u0906\u0926\u093f \u0938\u0947 \u0905\u092a\u0928\u0947 Worksheet \u092e\u0948 Data Import \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3a3df2e elementor-widget elementor-widget-heading\" data-id=\"3a3df2e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Existing Connections<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-007c0db elementor-widget elementor-widget-text-editor\" data-id=\"007c0db\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0905\u0917\u0930 \u0906\u092a\u0928\u0947 \u092a\u0939\u0932\u0947 \u092d\u0940 \u0915\u093f\u0938\u0940 Common Sources \u0938\u0947 Data Import \u0915\u093f\u092f\u093e \u0939\u0941\u0906 \u0939\u0948 \u0924\u094b \u0907\u0938 Option \u0915\u093e Use \u0915\u0930\u0915\u0947 \u0906\u092a Existing Connection \u0938\u0947 Data \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0964 \u0907\u0938\u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u0906\u092a \u092f\u0939 \u092d\u0940 \u0926\u0947\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948 \u0915\u0940 \u0906\u092a\u0915\u0940 Worksheet \u092e\u0947\u0902 \u0915\u0939\u093e\u0901 \u0915\u0939\u093e\u0901 \u0938\u0947 Data Import \u0915\u093f\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0f7ed51 elementor-widget elementor-widget-heading\" data-id=\"0f7ed51\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Connections<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-inner-section elementor-element elementor-element-b0c591c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b0c591c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-inner-column elementor-element elementor-element-1717055\" data-id=\"1717055\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9b858e3 elementor-widget elementor-widget-text-editor\" data-id=\"9b858e3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>MS Excel Data Tab \u0915\u0947 \u0907\u0938 Section \u092e\u0948 \u0939\u092e\u0947\u0902\u00a04 Option\u00a0\u0926\u0947\u0916\u0928\u0947 \u0915\u094b \u092e\u093f\u0932\u0924\u0947 \u0939\u0948 \u2013<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-inner-column elementor-element elementor-element-153d810\" data-id=\"153d810\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9fde288 elementor-widget elementor-widget-image\" data-id=\"9fde288\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"212\" height=\"93\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Connections-Group.png\" class=\"attachment-large size-large wp-image-7200\" alt=\"Connections in Data Tab\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Connections-Group.png 212w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Connections-Group-150x66.png 150w\" sizes=\"(max-width: 212px) 100vw, 212px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<div class=\"elementor-element elementor-element-2e5a3b8 elementor-widget elementor-widget-heading\" data-id=\"2e5a3b8\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Refresh All<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0c3a483 elementor-widget elementor-widget-text-editor\" data-id=\"0c3a483\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0905\u0917\u0930 \u0939\u092e\u0928\u0947 \u0915\u094b\u0908 Data External Sources \u0938\u0947 Upload \u0915\u0930 \u0926\u093f\u092f\u093e \u0939\u0948\u0964 \u0932\u0947\u0915\u093f\u0928 \u0905\u0917\u0930 \u0939\u092e \u0909\u0938 Main Sources Data \u092e\u0947 \u0915\u0941\u091b Updated \u0915\u0930 \u0926\u093f\u090f \u0939\u0948, \u0924\u094b \u0909\u0938 Updated \u0915\u094b Excel Sheet \u092e\u0947 \u092d\u0940 \u0932\u093e\u0928\u093e \u0915\u0947 \u0932\u093f\u090f \u0907\u0938 Option \u0915\u093e Use \u0915\u0930\u0924\u0947 \u0939\u0948\u0964 \u00a0<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-60ba443 elementor-widget elementor-widget-heading\" data-id=\"60ba443\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Connections<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e57cc43 elementor-widget elementor-widget-text-editor\" data-id=\"e57cc43\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Option \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u0906\u092a Workbook \u0915\u0947 \u0938\u092d\u0940 Data Connections \u0915\u094b Display \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 \u0907\u0938 Option \u092e\u0947\u0902 \u0906\u092a\u0915\u094b \u0909\u0928 \u0938\u092c Files \u0914\u0930 Data Resources \u0915\u0947 \u0928\u093e\u092e \u092e\u093f\u0932 \u091c\u093e\u090f\u0902\u0917\u0947, \u091c\u093f\u0928\u094d\u0939\u0947 \u0906\u092a \u0928\u0947 \u0905\u092a\u0928\u0940 Workbook \u092e\u0947\u0902 Add \u0915\u093f\u092f\u093e \u0939\u0948\u0964 \u0907\u0938\u092e\u0947\u0902 \u0906\u092a \u0909\u0928 \u0938\u092c\u0915\u094b Remove \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u0909\u0928\u094d\u0939\u0947 Refresh \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d6d6787 elementor-widget elementor-widget-heading\" data-id=\"d6d6787\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Properties<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-846a72b elementor-widget elementor-widget-text-editor\" data-id=\"846a72b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Option \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u0906\u092a \u0905\u092a\u0928\u0940 Add \u0915\u0940 \u0939\u0941\u0908 Data Resources \u0915\u0940 Properties \u0915\u094b \u0926\u0947\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u0909\u0928 Properties \u0915\u0940 Settings \u0915\u094b Change \u092d\u0940 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902, \u0907\u0938\u092e\u0947\u0902 \u0906\u092a\u0915\u094b Refresh \u0914\u0930 Data Formatting \u091c\u0948\u0938\u0940 Settings \u0926\u0947\u0916\u0928\u0947 \u0915\u094b \u092e\u093f\u0932 \u091c\u093e\u0924\u0940 \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-72d2cf0 elementor-widget elementor-widget-heading\" data-id=\"72d2cf0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Edit Links<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-906d28c elementor-widget elementor-widget-text-editor\" data-id=\"906d28c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Option \u0938\u0947 \u0906\u092a \u0909\u0928 \u0938\u092c \u0926\u0942\u0938\u0930\u0940 Files \u0915\u094b \u0926\u0947\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948 \u091c\u094b \u0915\u0940 \u0906\u092a\u0915\u0940 Spreadsheet \u0938\u0947 Link \u0939\u0948 \u0914\u0930 \u0906\u092a \u0907\u0928 Links \u0915\u094b Update \u0914\u0930 Remove \u092d\u0940 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b6a6202 elementor-widget elementor-widget-heading\" data-id=\"b6a6202\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Sort & Filter <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-inner-section elementor-element elementor-element-f043a40 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f043a40\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-inner-column elementor-element elementor-element-99c4a43\" data-id=\"99c4a43\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-36dd0ab elementor-widget elementor-widget-text-editor\" data-id=\"36dd0ab\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>MS Excel Data Tab \u0915\u0947 \u0907\u0938 Section \u092e\u0947\u0902 Data \u0915\u094b Sort \u0914\u0930 Filter \u0915\u0930\u0928\u0947 \u0938\u0947 \u0938\u092e\u094d\u092c\u0902\u0927\u093f\u0924 Option \u0926\u093f\u090f \u0917\u090f \u0939\u0948\u0964 \u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u0932\u093f\u090f \u0905\u0917\u0930 \u0906\u092a Data \u0915\u094b Value \u0915\u0947 \u0906\u0927\u093e\u0930 \u092a\u0930 \u092f\u093e \u0915\u093f\u0938\u0940 Word \u0915\u0947 \u092a\u0939\u0932\u0947 \u0905\u0915\u094d\u0937\u0930 \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930\u00a0Ascending\u00a0\u092f\u093e\u00a0Descending\u00a0Order \u092e\u0947\u0902 Set \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948 \u0924\u094b \u0907\u0938\u0915\u0947 \u0932\u093f\u090f \u0906\u092a Sort Option \u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932 \u0915\u0930\u0947\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-inner-column elementor-element elementor-element-3709b79\" data-id=\"3709b79\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-65d414f elementor-widget elementor-widget-image\" data-id=\"65d414f\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"233\" height=\"106\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Sort-Filter-Group.png\" class=\"attachment-large size-large wp-image-7205\" alt=\"Sort &amp; Filter Group in Data Tab\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Sort-Filter-Group.png 233w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Sort-Filter-Group-150x68.png 150w\" sizes=\"(max-width: 233px) 100vw, 233px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<div class=\"elementor-element elementor-element-cb5c59e elementor-widget elementor-widget-heading\" data-id=\"cb5c59e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Sort A To Z<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4742f3f elementor-widget elementor-widget-text-editor\" data-id=\"4742f3f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u092f\u0926\u093f \u0906\u092a \u0905\u092a\u0928\u0940 Workbook \u092e\u0947\u0902 Data \u0915\u094b\u00a0Alphabetically\u00a0(A To Z)\u00a0\u092f\u093e\u00a0Numerically\u00a0(Lowest \u0938\u0947 Highest)\u00a0\u0915\u094d\u0930\u092e \u092e\u0947\u0902 Sort \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948 \u0924\u094b \u0906\u092a \u0907\u0938 Option \u0915\u093e Use \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-708151c elementor-widget elementor-widget-heading\" data-id=\"708151c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Sort Z To A<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ac816cb elementor-widget elementor-widget-text-editor\" data-id=\"ac816cb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u092f\u0926\u093f \u0906\u092a \u0905\u092a\u0928\u0940 Workbook \u092e\u0947\u0902 Data \u0915\u094b\u00a0Alphabetically (Z To A)\u00a0\u092f\u093e\u00a0Numerically (Highest \u0938\u0947 Lowest)\u00a0\u0915\u094d\u0930\u092e \u092e\u0947\u0902 Sort \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948 \u0924\u094b \u0906\u092a \u0907\u0938 Option \u0915\u093e Use \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9f17ae7 elementor-widget elementor-widget-heading\" data-id=\"9f17ae7\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Sort<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-888fc54 elementor-widget elementor-widget-text-editor\" data-id=\"888fc54\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Option \u092a\u0930 Click \u0915\u0930\u0928\u0947 \u0938\u0947 \u090f\u0915\u00a0Sort\u00a0Dialog-Box Open \u0939\u094b\u0924\u093e \u0939\u0948 \u091c\u093f\u0938\u092e\u0947\u0902 \u0906\u092a\u0915\u094b Data \u0915\u094b Sort \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0905\u0924\u0930\u093f\u0915\u094d\u0924 Option \u0926\u0947\u0916\u0928\u0947 \u0915\u094b \u092e\u093f\u0932\u0947\u0902\u0917\u0947\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1201be2 elementor-widget elementor-widget-heading\" data-id=\"1201be2\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Filter<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cd742ca elementor-widget elementor-widget-text-editor\" data-id=\"cd742ca\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Option \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u0906\u092a \u0905\u092a\u0928\u0947 Data \u0915\u094b Filter \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902, \u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u0932\u093f\u090f \u092e\u093e\u0928 \u0932\u0940\u091c\u093f\u090f, \u0939\u092e\u093e\u0930\u0947 \u092a\u093e\u0938 \u092c\u0939\u0941\u0924 \u0938\u093e\u0930\u0947 Student \u0939\u0948 \u0914\u0930 \u0939\u092e \u0909\u0928 \u092e\u0947\u0902 \u0938\u0947 \u0915\u093f\u0928\u094d\u0939\u0940 \u090f\u0915 \u0926\u094b Student \u0915\u093e Result \u0926\u0947\u0916\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948, \u0924\u094b \u0909\u0938\u0915\u0947 \u0932\u093f\u090f \u0939\u092e \u092f\u0939 Filter Apply \u0915\u0930 \u0926\u0947\u0902\u0917\u0947\u0964 \u0907\u0938\u0938\u0947 \u0939\u0930 \u090f\u0915 Heading \u0915\u0947 \u0906\u0917\u0947 \u090f\u0915 Arrow \u0915\u093e \u0928\u093f\u0936\u093e\u0928 \u0906 \u091c\u093e\u090f\u0917\u093e, \u091c\u093f\u0938 \u092a\u0930 Click \u0915\u0930 \u0915\u0947 \u0906\u092a \u092f\u0939 Set \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948 \u0915\u0940 \u0909\u0938 Heading \u092e\u0947\u0902 \u0938\u0947 \u0906\u092a \u0915\u094b \u0915\u094c\u0928 \u0938\u093e Data \u0926\u0947\u0916\u0928\u093e \u0939\u0948\u0964 \u0907\u0938\u0915\u0947 \u0932\u093f\u090f \u0906\u092a\u00a0Ctrl + Shift + L\u00a0Shortcut \u0915\u093e \u092d\u0940 Use \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-89e31c4 elementor-widget elementor-widget-heading\" data-id=\"89e31c4\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Clear<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d872f7c elementor-widget elementor-widget-text-editor\" data-id=\"d872f7c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u092f\u0926\u093f \u0906\u092a\u0928\u0947 \u0905\u092a\u0928\u0947 Data \u092a\u0930 \u091c\u094b \u092d\u0940 Sort \u0914\u0930 Filter Apply \u0915\u093f\u092f\u093e \u0939\u0948 \u092f\u093e \u0909\u0938\u092e\u0947\u0902 \u0915\u0941\u091b \u092c\u0926\u0932\u093e\u0935 \u0915\u0930 \u0926\u093f\u090f \u0939\u0948 \u0914\u0930 \u0905\u092c \u0906\u092a \u091a\u093e\u0939\u0924\u0947 \u0939\u0948 \u0915\u0940 \u092f\u0939 Filter \u092a\u0939\u0932\u0947 \u091c\u0948\u0938\u093e \u0939\u094b \u091c\u093e\u090f \u0924\u094b \u0909\u0938\u0947 Clear \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0906\u092a \u0907\u0938 Option \u0915\u093e Use \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8376c25 elementor-widget elementor-widget-heading\" data-id=\"8376c25\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Reapply<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4d5eb28 elementor-widget elementor-widget-text-editor\" data-id=\"4d5eb28\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Option \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u0906\u092a Current Range \u092e\u0947\u0902 Filter \u0914\u0930 Sort \u0915\u094b Reapply \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 \u0907\u0938\u0915\u0947 \u0932\u093f\u090f \u0906\u092a\u00a0Ctrl + Alt + L\u00a0Shortcut \u0915\u093e \u092d\u0940 Use \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1af17de elementor-widget elementor-widget-heading\" data-id=\"1af17de\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Advanced<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-60d8173 elementor-widget elementor-widget-text-editor\" data-id=\"60d8173\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Option \u092a\u0930 Click \u0915\u0930\u0928\u0947 \u0938\u0947 \u0906\u092a\u0915\u0947 \u0938\u093e\u092e\u0928\u0947 \u090f\u0915\u00a0Advanced Filter\u00a0\u0915\u093e Dialog Box Open \u0939\u094b\u0924\u093e \u0939\u0948 \u091c\u093f\u0938\u092e\u0947\u0902 Complex Criteria \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0915\u0947 Filtering \u0915\u0930\u0928\u0947 \u0915\u0947 Option \u0926\u093f\u090f \u0917\u090f \u0939\u094b\u0924\u0947 \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-da68da0 elementor-widget elementor-widget-text-editor\" data-id=\"da68da0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li>Cursor \u0915\u094b \u0935\u0939\u093e \u0930\u0939\u0947 \u091c\u0939\u093e \u0906\u092a\u0915\u093e Main Data \u0939\u094b\u0964<\/li><li>\u0905\u092c Advance Filter \u092a\u0930 Click \u0915\u0930\u0947\u0964<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e377563 elementor-widget elementor-widget-image\" data-id=\"e377563\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"441\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Advance-Filter-1024x441.png\" class=\"attachment-large size-large wp-image-7210\" alt=\"Advance Filter\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Advance-Filter-1024x441.png 1024w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Advance-Filter-300x129.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Advance-Filter-150x65.png 150w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Advance-Filter-768x331.png 768w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Advance-Filter-1536x662.png 1536w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Advance-Filter-2048x883.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bc2040c elementor-widget elementor-widget-text-editor\" data-id=\"bc2040c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li>\u0905\u092c Criteria range \u0915\u094b Select \u0915\u0930\u0947\u0964<\/li><li>\u0914\u0930 Ok Bottom \u092a\u0930 Click \u0915\u0930\u0947\u0964<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-20cec10 elementor-widget elementor-widget-image\" data-id=\"20cec10\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"717\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Criteria-range-1024x717.png\" class=\"attachment-large size-large wp-image-7211\" alt=\"Criteria range\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Criteria-range-1024x717.png 1024w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Criteria-range-300x210.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Criteria-range-150x105.png 150w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Criteria-range-768x538.png 768w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Criteria-range.png 1241w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ac5c51c elementor-widget elementor-widget-text-editor\" data-id=\"ac5c51c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li>Select \u0915\u094d\u092f\u093e \u0917\u092f\u093e Criteria \u0915\u0947 According \u0906\u092a\u0915\u093e Data Filter \u0939\u094b \u091c\u093e\u090f\u0917\u093e\u0964<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8f97f9b elementor-widget elementor-widget-image\" data-id=\"8f97f9b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"316\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Data-Filter-1024x316.png\" class=\"attachment-large size-large wp-image-7212\" alt=\"Data Filter\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Data-Filter-1024x316.png 1024w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Data-Filter-300x93.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Data-Filter-150x46.png 150w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Data-Filter-768x237.png 768w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Data-Filter-1536x474.png 1536w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Data-Filter-2048x633.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5e9447e elementor-widget elementor-widget-heading\" data-id=\"5e9447e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Data Tools<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-inner-section elementor-element elementor-element-5b45206 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5b45206\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-inner-column elementor-element elementor-element-a18c3ff\" data-id=\"a18c3ff\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6cb4264 elementor-widget elementor-widget-text-editor\" data-id=\"6cb4264\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>MS Excel Data Tab \u0915\u0947 \u0907\u0938 Section \u0915\u0947 Options \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u0906\u092a Duplicate Data \u0915\u094b \u0939\u091f\u093e \u0938\u0915\u0924\u0947 \u0939\u0948, Invalid Data \u0915\u094b \u0930\u094b\u0915 \u0938\u0915\u0924\u0947 \u0939\u0948, Multiple Ranges \u0915\u0940 Values \u0915\u094b \u0915\u093f\u0938\u0940 New Range \u092e\u0947\u0902 \u0932\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-inner-column elementor-element elementor-element-f4d1b3b\" data-id=\"f4d1b3b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5f7edbf elementor-widget elementor-widget-image\" data-id=\"5f7edbf\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"135\" height=\"102\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Data-Tools-Group.png\" class=\"attachment-large size-large wp-image-7201\" alt=\"Data Tools in Data Tab\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<div class=\"elementor-element elementor-element-a78d791 elementor-widget elementor-widget-heading\" data-id=\"a78d791\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Text To Columns<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-089c82a elementor-widget elementor-widget-text-editor\" data-id=\"089c82a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Option \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u0906\u092a Single Column \u0915\u0947 Text \u0915\u094b Multiple Columns \u092e\u0947\u0902 Split \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0964 \u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u0932\u093f\u090f \u090f\u0915 Column \u092e\u0947\u0902 Full Name \u0932\u093f\u0916\u093e \u0917\u092f\u093e \u0939\u0948 \u0924\u094b \u0907\u0938 Option \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u0906\u092a Full Name \u0915\u094b Separate Column First Name \u0914\u0930 Last Name \u092e\u0947\u0902 Split \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0964 \u0907\u0938 Option \u092a\u0930 Click \u0915\u0930\u0928\u0947 \u0938\u0947 Convert Text To Columns Wizard Open \u0939\u094b\u0924\u093e \u0939\u0948\u0964 \u091c\u093f\u0938\u0915\u0940 Help \u0938\u0947 \u0906\u092a \u092f\u0939 \u091a\u0941\u0928 \u0938\u0915\u0924\u0947 \u0939\u0948 \u0915\u093f Text \u0915\u094b \u0915\u093f\u0938 \u0906\u0927\u093e\u0930 \u092a\u0930 Split \u0915\u0930\u0928\u093e \u0939\u0948 \u091c\u0948\u0938\u0947 \u0915\u093f Fixed Width \u092a\u0930 Split \u0915\u0930\u0928\u093e \u0939\u0948 \u092f\u093e \u092a\u094d\u0930\u0924\u094d\u092f\u0947\u0915 Comma, Period \u092f\u093e \u0905\u0928\u094d\u092f Character \u092a\u0930 Split \u0915\u0930\u0928\u093e \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-eed525f elementor-widget elementor-widget-heading\" data-id=\"eed525f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Flash Fill<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cbc9fa9 elementor-widget elementor-widget-text-editor\" data-id=\"cbc9fa9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u00a0\u092f\u0939 Option Pattern \u0915\u0940 \u092a\u0939\u091a\u093e\u0928 \u0915\u0930 \u0906\u092a\u0915\u0947 Data \u0915\u094b Automatically Fill \u0915\u0930 \u0926\u0947\u0924\u093e \u0939\u0948\u0964 \u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u0932\u093f\u090f \u0906\u092a\u0915\u0940 Sheet \u092e\u0947\u0902 \u090f\u0915 Data Column \u0939\u0948 \u091c\u093f\u0938\u0947 \u0906\u092a Sheet \u092e\u0947\u0902 \u0926\u0942\u0938\u0930\u0940 \u091c\u0917\u0939 Fill \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948 \u0924\u094b \u0907\u0938\u0915\u0947 \u0932\u093f\u090f \u0906\u092a\u0915\u094b \u0909\u0938 Column \u0915\u0947 \u0915\u0941\u091b Examples \u0926\u0947\u0928\u0947 \u0939\u094b\u0902\u0917\u0947 \u091c\u093f\u0938\u0938\u0947 Flash Fill Feature \u0909\u0938 Pattern \u0915\u094b \u0938\u092e\u091d \u092a\u093e\u090f \u0914\u0930 Data \u0915\u094b \u0906\u092a\u0915\u0947 \u091a\u0941\u0928\u0947\u0902 Column \u092e\u0947\u0902 Automatically Fill \u0915\u0930 \u0926\u0947\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-873bc08 elementor-widget elementor-widget-heading\" data-id=\"873bc08\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Remove Duplicates<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c336c05 elementor-widget elementor-widget-text-editor\" data-id=\"c336c05\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Option \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u0906\u092a Sheet \u092e\u0947\u0902 \u0938\u0947 Duplicate Rows \u0915\u094b Delete \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f32986c elementor-widget elementor-widget-heading\" data-id=\"f32986c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Data Validation<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c8af987 elementor-widget elementor-widget-text-editor\" data-id=\"c8af987\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Option \u0915\u093e Use \u0906\u092a \u092f\u0939 Restrict \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948 \u0915\u093f \u0915\u093f\u0938\u0940 Cell \u092e\u0947\u0902 \u0915\u093f\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u0947 Data \u092f\u093e Values \u0915\u094b \u0928\u0939\u0940\u0902 Enter \u0915\u093f\u092f\u093e \u091c\u093e \u0938\u0915\u0924\u093e \u0939\u0948\u0964 Data Validation Button \u092a\u0930 Click \u0915\u0930\u0928\u0947 \u0938\u0947 \u090f\u0915 Dialog-Box Display \u0939\u094b\u0924\u093e \u0939\u0948 \u091c\u093f\u0938\u092e\u0947\u0902 Rules \u0915\u0940 \u090f\u0915 List \u0926\u0940 \u0917\u092f\u0940 \u0939\u094b\u0924\u0940 \u0939\u0948 \u091c\u093f\u0938\u092e\u0947\u0902 \u0938\u0947 \u0906\u092a \u0915\u093f\u0938\u0940 \u090f\u0915 \u0915\u094b \u091a\u0941\u0928 \u0915\u0930 Cell \u092e\u0947\u0902 Enter \u0915\u093f\u092f\u0947 \u091c\u093e \u0938\u0915\u0928\u0947 \u0935\u093e\u0932\u0947 Data \u0915\u0947 \u092a\u094d\u0930\u0915\u093e\u0930 \u0914\u0930 Values \u0915\u094b Restrict \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bb0a132 elementor-widget elementor-widget-text-editor\" data-id=\"bb0a132\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u0932\u093f\u090f \u0906\u092a\u0928\u0947 \u092f\u0939 Rule \u091a\u0941\u0928\u093e \u0915\u093f \u0907\u0938 Cell \u092e\u0947\u0902 5 \u0938\u0947 \u091b\u094b\u091f\u0940 Number \u0939\u0940 Enter \u0915\u0940 \u091c\u093e \u0938\u0915\u0924\u0940 \u0939\u0948\u0964 \u0905\u092c \u0906\u092a \u091c\u0948\u0938\u0947 \u0939\u0940 \u0909\u0938 Cell \u092e\u0947\u0902 6 \u092f\u093e \u0909\u0938\u0938\u0947 \u092c\u0921\u093c\u093e Number Enter \u0915\u0930\u0947\u0902\u0917\u0947 Data Validation Feature \u0906\u092a\u0915\u094b Error Show \u0915\u0930\u0947\u0917\u093e\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-64e380a elementor-widget elementor-widget-heading\" data-id=\"64e380a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Consolidate<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-214fd9f elementor-widget elementor-widget-text-editor\" data-id=\"214fd9f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Option \u0915\u0947 Use \u0938\u0947 \u0939\u092e \u0905\u0932\u0917-\u0905\u0932\u0917 Sheets \u0915\u0947 Data \u0915\u094b \u090f\u0915 Single Sheet \u092e\u0947\u0902 Consolidate \u092f\u093e Combine \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0964 \u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u0932\u093f\u092f\u0947 \u0906\u092a\u0915\u0947 \u092a\u093e\u0938 Last \u0924\u0940\u0928 Month \u0915\u093e Sales Data \u0905\u0932\u0917-\u0905\u0932\u0917 Sheet \u092e\u0947\u0902 \u092e\u094c\u091c\u0942\u0926 \u0939\u0948, Consolidate Feature \u0906\u092a\u0915\u0947 \u0932\u093f\u090f \u0915\u093f\u0938\u0940 \u0905\u0928\u094d\u092f Sheet \u092a\u0930 \u0909\u0928\u0915\u093e Total \u0928\u093f\u0915\u093e\u0932 \u0938\u0915\u0924\u093e \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3a2aaba elementor-widget elementor-widget-heading\" data-id=\"3a2aaba\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Relationships<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d3de816 elementor-widget elementor-widget-text-editor\" data-id=\"d3de816\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u092f\u0939 Option \u0906\u092a\u0915\u094b \u090f\u0915 \u0939\u0940 Report \u092a\u0930 \u0905\u0932\u0917-\u0905\u0932\u0917 Table \u0938\u0947 \u0938\u092e\u094d\u092c\u0902\u0927\u093f\u0924 Data \u0926\u093f\u0916\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f Table \u0915\u0947 \u092c\u0940\u091a Relationship Create \u092f\u093e Edit \u0915\u0930\u0928\u0947 \u092e\u0948 \u092e\u0926\u0926 \u0915\u0930\u0924\u093e \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d904e33 elementor-widget elementor-widget-heading\" data-id=\"d904e33\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Forecast<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b7cac2f elementor-widget elementor-widget-image\" data-id=\"b7cac2f\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"125\" height=\"94\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Forecast-Group.png\" class=\"attachment-large size-large wp-image-7202\" alt=\"Forecast in Data Tab\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e804110 elementor-widget elementor-widget-heading\" data-id=\"e804110\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">What-If Analysis<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-997be27 elementor-widget elementor-widget-text-editor\" data-id=\"997be27\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Function \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u0906\u092a Scenarios (Values) \u0915\u094b Change \u0915\u0930\u0915\u0947 \u0909\u0938\u0915\u0947\u00a0 Outcome \u092a\u0930 Affect \u0926\u0947\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0964 \u0938\u092e\u091d\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u090f\u0915 Scenario \u0932\u0947\u0924\u0947 \u0939\u0948 \u0915\u093f \u0906\u092a \u0905\u092a\u0928\u0947 Product \u0915\u093e Price \u0915\u093f\u0924\u0928\u093e \u0930\u0916\u0947\u0902 \u0915\u093f \u0906\u092a \u0905\u092a\u0928\u0947 Target Profit \u0924\u0915 \u092a\u0939\u0941\u0901\u091a \u092a\u093e\u090f \u092f\u093e \u0906\u092a\u0915\u094b \u0939\u0930 \u092e\u0939\u0940\u0928\u0947 \u0915\u093f\u0924\u0928\u0940 Sell \u0915\u0930\u0928\u0940 \u0939\u094b\u0917\u0940, \u0905\u092a\u0928\u0947 Target Profit \u0915\u094b \u0939\u093e\u0938\u093f\u0932 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f\u0964 \u0910\u0938\u0947 \u0939\u0940 \u0905\u0932\u0917-\u0905\u0932\u0917 Scenario \u0915\u093e Outcome \u092a\u0930 \u0915\u094d\u092f\u093e Affect \u0939\u094b\u0917\u093e \u0907\u0938\u0915\u0947 \u0932\u093f\u090f \u0939\u0940 \u0939\u092e What-If Analysis Function \u0915\u093e Use \u0915\u0930\u0924\u0947 \u0939\u0948\u0964 \u0907\u0938\u0915\u0947 \u0924\u0940\u0928 Tool \u0939\u0948 Scenario Manager, Goal Seek \u0914\u0930 Data Table.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e536521 elementor-widget elementor-widget-heading\" data-id=\"e536521\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Forecast Sheet<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fe820b8 elementor-widget elementor-widget-text-editor\" data-id=\"fe820b8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Option \u0915\u0947 Use \u0938\u0947 \u0906\u092a \u0905\u092a\u0928\u0947 Company \u0915\u0940 Revenue Oder \u0915\u0947 Base \u092a\u0930 \u090f\u0915 Forecast \u0924\u0948\u092f\u093e\u0930 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-263451b elementor-widget elementor-widget-heading\" data-id=\"263451b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Outline<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-inner-section elementor-element elementor-element-983f23f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"983f23f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-f6b539c\" data-id=\"f6b539c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3c59719 elementor-widget elementor-widget-text-editor\" data-id=\"3c59719\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>MS Excel Data Tab \u0915\u0947 \u0907\u0938 Section \u092e\u0948 \u0939\u092e\u0947\u0902\u00a05 Option\u00a0\u0926\u0947\u0916\u0928\u0947 \u0915\u094b \u092e\u093f\u0932\u0924\u0947 \u0939\u0948 \u2013<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-1bc506c\" data-id=\"1bc506c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2d622c3 elementor-widget elementor-widget-image\" data-id=\"2d622c3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"140\" height=\"99\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Outline-Group.png\" class=\"attachment-large size-large wp-image-7204\" alt=\"Outline in Data Tab\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<div class=\"elementor-element elementor-element-9d9079d elementor-widget elementor-widget-heading\" data-id=\"9d9079d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Group<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d97ebf6 elementor-widget elementor-widget-text-editor\" data-id=\"d97ebf6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Option \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u0906\u092a \u0905\u092a\u0928\u0947 Data \u092e\u0947\u0902 Row \u0914\u0930 Column \u0915\u093e \u090f\u0915 Group \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 \u0907\u0938 Option \u0915\u093e \u0906\u092a\u00a0Shift + Alt + Right Arrow\u00a0Key \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u092d\u0940 Use \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4de9b41 elementor-widget elementor-widget-heading\" data-id=\"4de9b41\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Ungroup<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-84ccb9a elementor-widget elementor-widget-text-editor\" data-id=\"84ccb9a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Option \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u0906\u092a\u0928\u0947 \u091c\u093f\u0928 Rows \u0914\u0930 Columns \u0915\u094b Group \u0915\u093f\u092f\u093e \u0925\u093e \u0909\u0938\u0947 Select \u0915\u0930 \u0915\u0947 Ungroup \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 \u0907\u0938\u0947 \u0906\u092a\u00a0Shift+ Alt Left Arrow\u00a0Key \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u092d\u0940 Use \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9b055ce elementor-widget elementor-widget-heading\" data-id=\"9b055ce\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Subtotal<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dab7a05 elementor-widget elementor-widget-text-editor\" data-id=\"dab7a05\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0938 Option \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u0906\u092a Selected Rows \u0915\u093e Automatically Subtotal \u0928\u093f\u0915\u093e\u0932 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d13f932 elementor-widget elementor-widget-heading\" data-id=\"d13f932\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Show Detail<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9151cb6 elementor-widget elementor-widget-text-editor\" data-id=\"9151cb6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Group \u0915\u0940 \u0917\u0908 Rows \u0914\u0930 Columns \u0915\u094b Show \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0907\u0938 Option \u0915\u093e Use \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6b77281 elementor-widget elementor-widget-heading\" data-id=\"6b77281\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Hide Detail<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2d6b689 elementor-widget elementor-widget-text-editor\" data-id=\"2d6b689\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Group \u0915\u0940 \u0917\u0908 Rows \u0914\u0930 Columns \u0915\u094b Hide \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0907\u0938 Option \u0915\u093e Use \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-115638e7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"115638e7\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4a2d136e\" data-id=\"4a2d136e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-59a8c20a elementor-widget elementor-widget-eael-content-ticker\" data-id=\"59a8c20a\" data-element_type=\"widget\" data-widget_type=\"eael-content-ticker.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<div class=\"eael-ticker-wrap\" id=\"eael-ticker-wrap-59a8c20a\"><div class=\"ticker-badge\">\n                    <span>Trending Today<\/span>\n                <\/div><div class=\"swiper-container-wrap eael-ticker\">\n                <div class=\"swiper-container eael-content-ticker swiper-container-59a8c20a\" data-pagination=\".swiper-pagination-59a8c20a\" data-arrow-next=\".swiper-button-next-59a8c20a\" data-arrow-prev=\".swiper-button-prev-59a8c20a\" data-effect=\"slide\" data-speed=\"400\" data-autoplay=\"2000\" data-loop=\"1\" data-arrows=\"1\">\n                    <div class=\"swiper-wrapper\"><div class=\"swiper-slide\">\n        <div class=\"ticker-content\">\n            <a href=\"https:\/\/aiyoit.com\/tutorial\/introduction-to-tally-prime\/\" class=\"ticker-content-link\">Introduction to Tally Prime<\/a>\n        <\/div>\n    <\/div><div class=\"swiper-slide\">\n        <div class=\"ticker-content\">\n            <a href=\"https:\/\/aiyoit.com\/tutorial\/medium-quize\/\" class=\"ticker-content-link\">Medium &#8211; Quize<\/a>\n        <\/div>\n    <\/div><div class=\"swiper-slide\">\n        <div class=\"ticker-content\">\n            <a href=\"https:\/\/aiyoit.com\/tutorial\/advanced-quize\/\" class=\"ticker-content-link\">Advanced &#8211; Quize<\/a>\n        <\/div>\n    <\/div><div class=\"swiper-slide\">\n        <div class=\"ticker-content\">\n            <a href=\"https:\/\/aiyoit.com\/tutorial\/basic-quize\/\" class=\"ticker-content-link\">Basic &#8211; Quize<\/a>\n        <\/div>\n    <\/div><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"content-ticker-pagination\"><div class=\"swiper-button-next swiper-button-next-59a8c20a\"><i class=\"fas fa-angle-right\"><\/i><\/div><div class=\"swiper-button-prev swiper-button-prev-59a8c20a\"><i class=\"fas fa-angle-left\"><\/i><\/div><\/div>\n\t\t\t<\/div>\n\t\t<\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-730341b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"730341b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e71d75d\" data-id=\"e71d75d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2ecd3227 elementor-share-buttons--view-icon-text elementor-share-buttons--skin-gradient elementor-share-buttons--shape-square elementor-grid-0 elementor-share-buttons--color-official elementor-widget elementor-widget-share-buttons\" data-id=\"2ecd3227\" data-element_type=\"widget\" data-widget_type=\"share-buttons.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<link rel=\"stylesheet\" href=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/plugins\/elementor-pro\/assets\/css\/widget-share-buttons.min.css\">\t\t<div class=\"elementor-grid\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\">\n\t\t\t\t\t\t<div\n\t\t\t\t\t\t\tclass=\"elementor-share-btn elementor-share-btn_facebook\"\n\t\t\t\t\t\t\trole=\"button\"\n\t\t\t\t\t\t\ttabindex=\"0\"\n\t\t\t\t\t\t\taria-label=\"Share on facebook\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-facebook\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tFacebook\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\">\n\t\t\t\t\t\t<div\n\t\t\t\t\t\t\tclass=\"elementor-share-btn elementor-share-btn_pinterest\"\n\t\t\t\t\t\t\trole=\"button\"\n\t\t\t\t\t\t\ttabindex=\"0\"\n\t\t\t\t\t\t\taria-label=\"Share on pinterest\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-pinterest\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tPinterest\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\">\n\t\t\t\t\t\t<div\n\t\t\t\t\t\t\tclass=\"elementor-share-btn elementor-share-btn_linkedin\"\n\t\t\t\t\t\t\trole=\"button\"\n\t\t\t\t\t\t\ttabindex=\"0\"\n\t\t\t\t\t\t\taria-label=\"Share on linkedin\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-linkedin\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tLinkedIn\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\">\n\t\t\t\t\t\t<div\n\t\t\t\t\t\t\tclass=\"elementor-share-btn elementor-share-btn_whatsapp\"\n\t\t\t\t\t\t\trole=\"button\"\n\t\t\t\t\t\t\ttabindex=\"0\"\n\t\t\t\t\t\t\taria-label=\"Share on whatsapp\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-whatsapp\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tWhatsApp\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>MS Excel Data Tab \u0915\u093e Use External Sources \u0938\u0947 Data \u0915\u094b Import \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0964 \u0907\u0938\u0915\u0947 \u0905\u0932\u093e\u0935\u093e \u0939\u092e Data \u092e\u0947\u0902 Sort &#038; Filter, Advance Filter, Data Validation&#8230;.<\/p>\n","protected":false},"author":6,"featured_media":7257,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[44],"tags":[10,9,985,497,1511,1525,1515,1513,1507,1529,1528,1519,1506,52,1517,1521,1509,1512,564,568,565,1518,1514,517,1522,1508,51,1520,1516,1505,1510,1524,1527,1526,1523],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/posts\/7192"}],"collection":[{"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/comments?post=7192"}],"version-history":[{"count":15,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/posts\/7192\/revisions"}],"predecessor-version":[{"id":7255,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/posts\/7192\/revisions\/7255"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/media\/7257"}],"wp:attachment":[{"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/media?parent=7192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/categories?post=7192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/tags?post=7192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}