Google Sheets Tips Newsletter Archive - Google Drive

-
Google Sheets Tips Newsletter Archive - Google Drive








Google Sheets Tips Newsletter Archive - Google Drive





130-Apr-2018Monday Tip: Keyboard Shortcuts in Google Sheets5 keyboard shortcutshttps://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets
27-May-2018Monday Tip: Notifications in Google SheetsGet notifications when a spreadsheet changeshttps://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560017
314-May-2018Monday Tip: Datetime tip in Google SheetsQuickly split datetime with formulashttps://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560021
421-May-2018Monday Tip: Super cool (and clever) way to combine text and numbers in a cellAdd label to number with custom formattinghttps://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560077
511-Jun-2018Monday Tip: Replace numerical IF functions with MIN or MAXReplace numerical IF formulas with MIN or MAX functionshttps://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560093
618-Jun-2018Monday Tip: Quick ways to copy data down a columnQuick ways to fill a whole column (double click, highlight > Cmd + Enter or Cmd + D, quicker than Copy-paste or drag-down)https://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560097
725-Jun-2018Monday Tip: Multiply an entire column with a single 🔥 MMULT formula 🔥MMULT with constant value to quickly multiply column of numbershttps://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560101
82-Jul-2018Monday Tip: The OFFSET function!OFFSET function to move data up columnshttps://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560105
99-Jul-2018Monday G Sheets Tip: Better data entry ✉Control data entry with data validation e.g. email address with custom formula =search("@",F9)>0https://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560109
1016-Jul-2018Monday G Sheets Tip: CHAR-grilled anyone?Top 10(?) CHAR formulas e.g. to get arrows
e.g. ="Cohort "&char(8594)&char(10)&" Months after cohort start "&char(8595)https://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560113
1123-Jul-2018Monday Tip + I learned this the hard way, you don’t have to…Group rows and columnshttps://mailchi.mp/benlcollins/monday-tip-i-learned-this-the-hard-way-you-dont-have-to
1230-Jul-2018[Case Study] Josh’s journey from political campaign director to data analystF4 for relative/absolute and for repeat last commandhttps://mailchi.mp/benlcollins/i-learned-this-the-hard-way-you-dont-have-to-1560149
1320-Aug-2018Monday Tip: Tag people in comments in Google SheetsAlert in commentshttps://mailchi.mp/benlcollins/alert-in-comments
1427-Aug-2018Monday Tip: Conditional Formatting across entire rowHow to apply conditional formatting to whole row (also write quick blog post)https://mailchi.mp/benlcollins/alert-in-comments-1560245
153-Sep-2018🚀 Monday Tip: Trick to round numbers to the nearest ten, hundred, etc.How to round to nearest ten, hundred, thousandhttps://mailchi.mp/benlcollins/round-to-ten
1610-Sep-2018🚀 Monday Tip: Speed up your data entryQuick data entry by highlighting range in advancehttps://mailchi.mp/benlcollins/data-entry-confined-range
1717-Sep-2018🚀 Monday Tip: Generate random letters with the CODE functionGenerate random letters with CODE functionhttps://mailchi.mp/benlcollins/generate-random-letters-code-function
1824-Sep-2018🔆 Monday Tip: Create heatmaps with your dataCreate heatmaps using conditional formattinghttps://mailchi.mp/benlcollins/create-heatmap-with-conditional-formatting
191-Oct-2018🔆 Monday Tip: A Pivot Table tip and resourcesPivot Table Copy trick and resourceshttps://mailchi.mp/benlcollins/pivot-table-tip-and-resources
208-Oct-2018🔆 Monday Tip: Rename Pivot Table column headingsRename Pivot Table headingshttps://mailchi.mp/benlcollins/rename-pivot-table-headings
2115-Oct-2018🔆 Monday Tip: Hyperlink to different parts of your SheetHyperlink to other parts of your Sheethttps://mailchi.mp/benlcollins/hyperlinks-in-sheets
2222-Oct-2018🔆 Monday Tip: Repeat number groups with the ROW & MOD functionsCreate repeating number groups with ROW and MODhttps://mailchi.mp/benlcollins/number-groups-row-mod
2329-Oct-2018🎃 👻 Monday Tip: Create Google Sheets instantlyInstantly create a new Google Sheethttps://mailchi.mp/benlcollins/create-sheets-instantly
245-Nov-2018💪 Monday Tip: Advanced Formula Workout ChallengeAdvanced formula walk throughhttps://mailchi.mp/benlcollins/advanced-formula-workout
2512-Nov-2018🔆 Monday Tip: Neat trick with freeze panes & that surprise from last week...Quickly freeze rows by dragging down top rowhttps://mailchi.mp/benlcollins/freeze-panes-blastoff-surprise
2619-Nov-2018⛔ Monday Tip: Protect individual sheetsProtect individual sheets with Google Sheethttps://mailchi.mp/benlcollins/protect-individual-sheet
2726-Nov-2018Monday Tip: Super handy shortcutQuick create Sheets in folder with Shift + Shttps://mailchi.mp/benlcollins/shift-s-open-new-sheet
283-Dec-2018👉 Monday Tip: Automate your Sheets with MacrosIntroducing Macroshttps://us11.campaign-archive.com/?u=5f850f1ff83cc35ed1ca00348&id=0004cdcffc
2910-Dec-2018👉 Monday Tip: 5 million cells...Introducing 5 million cell limithttps://us11.campaign-archive.com/?u=5f850f1ff83cc35ed1ca00348&id=b7d4d15d32
3017-Dec-2018Monday Google Sheets Tip: Collaboration & FiltersFilter viewshttps://mailchi.mp/benlcollins/filter-views
3124-Dec-2018Monday Google Sheets Tip: Happy Holidays!Christmas tree with the CHAR functionhttps://mailchi.mp/benlcollins/christmas-tree-char
3231-Dec-2018Monday Google Sheets Tip: 2018 draws to a close% of year remaininghttps://mailchi.mp/benlcollins/end-of-2018
337-Jan-2019Google Sheets Tip: Format Individual Data Points In ChartsFormat individual data points in Google Sheets Chartshttps://mailchi.mp/benlcollins/format-individual-chart-points
3414-Jan-2019Google Sheets Tip: Quickly summarize your dataQuick Aggregation Tool, when you highlight datahttps://mailchi.mp/benlcollins/quickly-summarize-your-data
3521-Jan-2019Google Sheets Tip: How To Remove DuplicatesUNIQUE formula to deduphttps://mailchi.mp/benlcollins/how-to-remove-duplicates
3628-Jan-2019Google Sheets Tip: Numbers Starting With ZeroEnter numbers that start with zerohttps://mailchi.mp/benlcollins/numbers-starting-with-zero
374-Feb-2019Google Sheets Tip: Vlookup Formula ChallengeVlookup multiple criteria formula challengehttps://mailchi.mp/benlcollins/nested-tables-vlookup
3811-Feb-2019Google Sheets Tip: Text Trickery 😈Text rotationhttps://mailchi.mp/benlcollins/text-rotation
3918-Feb-2019Google Sheets Tip: Text Trickery Part II 😈Text rotation part IIhttps://mailchi.mp/benlcollins/text-rotation-part-ii
4025-Feb-2019Google Sheets Tip: Hello, how are you?Detect language + Google Translatehttps://mailchi.mp/benlcollins/google-translate-function
414-Mar-2019Google Sheets Tip: ROW/COLUMN functions & Formula Challenge SolutionMultiple images solutionhttps://mailchi.mp/benlcollins/repeated-image-formula
4211-Mar-2019Google Sheets Tip: The Endless Possibilities of Custom FunctionsClearbit API example + Apps Script Coursehttps://mailchi.mp/benlcollins/custom-functions
4325-Mar-2019Google Sheets Tip: A Change of Plans...Change of Plans + Subtotalhttps://mailchi.mp/benlcollins/change-of-plans-subtotal
441-Apr-2019Google Sheets Tip: Year In Progress SparklineSparklineshttps://mailchi.mp/benlcollins/sparkline-year-progress
458-Apr-2019Google Sheets Tip: Find The Most Frequent Word 🔎Find the most frequent wordhttps://mailchi.mp/benlcollins/mode-with-text
4615-Apr-2019Google Sheets Tip: Sneak peek at new stuff coming to Google SheetsNext Recaphttps://mailchi.mp/benlcollins/next-recap
4722-Apr-2019Google Sheets Tip: Macro to show/hide tabsFocus + Unfocus example + Apps Script Coursehttps://mailchi.mp/benlcollins/focus-unfocus
4829-Apr-2019Google Sheets Tip: Night mode anyone? 🌜Change background colors with Apps Scripthttps://mailchi.mp/benlcollins/night-mode-automation-launch
496-May-2019Google Sheets Tip: Create new tabs instantlyShift + F11 to create new tabs in Google Sheetshttps://mailchi.mp/benlcollins/shift-f11
5013-May-2019Google Sheets Tip: Images In CellsImages in cellshttps://mailchi.mp/benlcollins/image-in-cells
5120-May-2019Google Sheets Tip: Remove Duplicates Finally!New data features - Remove duplicateshttps://mailchi.mp/benlcollins/remove-duplicates
5227-May-2019Google Sheets Tip: Show formulasShow all formulas at once, with Ctrl + `https://mailchi.mp/benlcollins/show-formulas
533-Jun-2019Google Sheets Tip: Formula Challenge SolutionsFormula Challenge Resultshttps://mailchi.mp/benlcollins/formula-challenge-solution
5410-Jun-2019Google Sheets Tip: Colorful Sheets! 🌈Use color in Google Sheetshttps://mailchi.mp/benlcollins/add-colors
5517-Jun-2019Google Sheets Tip: More Colorful Sheets! 🌈Use of the MID formula and more colors in Sheetshttps://mailchi.mp/benlcollins/mid-formula-colors
5624-Jun-2019Google Sheets Tip: Quick Entry & Exit With FormulasF2 and Shift + Enter and Escape shortcutshttps://mailchi.mp/benlcollins/formula-entry-exit-shortcuts
571-Jul-2019Google Sheets Tip: Discover New Formulas TodayDiscover a new formula todayhttps://mailchi.mp/benlcollins/discover-new-function
588-Jul-2019Google Sheets Tip: Make Conditional Formatting PermanentApply conditional formatting permanentlyhttps://mailchi.mp/benlcollins/make-conditional-formatting-permanent
5915-Jul-2019Google Sheets Tip: Custom Number Formatting & Coming soon...Custom Number Formattinghttps://mailchi.mp/benlcollins/custom-number-formatting
6022-Jul-2019Google Sheets Tip: Moon Landing 50th Anniversary!Moon landing anniversaryhttps://mailchi.mp/benlcollins/moon-landing
6129-Jul-2019Google Sheets Tip: In Cell Date PickerData Validation Date Pickerhttps://mailchi.mp/benlcollins/in-cell-date-picker
625-Aug-2019Google Sheets Tip: Add Star Rating System ⭐⭐⭐Add Star Ratingshttps://mailchi.mp/benlcollins/star-rating
6312-Aug-2019Google Sheets Tip: Create QR Codes With FormulasCreate QR codes in Sheetshttps://mailchi.mp/benlcollins/qr-codes
6419-Aug-2019Google Sheets Tip: Apps Script Button & 10 Year AnniversaryApps Script 10 Year anniversaryhttps://mailchi.mp/benlcollins/apps-script-button
6526-Aug-2019Google Sheets Tip: QA ChecklistsQA Checklisthttps://mailchi.mp/benlcollins/qa-checklists
662-Sep-2019Google Sheets Tip: Do you use the Parser family of functions?Parser family of functionshttps://mailchi.mp/benlcollins/parser-functions
679-Sep-2019Google Sheets Tip: Manage Apps Script projects from the DashboardApps Script Dashboardhttps://mailchi.mp/benlcollins/apps-script-dashboard
6816-Sep-2019Google Sheets Tip: Brilliant Apps Script keyboard shortcuts 💯Apps Script shortcutshttps://mailchi.mp/benlcollins/apps-script-shortcuts
6923-Sep-2019Google Sheets Tip: Video sidebar with Apps ScriptEmbed videos in sidebarhttps://mailchi.mp/benlcollins/video-sidebar
7030-Sep-2019Google Sheets Tip 70: Extract Hyperlink URLs with a formulaExtract url from hyperlink formulahttps://mailchi.mp/benlcollins/extract-hyperlinks
717-Oct-2019Google Sheets Tip 71: Annotate Line Charts 📈Mark Today on a Line Graphhttps://mailchi.mp/benlcollins/annotate-line-charts
7214-Oct-2019Google Sheets Tip 72: One spicy function 🌶️SEQUENCE functionhttps://mailchi.mp/benlcollins/sequence-function
7321-Oct-2019Google Sheets Tip 73: Date trick that's so easy to miss...Double click date to bring up date pickerhttps://mailchi.mp/benlcollins/date-double-click
7428-Oct-2019Google Sheets Tip 74: A book, a challenge and the RANK function 🎃Find position of a value with RANK functionhttps://mailchi.mp/benlcollins/rank-function
754-Nov-2019Google Sheets Tip 75: A FACT to blow your mind ♣75 Tips Anniversary - special email about the Card sorting Factorial (the lesson I never included in the data analysis course)https://mailchi.mp/benlcollins/google-sheets-tip-75-fact
7611-Nov-2019Google Sheets Tip 76: Control who can edit tabsSetting tab level permissionshttps://mailchi.mp/benlcollins/tab-permissions
7718-Nov-2019Google Sheets Tip 77: Custom Formulas Data ValidationCustom Formulas in Data Validationhttps://mailchi.mp/benlcollins/google-sheets-tip-77-custom-formula-data-validation
7825-Nov-2019Google Sheets Tip 78: Line Chart Trick 📈Chart with vertical line marker for todayhttps://mailchi.mp/benlcollins/google-sheets-tip-78-line-chart-trick
792-Dec-2019Google Sheets Tip: Find Every FormulaFind all formulas with conditional formattinghttps://mailchi.mp/benlcollins/google-sheets-tip-79-find-formulas
809-Dec-2019Google Sheets Tip: Simple Formula ClockNow, Today, Text functions combine to make simple clockhttps://mailchi.mp/benlcollins/google-sheets-tip-80-simple-formula-clock
8116-Dec-2019Google Sheets Tip: Hyperlinked ImageHyperlinked imagehttps://mailchi.mp/benlcollins/hyperlinked-image
8230-Dec-2019Google Sheets Tip: Dates Are Really Just NumbersDates are just numbershttps://mailchi.mp/benlcollins/dates-in-spreadsheets
836-Jan-2020Google Sheets Tip: Working With Excel FilesWorking with Excel files in Sheets directlyhttps://mailchi.mp/benlcollins/excel-in-sheets
8413-Jan-2020Google Shees Tip: Colored CheckboxesColored checkboxeshttps://mailchi.mp/benlcollins/colored-checkboxes
8520-Jan-2020Google Sheets Tip: A Formula Challenge!Transpose & Formula Challenge #3: Alphabetical sorthttps://mailchi.mp/benlcollins/transpose-and-formula-challenge-3
8627-Jan-2020Google Sheets Tip: Transpose Formula Challenge Solution!Formula Challenge 3 Solutionhttps://mailchi.mp/benlcollins/formula-challenge-3-solution
873-Feb-2020Google Sheets Tip: Create Data With RandarrayCreate data with RANDARRAY functionhttps://mailchi.mp/benlcollins/randarray
8810-Feb-2020Google Sheets Tip: SWITCH functionSwitch functionhttps://mailchi.mp/benlcollins/switch-function
8917-Feb-2020Google Sheets Tip: Upgrade Your Apps Script!V8 runtimehttps://mailchi.mp/benlcollins/v8-runtime
9024-Feb-2020Google Sheets Tip: Rolling Average FormulaRolling average calculationhttps://mailchi.mp/benlcollins/rolling-average
912-Mar-2020Google Sheets Tip: Conditional Sparklines 📊Conditional sparklineshttps://mailchi.mp/benlcollins/conditional-sparklines
929-Mar-2020Google Sheets Tip: Trace Precedents With F2F2 pressed twice takes you to the rangehttps://mailchi.mp/benlcollins/trace-precedents
9316-Mar-2020Google Sheets Tip: Group Columns TrickGroup rows and columns - right click to customizehttps://mailchi.mp/benlcollins/group-columns-side-panel
9423-Mar-2020Google Sheets Tip: Organize TabsTab separatorshttps://mailchi.mp/benlcollins/organize-tabs
9530-Mar-2020Google Sheets Tip: Pivot Date Trick 📅Pivot Group Rule for Dateshttps://mailchi.mp/benlcollins/pivot-date-group
966-Apr-2020Google Sheets Tip: Pivot Custom Text Groups 📂Custom Grouping by highlighted valueshttps://mailchi.mp/benlcollins/pivot-text-group
9713-Apr-2020Google Sheets Tip: Pivot Table Bins, huh?Pivot Group Rule for Valueshttps://mailchi.mp/benlcollins/pivot-value-group
9820-Apr-2020Google Sheets Tip: Bullet ChartsBullet chartshttps://mailchi.mp/benlcollins/bullet-chart
9927-Apr-2020Google Sheets Tip: Find Last Non-Blank RowLast Non Blank Rowhttps://mailchi.mp/benlcollins/last-non-blank-row
1004-May-2020100 Google Sheets Tips Ebook 🎁 & Hyperlink Next Blank RowMonday Tips 100! Hyperlink to next blank cellhttps://mailchi.mp/benlcollins/hyperlink-next-blank-row
10111-May-2020Google Sheets Tip: Conditional Conditional FormattingConditional conditional formattinghttps://mailchi.mp/benlcollins/conditional-conditional-formatting
10218-May-2020Google Sheets Tip: Tab TricksTab tricks (move, hide, create, duplicate, shortcuts, double-click to rename, color separators, copy tohttps://mailchi.mp/benlcollins/tab-tricks
10325-May-2020Google Sheets Tip: Remove Line BreaksRemove line breaks with regexhttps://mailchi.mp/benlcollins/remove-line-breaks
1041-Jun-2020Google Sheets Tip: Multi-hyperlinks In A Single CellMultiple hyperlinks in single cellhttps://mailchi.mp/benlcollins/multiple-hyperlinks
1058-Jun-2020Google Sheets Tip: Auto Generate ID ColumnAuto ID numberinghttps://mailchi.mp/benlcollins/auto-generate-id-column
10615-Jun-2020A Google Sheets Tip hiding in plain sightTemplate Galleryhttps://mailchi.mp/benlcollins/template-gallery
10722-Jun-2020Google Sheets Tip: Show/Hide solutions and hints in workbooksNew Course Launch + IF/checkboxeshttps://mailchi.mp/benlcollins/if-with-checkbox
10829-Jun-2020GSheets Tip: Randomize Ranges & A Formula ChallengeRandomize range & formula challenge #4https://mailchi.mp/benlcollins/randomize-ranges-and-formula-challenge
1096-Jul-2020GSheets Tip: The Future, SORT and the Challenge SolutionFormula challenge #4 solutionhttps://mailchi.mp/benlcollins/sort-formula-challenge-4-solution
11013-Jul-2020Google Sheets Tip: Return Multiple Values With VlookupReturn multiple column values with vlookuphttps://mailchi.mp/benlcollins/vlookup-multiple-columns
11120-Jul-2020GSheets Tip: Find Formula Errors With Conditional FormattingCatching Errors With Conditional Formattinghttps://mailchi.mp/benlcollins/find-formula-errors-with-conditional-formatting
11227-Jul-2020GSheets Tip: How To Add Google Photos Into Your SheetsHow To Add Google Photos into your Sheetshttps://mailchi.mp/benlcollins/gsheets-tip-how-to-add-google-photos-to-your-sheets
1133-Aug-2020GSheets Tip: Hidden Currency ConverterConvert currencies with functionshttps://mailchi.mp/benlcollins/currency-converter
11410-Aug-2020GSheets Tip: Indicator Arrows in Pivot Tables 🔼Indicator lights in pivot tableshttps://mailchi.mp/benlcollins/gsheets-tip-indicator-arrows-in-pivot-tables
11517-Aug-2020GSheets Tip: Importrange Formula Know-HowImportRange knowledgehttps://mailchi.mp/benlcollins/gsheets-tip-importrange-permissions
11624-Aug-2020GSheets Tip: Share Sensitive Sheets SafelyCreate a copy to remove version history before sharinghttps://mailchi.mp/benlcollins/gsheets-tip-share-copy
11731-Aug-2020GSheets Tip: Format Numbers Like An AccountantCustom Number Formatting - add color and brackets to negative numbershttps://mailchi.mp/benlcollins/gsheets-tip-accounting-number-format
1187-Sep-2020GSheets Tip: Must-Know Fact About The QUERY FunctionA, B, C vs. Col1, Col2, Col3 in Queryhttps://mailchi.mp/benlcollins/gsheets-tip-must-know-fact-about-query-function
11914-Sep-2020GSheets Tip: Track G Suite Updates With This FormulaG Suite Updates with IMPORTFEEDhttps://mailchi.mp/benlcollins/gsheets-tip-track-g-suite-updates
12021-Sep-2020GSheets Tip: Dinosaurs, Time and Large Numbers 🐲Thought experiment with dinosaurs and large numbers! Something different ;)https://mailchi.mp/benlcollins/gsheets-tip-dinosaurs-time-and-large-numbers
12128-Sep-2020GSheets Tip: Countdown functionCount down reverse number formathttps://mailchi.mp/benlcollins/gsheets-tip-countdown-function
1225-Oct-2020GSheets Tip: Subscripts with formulasSubscript values e.g chemical formulashttps://mailchi.mp/benlcollins/gsheets-tip-subscripts-with-formulas
12312-Oct-2020GSheets Tip: Wildcards In Formulas 🌟Wildcards in formulashttps://mailchi.mp/benlcollins/gsheets-tip-wildcards-in-formulas
12419-Oct-2020GSheets Tip: Select/Deselect all Checkboxes at once ☑Select all checkboxes at once with space barhttps://mailchi.mp/benlcollins/gsheets-tip-select-all-checkboxes
12526-Oct-2020GSheets Tip: Custom Checkbox Values & Teacher Template ExampleCheckbox with custom valueshttps://mailchi.mp/benlcollins/gsheets-tip-custom-checkbox-values
1262-Nov-2020GSheets Tip: Remove the header row from QUERY resultsWrap QUERY with INDEX function to remove headerhttps://mailchi.mp/benlcollins/gsheets-tip-remove-query-header-row
1279-Nov-2020GSheets Tip: How To Draw A Slope ChartHow to draw a slope charthttps://mailchi.mp/benlcollins/gsheets-tip-slope-chart
12816-Nov-2020GSheets Tip: Draw A Chart With The Sequence FormulaHow to draw a grid charthttps://mailchi.mp/benlcollins/gsheets-tip-grid-chart
12923-Nov-2020GSheets Tip: Show Project Completion StatusSparkline status barhttps://mailchi.mp/benlcollins/gsheets-tip-sparkline-status-bar
13030-Nov-2020GSheets Tip: Have you ever heard of GESTEP?GESTEP functionhttps://mailchi.mp/benlcollins/gsheets-tip-gestep-function
1317-Dec-2020GSheets Tip: Apps Script just got a facelift!New Apps Script IDEhttps://mailchi.mp/benlcollins/gsheets-tip-new-apps-script-ide
13214-Dec-2020GSheets Tip: How To Select Randomly From A ListRANDBETWEEN and INDEX to select an item from a listhttps://mailchi.mp/benlcollins/gsheets-tip-select-randomly-from-list
13321-Dec-2020GSheets Tip: TEXTJOIN and Formula Challenge #5Formula Challenge #5: Unique numbershttps://mailchi.mp/benlcollins/gsheets-tip-textjoin-and-formula-challenge-5
1344-Jan-2021GSheets Tip: FLATTEN function?? Plus, Challenge #5 solutionFormula Challenge #5 Solution & Flatten functionhttps://mailchi.mp/benlcollins/gsheets-tip-flatten-and-formula-challenge-5-solution
13511-Jan-2021GSheets Tip: Two Number Formats in One ColumnDouble Format for column with % and number rule: [<1]0.0%;#,##0https://mailchi.mp/benlcollins/gsheets-tip-double-number-format
13618-Jan-2021GSheets Tip: Walk The First RowTell the story of one row + micro IPhttps://mailchi.mp/benlcollins/gsheets-tip-walk-the-first-row
13725-Jan-2021GSheets Tip: How to format your header rowThe right way to format your header rowshttps://mailchi.mp/benlcollins/gsheets-tip-header-row
1381-Feb-2021GSheets Tip: Cakes and Column StatsExplore your data with column statshttps://mailchi.mp/benlcollins/gsheets-tip-column-stats
1398-Feb-2021GSheets Tip: Why automate?Why you should learn automationhttps://mailchi.mp/benlcollins/gsheets-tip-why-automate
14015-Feb-2021GSheets Tip: To script or not to script...When to use apps script or not?https://mailchi.mp/benlcollins/gsheets-tip-to-script-or-not-to-script
14122-Feb-2021GSheets Tip: Toast To The Rescue 🍞Toasthttps://mailchi.mp/benlcollins/gsheets-tip-toast
1421-Mar-2021GSheets Tip: Let's build a Sheet Sizer tool together! 🔧Automation launch & Sheet Sizerhttps://mailchi.mp/benlcollins/gsheets-tip-sheet-sizer-1
1438-Mar-2021GSheets Tip: An Elegant FormulaSequence + Date Array Formulahttps://mailchi.mp/benlcollins/gsheets-tip-monthly-sequence
14415-Mar-2021GSheets Tip: The Beginner's MindsetThe Beginner's Mindsethttps://mailchi.mp/benlcollins/gsheets-tip-beginners-mindset
14522-Mar-2021GSheets Tip: Extract the n-th wordExtract nth word from sentencehttps://mailchi.mp/benlcollins/gsheets-tip-word-games-with-split
14629-Mar-2021GSheets Tip: The Taco Chart!Bar chart with REPT Functionhttps://mailchi.mp/benlcollins/gsheets-tip-rept-function-taco-chart
1475-Apr-2021GSheets Tip: 6 Creative Ways To Use BordersDifferent border examples in Sheets & pro sheets enrollment in PShttps://mailchi.mp/benlcollins/gsheets-tip-borders
14812-Apr-2021GSheets Tip: Google's hidden logo libraryGet company logos using Google's hidden APIhttps://mailchi.mp/benlcollins/gsheets-tip-google-logo-library
14919-Apr-2021GSheets Tip: Are they equal?Test if values are equal with equality operator, exact function and array formulahttps://mailchi.mp/benlcollins/gsheets-tip-equal
15026-Apr-2021GSheets Tip: 🟩🟩🟩🟩🟩🟩⬜⬜⬜⬜Progress bar charts with REPT and SPARKLINEhttps://mailchi.mp/benlcollins/gsheets-tip-progress-chart
1513-May-2021GSheets Tip: Home, sheet home 🏠Set a Google Sheet as your Chrome home pagehttps://mailchi.mp/benlcollins/gsheets-tip-home-sheet
15210-May-2021GSheets Tip: Array Formula to get row numbersRow numbers of non-blank cellshttps://mailchi.mp/benlcollins/gsheets-tip-row-numbers-non-blank
15317-May-2021GSheets Tip: Filter FunctionFilter function to find row numbers of non-blank cellshttps://mailchi.mp/benlcollins/gsheets-tip-filter-function
15424-May-2021GSheets Tip: Flatten FunctionFLATTEN functionhttps://mailchi.mp/benlcollins/gsheets-tip-flatten-function
15531-May-2021GSheets Tip: Find the last value in a rowFind last value in a rowhttps://mailchi.mp/benlcollins/gsheets-tip-find-the-last-value-in-a-row
1567-Jun-2021GSheets Tip: CHOOSE your own adventureChoose functionhttps://mailchi.mp/benlcollins/gsheets-tip-choose-function
15714-Jun-2021GSheets Tip: Random List Picker FormulaSelect Random element from listhttps://mailchi.mp/benlcollins/gsheets-tip-random-list-picker-formula
15821-Jun-2021GSheets Tip: Turbocharge your checkboxes ✅Uncheck with Apps Scripthttps://mailchi.mp/benlcollins/gsheets-tip-turbocharge-checkboxes
15928-Jun-2021GSheets Tip: Better Data Management with the Range Name BoxRange Name Boxhttps://mailchi.mp/benlcollins/gsheets-tip-range-name-box
1605-Jul-2021GSheets Tip: Generate A Year Of DatesYear Sequence Formulahttps://mailchi.mp/benlcollins/gsheets-tip-generate-dates-automatically
16112-Jul-2021GSheets Tip: REGEX, not as hard as it looks...REGEX formulas introduction, extract numbers examplehttps://mailchi.mp/benlcollins/gsheets-tip-regex-introduction
16219-Jul-2021GSheets Tip: Extract numbers from textREGEX part 2: extract number with thousand separators, decimals etc.https://mailchi.mp/benlcollins/gsheets-tip-regex-extract-numbers
16326-Jul-2021GSheets Tip: Oops, I made a mistake...REGEX part 2 fix: fix the mistake with the repetition characterhttps://mailchi.mp/benlcollins/gsheets-tip-regex-extract-numbers-fix
1642-Aug-2021GSheets Tip: Match telephone numbers 📞REGEX part 3: Extract phone number from stringhttps://mailchi.mp/benlcollins/gsheets-tip-regex-match-telephone-numbers
1659-Aug-2021GSheets Tip: Clever formula to switch name orderREGEX part 4: Identify transactional stringhttps://mailchi.mp/benlcollins/gsheets-tip-regex-name-swaperoo
16616-Aug-2021GSheets Tip: Go BigMaximise spacehttps://mailchi.mp/benlcollins/gsheets-tip-go-big
16723-Aug-2021GSheets Tip: Add Row Numbers DynamicallyAdding Row Numbers Dynamicallyhttps://mailchi.mp/benlcollins/gsheets-tip-add-row-numbers-dynamically
16830-Aug-2021GSheets Tip: How to create a slopegraph in SheetsSlopegraph tutorialhttps://mailchi.mp/benlcollins/gsheets-tip-slopegraph
1696-Sep-2021GSheets Tip: Yet another reason to use named ranges...Named Range in IMPORTRANGEhttps://mailchi.mp/benlcollins/gsheets-tip-named-ranges-importrange
17013-Sep-2021GSheets Tip: The REGEX cookbookLaunch REGEX cookbookhttps://mailchi.mp/benlcollins/gsheets-tip-floating-bars
17120-Sep-2021GSheets Tip: The Right Formula And Radial Bar ChartsUse the right formula for the jobhttps://mailchi.mp/benlcollins/gsheets-tip-use-the-right-formula
17227-Sep-2021GSheets Tip: Formula To Turn Column Numbers To LettersGoing from column number to column letterhttps://mailchi.mp/benlcollins/gsheets-tip-convert-column-number-to-letter
1734-Oct-2021New look GSheets Tip: Column Letters to NumbersConvert column letter to numberhttps://mailchi.mp/benlcollins/gsheets-tip-convert-column-letter-to-number
17411-Oct-2021Sheets Tip #174: 10 free days this month!Networkdayshttps://mailchi.mp/benlcollins/gsheets-tip-networkdays
17518-Oct-2021Sheets Tip #175: QUERY function filtering trick...QUERY where clause "starts with"https://mailchi.mp/benlcollins/gsheets-tip-query-starts-with
17625-Oct-2021Sheets Tip 176: Apostrophes in the QUERY functionQUERY and apostropheshttps://mailchi.mp/benlcollins/gsheets-tip-query-apostrophes
1771-Nov-2021Sheets Tip 177: AI assisted data cleaning 🗑️Cleanup suggestionshttps://mailchi.mp/benlcollins/gsheets-tip-177-cleanup-suggestions
1788-Nov-2021Sheets Tip 178: Make Formulas More ReadableMake your formulas more readable by resizing and adding new lineshttps://mailchi.mp/benlcollins/gsheets-tip-178-readable-formulas
17915-Nov-2021Sheets Tip 179: Advanced VLOOKUP for multi-column lookupsMulti-Column Lookuphttps://mailchi.mp/benlcollins/gsheets-tip-179-vlookup-multi-column-lookup
18022-Nov-2021Sheets Tip 180: Lists Of Grouped Numbers With SEQUENCELists of grouped numbers with sequencehttps://mailchi.mp/benlcollins/gsheets-tip-180-grouped-numbers-sequence
18129-Nov-2021Sheets Tip 181: Shortcuts You Should UseShortcuts for working with rangeshttps://mailchi.mp/benlcollins/gsheets-tip-181-range-shortcuts
1826-Dec-2021Sheets Tip 182: SUMPRODUCT, a powerful but enigmatic functionSomething with sumproducthttps://mailchi.mp/benlcollins/gsheets-tip-182-sumproduct
18313-Dec-2021Sheets Tip 183: Weighted average with SUMPRODUCT ⚖️Follow up to sumproduct: weigted avearge examplehttps://mailchi.mp/benlcollins/gsheets-tip-183-sumproduct-weighted-average
18420-Dec-2021Sheets Tip 184: CHICKEN and EGG finally solved! 🐣Chicken and egg sorthttps://mailchi.mp/benlcollins/gsheets-tip-184-chicken-egg-sort
1853-Jan-2022Sheets Tip 185: 2 Quick Ways To Create New SheetsTwo quick ways to create a new Sheethttps://mailchi.mp/benlcollins/gsheets-tip-185-new-sheets
18610-Jan-2022Sheets Tip 186: A Creative Use Case For SlicersCreative way to use a slicer for sections of a sheethttps://mailchi.mp/benlcollins/gsheets-tip-186-creative-slicers
18717-Jan-2022Sheets Tip 186: The Finder Tool 🔎The finder toolhttps://mailchi.mp/benlcollins/gsheets-tip-187-finder-tool
18824-Jan-2022Sheets Tip 188: Going dotty...Dot Plothttps://mailchi.mp/benlcollins/gsheets-tip-188-dot-plot
18931-Jan-2022Sheets Tip 189: How To Reference Cells in QUERY SELECT 👀How to select other cells from inside the QUERY functionhttps://mailchi.mp/benlcollins/gsheets-tip-189-query-external-cells
1907-Feb-2022Sheets Tip 190: Publish To Web & Formula StudioPublish to web and formula studiohttps://mailchi.mp/benlcollins/gsheets-tip-190-publish-to-web
19114-Feb-2022Sheets Tip 191: Add an auto-incrementing row ID 📶Auto-incrementing row ID columnhttps://mailchi.mp/benlcollins/gsheets-tip-191-auto-incrementing-id
19221-Feb-2022Sheets Tip 192: SEQUENCE DataGenerate dummy data with sequencehttps://benlcollins.ck.page/posts/sheets-tip-192-sequence-data
19328-Feb-2022Sheets Tip 193: Conditional counts with COUNTIFCOUNTIF with wildcardshttps://benlcollins.ck.page/posts/sheets-tip-193-conditional-counts-with-countif
1947-Mar-2022Sheets Tip 194: Formula Challenge #6 💥MID and Formula challenge 6: randomize lettershttps://benlcollins.ck.page/posts/sheets-tip-194-formula-challenge-6
19514-Mar-2022Sheets Tip 195: SEQUENCE and Formula Challenge 6 solutionFormula challenge 6 solutionhttps://benlcollins.ck.page/posts/sheets-tip-195-pi-sequence-and-formula-challenge-6-solution
19621-Mar-2022Sheets Tip 196: Wow, so many viewsSheets Activity Dashboardhttps://benlcollins.ck.page/posts/sheets-tip-196-wow-so-many-views
19728-Mar-2022Sheets Tip 197: Highlight Top 10Highlight top 5 or top 10https://benlcollins.ck.page/posts/sheets-tip-197-highlight-top-5
1984-Apr-2022Sheets Tip 198: Two Methods To Trim WhitespaceTrim whitespacehttps://benlcollins.ck.page/posts/sheets-tip-198-two-methods-to-trim-whitespace
19911-Apr-2022Sheets Tip 199: IMPORTRANGE Backlink To Source FormulaImportRange backlinkshttps://benlcollins.ck.page/posts/sheets-tip-199-importrange-backlink-to-source-sheet
20018-Apr-2022200 spreadsheet espressos! 🎉200 milestone and audience surveyhttps://benlcollins.ck.page/posts/200-spreadsheet-espressos
20125-Apr-2022Sheets Tip 201: Copy Visible Cells OnlyCopy only visible cellhttps://benlcollins.ck.page/posts/sheets-tip-201-copy-visible-cells-only
2022-May-2022Sheets Tip 202: Meet within a SheetMeet and Sheethttps://benlcollins.ck.page/posts/sheets-tip-202-meet-within-a-sheet
2039-May-2022Sheets Tip 203: How To Use Arrays To Return Multiple Columns In VLOOKUPHow to create arrayshttps://benlcollins.ck.page/posts/sheets-tip-203-how-to-use-arrays-to-return-multiple-columns-in-vlookup
20416-May-2022Sheets Tip 204: How To Use Dates In The QUERY FunctionDates with the QUERY function and QUERY function launchhttps://benlcollins.ck.page/posts/sheets-tip-204-how-to-use-dates-in-the-query-function
20523-May-2022Sheets Tip #205: The hidden powers of custom numbers formats... 👀Custom number formatshttps://benlcollins.ck.page/posts/sheets-tip-205-the-hidden-powers-of-custom-numbers-formats
20630-May-2022Sheets Tip 206: Create barcodes in Sheets ║█║▌║█║▌│║▌║▌█║Barcodes in Sheetshttps://benlcollins.ck.page/posts/sheets-tip-206-create-barcodes-in-sheets
2076-Jun-2022Sheets Tip 207: Get unique values from grouped listsGet unique values from grouped listshttps://benlcollins.ck.page/posts/sheets-tip-207-get-unique-values-from-grouped-lists
20813-Jun-2022Sheets Tip 208: Google Finance 5 secrets & An equation to change your worldview5 Secrets of the Google Finance Functionhttps://benlcollins.ck.page/posts/sheets-tip-208-google-finance-5-secrets-an-equation-to-change-your-worldview
20920-Jun-2022Sheets Tip 209: New lines with the magic CHAR functionAdd line breaks to strings with CHAR(10)https://benlcollins.ck.page/posts/sheets-tip-209-new-lines-with-the-magic-char-function
21027-Jun-2022Sheets Tip 210: Day first or month first? Fixing mixed date columnsFixing Dates in mixed column of US and UK typeshttps://benlcollins.ck.page/posts/sheets-tip-210-day-first-or-month-first-fixing-mixed-date-columns
2115-Jul-2022Sheets Tip 211: Spreadsheet Competition & How To Open All Links At OnceOpen all links at oncehttps://benlcollins.ck.page/posts/sheets-tip-211-spreadsheet-competition-how-to-open-all-links-at-once
21211-Jul-2022Sheets Tip 212: Single Formula Year Calendar! 🗓Calendar with SEQUENCE functionhttps://benlcollins.ck.page/posts/sheets-tip-212-single-formula-year-calendar
21318-Jul-2022Sheets Tip 213: Improvements to the single formula calendarCalendar with SEQUENCE function - Part IIhttps://benlcollins.ck.page/posts/sheets-tip-213-improvements-to-the-single-formula-calendar
21425-Jul-2022Sheets Tip 214: Changing Sheets Ownership 🔐Change owner of a Google Sheethttps://benlcollins.ck.page/posts/sheets-tip-214-changing-sheets-ownership
2151-Aug-2022Sheets 215: Understanding Spreadsheet ErrorsUnderstanding spreadsheet errorshttps://benlcollins.ck.page/posts/sheets-215-understanding-spreadsheet-errors
2168-Aug-2022Sheets Tip 216: Dashboard Ideas!Dashboard Ideashttps://benlcollins.ck.page/posts/sheets-tip-216-dashboard-ideas
21715-Aug-2022Sheets Tip 217: Three Tips For Better Navigation 🧭Go To Navigation (F2 inside formulas, copying range into reference bar, hidden Go To)https://benlcollins.ck.page/posts/sheets-tip-217-three-tips-for-better-navigation
21822-Aug-2022Sheets Tip 218: Amazing In-Cell Sparkline Progress ChartsSparkline Progress Bar Chartshttps://benlcollins.ck.page/posts/sheets-tip-218-amazing-in-cell-sparkline-progress-charts
21929-Aug-2022Sheets Tip 219: The new Named Functions are a game changerNamed functionshttps://benlcollins.ck.page/posts/sheets-tip-219-the-new-named-functions-are-a-game-changer
2206-Sep-2022Sheets Tip 220: The new MAP function! 🗺️The MAP functionhttps://benlcollins.ck.page/posts/sheets-tip-220-the-new-map-function
22112-Sep-2022Sheets Tip 221: Pivot like a pro!Pivot table 3 tipshttps://benlcollins.ck.page/posts/sheets-tip-221-pivot-like-a-pro
22219-Sep-2022Sheets Tip 222: Formulas to build lists like 1 of 10, 2 of 10, etc.1 of 10 sequenceshttps://benlcollins.ck.page/posts/sheets-tip-222-formulas-to-build-lists-like-1-of-10-2-of-10-etc
22326-Sep-2022Sheets Tip 223: Sort by length formulaSort by lengthhttps://benlcollins.ck.page/posts/sheets-tip-223-sort-by-length-formula
2243-Oct-2022Sheets Tip 224: I do this with every new dataset...Steps I take with every new tablehttps://benlcollins.ck.page/posts/sheets-tip-224-i-do-this-with-every-new-dataset
22510-Oct-2022Sheets Tip 225: Stack two tables dynamicallyStack two tables with the {...} array literalshttps://benlcollins.ck.page/posts/sheets-tip-225-stack-two-tables-dynamically
22617-Oct-2022Sheets Tip 226: New Announcements From The Google Conference 🧐Google Cloud Next Recaphttps://benlcollins.ck.page/posts/sheets-tip-226-new-announcements-from-the-google-conference-1
22724-Oct-2022Sheets Tip 227: Yet more ways to stack tables...Stack two tables with QUERY function alternativehttps://ckarchive.com/b/68ueh8hkw3dp6
22831-Oct-2022Sheets Tip 228: Mega running total SCAN formulas & halloween functions 🎃Scan functionhttps://benlcollins.ck.page/posts/sheets-tip-228-mega-running-total-scan-formulas-halloween-functions
2297-Nov-2022Sheets Tip 229: My most heavily used shortcutCopy and Paste Specialhttps://benlcollins.ck.page/posts/sheets-tip-229-my-most-frequently-used-shortcut
23014-Nov-2022Sheets Tip 230: How to add indicator arrows to dataIndicator Arrows, mention Black Friday sale coming uphttps://benlcollins.ck.page/posts/sheets-tip-230-how-to-add-indicator-arrows-to-data
23121-Nov-2022Sheets Tip 231: Never again miss a change to your SheetBlack Friday weekhttps://benlcollins.ck.page/posts/sheets-tip-231-never-again-miss-a-change-to-your-sheet
2325-Dec-2022Sheets Tip 232: New Timeline (Gantt) Charts in SheetsNew timeline chartshttps://benlcollins.ck.page/posts/sheets-tip-232-new-chart-in-sheets-timeline-view-aka-gantt-charts
23312-Dec-2022Sheets Tip 233: How to categorize data with IFSHow to categorize with IFShttps://benlcollins.ck.page/posts/sheets-tip-233-how-to-categorize-data-with-ifs
23419-Dec-2022Sheets Tip 234: Freeze rows with Grabby HandFreeze rows with grabby handhttps://benlcollins.ck.page/posts/sheets-tip-234-freeze-rows-with-grabby-hand
2353-Jan-2023Sheets Tip 235: Secret Date Trick and a Happy New Year! 🎉Date pickerhttps://benlcollins.ck.page/posts/sheets-tip-235-secret-date-trick-and-a-happy-new-year
2369-Jan-2023Sheets Tip 236: New Drop-Down Chips!New drop down menus + update blog posthttps://benlcollins.ck.page/posts/sheets-tip-236-new-drop-down-chips
Google Sheets Tips Newsletter Archive
Sign up 👉https://www.benlcollins.com/google-sheets-tips/👈
Weekly newsletter every Monday at 11am
Tip NumberDateSubjectDescriptionLink
130-Apr-2018Monday Tip: Keyboard Shortcuts in Google Sheets5 keyboard shortcutshttps://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets
27-May-2018Monday Tip: Notifications in Google SheetsGet notifications when a spreadsheet changeshttps://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560017
314-May-2018Monday Tip: Datetime tip in Google SheetsQuickly split datetime with formulashttps://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560021
421-May-2018Monday Tip: Super cool (and clever) way to combine text and numbers in a cellAdd label to number with custom formattinghttps://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560077
511-Jun-2018Monday Tip: Replace numerical IF functions with MIN or MAXReplace numerical IF formulas with MIN or MAX functionshttps://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560093
618-Jun-2018Monday Tip: Quick ways to copy data down a columnQuick ways to fill a whole column (double click, highlight > Cmd + Enter or Cmd + D, quicker than Copy-paste or drag-down)https://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560097
725-Jun-2018Monday Tip: Multiply an entire column with a single 🔥 MMULT formula 🔥MMULT with constant value to quickly multiply column of numbershttps://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560101
82-Jul-2018Monday Tip: The OFFSET function!OFFSET function to move data up columnshttps://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560105
99-Jul-2018Monday G Sheets Tip: Better data entry ✉Control data entry with data validation e.g. email address with custom formula =search("@",F9)>0https://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560109
1016-Jul-2018Monday G Sheets Tip: CHAR-grilled anyone?Top 10(?) CHAR formulas e.g. to get arrows
e.g. ="Cohort "&char(8594)&char(10)&" Months after cohort start "&char(8595)		https://mailchi.mp/benlcollins/monday-tip-keyboard-shortcuts-in-google-sheets-1560113
1123-Jul-2018Monday Tip + I learned this the hard way, you don’t have to…Group rows and columnshttps://mailchi.mp/benlcollins/monday-tip-i-learned-this-the-hard-way-you-dont-have-to
1230-Jul-2018[Case Study] Josh’s journey from political campaign director to data analystF4 for relative/absolute and for repeat last commandhttps://mailchi.mp/benlcollins/i-learned-this-the-hard-way-you-dont-have-to-1560149
1320-Aug-2018Monday Tip: Tag people in comments in Google SheetsAlert in commentshttps://mailchi.mp/benlcollins/alert-in-comments
1427-Aug-2018Monday Tip: Conditional Formatting across entire rowHow to apply conditional formatting to whole row (also write quick blog post)https://mailchi.mp/benlcollins/alert-in-comments-1560245
153-Sep-2018🚀 Monday Tip: Trick to round numbers to the nearest ten, hundred, etc.How to round to nearest ten, hundred, thousandhttps://mailchi.mp/benlcollins/round-to-ten
1610-Sep-2018🚀 Monday Tip: Speed up your data entryQuick data entry by highlighting range in advancehttps://mailchi.mp/benlcollins/data-entry-confined-range
1717-Sep-2018🚀 Monday Tip: Generate random letters with the CODE functionGenerate random letters with CODE functionhttps://mailchi.mp/benlcollins/generate-random-letters-code-function
1824-Sep-2018🔆 Monday Tip: Create heatmaps with your dataCreate heatmaps using conditional formattinghttps://mailchi.mp/benlcollins/create-heatmap-with-conditional-formatting
191-Oct-2018🔆 Monday Tip: A Pivot Table tip and resourcesPivot Table Copy trick and resourceshttps://mailchi.mp/benlcollins/pivot-table-tip-and-resources
208-Oct-2018🔆 Monday Tip: Rename Pivot Table column headingsRename Pivot Table headingshttps://mailchi.mp/benlcollins/rename-pivot-table-headings
2115-Oct-2018🔆 Monday Tip: Hyperlink to different parts of your SheetHyperlink to other parts of your Sheethttps://mailchi.mp/benlcollins/hyperlinks-in-sheets
2222-Oct-2018🔆 Monday Tip: Repeat number groups with the ROW & MOD functionsCreate repeating number groups with ROW and MODhttps://mailchi.mp/benlcollins/number-groups-row-mod
2329-Oct-2018🎃 👻 Monday Tip: Create Google Sheets instantlyInstantly create a new Google Sheethttps://mailchi.mp/benlcollins/create-sheets-instantly
245-Nov-2018💪 Monday Tip: Advanced Formula Workout ChallengeAdvanced formula walk throughhttps://mailchi.mp/benlcollins/advanced-formula-workout
2512-Nov-2018🔆 Monday Tip: Neat trick with freeze panes & that surprise from last week...Quickly freeze rows by dragging down top rowhttps://mailchi.mp/benlcollins/freeze-panes-blastoff-surprise
2619-Nov-2018⛔ Monday Tip: Protect individual sheetsProtect individual sheets with Google Sheethttps://mailchi.mp/benlcollins/protect-individual-sheet
2726-Nov-2018Monday Tip: Super handy shortcutQuick create Sheets in folder with Shift + Shttps://mailchi.mp/benlcollins/shift-s-open-new-sheet
283-Dec-2018👉 Monday Tip: Automate your Sheets with MacrosIntroducing Macroshttps://us11.campaign-archive.com/?u=5f850f1ff83cc35ed1ca00348&id=0004cdcffc
2910-Dec-2018👉 Monday Tip: 5 million cells...Introducing 5 million cell limithttps://us11.campaign-archive.com/?u=5f850f1ff83cc35ed1ca00348&id=b7d4d15d32
3017-Dec-2018Monday Google Sheets Tip: Collaboration & FiltersFilter viewshttps://mailchi.mp/benlcollins/filter-views
3124-Dec-2018Monday Google Sheets Tip: Happy Holidays!Christmas tree with the CHAR functionhttps://mailchi.mp/benlcollins/christmas-tree-char
3231-Dec-2018Monday Google Sheets Tip: 2018 draws to a close% of year remaininghttps://mailchi.mp/benlcollins/end-of-2018
337-Jan-2019Google Sheets Tip: Format Individual Data Points In ChartsFormat individual data points in Google Sheets Chartshttps://mailchi.mp/benlcollins/format-individual-chart-points
3414-Jan-2019Google Sheets Tip: Quickly summarize your dataQuick Aggregation Tool, when you highlight datahttps://mailchi.mp/benlcollins/quickly-summarize-your-data
3521-Jan-2019Google Sheets Tip: How To Remove DuplicatesUNIQUE formula to deduphttps://mailchi.mp/benlcollins/how-to-remove-duplicates
3628-Jan-2019Google Sheets Tip: Numbers Starting With ZeroEnter numbers that start with zerohttps://mailchi.mp/benlcollins/numbers-starting-with-zero
374-Feb-2019Google Sheets Tip: Vlookup Formula ChallengeVlookup multiple criteria formula challengehttps://mailchi.mp/benlcollins/nested-tables-vlookup
3811-Feb-2019Google Sheets Tip: Text Trickery 😈Text rotationhttps://mailchi.mp/benlcollins/text-rotation
3918-Feb-2019Google Sheets Tip: Text Trickery Part II 😈Text rotation part IIhttps://mailchi.mp/benlcollins/text-rotation-part-ii
4025-Feb-2019Google Sheets Tip: Hello, how are you?Detect language + Google Translatehttps://mailchi.mp/benlcollins/google-translate-function
414-Mar-2019Google Sheets Tip: ROW/COLUMN functions & Formula Challenge SolutionMultiple images solutionhttps://mailchi.mp/benlcollins/repeated-image-formula
4211-Mar-2019Google Sheets Tip: The Endless Possibilities of Custom FunctionsClearbit API example + Apps Script Coursehttps://mailchi.mp/benlcollins/custom-functions
4325-Mar-2019Google Sheets Tip: A Change of Plans...Change of Plans + Subtotalhttps://mailchi.mp/benlcollins/change-of-plans-subtotal
441-Apr-2019Google Sheets Tip: Year In Progress SparklineSparklineshttps://mailchi.mp/benlcollins/sparkline-year-progress
458-Apr-2019Google Sheets Tip: Find The Most Frequent Word 🔎Find the most frequent wordhttps://mailchi.mp/benlcollins/mode-with-text
4615-Apr-2019Google Sheets Tip: Sneak peek at new stuff coming to Google SheetsNext Recaphttps://mailchi.mp/benlcollins/next-recap
4722-Apr-2019Google Sheets Tip: Macro to show/hide tabsFocus + Unfocus example + Apps Script Coursehttps://mailchi.mp/benlcollins/focus-unfocus
4829-Apr-2019Google Sheets Tip: Night mode anyone? 🌜Change background colors with Apps Scripthttps://mailchi.mp/benlcollins/night-mode-automation-launch
496-May-2019Google Sheets Tip: Create new tabs instantlyShift + F11 to create new tabs in Google Sheetshttps://mailchi.mp/benlcollins/shift-f11
5013-May-2019Google Sheets Tip: Images In CellsImages in cellshttps://mailchi.mp/benlcollins/image-in-cells
5120-May-2019Google Sheets Tip: Remove Duplicates Finally!New data features - Remove duplicateshttps://mailchi.mp/benlcollins/remove-duplicates
5227-May-2019Google Sheets Tip: Show formulasShow all formulas at once, with Ctrl + `https://mailchi.mp/benlcollins/show-formulas
533-Jun-2019Google Sheets Tip: Formula Challenge SolutionsFormula Challenge Resultshttps://mailchi.mp/benlcollins/formula-challenge-solution
5410-Jun-2019Google Sheets Tip: Colorful Sheets! 🌈Use color in Google Sheetshttps://mailchi.mp/benlcollins/add-colors
5517-Jun-2019Google Sheets Tip: More Colorful Sheets! 🌈Use of the MID formula and more colors in Sheetshttps://mailchi.mp/benlcollins/mid-formula-colors
5624-Jun-2019Google Sheets Tip: Quick Entry & Exit With FormulasF2 and Shift + Enter and Escape shortcutshttps://mailchi.mp/benlcollins/formula-entry-exit-shortcuts
571-Jul-2019Google Sheets Tip: Discover New Formulas TodayDiscover a new formula todayhttps://mailchi.mp/benlcollins/discover-new-function
588-Jul-2019Google Sheets Tip: Make Conditional Formatting PermanentApply conditional formatting permanentlyhttps://mailchi.mp/benlcollins/make-conditional-formatting-permanent
5915-Jul-2019Google Sheets Tip: Custom Number Formatting & Coming soon...Custom Number Formattinghttps://mailchi.mp/benlcollins/custom-number-formatting
6022-Jul-2019Google Sheets Tip: Moon Landing 50th Anniversary!Moon landing anniversaryhttps://mailchi.mp/benlcollins/moon-landing
6129-Jul-2019Google Sheets Tip: In Cell Date PickerData Validation Date Pickerhttps://mailchi.mp/benlcollins/in-cell-date-picker
625-Aug-2019Google Sheets Tip: Add Star Rating System ⭐⭐⭐Add Star Ratingshttps://mailchi.mp/benlcollins/star-rating
6312-Aug-2019Google Sheets Tip: Create QR Codes With FormulasCreate QR codes in Sheetshttps://mailchi.mp/benlcollins/qr-codes
6419-Aug-2019Google Sheets Tip: Apps Script Button & 10 Year AnniversaryApps Script 10 Year anniversaryhttps://mailchi.mp/benlcollins/apps-script-button
6526-Aug-2019Google Sheets Tip: QA ChecklistsQA Checklisthttps://mailchi.mp/benlcollins/qa-checklists
662-Sep-2019Google Sheets Tip: Do you use the Parser family of functions?Parser family of functionshttps://mailchi.mp/benlcollins/parser-functions
679-Sep-2019Google Sheets Tip: Manage Apps Script projects from the DashboardApps Script Dashboardhttps://mailchi.mp/benlcollins/apps-script-dashboard
6816-Sep-2019Google Sheets Tip: Brilliant Apps Script keyboard shortcuts 💯Apps Script shortcutshttps://mailchi.mp/benlcollins/apps-script-shortcuts
6923-Sep-2019Google Sheets Tip: Video sidebar with Apps ScriptEmbed videos in sidebarhttps://mailchi.mp/benlcollins/video-sidebar
7030-Sep-2019Google Sheets Tip 70: Extract Hyperlink URLs with a formulaExtract url from hyperlink formulahttps://mailchi.mp/benlcollins/extract-hyperlinks
717-Oct-2019Google Sheets Tip 71: Annotate Line Charts 📈Mark Today on a Line Graphhttps://mailchi.mp/benlcollins/annotate-line-charts
7214-Oct-2019Google Sheets Tip 72: One spicy function 🌶️SEQUENCE functionhttps://mailchi.mp/benlcollins/sequence-function
7321-Oct-2019Google Sheets Tip 73: Date trick that's so easy to miss...Double click date to bring up date pickerhttps://mailchi.mp/benlcollins/date-double-click
7428-Oct-2019Google Sheets Tip 74: A book, a challenge and the RANK function 🎃Find position of a value with RANK functionhttps://mailchi.mp/benlcollins/rank-function
754-Nov-2019Google Sheets Tip 75: A FACT to blow your mind ♣75 Tips Anniversary - special email about the Card sorting Factorial (the lesson I never included in the data analysis course)https://mailchi.mp/benlcollins/google-sheets-tip-75-fact
7611-Nov-2019Google Sheets Tip 76: Control who can edit tabsSetting tab level permissionshttps://mailchi.mp/benlcollins/tab-permissions
7718-Nov-2019Google Sheets Tip 77: Custom Formulas Data ValidationCustom Formulas in Data Validationhttps://mailchi.mp/benlcollins/google-sheets-tip-77-custom-formula-data-validation
7825-Nov-2019Google Sheets Tip 78: Line Chart Trick 📈Chart with vertical line marker for todayhttps://mailchi.mp/benlcollins/google-sheets-tip-78-line-chart-trick
792-Dec-2019Google Sheets Tip: Find Every FormulaFind all formulas with conditional formattinghttps://mailchi.mp/benlcollins/google-sheets-tip-79-find-formulas
809-Dec-2019Google Sheets Tip: Simple Formula ClockNow, Today, Text functions combine to make simple clockhttps://mailchi.mp/benlcollins/google-sheets-tip-80-simple-formula-clock
8116-Dec-2019Google Sheets Tip: Hyperlinked ImageHyperlinked imagehttps://mailchi.mp/benlcollins/hyperlinked-image
8230-Dec-2019Google Sheets Tip: Dates Are Really Just NumbersDates are just numbershttps://mailchi.mp/benlcollins/dates-in-spreadsheets
836-Jan-2020Google Sheets Tip: Working With Excel FilesWorking with Excel files in Sheets directlyhttps://mailchi.mp/benlcollins/excel-in-sheets
8413-Jan-2020Google Shees Tip: Colored CheckboxesColored checkboxeshttps://mailchi.mp/benlcollins/colored-checkboxes
8520-Jan-2020Google Sheets Tip: A Formula Challenge!Transpose & Formula Challenge #3: Alphabetical sorthttps://mailchi.mp/benlcollins/transpose-and-formula-challenge-3
8627-Jan-2020Google Sheets Tip: Transpose Formula Challenge Solution!Formula Challenge 3 Solutionhttps://mailchi.mp/benlcollins/formula-challenge-3-solution
873-Feb-2020Google Sheets Tip: Create Data With RandarrayCreate data with RANDARRAY functionhttps://mailchi.mp/benlcollins/randarray
8810-Feb-2020Google Sheets Tip: SWITCH functionSwitch functionhttps://mailchi.mp/benlcollins/switch-function
8917-Feb-2020Google Sheets Tip: Upgrade Your Apps Script!V8 runtimehttps://mailchi.mp/benlcollins/v8-runtime
9024-Feb-2020Google Sheets Tip: Rolling Average FormulaRolling average calculationhttps://mailchi.mp/benlcollins/rolling-average
912-Mar-2020Google Sheets Tip: Conditional Sparklines 📊Conditional sparklineshttps://mailchi.mp/benlcollins/conditional-sparklines
929-Mar-2020Google Sheets Tip: Trace Precedents With F2F2 pressed twice takes you to the rangehttps://mailchi.mp/benlcollins/trace-precedents
9316-Mar-2020Google Sheets Tip: Group Columns TrickGroup rows and columns - right click to customizehttps://mailchi.mp/benlcollins/group-columns-side-panel
9423-Mar-2020Google Sheets Tip: Organize TabsTab separatorshttps://mailchi.mp/benlcollins/organize-tabs
9530-Mar-2020Google Sheets Tip: Pivot Date Trick 📅Pivot Group Rule for Dateshttps://mailchi.mp/benlcollins/pivot-date-group
966-Apr-2020Google Sheets Tip: Pivot Custom Text Groups 📂Custom Grouping by highlighted valueshttps://mailchi.mp/benlcollins/pivot-text-group
9713-Apr-2020Google Sheets Tip: Pivot Table Bins, huh?Pivot Group Rule for Valueshttps://mailchi.mp/benlcollins/pivot-value-group
9820-Apr-2020Google Sheets Tip: Bullet ChartsBullet chartshttps://mailchi.mp/benlcollins/bullet-chart
9927-Apr-2020Google Sheets Tip: Find Last Non-Blank RowLast Non Blank Rowhttps://mailchi.mp/benlcollins/last-non-blank-row
1004-May-2020100 Google Sheets Tips Ebook 🎁 & Hyperlink Next Blank RowMonday Tips 100! Hyperlink to next blank cellhttps://mailchi.mp/benlcollins/hyperlink-next-blank-row
10111-May-2020Google Sheets Tip: Conditional Conditional FormattingConditional conditional formattinghttps://mailchi.mp/benlcollins/conditional-conditional-formatting
10218-May-2020Google Sheets Tip: Tab TricksTab tricks (move, hide, create, duplicate, shortcuts, double-click to rename, color separators, copy tohttps://mailchi.mp/benlcollins/tab-tricks
10325-May-2020Google Sheets Tip: Remove Line BreaksRemove line breaks with regexhttps://mailchi.mp/benlcollins/remove-line-breaks
1041-Jun-2020Google Sheets Tip: Multi-hyperlinks In A Single CellMultiple hyperlinks in single cellhttps://mailchi.mp/benlcollins/multiple-hyperlinks
1058-Jun-2020Google Sheets Tip: Auto Generate ID ColumnAuto ID numberinghttps://mailchi.mp/benlcollins/auto-generate-id-column
10615-Jun-2020A Google Sheets Tip hiding in plain sightTemplate Galleryhttps://mailchi.mp/benlcollins/template-gallery
10722-Jun-2020Google Sheets Tip: Show/Hide solutions and hints in workbooksNew Course Launch + IF/checkboxeshttps://mailchi.mp/benlcollins/if-with-checkbox
10829-Jun-2020GSheets Tip: Randomize Ranges & A Formula ChallengeRandomize range & formula challenge #4https://mailchi.mp/benlcollins/randomize-ranges-and-formula-challenge
1096-Jul-2020GSheets Tip: The Future, SORT and the Challenge SolutionFormula challenge #4 solutionhttps://mailchi.mp/benlcollins/sort-formula-challenge-4-solution
11013-Jul-2020Google Sheets Tip: Return Multiple Values With VlookupReturn multiple column values with vlookuphttps://mailchi.mp/benlcollins/vlookup-multiple-columns
11120-Jul-2020GSheets Tip: Find Formula Errors With Conditional FormattingCatching Errors With Conditional Formattinghttps://mailchi.mp/benlcollins/find-formula-errors-with-conditional-formatting
11227-Jul-2020GSheets Tip: How To Add Google Photos Into Your SheetsHow To Add Google Photos into your Sheetshttps://mailchi.mp/benlcollins/gsheets-tip-how-to-add-google-photos-to-your-sheets
1133-Aug-2020GSheets Tip: Hidden Currency ConverterConvert currencies with functionshttps://mailchi.mp/benlcollins/currency-converter
11410-Aug-2020GSheets Tip: Indicator Arrows in Pivot Tables 🔼Indicator lights in pivot tableshttps://mailchi.mp/benlcollins/gsheets-tip-indicator-arrows-in-pivot-tables
11517-Aug-2020GSheets Tip: Importrange Formula Know-HowImportRange knowledgehttps://mailchi.mp/benlcollins/gsheets-tip-importrange-permissions
11624-Aug-2020GSheets Tip: Share Sensitive Sheets SafelyCreate a copy to remove version history before sharinghttps://mailchi.mp/benlcollins/gsheets-tip-share-copy
11731-Aug-2020GSheets Tip: Format Numbers Like An AccountantCustom Number Formatting - add color and brackets to negative numbershttps://mailchi.mp/benlcollins/gsheets-tip-accounting-number-format
1187-Sep-2020GSheets Tip: Must-Know Fact About The QUERY FunctionA, B, C vs. Col1, Col2, Col3 in Queryhttps://mailchi.mp/benlcollins/gsheets-tip-must-know-fact-about-query-function
11914-Sep-2020GSheets Tip: Track G Suite Updates With This FormulaG Suite Updates with IMPORTFEEDhttps://mailchi.mp/benlcollins/gsheets-tip-track-g-suite-updates
12021-Sep-2020GSheets Tip: Dinosaurs, Time and Large Numbers 🐲Thought experiment with dinosaurs and large numbers! Something different ;)https://mailchi.mp/benlcollins/gsheets-tip-dinosaurs-time-and-large-numbers
12128-Sep-2020GSheets Tip: Countdown functionCount down reverse number formathttps://mailchi.mp/benlcollins/gsheets-tip-countdown-function
1225-Oct-2020GSheets Tip: Subscripts with formulasSubscript values e.g chemical formulashttps://mailchi.mp/benlcollins/gsheets-tip-subscripts-with-formulas
12312-Oct-2020GSheets Tip: Wildcards In Formulas 🌟Wildcards in formulashttps://mailchi.mp/benlcollins/gsheets-tip-wildcards-in-formulas
12419-Oct-2020GSheets Tip: Select/Deselect all Checkboxes at once ☑Select all checkboxes at once with space barhttps://mailchi.mp/benlcollins/gsheets-tip-select-all-checkboxes
12526-Oct-2020GSheets Tip: Custom Checkbox Values & Teacher Template ExampleCheckbox with custom valueshttps://mailchi.mp/benlcollins/gsheets-tip-custom-checkbox-values
1262-Nov-2020GSheets Tip: Remove the header row from QUERY resultsWrap QUERY with INDEX function to remove headerhttps://mailchi.mp/benlcollins/gsheets-tip-remove-query-header-row
1279-Nov-2020GSheets Tip: How To Draw A Slope ChartHow to draw a slope charthttps://mailchi.mp/benlcollins/gsheets-tip-slope-chart
12816-Nov-2020GSheets Tip: Draw A Chart With The Sequence FormulaHow to draw a grid charthttps://mailchi.mp/benlcollins/gsheets-tip-grid-chart
12923-Nov-2020GSheets Tip: Show Project Completion StatusSparkline status barhttps://mailchi.mp/benlcollins/gsheets-tip-sparkline-status-bar
13030-Nov-2020GSheets Tip: Have you ever heard of GESTEP?GESTEP functionhttps://mailchi.mp/benlcollins/gsheets-tip-gestep-function
1317-Dec-2020GSheets Tip: Apps Script just got a facelift!New Apps Script IDEhttps://mailchi.mp/benlcollins/gsheets-tip-new-apps-script-ide
13214-Dec-2020GSheets Tip: How To Select Randomly From A ListRANDBETWEEN and INDEX to select an item from a listhttps://mailchi.mp/benlcollins/gsheets-tip-select-randomly-from-list
13321-Dec-2020GSheets Tip: TEXTJOIN and Formula Challenge #5Formula Challenge #5: Unique numbershttps://mailchi.mp/benlcollins/gsheets-tip-textjoin-and-formula-challenge-5
1344-Jan-2021GSheets Tip: FLATTEN function?? Plus, Challenge #5 solutionFormula Challenge #5 Solution & Flatten functionhttps://mailchi.mp/benlcollins/gsheets-tip-flatten-and-formula-challenge-5-solution
13511-Jan-2021GSheets Tip: Two Number Formats in One ColumnDouble Format for column with % and number rule: [<1]0.0%;#,##0https://mailchi.mp/benlcollins/gsheets-tip-double-number-format
13618-Jan-2021GSheets Tip: Walk The First RowTell the story of one row + micro IPhttps://mailchi.mp/benlcollins/gsheets-tip-walk-the-first-row
13725-Jan-2021GSheets Tip: How to format your header rowThe right way to format your header rowshttps://mailchi.mp/benlcollins/gsheets-tip-header-row
1381-Feb-2021GSheets Tip: Cakes and Column StatsExplore your data with column statshttps://mailchi.mp/benlcollins/gsheets-tip-column-stats
1398-Feb-2021GSheets Tip: Why automate?Why you should learn automationhttps://mailchi.mp/benlcollins/gsheets-tip-why-automate
14015-Feb-2021GSheets Tip: To script or not to script...When to use apps script or not?https://mailchi.mp/benlcollins/gsheets-tip-to-script-or-not-to-script
14122-Feb-2021GSheets Tip: Toast To The Rescue 🍞Toasthttps://mailchi.mp/benlcollins/gsheets-tip-toast
1421-Mar-2021GSheets Tip: Let's build a Sheet Sizer tool together! 🔧Automation launch & Sheet Sizerhttps://mailchi.mp/benlcollins/gsheets-tip-sheet-sizer-1
1438-Mar-2021GSheets Tip: An Elegant FormulaSequence + Date Array Formulahttps://mailchi.mp/benlcollins/gsheets-tip-monthly-sequence
14415-Mar-2021GSheets Tip: The Beginner's MindsetThe Beginner's Mindsethttps://mailchi.mp/benlcollins/gsheets-tip-beginners-mindset
14522-Mar-2021GSheets Tip: Extract the n-th wordExtract nth word from sentencehttps://mailchi.mp/benlcollins/gsheets-tip-word-games-with-split
14629-Mar-2021GSheets Tip: The Taco Chart!Bar chart with REPT Functionhttps://mailchi.mp/benlcollins/gsheets-tip-rept-function-taco-chart
1475-Apr-2021GSheets Tip: 6 Creative Ways To Use BordersDifferent border examples in Sheets & pro sheets enrollment in PShttps://mailchi.mp/benlcollins/gsheets-tip-borders
14812-Apr-2021GSheets Tip: Google's hidden logo libraryGet company logos using Google's hidden APIhttps://mailchi.mp/benlcollins/gsheets-tip-google-logo-library
14919-Apr-2021GSheets Tip: Are they equal?Test if values are equal with equality operator, exact function and array formulahttps://mailchi.mp/benlcollins/gsheets-tip-equal
15026-Apr-2021GSheets Tip: 🟩🟩🟩🟩🟩🟩⬜⬜⬜⬜Progress bar charts with REPT and SPARKLINEhttps://mailchi.mp/benlcollins/gsheets-tip-progress-chart
1513-May-2021GSheets Tip: Home, sheet home 🏠Set a Google Sheet as your Chrome home pagehttps://mailchi.mp/benlcollins/gsheets-tip-home-sheet
15210-May-2021GSheets Tip: Array Formula to get row numbersRow numbers of non-blank cellshttps://mailchi.mp/benlcollins/gsheets-tip-row-numbers-non-blank
15317-May-2021GSheets Tip: Filter FunctionFilter function to find row numbers of non-blank cellshttps://mailchi.mp/benlcollins/gsheets-tip-filter-function
15424-May-2021GSheets Tip: Flatten FunctionFLATTEN functionhttps://mailchi.mp/benlcollins/gsheets-tip-flatten-function
15531-May-2021GSheets Tip: Find the last value in a rowFind last value in a rowhttps://mailchi.mp/benlcollins/gsheets-tip-find-the-last-value-in-a-row
1567-Jun-2021GSheets Tip: CHOOSE your own adventureChoose functionhttps://mailchi.mp/benlcollins/gsheets-tip-choose-function
15714-Jun-2021GSheets Tip: Random List Picker FormulaSelect Random element from listhttps://mailchi.mp/benlcollins/gsheets-tip-random-list-picker-formula
15821-Jun-2021GSheets Tip: Turbocharge your checkboxes ✅Uncheck with Apps Scripthttps://mailchi.mp/benlcollins/gsheets-tip-turbocharge-checkboxes
15928-Jun-2021GSheets Tip: Better Data Management with the Range Name BoxRange Name Boxhttps://mailchi.mp/benlcollins/gsheets-tip-range-name-box
1605-Jul-2021GSheets Tip: Generate A Year Of DatesYear Sequence Formulahttps://mailchi.mp/benlcollins/gsheets-tip-generate-dates-automatically
16112-Jul-2021GSheets Tip: REGEX, not as hard as it looks...REGEX formulas introduction, extract numbers examplehttps://mailchi.mp/benlcollins/gsheets-tip-regex-introduction
16219-Jul-2021GSheets Tip: Extract numbers from textREGEX part 2: extract number with thousand separators, decimals etc.https://mailchi.mp/benlcollins/gsheets-tip-regex-extract-numbers
16326-Jul-2021GSheets Tip: Oops, I made a mistake...REGEX part 2 fix: fix the mistake with the repetition characterhttps://mailchi.mp/benlcollins/gsheets-tip-regex-extract-numbers-fix
1642-Aug-2021GSheets Tip: Match telephone numbers 📞REGEX part 3: Extract phone number from stringhttps://mailchi.mp/benlcollins/gsheets-tip-regex-match-telephone-numbers
1659-Aug-2021GSheets Tip: Clever formula to switch name orderREGEX part 4: Identify transactional stringhttps://mailchi.mp/benlcollins/gsheets-tip-regex-name-swaperoo
16616-Aug-2021GSheets Tip: Go BigMaximise spacehttps://mailchi.mp/benlcollins/gsheets-tip-go-big
16723-Aug-2021GSheets Tip: Add Row Numbers DynamicallyAdding Row Numbers Dynamicallyhttps://mailchi.mp/benlcollins/gsheets-tip-add-row-numbers-dynamically
16830-Aug-2021GSheets Tip: How to create a slopegraph in SheetsSlopegraph tutorialhttps://mailchi.mp/benlcollins/gsheets-tip-slopegraph
1696-Sep-2021GSheets Tip: Yet another reason to use named ranges...Named Range in IMPORTRANGEhttps://mailchi.mp/benlcollins/gsheets-tip-named-ranges-importrange
17013-Sep-2021GSheets Tip: The REGEX cookbookLaunch REGEX cookbookhttps://mailchi.mp/benlcollins/gsheets-tip-floating-bars
17120-Sep-2021GSheets Tip: The Right Formula And Radial Bar ChartsUse the right formula for the jobhttps://mailchi.mp/benlcollins/gsheets-tip-use-the-right-formula
17227-Sep-2021GSheets Tip: Formula To Turn Column Numbers To LettersGoing from column number to column letterhttps://mailchi.mp/benlcollins/gsheets-tip-convert-column-number-to-letter
1734-Oct-2021New look GSheets Tip: Column Letters to NumbersConvert column letter to numberhttps://mailchi.mp/benlcollins/gsheets-tip-convert-column-letter-to-number
17411-Oct-2021Sheets Tip #174: 10 free days this month!Networkdayshttps://mailchi.mp/benlcollins/gsheets-tip-networkdays
17518-Oct-2021Sheets Tip #175: QUERY function filtering trick...QUERY where clause "starts with"https://mailchi.mp/benlcollins/gsheets-tip-query-starts-with
17625-Oct-2021Sheets Tip 176: Apostrophes in the QUERY functionQUERY and apostropheshttps://mailchi.mp/benlcollins/gsheets-tip-query-apostrophes
1771-Nov-2021Sheets Tip 177: AI assisted data cleaning 🗑️Cleanup suggestionshttps://mailchi.mp/benlcollins/gsheets-tip-177-cleanup-suggestions
1788-Nov-2021Sheets Tip 178: Make Formulas More ReadableMake your formulas more readable by resizing and adding new lineshttps://mailchi.mp/benlcollins/gsheets-tip-178-readable-formulas
17915-Nov-2021Sheets Tip 179: Advanced VLOOKUP for multi-column lookupsMulti-Column Lookuphttps://mailchi.mp/benlcollins/gsheets-tip-179-vlookup-multi-column-lookup
18022-Nov-2021Sheets Tip 180: Lists Of Grouped Numbers With SEQUENCELists of grouped numbers with sequencehttps://mailchi.mp/benlcollins/gsheets-tip-180-grouped-numbers-sequence
18129-Nov-2021Sheets Tip 181: Shortcuts You Should UseShortcuts for working with rangeshttps://mailchi.mp/benlcollins/gsheets-tip-181-range-shortcuts
1826-Dec-2021Sheets Tip 182: SUMPRODUCT, a powerful but enigmatic functionSomething with sumproducthttps://mailchi.mp/benlcollins/gsheets-tip-182-sumproduct
18313-Dec-2021Sheets Tip 183: Weighted average with SUMPRODUCT ⚖️Follow up to sumproduct: weigted avearge examplehttps://mailchi.mp/benlcollins/gsheets-tip-183-sumproduct-weighted-average
18420-Dec-2021Sheets Tip 184: CHICKEN and EGG finally solved! 🐣Chicken and egg sorthttps://mailchi.mp/benlcollins/gsheets-tip-184-chicken-egg-sort
1853-Jan-2022Sheets Tip 185: 2 Quick Ways To Create New SheetsTwo quick ways to create a new Sheethttps://mailchi.mp/benlcollins/gsheets-tip-185-new-sheets
18610-Jan-2022Sheets Tip 186: A Creative Use Case For SlicersCreative way to use a slicer for sections of a sheethttps://mailchi.mp/benlcollins/gsheets-tip-186-creative-slicers
18717-Jan-2022Sheets Tip 186: The Finder Tool 🔎The finder toolhttps://mailchi.mp/benlcollins/gsheets-tip-187-finder-tool
18824-Jan-2022Sheets Tip 188: Going dotty...Dot Plothttps://mailchi.mp/benlcollins/gsheets-tip-188-dot-plot
18931-Jan-2022Sheets Tip 189: How To Reference Cells in QUERY SELECT 👀How to select other cells from inside the QUERY functionhttps://mailchi.mp/benlcollins/gsheets-tip-189-query-external-cells
1907-Feb-2022Sheets Tip 190: Publish To Web & Formula StudioPublish to web and formula studiohttps://mailchi.mp/benlcollins/gsheets-tip-190-publish-to-web
19114-Feb-2022Sheets Tip 191: Add an auto-incrementing row ID 📶Auto-incrementing row ID columnhttps://mailchi.mp/benlcollins/gsheets-tip-191-auto-incrementing-id
19221-Feb-2022Sheets Tip 192: SEQUENCE DataGenerate dummy data with sequencehttps://benlcollins.ck.page/posts/sheets-tip-192-sequence-data
19328-Feb-2022Sheets Tip 193: Conditional counts with COUNTIFCOUNTIF with wildcardshttps://benlcollins.ck.page/posts/sheets-tip-193-conditional-counts-with-countif
1947-Mar-2022Sheets Tip 194: Formula Challenge #6 💥MID and Formula challenge 6: randomize lettershttps://benlcollins.ck.page/posts/sheets-tip-194-formula-challenge-6
19514-Mar-2022Sheets Tip 195: SEQUENCE and Formula Challenge 6 solutionFormula challenge 6 solutionhttps://benlcollins.ck.page/posts/sheets-tip-195-pi-sequence-and-formula-challenge-6-solution
19621-Mar-2022Sheets Tip 196: Wow, so many viewsSheets Activity Dashboardhttps://benlcollins.ck.page/posts/sheets-tip-196-wow-so-many-views
19728-Mar-2022Sheets Tip 197: Highlight Top 10Highlight top 5 or top 10https://benlcollins.ck.page/posts/sheets-tip-197-highlight-top-5
1984-Apr-2022Sheets Tip 198: Two Methods To Trim WhitespaceTrim whitespacehttps://benlcollins.ck.page/posts/sheets-tip-198-two-methods-to-trim-whitespace
19911-Apr-2022Sheets Tip 199: IMPORTRANGE Backlink To Source FormulaImportRange backlinkshttps://benlcollins.ck.page/posts/sheets-tip-199-importrange-backlink-to-source-sheet
20018-Apr-2022200 spreadsheet espressos! 🎉200 milestone and audience surveyhttps://benlcollins.ck.page/posts/200-spreadsheet-espressos
20125-Apr-2022Sheets Tip 201: Copy Visible Cells OnlyCopy only visible cellhttps://benlcollins.ck.page/posts/sheets-tip-201-copy-visible-cells-only
2022-May-2022Sheets Tip 202: Meet within a SheetMeet and Sheethttps://benlcollins.ck.page/posts/sheets-tip-202-meet-within-a-sheet
2039-May-2022Sheets Tip 203: How To Use Arrays To Return Multiple Columns In VLOOKUPHow to create arrayshttps://benlcollins.ck.page/posts/sheets-tip-203-how-to-use-arrays-to-return-multiple-columns-in-vlookup
20416-May-2022Sheets Tip 204: How To Use Dates In The QUERY FunctionDates with the QUERY function and QUERY function launchhttps://benlcollins.ck.page/posts/sheets-tip-204-how-to-use-dates-in-the-query-function
20523-May-2022Sheets Tip #205: The hidden powers of custom numbers formats... 👀Custom number formatshttps://benlcollins.ck.page/posts/sheets-tip-205-the-hidden-powers-of-custom-numbers-formats
20630-May-2022Sheets Tip 206: Create barcodes in Sheets ║█║▌║█║▌│║▌║▌█║Barcodes in Sheetshttps://benlcollins.ck.page/posts/sheets-tip-206-create-barcodes-in-sheets
2076-Jun-2022Sheets Tip 207: Get unique values from grouped listsGet unique values from grouped listshttps://benlcollins.ck.page/posts/sheets-tip-207-get-unique-values-from-grouped-lists
20813-Jun-2022Sheets Tip 208: Google Finance 5 secrets & An equation to change your worldview5 Secrets of the Google Finance Functionhttps://benlcollins.ck.page/posts/sheets-tip-208-google-finance-5-secrets-an-equation-to-change-your-worldview
20920-Jun-2022Sheets Tip 209: New lines with the magic CHAR functionAdd line breaks to strings with CHAR(10)https://benlcollins.ck.page/posts/sheets-tip-209-new-lines-with-the-magic-char-function
21027-Jun-2022Sheets Tip 210: Day first or month first? Fixing mixed date columnsFixing Dates in mixed column of US and UK typeshttps://benlcollins.ck.page/posts/sheets-tip-210-day-first-or-month-first-fixing-mixed-date-columns
2115-Jul-2022Sheets Tip 211: Spreadsheet Competition & How To Open All Links At OnceOpen all links at oncehttps://benlcollins.ck.page/posts/sheets-tip-211-spreadsheet-competition-how-to-open-all-links-at-once
21211-Jul-2022Sheets Tip 212: Single Formula Year Calendar! 🗓Calendar with SEQUENCE functionhttps://benlcollins.ck.page/posts/sheets-tip-212-single-formula-year-calendar
21318-Jul-2022Sheets Tip 213: Improvements to the single formula calendarCalendar with SEQUENCE function - Part IIhttps://benlcollins.ck.page/posts/sheets-tip-213-improvements-to-the-single-formula-calendar
21425-Jul-2022Sheets Tip 214: Changing Sheets Ownership 🔐Change owner of a Google Sheethttps://benlcollins.ck.page/posts/sheets-tip-214-changing-sheets-ownership
2151-Aug-2022Sheets 215: Understanding Spreadsheet ErrorsUnderstanding spreadsheet errorshttps://benlcollins.ck.page/posts/sheets-215-understanding-spreadsheet-errors
2168-Aug-2022Sheets Tip 216: Dashboard Ideas!Dashboard Ideashttps://benlcollins.ck.page/posts/sheets-tip-216-dashboard-ideas
21715-Aug-2022Sheets Tip 217: Three Tips For Better Navigation 🧭Go To Navigation (F2 inside formulas, copying range into reference bar, hidden Go To)https://benlcollins.ck.page/posts/sheets-tip-217-three-tips-for-better-navigation
21822-Aug-2022Sheets Tip 218: Amazing In-Cell Sparkline Progress ChartsSparkline Progress Bar Chartshttps://benlcollins.ck.page/posts/sheets-tip-218-amazing-in-cell-sparkline-progress-charts
21929-Aug-2022Sheets Tip 219: The new Named Functions are a game changerNamed functionshttps://benlcollins.ck.page/posts/sheets-tip-219-the-new-named-functions-are-a-game-changer
2206-Sep-2022Sheets Tip 220: The new MAP function! 🗺️The MAP functionhttps://benlcollins.ck.page/posts/sheets-tip-220-the-new-map-function
22112-Sep-2022Sheets Tip 221: Pivot like a pro!Pivot table 3 tipshttps://benlcollins.ck.page/posts/sheets-tip-221-pivot-like-a-pro
22219-Sep-2022Sheets Tip 222: Formulas to build lists like 1 of 10, 2 of 10, etc.1 of 10 sequenceshttps://benlcollins.ck.page/posts/sheets-tip-222-formulas-to-build-lists-like-1-of-10-2-of-10-etc
22326-Sep-2022Sheets Tip 223: Sort by length formulaSort by lengthhttps://benlcollins.ck.page/posts/sheets-tip-223-sort-by-length-formula
2243-Oct-2022Sheets Tip 224: I do this with every new dataset...Steps I take with every new tablehttps://benlcollins.ck.page/posts/sheets-tip-224-i-do-this-with-every-new-dataset
22510-Oct-2022Sheets Tip 225: Stack two tables dynamicallyStack two tables with the {...} array literalshttps://benlcollins.ck.page/posts/sheets-tip-225-stack-two-tables-dynamically
22617-Oct-2022Sheets Tip 226: New Announcements From The Google Conference 🧐Google Cloud Next Recaphttps://benlcollins.ck.page/posts/sheets-tip-226-new-announcements-from-the-google-conference-1
22724-Oct-2022Sheets Tip 227: Yet more ways to stack tables...Stack two tables with QUERY function alternativehttps://ckarchive.com/b/68ueh8hkw3dp6
22831-Oct-2022Sheets Tip 228: Mega running total SCAN formulas & halloween functions 🎃Scan functionhttps://benlcollins.ck.page/posts/sheets-tip-228-mega-running-total-scan-formulas-halloween-functions
2297-Nov-2022Sheets Tip 229: My most heavily used shortcutCopy and Paste Specialhttps://benlcollins.ck.page/posts/sheets-tip-229-my-most-frequently-used-shortcut
23014-Nov-2022Sheets Tip 230: How to add indicator arrows to dataIndicator Arrows, mention Black Friday sale coming uphttps://benlcollins.ck.page/posts/sheets-tip-230-how-to-add-indicator-arrows-to-data
23121-Nov-2022Sheets Tip 231: Never again miss a change to your SheetBlack Friday weekhttps://benlcollins.ck.page/posts/sheets-tip-231-never-again-miss-a-change-to-your-sheet
2325-Dec-2022Sheets Tip 232: New Timeline (Gantt) Charts in SheetsNew timeline chartshttps://benlcollins.ck.page/posts/sheets-tip-232-new-chart-in-sheets-timeline-view-aka-gantt-charts
23312-Dec-2022Sheets Tip 233: How to categorize data with IFSHow to categorize with IFShttps://benlcollins.ck.page/posts/sheets-tip-233-how-to-categorize-data-with-ifs
23419-Dec-2022Sheets Tip 234: Freeze rows with Grabby HandFreeze rows with grabby handhttps://benlcollins.ck.page/posts/sheets-tip-234-freeze-rows-with-grabby-hand
2353-Jan-2023Sheets Tip 235: Secret Date Trick and a Happy New Year! 🎉Date pickerhttps://benlcollins.ck.page/posts/sheets-tip-235-secret-date-trick-and-a-happy-new-year
2369-Jan-2023Sheets Tip 236: New Drop-Down Chips!New drop down menus + update blog posthttps://benlcollins.ck.page/posts/sheets-tip-236-new-drop-down-chips

