20";display:block;height:0;overflow:hidden}.clearfix:after{clear:both}.tie-container,#tie-wrapper{height:100%;min-height:650px}.tie-container{position:relative;overflow:hidden}#tie-wrapper{background:#fff;position:relative;z-index:108;height:100%;margin:0 auto}.container-wrapper{background:#fff;border:1px solid rgba(0,0,0,.1);border-radius:2px;padding:30px}#content{margin-top:30px}@media (max-width:991px){#content{margin-top:15px}}.site-content{-ms-word-wrap:break-word;word-wrap:break-word}.theme-header{background:#fff;position:relative;z-index:999}.theme-header:after{content:"";display:table;clear:both}.theme-header.has-shadow{box-shadow:rgba(0,0,0,.1) 0px 25px 20px -20px}#menu-components-wrap{display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-justify-content:space-between;-ms-flex-pack:justify;justify-content:space-between;width:100%;-webkit-flex-wrap:wrap;-ms-flex-wrap:wrap;flex-wrap:wrap}.logo-row{position:relative}#logo{margin-top:40px;margin-bottom:40px;display:block;float:left}#logo a{display:inline-block}#logo.text-logo a{color:var(--brand-color)}.logo-text{font-size:50px;line-height:50px;font-weight:700}@media (max-width:670px){.logo-text{font-size:30px}}@media (max-width:991px){#theme-header.has-normal-width-logo #logo{margin:14px 0!important;text-align:left;line-height:1}}@media (max-width:991px){#theme-header.mobile-header-default:not(.header-layout-1) #logo{-webkit-flex-grow:10;-ms-flex-positive:10;flex-grow:10}}.components{display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-align-items:center;-ms-flex-align:center;align-items:center;-webkit-justify-content:end;-ms-flex-pack:end;justify-content:end}.components>li{position:relative}.components>li>a{display:block;position:relative;width:30px;text-align:center;font-size:16px;white-space:nowrap}.components .search-bar form{width:auto;background:rgba(255,255,255,.1);line-height:36px;border-radius:50px;position:relative}.components #search-input{border:0;width:100%;background:0 0;padding:0 35px 0 20px;border-radius:0;font-size:inherit}.components #search-submit{position:absolute;right:0;top:0;width:40px;line-height:inherit;color:#777;background:0 0;font-size:15px;padding:0;border:none}@media (max-width:991px){.logo-container{border-width:0;display:-webkit-flex;display:-ms-flexbox;display:flex;-webkit-flex-flow:row nowrap;-ms-flex-flow:row nowrap;flex-flow:row nowrap;-webkit-align-items:center;-ms-flex-align:center;align-items:center;-webkit-justify-content:space-between;-ms-flex-pack:justify;justify-content:space-between}}.mobile-header-components{display:none;z-index:10;height:30px;line-height:30px;-webkit-flex-wrap:nowrap;-ms-flex-wrap:nowrap;flex-wrap:nowrap;-webkit-flex:1 1 0%;-ms-flex:1 1 0%;flex:1 1 0%}.mobile-header-components .components{float:none;display:-webkit-flex!important;display:-ms-flexbox!important;display:flex!important;-webkit-justify-content:stretch;-ms-flex-pack:stretch;justify-content:stretch}.mobile-header-components .components li.custom-menu-link{display:inline-block;float:none}.mobile-header-components .components li.custom-menu-link>a{width:20px;padding-bottom:15px}.mobile-header-components [class^=tie-icon-]{font-size:18px;width:20px;height:20px;vertical-align:middle}.mobile-header-components .tie-mobile-menu-icon{font-size:20px}.mobile-header-components .nav-icon{display:inline-block;width:20px;height:2px;background-color:var(--base-color);position:relative;top:-4px}.mobile-header-components .nav-icon:before,.mobile-header-components .nav-icon:after{position:absolute;right:0;background-color:var(--base-color);content:'';display:block;width:100%;height:100%;-webkit-transform:translateZ(0);transform:translateZ(0);-webkit-backface-visibility:hidden;backface-visibility:hidden}.mobile-header-components .nav-icon:before{-webkit-transform:translateY(-7px);-ms-transform:translateY(-7px);transform:translateY(-7px)}.mobile-header-components .nav-icon:after{-webkit-transform:translateY(7px);-ms-transform:translateY(7px);transform:translateY(7px)}#mobile-header-components-area_1 .components li.custom-menu-link>a{margin-right:15px}#mobile-header-components-area_2 .components{-webkit-flex-direction:row-reverse;-ms-flex-direction:row-reverse;flex-direction:row-reverse}#mobile-header-components-area_2 .components li.custom-menu-link>a{margin-left:15px}@media (max-width:991px){.logo-container:before,.logo-container:after{height:1px}#tie-body #mobile-container,.mobile-header-components{display:block}#slide-sidebar-widgets{display:none}}.top-nav{background-color:#fff;position:relative;z-index:10;line-height:40px;border:1px solid rgba(0,0,0,.1);border-width:1px 0;color:var(--base-color);clear:both}.main-nav-below.top-nav-above .top-nav{border-top-width:0}.top-nav a:not(.button):not(:hover){color:var(--base-color)}.topbar-wrapper{display:-webkit-flex;display:-ms-flexbox;display:flex;min-height:40px}.top-nav .tie-alignleft,.top-nav .tie-alignright{-webkit-flex-grow:1;-ms-flex-positive:1;flex-grow:1;position:relative}.top-nav.has-breaking-news .tie-alignleft{-webkit-flex:1 0 100px;-ms-flex:1 0 100px;flex:1 0 100px}.top-nav.has-breaking-news .tie-alignright{-webkit-flex-grow:0;-ms-flex-positive:0;flex-grow:0;z-index:1}.topbar-today-date{float:left;padding-right:15px;-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0}@media (max-width:991px){.topbar-today-date,.theme-header .components{display:none}}.breaking{display:none}.main-nav-wrapper{position:relative;z-index:4}.main-nav{background-color:var(--main-nav-background);color:var(--main-nav-primary-color);position:relative;border:1px solid var(--main-nav-main-border-color);border-width:1px 0}.main-menu-wrapper{position:relative}@media (min-width:992px){#main-nav{z-index:9;line-height:60px}.main-nav-dark{--main-nav-background:#1f2024;--main-nav-secondry-background:rgba(0,0,0,.2);--main-nav-primary-color:var(--brand-color);--main-nav-contrast-primary-color:var(--bright-color);--main-nav-text-color:#fff;--main-nav-secondry-text-color:rgba(225,255,255,.5);--main-nav-main-border-color:rgba(255,255,255,.07);--main-nav-secondry-border-color:rgba(255,255,255,.04)}.main-nav-dark .main-nav{border-width:0}}@media (min-width:992px){.main-nav-boxed .main-nav{border-width:0}.main-nav-boxed .main-menu-wrapper{float:left;width:100%;background-color:var(--main-nav-background);padding-right:15px}}.main-nav-boxed .main-nav:not(.fixed-nav){background:0 0!important}@media (max-width:991px){#tie-wrapper header#theme-header{box-shadow:none;background:0 0!important}.logo-container{border-width:0;box-shadow:0 3px 7px 0 rgba(0,0,0,.1)}.logo-container{background-color:#fff}.header-layout-3 .main-nav-wrapper{display:none}.main-menu-wrapper .main-menu-wrap{width:100%}}.magazine2 .container-wrapper{border-width:0;padding:0;background-color:transparent;opacity:.99}.magazine2.post-layout-1 .entry-header-outer{padding:0 0 20px}.magazine2 .entry-content{padding:0 0 30px}@media (max-width:670px){.magazine2 .entry-content{padding:0 0 15px}}.main-nav-dark .main-nav input{color:#ccc}input{border:1px solid rgba(0,0,0,.1);color:var(--base-color);font-size:13px;outline:none;padding:10px 12px;line-height:23px;border-radius:2px;max-width:100%;background-color:transparent}input:not([type=checkbox]):not([type=radio]){-webkit-appearance:none;-moz-appearance:none;appearance:none;outline:none}@media (max-width:767px){input:not([type=submit]){font-size:16px!important}}.button,[type=submit]{width:auto;position:relative;background-color:var(--tie-buttons-color,var(--brand-color));color:var(--tie-buttons-text,var(--bright-color));border-radius:var(--tie-buttons-radius,2px);border:var(--tie-buttons-border-width,0) solid var(--tie-buttons-border-color,var(--brand-color));padding:10px 25px;margin:0;font-weight:600;font-size:14px;display:inline-block;text-align:center;line-height:21px;text-decoration:none;vertical-align:middle;-webkit-appearance:none;-moz-appearance:none;appearance:none}@media (min-width:992px){.sidebar-right .main-content{float:left}.sidebar-right.magazine2 .main-content{padding-right:5px}}.post-thumb{position:relative;height:100%;display:block;-webkit-backface-visibility:hidden;backface-visibility:hidden;-webkit-transform:rotate(0);-ms-transform:rotate(0);transform:rotate(0)}.post-thumb img{width:100%;display:block}.post-thumb .post-cat-wrap{position:absolute;bottom:10px;margin:0;right:10px}.post-meta{margin:10px 0 8px;font-size:12px;overflow:hidden}.post-meta,.post-meta a:not(:hover){color:#666}.post-meta .meta-item{margin-right:8px;display:inline-block}.post-meta .meta-item.tie-icon:before{padding-right:3px}.post-meta .meta-item.date:before{content:"\f017"}.post-meta .meta-item.meta-comment:before{content:"\f086"}.post-meta .tie-alignright .meta-item:last-child{margin:0!important}@media (max-width:767px){.entry-header .post-meta>span,.entry-header .post-meta>div,.main-content .post-meta>span,.main-content .post-meta>div{float:left}}.post-cat-wrap{position:relative;z-index:3;margin-bottom:5px;font-weight:400;font-family:inherit!important;line-height:0;display:block}.post-cat{display:inline-block;background:var(--brand-color);color:var(--bright-color);padding:0 11px;font-size:13px;line-height:2em;margin-right:4px;position:relative;white-space:nowrap;word-wrap:normal;letter-spacing:0;border-radius:4px}.post-cat:first-child:last-child{margin:0}#breadcrumb{margin:50px 0 0}#breadcrumb,#breadcrumb a:not(:hover){color:#666}#breadcrumb .delimiter{margin:0 3px;font-style:normal}.entry-header-outer #breadcrumb{margin:0 0 20px;padding:0}@media (max-width:767px){.single-post #breadcrumb .current,.single-post #breadcrumb em:last-of-type{display:none}}.entry-header{padding:30px 30px 0;margin-bottom:20px}@media (max-width:991px){.entry-header{padding:20px 20px 0}}.entry{line-height:26px;font-size:15px}.entry p{margin-bottom:25px;line-height:26px}@media (max-width:767px){.container-wrapper,.entry-content{padding:20px 15px}}.block-head-1 .the-global-title{position:relative;font-size:17px;padding:0 0 15px;border-bottom:2px solid rgba(0,0,0,.1);margin-bottom:20px}.block-head-1 .the-global-title:after{content:"";background:#2c2f34;width:40px;height:2px;position:absolute;bottom:-2px;left:0}.block-head-1 .the-global-title:before{content:"";width:0;height:0;position:absolute;bottom:-5px;left:0;border-left:0;border-right:5px solid transparent;border-top:5px solid #2c2f34}.side-aside{position:fixed;top:0;z-index:111;visibility:hidden;width:350px;max-width:100%;height:100%;background:#fff;background-repeat:no-repeat;background-position:center top;background-size:cover;overflow-y:auto}@media (min-width:992px){.side-aside{right:0;-webkit-transform:translate(350px,0);-ms-transform:translate(350px,0);transform:translate(350px,0)}}.dark-skin{--lazyload-loading-color:#161717}.dark-skin{background-color:var(--tie-dark-skin-bg-main,#1f2024);color:#fff}.dark-skin input:not([type=submit]){color:#ccc}.dark-skin a:not(:hover){color:#fff}.dark-skin input:not([type=submit]){border-color:rgba(255,255,255,.1)}.dark-skin .container-wrapper{background-color:var(--tie-dark-skin-bg-main,#1f2024);border-color:rgba(255,255,255,.1)}.dark-skin .widget a:not(:hover){color:#fff}.widget-title{position:relative}.widget-title .the-subtitle{font-size:15px;min-height:15px}.widget-title-icon{position:absolute;right:0;top:1px;color:#b9bec3;font-size:15px}.widget-title-icon:before{content:"\f08d"}.post-widget-body{padding-left:125px}.post-widget-body .post-title{font-size:14px;line-height:1.4;margin-bottom:5px}.post-widget-thumbnail{float:left;margin-right:15px;position:relative}.widget li{padding:6px 0}.widget li:first-child{padding-top:0}.widget li:last-child{padding-bottom:0;border-bottom:0}.widget li:after{clear:both;display:table;content:""}.widget .post-meta{margin:2px 0 0;font-size:11px;line-height:17px}.posts-list-big-first .posts-list-items li:first-child{padding-bottom:20px}.posts-list-big-first li:first-child .post-widget-thumbnail{width:100%;margin-right:0;margin-bottom:10px}.posts-list-big-first li:first-child .post-widget-thumbnail a{min-height:40px}.posts-list-big-first li:first-child .post-widget-body{padding-left:0}.posts-list-big-first li:first-child .post-title{font-size:18px}@media (max-width:991px){.posts-list-big-first .posts-list-items{overflow:hidden}.posts-list-big-first li{width:48%;float:left}.posts-list-big-first li:nth-child(2n+1){clear:both}}@media (max-width:670px){.posts-list-big-first li{width:100%}}form.search-form{overflow:auto;position:relative;width:100%;margin-top:10px}.search-field{float:left;width:73%;padding:8px 15px}.search-submit[type=submit]{float:right;padding:10px 5px;margin-left:2%;width:25%}.login-widget .widget-title-icon:before{content:"\f023"}.login-widget form input[type=text],.login-widget form input[type=password]{width:100%;float:none;margin-bottom:15px}.login-widget .pass-container{position:relative}.login-widget .pass-container input[type=password]{padding-right:70px}.login-widget .forget-text{position:absolute;right:15px;line-height:45px;top:0;font-size:12px}.login-widget .forget-text:not(:hover){color:#666}.login-widget .rememberme{display:block;margin-bottom:15px}li.widget-post-list{padding:7px 0;position:relative}.social-icons-widget ul{margin:0 -3px}.widget_media_image img{margin:0 auto;display:block}@media (min-width:992px){.theme-header .logo-row>div{height:auto!important}}.breaking{float:left;width:100%;display:block!important}.breaking-title{padding:0 10px;display:block;float:left;color:#fff;font-size:12px;position:relative}.breaking-title span{position:relative;z-index:1}.breaking-title span.breaking-icon{display:none}@media (max-width:600px){.breaking-title span.breaking-icon{display:inline-block}.breaking-title .breaking-title-text{display:none}}.breaking-title:before{content:"";background:#f05555;width:100%;height:100%;position:absolute;left:0;top:0;z-index:0}.breaking-news{display:none}#mobile-container{display:none;padding:10px 30px 30px}#mobile-menu{margin-bottom:20px;position:relative;padding-top:15px}#mobile-social-icons{margin-bottom:15px}#mobile-social-icons ul{text-align:center;overflow:hidden}#mobile-search .search-form{overflow:hidden;position:relative}#mobile-search .search-form:after{position:absolute;content:"\f002";font-family:'tiefonticon';top:4px;right:10px;line-height:30px;width:30px;font-size:16px;border-radius:50%;text-align:center;color:#fff}#mobile-search .search-field{background-color:rgba(0,0,0,.05);border-color:rgba(255,255,255,.1);color:#fff;width:100%;border-radius:50px;padding:7px 45px 7px 20px}#mobile-search .search-submit{background:0 0;font-size:0;width:35px;height:38px;position:absolute;top:0;right:5px;z-index:1}#mobile-search input::-webkit-input-placeholder{color:rgba(255,255,255,.6)}#mobile-search input::-moz-placeholder{color:rgba(255,255,255,.6)}#mobile-search input:-moz-placeholder{color:rgba(255,255,255,.6)}#mobile-search input:-ms-input-placeholder{color:rgba(255,255,255,.6)}#tie-wrapper:after{position:absolute;z-index:1000;top:-10%;left:-50%;width:0;height:0;background:rgba(0,0,0,.2);content:'';opacity:0}@media (max-width:991px){.side-aside.appear-from-left{left:0;-webkit-transform:translate(-100%,0);-ms-transform:translate(-100%,0);transform:translate(-100%,0)}.side-aside.is-fullwidth{width:100%}}.is-desktop .side-aside .has-custom-scroll{padding:50px 0 0}.side-aside:after{position:absolute;top:0;left:0;width:100%;height:100%;background:rgba(0,0,0,.2);content:'';opacity:1}.side-aside .container-wrapper{padding:30px!important;border-radius:0;border:0;background:0 0;box-shadow:none!important}a.remove{position:absolute;top:0;right:0;display:block;speak:never;-webkit-font-smoothing:antialiased;-moz-osx-font-smoothing:grayscale;width:20px;height:20px;display:block;line-height:20px;text-align:center;font-size:15px}a.remove:before{content:"\e117";font-family:'tiefonticon';color:#e74c3c}a.remove.big-btn{width:25px;height:25px;line-height:25px;font-size:22px}a.remove.light-btn:not(:hover):before{color:#fff}.side-aside a.remove{z-index:1;top:15px;left:50%;right:auto;-webkit-transform:translateX(-50%);-ms-transform:translateX(-50%);transform:translateX(-50%)}.side-aside a.remove:not(:hover):before{color:#111}.side-aside.dark-skin a.remove:not(:hover):before{color:#fff}.tie-popup a.remove{-webkit-transform:scale(.2);-ms-transform:scale(.2);transform:scale(.2);opacity:0;top:15px;right:15px;z-index:1}.theiaStickySidebar:after{content:"";display:table;clear:both}.side-aside,.has-custom-scroll{overflow-x:hidden;scrollbar-width:thin}.side-aside::-webkit-scrollbar,.has-custom-scroll::-webkit-scrollbar{width:5px}.side-aside::-webkit-scrollbar-track,.has-custom-scroll::-webkit-scrollbar-track{background:0 0}.side-aside::-webkit-scrollbar-thumb,.has-custom-scroll::-webkit-scrollbar-thumb{border-radius:20px;background:rgba(0,0,0,.2)}.dark-skin .has-custom-scroll::-webkit-scrollbar-thumb{background:#000}.tie-popup{position:fixed;z-index:99999;left:0;top:0;height:100%;width:100%;background-color:rgba(0,0,0,.5);display:none;-webkit-perspective:600px;perspective:600px}.tie-popup-container{position:relative;z-index:100;width:90%;max-width:420px;margin:10em auto 0;border-radius:2px;box-shadow:0 0 20px rgba(0,0,0,.2);will-change:transform,opacity;-webkit-transform:scale(.5);-ms-transform:scale(.5);transform:scale(.5);opacity:0}.tie-popup-container .login-submit{padding-top:15px;padding-bottom:15px}.tie-popup-container .container-wrapper{padding:60px;background-color:#fff!important;border-radius:5px}@media (max-width:479px){.tie-popup-container .container-wrapper{padding:30px}}.pop-up-live-search{will-change:transform,opacity;-webkit-transform:scale(.7);-ms-transform:scale(.7);transform:scale(.7);opacity:0}.tie-popup-search-wrap::-webkit-input-placeholder{color:#fff}.tie-popup-search-wrap::-moz-placeholder{color:#fff}.tie-popup-search-wrap:-moz-placeholder{color:#fff}.tie-popup-search-wrap:-ms-input-placeholder{color:#fff}.tie-popup-search-wrap form{position:relative;height:80px;margin-bottom:20px}.popup-search-wrap-inner{position:relative;padding:80px 15px 0;margin:0 auto;max-width:800px}input.tie-popup-search-input{width:100%;height:80px;line-height:80px;background:rgba(0,0,0,.7)!important;font-weight:500;font-size:22px;border:0;padding-right:80px;padding-left:30px;color:#fff;border-radius:5px}button.tie-popup-search-submit{font-size:28px;color:#666;position:absolute;right:5px;top:15px;background:0 0!important}#tie-popup-search-mobile .popup-search-wrap-inner{padding-top:50px}#tie-popup-search-mobile input.tie-popup-search-input{height:50px;line-height:1;padding-left:20px;padding-right:50px}#tie-popup-search-mobile button.tie-popup-search-submit{font-size:16px;top:9px;right:0}#autocomplete-suggestions{overflow:auto;padding:20px;color:#eee;position:absolute;display:none;width:370px;z-index:9999;margin-top:15px}.tie-icon-facebook:before{content:"\f09a"}.tie-icon-search:before{content:"\f002"}.tie-icon-author:before{content:"\f007"}.tie-icon-home:before{content:"\f015"}.tie-icon-tags:before{content:"\f02c"}.tie-icon-bookmark:before{content:"\f02e"}.tie-icon-camera:before{content:"\f030"}.tie-icon-random:before{content:"\f074"}.tie-icon-twitter:before{content:"\e90f"}.tie-icon-navicon:before{content:"\f0c9"}.tie-icon-bolt:before{content:"\f0e7"}.tie-icon-paper-plane:before{content:"\f1d8"}.tie-icon-whatsapp:before{content:"\f232"}.tie-icon-fire:before{content:"\e900"}.post-content.container-wrapper{padding:0}.entry-header{font-size:45px;line-height:1.2}@media (max-width:767px){.entry-header{font-size:28px}}.entry-header .entry-title{margin-bottom:15px}@media (max-width:767px){.entry-header .entry-title{font-size:28px}}.entry-header .post-cat{margin-bottom:6px}.entry-header .post-meta{overflow:inherit;font-size:12px;margin-top:5px;margin-bottom:0;line-height:24px}.entry-header .post-meta .meta-item{margin-right:12px}.entry-header .post-meta,.entry-header .post-meta a:not(:hover){color:#333}.entry-header .post-meta .meta-author{margin:0}.entry-header .post-meta .meta-author a{font-weight:600}.entry-header .post-meta .author-meta+.date:before{content:"22";color:#ccc;margin:0 3px 0 5px;display:inline-block}.entry-header .post-meta .tie-alignright{display:inline}@media (max-width:767px){.entry-header .post-meta{margin-bottom:-8px}.entry-header .post-meta .tie-alignright{float:none}.entry-header .post-meta .meta-item,.entry-header .post-meta .tie-alignright .meta-item:last-child{margin-bottom:8px!important}.entry-header .post-meta>span,.entry-header .post-meta>div{float:initial!important}.entry-header .post-meta .meta-author a{font-weight:400}}.post-layout-1 div.entry-content{padding-top:0}.post-layout-1 .entry-header-outer{padding:30px 30px 20px}@media (max-width:767px){.post-layout-1 .entry-header-outer{padding:20px}}.post-layout-1 .entry-header{padding:0;margin:0}.featured-area{position:relative;margin-bottom:30px;line-height:1}@media (max-width:767px){.featured-area{margin-bottom:20px}}.featured-area img{width:100%}.single-featured-image{position:relative;margin:0;line-height:0}.single-caption-text{position:absolute;bottom:0;left:0;padding:5px 10px;background:rgba(0,0,0,.6);color:#fff;line-height:1.8;font-size:90%}.entry-content{padding:0 30px 30px}@media (max-width:767px){.entry-content{padding-right:15px;padding-left:15px}}.entry h2{margin:0 0 .5em}@media (max-width:767px){.single .entry-content{padding-top:15px}}.post-bottom-meta{margin:3px 0 0;font-size:11px;clear:both;line-height:20px}.post-bottom-meta:after{content:"";display:table;clear:both}.post-bottom-meta-title{float:left;padding:0 6px;margin:5px 5px 0 0;background:#2c2f34;border:1px solid rgba(0,0,0,.1);border-radius:2px}.post-bottom-meta-title{color:#fff}.post-tags-modern{margin-top:30px}.post-tags-modern .post-bottom-meta-title{display:none}.share-buttons{padding:18px 28px;line-height:0}@media (max-width:767px){.share-buttons{padding:15px}}.share-buttons-mobile{position:fixed;bottom:0;z-index:999999;width:100%;background:0 0;border:0 none;padding:0}.share-buttons-mobile .share-links a{margin:0;border-radius:0;width:1%;display:table-cell;opacity:1!important}.share-buttons-mobile .share-links a .share-btn-icon{margin:0 auto;float:none}@media (min-width:768px){.share-buttons-mobile{display:none}}.mobile-share-buttons-spacer{height:40px}@media (min-width:768px){.mobile-share-buttons-spacer{display:none}}.share-links a{color:#fff}.share-links{overflow:hidden;position:relative}.share-links .share-btn-icon{font-size:15px}.share-links a{display:inline-block;margin:2px;height:40px;overflow:hidden;position:relative;border-radius:2px;width:40px}.share-links a,.share-links a:before{background-color:#444}.share-links a .share-btn-icon{width:40px;height:40px;float:left;display:block;text-align:center;line-height:40px}.share-links a.facebook-share-btn,.share-links a.facebook-share-btn:before{background:#4080ff}.share-links a.twitter-share-btn,.share-links a.twitter-share-btn:before{background:#000}.share-links a.whatsapp-share-btn,.share-links a.whatsapp-share-btn:before{background:#43d854}.share-links a.telegram-share-btn,.share-links a.telegram-share-btn:before{background:#08c}@media (min-width:768px){a.whatsapp-share-btn,a.telegram-share-btn{display:none!important}}#related-posts .related-item{position:relative;float:left;width:33.333%;padding:0 15px;margin-bottom:20px}@media (max-width:767px){#related-posts .related-item{padding:0 8px}}#related-posts .related-item .post-thumb{margin-bottom:10px}#related-posts .related-item .post-title{font-size:14px;line-height:19px}#related-posts .related-item .post-meta{margin:4px 0 0}.has-sidebar .site-content #related-posts .related-item:nth-child(3n+1){clear:both}@media (max-width:767px){#related-posts .related-item{width:50%!important;clear:none!important}}#related-posts.has-extra-post .related-item:last-child{clear:none!important;display:none}@media only screen and (min-width:320px) and (max-width:767px){#related-posts.has-extra-post .related-item:last-child{display:block}}#cancel-comment-reply-link{float:right;line-height:18px}#reading-position-indicator{display:block;height:5px;position:fixed;bottom:0;left:0;background:var(--brand-color);box-shadow:0 0 10px rgba(0,136,255,.7);width:0;z-index:9999;max-width:100%}#check-also-box{position:fixed;background-color:#fff;z-index:999;bottom:15px;right:-1px;-webkit-transform:translatex(100%);-ms-transform:translatex(100%);transform:translatex(100%);width:340px;padding:30px;border:1px solid rgba(0,0,0,.1);border-radius:2px;border-top-right-radius:0;border-bottom-right-radius:0}#check-also-box .has-first-big-post .post-widget-body{clear:both}#check-also-box .posts-list-big-first li{padding-bottom:0}#check-also-box .posts-list-big-first li .post-title{font-size:18px;line-height:1.3em}@media (max-width:991px){#check-also-box{display:none}}#post-extra-info{display:none}
Tricks in Excel to become an expert - Tech Smart
tricks in excel to become an expert.png Tips for Excel
Excel is a program that was launched on the market 37 years ago and since then it has been widely used in companies, so much so that It is a skill highly valued by recruiters.
However, not only is it helpful to have some basic knowledge with this tool for the job, but also, spreadsheets with personal accounts can be created and reviewed from any device, this will be much more practical than continuing to write down the expenses of the week and the month in a notebook.
Here are some tricks to apply in Excel that will make it easier to use:
An activity that is always very necessary when working with documents in Excel is to select all the cells that have been created in the same spreadsheet and this sometimes becomes tedious, especially when there is already enough information recorded. For this, it will only be enough to press the key combination CTRL+E, and if it’s a mac Cmd + A . With this command you can change format elements in less time.
1. Select all the blank cells that you want to delete.
2. Press F5 and when the “Go to” option has been opened, select “Special”.
3. Next, click on “Blank Cells” and then type the key combination CTRL + Minus (-).
4. Finally, select the option that says “Delete rows”
5. How to find duplicate values in a list
6. Select the data that you want to validate.
7. On the home tab select the “Styles” group and then click on “Conditional Formatting”.
8. Then click on “Rules to highlight cells” and finally choose the option that says “Duplicate Values”
Usually people who work with Excel formulas learn to perform their tasks quickly and without using the mouse, for example, if you want to edit a cell without double-clicking the mouse just press the F2 key.
Select the data to convert and press the key combination at the same time CTR + SHIFT + 4 in this way the numerical values can be converted into monetary format easily and without complication.
1. Copy the link of the web page where the information you want to insert in the spreadsheet is located.
2. Now go to the “Data” tab, select “Get Data”, then choose the “From other sources” option.
3. Then you must click on “From the web” and paste the link that was copied previously.
4. As a last step, you must select the table in which you want to paste the imported information.
Doing this without having to go through the toolbar option by option is as simple as selecting the numbers you want to convert to percentages and pressing the keys at the same time. CTRL + SHIFT + 5.
To filter data in a simple way, you must locate in any cell and press the key combination CTRL + SHIFT + L then it only remains to click on the arrow that is generated in the header of the list to start filtering the data by different aspects.
:
Back to top button