</noscript> <!-- End Google Tag Manager (noscript) --> <a id="skip-nav" class="screenreader-text" href="#main-content">Skip Navigation or Skip to Content</a> <!-- CCE SERVER REFERENCE --> <script language="javascript" type="text/javascript"> </script> <div class="leftNavBack"> <input name="ctl00$Uctopnav1$hdnCartStatus" type="hidden" id="ctl00_Uctopnav1_hdnCartStatus" value="0" /> </div> <!-- END CCE SERVER REFERENCE --> <header class="top-bar topbar-responsive clearfix"> <div class="top-bar-title float-left"> <a class="topbar-responsive-logo" href="https://www.uvu.edu/ce" title="Visit Main Website (opens in new window)" target="_blank"><img src="https://www.campusce.net/uvu/configuration/uvu/img/uvu-mono.svg" style="height: 25px !important;" alt="School Logo" /> <strong>CONTINUING EDUCATION</strong></a> </div> <div class="top-bar-right"> <a href="../search/search2.aspx" title="Advanced Search"><button type="button" class="button hollow topbar-responsive-button"><i class="fas fa-search" aria-hidden="true"></i><span class="show-for-sr">Search Button</span></button></a> </div> </header> <div class="custom-menu"> <ul class="vertical medium-horizontal menu"> <li><a href="https://www.uvu.edu/ce/about-us/index.html" target="_blank"><i class="fi-list"></i> <span>Contact Us</span></a></li> <li><a href="../category/category.aspx"><i class="fi-list"></i> <span>Course Catalog</span></a></li> <li><a href="https://www.uvu.edu/ce/professional-education/index.html" target="_blank"><i class="fi-list"></i> <span>Professional Education</span></a></li> <li><a href="https://www.uvu.edu/communityed/elder/" target="_blank"><i class="fi-list"></i> <span>Elder Quest</span></a></li> <li><a href="https://www.uvu.edu/communityed/esl/index.html" target="_blank"><i class="fi-list"></i> <span>ESL</span></a></li> </ul> </div> <div class="hero-section"> <div class="hero-section-text"> <!--<h1>Header</h1> <h5>subtitle about anything you like</h5>--> </div> </div> <form name="aspnetForm" method="post" action="./course.aspx?C=678&pc=6&mc=13&sc=0" id="aspnetForm"> <div> <input type="hidden" name="__EVENTTARGET" id="__EVENTTARGET" value="" /> <input type="hidden" name="__EVENTARGUMENT" id="__EVENTARGUMENT" value="" /> <input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="VA30fvZr6KL9Squ3Uy3lMX3yUyGqW9LnOJgQrY5AXAZZBrO41tGjcn7xLT835RGu5pM5Qp8veMYTzmPP+YTy3WSuaTv1biwsheOzpcCTkZjM8G7EjKQ3BVv/G+053hos1/mqdsY+lG8TChT7GRKho93LA9KN3ekKzkYdxIVgCHUZHPx+/cqHPAXC8dZEWPiOx3umNaU9MHARZkN84GKj2Xy9yW+iTng1iOYQla4NalJQIiGA9VQlisW49ehIXnCGBqYm7Bo++1zzPddackDNBLYBHRKNpmXX0o/ol8P+K5Lv1CUoTaLkA+D7Dxwfg5O/aquxjWboBeMdmyRrX2qiTZWm5QImfblijV5y26VuxQGxuoBqBKtMfj2N4N/GzfWQ+OqvLgWmZsDURyRo/DaCnTIm1W6L25f+mwGTYUZrk7lFcDUiRsue8wCg+E/Mydjbi33dweop8MYO9+M1r2P+Y/u/vN9Vu1tkeUYRdqoSC8qaNjvmETd84la6bKwLAVNe8V7xGk30oWsMCZ6UrgnAwq/g992LREleGmbdlCFSjDexpKtKImbofTF8Jg2mLBpVwfdxa6UFcclZVzq7HbyT17bssqwQJO06bTCrb6ZAyEsG41RROxZWc40qVONrW+/O1wcowdrjcoBX5w+QdbCFZhSVGl+eaeVOTSFCsi5wiAmSThjRsogwLAYqVi4AelMer2OzoO2pU2I/YSaFcLZExOl23iuD74Dd3NUKNDV3IqCiLMCd2/OyjCMvXWh2f5c3TIVxhfF4QKclJgIdb5B1TG6BcRcYrNHCOgtMKY28Dcn/NWJMCEMLA9wCYKabcjMxy5G5Bl59zWFv4utSYom0L+1nB4VSw8sarnRgx5jjN6RJtnSAhuuXpezv0rPaFO/2mOVc+D9UgMI/iWpkU762hQYedFlOAhe169s+PEdLY3bRK9yhvkl6btVbQC4fnzb+vS2VW/Cp0j96lJYQTExSyKwf1RfImqHNInt/fmXz5eovFUzK+8bPQei/SHzIiEX5OViZB7F/rhqPQFrntwErt/7RMMcR6K/F/ipTFOnE8ENJh8QQ4rv9z8PcO+6f7xODgbOrnDjTSWOAIZsbuEo2P+WXw1bxWW7rkVGmhYL6NXN/NDDGyuE5Qtlz9xWdoXSCjoMRtdZmaHZaYkiLkXAOYvNQUvaUpu37rq7Ftv8ocHh/EXnvzGESodsFaefxhmn31WFOUJk2GIjMuP8xK274lKr6DQjjD2g3yUj0lWhOPu2ffajYe7HrvbTW2wsWwVKDru3266QoTmDyfhgtnv3Ti0z3dC4HXqut5k5Ambmh7AlMHIZoK9LJKiWcWVcLO12n9Bz8TGvwN7busnl/X7Iy787QWeZQDvfMR5PPfAch5jlByTCUoXISOzymhKzdvJD/5zIDbbh7Y8R6FLoU3qgYZajUMMu0odk1GycGR6NbDEyLcXIvFtizyVaHHQBEITcBQLAqip3oFxD6Mpx/4hVugJOuXbA4ygwjEgaU+e9/khKmtGphmEcTxTRXT060tgy8L8HsHJ4Fs0yB64Goj5sw63AhXm5je/RydekJvJlEhlkAeECh1SGcKU7K3veTv2SgX9L/sQU+qTN5SlgZ0ltldRn5fUVg603HmiMEyfA7j0gC9+7bdcgWK9vFZO/O451wnUWDsov6h9caAD0LwBEazq3x/U3shSQx7tA4dUAKxa9Md2JWVTiPWEFmgmmXUmq6eL7erWjpXv2J9LYR8zGduA==" /> </div> <script type="text/javascript"> //<![CDATA[ var theForm = document.forms['aspnetForm']; if (!theForm) { theForm = document.aspnetForm; } function __doPostBack(eventTarget, eventArgument) { if (!theForm.onsubmit || (theForm.onsubmit() != false)) { theForm.__EVENTTARGET.value = eventTarget; theForm.__EVENTARGUMENT.value = eventArgument; theForm.submit(); } } //]]> </script> <script src="/uvu/WebResource.axd?d=pynGkmcFUV13He1Qd6_TZBt8ZAIUgY_ZXlRx7e_6d3uPC_2Cr7P-wFNopIO5d8Tn0TgwpwwFOL6Mu-WqgSaPSQ2&t=638627972640000000" type="text/javascript"></script> <script src="/uvu/ScriptResource.axd?d=NJmAwtEo3Ipnlaxl6CMhvjLdV-jrtFjD4O0RIIhtTlHZywVF3ykQqD8XGkEJ-YdbSXc7M8Qz0SWK-fj8yDVRzll72KnQgs51NzUeDqsBxdf2R-3l8Wh3e1-Rr0XL_0DpOHkd0IpPAeJS_mbbQHIny87qkrZY7bLmvbbTq8uFs7w1&t=2a9d95e3" type="text/javascript"></script> <script src="/uvu/ScriptResource.axd?d=dwY9oWetJoJoVpgL6Zq8OIKNKS3unt-J7H-_1wzNkap0Kq3oQwsFc0HrABh0DQkHMwK3VDKRgmlNLLAn8xJsXz9Y04TzP19YY6CwPF_pBYXnueRpJhSXj3RO5G7fQZvKkFV_TD7IKBJf2MvrFRQ6HAqLBNuJjc-k0wanD6598kY1&t=2a9d95e3" type="text/javascript"></script> <div> <input type="hidden" name="__VIEWSTATEGENERATOR" id="__VIEWSTATEGENERATOR" value="4B39941A" /> </div><!-- START CCE FORM --> <section role="region" aria-labelledby="CCESecMenu"> <div id="CCESecMenu"> <div class="row large-unstack"> <div class="large-8 columns"> <div id="top"> <div id="ctl00_Ucpreheader1_divPreHeaderWelcome" class="left" welcomeText="Welcome, "></div> <div id="ctl00_Ucpreheader1_headerNavMenu" class="right"><a id="ctl00_Ucpreheader1_linkPreHdrSignin" signOutText="Sign Out" signOutLink="../account/signout.aspx" href="../account/signin.aspx">Sign In</a><span> | </span><a id="ctl00_Ucpreheader1_hypGoCartIndex" href="../cart/index.aspx">View Cart</a><span> | </span><span> | </span><a id="ctl00_Ucpreheader1_hypFeedback" href="Javascript:feedBack('/uvu/feedBack/feedBack.aspx')">Help</a><span> | </span></div> </div> </div> <div class="large-4 columns"> <ul id="CCEMenu"> <li><a href="../search/search2.aspx" title="Search Catalog"><i class="fas fa-search" aria-hidden="true" aria-label="Search Catalog"></i> Search</a></li> <li><a href="../cart/index.aspx" title="Shopping Cart"><i class="fas fa-shopping-cart" aria-hidden="true" aria-label="Shopping Cart"></i> <span class='badge badge-warning' id='lblCartCount'> 0 </span> Cart</a><input name="hiddencartitems" type="hidden" id="hiddencartitems" value="0" /></li> <li><a href="../account/myaccount.aspx" title="My Account"><i class="fas fa-user-circle" aria-hidden="true" aria-label="My Accout"></i> Account</a></li> </ul> </div> </div> <script type="text/javascript"> function checkcart(name) { var el = FindElement(name); var cartcell = FindElement("lblCartCount"); if (el != null){ cartcell.innerHTML = ' ' + el.value + ' '; } } </script> </div> </section> <main id="main-content"> <div class="row columns large-12 clearfix"><!--START CCE CONTENT--> <div id="CCEContent" class="clearfix"> <div id="CCECatalog" class="clearfix"> <input type="hidden" name="ctl00$hdnMerchantCode" id="ctl00_hdnMerchantCode" /> <script type="text/javascript"> //<![CDATA[ Sys.WebForms.PageRequestManager._initialize('ctl00$ContentPlaceHolder1$sm', 'aspnetForm', [], [], [], 90, 'ctl00'); //]]> </script> <script type="text/javascript" language="javascript" src="../include/common.js"></script> <script type="text/javascript" language="javascript" src="../js/httpClient.js"></script> <script language="javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js" type="text/javascript"></script> <div id="rightnav"> <style type="text/css"> .style1 { width: 147px; } .style2 { width: 147px; height: 23px; } </style> <table class="extinfo"> <tr> <td class="style2"> <a id="ctl00_ContentPlaceHolder1_ucCoursePrint_lnkPrint" href="Javascript:coursePrint('678');" target="_self">Print Course information</a> </td> </tr> <tr> <td class="style1"> <a href="#" onclick="openEmailToFriendModal();"> Email me when offered </a> </td> </tr> <tr> <td class="style1"> <a id="ctl00_ContentPlaceHolder1_ucCoursePrint_lnkReturn" href="/uvu/">Return to Course Catalog</a> </td> </tr> </table> <br /> </div> <!-- this is the main content --> <div id="ctl00_ContentPlaceHolder1_CourseInfo" class="course-info-wrapper CourseInfo__singleCourse"> <a id="ctl00_ContentPlaceHolder1_ucBC_lnkCatalog" href="/uvu/category/category.aspx"> Course Catalog </a> <span id="ctl00_ContentPlaceHolder1_ucBC_Label1"> > </span> <a id="ctl00_ContentPlaceHolder1_ucBC_lnkPCat" href="../category/category.aspx?S=6">Community Education</a> <span id="ctl00_ContentPlaceHolder1_ucBC_Label2"> > </span> <a id="ctl00_ContentPlaceHolder1_ucBC_lnkMCat" href="../category/category.aspx?S=13">Computers</a> <header class="ucCourseInfo"> <h1 class="pageTitle CCEPrimaryHeader pageHeading">EXCEL: ADVANCED FORMULAS <span id="ctl00_ContentPlaceHolder1_ucCourse_lblNewTag" class="attn"></span> </h1> <span id="ctl00_ContentPlaceHolder1_ucCourse_lblDescription" class="para custom-description">Advance your excel skills with formulas to help you combine multiple cells, and work across multiple worksheets. Learn formulas for statistics logical IF, lookups, math conversions, and how to create and use ranges.<br /> Supply List:<br /> Laptops provided for in-class learning or bring your own if you like.</span> </header> <div id="ctl00_ContentPlaceHolder1_pnlClass" class="pnlClass"> </div> <div id="ctl00_ContentPlaceHolder1_pnlNoClass" class="attn"> <span>No classes currently available. <a href="javascript:history.go(-1)">Click here</a> to continue searching for courses.</span> </div> </div> <!--main--> <link href="../styles/popup.css" rel="stylesheet" type="text/css" /> <div id="bob" style="" onmouseleave="hidePopupDialog()"> <div id="bobarrow" style="top: 54px; left: -42px;"> <img class="bobArrow transp" src="../images/popup/up-left-combo.png" id="bobarrowulimg" style="display: block;" role="presentation"/> </div> <div id="bobtcap"> <img class="transp" src="../images/popup/topcap1.png" style="width: 290px; height: 23px; display: block;" id="bobtopcap" role="presentation" /> </div> <div class="transp" id="bobtitlebox"> <div class="bobcontentspace"> <div style="float:right"> <img src="../images/popup/xclose.gif" border="0" onclick="hidePopupDialog();" role="presentation" style="cursor:pointer;" /> </div> <div id="bobtitle" style="float:left"> <p>Some Title</p> </div> <div style="clear:both"></div> </div> </div> <div style="position: relative;" class="transp" id="bobinner"> <div class="bobcontentspace" id="bobcontent"> <div style="position: relative;" id="bobsynopsis"> <div id="ctl00_ContentPlaceHolder1_ucPopup_pnlMain" style="height:300px;overflow:auto;"> </div> </div> <br clear="all" /> </div> <br clear="all" style="line-height: 1px; font-size: 1px; height: 1px;" /> </div> <div id="bobbcap"> <img class="transp" src="../images/popup/bottomcap.png" style="width: 290px; height: 31px;" id="bobbottomcap" role="presentation" /></div> </div> <script language=javascript> function showPopupDialog(hyp, hidTitle, hidMessage) { var bobtitle = document.getElementById('bobtitle'); bobtitle.innerHTML = decodeHtml(document.getElementById(hidTitle).value); var bobsynopsis = document.getElementById('ctl00_ContentPlaceHolder1_ucPopup_pnlMain'); bobsynopsis.innerHTML = decodeHtml(document.getElementById(hidMessage).value); var itemPos = jQuery(hyp).offset(); var posx = itemPos.left + 60; var posy = itemPos.top - 50; var bob = document.getElementById('bob'); if (bob.parentNode != document.body) { bob.parentNode.removeChild(bob); document.body.appendChild(bob); } bob.style.left = posx + 'px'; bob.style.top = posy + 'px'; bob.style.visibility = 'visible'; } function decodeHtml(html) { var txt = document.createElement("textarea"); txt.innerHTML = html; return txt.value; } function hidePopupDialog() { var bob=document.getElementById('bob'); bob.style.visibility='hidden'; } function getElementLeft(elem) { var xPos = elem.offsetLeft; var tempEl = elem.offsetParent; while (tempEl != null) { xPos += tempEl.offsetLeft; tempEl = tempEl.offsetParent; } return xPos; } function getElementTop(elem) { var yPos = elem.offsetTop; var tempEl = elem.offsetParent; while (tempEl != null) { yPos += tempEl.offsetTop; tempEl = tempEl.offsetParent; } return yPos; } </script> <link href="../../styles/popup.css" rel="stylesheet" type="text/css" /> <script type="text/javascript" language="javascript"> function PopupAlert(alertType, itemID) { //replace with ajax call //cbAlertPopup.Callback(alertType, itemID); //WaitForCallback(cbAlertPopup.ClientObjectId , 250, "ShowPopup();"); var param = JSON.stringify({ 'alertType': alertType, 'itemID': itemID }); $.ajax({ url: '../controls/Dialog/PopupHelper.aspx/GetPopupContent', type: 'POST', dataType: 'json', //data: "{ 'alertType': '" + alertType + "',itemID:'" + itemID + "'}", data: param, contentType: 'application/json', success: function (response) { if (response.d && response.d != '') { ShowPopup(response.d); } else { console.warn(`No response could be obtain.`); } }, failure: function(msg) { console.error(msg); } }); } function ShowPopup(alertText) { if (alertText.length) { $('#tdContent').html(alertText); $('#divPopup').show(); $('#divPopup').draggable(); } } function HidePopup() { $('#divPopup').hide(); } </script> <link href="../../styles/jquery-ui.min.css" rel="stylesheet" type="text/css" /> <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.7.1/jquery-ui.min.js"></script> <style type="text/css"> #divPopup { width: 100%; height: 100%; top: 35%; position: absolute; display: none; } </style> <div id="divPopup" style="display: none"> <table width="458" onmousedown="alertDialog.StartDrag(event);" class="genericPopupHeader" cellpadding="0" cellspacing="0" id="alertDialog"> <tr> <td width="9" height="35" style="background-image: url(../images/genericdialog/top-left.png);"> </td> <td height="35" style="background-image: url(../images/genericdialog/top-mid.png); height: 35px !important;" valign="middle" width="409"> <span style="color: White; font-size: 15px; font-family: Arial; font-weight: bold;"> Alert</span> </td> <td width="40" height="35" valign="top" style="background-image: url(../images/genericdialog/top-right.png);"> <img src="../images/genericdialog/close.png" style="cursor: default; padding-top: 4px;" width="32" height="25" style="margin-top: 4px;" onmousedown="this.src='../images/genericdialog/close-down.png';" onmouseup="this.src='../images/genericdialog/close-hover.png';" onclick="HidePopup();" onmouseover="this.src='../images/genericdialog/close-hover.png';" onmouseout="this.src='../images/genericdialog/close.png';" /> </td> </tr> </table> <table cellpadding="0" cellspacing="0" width="458" class="genericPopup"> <tr> <td width="7" style="background-image: url(../images/genericdialog/left.png);"> </td> <td style="background-color: white; font-size: 12px; font-family: Arial;"> <table width="100%" cellpadding="0" cellspacing="0"> <tr> <td style="padding: 5px; height: 50px; text-align: left; vertical-align: middle" id="tdContent"> </td> </tr> <tr> <td style="background-image: url(../images/genericdialog/bottom_content.gif); height: 41px; padding-right: 10px;" align="right"> <input type='button' onclick='HidePopup();' value='Close' /> </td> </tr> </table> </td> <td width="7" style="background-image: url(../images/genericdialog/right.png)";> </td> </tr> </table> <table cellpadding="0" cellspacing="0" width="458" height="7" class="genericPopupFooter"> <tr> <td width="9" height="7"> <img style="display: block;" src="../images/genericdialog/bottom-left.png" /> </td> <td style="background-image: url(../images/genericdialog/bottom-mid.png);" width="440"> </td> <td width="9" height="7"> <img style="display: block;" src="../images/genericdialog/bottom-right.png" /> </td> </tr> </table> </div> <input type="hidden" name="ctl00$ContentPlaceHolder1$hdnCourses" id="hdnCourses" /> <script type="text/javascript"> const emailToFriendURL = `https://www.campusce.net/uvu/course/EmailToFriend.aspx`; const reloadEmailToFriendModalOnClose = false; document.addEventListener('DOMContentLoaded', function () { const emailToFriendModalOverlay = document.getElementById('emailToFriendModalOverlay') const emailToFriendModalWindow = document.getElementById('emailToFriendModalWindow'); const emailToFriendIFrame = document.getElementById('emailToFriendIFrame'); const emailToFriendModalContent = document.getElementById('emailToFriendModalContent'); const emailToFriendModalLoading = document.getElementById('emailToFriendModalLoading'); const emailToFriendModalLink = document.getElementById('emailToFriendModalLink'); const emailToFriendModalCloseIcon = document.getElementById('emailToFriendModalCloseIcon') const emailToFriendModalReloadIcon = document.getElementById('emailToFriendModalReloadIcon'); if (emailToFriendModalCloseIcon) emailToFriendModalCloseIcon.addEventListener('click', function () { closeEmailToFriendModal(); }); if (emailToFriendModalReloadIcon) emailToFriendModalReloadIcon.addEventListener('click', function () { reloadEmailToFriendModal(); }); if (emailToFriendModalOverlay) emailToFriendModalOverlay.addEventListener('click', function () { emailToFriendModalOverlay.style.display = 'none'; emailToFriendModalWindow.style.display = 'none'; }); }); function clickEmailToFriendModalLink(event, element) { event.preventDefault(); if (!element || !element.dataset || !element.dataset.id || !emailToFriendIFrame) return; const elDataId = element.dataset.id; if (elDataId > 0) { emailToFriendIFrame.src = `${emailToFriendURL}?cid=${elDataId}`; openEmailToFriendModal(); } } function openEmailToFriendModal() { emailToFriendModalLoading.style.display = 'flex'; emailToFriendModalContent.style.display = 'none'; emailToFriendModalOverlay.style.display = 'block'; emailToFriendModalWindow.style.display = 'block'; emailToFriendModalContent.style.width = emailToFriendModalWindow.offsetWidth + 'px'; emailToFriendModalContent.style.height = emailToFriendModalWindow.offsetHeight + 'px'; setTimeout(() => { emailToFriendModalLoading.style.display = 'none'; emailToFriendModalContent.style.display = 'block'; }, 500); } function closeEmailToFriendModal() { emailToFriendModalContent.style.display = 'none'; emailToFriendModalLoading.style.display = 'none'; emailToFriendModalOverlay.style.display = 'none'; emailToFriendModalWindow.style.display = 'none'; if (reloadEmailToFriendModalOnClose) reloadEmailToFriendModal(); else { emailToFriendIFrame.src = ``; } } function reloadEmailToFriendModal() { emailToFriendIFrame.src = emailToFriendIFrame.src; } window.addEventListener('resize', function () { if (emailToFriendModalWindow.style.display === 'block') { openEmailToFriendModal(); // Dynamically resizes the modal } }); </script> <div id="emailToFriendModalOverlay" class="modal-overlay"></div> <div id="emailToFriendModalWindow" class="modal-window"> <span id="emailToFriendModalCloseIcon" class="modal-close-icon">×</span> <span id="emailToFriendModalReloadIcon" class="modal-reload-icon"></span> <div id="emailToFriendModalLoading" class="modal-loading"> <img alt="loading" src="../images/loading.gif" /> </div> <div id="emailToFriendModalContent" class="modal-content"> <iframe id="emailToFriendIFrame" class="modal-iframe">
TOP
