</ iframe ></noscript> <!-- For Large Screens header _InnerLayout_FullWidth_B4_V2_TW--> <div class="bg-[#010413] h-[3.4rem] z-[110] w-full shadow-lg lg:!block hidden relative"> <nav class=" flex items-center justify-between custom-container"> <div class="mx-auto flex justify-between w-full"> <div class="flex items-center space-x-4 w-full my-1"> <main-search class="w-full" [showLogo]="true"></main-search> </div> <!-- LoggedUserHiddenVars Partial --> <input type="hidden" id="ImageCDN" data-value="https://cdn-images-gf-prod.azureedge.net" /> <input type="hidden" id="Username" data-value="" /> <input type="hidden" id="UserRoleInSelectedCompany" data-value="" /> <input type="hidden" id="ShowSetupCompanyLink4CompanyAdmin" data-value="" /> <input type="hidden" id="SelectedCompanyPackageId" data-value="-1" /> <input type="hidden" id="SelectedCompanyPackageName" data-value="" /> <input type="hidden" id="UpgradeLinkUrl" data-value="" /> <input type="hidden" id="UpgradeLinkTitle" data-value="" /> <input type="hidden" id="ChangeCompanyLink" data-value="" /> <input type="hidden" id="DebugMode" data-value="" /> <input type="hidden" id="ShowSwitchToPreviousUser" data-value="" /> <input type="hidden" id="PreviousUser" data-value="" /> <input type="hidden" id="CartItemCount" data-value="" /> <div class="hidden lg:flex items-center"> <!-- For Large Screens --> <div class="hidden lg:flex items-center"> <style> .Image-icon-xs { height: 40px; width: 40px; } .topdrpheadercolor { background: black; color: white; } .topdrpCard-top { border-top: 4px solid #00b9bd; } .viewcartdrp-menu { left: auto; right: 21%; min-width: 25%; } .cartitemscount { border-radius: 50%; color: #fff; display: inline-block; font-size: 12px; height: 18px; line-height: 16px; padding: 2px; position: relative; text-align: center; float: right; min-width: 20px; background: red; } </style> <ul class="flex space-x-2 my-1 "> <li> <a class="inline-flex items-center px-4 py-[10px] text-white border border-orange-500 bg-[#000]-600 rounded-[4px] text-sm font-semibold transition duration-200 whitespace-nowrap" href="/account/login"> Login </a> </li> <li> <a class="inline-flex items-center px-4 py-[10px] text-white border border-orange-500 bg-[#e56932] rounded-[4px] text-sm font-semibold transition duration-200 whitespace-nowrap" href="/Account/Register"> Get Started </a> </li> </ul> <div id="changeCompanyModal" class="normal-width-popup" style="display:none;"> <div class="modal-overlay"> <div class="modal-container lg:w-[70%] w-full"> <div class="modal-content mt-[15px]"> <div class="modal-header"> <h3 class="text-2xl font-semibold p-3 py-4">Change Company</h3> <button class="p-0 ml-auto bg-transparent border-0 text-black float-right text-3xl leading-none font-semibold outline-none focus:outline-none" id="CloseModelIcon" onclick="closeChangeCompany()"> <span id="popupCloseIcon" class="text-white text-2xl block outline-none focus:outline-none p-3 py-4 bg-[#c94d4d] rounded-tr-lg">×</span> </button> </div> <div> <app-change-company></app-change-company> </div> </div> </div> </div> </div> <script> function openChangeCompany(isRoleChange) { const changeCompanyModal = document.getElementById("changeCompanyModal"); if (changeCompanyModal) { changeCompanyModal.style.display = "block"; } // ✅ Must match exactly 'openChangeCompanyModal' window.dispatchEvent(new CustomEvent('openChangeCompanyModal', { detail: isRoleChange })); } function closeChangeCompany() { const changeCompanyModal = document.getElementById("changeCompanyModal"); if (changeCompanyModal) { changeCompanyModal.style.display = "none"; } } document.addEventListener("DOMContentLoaded", function () { // Get modal elements const changeCompanyModal = document.getElementById("changeCompanyModal"); const closeModelIcon = document.getElementById("CloseModelIcon"); // Get dropdown elements const cartButton = document.getElementById("cartButton"); const cartDropdown = document.getElementById("cartDropdown"); const topHeaderIcon = document.getElementById("topHeaderIcon"); const topHeaderdropdown = document.getElementById("topHeaderdropdown"); const closeDropdownIcon = document.getElementById("closeDropdown"); // Close modal when clicking the close icon if (closeModelIcon && changeCompanyModal) { closeModelIcon.addEventListener("click", function () { changeCompanyModal.style.display = "none"; }); } // Toggle cart dropdown visibility if (cartButton && cartDropdown) { cartButton.addEventListener("click", function (e) { e.stopPropagation(); const isVisible = cartDropdown.classList.contains("opacity-100"); cartDropdown.classList.toggle("opacity-100", !isVisible); cartDropdown.classList.toggle("visible", !isVisible); cartDropdown.classList.toggle("opacity-0", isVisible); cartDropdown.classList.toggle("invisible", isVisible); }); } // Toggle top header dropdown visibility if (topHeaderIcon && topHeaderdropdown) { topHeaderIcon.addEventListener("click", function (e) { e.stopPropagation(); const isVisible = topHeaderdropdown.classList.contains("opacity-100"); topHeaderdropdown.classList.toggle("opacity-100", !isVisible); topHeaderdropdown.classList.toggle("visible", !isVisible); topHeaderdropdown.classList.toggle("opacity-0", isVisible); topHeaderdropdown.classList.toggle("invisible", isVisible); }); } // Close dropdowns when clicking outside document.addEventListener("click", function () { if (cartDropdown) { cartDropdown.classList.add("opacity-0", "invisible"); cartDropdown.classList.remove("opacity-100", "visible"); } if (topHeaderdropdown) { topHeaderdropdown.classList.add("opacity-0", "invisible"); topHeaderdropdown.classList.remove("opacity-100", "visible"); } }); // Close cart dropdown when clicking the close icon if (closeDropdownIcon && cartDropdown) { closeDropdownIcon.addEventListener("click", function () { cartDropdown.classList.add("opacity-0", "invisible"); cartDropdown.classList.remove("opacity-100", "visible"); }); } }); </script> </div> </div> </div> </nav> </div> <!-- For Small Screens header _InnerLayout_FullWidth_B4_V2_TW--> <div class="lg:hidden flex bg-[#010413] fixed top-0 right-0 left-0 z-[555]"> <div class="w-full flex justify-between items-center relative py-1 px-2 gap-0.5"> <div class="w-full"> <div class="flex items-center space-x-4"> <main-search class="w-full" [showLogo]="true"></main-search> </div> </div> <div class=""> <!-- For Small Screens --> <div class="lg:hidden flex justify-end right-1"> <style> .Image-icon-xs { height: 40px; width: 40px; } .topdrpheadercolor { background: black; color: white; } .topdrpCard-top { border-top: 4px solid #00b9bd; } .viewcartdrp-menu { left: auto; } .drpMenuLeft { left: auto; right: 0; } .moreLinks .dropdown-toggle::after { display: none; } .moreLinks .dropdown-menu { min-width: 15rem; } .moreLinks small { font-size: 65%; } .cursor-pointer { position: relative; z-index: 10; } </style> <div class="flex gap-1 items-center"> <!-- Login Button --> <div class="my-auto"> <a href="/account/login" class="inline-flex items-center justify-center px-1.5 py-2 border bg-white border-orange-500 text-orange-500 rounded-md hover:bg-orange-500 hover:text-white transition-colors duration-200" title="Login"> <i class="fa-solid fa-right-to-bracket"></i> </a> </div> <!-- Register Button --> <div class="my-auto"> <a href="/account/register" class="inline-flex items-center justify-center px-1.5 py-2 border hover:bg-white border-[#6dd5c0] hover:!text-[#6dd5c0] rounded-md bg-[#6dd5c0] text-white transition-colors duration-200" title="Register"> <i class="fa-solid fa-user-plus"></i> </a> </div> </div> <div id="changeCompanyModalsmall" class="normal-width-popup hidden"> <div class="modal-overlay"> <div class="modal-container lg:w-[70%] w-full"> <div class="modal-content"> <div class="modal-header"> <h3 class="text-2xl font-semibold p-3 py-4">Change Company</h3> <button class="p-0 ml-auto bg-transparent border-0 text-black float-right text-3xl leading-none font-semibold outline-none focus:outline-none" id="CloseModelIconsmall" onclick="closeChangeCompanySmall()"> <span id="popupCloseIconsmall" class="text-white text-2xl block outline-none focus:outline-none p-3 py-4 bg-[#c94d4d] rounded-tr-lg">×</span> </button> </div> <div> <app-change-company></app-change-company> </div> </div> </div> </div> </div> <script> function openChangeCompanySmall(isRoleChange) { const changeCompanyModal = document.getElementById("changeCompanyModalsmall"); if (changeCompanyModal) { changeCompanyModal.style.display = "block"; } // ✅ Must match exactly 'openChangeCompanyModal' window.dispatchEvent(new CustomEvent('openChangeCompanyModal', { detail: isRoleChange })); } function closeChangeCompanySmall() { const changeCompanyModal = document.getElementById("changeCompanyModalsmall"); if (changeCompanyModal) { changeCompanyModal.style.display = "none"; } } document.addEventListener("DOMContentLoaded", function () { const toggleButton = document.getElementById("dropdownToggle"); const dropdownContent = document.getElementById("dropdownContent"); const dropdownButton = document.getElementById('dropdownheaderButton'); const dropdownMenu = document.getElementById('dropdownMenu'); const topHeaderIcon = document.getElementById('topHeaderIcon'); const closeModelIcon = document.getElementById('CloseModelIcon'); const topHeaderdropdown = document.getElementById('topHeaderdropdown'); // Toggle top header dropdown visibility if (dropdownButton && topHeaderdropdown) { dropdownButton.addEventListener('click', function (e) { e.stopPropagation(); const isVisible = topHeaderdropdown.classList.contains('opacity-100'); topHeaderdropdown.classList.toggle('opacity-100', !isVisible); topHeaderdropdown.classList.toggle('visible', !isVisible); topHeaderdropdown.classList.toggle('opacity-0', isVisible); topHeaderdropdown.classList.toggle('invisible', isVisible); }); } // Toggle dropdown visibility if (toggleButton && dropdownContent) { toggleButton.addEventListener("click", function (event) { event.stopPropagation(); dropdownContent.classList.toggle("hidden"); if (dropdownMenu) dropdownMenu.classList.add("hidden"); }); } // Toggle dropdown menu visibility if (dropdownButton && dropdownMenu) { dropdownButton.addEventListener("click", function (event) { event.stopPropagation(); dropdownMenu.classList.toggle("hidden"); }); } // Close all dropdowns when clicking outside document.addEventListener("click", function () { if (dropdownContent) dropdownContent.classList.add("hidden"); if (dropdownMenu) dropdownMenu.classList.add("hidden"); if (topHeaderdropdown) { topHeaderdropdown.classList.add('opacity-0', 'invisible'); topHeaderdropdown.classList.remove('opacity-100', 'visible'); } }); // Close dropdowns when clicking inside if (dropdownContent) { dropdownContent.addEventListener("click", function () { dropdownContent.classList.add("hidden"); }); } if (dropdownMenu) { dropdownMenu.addEventListener("click", function () { dropdownMenu.classList.add("hidden"); }); } }); </script> <!-- Show on small screens --> </div> </div> </div> </div> <!-- Start-Global messaging --> <div id="global-messaging" class="container" > <div id="valSummary" class="alert alert-danger error hide" style="color:Green;display:none;"> </div> <div id="lblSuccess" class="alert alert-success confirmation hide"></div> <div id="lblInformation" class="alert alert-info notice hide"></div> <div id="lblAlert" class="alert alert-warning alerts hide"></div> </div> <!-- End- Global messaging --> <input type="hidden" id="CourseId" data-value="2081" /> <input type="hidden" id="PreviewType" data-value="" /> <input type="hidden" id="EncyrptedData" data-value="" /> <input type="hidden" id="CUID" data-value="Kcwt3nzM3ZI=" /> <input type="hidden" id="CouponId" data-value="0" /> <div class="sticky top-0 pl-2 py-0 z-50 bg-opacity-90 w-full bg-[#010413] transition-opacity duration-300 ease-in-out hidden" id="stickyElement"> <div class="custom-container px-2 py-2 text-white"> <div class="w-full"> <span class="bg-[#00ae6b] text-white preview-header-badge">Course</span> <h3 class="md:!text-3xl text-xl font-semibold mb-1">Microsoft Excel Zero to Hero - Complete Excel Course 2023</h3> </div> </div> </div> <div class="md:!pt-0 pb-3 md:!px-2 relative bg-gray-900 text-white w-full headercommon block" id="previewhead"> <div class="custom-container pt-0.5 px-2"> <span class=""> <span class="bg-[#00ae6b] text-white preview-header-badge">Course</span> </span> <div class="mt-1 mb-0 md:!text-sm text-[13px] text-gray-300 flex items-center space-x-2"> <a class="text-[#42bda8] font-semibold" href="/courses/computer-skills-and-office-productivity">Computer Skills and Office Productivity</a> <span class="text-[#42bda8]">></span> <a class="text-[#42bda8] font-semibold" href="/courses/microsoft-excel">Microsoft Excel</a> </div> <h1 class="md:!text-3xl text-xl lg:!leading-none leading-none font-semibold">Microsoft Excel Zero to Hero - Complete Excel Course 2023</h1> <div class="w-full md:w-1/4 mt-1"> <div class="trained_by_with_dates text-white rounded-sm shadow p-1"> <div class=""> <div class="flex flex-col items-center"> <div class="w-full text-center"> <p class="text-[0.8rem] text-gray-300">Trained by:</p> <div class="flex flex-row items-center justify-center gap-6"> <div class="flex flex-row"> <b class="block -mr-[15px]"> <a href="/user/sudhasekhar"> <img src="https://cdn-images-gf-prod.azureedge.net/assets/user/200_200_pyrg2545GP.png" alt="Metla Sudha Sekhar" loading="lazy" class="rounded-full border" style="height:30px; width: 30px;" /> </a> </b> </div> <div class="text-[0.8rem] font-medium text-white"> Metla Sudha Sekhar </div> </div> </div> </div> </div> </div> </div> </div> </div> <nav aria-label="breadcrumb" class="bg-[#f0f4f8]"> <div class="custom-container py-0.5"> <div class="flex text-gray-900 p-1"> <div class="flex align-middle"> <span class="pl-1 flex md:!text-sm text-[12px] hover:bg-gray-200 hover:rounded-md justify-center items-center"> <button routerLink="/" class="flex my-auto ml-auto rounded-full hover:bg-gray-200 hover:rounded-md"> <svg class="w-3 h-3" viewBox="-5 0 24 24" version="1.1" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:sketch="http://www.bohemiancoding.com/sketch/ns" fill="#000000"> <g id="SVGRepo_bgCarrier" stroke-width="0"></g> <g id="SVGRepo_tracerCarrier" stroke-linecap="round" stroke-linejoin="round"></g> <g id="SVGRepo_iconCarrier"> <title>chevron-left</title> <desc>Created with Sketch Beta.</desc> <defs></defs> <g id="Page-1" stroke="none" stroke-width="1" fill="none" fill-rule="evenodd" sketch:type="MSPage"> <g id="Icon-Set" sketch:type="MSLayerGroup" transform="translate(-421.000000, -1195.000000)" fill="#000000"> <path d="M423.429,1206.98 L434.686,1196.7 C435.079,1196.31 435.079,1195.67 434.686,1195.28 C434.293,1194.89 433.655,1194.89 433.263,1195.28 L421.282,1206.22 C421.073,1206.43 420.983,1206.71 420.998,1206.98 C420.983,1207.26 421.073,1207.54 421.282,1207.75 L433.263,1218.69 C433.655,1219.08 434.293,1219.08 434.686,1218.69 C435.079,1218.29 435.079,1217.66 434.686,1217.27 L423.429,1206.98" id="chevron-left" sketch:type="MSShapeGroup"></path> </g> </g> </g> </svg> </button> <span class="p-1 flex text-sm text-muted hover:bg-gray-200 hover:rounded-md"> <span class=""><a href="/"><i class=""></i> Home</a></span> <span class="ml-1 mt-[5.5px]"> <svg class="w-3 h-3" viewBox="0 -6.5 36 36" version="1.1" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" fill="#000000"> <g id="SVGRepo_bgCarrier" stroke-width="0"></g> <g id="SVGRepo_tracerCarrier" stroke-linecap="round" stroke-linejoin="round"></g> <g id="SVGRepo_iconCarrier"> <title>right-arrow</title> <desc>Created with Sketch.</desc> <g id="icons" stroke="none" stroke-width="1" fill="none" fill-rule="evenodd"> <g id="ui-gambling-website-lined-icnos-casinoshunter" transform="translate(-212.000000, -159.000000)" fill="#252528" fill-rule="nonzero"> <g id="square-filled" transform="translate(50.000000, 120.000000)"> <path d="M187.108012,39.2902857 L197.649804,49.7417043 L197.708994,49.7959169 C197.889141,49.9745543 197.986143,50.2044182 198,50.4382227 L198,50.5617773 C197.986143,50.7955818 197.889141,51.0254457 197.708994,51.2040831 L197.6571,51.2479803 L187.108012,61.7097143 C186.717694,62.0967619 186.084865,62.0967619 185.694547,61.7097143 C185.30423,61.3226668 185.30423,60.6951387 185.694547,60.3080911 L194.702666,51.3738496 L162.99947,51.3746291 C162.447478,51.3746291 162,50.9308997 162,50.3835318 C162,49.8361639 162.447478,49.3924345 162.99947,49.3924345 L194.46779,49.3916551 L185.694547,40.6919089 C185.30423,40.3048613 185.30423,39.6773332 185.694547,39.2902857 C186.084865,38.9032381 186.717694,38.9032381 187.108012,39.2902857 Z M197.115357,50.382693 L186.401279,61.0089027 L197.002151,50.5002046 L197.002252,50.4963719 L196.943142,50.442585 L196.882737,50.382693 L197.115357,50.382693 Z" id="right-arrow"></path> </g> </g> </g> </g> </svg> </span> </span> <span class="py-1 flex text-sm text-gray-800 hover:bg-gray-200 hover:rounded-md "> <span>Course</span> </span> </span> </div> </div> </div> </nav> <div class="custom-body md:!mb-0 mb-20"> <div class="custom-container px-2 py-0.5" id="MainContainer"> <div class="flex flex-wrap mb-10 py-2"> <div class="lg:w-9/12"> <div class="border border-gray-200 shadow-custom-small lg:mr-4 md:!p-4 px-2 rounded-md bg-white"> <div class="card-body"> <app-course-introvideo></app-course-introvideo> <div class="flex flex-wrap" id="showSticky"> <div class="w-full"> <div class="clearfix space30"></div> <h2 class="md:!text-[1.75rem] text-[1.5rem] font-semibold mt-3 mb-2">Course Summary</h2> <div class="description preview-description text-justify lg:!text-[1rem] leading-6 course-container"><p>Welcome to Microsoft Excel Zero to Hero: The Complete Excel Course, With its latest version, this course teaches every essential concept of an Excel essential formula and regular office functional examples in a single course, allowing you to start your Excel course journey step by step.</p> <p>Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, XLookup, VLookup, HLookup, charts, 3D maps, and a programming language called Visual Basic for Applications. Excel forms part of the Microsoft Office 365 suite of software.</p></div> <div class="clearfix space30"></div> <div> <h2 class="md:!text-[1.75rem] text-[1.5rem] font-semibold mt-3 mb-2">Who can benefit?</h2> <div id="whocanbenefit" class="preview-description text-justify lg:!text-[1rem] leading-6 course-container"><p>Anyone using computers.</p> <ul> <li>You will need a PC with any version of Excel installed</li> <li>No prior technical experience is required! All you need a computer!</li> </ul> <p> </p></div> </div> <div> <h2 class="md:!text-[1.75rem] text-[1.5rem] font-semibold mt-3 mb-2">What you will learn?</h2> <span id="whatwillyoulearn" class="preview-description text-justify lg:!text-[1rem] leading-6 course-container"><ul> <li>Learn one of the most powerful Microsoft Excel that exists today</li> <li>Master on essential Excel formulas for data analysis</li> <li>Learn to apply Excel data formatting for your real-world data</li> <li>Aggregation results by applying Pivot table creations for analysis</li> <li>Create eye catching visual charts using Bar charts, scatter plots, pie etc.</li> <li>Develop skills on real-world functionality on Excel formulas on your sheet</li> <li>Estimate project timelines and budget chart preparations with hands-on sessions</li> <li>Master Excel's most popular functions such as VLOOKUP, HLOOKUP, index and match</li> <li>Learn Trending XLOOKUP and wildcard match formulas to improve results for analytics</li> <li>How to handle #N/A errors to approximate and match case</li> <li>Import data from TXT, .CSV, PFD and from Website to Excel spreadsheet </li> <li>Implement Business and Geo-charts for Business needs: stock, radar, surface charts etc..</li> <li>Learn to Apply Named ranges and indirect named range functions</li> </ul></span> </div> </div> </div> <app-root> </app-root> </div> </div> </div> <div class="lg:w-3/12"> <app-course-price-info> </app-course-price-info> </div> </div> </div> <app-course-join></app-course-join> </div> <script> window.addEventListener('scroll', function () { const stickyElement = document.getElementById('stickyElement'); const previewhead = document.getElementById('previewhead'); if (window.scrollY >= 50) { stickyElement.classList.remove('hidden'); stickyElement.classList.add('block'); previewhead.classList.add('hidden'); previewhead.classList.remove('block'); } else { stickyElement.classList.add('hidden'); stickyElement.classList.remove('block'); previewhead.classList.add('block'); previewhead.classList.remove('hidden'); } }); </script> <link rel="stylesheet" href="/css/course-preview-app.css" /> <script src="/js/course-preview-app.js"></script> <div class="bg-[#152f4f] py-4 text-white"> <div class="custom-container "> <div class="flex flex-col items-center text-center"> <!-- Copyright --> <p> © Copyright 2026 Guruface Inc. Designed by <a href="http://www.guruface.com" target="_blank">Guruface Inc.</a> </p> <!-- Icons under the text --> <div class="mt-3 space-x-4 text-xl"> <a class="fab fa-twitter text-white hover:text-gray-400"></a> <a class="fab fa-facebook-f text-white hover:text-gray-400"></a> <a class="fab fa-linkedin-in text-white hover:text-gray-400"></a> <!-- Uncomment if needed --> <!-- <a class="fa fa-google-plus text-gray-600 hover:text-gray-400" href=""></a> <a class="fa fa-dribbble text-gray-600 hover:text-gray-400" href="#"></a> <a class="fa fa-skype text-gray-600 hover:text-gray-400" href="#"></a> <a class="fa fa-behance text-gray-600 hover:text-gray-400" href="#"></a> <a class="fa fa-stumbleupon text-gray-600 hover:text-gray-400" href="#"></a> <a class="fa fa-rss text-gray-600 hover:text-gray-400" href="#"></a> --> </div> <!-- App Version Display Section --> </div> </div> </div> </body> </html>