Commentaires

Enregistrer un commentaire

🖐 Hello,
N'hésitez pas à commenter ou vous exprimer si vous avez des trucs à dire . . .👉

Posts les plus consultés de ce blog

💥 TOP Best Chat GPT Prompts for Marketers - 2024

-
Image
110 Best Chat GPT Prompts for Marketers 110 meilleures invites de chat GPT pour les spécialistes du marketing Dernière mise à jour : 2 janvier 2024 à 16h28 Par MUKUND KAPOOR  - Auteur 15 minutes de lecture 15 minutes de lecture PARTAGER Contenu Meilleures invites GPT de chat pour les spécialistes du marketing FAQ Comment Chat GPT peut-il aider les spécialistes du marketing ? Chat GPT peut-il remplacer les représentants du service client humain ? Lire plus d'articles Les invites ChatGPT sont l'outil idéal pour les spécialistes du marketing qui souhaitent que leur contenu soit plus créatif. ChatGPT a tout ce dont vous avez besoin pour créer des publications intéressantes sur les réseaux sociaux, des campagnes par e-mail efficaces et d'excellents articles de blog. En pouvant modifier les invites, vous pouvez vous assurer que chaque élément de contenu correspond au message que vous souhaitez envoyer. Grâce à sa capacité à comprendre le contexte et à générer des réponses basées
Lire la suite

