< Back to all Training Materials STS Trainer login Excel 2: Boost Your Excel IQ: Mastering Functions Slides Files </div></div> <footer class=" has-global-padding entry-footer"> <div> </div> </footer> </article> <footer class="is-layout-constrained has-global-padding"> <div> </div> </footer> </main> <footer id="footer" class="uw-footer has-contrast-background-color is-layout-constrained has-global-padding"> <div class="alignwide"> <h2 class="show-for-sr uw-footer-header">Site footer content</h2> <div class="uw-footer-content"> <div class="uw-logo"> <div class="uw-logo-link-wrapper"><a href="https://www.wisc.edu"><svg role="img" aria-label="UW logo. Link to main university website" ><use href="https://sts.doit.wisc.edu/training-materials/wp-content/themes/uw-theme-gutenberg-child/build/uw-icons.svg?ver=7#uw-icon-crest-footer"></use></svg></a><a href="https://www.wisconsin.edu/" class="uw-footer-stand-out-link">Part of the <span class="no-break">Universities of Wisconsin</span></a></div> </div> </div> <div class="uw-copyright"> <p>Website feedback, questions or accessibility issues: <a id="uw-website-issues-contact" href="mailto:sts@doit.wisc.edu">sts@doit.wisc.edu</a> | Learn more about <a href="https://accessible.wisc.edu/">accessibility at UW–Madison</a>.</p> <p>This site was built using <a href="https://uwtheme.brand.wisc.edu/">UW Theme 2.0</a> | <a href="https://www.wisc.edu/privacy-notice/">Privacy Notice</a> | © 2026 Board of Regents of the <a href="https://www.wisconsin.edu">University of Wisconsin System</a>.</p> </div> </div> </footer> <script type="speculationrules"> {"prefetch":[{"source":"document","where":{"and":[{"href_matches":"/training-materials/*"},{"not":{"href_matches":["/training-materials/wp-*.php","/training-materials/wp-admin/*","/training-materials/wp-content/uploads/*","/training-materials/wp-content/*","/training-materials/wp-content/plugins/*","/training-materials/wp-content/themes/uw-theme-gutenberg-child/*","/training-materials/*\\?(.+)"]}},{"not":{"selector_matches":"a[rel~=\"nofollow\"]"}},{"not":{"selector_matches":".no-prefetch, .no-prefetch a"}}]},"eagerness":"conservative"}]} </script> <script id="sts-misc-js" src="https://sts.doit.wisc.edu/training-materials/wp-content/plugins/sts-toolbox-manuals-prod/js/sts-misc.js"></script> <script id="sts-tablesorter-js" src="https://sts.doit.wisc.edu/training-materials/wp-content/plugins/sts-toolbox-manuals-prod/js/jquery.tablesorter.js"></script> <script id="wp-dom-ready-js" src="https://sts.doit.wisc.edu/training-materials/wp-includes/js/dist/dom-ready.min.js?ver=3fe927cab37bf38d6a23"></script> <script id="uw-theme-script-js" src="https://sts.doit.wisc.edu/training-materials/wp-content/themes/uw-theme-gutenberg-child/build/js/theme.js?ver=dd678bc7b2724245efd3"></script> <script id="admin_enqueue_scripts-js" src="https://sts.doit.wisc.edu/training-materials/wp-content/themes/uw-theme-gutenberg-child/sts/js/sts-main.js?ver=1.0.0"></script> <script id="wp_enqueue_scripts-js" src="https://sts.doit.wisc.edu/training-materials/wp-content/themes/uw-theme-gutenberg-child/sts/js/smooth-scroll.js?ver=1.0.0"></script> <script data-wp-strategy="defer" defer id="sts-block-sts-custom-sections-view-script-js" src="https://sts.doit.wisc.edu/training-materials/wp-content/plugins/sts-custom-sections/build/sts-custom-sections/view.js?ver=c9d98f88db95489cd1b5"></script> <script id="wp-emoji-settings" type="application/json"> {"baseUrl":"https://s.w.org/images/core/emoji/17.0.2/72x72/","ext":".png","svgUrl":"https://s.w.org/images/core/emoji/17.0.2/svg/","svgExt":".svg","source":{"concatemoji":"https://sts.doit.wisc.edu/training-materials/wp-includes/js/wp-emoji-release.min.js?ver=7.1.2"}} </script> <script type="module"> /*! This file is auto-generated */ var e="script#wp-emoji-settings",t=document.querySelector(e);if(!(t instanceof HTMLScriptElement))throw new Error("Element missing: "+e);const r=JSON.parse(t.text),s=(window._wpemojiSettings=r,"wpEmojiSettingsSupports"),o=["flag","emoji"];function i(e){try{var t={supportTests:e,timestamp:(new Date).valueOf()};sessionStorage.setItem(s,JSON.stringify(t))}catch(e){}}function c(e,t,n){e.clearRect(0,0,e.canvas.width,e.canvas.height),e.fillText(t,0,0);t=new Uint32Array(e.getImageData(0,0,e.canvas.width,e.canvas.height).data);e.clearRect(0,0,e.canvas.width,e.canvas.height),e.fillText(n,0,0);const r=new Uint32Array(e.getImageData(0,0,e.canvas.width,e.canvas.height).data);return t.every((e,t)=>e===r[t])}function p(e,t){e.clearRect(0,0,e.canvas.width,e.canvas.height),e.fillText(t,0,0);var n=e.getImageData(16,16,1,1);for(let e=0;e<n.data.length;e++)if(0!==n.data[e])return!1;return!0}function u(e,t,n,r){switch(t){case"flag":return n(e,"\ud83c\udff3\ufe0f\u200d\u26a7\ufe0f","\ud83c\udff3\ufe0f\u200b\u26a7\ufe0f")?!1:!n(e,"\ud83c\udde8\ud83c\uddf6","\ud83c\udde8\u200b\ud83c\uddf6")&&!n(e,"\ud83c\udff4\udb40\udc67\udb40\udc62\udb40\udc65\udb40\udc6e\udb40\udc67\udb40\udc7f","\ud83c\udff4\u200b\udb40\udc67\u200b\udb40\udc62\u200b\udb40\udc65\u200b\udb40\udc6e\u200b\udb40\udc67\u200b\udb40\udc7f");case"emoji":return!r(e,"\ud83e\u1fac8")}return!1}function f(e,t,n,r){let a;const s=(a="undefined"!=typeof WorkerGlobalScope&&self instanceof WorkerGlobalScope?new OffscreenCanvas(300,150):document.createElement("canvas")).getContext("2d",{willReadFrequently:!0}),o=(s.textBaseline="top",s.font="600 32px Arial",{});return e.forEach(e=>{o[e]=t(s,e,n,r)}),o}function a(e){var t=document.createElement("script");t.src=e,t.defer=!0,document.head.appendChild(t)}r.supports={everything:!0,everythingExceptFlag:!0},new Promise(t=>{let n=function(){try{var e=JSON.parse(sessionStorage.getItem(s));if("object"==typeof e&&"number"==typeof e.timestamp&&(new Date).valueOf()<e.timestamp+604800&&"object"==typeof e.supportTests)return e.supportTests}catch(e){}return null}();if(!n){if("undefined"!=typeof Worker&&"undefined"!=typeof OffscreenCanvas&&"undefined"!=typeof URL&&URL.createObjectURL&&"undefined"!=typeof Blob)try{var e="postMessage("+f.toString()+"("+[JSON.stringify(o),u.toString(),c.toString(),p.toString()].join(",")+"));",r=new Blob([e],{type:"text/javascript"});const a=new Worker(URL.createObjectURL(r),{name:"wpTestEmojiSupports"});return void(a.onmessage=e=>{i(n=e.data),a.terminate(),t(n)})}catch(e){}i(n=f(o,u,c,p))}t(n)}).then(e=>{for(const n in e)r.supports[n]=e[n],r.supports.everything=r.supports.everything&&r.supports[n],"flag"!==n&&(r.supports.everythingExceptFlag=r.supports.everythingExceptFlag&&r.supports[n]);var t;r.supports.everythingExceptFlag=r.supports.everythingExceptFlag&&!r.supports.flag,r.supports.everything||((t=r.source||{}).concatemoji?a(t.concatemoji):t.wpemoji&&t.twemoji&&(a(t.twemoji),a(t.wpemoji)))}); //# sourceURL=https://sts.doit.wisc.edu/training-materials/wp-includes/js/wp-emoji-loader.min.js </script> </body> </html>
