PageSourceSearch

https://www.benlcollins.com/

html benlcollins.com collected 2026-10-01 10:41:57 UTC 134,725 bytes, 2,040 lines download raw bytes

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 &amp; 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=" &raquo; Feed" href="https://www.benlcollins.com/feed/" />
35<link rel="alternate" type="application/rss+xml" title=" &raquo; 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&#038;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 &amp; 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 &hellip;" 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&#8217;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&#8217;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">&nbsp;</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 &#8211; 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 &amp; 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> &#8212; 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 &#8211; 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">&nbsp;</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&#8217;
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 &amp; 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 &amp; 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.