La liste de contrôle SEO

-
Image
  La liste de contrôle SEO complète en 51 points pour 2022 Si vous essayez de trouver un processus précis, étape par étape, que vous pouvez utiliser pour générer plus de trafic et de clients vers votre site Web à partir des moteurs de recherche, vous allez adorer cette liste de contrôle SEO.  C'est exactement la liste de contrôle que nous avons utilisée pour augmenter notre trafic organique de 145 % l'année dernière. Retour au blogue Table des matières Aperçu de la liste de contrôle SEO Chapitre 1 : Principes de base du référencement Chapitre 2 : Liste de contrôle pour la recherche de mots-clés Chapitre 3 : Liste de contrôle SEO sur la page Chapitre 4 : Liste de contrôle pour la création de liens Chapitre 5 : Liste de contrôle technique SEO Chapitre 6 : Suivi et plus En conclusion Aperçu de la liste de contrôle SEO La première chose que la plupart des gens font lorsqu'ils voient notre liste de contrôle pour la première fois, c'est paniquer. Ne fais pas ça ! Cela peut se
Lire la suite

Meilleurs outils de référencement 🛠 organisée par Saijo George

-
Image
Meilleurs outils de référencement 🛠 organisée par Saijo George #débutants Beginner's Guides référencement Résumé des actualités SEO Guide du débutant en référencement Académie ContentKing hreflang Guide Google's SEO Guide Bing Webmaster Guide Comment fonctionne Google par Paul Haahr Comment Google fonctionne pour les sites lourds JS À propos des URL, LazyLoading, etc. Liste de lecture SEO Javascript Plato Web Design SEO Guide Fonctionnement de la recherche L'anatomie d'une page Web parfaite Comment Google explore une page Web Webmaster Guidelines Guide du débutant pour la création de liens Consignes relatives à l'évaluation de la qualité Google – 28 mars 2016 Microsoft Excel for SEOs Suppression des pénalités Google Web Performance 101 Guide d'optimisation de la vitesse du site Web Analyse des fichiers journaux pour le référencement Idées créatives de création de liens Mobile Measurement Glossary Marketing Plan directeur Facebook Google Digital Garage Comment d
Lire la suite

