1<!DOCTYPE html> 2<html lang="en-US" class="no-js"> 3<head> 4 <meta charset="UTF-8"> 5 <meta name="viewport" content="width=device-width, initial-scale=1.0"> 6 <link rel="profile" href="https://gmpg.org/xfn/11"> 7 <link rel="pingback" href="https://www.benlcollins.com/xmlrpc.php"> 8
8<script> 9(function(html){html.className = html.className.replace(/\bno-js\b/,'js')})(document.documentElement); 10//# sourceURL=twentyfifteen_javascript_detection 11</script>
11 12<meta name='robots' content='index, follow, max-image-preview:large, max-snippet:-1, max-video-preview:-1' /> 13 14 <!-- This site is optimized with the Yoast SEO plugin v28.5 - https://yoast.com/product/yoast-seo-wordpress/ --> 15 <title>Google Sheets and Apps Script Tutorials and Online Courses</title> 16<link data-rocket-prefetch href="https://cdn.usefathom.com" rel="dns-prefetch"> 17<link data-rocket-prefetch href="https://js.sparkloop.app" rel="dns-prefetch"><link rel="preload" data-rocket-preload as="image" href="https://www.benlcollins.com/wp-content/uploads/2026/03/courseIcon3.jpg" fetchpriority="high"> 18 <meta name="description" content="Beginner to advanced tutorials covering Google Sheets, Apps Script, data analysis, automation and APIs. Learn new skills today!" /> 19 <link rel="canonical" href="https://www.benlcollins.com/" /> 20 <meta property="og:locale" content="en_US" /> 21 <meta property="og:type" content="website" /> 22 <meta property="og:title" content="Google Sheets and Apps Script Tutorials and Online Courses" /> 23 <meta property="og:description" content="Beginner to advanced tutorials covering Google Sheets, Apps Script, data analysis, automation and APIs. Learn new skills today!" /> 24 <meta property="og:url" content="https://www.benlcollins.com/" /> 25 <meta property="article:modified_time" content="2026-09-14T15:39:34+00:00" /> 26 <meta property="og:image" content="https://www.benlcollins.com/wp-content/uploads/2026/03/courseIcon3.jpg" /> 27 <meta name="twitter:card" content="summary_large_image" /> 28
28<script type="application/ld+json" class="yoast-schema-graph">{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.benlcollins.com\/","url":"https:\/\/www.benlcollins.com\/","name":"Google Sheets and Apps Script Tutorials and Online Courses","isPartOf":{"@id":"https:\/\/www.benlcollins.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.benlcollins.com\/#primaryimage"},"image":{"@id":"https:\/\/www.benlcollins.com\/#primaryimage"},"thumbnailUrl":"https:\/\/www.benlcollins.com\/wp-content\/uploads\/2026\/03\/courseIcon3.jpg","datePublished":"2017-10-11T16:58:45+00:00","dateModified":"2026-09-14T15:39:34+00:00","description":"Beginner to advanced tutorials covering Google Sheets, Apps Script, data analysis, automation and APIs. Learn new skills today!","breadcrumb":{"@id":"https:\/\/www.benlcollins.com\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.benlcollins.com\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.benlcollins.com\/#primaryimage","url":"https:\/\/www.benlcollins.com\/wp-content\/uploads\/2026\/03\/courseIcon3.jpg","contentUrl":"https:\/\/www.benlcollins.com\/wp-content\/uploads\/2026\/03\/courseIcon3.jpg","width":2726,"height":1533,"caption":"28 Days to Gemini Mastery Course"},{"@type":"BreadcrumbList","@id":"https:\/\/www.benlcollins.com\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home"}]},{"@type":"WebSite","@id":"https:\/\/www.benlcollins.com\/#website","url":"https:\/\/www.benlcollins.com\/","name":"","description":"Educator and Google Developer Expert. Helping you navigate the world of spreadsheets & AI.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.benlcollins.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}</script>
28 29 <!-- / Yoast SEO plugin. --> 30 31 32<link rel='dns-prefetch' href='//cdn.usefathom.com' /> 33 34<link rel="alternate" type="application/rss+xml" title=" » Feed" href="https://www.benlcollins.com/feed/" /> 35<link rel="alternate" type="application/rss+xml" title=" » Comments Feed" href="https://www.benlcollins.com/comments/feed/" /> 36<link rel="alternate" title="oEmbed (JSON)" type="application/json+oembed" href="https://www.benlcollins.com/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fwww.benlcollins.com%2F" /> 37<link rel="alternate" title="oEmbed (XML)" type="text/xml+oembed" href="https://www.benlcollins.com/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fwww.benlcollins.com%2F&format=xml" /> 38<style id="wp-img-auto-sizes-contain-inline-css"> 39img:is([sizes=auto i],[sizes^="auto," i]){contain-intrinsic-size:3000px 1500px} 40/*# sourceURL=wp-img-auto-sizes-contain-inline-css */ 41</style> 42<style id="wp-emoji-styles-inline-css"> 43 44 img.wp-smiley, img.emoji { 45 display: inline !important; 46 border: none !important; 47 box-shadow: none !important; 48 height: 1em !important; 49 width: 1em !important; 50 margin: 0 0.07em !important; 51 vertical-align: -0.1em !important; 52 background: none !important; 53 padding: 0 !important; 54 } 55/*# sourceURL=wp-emoji-styles-inline-css */ 56</style> 57<style id="wp-block-library-inline-css"> 58:root{--wp-block-synced-color:#7a00df;--wp-block-synced-color--rgb:122,0,223;--wp-bound-block-color:var(--wp-block-synced-color);--wp-editor-canvas-background:#ddd;--wp-admin-theme-color:#007cba;--wp-admin-theme-color--rgb:0,124,186;--wp-admin-theme-color-darker-10:#006ba1;--wp-admin-theme-color-darker-10--rgb:0,107,160.5;--wp-admin-theme-color-darker-20:#005a87;--wp-admin-theme-color-darker-20--rgb:0,90,135;--wp-admin-border-width-focus:2px}@media (min-resolution:192dpi){:root{--wp-admin-border-width-focus:1.5px}}.wp-element-button{cursor:pointer}:root .has-very-light-gray-background-color{background-color:#eee}:root .has-very-dark-gray-background-color{background-color:#313131}:root .has-very-light-gray-color{color:#eee}:root .has-very-dark-gray-color{color:#313131}:root .has-vivid-green-cyan-to-vivid-cyan-blue-gradient-background{background:linear-gradient(135deg,#00d084,#0693e3)}:root .has-purple-crush-gradient-background{background:linear-gradient(135deg,#34e2e4,#4721fb 50%,#ab1dfe)}:root .has-hazy-dawn-gradient-background{background:linear-gradient(135deg,#faaca8,#dad0ec)}:root .has-subdued-olive-gradient-background{background:linear-gradient(135deg,#fafae1,#67a671)}:root .has-atomic-cream-gradient-background{background:linear-gradient(135deg,#fdd79a,#004a59)}:root .has-nightshade-gradient-background{background:linear-gradient(135deg,#330968,#31cdcf)}:root .has-midnight-gradient-background{background:linear-gradient(135deg,#020381,#2874fc)}:root{--wp--preset--font-size--normal:16px;
58--wp--preset--font-size--huge:42px}.has-regular-font-size{font-size:1em}.has-larger-font-size{font-size:2.625em}.has-normal-font-size{font-size:var(--wp--preset--font-size--normal)}.has-huge-font-size{font-size:var(--wp--preset--font-size--huge)}:root .has-text-align-center{text-align:center}:root .has-text-align-left{text-align:left}:root .has-text-align-right{text-align:right}.has-fit-text{white-space:nowrap!important}#end-resizable-editor-section{display:none}.aligncenter{clear:both}.items-justified-left{justify-content:flex-start}.items-justified-center{justify-content:center}.items-justified-right{justify-content:flex-end}.items-justified-space-between{justify-content:space-between}.screen-reader-text{word-wrap:normal!important;border:0;clip-path:inset(50%);height:1px;margin:-1px;overflow:hidden;padding:0;position:absolute;width:1px;word-break:normal!important}.screen-reader-text:focus{background-color:#ddd;clip-path:none;color:#444;display:block;font-size:1em;height:auto;left:5px;line-height:normal;padding:15px 23px 14px;text-decoration:none;top:5px;width:auto;z-index:100000}html :where(.has-border-color){border-style:solid}html :where([style^=border-color],[style*=";border-color"],[style*="; border-color"]){border-style:solid}html :where([style^=border-top-color],[style*=";border-top-color"],[style*="; border-top-color"]){border-top-style:solid}html :where([style^=border-right-color],[style*=";border-right-color"],[style*="; border-right-color"]){border-right-style:solid}html :where([style^=border-bottom-color],[style*=";border-bottom-color"],[style*="; border-bottom-color"]){border-bottom-style:solid}html :where([style^=border-left-color],[style*=";border-left-color"],[style*="; border-left-color"]){border-left-style:solid}html :where([style^=border-width],[style*=";border-width"],[style*="; border-width"]){border-style:solid}html :where([style^=border-top-width],[style*=";border-top-width"],[style*="; border-top-width"]){border-top-style:solid}html :where([style^=border-right-width],[style*=";border-right-width"],[style*="; border-right-width"]){border-right-style:solid}html :where([style^=border-bottom-width],[style*=";border-bottom-width"],[style*="; border-bottom-width"]){border-bottom-style:solid}html :where([style^=border-left-width],[style*=";border-left-width"],[style*="; border-left-width"]){border-left-style:solid}html :where(img[class*=wp-image-]){height:auto;max-width:100%}:where(figure){margin:0 0 1em}html :where(.is-position-sticky){--wp-admin--admin-bar--position-offset:var(--wp-admin--admin-bar--height,0px)}@media screen and (max-width:600px){html :where(.is-position-sticky){--wp-admin--admin-bar--position-offset:0px}} 59 60/*# sourceURL=/wp-includes/css/dist/block-library/common.min.css */ 61</style> 62<style id="wp-block-heading-inline-css"> 63h1:where(.wp-block-heading).has-background,h2:where(.wp-block-heading).has-background,h3:where(.wp-block-heading).has-background,h4:where(.wp-block-heading).has-background,h5:where(.wp-block-heading).has-background,h6:where(.wp-block-heading).has-background{padding:1.25em 2.375em}h1.has-text-align-left[style*=writing-mode]:where([style*=vertical-lr]),h1.has-text-align-right[style*=writing-mode]:where([style*=vertical-rl]),h2.has-text-align-left[style*=writing-mode]:where([style*=vertical-lr]),h2.has-text-align-right[style*=writing-mode]:where([style*=vertical-rl]),h3.has-text-align-left[style*=writing-mode]:where([style*=vertical-lr]),h3.has-text-align-right[style*=writing-mode]:where([style*=vertical-rl]),h4.has-text-align-left[style*=writing-mode]:where([style*=vertical-lr]),h4.has-text-align-right[style*=writing-mode]:where([style*=vertical-rl]),h5.has-text-align-left[style*=writing-mode]:where([style*=vertical-lr]),h5.has-text-align-right[style*=writing-mode]:where([style*=vertical-rl]),h6.has-text-align-left[style*=writing-mode]:where([style*=vertical-lr]),h6.has-text-align-right[style*=writing-mode]:where([style*=vertical-rl]){rotate:180deg} 64/*# sourceURL=https://www.benlcollins.com/wp-includes/blocks/heading/style.min.css */ 65</style> 66<style id="wp-block-latest-posts-inline-css"> 67.wp-block-latest-posts{box-sizing:border-box}.wp-block-latest-posts.alignleft{margin-right:2em}.wp-block-latest-posts.alignright{margin-left:2em}.wp-block-latest-posts.wp-block-latest-posts__list{list-style:none}.wp-block-latest-posts.wp-block-latest-posts__list li{clear:both;overflow-wrap:break-word}.wp-block-latest-posts.is-grid:not(.is-layout-grid){display:flex;flex-wrap:wrap}.wp-block-latest-posts.is-grid:not(.is-layout-grid) li{margin:0 1.25em 1.25em 0;width:100%}@media (min-width:600px){.wp-block-latest-posts.columns-2:not(.is-layout-grid) li{width:calc(50% - .625em)}.wp-block-latest-posts.columns-2:not(.is-layout-grid) li:nth-child(2n){margin-right:0}.wp-block-latest-posts.columns-3:not(.is-layout-grid) li{width:calc(33.33333% - .83333em)}.wp-block-latest-posts.columns-3:not(.is-layout-grid) li:nth-child(3n){margin-right:0}.wp-block-latest-posts.columns-4:not(.is-layout-grid) li{width:calc(25% - .9375em)}.wp-block-latest-posts.columns-4:not(.is-layout-grid) li:nth-child(4n){margin-right:0}.wp-block-latest-posts.columns-5:not(.is-layout-grid) li{width:calc(20% - 1em)}.wp-block-latest-posts.columns-5:not(.is-layout-grid) li:nth-child(5n){margin-right:0}.wp-block-latest-posts.columns-6:not(.is-layout-grid) li{width:calc(16.66667% - 1.04167em)}.wp-block-latest-posts.columns-6:not(.is-layout-grid) li:nth-child(6n){margin-right:0}}@media (max-width:600px){.wp-block-latest-posts-is-layout-grid[class*=columns-]:not
67(.has-native-responsive-grid){grid-template-columns:1fr}}:root :where(.wp-block-latest-posts.is-grid){padding:0}:root :where(.wp-block-latest-posts.wp-block-latest-posts__list){padding-left:0}.wp-block-latest-posts__post-author,.wp-block-latest-posts__post-date{display:block;font-size:.8125em}.wp-block-latest-posts__post-excerpt,.wp-block-latest-posts__post-full-content{margin-bottom:1em;margin-top:.5em}.wp-block-latest-posts__featured-image a{display:inline-block}.wp-block-latest-posts__featured-image img{height:auto;max-width:100%;width:auto}.wp-block-latest-posts__featured-image.alignleft{float:left;margin-right:1em}.wp-block-latest-posts__featured-image.alignright{float:right;margin-left:1em}.wp-block-latest-posts__featured-image.aligncenter{margin-bottom:1em;text-align:center} 68/*# sourceURL=https://www.benlcollins.com/wp-includes/blocks/latest-posts/style.min.css */ 69</style> 70<style id="wp-block-paragraph-inline-css"> 71.is-small-text{font-size:.875em}.is-regular-text{font-size:1em}.is-large-text{font-size:2.25em}.is-larger-text{font-size:3em}.has-drop-cap:not(:focus):first-letter{float:left;font-size:8.4em;font-style:normal;font-weight:100;line-height:.68;margin:.05em .1em 0 0;text-transform:uppercase}body.rtl .has-drop-cap:not(:focus):first-letter{float:none;margin-left:.1em}p.has-drop-cap.has-background{overflow:hidden}:root :where(p.has-background){padding:1.25em 2.375em}:where(p.has-text-color:not(.has-link-color)) a{color:inherit}p.has-text-align-left[style*="writing-mode:vertical-lr"],p.has-text-align-right[style*="writing-mode:vertical-rl"]{rotate:180deg} 72/*# sourceURL=https://www.benlcollins.com/wp-includes/blocks/paragraph/style.min.css */ 73</style> 74<style id="wp-block-separator-inline-css"> 75@charset "UTF-8";.wp-block-separator{border:none;border-top:2px solid}:root :where(.wp-block-separator.is-style-dots){height:auto;line-height:1;text-align:center}:root :where(.wp-block-separator.is-style-dots):before{color:currentColor;content:"···";font-family:serif;font-size:1.5em;letter-spacing:2em;padding-left:2em}.wp-block-separator.is-style-dots{background:none!important;border:none!important} 76/*# sourceURL=https://www.benlcollins.com/wp-includes/blocks/separator/style.min.css */ 77</style> 78<style id="wp-block-separator-theme-inline-css"> 79.wp-block-separator.has-css-opacity{opacity:.4}.wp-block-separator{border:none;border-bottom:2px solid;margin-left:auto;margin-right:auto}.wp-block-separator.has-alpha-channel-opacity{opacity:1}.wp-block-separator:not(.is-style-wide):not(.is-style-dots){width:100px}.wp-block-separator.has-background:not(.is-style-dots){border-bottom:none;height:1px}.wp-block-separator.has-background:not(.is-style-wide):not(.is-style-dots){height:2px} 80/*# sourceURL=https://www.benlcollins.com/wp-includes/blocks/separator/theme.min.css */ 81</style> 82 83<style id="classic-theme-styles-inline-css"> 84/*! This file is auto-generated */ 85.wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} 86/*# sourceURL=/wp-includes/css/classic-themes.min.css */ 87</style> 88 89<link rel='stylesheet' id='convertkit-frontend-css' href='https://www.benlcollins.com/wp-content/plugins/convertkit/resources/frontend/css/frontend.css?ver=3.4.1' media='all' /> 90<style id="wp-block-button-inline-css"> 91.wp-block-button__link{align-content:center;box-sizing:border-box;cursor:pointer;display:inline-block;height:100%;text-align:center;word-break:break-word}.wp-block-button__link.aligncenter{text-align:center}.wp-block-button__link.alignright{text-align:right}:where(.wp-block-button__link){border-radius:9999px;box-shadow:none;padding:calc(.667em + 2px) calc(1.333em + 2px);text-decoration:none}.wp-block-button[style*=text-decoration] .wp-block-button__link{text-decoration:inherit}.wp-block-buttons>.wp-block-button.has-custom-width{max-width:none}.wp-block-buttons>.wp-block-button.has-custom-width .wp-block-button__link{width:100%}.wp-block-buttons>.wp-block-button.has-custom-font-size .wp-block-button__link{font-size:inherit}.wp-block-buttons>.wp-block-button[class*=wp-block-button__width]{width:calc(var(--wp--block-button--width)*1% - var(--wp--style--block-gap, .5em)*(1 - var(--wp--block-button--width)/100))}.wp-block-buttons>.wp-block-button.wp-block-button__width-25{width:calc(25% - var(--wp--style--block-gap, .5em)*.75)}.wp-block-buttons>.wp-block-button.wp-block-button__width-50{width:calc(50% - var(--wp--style--block-gap, .5em)*.5)}.wp-block-buttons>.wp-block-button.wp-block-button__width-75{width:calc(75% - var(--wp--style--block-gap, .5em)*.25)}.wp-block-buttons>.wp-block-button.wp-block-button__width-100{flex-basis:100%;width:100%}.wp-block-buttons.is-vertical>.wp-block-button[class*=wp-block-button__width]{width:calc(var(--wp--block-button--width)*1%)}.wp-block-buttons.is-vertical>.wp-block-button.wp-block-button__width-25{width:25%}.wp-block-buttons.is-vertical>.wp-block-button.wp-block-button__width-50{width:50%}.wp-block-buttons.is-vertical>.wp-block-button.wp-block-button__width-75{width:75%}.wp-block-button.is-style-squared,.wp-block-button__link.wp-block-button.is-style-squared{border-radius:0}.wp-block-button.no-border-radius,.wp-block-button__link.no-border-radius{border-radius:0!important}:root :where(.wp-block-button .wp-block-button__link.is-style-outline),:root :where(.wp-block-button.is-style-outline>.wp-block-button__link){border:2px solid;padding:.667em 1.333em}:root :where(.wp-block-button .wp-block-button__link.is-style-outline:not(.has-text-color)),:root :where(.wp-block-button.is-style-outline>.wp-block-button__link:not(.has-text-color)){color:currentColor}:root :where(.wp-block-button .wp-block-button__link.is-style-outline:not(.has-background)),:root :where(.wp-block-button.is-style-outline>.wp-block-button__link:not(.has-background)){background-color:transparent;background-image:none} 92/*# sourceURL=https://www.benlcollins.com/wp-includes/blocks/button/style.min.css */ 93</style> 94<style id="global-styles-inline-css"> 95:root{--wp--preset--aspect-ratio--square: 1;--wp--preset--aspect-ratio--4-3: 4/3;--wp--preset--aspect-ratio--3-4: 3/4;--wp--preset--aspect-ratio--3-2: 3/2;--wp--preset--aspect-ratio--2-3: 2/3;--wp--preset--aspect-ratio--16-9: 16/9;--wp--preset--aspect-ratio--9-16: 9/16;--wp--preset--color--black: #000000;--wp--preset--color--cyan-bluish-gray: #abb8c3;--wp--preset--color--white: #fff;--wp--preset--color--pale-pink: #f78da7;--wp--preset--color--vivid-red: #cf2e2e;--wp--preset--color--luminous-vivid-orange: #ff6900;--wp--preset--color--luminous-vivid-amber: #fcb900;--wp--preset--color--light-green-cyan: #7bdcb5;--wp--preset--color--vivid-green-cyan: #00d084;--wp--preset--color--pale-cyan-blue: #8ed1fc;--wp--preset--color--vivid-cyan-blue: #0693e3;--wp--preset--color--vivid-purple: #9b51e0;--wp--preset--color--dark-gray: #111;--wp--preset--color--light-gray: #f1f1f1;--wp--preset--color--yellow: #f4ca16;--wp--preset--color--dark-brown: #352712;--wp--preset--color--medium-pink: #e53b51;--wp--preset--color--light-pink: #ffe5d1;--wp--preset--color--dark-purple: #2e2256;--wp--preset--color--purple: #674970;--wp--preset--color--blue-gray: #22313f;--wp--preset--color--bright-blue: #55c3dc;--wp--preset--color--light-blue: #e9f2f9;--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple: linear-gradient(135deg,rgb(6,147,227) 0%,rgb(155,81,224) 100%);--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan: linear-gradient(135deg,rgb(122,220,180) 0%,rgb(0,208,130) 100%);--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange: linear-gradient(135deg,rgb(252,185,
950) 0%,rgb(255,105,0) 100%);--wp--preset--gradient--luminous-vivid-orange-to-vivid-red: linear-gradient(135deg,rgb(255,105,0) 0%,rgb(207,46,46) 100%);--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray: linear-gradient(135deg,rgb(238,238,238) 0%,rgb(169,184,195) 100%);--wp--preset--gradient--cool-to-warm-spectrum: linear-gradient(135deg,rgb(74,234,220) 0%,rgb(151,120,209) 20%,rgb(207,42,186) 40%,rgb(238,44,130) 60%,rgb(251,105,98) 80%,rgb(254,248,76) 100%);--wp--preset--gradient--blush-light-purple: linear-gradient(135deg,rgb(255,206,236) 0%,rgb(152,150,240) 100%);--wp--preset--gradient--blush-bordeaux: linear-gradient(135deg,rgb(254,205,165) 0%,rgb(254,45,45) 50%,rgb(107,0,62) 100%);--wp--preset--gradient--luminous-dusk: linear-gradient(135deg,rgb(255,203,112) 0%,rgb(199,81,192) 50%,rgb(65,88,208) 100%);--wp--preset--gradient--pale-ocean: linear-gradient(135deg,rgb(255,245,203) 0%,rgb(182,227,212) 50%,rgb(51,167,181) 100%);--wp--preset--gradient--electric-grass: linear-gradient(135deg,rgb(202,248,128) 0%,rgb(113,206,126) 100%);--wp--preset--gradient--midnight: linear-gradient(135deg,rgb(2,3,129) 0%,rgb(40,116,252) 100%);--wp--preset--gradient--dark-gray-gradient-gradient: linear-gradient(90deg, rgba(17,17,17,1) 0%, rgba(42,42,42,1) 100%);--wp--preset--gradient--light-gray-gradient: linear-gradient(90deg, rgba(241,241,241,1) 0%, rgba(215,215,215,1) 100%);--wp--preset--gradient--white-gradient: linear-gradient(90deg, rgba(255,255,255,1) 0%, rgba(230,230,230,1) 100%);--wp--preset--gradient--yellow-gradient: linear-gradient(90deg, rgba(244,202,22,1) 0%, rgba(205,168,10,1) 100%);--wp--preset--gradient--dark-brown-gradient: linear-gradient(90deg, rgba(53,39,18,1) 0%, rgba(91,67,31,1) 100%);--wp--preset--gradient--medium-pink-gradient: linear-gradient(90deg, rgba(229,59,81,1) 0%, rgba(209,28,51,1) 100%);--wp--preset--gradient--light-pink-gradient: linear-gradient(90deg, rgba(255,229,209,1) 0%, rgba(255,200,158,1) 100%);--wp--preset--gradient--dark-purple-gradient: linear-gradient(90deg, rgba(46,34,86,1) 0%, rgba(66,48,123,1) 100%);--wp--preset--gradient--purple-gradient: linear-gradient(90deg, rgba(103,73,112,1) 0%, rgba(131,93,143,1) 100%);--wp--preset--gradient--blue-gray-gradient: linear-gradient(90deg, rgba(34,49,63,1) 0%, rgba(52,75,96,1) 100%);--wp--preset--gradient--bright-blue-gradient: linear-gradient(90deg, rgba(85,195,220,1) 0%, rgba(43,180,211,1) 100%);--wp--preset--gradient--light-blue-gradient: linear-gradient(90deg, rgba(233,242,249,1) 0%, rgba(193,218,238,1) 100%);--wp--preset--font-size--small: 13px;--wp--preset--font-size--medium: 20px;--wp--preset--font-size--large: 36px;--wp--preset--font-size--x-large: 42px;--wp--preset--spacing--20: 0.44rem;--wp--preset--spacing--30: 0.67rem;--wp--preset--spacing--40: 1rem;--wp--preset--spacing--50: 1.5rem;--wp--preset--spacing--60: 2.25rem;--wp--preset--spacing--70: 3.38rem;--wp--preset--spacing--80: 5.06rem;--wp--preset--shadow--natural: 6px 6px 9px rgba(0, 0, 0, 0.2);--wp--preset--shadow--deep: 12px 12px 50px rgba(0, 0, 0, 0.4);--wp--preset--shadow--sharp: 6px 6px 0px rgba(0, 0, 0, 0.2);--wp--preset--shadow--outlined: 6px 6px 0px -3px rgb(255, 255, 255), 6px 6px rgb(0, 0, 0);--wp--preset--shadow--crisp: 6px 6px 0px rgb(0, 0, 0);}.wp-block-button{--wp--preset--dimension--25: 25%;--wp--preset--dimension--50: 50%;--wp--preset--dimension--75: 75%;--wp--preset--dimension--100: 100%;}:where(body) { margin: 0; }:where(.is-layout-flex){gap: 0.5em;}:where(.is-layout-grid){gap: 0.5em;}body .is-layout-flex{display: flex;}.is-layout-flex{flex-wrap: wrap;align-items: center;}.is-layout-flex > :is(*, div){margin: 0;}body .is-layout-grid{display: grid;}.is-layout-grid > :is(*, div){margin: 0;}body{padding-top: 0px;padding-right: 0px;padding-bottom: 0px;padding-left: 0px;}:root :where(.wp-element-button, .wp-block-button__link){background-color: #32373c;border-width: 0;color: #fff;font-family: inherit;font-size: inherit;font-style: inherit;font-weight: inherit;letter-spacing: inherit;line-height: inherit;padding-top: calc(0.667em + 2px);padding-right: calc(1.333em + 2px);padding-bottom: calc(0.667em + 2px);padding-left: calc(1.333em + 2px);text-decoration: none;text-transform: inherit;}.has-black-color{color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-color{color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-color{color: var(--wp--preset--color--white) !important;}.has-pale-pink-color{color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-color{color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-color{color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-color{color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-color{color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-color{color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-color{color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-color{color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-color{color: var(--wp--preset--color--vivid-purple) !important;}.has-dark-gray-color{color: var(--wp--preset--color--dark-gray) !important;}.has-light-gray-color{color: var(--wp--preset--color--light-gray) !important;}.has-yellow-color{color: var(--wp--preset--color--yellow) !important;}.has-dark-brown-color{color: var(--wp--preset--color--dark-brown) !important;}.has-medium-pink-color{color: var(--wp--preset--color--medium-pink) !important;}.has-light-pink-color{color: var(--wp--preset--color--light-pink) !important;}.has-dark-purple-color{color: var(--wp--preset--color--dark-purple) !important;}.has-purple-color{color: var(--wp--preset--color--purple) !important;}.has-blue-gray-color{color: var(--wp--preset--color--blue-gray) !important;}.has-bright-blue-color{color: var(--wp--preset--color--bright-blue) !important;}.has-light-blue-color{color: var(--wp--preset--color--light-blue) !important;}.has-black-background-color{background-color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-background-color{background-color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-background-color{background-color: var(--wp--preset--color--white) !important;}.has-pale-pink-background-color{background-color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-background-color{background-color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-background-color{background-color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-background-color{background-color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-background-color{background-color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-background-color{background-color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-background-color{background-color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-background-color{background-color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-background-color{background-color: var(--wp--preset--color--vivid-purple) !important;}.has-dark-gray-background-color{background-color: var(--wp--preset--color--dark-gray) !important;}.has-light-gray-background-color{background-color: var(--wp--preset--color--light-gray) !important;}.has-yellow-background-color{background-color: var(--wp--preset--color--yellow) !important;}.has-dark-brown-background-color{background-color: var(--wp--preset--color--dark-brown) !important;}.has-medium-pink-background-color{background-color: var(--wp--preset--color--medium-pink) !important;}.has-light-pink-background-color{background-color: var(--wp--preset--color--light-pink) !important;}.has-dark-purple-background-color{background-color: var(--wp--preset--color--dark-purple) !important;}.has-purple-background-color{background-color: var(--wp--preset--color--purple) !important;}.has-blue-gray-background-color{background-color: var(--wp--preset--color--blue-gray) !important;}.has-bright-blue-background-color{background-color: var(--wp--preset--color--bright-blue) !important;}.has-light-blue-background-color{background-color: var(--wp--preset--color--light-blue) !important;}.has-black-border-color{border-color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-border-color{border-color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-border-color{border-color: var(--wp--preset--color--white) !important;}.has-pale-pink-border-color{border-color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-border-color{border-color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-border-color{border-color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-border-color{border-color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-border-color{border-color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-border-color{border-color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-border-color{border-color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-border-color{border-color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-border-color{border-color: var(--wp--preset--color--vivid-purple) !important;}.has-dark-gray-border-color{border-color: var(--wp--preset--color--dark-gray) !important;}.has-light-gray-border-color{border-color: var(--wp--preset--color--light-gray) !important;}.has-yellow-border-color{border-color: var(--wp--preset--color--yellow) !important;}.has-dark-brown-border-color{border-color: var(--wp--preset--color--dark-brown) !important;}.has-medium-pink-border-color{border-color: var(--wp--preset--color--medium-pink) !important;}.has-light-pink-border-color{border-color: var(--wp--preset--color--light-pink) !important;}.has-dark-purple-border-color{border-color: var(--wp--preset--color--dark-purple) !important;}.has-purple-border-color{border-color: var(--wp--preset--color--purple) !important;}.has-blue-gray-border-color{border-color: var(--wp--preset--color--blue-gray) !important;}.has-bright-blue-border-color{border-color: var(--wp--preset--color--bright-blue) !important;}.has-light-blue-border-color{border-color: var(--wp--preset--color--light-blue) !important;}.has-vivid-cyan-blue-to-vivid-purple-gradient-background{background: var(--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple) !important;}.has-light-green-cyan-to-vivid-green-cyan-gradient-background{background: var(--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan) !important;}.has-luminous-vivid-amber-to-luminous-vivid-orange-gradient-background{background: var(--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange) !important;}.has-luminous-vivid-orange-to-vivid-red-gradient-background{background: var(--wp--preset--gradient--luminous-vivid-orange-to-vivid-red) !important;}
95.has-very-light-gray-to-cyan-bluish-gray-gradient-background{background: var(--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray) !important;}.has-cool-to-warm-spectrum-gradient-background{background: var(--wp--preset--gradient--cool-to-warm-spectrum) !important;}.has-blush-light-purple-gradient-background{background: var(--wp--preset--gradient--blush-light-purple) !important;}.has-blush-bordeaux-gradient-background{background: var(--wp--preset--gradient--blush-bordeaux) !important;}.has-luminous-dusk-gradient-background{background: var(--wp--preset--gradient--luminous-dusk) !important;}.has-pale-ocean-gradient-background{background: var(--wp--preset--gradient--pale-ocean) !important;}.has-electric-grass-gradient-background{background: var(--wp--preset--gradient--electric-grass) !important;}.has-midnight-gradient-background{background: var(--wp--preset--gradient--midnight) !important;}.has-dark-gray-gradient-gradient-gradient-background{background: var(--wp--preset--gradient--dark-gray-gradient-gradient) !important;}.has-light-gray-gradient-gradient-background{background: var(--wp--preset--gradient--light-gray-gradient) !important;}.has-white-gradient-gradient-background{background: var(--wp--preset--gradient--white-gradient) !important;}.has-yellow-gradient-gradient-background{background: var(--wp--preset--gradient--yellow-gradient) !important;}.has-dark-brown-gradient-gradient-background{background: var(--wp--preset--gradient--dark-brown-gradient) !important;}.has-medium-pink-gradient-gradient-background{background: var(--wp--preset--gradient--medium-pink-gradient) !important;}.has-light-pink-gradient-gradient-background{background: var(--wp--preset--gradient--light-pink-gradient) !important;}.has-dark-purple-gradient-gradient-background{background: var(--wp--preset--gradient--dark-purple-gradient) !important;}.has-purple-gradient-gradient-background{background: var(--wp--preset--gradient--purple-gradient) !important;}.has-blue-gray-gradient-gradient-background{background: var(--wp--preset--gradient--blue-gray-gradient) !important;}.has-bright-blue-gradient-gradient-background{background: var(--wp--preset--gradient--bright-blue-gradient) !important;}.has-light-blue-gradient-gradient-background{background: var(--wp--preset--gradient--light-blue-gradient) !important;}.has-small-font-size{font-size: var(--wp--preset--font-size--small) !important;}.has-medium-font-size{font-size: var(--wp--preset--font-size--medium) !important;}.has-large-font-size{font-size: var(--wp--preset--font-size--large) !important;}.has-x-large-font-size{font-size: var(--wp--preset--font-size--x-large) !important;} 96:where(.wp-block-latest-posts.is-layout-flex){gap: 1.25em;}:where(.wp-block-latest-posts.is-layout-grid){gap: 1.25em;} 97/*# sourceURL=global-styles-inline-css */ 98</style> 99 100<link rel='stylesheet' id='simple-banner-style-css' href='https://www.benlcollins.com/wp-content/plugins/simple-banner/simple-banner.css?ver=3.3.2' media='all' /> 101<link rel='stylesheet' id='twentyfifteen-fonts-css' href='https://www.benlcollins.com/wp-content/themes/twentyfifteen/assets/fonts/noto-sans-plus-noto-serif-plus-inconsolata.css?ver=20230328' media='all' /> 102<link rel='stylesheet' id='genericons-css' href='https://www.benlcollins.com/wp-content/themes/twentyfifteen/genericons/genericons.css?ver=20251101' media='all' /> 103<link rel='stylesheet' id='twentyfifteen-style-css' href='https://www.benlcollins.com/wp-content/themes/twentyfifteen/style.css?ver=20260819' media='all' /> 104<link rel='stylesheet' id='twentyfifteen-block-style-css' href='https://www.benlcollins.com/wp-content/themes/twentyfifteen/css/blocks.css?ver=20240715' media='all' /> 105<link rel='stylesheet' id='convertkit-admin-quicktags-css' href='https://www.benlcollins.com/wp-content/plugins/convertkit/resources/backend/css/quicktags.css?ver=3.4.1' media='all' />
106<script data-wp-strategy="defer" defer id="fathom-snippet-js" src="https://cdn.usefathom.com/script.js" data-site="BMHYBZTT" data-no-minify></script>
vendor: 1 bytes, line 106
106
107<script id="jquery-core-js" src="https://www.benlcollins.com/wp-includes/js/jquery/jquery.min.js?ver=3.7.1"></script>
vendor: 1 bytes, line 107
107
108<script id="jquery-migrate-js" src="https://www.benlcollins.com/wp-includes/js/jquery/jquery-migrate.min.js?ver=3.4.1"></script>
vendor: 1 bytes, line 108
108
109<script id="simple-banner-script-js-before"> 110const simpleBannerScriptParams = {"pro_version_enabled":"","debug_mode":"","id":7246,"version":"3.3.2","banner_params":[{"hide_simple_banner":"yes","simple_banner_prepend_element":"","simple_banner_position":"relative","header_margin":"","header_padding":"","wp_body_open_enabled":"","wp_body_open":true,"simple_banner_z_index":"","disabled_on_current_page":false,"disabled_pages_array":[],"is_current_page_a_post":false,"disabled_on_posts":"","simple_banner_disabled_page_paths":"","simple_banner_font_size":"20px","simple_banner_color":"BLACK","simple_banner_text_color":"WHITE","simple_banner_link_color":"#ffffff","simple_banner_close_color":"WHITE","simple_banner_text":"<a href=\"https:\/\/geminimastery.benlcollins.com\/\">Stop feeling behind with AI. Start leading. 28 Days to Gemini Mastery \u2192<\/a>","simple_banner_custom_css":"","simple_banner_scrolling_custom_css":"","simple_banner_text_custom_css":"","simple_banner_button_css":"","site_custom_css":"","keep_site_custom_css":"","site_custom_js":"","keep_site_custom_js":"","close_button_enabled":"on","close_button_expiration":"","close_button_cookie_set":false,"current_date":{"date":"2026-10-01 10:23:43.264044","timezone_type":3,"timezone":"UTC"},"start_date":{"date":"2026-10-01 10:23:43.264049","timezone_type":3,"timezone":"UTC"},"end_date":{"date":"2026-10-01 10:23:43.264052","timezone_type":3,"timezone":"UTC"},"simple_banner_start_after_date":"","simple_banner_remove_after_date":"","simple_banner_insert_inside_element":""}]} 111//# sourceURL=simple-banner-script-js-before 112</script>
vendor: 1 bytes, line 112
112
113<script id="simple-banner-script-js" src="https://www.benlcollins.com/wp-content/plugins/simple-banner/simple-banner.js?ver=3.3.2"></script>
vendor: 1 bytes, line 113
113
114<script id="twentyfifteen-script-js-extra"> 115var screenReaderText = {"expand":"\u003Cspan class=\"screen-reader-text\"\u003Eexpand child menu\u003C/span\u003E","collapse":"\u003Cspan class=\"screen-reader-text\"\u003Ecollapse child menu\u003C/span\u003E"}; 116//# sourceURL=twentyfifteen-script-js-extra 117</script>
vendor: 1 bytes, line 117
117
118<script data-wp-strategy="defer" defer id="twentyfifteen-script-js" src="https://www.benlcollins.com/wp-content/themes/twentyfifteen/js/functions.js?ver=20250729"></script>
118 119<link rel="https://api.w.org/" href="https://www.benlcollins.com/wp-json/" /><link rel="alternate" title="JSON" type="application/json" href="https://www.benlcollins.com/wp-json/wp/v2/pages/7246" /><link rel="EditURI" type="application/rsd+xml" title="RSD" href="https://www.benlcollins.com/xmlrpc.php?rsd" /> 120<link rel='shortlink' href='https://www.benlcollins.com/' />
121<script async src="https://js.sparkloop.app/team_f28d45a262.js" data-sparkloop></script>
121 122<!-- Black Friday Top Banner --><!--<br>
123<script src="https://static.elfsight.com/platform/platform.js" data-use-service-core defer></script>
123 124<div class="elfsight-app-bc12d32e-94fd-4088-9e5e-f4b10e441404" data-elfsight-app-lazy></div>--> 125 126<!-- Google Workspace Affiliate Scripts
127<script type="text/javascript" language="javascript" src="https://www.kqzyfj.com/placeholder-53801197?target=_top&mouseover=N"></script>
127--><style id="simple-banner-hide" type="text/css">.simple-banner{display:none;}</style><style id="simple-banner-position" type="text/css">.simple-banner{position:relative;}</style><style id="simple-banner-font-size" type="text/css">.simple-banner .simple-banner-text{font-size:20px;}</style><style id="simple-banner-background-color" type="text/css">.simple-banner{background:BLACK;}</style><style id="simple-banner-text-color" type="text/css">.simple-banner .simple-banner-text{color:WHITE;}</style><style id="simple-banner-link-color" type="text/css">.simple-banner .simple-banner-text a{color:#ffffff;}</style><style id="simple-banner-z-index" type="text/css">.simple-banner{z-index: 99999;}</style><style id="simple-banner-close-color" type="text/css">.simple-banner .simple-banner-button{color:WHITE;}</style><style id="simple-banner-site-custom-css-dummy" type="text/css"></style>
127<script id="simple-banner-site-custom-js-dummy" type="text/javascript"></script>
127<!-- Stream WordPress user activity plugin v4.4.0 --> 128<style id="custom-background-css"> 129body.custom-background { background-color: #ffffff; } 130</style>
131<script async src="https://js.sparkloop.app/team_f28d45a262.js" data-sparkloop></script>
131<link rel="icon" href="https://www.benlcollins.com/wp-content/uploads/2020/06/cropped-BC-Icon-Color-512-32x32.png" sizes="32x32" /> 132<link rel="icon" href="https://www.benlcollins.com/wp-content/uploads/2020/06/cropped-BC-Icon-Color-512-192x192.png" sizes="192x192" /> 133<link rel="apple-touch-icon" href="https://www.benlcollins.com/wp-content/uploads/2020/06/cropped-BC-Icon-Color-512-180x180.png" /> 134<meta name="msapplication-TileImage" content="https://www.benlcollins.com/wp-content/uploads/2020/06/cropped-BC-Icon-Color-512-270x270.png" /> 135<style id="wp-custom-css"> 136/* 137Welcome to Custom CSS! 138 139CSS (Cascading Style Sheets) is a kind of code that tells the browser how 140to render a web page. You may delete these comments and get started with 141your customizations. 142 143By default, your stylesheet will be loaded after the theme stylesheets, 144which means that your rules can take precedence and override the theme CSS 145rules. Just write here what you want to change, you don't need to copy all 146your theme's stylesheet content. 147*/ 148/* 149a { 150 color: #0F9e59; 151} 152*/ 153.promotionBox { 154 width: 100%; 155 height: 360px; 156 background: #fff; 157 border:5px solid #0F9D58; 158 border-radius: 25px; 159 padding: 20px; 160} 161 162.codewrapper3 { 163 background: #f5f5f5; 164 margin: 0 0 30px 5px; 165 padding: 10px 15px 10px 15px; 166 border: 2px solid #dcdcdc; 167 font-size: 24px; 168 word-wrap: break-word; 169} 170 171.codewrapper4 { 172 background: #f5f5f5; 173 margin: 0 0 30px 5px; 174 padding: 10px 15px 10px 15px; 175 border: 2px solid #dcdcdc; 176 font-size: 18px; 177 word-wrap: break-word; 178} 179 180.container { 181 margin-right: 40px; 182 margin-bottom: 40px; 183 float: left; 184} 185 186.logo_grid { 187 clear: both; 188} 189 190 191/* styles for flash notice at top of posts */ 192.notice { 193 font: 14px/18px; 194 letter-spacing: .1em; 195 width: 100%; 196 margin: 20px auto; 197 text-align: center; 198 padding: 10px; 199 color: white; 200 text-decoration: none !important; 201 border-radius: .5rem; 202 background-color: #49bb5b; 203 border: 1px solid #2B823A; 204} 205 206.notice a:hover { 207 color: white; 208 text-decoration: underline; 209} 210 211.noticeYellow { 212 font: 20px/32px; 213 letter-spacing: .05em; 214 width: 100%; 215 margin: 20px auto; 216 text-align: center; 217 padding: 10px; 218 text-decoration: none !important; 219 border-radius: .25rem; 220 background-color: #FEE2B7; 221 border: 2px solid #cbb492; 222} 223 224.noticeYellow a:hover { 225 text-decoration: underline; 226} 227 228.noticeYellowLeft { 229 font: 20px/32px; 230 letter-spacing: .05em; 231 width: 100%; 232 margin: 20px auto; 233 text-align: left; 234 padding: 10px 10px 10px 10px; 235 text-decoration: none !important; 236 background-color: #FEE2B7; 237 border: 2px solid #cbb492; 238} 239 240.noticeYellowLeft a:hover { 241 text-decoration: underline; 242} 243 244.noticeYellowCenter { 245 font: 20px/24px; 246 letter-spacing: .05em; 247 width: 100%; 248 margin: 10px; 249 text-align: center; 250 padding: 20px; 251 text-decoration: none !important; 252 border-radius: 2.5rem; 253 background-color: #FEE2B7; 254 border: 2px solid #cbb492; 255} 256 257.noticeYellowCenter a:hover { 258 text-decoration: underline; 259} 260 261table#table_books { 262 width: 100%; 263} 264 265table#table_books, td, tr { 266 border: none; 267} 268 269table#table_data { 270 width: 100%; 271} 272 273table#table_data, td, tr { 274 border: 1px solid #d3d3d3; 275} 276 277#table_data td, tr { 278 padding: 8px; 279} 280 281.text-red { 282 color: #F15854; 283} 284 285.note-link { 286 font-size: 18px; 287 line-height: 24px; 288 position: relative; 289 padding: 14px 20px 24px 20px; 290 margin: 32px 0; 291 background-color: rgba(255,202,0,0.05); 292 border: solid 2px #ffca00; 293 border-radius: 12px; 294 clear: both; 295} 296 297.note-link-title { 298 font-size: 18px; 299 line-height: 24px; 300 color: #868F93; 301 padding-bottom: 8px; 302} 303 304.note-link-a { 305 display: block; 306 margin-top: 10px; 307 font-weight: 500; 308 font-size: 16px; 309 color: #000; 310} 311 312 313body {font-family: sans-serif} 314 315.related-articles { 316 display: block; 317 clear:both; 318 object-fit: contain; 319} 320 321.codeLinePadding { 322 line-height: 2em !important; 323 background-color: #e0e0e0 !important; 324 padding: 10px; 325} 326 327/* custom styles for the custom number format post */ 328#customNumberFormat { 329 border-collapse: collapse; 330 width: 100%; 331} 332 333#customNumberFormat td, #customNumberFormat th { 334 border: 1px solid #ddd; 335 padding: 8px; 336 text-align: center; 337} 338 339#customNumberFormat tr:nth-child(even){background-color: #f2f2f2;} 340 341#customNumberFormat tr:hover {background-color: #ddd;} 342 343#customNumberFormat th { 344 padding-top: 12px; 345 padding-bottom: 12px; 346 background-color: #0F9E59; 347 color: white; 348} 349 350pre{ 351 background:#f5f5f5; 352 border:1px #eee solid; 353 border-left:6px #eee solid; 354 font-size:0.9em; 355 white-space:pre; 356 overflow-x:auto; 357} 358 359.exerciseHighlight { 360 padding: 5px 5px 5px 10px; 361 margin-bottom: 1em; 362 background-color: #1A72E8; 363 font-weight: bold; 364 color: white; 365 text-align: left; 366 border-left: 15px #0d3974 solid; 367} 368 369.exerciseBox { 370 border: 2px #0d3974 dashed; 371 padding: 15px 10px 5px 10px; 372 margin: 35px 0px 30px 0px; 373} 374 375.exerciseHighlightSheets { 376 padding: 5px 5px 5px 10px; 377 margin-bottom: 1em; 378 background-color: #54a06b; 379 font-weight: bold; 380 color: white; 381 text-align: left; 382 border-left: 15px #2A8947 solid; 383} 384 385.exerciseBoxSheets { 386 border: 2px #2A8947 dashed; 387 padding: 15px 10px 5px 10px; 388 margin: 35px 0px 30px 0px; 389} 390 391.courseMenu ul { 392 list-style: none; 393 width:100%; 394 margin-left:0px; 395 padding-left:0px; 396} 397 398.courseMenu li { 399 padding: 15px 0px 10px 0px; 400 border-bottom: 1px solid #e8e8e8; 401} 402 403.courseMenu a { 404 text-decoration: none; 405 border-bottom-style: none; 406} 407 408.textWrapLeft { 409 float: left; 410 margin: 5px 10px 10px 0px; 411} 412 413.textWrapRight { 414 float: right; 415 margin: 5px 0px 10px 10px; 416} 417 418.button { 419 background-color: #4CAF50; /* Green */ 420 border: 2px solid #4CAF50 !important; 421 color: white; 422 padding: 16px 32px; 423 text-align: center; 424 text-decoration: none !important; 425 display: inline-block; 426 font-size: 20px; 427 font-weight: bold; 428 margin: 0px 2px 4px 2px; 429 transition-duration: 0.4s; 430 cursor: pointer; 431} 432 433.button1 { 434 background-color: white; 435 color: black; 436 border: 2px solid #4CAF50; 437} 438 439.button1:hover { 440 background-color: #4CAF50; 441 color: white; 442} 443 444#superscripts { 445 border-collapse: collapse; 446 width: 400px; 447} 448 449#superscripts td, #superscripts th { 450 border: 1px solid #ddd; 451 padding: 5px 5px 5px 8px; 452 text-align: center; 453} 454 455#superscripts tr:nth-child(even){background-color: #f2f2f2;} 456 457#superscripts tr:hover {background-color: #ddd;} 458 459#superscripts th { 460 padding-top: 12px; 461 padding-bottom: 12px; 462 text-align: left; 463 background-color: #0F9E59; 464 color: white; 465 text-align: center; 466} 467 468.threeColContents { 469 border:none; 470 padding:10px; 471} 472.threeColContents th { 473 border:none; 474 padding:10px; 475} 476.threeColContents td { 477 border:none; 478 padding:10px; 479 480 font-size: 10px; 481} 482 483.videoWrapper iframe { 484 display:block; 485 margin:auto; 486} 487 488/* custom styles generated for table in every function project posts */ 489.tg {border-collapse:collapse;border-spacing:0;} 490.tg td{border-color:black;border-style:solid;border-width:1px;font-size:14px; 491 overflow:hidden;padding:10px 16px;word-break:normal;} 492.tg th{border-color:black;border-style:solid;border-width:1px;font-size:14px; 493 font-weight:normal;overflow:hidden;padding:10px 16px;word-break:normal;color:white;} 494.tg .tg-yrf6{background-color:#ffffff;border-color:#c0c0c0;font-size:18px;text-align:center;vertical-align:bottom} 495.tg .tg-h4pz{background-color:#0F9E59;border-color:#c0c0c0; 496 font-size:18px;font-weight:bold; 497 text-align:center;vertical-align:bottom} 498.tg .tg-aowf{background-color:#efefef;border-color:#c0c0c0;font-size:18px;text-align:center;vertical-align:bottom} 499.tg .tg-4c6z{background-color:#0F9E59;border-color:#c0c0c0;font-size:18px;font-weight:bold;text-align:center;vertical-align:bottom} 500.tg .tg-4sho{background-color:#ffffff;border-color:#c0c0c0;font-size:18px;text-align:left;vertical-align:bottom} 501.tg .tg-xdbz{background-color:#efefef;border-color:#c0c0c0;font-size:18px;text-align:left;vertical-align:bottom} 502
503/* Affiliate Banner Ad Code - For Google Workspace */ 504.note-link-blue { 505 font-size: 18px; 506 line-height: 24px; 507 position: relative; 508 padding: 14px 20px 24px 20px; 509 margin: 32px 0; 510 background-color: #e9f1fe; 511 border: solid 2px #4285F4; 512 border-radius: 12px; 513 clear: both; 514 min-height: 250px; 515} 516 517.note-link-blue-title { 518 font-size: 18px; 519 line-height: 32px; 520 color: #4285F4; 521} 522 523.note-link-blue-p { 524 display: block; 525 margin-top: 10px; 526 font-weight: 500; 527 font-size: 16px; 528 color: #000; 529} 530 531.note-link-blue-a { 532 text-align: center; 533} 534 535.si_button { 536 padding-bottom: 30px; 537} 538 539</style> 540<style id="rocket-lazyrender-inline-css">[data-wpr-lazyrender] {content-visibility: auto;}</style><meta name="generator" content="WP Rocket 3.23.3.3" data-wpr-features="wpr_preconnect_external_domains wpr_automatic_lazy_rendering wpr_oci wpr_image_dimensions wpr_cdn wpr_preload_links wpr_desktop" /></head> 541 542<body class="home wp-singular page-template-default page page-id-7246 custom-background wp-custom-logo wp-embed-responsive wp-theme-twentyfifteen"> 543<div id="page" class="hfeed site"> 544 <a class="skip-link screen-reader-text" href="#content"> 545 Skip to content </a> 546 547 <div id="sidebar" class="sidebar"> 548 <header id="masthead" class="site-header"> 549 <div class="site-branding"> 550 <a href="https://www.benlcollins.com/" class="custom-logo-link" rel="home" aria-current="page"><img width="248" height="34" src="https://www.benlcollins.com/wp-content/uploads/2020/06/cropped-BC-Horizontal-Color-1.png" class="custom-logo" alt="Ben Collins logo" decoding="async" /></a> <p class="site-description">Educator and Google Developer Expert. Helping you navigate the world of spreadsheets & AI.</p> 551 552 <button class="secondary-toggle">Menu and widgets</button> 553 </div><!-- .site-branding --> 554 </header><!-- .site-header --> 555 556 <div id="secondary" class="secondary"> 557 558 <nav id="site-navigation" class="main-navigation"> 559 <div class="menu-main-menu-container"><ul id="menu-main-menu" class="nav-menu"><li id="menu-item-21380" class="menu-item menu-item-type-custom menu-item-object-custom current-menu-item current_page_item menu-item-home menu-item-21380"><a href="https://www.benlcollins.com/" aria-current="page">Home</a></li> 560<li id="menu-item-21639" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-21639"><a href="https://geminimastery.benlcollins.com/"><strong style=" background: linear-gradient(90deg, #FA47D3 0%, #9552E3 40%, #1861F8 70%, #0AAEC5 100%); -webkit-background-clip: text; -webkit-text-fill-color: transparent; background-clip: text; ">28 Days to Gemini Mastery</strong></a></li> 561<li id="menu-item-10164" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children menu-item-10164"><a target="_blank" href="https://courses.benlcollins.com/">Courses</a> 562<ul class="sub-menu"> 563 <li id="menu-item-21644" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-21644"><a href="https://geminimastery.benlcollins.com/">28 Days to Gemini Mastery</a></li> 564 <li id="menu-item-21645" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-21645"><a href="https://moderngooglesheets.benlcollins.com/">Modern Google Sheets</a></li> 565 <li id="menu-item-21131" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-21131"><a target="_blank" href="https://courses.benlcollins.com/">Other Courses</a></li> 566 <li id="menu-item-11224" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-11224"><a target="_blank" href="https://sso.teachable.com/secure/69396/users/sign_in">Student Login</a></li> 567</ul> 568</li> 569<li id="menu-item-21825" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-21825"><a href="https://www.benlcollins.com/future-proof-newsletter/">Newsletter</a></li> 570<li id="menu-item-1439" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1439"><a href="https://www.benlcollins.com/about/">About</a></li> 571<li id="menu-item-453" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-453"><a href="https://www.benlcollins.com/contact/">Contact</a></li> 572</ul></div> </nav><!-- .main-navigation --> 573 574 575 <div id="widget-area" class="widget-area" role="complementary"> 576 <aside id="search-2" class="widget widget_search"><h2 class="widget-title">Search</h2><form role="search" method="get" class="search-form" action="https://www.benlcollins.com/"> 577 <label> 578 <span class="screen-reader-text">Search for:</span> 579 <input type="search" class="search-field" placeholder="Search …" value="" name="s" /> 580 </label> 581 <input type="submit" class="search-submit screen-reader-text" value="Search" /> 582 </form></aside><aside id="block-3" class="widget widget_block"> 583<h2 class="wp-block-heading">LATEST</h2> 584</aside><aside id="block-2" class="widget widget_block widget_recent_entries"><ul class="wp-block-latest-posts__list wp-block-latest-posts is-layout-flow wp-block-latest-posts-is-layout-flow"><li><a class="wp-block-latest-posts__post-title" href="https://www.benlcollins.com/spreadsheets/400-google-sheets-tips-whats-next/">The end of an era: issue #400 was the last Google Sheets Tips newsletter and what’s coming next</a></li> 585<li><a class="wp-block-latest-posts__post-title" href="https://www.benlcollins.com/spreadsheets/datatype-font/">Explorations with the Datatype Font in Google Sheets</a></li> 586<li><a class="wp-block-latest-posts__post-title" href="https://www.benlcollins.com/spreadsheets/sheets-canvas/">Build Dashboards and Kanban Boards with the Google Sheets Canvas Tool</a></li> 587<li><a class="wp-block-latest-posts__post-title" href="https://www.benlcollins.com/spreadsheets/google-next-2026/">Google Sheets and Workspace Updates from Google Next 2026</a></li> 588<li><a class="wp-block-latest-posts__post-title" href="https://www.benlcollins.com/ai/formulas-2026/">Is Formula Writing Dead? (And why we shouldn’t mourn it)</a></li> 589</ul></aside> </div><!-- .widget-area --> 590 591 </div><!-- .secondary --> 592 593 </div><!-- .sidebar --> 594
595 <div id="content" class="site-content"> 596 597 <div id="primary" class="content-area"> 598 <main id="main" class="site-main"> 599 600 601<article id="post-7246" class="post-7246 page type-page status-publish hentry"> 602 603 <header class="entry-header"> 604 <h1 class="entry-title">Newest Course: Gemini Mastery</h1> </header><!-- .entry-header --> 605 606 <div class="entry-content"> 607 608<!-- 28 Days to Gemini Mastery â Homepage Banner --> 609<!-- Paste into a WordPress Custom HTML block --> 610 611<style> 612.gm { font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Helvetica, Arial, sans-serif; border-radius: 12px; overflow: hidden; border: 1px solid #e5e5e5; } 613.gm-bar { height: 13px; background: linear-gradient(90deg, #E040A0 0%, #9B59B6 35%, #7B68EE 65%, #12C2E9 100%); } 614.gm-body { background: #fff; padding: 1.75rem !important; display: flex; flex-direction: column; gap: 1.1rem; } 615.gm-eyebrow { font-size: 11px !important; font-weight: 600; letter-spacing: 0.09em; text-transform: uppercase; margin: 0 0 0.4rem 0 !important; color: #9B59B6; line-height: 1.2 !important; } 616.gm-headline { font-size: 22px !important; font-weight: 700; line-height: 1.2 !important; color: #111; margin: 0 !important; padding: 0 !important; } 617.gm-img-wrap { display: flex; justify-content: center; line-height: 0; font-size: 0; margin: 0 0 0.5rem 0 !important; padding: 0 !important; } 618.gm-img-link { display: block; width: 80%; border-radius: 8px; overflow: hidden; box-shadow: 0 3px 16px rgba(0,0,0,0.12); transition: transform 0.2s, box-shadow 0.2s; margin: 0 !important; padding: 0 !important; line-height: 0; } 619.gm-img-link:hover { transform: scale(1.01); box-shadow: 0 6px 22px rgba(0,0,0,0.18); } 620.gm-img-link img { width: 100% !important; height: auto !important; display: block !important; margin: 0 !important; padding: 0 !important; border: none !important; box-shadow: none !important; line-height: 0; } 621.gm-benefits { list-style: none !important; margin: 0 !important; padding: 0 !important; display: flex; flex-direction: column; gap: 9px; } 622.gm-benefits li { font-size: 15px !important; color: #333; line-height: 1.45 !important; display: flex !important; align-items: flex-start; gap: 10px; margin: 0 !important; padding: 0 !important; } 623.gm-benefits li::before { content: "" !important; display: inline-block !important; width: 7px; height: 7px; border-radius: 50%; background: linear-gradient(135deg, #C471ED, #12C2E9); flex-shrink: 0; margin-top: 5px; } 624.gm-divider { height: 1px; background: #f0f0f0; margin: 0 !important; } 625.gm-bottom { display: flex; align-items: center; gap: 1.25rem; flex-wrap: wrap; } 626.gm-price-block { display: flex; align-items: baseline; gap: 8px; } 627.gm-price { font-size: 28px !important; font-weight: 700; color: #111; margin: 0 !important; } 628.gm-was { font-size: 14px !important; color: #aaa; text-decoration: line-through; margin: 0 !important; } 629.gm-badge { font-size: 11px !important; font-weight: 600; background: #F3E5FA; color: #7D3C98 !important; padding: 3px 9px !important; border-radius: 20px; white-space: nowrap; margin: 0 !important; } 630.gm-cta { display: inline-block !important; font-size: 15px !important; font-weight: 700; padding: 12px 24px !important; border-radius: 8px; text-decoration: none !important; color: #fff !important; background: #C0392B !important; transition: background 0.2s; white-space: nowrap; margin: 0 !important; } 631.gm-cta:hover { background: #A93226 !important; } 632.gm-fine { font-size: 12px !important; color: #aaa !important; line-height: 1.5 !important; margin: 0 !important; width: 100%; } 633</style> 634 635<div class="gm"> 636 <div class="gm-bar"></div> 637 <div class="gm-body"> 638 639 <div style="margin:0;padding:0.5rem 0 0;"> 640 <p class="gm-eyebrow">New course â launch offer</p> 641 <h2 class="gm-headline">Stop dabbling with Gemini.<br>Start building AI systems.</h2> 642 </div> 643 644 <div class="gm-img-wrap"> 645 <a class="gm-img-link" href="https://geminimastery.benlcollins.com"> 646 <img fetchpriority="high" width="2726" height="1533" decoding="async" src="https://www.benlcollins.com/wp-content/uploads/2026/03/courseIcon3.jpg" alt="28 Days to Gemini Mastery" /> 647 </a> 648 </div> 649 650 <ul class="gm-benefits"> 651 <li>Go from one-off prompts to repeatable AI workflows â in just 15â20 minutes a day</li> 652 <li>Integrate Gemini across Sheets, Docs, Gmail, and all your Workspace tools</li> 653 <li>Build automations and agents that save you hours every week</li> 654 <li>Master NotebookLM, vibe coding, Gemini Gems, and more â 28 lessons, lifetime access</li> 655 </ul> 656 657 <div class="gm-divider"></div> 658 659 <div class="gm-bottom"> 660 <div class="gm-price-block">
661 <span class="gm-price">$149</span> 662 </div> 663 <a class="gm-cta" href="https://geminimastery.benlcollins.com">Get instant access â</a> 664 <p class="gm-fine">Access all 28 lessons instantly · Lifetime access · 14-day money-back guarantee</p> 665 </div> 666 667 </div> 668</div> 669 670 671 672<h1 class="wp-block-heading">Writing</h1> 673 674 675 676<h2 class="wp-block-heading"><figure><span style="background-color: rgb(255, 255, 255); color: rgb(250, 71, 211);">A</span><span style="background-color: rgb(255, 255, 255); color: rgb(224, 74, 215);">I </span><span style="background-color: rgb(255, 255, 255); color: rgb(149, 82, 227);">and</span><span style="background-color: rgb(255, 255, 255); color: rgb(93, 89, 237);"> Sp</span><span style="background-color: rgb(255, 255, 255); color: rgb(24, 97, 248);">re</span><span style="background-color: rgb(255, 255, 255); color: rgb(6, 131, 229);">ad</span><span style="background-color: rgb(255, 255, 255); color: rgb(7, 154, 211);">sh</span><span style="background-color: rgb(255, 255, 255); color: rgb(10, 174, 197);">ee</span><span style="background-color: rgb(255, 255, 255); color: rgb(10, 189, 185);">ts</span></figure></h2> 677 678 679 680<p class="wp-block-paragraph"><mark>NEW</mark> <a href="https://www.benlcollins.com/spreadsheets/400-google-sheets-tips-whats-next/" data-type="post" data-id="21799" target="_blank" rel="noreferrer noopener">The end of an era: issue #400 was the last Google Sheets Tips newsletter and whatâs coming next</a></p> 681 682 683 684<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/sheets-canvas/" data-type="post" data-id="21673" target="_blank" rel="noreferrer noopener">Build Dashboards and Kanban Boards with the Google Sheets Canvas Tool</a></p> 685 686 687 688<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/google-next-2026/" type="post" id="21656">Google Sheets and Workspace Updates from Google Next 2026</a></p> 689 690 691 692<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/ai/formulas-2026/" target="_blank" rel="noopener">Is Formula Writing Dead? (And why we shouldnât mourn it)</a></p> 693 694 695 696<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/ai/knowledge-engine-notebooklm/" target="_blank" rel="noopener">How to Build a Content Engine with Apps Script, NotebookLM, and a Gemini Gem</a></p> 697 698 699 700<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/ai-function/" target="_blank" rel="noopener">How to use the AI Function in Google Sheets (with 10 examples)</a></p> 701 702 703 704<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/ai/operator-google-sheet/" target="_blank" rel="noopener">I Let OpenAI Operator Manage My Google Sheet: Hereâs What Happened.</a></p> 705 706 707 708<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/ai/can-ai-studio-teach-me-how-to-build-a-pivot-table/" target="_blank" rel="noopener">Can AI Studio teach me how to build a pivot table?</a></p> 709 710 711 712<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/ai/sora-experiment/" target="_blank" rel="noopener">AI Experiments: Using Sora AI to Generate Videos</a></p> 713 714 715 716<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/ai/" target="_blank" rel="noopener">What AI Can Do For You As A Google Sheets User. Is The Hype Justified?</a></p> 717 718 719 720<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/ai-tools-with-google-sheets/" target="_blank" rel="noopener">Three Ways To Use AI Tools With Google Sheets</a></p> 721 722 723 724<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/google-forms-ai-apps-script/" target="_blank" rel="noopener">How I Used Google Forms, AI, and Apps Script Automation to Analyze 1,700 Survey Responses</a></p> 725 726 727 728<p class="wp-block-paragraph"> </p> 729 730 731 732<hr class="wp-block-separator has-alpha-channel-opacity"/> 733 734 735 736<h2 class="wp-block-heading"><figure><img decoding="async" class="alignnone size-thumbnail wp-image-4369" style="display: inline;" src="https://www.benlcollins.com/wp-content/uploads/2017/01/google_sheets_log-150x150.png" alt="" width="100" height="100" srcset="https://www.benlcollins.com/wp-content/uploads/2017/01/google_sheets_log-150x150.png 150w, https://www.benlcollins.com/wp-content/uploads/2017/01/google_sheets_log.png 300w" sizes="(max-width: 100px) 100v
736w, 100px" /></figure>Google Sheets Articles</h2> 737 738 739 740<h3 class="wp-block-heading">Popular Articles</h3> 741 742 743 744<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/how-to-use-google-sheets/" target="_blank" rel="noopener noreferrer">How to use Google Sheets: A Beginnerâs Guide</a> <em>(a super detailed guide to take you from newbie to ninja in no time!)</em></p> 745 746 747 748<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/url-tricks-for-google-sheets/" target="_blank" rel="noopener">11 Incredibly Useful URL Tricks for Google Sheets</a></p> 749 750 751 752<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/conditional-formatting-entire-row/" target="_blank" rel="noopener">How to apply conditional formatting across an entire row in Google Sheets</a></p> 753 754 755 756<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/checklist-template/" target="_blank" rel="noopener noreferrer">Checklist Template In Google Sheets</a></p> 757 758 759 760<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/google-sheets-query-sql/" target="_blank" rel="noopener">Google Sheets Query function: The Most Powerful Function in Google Sheets</a></p> 761 762 763 764<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/query-dates/" target="_blank" rel="noopener">Filtering with dates in the QUERY function</a></p> 765 766 767 768<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/formula-parse-error/" target="_blank" rel="noopener">When Your Formula Doesnât Work: Formula Parse Errors in Google Sheets</a></p> 769 770 771 772<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/google-apps-script-beginner-guide/" target="_blank" rel="noopener">Google Apps Script: A Beginnerâs Guide</a></p> 773 774 775 776<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/google-sheets-button/" target="_blank" rel="noopener">Add A Google Sheets Button To Run Scripts</a></p> 777 778 779 780<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/superscript-in-google-sheets/" target="_blank" rel="noopener">How To Add Subscript and Superscript In Google Sheets</a></p> 781 782 783 784<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/google-sheets-custom-number-format/" target="_blank" rel="noopener">Google Sheets Custom Number Format</a></p> 785 786 787 788<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/custom-number-format-color-palette-reference-table/" target="_blank" rel="noopener">Custom Number Format Color Palette Reference Table</a></p> 789 790 791 792<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/google-sheets-checkbox/" target="_blank" rel="noopener">How To Use Checkboxes In Google Sheets</a></p> 793 794 795 796<h3 class="wp-block-heading">Sheets Insiders Membership Articles</h3> 797 798 799 800<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/introducing-membership-program/" target="_blank" rel="noopener">Introducing The Sheets Insiders Membership Program</a></p> 801 802 803 804<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/si1-visual-vocab/" target="_blank" rel="noopener">Sheets Insiders 1: Visual Vocabulary Template</a> (available to everyone)</p> 805 806 807 808<h3 class="wp-block-heading">Working with data in Google Sheets</h3> 809 810 811 812<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/tables-in-google-sheets/" target="_blank" rel="noopener">
812The Complete Guide to Tables in Google Sheets</a></p> 813 814 815 816<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/importrange-google-sheets/" target="_blank" rel="noopener">How To Use The IMPORTRANGE Function In Google Sheets To Transfer Data From One Sheet To Another</a></p> 817 818 819 820<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/slow-google-sheets/" target="_blank" rel="noopener noreferrer">Slow Google Sheets? Here are 27 ideas to try today</a></p> 821 822 823 824<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/data-best-practices/" target="_blank" rel="noopener noreferrer">18 best practices for working with data in Google Sheets</a></p> 825 826 827 828<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/copy-only-visible-cells/" target="_blank" rel="noopener">How To Copy Only Visible Cells In Google Sheets</a></p> 829 830 831 832<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/google-sheets-checkbox/" target="_blank" rel="noopener noreferrer">How To Use Checkboxes In Google Sheets</a></p> 833 834 835 836<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/google-sheets-select-all-checkbox/" target="_blank" rel="noopener">How To Create A Select All Checkbox in Google Sheets</a></p> 837 838 839 840<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/mimic-radio-buttons-with-formulas-and-checkboxes/" target="_blank" rel="noopener">How To Mimic Radio Buttons With Formulas and Checkboxes</a></p> 841 842 843 844<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/google-sheets-drop-down/" target="_blank" rel="noopener">How To Create A Google Sheets Drop Down Menu</a></p> 845 846 847 848<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/multiple-selections-dropdowns/" target="_blank" rel="noopener">Multiple Selections in Drop Downs in Google Sheets</a></p> 849 850 851 852<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/how-to-remove-duplicates-in-google-sheets/" target="_blank" rel="noopener noreferrer">How to Remove Duplicates in Google Sheets</a></p> 853 854 855 856<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/unpivot-in-google-sheets/" target="_blank" rel="noopener noreferrer">Unpivot In Google Sheets With Formulas, Or How To Turn Wide Data Into Tall Data</a></p> 857 858 859 860<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/connected-sheets/" target="_blank" rel="noopener noreferrer">Connected Sheets: Analyze Big Data In Google Sheets</a></p> 861 862 863 864<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/bigquery/get-started-with-google-bigquery/" target="_blank" rel="noopener">Beyond Sheets: Get Started With Google BigQuery</a></p> 865 866 867 868<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/unique-list-of-items/" target="_blank" rel="noopener">Get A Unique List Of Items From A Column With Grouped Words</a></p> 869 870 871 872<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/google-sheets-top-5-values/" target="_blank" rel="noopener">How To Highlight The Top 5 Values In Google Sheets With Formulas</a></p> 873 874 875 876<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/rank-function/" target="_blank" rel="noopener">How To Rank Data In Google Sheets With The RANK Function</a></p> 877 878 879 880<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/arrays-in-google-sheets/" target="_blank" rel="noopener">How To Create Arrays In Google Sheets (a.k.a. Array Literals)</a></p> 881 882 883 884<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/automatic-data-sharing-across-sheets/" target="_blank" rel="noopener">Automatic Data Sharing Across Sheets With IMPORTRANGE and Named Functions</a></p> 885 886 887 888<h3 class="wp-block-heading">Formulas in Google Sheets</h3> 889 890 891 892<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/new-analytical-functions-2023/" target="_blank" rel="noopener">11 New Analytical Functions In Google Sheets For 2023</a></p> 893 894 895 896<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/new-functions-in-google-sheets-2022/" target="_blank" rel="noopener">New Functions In Google Sheets For 2022: Named Functions, Lambda, MAP, REDUCE, etc.</a></p> 897 898 899 900<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/named-functions/" target="_blank" rel="noopener">A Guide To Named Functions In Google Sheets</a></p> 901 902 903 904<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/lambda-function/" target="_blank" rel="noopener">
904LAMBDA Function in Google Sheets</a></p> 905 906 907 908<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/xlookup-function/" target="_blank" rel="noopener">XLOOKUP Function in Google Sheets</a></p> 909 910 911 912<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/xmatch-function/" target="_blank" rel="noopener">XMATCH Function in Google Sheets</a></p> 913 914 915 916<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/map-function/" target="_blank" rel="noopener">MAP Function in Google Sheets â LAMBDA Helper Function</a></p> 917 918 919 920<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/reduce-function/" target="_blank" rel="noopener">REDUCE Function in Google Sheets â LAMBDA Helper Function</a></p> 921 922 923 924<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/makearray-function/" target="_blank" rel="noopener">MAKEARRAY Function in Google Sheets â LAMBDA Helper Function</a></p> 925 926 927 928<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/scan-function/" target="_blank" rel="noopener">SCAN Function in Google Sheets â LAMBDA Helper Function</a></p> 929 930 931 932<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/byrow-function/" target="_blank" rel="noopener">BYROW Function in Google Sheets â LAMBDA Helper Function</a></p> 933 934 935 936<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/bycol-function/" target="_blank" rel="noopener">BYCOL Function in Google Sheets – LAMBDA Helper Function</a></p> 937 938 939 940<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/google-sheets-formulas-techniques/" target="_blank" rel="noopener noreferrer">18 Google Sheets Formula Tips & Techniques You Should Know</a></p> 941 942 943 944<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/complex-formulas-onion-method/" target="_blank" rel="noopener noreferrer">Use The Onion Method To Approach Complex Formulas</a></p> 945 946 947 948<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/if-function/" target="_blank" rel="noopener">IF Function in Google Sheets</a></p> 949 950 951 952<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/ifs-function/" target="_blank" rel="noopener">IFS Function in Google Sheets</a></p> 953 954 955 956<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/iferror-function/" target="_blank" rel="noopener">IFERROR Function In Google Sheets</a></p> 957 958 959 960<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/fact-function/" target="_blank" rel="noopener">FACT Function in Google Sheets (And Why A Shuffled Deck of Cards Is Unique)</a></p> 961 962 963 964<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/rept-function/" target="_blank" rel="noopener">REPT Function in Google Sheets</a></p> 965 966 967 968<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/split-function/" target="_blank" rel="noopener">SPLIT Function in Google Sheets</a></p> 969 970 971 972<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/indirect-function/" target="_blank" rel="noopener">INDIRECT Function in Google Sheets</a></p> 973 974 975 976<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/subtotal-function/" target="_blank" rel="noopener">SUBTOTAL Function in Google Sheets</a></p> 977 978 979 980<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/google-sheets-query-sql/" target="_blank" rel="noopener noreferrer">Google Sheets Query function: Learn the most powerful function in Google Sheets</a></p> 981 982 983 984<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/query-dates/" target="_blank" rel="noopener noreferrer">Filtering with dates in the QUERY function</a></p> 985 986 987 988<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/query-total-row/" target="_blank" rel="noopener noreferrer">How to add a total row to a Query Function table in Google Sheets</a></p> 989 990 991 992<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/filter-function-google-sheets/" target="_blank" rel="noopener noreferrer">A Guide To The Google Sheets Filter Function</a></p> 993 994 995 996<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/formula-examples/advanced-filter/" target="_blank" rel="noopener noreferrer">Advanced Filter Examples in Google Sheets</a></p> 997 998 999 1000<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/formula-examples/array-formula-intro/" target="_blank" rel="noopener noreferrer">How does the array formula work in Google Sheets?</a></p> 1001 1002 1003 1004<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/formula-examples/array-formulas-forms/" target="_blank" rel="noopener noreferrer">Use Array Formulas to auto-fill calculation columns when using Google Forms</a></p> 1005 1006 1007 1008<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/formula-examples/text-numbers/" target="_blank" rel="noopener noreferrer">How can I combine text and numbers in a cell and keep the number formatting?</a></p> 1009 1010 1011 1012<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/formula-examples/first-and-last-d
1012ays-current-month/" target="_blank" rel="noopener noreferrer">How do I get the first and last days of the current month?</a></p> 1013 1014 1015 1016<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/formula-examples/first-and-last-days-prior-month/" target="_blank" rel="noopener noreferrer">How do I get the first and last days of the prior month?</a></p> 1017 1018 1019 1020<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/vlookup-function/" target="_blank" rel="noopener">VLOOKUP Function in Google Sheets: The Essential Guide</a></p> 1021 1022 1023 1024<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/formula-examples/vlookup-left/" target="_blank" rel="noopener noreferrer">How do I do a VLOOKUP to the left in Google Sheets?</a></p> 1025 1026 1027 1028<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/vlookup-wildcard/" target="_blank" rel="noopener noreferrer">VLOOKUP in Google Sheets using wildcards for partial matches</a></p> 1029 1030 1031 1032<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/formula-examples/vlookup-return-multiple-columns/" target="_blank" rel="noopener noreferrer">Have VLOOKUP Return Multiple Columns in Google Sheets</a></p> 1033 1034 1035 1036<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/vlookup-multiple-criteria/" target="_blank" rel="noopener noreferrer">VLOOKUP Multiple Criteria in Google Sheets</a></p> 1037 1038 1039 1040<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/running-total/" target="_blank" rel="noopener noreferrer">Running Total Array Formulas (using MMULT)</a></p> 1041 1042 1043 1044<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/formula-examples/reverse-text/" target="_blank" rel="noopener noreferrer">How do I reverse text in a cell in Google Sheets?</a></p> 1045 1046 1047 1048<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/sequence-function/" target="_blank" rel="noopener">Build Numbered Lists With The Amazing SEQUENCE Function</a></p> 1049 1050 1051 1052<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/formula-examples/dynamic-named-ranges/" target="_blank" rel="noopener noreferrer">How to create dynamic named ranges in Google Sheets</a></p> 1053 1054 1055 1056<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/formula-help/" target="_blank" rel="noopener noreferrer">Help, my formula doesnât work! (Dealing with errors)</a></p> 1057 1058 1059 1060<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/cell-function-table-of-contents/" target="_blank" rel="noopener">Experiments With Cell Function: Create A Dynamic Table Of Contents In Google Sheets With Formulas</a></p> 1061 1062 1063 1064<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/google-sheets-regex-formulas/" target="_blank" rel="noopener">Google Sheets REGEX Formulas</a></p> 1065 1066 1067 1068<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/default-values/" target="_blank" rel="noopener">Setting Default Values For Cells In Google Sheets</a></p> 1069 1070 1071 1072<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/char-function/" target="_blank" rel="noopener">A Complete Guide To The CHAR Function In Google Sheets</a></p> 1073 1074 1075 1076<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/transpose-function/" target="_blank" rel="noopener">The TRANSPOSE Function in Google Sheets</a></p> 1077 1078 1079 1080<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/flatten-function/" target="_blank" rel="noopener">The FLATTEN Function in Google Sheets</a></p> 1081 1082 1083 1084<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/and-function/" target="_blank" rel="noopener">The AND Function in Google Sheets</a></p> 1085 1086 1087 1088<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/or-function/" target="_blank" rel="noopener">The OR Function in Google Sheets</a></p> 1089 1090 1091 1092<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/unique-function/" target="_blank" rel="noopener">The UNIQUE Function in Google Sheets</a></p> 1093 1094 1095 1096<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/countif-function/" target="_blank" rel="noopener">Google Sheets COUNTIF Function</a></p> 1097 1098 1099 1100<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/countifs-function/" target="_blank" rel="noopener">Google Sheets COUNTIFS Function</a></p> 1101 1102 1103 1104<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/sumif-function/" target="_blank" rel="noopener">How To Use Google Sheets SUMIF Function</a></p> 1105 1106 1107 1108<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/sumifs-function/" target="_blank" rel="noopener">Google Sheets SUMIFS Function</a></p> 1109 1110 1111 1112<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/randarray-function/" target="_blank" rel="noopener">How To Use The RANDARRAY Function In Google Sheets</a></p> 1113 1114 1115 1116<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/randbetween-function/" target="_blank" rel="noopener">How To Use The RANDBETWEEN Function In Google Sheets</a></p> 1117 1118 1119 1120<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/rand-function/" target="_blank" rel="noopener">How To Create A Random Number Generator In Google Sheets</a></p> 1121 1122 1123 1124<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/sortn-function/" target="_blank" rel="noopener">SORTN Function In Google Sheets</a></p> 1125 1126 1127 1128<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/large-function/" target="_blank" rel="noopener">The LARGE Function in Google Sheets</a></p> 1129 1130 1131 1132<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/switch-function/" target="_blank" rel="noopener">Use The SWITCH Function to Categorize Data Efficiently</a></p> 1133 1134 1135 1136<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/choose-function/" target="_blank" rel="noopener">How To Use The Choose Function In Google Sheets</a></p> 1137 1138 1139 1140<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/trim-function/" target="_blank" rel="noopener">How To Use The TRIM Function In Google Sheets To Clean Your Data</a></p> 1141 1142 1143 1144<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/roman-function/" target="_blank" rel="noopener">The ROMAN Function in Google Sheets</a></p> 1145 1146 1147 1148<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/len-function/" target="_blank" rel="noopener">The LEN Function in Google Sheets</a></p> 1149 1150 1151 1152<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/getpivotdata/" target="_blank" rel="noopener">GETPIVOTDATA Function in Google Sheets: How To Extract Data From Pivot Tables</a></p> 1153 1154 1155 1156<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/bullet-chart-in-google-sheets/" target="_blank" rel="noopener">Bullet Chart in Google Sheets with Sparklines and Named Functions</a></p> 1157 1158 1159 1160<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/recursion-in-google-sheets/" target="_blank" rel="noopener">Recursion in Google Sheets with Formulas</a><br><a id="formulaChallenges"></a></p> 1161 1162 1163 1164<h3 class="wp-block-heading">Formula Challenges in Google Sheets</h3> 1165 1166 1167 1168<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/formula-challenge-1-repeating-images-with-array-formulas/" target="_blank" rel="noopener noreferrer">Formula Challenge #1: Repeating Images with Array Formulas</a></p> 1169 1170 1171 1172<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/formula-challenge-2-matching-terms/" target="_blank" rel="noopener noreferrer">Formula Challenge #2: Matching Terms</a></p> 1173 1174 1175 1176<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/formula-challenge-3-alphabetize-comma-separated-strings/" target="_blank" rel="noopener noreferrer">Formula Challenge #3: Alphabetize Comma-Separated Strings</a></p> 1177 1178 1179 1180<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/formula-challenge-4-sort-a-column-by-last-name/" target="_blank" rel="noopener noreferrer">Formula Challenge #4: Sort A Column By Last Name</a></p> 1181 1182 1183 1184<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/formula-challenge-5-merge-columns-in-google-sheets-with-single-range-reference/" target="_blank" rel="noopener">Formula Challenge #5: Merge Columns in Google Sheets With Single Range Reference</a></p> 1185 1186 1187 1188<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/formula-challenge-6-split-a-string-into-characters/" target="_blank" rel="noopener">Formula Challenge #6: Split A String Into Characters And Recombine In Random Order</
1188a></p> 1189 1190 1191 1192<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/formula-challenge-7-repeating-sequence/" target="_blank" rel="noopener">Formula Challenge #7: Generate A Repeating Sequence Of Numbers</a></p> 1193 1194 1195 1196<h3 class="wp-block-heading">Getting external data into Google Sheets with formulas</h3> 1197 1198 1199 1200<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/alexa-rank-tracker-sheet/" target="_blank" rel="noopener noreferrer">Alexa Rank Tracker in Google Sheets</a></p> 1201 1202 1203 1204<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/google-sheet-web-scraper/" target="_blank" rel="noopener noreferrer">Using Google Sheets as a basic web scraper</a></p> 1205 1206 1207 1208<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/import-social-media-statistics/" target="_blank" rel="noopener noreferrer">How can I import social media statistics into Google Sheets?</a></p> 1209 1210 1211 1212<h3 class="wp-block-heading">Pivot Tables in Google Sheets</h3> 1213 1214 1215 1216<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/pivot-tables-google-sheets/" target="_blank" rel="noopener noreferrer">Pivot Tables in Google Sheets: A Beginnerâs Guide</a></p> 1217 1218 1219 1220<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/pivot-table-map/" target="_blank" rel="noopener noreferrer">Mapping data with Pivot Tables in Google Sheetsâ¦yes, really!</a></p> 1221 1222 1223 1224<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/slicers-in-google-sheets/" target="_blank" rel="noopener noreferrer">Slicers in Google Sheets</a></p> 1225 1226 1227 1228<h3 class="wp-block-heading">Formatting in Google Sheets</h3> 1229 1230 1231 1232<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/superscript-in-google-sheets/" target="_blank" rel="noopener noreferrer">How To Add Subscript and Superscript In Google Sheets</a></p> 1233 1234 1235 1236<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/merge-cells/" target="_blank" rel="noopener noreferrer">How To Merge Cells In Google Sheets And When To Be Careful</a></p> 1237 1238 1239 1240<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/conditional-formatting-entire-row/" target="_blank" rel="noopener noreferrer">How To Apply Conditional Formatting Across An Entire Row In Google Sheets</a></p> 1241 1242 1243 1244<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/status-arrows-in-google-sheets/" target="_blank" rel="noopener">Status Arrows in Google Sheets</a></p> 1245 1246 1247 1248<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/text-rotation/" target="_blank" rel="noopener noreferrer">Using Text Rotation to Create Custom Table Headers in Google Sheets</a></p> 1249 1250 1251 1252<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/google-sheets-custom-number-format/" target="_blank" rel="noopener noreferrer">Google Sheets Custom Number Format</a></p> 1253 1254 1255 1256<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/how-to-wrap-text-in-google-sheets/" target="_blank" rel="noopener">How To Wrap Text In Google Sheets</a></p> 1257 1258 1259 1260<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/barcodes-in-google-sheets/" target="_blank" rel="noopener">Create Barcodes In Google Sheets In 2 Easy Steps</a></p> 1261 1262 1263 1264<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/qr-codes-in-google-sheets/" target="_blank" rel="noopener">How To Create QR Codes in Google Sheets Using Formulas</a></p> 1265 1266 1267 1268<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/how-to-alternate-colors-in-google-sheets/" target="_blank" rel="noopener">How To Alternate Colors In Google Sheets</a></p> 1269 1270 1271 1272<h3 class="wp-block-heading">Automation</h3> 1273 1274 1275 1276<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/macros/" target="_blank" rel="noopener noreferrer">The complete guide to simple automation in Google Sheets, using Macros</a></p> 1277 1278 1279 1280<h3 class="wp-block-heading">Data Analysis techniques in Google Sheets</h3> 1281 1282 1283 1284<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/goal-seek-in-google-sheets/" target="_blank" rel="noopener noreferrer">Goal Seek in Google Sheets</a></p> 1285 1286 1287 1288<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/average/" target="_blank" rel="noopener noreferrer">What the worldâs richest man can teach us about averages</a></p> 1289 1290 1291 1292<h3 class="wp-block-heading">Charting techniques in Google Sheets</h3> 1293 1294 1295 1296<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/radial-bar-charts-in-google-sheets/" target="_blank" rel="noopener">Radial Bar Charts in Google Sheets</a></p> 1297 1298 1299 1300<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/grid-chart-in-google-sheets/" target="_blank" rel="noopener noreferrer">How To Create A Grid Chart In Google Sheets</a></p> 1301 1302 1303 1304<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/dynamic-charts-google-sheets/" target="_blank" rel="noopener noreferrer">Creating dynamic charts using Google Sheets drop down menus</a></p> 1305 1306 1307 1308<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/sparklines-in-google-sheets/" target="_blank" rel="noopener noreferrer">Everything you ever wanted to know about Sparklines in Google Sheets</a></p> 1309 1310 1311 1312<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/how-can-i-format-individual-data-points-in-google-sheets-charts/" target="_blank" rel="noopener noreferrer">How can I format individual data points in Google Sheets charts?</a></p> 1313 1314 1315 1316<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/line-graph/" target="_blank" rel="noopener noreferrer">How to create an annotated line graph in Google Sheets</a></p> 1317 1318 1319 1320<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/funnel-charts/" target="_blank" rel="noopener noreferrer">How to create a funnel chart in Google Sheets</a></p> 1321 1322 1323 1324<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/waterfall-charts/" target="_blank" rel="noopener noreferrer">How to create a waterfall chart in Google Sheets</a></p> 1325 1326 1327 1328<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/chart-dynamic-bands/" target="_blank" rel="noopener noreferrer">Web traffic chart with dynamic banding in Google Sheets</a></p> 1329 1330 1331 1332<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/formula-examples/multi-colored-line-charts/" target="_blank" rel="noopener noreferrer">How do I create a multi-colored line chart in Google Sheets?</a></p> 1333 1334 1335 1336<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/scatter-plot-google-sheets/" target="_blank" rel="noopener noreferrer">How to Create a Scatter Plot in Google Sheets</a></p> 1337 1338 1339 1340<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/histogram-in-google-sheets/" target="_blank" rel="noopener noreferrer">How to make a Histogram in Google Sheets and overlay a Normal Distribution Curve</a></p> 1341 1342 1343 1344<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/dot-plots-in-google-sheets/" target="_blank" rel="noopener">Dot Plots in Google Sheets</a></p> 1345 1346 1347 1348<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/heat-map-in-google-sheets/" target="_blank" rel="noopener">How To Create A Heat Map In Google Sheets</a></p> 1349 1350 1351 1352<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/bullet-chart-in-google-sheets/" target="_blank" rel="noopener">Bullet Chart in Google Sheets with Sparklines and Named Functions</a></p> 1353 1354 1355 1356<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/formula-pie-charts/" target="_blank" rel="noopener">Formula Pie Charts in Google Sheets</a></p> 1357 1358 1359 1360<h3 class="wp-block-heading">Dashboards in Google Sheets</h3> 1361 1362 1363 1364<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/10-techniques-google-sheets-dashboard/" target="_blank" rel="noopener noreferrer">10 techniques for building a Google Sheets dashboard</a></p> 1365 1366 1367 1368<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/dashboard/dashboard-design/" target="_blank" rel="noopener noreferrer">Dashboard Design Checklist: From a Blank Google Sheet to Business Insights</a></p> 1369 1370 1371 1372<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/budget-templates/" target="_blank" rel="noopener noreferrer">10 techniques to use when building budget templates in Google Sheets</a></p> 1373 1374 1375 1376<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/dashboard/ejunkie/" target="_blank" rel="noopener noreferrer">How to build a real-time sales dashboard for E-junkie using Google Sheets and Apps Script</a></p> 1377 1378 1379 1380<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/building-a-dynamic-dashboard-for-a-3-day-digital-flash-sale/" target="_blank" rel="noopener noreferrer">Building a dynamic dashboard for a 3-day digital flash sale</a></p> 1381 1382 1383 1384<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/creating-a-custom-google-analytics-report-in-a-google-spreadsheet/" target="_blank" rel="noopener noreferrer">Creating a custom Google Analytics report in a Google spreadsheet</a></p> 1385 1386 1387 1388<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/dynamic-dashboard-in-google-spreadsheets/" target="_blank" rel="noopener noreferrer">Creating a dynamic dashboard in Google Spreadsheets to track sales for a digital product launch</a></p> 1389 1390 1391 1392<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/google-sheets-visual-dashboard-design/" target="_blank" rel="noopener">Making Google Sheets look less like⦠Google Sheets</a></p> 1393 1394 1395 1396<h3 class="wp-block-heading">Other articles about Google Sheets</h3> 1397 1398 1399 1400<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/smart-chips-in-google-sheets/" target="_blank" rel="noopener">
1400The Complete Guide to Smart Chips in Google Sheets</a></p> 1401 1402 1403 1404<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/no-code/glide-app-harpers-ferry-trails/" target="_blank" rel="noopener">How I Built A Glide App And Turned My Google Sheet Into A Simple No-Code App</a></p> 1405 1406 1407 1408<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/tiller/" target="_blank" rel="noopener noreferrer">How we manage our family finances with Google Sheets</a></p> 1409 1410 1411 1412<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/sheets-location/" target="_blank" rel="noopener noreferrer">Explaining syntax differences in your formulas due to your Google Sheets location</a></p> 1413 1414 1415 1416<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/productivity-tips-for-google-sheets/" target="_blank" rel="noopener noreferrer">6 Killer Productivity Tips for Google Sheets</a><a id="math"></a></p> 1417 1418 1419 1420<h3 class="wp-block-heading">Mathematics in Google Sheets</h3> 1421 1422 1423 1424<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/logistic-map/" target="_blank" rel="noopener">Exploring Population Growth And Chaos Theory With The Logistic Map, In Google Sheets</a></p> 1425 1426 1427 1428<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/cantor-set-in-google-sheets/" target="_blank" rel="noopener">How To Draw The Cantor Set In Google Sheets</a></p> 1429 1430 1431 1432<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/pi-function/" target="_blank" rel="noopener">PI Function in Google Sheets And Other Fun Ï Facts</a></p> 1433 1434 1435 1436<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/complex-numbers-in-google-sheets/" target="_blank" rel="noopener noreferrer">Complex Numbers In Google Sheets</a></p> 1437 1438 1439 1440<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/how-to-draw-the-mandelbrot-set/" target="_blank" rel="noopener noreferrer">How To Draw The MandelBrot Set In Google Sheets, Using Only Formulas</a></p> 1441 1442 1443 1444<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/sierpinski-triangle-in-google-sheets/" target="_blank" rel="noopener">How To Draw The SierpiÅski Triangle In Google Sheets</a></p> 1445 1446 1447 1448<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/fact-function/" target="_blank" rel="noopener">The FACT Function in Google Sheets (And Why A Shuffled Deck of Cards Is Unique)</a></p> 1449 1450 1451 1452<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/recursion-in-google-sheets/#fibonacci" target="_blank" rel="noopener">Recursion and the Fibonacci Sequence</a></p> 1453 1454 1455 1456<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/recursion-in-google-sheets/#prime" target="_blank" rel="noopener">Recursion, Primes and the Sieve of Eratosthenes</a></p> 1457 1458 1459 1460<h3 class="wp-block-heading">Exploration With Google Sheets</h3> 1461 1462 1463 1464<p class="wp-block-paragraph">Interesting projects that push the limits of what you can do in Google Sheets, without coding.</p> 1465 1466 1467 1468<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/chess/" target="_blank" rel="noopener">Play-It-Through Chess Game in a Single Google Sheets Formula</a></p> 1469 1470 1471 1472<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/etch-a-sheet/" target="_blank" rel="noopener">Etch A Sheet In Google Sheets</a></p> 1473 1474 1475 1476<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/google-sheets-formula-clock/" target="_blank" rel="noopener noreferrer">Google Sheets Formula Clock</a></p> 1477 1478 1479 1480<p class="wp-block-paragraph"><a href="https://twitter.com/benlcollins/status/1338914143903092739" target="_blank" rel="noopener">Recreating Visualize Value design work with SPARKLINES</a> (external link to Twitter)</p> 1481 1482 1483 1484<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/google-sheets-advent-calendar/" target="_blank" rel="noopener">Google Sheets Advent Calendar</a></p> 1485 1486 1487 1488<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/join-the-dots/" target="_blank" rel="noopener">Join The Dots Drawing In Google Sheets</a></p> 1489 1490 1491 1492<p class="wp-block-paragraph"><mark>NEW</mark> <a href="https://www.benlcollins.com/spreadsheets/datatype-font/" data-type="post" data-id="21735" target="_blank" rel="noreferrer noopener">Explorations with the Datatype Font</a></p> 1493 1494 1495 1496<h3 class="wp-block-heading">Other Resources for Google Sheets</h3> 1497 1498 1499 1500<p class="wp-block-paragraph"><a href="https://exceltosheets.com/" target="_blank" rel="noopener noreferrer">Excel To Sheets</a> — a dedicated resource to help organizations migrate to Google Sheets from Microsoft Excel.</p> 1501 1502 1503 1504<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/freelance-google-sheets-developer/" target="_blank" rel="noopener">How To Become A Freelance Google Sheets Developer</a></p> 1505 1506 1507 1508<h3 class="wp-block-heading">Google Sheets Courses</h3> 1509 1510 1511 1512<p class="wp-block-paragraph"><a href="https://courses.benlcollins.com/p/google-sheets-essentials/" target="_blank" rel="noopener noreferrer">Google Sheets Essentials (beginner course)</a></p> 1513 1514 1515 1516<p class="wp-block-paragraph"><a href="https://courses.benlcollins.com/p/data-analysis-with-google-sheets" target="_blank" rel="noopener noreferrer">Data Analysis in Google Sheets</a></p> 1517 1518 1519 1520<p class="wp-block-paragraph"><a href="https://courses.benlcollins.com/p/dashboards" target="_blank" rel="noopener noreferrer">Build Dashboards with Google Sheets</a></p> 1521 1522 1523 1524<p class="wp-block-paragraph"><a href="https://courses.benlcollins.com/p/pivot-tables" target="_blank" rel="noopener noreferrer">Pivot Tables in Google Sheets</a></p> 1525 1526 1527 1528<p class="wp-block-paragraph"><a href="https://courses.benlcollins.com/p/google-sheets-regex-formula-cookbook/" target="_blank" rel="noopener">The Google Sheets REGEX Formula Cookbook</a></p> 1529 1530 1531 1532<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/advanced-formulas-course/" target="_blank" rel="noopener noreferrer">Advanced Formulas – 30 Day Challenge</a> (a free course)</p> 1533 1534 1535 1536<hr class="wp-block-separator has-alpha-channel-opacity"/> 1537 1538 1539 1540<p class="wp-block-paragraph"> </p> 1541 1542 1543 1544<h2 class="wp-block-heading"><figure><img decoding="async" class="alignnone size-thumbnail wp-image-21303" src="https://www.benlcollins.com/wp-content/uploads/2025/01/Google_Apps_Script.svg_.png" alt="Google Apps Script" width="100" height="100"></figure>Apps Script Articles</h2> 1545 1546 1547 1548<h3 class="wp-block-heading">Getting Started Guides for Apps Script</h3> 1549 1550 1551 1552<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/macros/" target="_blank" rel="noopener noreferrer">The complete guide to simple automation in Google Sheets, using Macros</a></p> 1553 1554 1555 1556<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/beginner-guide-to-google-apps-script/" target="_blank" rel="noopener noreferrer">Google Apps Script: A Beginner’
1556s Guide</a></p> 1557 1558 1559 1560<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/repeatable-task/" target="_blank" rel="noopener">Repeatable Task: To Script Or Not To Script, That Is The Question</a></p> 1561 1562 1563 1564<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/google-apps-script-ide/" target="_blank" rel="noopener noreferrer">A Guide To The New Google Apps Script IDE</a></p> 1565 1566 1567 1568<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/api-tutorial-for-beginners/" target="_blank" rel="noopener noreferrer">API Tutorial For Beginners With Google Sheets & Apps Script</a></p> 1569 1570 1571 1572<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/coding-tips/" target="_blank" rel="noopener noreferrer">10 Coding Tips For Beginners With Apps Script</a></p> 1573 1574 1575 1576<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/google-sheets-button/" target="_blank" rel="noopener noreferrer">Add A Google Sheets Button To Run Scripts</a></p> 1577 1578 1579 1580<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/merge-cells/#AppsScript" target="_blank" rel="noopener noreferrer">Finding Merged Cells In Your Google Sheet using Apps Script</a></p> 1581 1582 1583 1584<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/sheet-sizer/" target="_blank" rel="noopener">Sheet Sizer! Build A Tool To Measure Your Google Sheets Size With Apps Script</a></p> 1585 1586 1587 1588<h3 class="wp-block-heading">Using Apps Script to automate Google Workspace</h3> 1589 1590 1591 1592<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/radio-buttons-in-google-sheets/" target="_blank" rel="noopener">Radio Buttons in Google Sheets: Only One Checkbox Checked</a></p> 1593 1594 1595 1596<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/google-sheets-sort-by-color-or-filter-by-color/" target="_blank" rel="noopener noreferrer">Google Sheets Sort By Color And Google Sheets Filter By Color</a></p> 1597 1598 1599 1600<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/saving-data-in-google-sheets/" target="_blank" rel="noopener noreferrer">How To Save Data In Google Sheets With Timestamps Using Apps Script</a></p> 1601 1602 1603 1604<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/time-triggers/" target="_blank" rel="noopener noreferrer">How to set up time-based triggers to run your Apps Script code</a></p> 1605 1606 1607 1608<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/index-sheet/" target="_blank" rel="noopener noreferrer">How to add a hyperlinked index sheet or sidebar to your large Google Sheet workbooks</a></p> 1609 1610 1611 1612<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/extract-email-from-gmail/" target="_blank" rel="noopener noreferrer">How to extract email addresses tagged with a specific Gmail label</a></p> 1613 1614 1615 1616<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/gmail-mail-merge-for-a-specific-label-with-apps-script/" target="_blank" rel="noopener noreferrer">Gmail Mail Merge For A Specific Label With Apps Script</a></p> 1617 1618 1619 1620<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/google-forms-survey-tool/" target="_blank" rel="noopener noreferrer">How to reply to Google Forms survey responses quickly with Sheets & Apps Script</a></p> 1621 1622 1623 1624<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/waterfall-charts/#waterfall_script" target="_blank" rel="noopener noreferrer">How to automatically create waterfall charts using Apps Script</a></p> 1625 1626 1627 1628<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/funnel-charts/#funnel_script" target="_blank" rel="noopener noreferrer">How to automatically create funnel charts using Apps Script</a></p> 1629 1630 1631 1632<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/line-graph/#animate" target="_blank" rel="noopener noreferrer">One way to animate a chart in Google Sheets</a></p> 1633 1634 1635 1636<h3 class="wp-block-heading">Working with external services using Apps Script</h3> 1637 1638 1639 1640<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/api-authentication-apps-script-reference/" target="_blank" rel="noopener">API Authentication Apps Script Reference</a></p> 1641 1642 1643 1644<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/convertkit-report/" target="_blank" rel="noopener">How To Build An Automated ConvertKit Report In Google Sheets Using Apps Script</a></p> 1645 1646 1647 1648<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/teachable-api/" target="_blank" rel="noopener">How To Connect To The Teachable API With Apps Script</a></p> 1649 1650 1651 1652<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/fathom-analytics-api/" target="_blank" rel="noopener">How To Get Fathom Analytics Data Into Google Sheets, Using Apps Script</a></p> 1653 1654 1655 1656<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/nest-thermostat/" target="_blank" rel="noopener">Control Your Nest Thermostat And Build A Temperature Logger In Google Sheets Using Apps Script</a></p> 1657 1658 1659 1660<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/tables/sentiment-analysis-google-tables/" target="_blank" rel="noopener noreferrer">Sentiment Analysis For Google Tables Using Apps Script</a></p> 1661 1662 1663 1664<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/tables/google-tables-apps-script-bot/" target="_blank" rel="noopener">Data Enrichment with the Google Tables Apps Script Bot</a> (Mattermark API)</p> 1665 1666 1667 1668<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/strava-api-with-google-sheets/" target="_blank" rel="noopener noreferrer">How to connect the Strava API with Google Sheets and Data Studio</a></p> 1669 1670 1671 1672<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/marking-template/" target="_blank" rel="noopener noreferrer">Google Sheets Slack bot: how to push data from your Google Sheets into the popular messaging app</a></p> 1673 1674 1675 1676<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/crunchbase/" target="_blank" rel="noopener noreferrer">Connecting to the Crunchbase API with Google Sheets</a></p> 1677 1678 1679 1680<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/mailchimp-integration/" target="_blank" rel="noopener noreferrer">Google Sheets and Mailchimp integration using Apps Script</a></p> 1681 1682 1683 1684<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/oauth-github/" target="_blank" rel="noopener noreferrer">Show data from the GitHub API in Google Sheets, using Apps Script and Oauth</a></p> 1685 1686 1687 1688<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/dashboard/ejunkie/" target="_blank" rel="noopener noreferrer">How to build a real-time sales dashboard for E-junkie using Google Sheets and Apps Script</a></p> 1689 1690 1691 1692<p class="wp-block-paragraph"><a href="https://davidwalsh.name/using-slack-slash-commands-to-send-data-from-slack-into-google-sheets" target="_blank" rel="noopener">Using Slack Slash Commands to Send Data from Slack into Google Sheets</a> (guest post on external site)</p> 1693 1694 1695 1696<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/data-studio/community-connector/#AppsScript" target="_blank" rel="noopener noreferrer">How to create a Data Studio Community Connector with Apps Script</a></p> 1697 1698 1699 1700<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/how-to-connect-google-sheets-to-a-database/" target="_blank" rel="noopener noreferrer">How To Connect Google Sheets To A Database, Using Apps Script</a></p> 1701 1702 1703 1704<h3 class="wp-block-heading">D3 and Google Chart API</h3> 1705 1706 1707 1708<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/d3-google-sheets/" target="_blank" rel="noopener noreferrer">Google Sheets and D3 charts</a></p> 1709 1710 1711 1712<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/javascript/tufte-chart-google/" target="_blank" rel="noopener noreferrer">Recreating Tufteâs famous temperature chart with the Google Chart API</a></p> 1713 1714 1715 1716<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/javascript/animated-temp-chart/" target="_blank" rel="noopener noreferrer">Animated temperature chart using the Google Chart API</a></p> 1717 1718 1719 1720<h3 class="wp-block-heading">Other Apps Script Resources</h3> 1721 1722 1723 1724<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/analytics/track-link-clicks/" target="_blank" rel="noopener">How To Track Link Clicks With Apps Script And Google Sheets</a></p> 1725 1726 1727 1728<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/apps-script-v8-runtime/" target="_blank" rel="noopener noreferrer">Apps Script V8 Runtime Is Here! What Does That Mean?</a></p> 1729 1730 1731 1732<p class="wp-block-paragraph">Check out my <a href="https://github.com/benlcollins/apps_script" target="_blank" rel="noopener noreferrer">apps script</a> and <a href="https://github.com/benlcollins/apps_script_apis" target="_blank" rel="noopener noreferrer">apps script API</a> repositories on GitHub.</p> 1733 1734 1735 1736<h3 class="wp-block-heading">Apps Script Courses</h3> 1737 1738 1739 1740<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script-course/" target="_blank" rel="noopener noreferrer">Apps Script Taster</a>: a free, introductory course</p> 1741 1742 1743 1744<p class="wp-block-paragraph"><a href="https://courses.benlcollins.com/p/beginner-apps-script" target="_blank" rel="noopener">Beginner Apps Script</a>: a fun and practical way to master the foundations of Apps Script</p> 1745 1746 1747 1748<p class="wp-block-paragraph"><a href="https://courses.benlcollins.com/p/automation-with-apps-script" target="_blank" rel="noopener noreferrer">Automation With Apps Script</a>
1748: learn how to automate workflows in Google Workspace and work with external APIs<a id="OtherGoogleTools"></a></p> 1749 1750 1751 1752<hr class="wp-block-separator has-alpha-channel-opacity"/> 1753 1754 1755 1756<h2 class="wp-block-heading">ð§ Other Google Tools I Work With</h2> 1757 1758 1759 1760<h3 class="wp-block-heading">Google Tables</h3> 1761 1762 1763 1764<p class="wp-block-paragraph">Tableâs features and capabilities are now integrated into AppSheet. Read more <a href="https://support.google.com/area120-tables/answer/10831919" target="_blank" rel="noopener">here</a>.</p> 1765 1766 1767 1768<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/tables/google-tables/" target="_blank" rel="noopener noreferrer">Google Tables: How I Use Googleâs New Workflow Tool</a></p> 1769 1770 1771 1772<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/tables/sentiment-analysis-google-tables/" target="_blank" rel="noopener noreferrer">Sentiment Analysis For Google Tables Using Apps Script</a></p> 1773 1774 1775 1776<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/tables/google-tables-apps-script-bot/" target="_blank" rel="noopener">Data Enrichment with the Google Tables Apps Script Bot</a></p> 1777 1778 1779 1780<h3 class="wp-block-heading">Google BigQuery</h3> 1781 1782 1783 1784<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/bigquery/get-started-with-google-bigquery/" target="_blank" rel="noopener">Beyond Sheets: Get Started With Google BigQuery</a></p> 1785 1786 1787 1788<h3 class="wp-block-heading">Looker (formerly Data Studio) Articles</h3> 1789 1790 1791 1792<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/dashboard/google-data-studio-intro/" target="_blank" rel="noopener noreferrer">An introduction to Data Studio</a></p> 1793 1794 1795 1796<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/strava-api-with-google-sheets/" target="_blank" rel="noopener noreferrer">How to connect the Strava API with Google Sheets and Data Studio</a></p> 1797 1798 1799 1800<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/dashboard/google-data-studio-tips/" target="_blank" rel="noopener noreferrer">6 advanced techniques in Data Studio</a></p> 1801 1802 1803 1804<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/data-studio/community-connector/" target="_blank" rel="noopener noreferrer">Community connectors to access any data in Data Studio</a></p> 1805 1806 1807 1808<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/data-studio/connector-fields/" target="_blank" rel="noopener noreferrer">Data Studio Connector fields get an update</a></p> 1809 1810 1811 1812<h3 class="wp-block-heading">Google Sites</h3> 1813 1814 1815 1816<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/sites/how-to-use-google-sheets-in-your-google-sites/" target="_blank" rel="noopener">How to Use Google Sheets in Your Google Sites</a></p> 1817 1818 1819 1820<hr class="wp-block-separator has-alpha-channel-opacity"/> 1821 1822 1823 1824<h2 class="wp-block-heading">ð Other articles</h2> 1825 1826 1827 1828<h3 class="wp-block-heading">Annual Reviews</h3> 1829 1830 1831 1832<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/2025-review-2026-aim/" target="_blank" rel="noopener">2025 In Review And A Look Forward To 2026</a></p> 1833 1834 1835 1836<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/2024-review-2025-aim/" target="_blank" rel="noopener">2024 In Review And A Look Forward To 2025</a></p> 1837 1838 1839 1840<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/2023-review-2024-aim/" target="_blank" rel="noopener">2023 In Review And A Look Forward To 2024</a></p> 1841 1842 1843 1844<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/2022-review-2023-aim/" target="_blank" rel="noopener">2022 In Review And A Look Forward To 2023</a></p> 1845 1846 1847 1848<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/2021-review-2022-aim/" target="_blank" rel="noopener">2021 In Review And A Look Forward To 2022</a></p> 1849 1850 1851 1852<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/2020-review-2021-aim/" target="_blank" rel="noopener">2020 In Review And A Look Forward To 2021</a></p> 1853 1854 1855 1856<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/2019-review-2020-aim/" target="_blank" rel="noopener noreferrer">2019 in review and a look forward to 2020</a></p> 1857 1858 1859 1860<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/2018-review-2019-aim/" target="_blank" rel="noopener noreferrer">2018 in review and a look forward to 2019</a></p> 1861 1862 1863 1864<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/2017-review-2018-aim/" target="_blank" rel="noopener noreferrer">2017 in review and a look forward to 2018</a></p> 1865 1866 1867 1868<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/2016-review-2017-aim/" target="_blank" rel="noopener noreferrer">2016 in review and a look forward to 2017</a></p> 1869 1870 1871 1872<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/2015-review-2016-aim/" target="_blank" rel="noopener noreferrer">2015 in review and a look forward to 2016</a></p> 1873 1874 1875 1876<h3 class="wp-block-heading">SheetsCon: Online Google Sheets Conference</h3> 1877 1878 1879 1880<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/sheetscon-2020-onl
1880ine-conference-lessons/" target="_blank" rel="noopener noreferrer">SheetsCon 2020: Lessons Learned Running An Online Conference For 6,700 People</a></p> 1881 1882 1883 1884<h3 class="wp-block-heading">Google Cloud Next Conference Recaps</h3> 1885 1886 1887 1888<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/recap-next-19/" target="_blank" rel="noopener noreferrer">Recap From Google Cloud Next â19 Conference</a></p> 1889 1890 1891 1892<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/google-next-19/" target="_blank" rel="noopener noreferrer">Google Next 19 Conference â Live Blog</a></p> 1893 1894 1895 1896<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/recap-next-18/" target="_blank" rel="noopener noreferrer">Recap From Google Cloud Next â18 Conference</a></p> 1897 1898 1899 1900<h3 class="wp-block-heading">Essays</h3> 1901 1902 1903 1904<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/a-behind-the-scenes-look-at-how-i-create-a-technical-video-course/" target="_blank" rel="noopener">A Behind The Scenes Look At How I Create A Technical Video Course</a></p> 1905 1906 1907 1908<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/benefits-of-cohort-based-courses/" target="_blank" rel="noopener">Three Benefits Of Cohort-Based Courses</a></p> 1909 1910 1911 1912<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/5-insights-from-cohort-based-courses/" target="_blank" rel="noopener">5 Insights From Taking A Live Cohort-Based Course (And How Iâm Applying Them To My Own)</a></p> 1913 1914 1915 1916<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/student-learning-loop/" target="_blank" rel="noopener">Create A Student Learning Loop In Your Cohort-Based Course</a></p> 1917 1918 1919 1920<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/journey/" target="_blank" rel="noopener">I Left My Corporate Accounting Job 7 Years Ago. Hereâs How I Built A Career As An Educational Entrepreneur</a></p> 1921 1922 1923 1924<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/thoughts-on-productivity/" target="_blank" rel="noopener noreferrer">Thoughts on productivity</a></p> 1925 1926 1927 1928<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/office/" target="_blank" rel="noopener noreferrer">In Pursuit Of A Dream</a></p> 1929 1930 1931 1932<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/google-sheets-excel-story/" target="_blank" rel="noopener noreferrer">If Google Sheets And Microsoft Excel Went For A Drinkâ¦</a></p> 1933 1934 1935 1936<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/general/dream-office/" target="_blank" rel="noopener">Dream Home Office Setup</a></p> 1937 1938 1939 1940<h3 class="wp-block-heading">SQL</h3> 1941 1942 1943 1944<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/sql/six-reasons-to-start-learning-sql/" target="_blank" rel="noopener noreferrer">Six reasons to start learning SQL</a></p> 1945 1946 1947 1948<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/apps-script/how-to-connect-google-sheets-to-a-database/" target="_blank" rel="noopener noreferrer">How To Connect Google Sheets To A SQL Database, Using Apps Script</a></p> 1949 1950 1951 1952<h3 class="wp-block-heading">Excel</h3> 1953 1954 1955 1956<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/excel-bump-chart/" target="_blank" rel="noopener noreferrer">Excel tutorial: build a dynamic bump chart of the English Premier League</a></p> 1957 1958 1959 1960<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/excel-political-dashboard-tutorial/" target="_blank" rel="noopener noreferrer">Excel tutorial: Building a dynamic, animated dashboard for U.S. political data</a></p> 1961 1962 1963 1964<p class="wp-block-paragraph"><a href="https://www.benlcollins.com/spreadsheets/10-productivity-tips-excel/" target="_blank" rel="noopener noreferrer">Excel-fficiency: 10 tips for boosting productivity in Excel</a></p> 1965 </div><!-- .entry-content --> 1966 1967 1968</article><!-- #post-7246 --> 1969 1970 </main><!-- .site-main --> 1971 </div><!-- .content-area --> 1972 1973 1974 </div><!-- .site-content --> 1975 1976 <footer data-wpr-lazyrender="1" id="colophon" class="site-footer"> 1977 <div class="site-info"> 1978 <a class="privacy-policy-link" href="https://www.benlcollins.com/privacy/" rel="privacy-policy">Privacy Policy</a><span role="separator" aria-hidden="true"></span> <a href="https://wordpress.org/" class="imprint"> 1979 Proudly powered by WordPress </a> 1980 </div><!-- .site-info --> 1981 </footer><!-- .site-footer --> 1982 1983</div><!-- .site --> 1984
1985<script type="speculationrules"> 1986{"prefetch":[{"source":"document","where":{"and":[{"href_matches":"/*"},{"not":{"href_matches":["/wp-*.php","/wp-admin/*","/wp-content/uploads/*","/wp-content/*","/wp-content/plugins/*","/wp-content/themes/twentyfifteen/*","/*\\?(.+)"]}},{"not":{"selector_matches":"a[rel~=\"nofollow\"]"}},{"not":{"selector_matches":".no-prefetch, .no-prefetch a"}}]},"eagerness":"conservative"}]} 1987</script>
1987 1988<div class="simple-banner simple-banner-text" style="display:none !important"></div>
1988<script id="convertkit-js-js-extra"> 1989var convertkit_broadcasts = {"ajax_url":"https://www.benlcollins.com/wp-json/kit/v1/broadcasts","debug":""}; 1990var convertkit = {"debug":"","subscriber_id":"0"}; 1991//# sourceURL=convertkit-js-js-extra 1992</script>
vendor: 1 bytes, line 1992
1992
1993<script id="convertkit-js-js" src="https://www.benlcollins.com/wp-content/plugins/convertkit/resources/frontend/js/dist/frontend.min.js?ver=3.4.1"></script>
vendor: 1 bytes, line 1993
1993
1994<script id="rocket-browser-checker-js-after"> 1995"use strict";var _createClass=function(){function defineProperties(target,props){for(var i=0;i<props.length;i++){var descriptor=props[i];descriptor.enumerable=descriptor.enumerable||!1,descriptor.configurable=!0,"value"in descriptor&&(descriptor.writable=!0),Object.defineProperty(target,descriptor.key,descriptor)}}return function(Constructor,protoProps,staticProps){return protoProps&&defineProperties(Constructor.prototype,protoProps),staticProps&&defineProperties(Constructor,staticProps),Constructor}}();function _classCallCheck(instance,Constructor){if(!(instance instanceof Constructor))throw new TypeError("Cannot call a class as a function")}var RocketBrowserCompatibilityChecker=function(){function RocketBrowserCompatibilityChecker(options){_classCallCheck(this,RocketBrowserCompatibilityChecker),this.passiveSupported=!1,this._checkPassiveOption(this),this.options=!!this.passiveSupported&&options}return _createClass(RocketBrowserCompatibilityChecker,[{key:"_checkPassiveOption",value:function(self){try{var options={get passive(){return!(self.passiveSupported=!0)}};window.addEventListener("test",null,options),window.removeEventListener("test",null,options)}catch(err){self.passiveSupported=!1}}},{key:"initRequestIdleCallback",value:function(){!1 in window&&(window.requestIdleCallback=function(cb){var start=Date.now();return setTimeout(function(){cb({didTimeout:!1,timeRemaining:function(){return Math.max(0,50-(Date.now()-start))}})},1)}),!1 in window&&(window.cancelIdleCallback=function(id){return clearTimeout(id)})}},{key:"isDataSaverModeOn",value:function(){return"connection"in navigator&&!0===navigator.connection.saveData}},{key:"supportsLinkPrefetch",value:function(){var elem=document.createElement("link");return elem.relList&&elem.relList.supports&&elem.relList.supports("prefetch")&&window.IntersectionObserver&&"isIntersecting"in IntersectionObserverEntry.prototype}},{key:"isSlowConnection",value:function(){return"connection"in navigator&&"effectiveType"in navigator.connection&&("2g"===navigator.connection.effectiveType||"slow-2g"===navigator.connection.effectiveType)}}]),RocketBrowserCompatibilityChecker}(); 1996//# sourceURL=rocket-browser-checker-js-after 1997</script>
vendor: 1 bytes, line 1997
1997
1998<script id="rocket-preload-links-js-extra"> 1999var RocketPreloadLinksConfig = {"excludeUris":"/p/platform.js/|/(?:.+/)?feed(?:/(?:.+/?)?)?$|/(?:.+/)?embed/|/(index.php/)?(.*)wp-json(/.*|$)|/refer/|/go/|/recommend/|/recommends/","usesTrailingSlash":"1","imageExt":"jpg|jpeg|gif|png|tiff|bmp|webp|avif|pdf|doc|docx|xls|xlsx|php","fileExt":"jpg|jpeg|gif|png|tiff|bmp|webp|avif|pdf|doc|docx|xls|xlsx|php|html|htm","siteUrl":"https://www.benlcollins.com","onHoverDelay":"100","rateThrottle":"3"}; 2000//# sourceURL=rocket-preload-links-js-extra 2001</script>
vendor: 1 bytes, line 2001
2001
2002<script id="rocket-preload-links-js-after"> 2003(function() { 2004"use strict";var r="function"==typeof Symbol&&"symbol"==typeof Symbol.iterator?function(e){return typeof e}:function(e){return e&&"function"==typeof Symbol&&e.constructor===Symbol&&e!==Symbol.prototype?"symbol":typeof e},e=function(){function i(e,t){for(var n=0;n<t.length;n++){var i=t[n];i.enumerable=i.enumerable||!1,i.configurable=!0,"value"in i&&(i.writable=!0),Object.defineProperty(e,i.key,i)}}return function(e,t,n){return t&&i(e.prototype,t),n&&i(e,n),e}}();function i(e,t){if(!(e instanceof t))throw new TypeError("Cannot call a class as a function")}var t=function(){function n(e,t){i(this,n),this.browser=e,this.config=t,this.options=this.browser.options,this.prefetched=new Set,this.eventTime=null,this.threshold=1111,this.numOnHover=0}return e(n,[{key:"init",value:function(){!this.browser.supportsLinkPrefetch()||this.browser.isDataSaverModeOn()||this.browser.isSlowConnection()||(this.regex={excludeUris:RegExp(this.config.excludeUris,"i"),images:RegExp(".("+this.config.imageExt+")$","i"),fileExt:RegExp(".("+this.config.fileExt+")$","i")},this._initListeners(this))}},{key:"_initListeners",value:function(e){-1<this.config.onHoverDelay&&document.addEventListener("mouseover",e.listener.bind(e),e.listenerOptions),document.addEventListener("mousedown",e.listener.bind(e),e.listenerOptions),document.addEventListener("touchstart",e.listener.bind(e),e.listenerOptions)}},{key:"listener",value:function(e){var t=e.target.closest("a"),n=this._prepareUrl(t);if(null!==n)switch(e.type){case"mousedown":case"touchstart":this._addPrefetchLink(n);break;case"mouseover":this._earlyPrefetch(t,n,"mouseout")}}},{key:"_earlyPrefetch",value:function(t,e,n){var i=this,r=setTimeout(function(){if(r=null,0===i.numOnHover)setTimeout(function(){return i.numOnHover=0},1e3);else if(i.numOnHover>i.config.rateThrottle)return;i.numOnHover++,i._addPrefetchLink(e)},this.config.onHoverDelay);t.addEventListener(n,function e(){t.removeEventListener(n,e,{passive:!0}),null!==r&&(clearTimeout(r),r=null)},{passive:!0})}},{key:"_addPrefetchLink",value:function(i){return this.prefetched.add(i.href),new Promise(function(e,t){var n=document.createElement("link");n.rel="prefetch",n.href=i.href,n.onload=e,n.onerror=t,document.head.appendChild(n)}).catch(function(){})}},{key:"_prepareUrl",value:function(e){if(null===e||"object"!==(void 0===e?"undefined":r(e))||!1 in e||-1===["http:","https:"].indexOf(e.protocol))return null;var t=e.href.substring(0,this.config.siteUrl.length),n=this._getPathname(e.href,t),i={original:e.href,protocol:e.protocol,origin:t,pathname:n,href:t+n};return this._isLinkOk(i)?i:null}},{key:"_getPathname",value:function(e,t){var n=t?e.substring(this.config.siteUrl.length):e;return n.startsWith("/")||(n="/"+n),this._shouldAddTrailingSlash(n)?n+"/":n}},{key:"_shouldAddTrailingSlash",value:function(e){return this.config.usesTrailingSlash&&!e.endsWith("/")&&!this.regex.fileExt.test(e)}},{key:"_isLinkOk",value:function(e){return null!==e&&"object"===(void 0===e?"undefined":r(e))&&(!this.prefetched.has(e.href)&&e.origin===this.config.siteUrl&&-1===e.href.indexOf("?")&&-1===e.href.indexOf("#")&&!this.regex.excludeUris.test(e.href)&&!this.regex.images.test(e.href))}}],[{key:"run",value:function(){"undefined"!=typeof RocketPreloadLinksConfig&&new n(new RocketBrowserCompatibilityChecker({capture:!0,passive:!0}),RocketPreloadLinksConfig).init()}}]),n}();t.run(); 2005}()); 2006 2007//# sourceURL=rocket-preload-links-js-after 2008</script>
vendor: 1 bytes, line 2008
2008
2009<script id="quicktags-js-extra"> 2010var quicktagsL10n = {"closeAllOpenTags":"Close all open tags","closeTags":"close tags","enterURL":"Enter the URL","enterImageURL":"Enter the URL of the image","enterImageDescription":"Enter a description of the image","textdirection":"text direction","toggleTextdirection":"Switch Editor Text Direction","dfw":"Distraction-free writing mode","strong":"Bold","strongClose":"Close bold tag","em":"Italic","emClose":"Close italic tag","link":"Insert link","blockquote":"Blockquote","blockquoteClose":"Close blockquote tag","del":"Deleted text (strikethrough)","delClose":"Close deleted text tag","ins":"Inserted text","insClose":"Close inserted text tag","image":"Insert image","ul":"Bulleted list","ulClose":"Close bulleted list tag","ol":"Numbered list","olClose":"Close numbered list tag","li":"List item","liClose":"Close list item tag","code":"Code","codeClose":"Close code tag","more":"Insert Read More tag"}; 2011//# sourceURL=quicktags-js-extra 2012</script>
vendor: 1 bytes, line 2012
2012
2013<script id="quicktags-js" src="https://www.benlcollins.com/wp-includes/js/quicktags.min.js?ver=7.1.1"></script>
vendor: 1 bytes, line 2013
2013
2014<script id="convertkit-admin-quicktags-js-extra"> 2015var convertkit_quicktags = {"broadcasts":{"title":"Kit Broadcasts","icon":"resources/backend/images/block-icon-broadcasts.svg","attributes":{"display_grid":{"type":"boolean","default":false},"display_order":{"type":"string","default":"date-broadcast"},"date_format":{"type":"string","default":"F j, Y"},"display_image":{"type":"boolean","default":false},"display_description":{"type":"boolean","default":false},"display_read_more":{"type":"boolean","default":false},"read_more_label":{"type":"string","default":"Read more"},"limit":{"type":"number","default":10},"page":{"type":"number","default":1},"paginate":{"type":"boolean","default":false},"paginate_label_prev":{"type":"string","default":"Previous"},"paginate_label_next":{"type":"string","default":"Next"},"style":{"type":"object"},"backgroundColor":{"type":"string"},"textColor":{"type":"string"},"fontSize":{"type":"string"},"is_gutenberg_example":{"type":"boolean","default":false}},"render_callback":[{},"render"]},"content":{"title":"Kit Custom Content","icon":"resources/backend/images/block-icon-content.svg","attributes":{"tag":{"type":"string"}},"render_callback":[{},"render"]},"formtrigger":{"title":"Kit Form Trigger","icon":"resources/backend/images/block-icon-formtrigger.svg","attributes":{"form":{"type":"string","default":""},"text":{"type":"string","default":"Subscribe"},"style":{"type":"object"},"backgroundColor":{"type":"string"},"textColor":{"type":"string"},"fontSize":{"type":"string"},"is_gutenberg_example":{"type":"boolean","default":false}},"render_callback":[{},"render"]},"form":{"title":"Kit Form","icon":"resources/backend/images/block-icon-form.svg","attributes":{"form":{"type":"string"},"align":{"type":"string"},"style":{"type":"object"},"backgroundColor":{"type":"string"},"is_gutenberg_example":{"type":"boolean","default":false}},"render_callback":[{},"render"]},"product":{"title":"Kit Product","icon":"resources/backend/images/block-icon-product.svg","attributes":{"product":{"type":"string","default":""},"text":{"type":"string","default":"Buy my product"},"discount_code":{"type":"string","default":""},"checkout":{"type":"boolean","default":false},"disable_modal_on_mobile":{"type":"boolean","default":false},"style":{"type":"object"},"backgroundColor":{"type":"string"},"textColor":{"type":"string"},"fontSize":{"type":"string"},"is_gutenberg_example":{"type":"boolean","default":false}},"render_callback":[{},"render"]}}; 2016var convertkit_admin_tinymce = {"ajaxurl":"https://www.benlcollins.com/wp-json/kit/v1/editor/tinymce/modal","nonce":"a2634b599f"}; 2017//# sourceURL=convertkit-admin-quicktags-js-extra 2018</script>
vendor: 1 bytes, line 2018
2018
2019<script id="convertkit-admin-quicktags-js" src="https://www.benlcollins.com/wp-content/plugins/convertkit/resources/backend/js/quicktags.js?ver=3.4.1"></script>
2019 2020
2020<script type="text/template" id="tmpl-convertkit-quicktags-modal"> 2021 <div id="convertkit-quicktags-modal"> 2022 <div class="media-frame-title"><h1></h1></div> 2023 <div class="media-frame-content"></div> 2024 <div class="media-frame-toolbar"> 2025 <div class="media-toolbar"> 2026 <div class="media-toolbar-secondary"> 2027 <button type="button" class="button button-large cancel">Cancel</button> 2028 </div> 2029 <div class="media-toolbar-primary"> 2030 <button type="button" class="button button-primary button-large">Insert</button> 2031 </div> 2032 </div> 2033 </div> 2034 </div> 2035 </script>
2035 2036
2037<script>(function(){function c(){var b=a.contentDocument||(a.contentWindow&&a.contentWindow.document);if(b){var d=b.createElement('script');d.innerHTML="window.__CF$cv$params={r:'a43adb9a39b1d94c',t:'MTc5MDg1MTMxNg=='};var a=document.createElement('script');a.src='/cdn-cgi/challenge-platform/scripts/jsd/main.js';document.getElementsByTagName('head')[0].appendChild(a);";b.getElementsByTagName('head')[0].appendChild(d)}}if(document.body){var a=document.createElement('iframe');a.height=1;a.width=1;a.style.position='absolute';a.style.top=0;a.style.left=0;a.style.border='none';a.style.visibility='hidden';document.body.appendChild(a);if('loading'!==document.readyState)c();else if(window.addEventListener)document.addEventListener('DOMContentLoaded',c);else{var e=document.onreadystatechange||function(){};document.onreadystatechange=function(b){e(b);'loading'!==document.readyState&&(document.onreadystatechange=e,c())}}}})();</script>
2037</body> 2038</html> 2039 2040<!-- This website is like a Rocket, isn't it? Performance optimized by WP Rocket. Learn more: https://wp-rocket.me -->
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.