{"id":2290,"date":"2023-06-04T11:56:05","date_gmt":"2023-06-04T05:56:05","guid":{"rendered":"https:\/\/infosystemltd.com\/?post_type=product&#038;p=2290"},"modified":"2023-11-22T21:39:16","modified_gmt":"2023-11-22T15:39:16","slug":"mastering-excel-skills","status":"publish","type":"product","link":"https:\/\/infosystemltd.com\/training-courses\/mastering-excel-skills\/","title":{"rendered":"Mastering Excel Skills"},"content":{"rendered":"\t\t<div data-elementor-type=\"product-post\" data-elementor-id=\"2290\" class=\"elementor elementor-2290\" data-elementor-post-type=\"product\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-957a437 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"957a437\" data-element_type=\"section\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\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-bbc14f0\" data-id=\"bbc14f0\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d89d01e elementor-tabs-view-horizontal elementor-widget elementor-widget-tabs\" data-id=\"d89d01e\" data-element_type=\"widget\" data-widget_type=\"tabs.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.21.0 - 30-04-2024 *\/\n.elementor-widget-tabs.elementor-tabs-view-vertical .elementor-tabs-wrapper{width:25%;flex-shrink:0}.elementor-widget-tabs.elementor-tabs-view-vertical .elementor-tab-desktop-title.elementor-active{border-inline-end-style:none}.elementor-widget-tabs.elementor-tabs-view-vertical .elementor-tab-desktop-title.elementor-active:after,.elementor-widget-tabs.elementor-tabs-view-vertical .elementor-tab-desktop-title.elementor-active:before{height:999em;width:0;right:0;border-inline-end-style:solid}.elementor-widget-tabs.elementor-tabs-view-vertical .elementor-tab-desktop-title.elementor-active:before{top:0;transform:translateY(-100%)}.elementor-widget-tabs.elementor-tabs-view-vertical .elementor-tab-desktop-title.elementor-active:after{top:100%}.elementor-widget-tabs.elementor-tabs-view-horizontal .elementor-tab-desktop-title{display:table-cell}.elementor-widget-tabs.elementor-tabs-view-horizontal .elementor-tab-desktop-title.elementor-active{border-bottom-style:none}.elementor-widget-tabs.elementor-tabs-view-horizontal .elementor-tab-desktop-title.elementor-active:after,.elementor-widget-tabs.elementor-tabs-view-horizontal .elementor-tab-desktop-title.elementor-active:before{bottom:0;height:0;width:999em;border-bottom-style:solid}.elementor-widget-tabs.elementor-tabs-view-horizontal .elementor-tab-desktop-title.elementor-active:before{right:100%}.elementor-widget-tabs.elementor-tabs-view-horizontal .elementor-tab-desktop-title.elementor-active:after{left:100%}.elementor-widget-tabs .elementor-tab-content,.elementor-widget-tabs .elementor-tab-title,.elementor-widget-tabs .elementor-tab-title:after,.elementor-widget-tabs .elementor-tab-title:before,.elementor-widget-tabs .elementor-tabs-content-wrapper{border:1px #d5d8dc}.elementor-widget-tabs .elementor-tabs{text-align:start}.elementor-widget-tabs .elementor-tabs-wrapper{overflow:hidden}.elementor-widget-tabs .elementor-tab-title{cursor:pointer;outline:var(--focus-outline,none)}.elementor-widget-tabs .elementor-tab-desktop-title{position:relative;padding:20px 25px;font-weight:700;line-height:1;border:solid transparent}.elementor-widget-tabs .elementor-tab-desktop-title.elementor-active{border-color:#d5d8dc}.elementor-widget-tabs .elementor-tab-desktop-title.elementor-active:after,.elementor-widget-tabs .elementor-tab-desktop-title.elementor-active:before{display:block;content:\"\";position:absolute}.elementor-widget-tabs .elementor-tab-desktop-title:focus-visible{border:1px solid #000}.elementor-widget-tabs .elementor-tab-mobile-title{padding:10px;cursor:pointer}.elementor-widget-tabs .elementor-tab-content{padding:20px;display:none}@media (max-width:767px){.elementor-tabs .elementor-tab-content,.elementor-tabs .elementor-tab-title{border-style:solid solid none}.elementor-tabs .elementor-tabs-wrapper{display:none}.elementor-tabs .elementor-tabs-content-wrapper{border-bottom-style:solid}.elementor-tabs .elementor-tab-content{padding:10px}}@media (min-width:768px){.elementor-widget-tabs.elementor-tabs-view-vertical .elementor-tabs{display:flex}.elementor-widget-tabs.elementor-tabs-view-vertical .elementor-tabs-wrapper{flex-direction:column}.elementor-widget-tabs.elementor-tabs-view-vertical .elementor-tabs-content-wrapper{flex-grow:1;border-style:solid solid solid none}.elementor-widget-tabs.elementor-tabs-view-horizontal .elementor-tab-content{border-style:none solid solid}.elementor-widget-tabs.elementor-tabs-alignment-center .elementor-tabs-wrapper,.elementor-widget-tabs.elementor-tabs-alignment-end .elementor-tabs-wrapper,.elementor-widget-tabs.elementor-tabs-alignment-stretch .elementor-tabs-wrapper{display:flex}.elementor-widget-tabs.elementor-tabs-alignment-center .elementor-tabs-wrapper{justify-content:center}.elementor-widget-tabs.elementor-tabs-alignment-end .elementor-tabs-wrapper{justify-content:flex-end}.elementor-widget-tabs.elementor-tabs-alignment-stretch.elementor-tabs-view-horizontal .elementor-tab-title{width:100%}.elementor-widget-tabs.elementor-tabs-alignment-stretch.elementor-tabs-view-vertical .elementor-tab-title{height:100%}.elementor-tabs .elementor-tab-mobile-title{display:none}}<\/style>\t\t<div class=\"elementor-tabs\">\n\t\t\t<div class=\"elementor-tabs-wrapper\" role=\"tablist\" >\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-2271\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"true\" data-tab=\"1\" role=\"tab\" tabindex=\"0\" aria-controls=\"elementor-tab-content-2271\" aria-expanded=\"false\">Overview<\/div>\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-2272\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"false\" data-tab=\"2\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-2272\" aria-expanded=\"false\">Curriculum<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t<div class=\"elementor-tabs-content-wrapper\" role=\"tablist\" aria-orientation=\"vertical\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"true\" data-tab=\"1\" role=\"tab\" tabindex=\"0\" aria-controls=\"elementor-tab-content-2271\" aria-expanded=\"false\">Overview<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-2271\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-2271\" tabindex=\"0\" hidden=\"false\"><h2><strong>Mastering in Excel for Future Professionals\/Leaders<\/strong><\/h2><p>Your first performance in your first job is dependent on Excel or Power-point mostly. So don&#8217;t miss our Beginner Excel Training. Unlock Your Potential to prove yourself ready for Entry Level Job. This Training is Designed for Fresh graduates and New Joiner in Corporate. It will give you an unbeatable edge to start your high performing day in Corporate. Best Expert and Corporate Practitioner will conduct the training. We shall provide training in computer lab so no need to carry your own.<\/p><p><strong>Key components of the Training:<\/strong><\/p><ul><li>Basic Excel Skills<\/li><li>Certificate of Completion<\/li><li>Expert and Practitioner-Led Training<\/li><li>Unbeatable Edge in the Corporate World<\/li><li>Dedicated Computer Lab<\/li><li>Tips and Tricks<\/li><\/ul><\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"false\" data-tab=\"2\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-2272\" aria-expanded=\"false\">Curriculum<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-2272\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"2\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-2272\" tabindex=\"0\" hidden=\"hidden\"><div class=\"row\"><div class=\"col-6\"><h5>Day-1 (Basic Excel Functions)<\/h5><p><strong>Common Excel Tools with Examples and Practice Sheet:<\/strong><\/p><ul class=\"course-list\"><li><i class=\"bx bx-check\">Workbook (New, Open, Save, Save As, Close)<\/i><\/li><li><i class=\"bx bx-check\">Worksheet (Insert, Modify, Move, Copy, Delete, Rename, Hide\/ Unhide)<\/i><\/li><li><i class=\"bx bx-check\">Rows, Columns (Insert, Copy, Cut, Delete, Hide\/ Unhide)<\/i><\/li><li><i class=\"bx bx-check\">Cells and Range (Select, Copy, Cut, Paste, Delete)<\/i><\/li><li><i class=\"bx bx-check\">Convert worksheets into PDF file<\/i><\/li><li><i class=\"bx bx-check\">Paste Special tricks by Values, Formulas, Validation and Transpose<\/i><\/li><li><i class=\"bx bx-check\">Smartest and Fastest way to Paste as Values<\/i><\/li><li><i class=\"bx bx-check\">Search for a value in the whole workbook<\/i><\/li><li><i class=\"bx bx-check\">Freeze top rows or left columns while scrolling data<\/i><\/li><li><i class=\"bx bx-check\">Arrange open workbooks as Titled, Horizontal, Vertical, Cascade<\/i><\/li><li><i class=\"bx bx-check\">Insert, Edit, Re size and Hide Comments<\/i><\/li><li><i class=\"bx bx-check\">Permanently display Comments<\/i><\/li><\/ul><\/div><div>\u00a0<\/div><div class=\"col-6\"><strong>Introduction of Functions and Formulas in Excel with Case Solving:<\/strong><\/div><div>\u00a0<\/div><div><ul><li><i class=\"bx bx-check\">Using Formula Bar for writing formulas<br \/><\/i><\/li><li><i class=\"bx bx-check\">Entering formulas directly in cells<br \/><\/i><\/li><li><i class=\"bx bx-check\">Using the Insert Function dialogue box<br \/><\/i><\/li><li><i class=\"bx bx-check\">Finding the appropriate function for a task<br \/><\/i><\/li><li><i class=\"bx bx-check\">Adding all numbers in a range using SUM Function<br \/><\/i><\/li><li><i class=\"bx bx-check\">Counting total numbers or texts with COUNT-COUNTA function<br \/><\/i><\/li><li><i class=\"bx bx-check\">Finding smallest and largest values with MIN- MAX function<br \/><\/i><\/li><li><i class=\"bx bx-check\">Rounding decimal numbers<\/i><\/li><\/ul><\/div><div>\u00a0<\/div><\/div><hr \/><div class=\"row\"><div class=\"col-6\"><h5>\u00a0<\/h5><h5>Day-2 Sessions<\/h5><p><strong>Short Cuts in Excel:<\/strong><\/p><ul class=\"course-list\"><li><p>Time saving Shortcuts with Cheat sheet<\/p><\/li><li><p>Quickly enter Today Date and Current Time<\/p><\/li><li><p>Fastest way to use SUM function<\/p><\/li><li><p>Instantly display Format Dialog box<\/p><\/li><li><p>Go to last or first cell in a column or row<\/p><\/li><li><p>Select data up to last row, last column quickly<\/p><\/li><li><p>Enter values in many cells at once<\/p><\/li><li><p>Insert new lines inside a same cell<\/p><\/li><\/ul><p><strong>Views and Comments<\/strong><\/p><\/div><ul><li>Freeze top rows or left columns while scrolling data<\/li><li>Arrange open workbooks as Titled, Horizontal, Vertical, Cascade<\/li><li>Insert, Edit, Re size and Hide Comments<\/li><li>Permanently display Comments<\/li><\/ul><p><strong>Charts and Trend Lines<\/strong><\/p><\/div><ul><li>Working with Chart Components (Axis, Categories, Series, Legend)<\/li><li>Re sizing, Moving and Copying Charts<\/li><li>Formatting and Styling Charts with 2D, 3D and Round effect<\/li><li>Creating Column, Line, Pie, Bar, Area and Scatter Charts<br \/>Chart Trend Lines (Linear, Exponential,<\/li><li>Polynomial and Moving Avg)<\/li><\/ul><p><strong>Introduction of Advance Tools for Practical Application in Corporate<\/strong><\/p><ul><li>Pivot-Table ( Reporting; Cost Calculation; Location wise demand mapping )<\/li><li>V-Look Up ( Demand Supply Planning )<\/li><li>Goal Seek ( Break Even Point Calculations; Limiting Business Value Propositions )<\/li><li>Solver ( Distribution Network Optimization )<\/li><li>Drop Down List and Validation ( Down Time Analysis &amp;amp; Capturing Records )<\/li><\/ul><div class=\"col-lg-4\"><div class=\"account-wrap\">\u00a0<\/div><\/div><\/div>\n\t\t\t\t\t\t\t<\/div>\n\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<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p class=\"fs-14px color-666 mb-1\"><strong class=\"color-000\">Total Class Duration: <\/strong><span id=\"Duration\">2 Days<\/span><\/p>\n<p class=\"fs-14px color-666 mb-1\"><strong class=\"color-000\">Day Of Classes: <\/strong>8th &amp; 9th December<\/p>\n<p>\ud835\udc13\ud835\udc2b\ud835\udc1a\ud835\udc22\ud835\udc27\ud835\udc22\ud835\udc27\ud835\udc20 \ud835\udc13\ud835\udc22\ud835\udc26\ud835\udc1e: <span class=\"x193iq5w xeuugli x13faqbe x1vvkbs x1xmvt09 x1lliihq x1s928wv xhkezso x1gmr53x x1cpjm7i x1fgarty x1943h6x xudqn12 x3x7a5m x6prxxf xvq8zen xo1l8bm xzsf02u x1yc453h\" dir=\"auto\">Friday 9.30 to 12.30 pm \/ Saturday 9.30 to 2.30 pm<\/span><\/p>\n<p class=\"fs-14px color-666 mb-1\"><strong class=\"color-000\">Digital Content:\u00a0<\/strong>Yes<\/p>\n<p class=\"fs-14px color-666 mb-1\"><strong class=\"color-000\">Certificate Format:\u00a0<\/strong>Digital &amp; Printed<\/p>\n","protected":false},"featured_media":3519,"template":"","meta":[],"product_cat":[18],"product_tag":[],"_links":{"self":[{"href":"https:\/\/infosystemltd.com\/wp-json\/wp\/v2\/product\/2290"}],"collection":[{"href":"https:\/\/infosystemltd.com\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/infosystemltd.com\/wp-json\/wp\/v2\/types\/product"}],"version-history":[{"count":2,"href":"https:\/\/infosystemltd.com\/wp-json\/wp\/v2\/product\/2290\/revisions"}],"predecessor-version":[{"id":3518,"href":"https:\/\/infosystemltd.com\/wp-json\/wp\/v2\/product\/2290\/revisions\/3518"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/infosystemltd.com\/wp-json\/wp\/v2\/media\/3519"}],"wp:attachment":[{"href":"https:\/\/infosystemltd.com\/wp-json\/wp\/v2\/media?parent=2290"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/infosystemltd.com\/wp-json\/wp\/v2\/product_cat?post=2290"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/infosystemltd.com\/wp-json\/wp\/v2\/product_tag?post=2290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}