Insérer un formulaire de contact - Zbooing : Astuces pour Google Sites

-
Image
Insérer un formulaire de contact - Zbooing : Astuces pour Google Sites Insérer un formulaire de contact publié le  15 oct. 2009, 22:10  par Zboo Ing    [ mis à jour :  26 févr. 2013, 19:30  ] Laisser  son adresse email directement sur internet  est aujourd'hui un processus  risqué . Vous risquez en effet de rapidement vous retrouver inondé de  spams  vous proposant des services  indésirables  qui vous proposent d'élargir diverses parties de votre anatomie et bien d'autres perspectives réjouissantes. Pour éviter cela, vous pouvez mettre en place un  formulaire de contact sur votre site  : un  questionnaire  à partir duquel  votre lecteur  peut  directement  vous  transmettre un message  sans pour autant connaître votre adresse  email . Grace à ce tutoriel, vous recevrez par email les messages laissés par les internautes qui visitent votre site. Cette astuce ne nécessite pas de compétences spéciales en informatique. Il existe sur internet quantité de tutoriels pour vous expli
Lire la suite

100 outils pour lancer sa startup sans argent (mais pas sans talent)

-
Image
100 outils pour lancer sa startup sans argent (mais pas sans talent) 100 outils pour lancer sa startup sans développeur ni graphiste (et presque sans argent) Vous êtes entrepreneur·e ? Maddyness vous a concocté un véritable kit pour créer, faire grandir et même vendre votre startup. Du recrutement au financement, vous retrouverez astuces et bonnes pratiques pour vous sortir de ce labyrinthe qu'est l'entrepreneuriat. Dans cette fiche : une centaine d'outils pour se lancer en économisant son temps, et son argent ! PARTAGER SIGNALER UNE ERREUR ENREGISTRER PDF / EXPORTER DANS CET ARTICLE 1. Le graphisme (design, photos, vidéos...) 2. Le prototypage 3. Le site de présentation et la landing page 4. Un site e-commerce 5. Les outils social media (contenus, reach, automatisation...) 6. L'emailing 7. La gestion de projet (communiquer, brainstormer, organiser) 8. La vente 9. Les applications mobiles 10. L'administratif, le financier, le réglementaire 11. L'analytique et le
Lire la suite

30 prompts marketing ChatGPT à utiliser d'urgence ! | Conseils Rédaction Web

-
Image
30 prompts marketing ChatGPT à utiliser d'urgence ! | Conseils Rédaction Web 30 PROMPTS MARKETING CHATGPT À UTILISER D’URGENCE ! Mis à jour le 28/11/2023 | Publié le 09/02/2023 Plusieurs mois après son lancement,  ChatGPT  s’est durablement installé auprès de tous les utilisateurs d’internet. La version GPT-4, actuellement déployée dans le monde et beaucoup plus puissante, devrait encore augmenter notre dépendance à l’outil (même si ChatGPT est loin d’être parfait, et peut présenter des  failles assez dangereuses ). En restant  accessible au plus grand nombre,  ChatGPT va révolutionner en profondeur notre manière de rechercher l’information (Bing a déjà  implémenté l’IA  dans son moteur de recherche). Et c’est particulièrement vrai pour tous les professionnels du digital, qui ne peuvent plus s’en passer. Alors, quels sont  les prompts qui marchent vraiment pour obtenir des « outputs » utilisables au quotidien , et gagner en productivité ? Voici une liste de 30 prompts marketing Cha
Lire la suite

💥Top BEST invites ChatGPT pour le succès du dropshipping *° 2024

-
Image
Liens --> https://www.google.com/search?q=Best+prompt+chatgpt%2B+aliexpress+dropship&newwindow=1&sca_esv=c51a80de1a7d45f0&sca_upv=1&rlz=1C1CHZN_frFR1078FR1078&sxsrf=ACQVn0-ZZBXVST5KmsjcconAXXhesfC6tg%3A1707763995334&ei=G2nKZdj-E4ulkdUPgoWfyAQ&ved=0ahUKEwiY-LTSvKaEAxWLUqQEHYLCB0kQ4dUDCBA&uact=5&oq=Best+prompt+chatgpt%2B+aliexpress+dropship&gs_lp=Egxnd3Mtd2l6LXNlcnAiKEJlc3QgcHJvbXB0IGNoYXRncHQrIGFsaWV4cHJlc3MgZHJvcHNoaXAyBxAhGAoYoAEyBxAhGAoYoAEyBxAhGAoYoAFIl4IBUABYh31wAHgBkAEAmAHxAaABnCCqAQYxLjMwLjG4AQPIAQD4AQHCAggQABgHGB4YE8ICChAAGAcYHhgTGArCAgYQABgHGB7CAggQABgHGB4YCsICCBAAGAgYBxgewgIIEAAYBRgHGB7CAgcQABiABBgNwgIJEAAYgAQYDRgKwgIGEAAYFhgewgIIEAAYFhgeGArCAgkQIRgKGKABGArCAggQABiABBiiBMICBBAhGBXiAwQYACBB&sclient=gws-wiz-serp https://promptadvance.club/chatgpt-prompts/chat-gpt-prompts-for-dropshipping?newsletter= https://blog.ecomhunt.com/2023/06/26/8-chatgpt-prompts-for-your-dropshipping-store/ https://www.autods.com/blog/dropshipping-tips-strat
Lire la suite

Questions et réponses sur l'évaluation de la certification YouTube Music en 2021 + examen final Certification Ateliers Numériques 2022

-
Image
Questions et réponses sur l'évaluation de la certification YouTube Music en 2021 Réponses examen final Certification Ateliers Numériques 2022 https://www.certificationanswers.com/fr/category/principes-fondamentaux-du-marketing-numerique-de-google-ateliers-numeriques/ https://certprep.fr/ https://www.facebook.com/certificationanswers/posts/385973622058117/ https://yzydo.com/fr/blog/ https://dmcceqa.com/fundamentals-of-digital-marketing-answers-google-digital-garage-exam-digital-skills-digital-unlocked/ https://www.youtube.com/watch?v=NXSfRWF88E8 https://www.youtube.com/watch?v=ezyuhXHrBHw https://www.youtube.com/watch?v=l3qxeyXMT3w Réponses à la Certification YouTube Musique – Évaluation YouTube pour les artistes https://certprep.fr/reponses-evaluation-youtube-musique/#:~:text=La%20certification%20YouTube%20Music%20est,en%20moins%20de%2015%20minutes. https://www.seoaimpoint.com/blog/youtube-music-assessment-answers.php https://yojana4u.com/youtube-music-certification-exam-answers/ h
Lire la suite

La liste de contrôle SEO complète en 51 points pour 2024

-
Image
La liste de contrôle SEO complète en 51 points pour 2024 La liste de contrôle SEO complète en 51 points pour 2024 Si vous essayez de trouver un processus précis, étape par étape, que vous pouvez utiliser pour générer plus de trafic et de clients vers votre site Web à partir des moteurs de recherche, vous allez adorer cette liste de contrôle SEO.  C'est la liste de contrôle exacte que nous avons utilisée pour augmenter notre trafic organique de 145 % l'année dernière. Tommy Griffith 14 décembre 2023 26 minutes.  lire Retour au blog Table des matières Aperçu de la liste de contrôle SEO Chapitre 1 : Bases du référencement Chapitre 2 : Liste de contrôle pour la recherche de mots clés Chapitre 3 : Liste de contrôle de référencement sur la page Chapitre 4 : Liste de contrôle pour la création de liens Chapitre 5 : Liste de contrôle technique pour le référencement Chapitre 6 : Suivi et plus En conclusion Aperçu de la liste de contrôle SEO La première chose que font la plupart des gens
Lire la suite

Les meilleurs GPTs pour vous aider dans votre travail de rédaction

-
Image
Les meilleurs GPTs pour vous aider dans votre travail de rédaction Les meilleurs GPTs pour vous aider dans votre travail de rédaction Pascale Duc 16 février 2024 à 12h00 1 Découvrez notre sélection des meilleurs GPTs pour votre travail de rédaction © Clubic Après plusieurs semaines d’attente, OpenAI a enfin lancé le GPT Store. Il s’agit d’une bibliothèque recensant des milliers de GPTs ( generative pre-trained transformers ), des surcouches sur le système  ChatGPT  qui ajoutent automatiquement des instructions spécifiques, des préprompts ou des bases de connaissances particulières à l’IA. N’importe qui peut concevoir un GPT, il ne faut avoir aucune connaissance spéciale en informatique. À terme, OpenAI prévoit de monétiser le GPT Store. Les GPTs peuvent concerner tous les domaines : lifestyle, maths, développement… Et ils vont parfois plus loin que la simple génération de textes, en s’alliant avec l’intelligence artificielle DALL·E 3 pour produire des images. Il suffit de se rendre dan
Lire la suite