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

Comment faire du business sur Amazon ? [GUIDE COMPLET 2022]

-
Image
Comment faire du business sur Amazon ? [GUIDE COMPLET 2020] Comment faire du business sur Amazon ? [GUIDE COMPLET 2020] Hey, salut ! Heureux que vous lisiez ce guide détaillé sur la façon de vendre sur Amazon. Avant que vous ne creusiez, je voulais vous présenter cette ressource, faite par  DocShipper Sourcing . Cet impressionnant guide de 9 chapitres a été conçu avec soin pour vous donner toutes les informations dont vous avez besoin pour bâtir une entreprise rentable et évolutive sur Amazon, depuis la recherche de votre premier produit jusqu'à son lancement, sa vente et la poursuite de son développement. Ce qu'il y a de mieux dans ce guide, c'est que vous pouvez toujours vous y référer, sous forme de liste de contrôle, chaque fois que vous lancez un produit... jusqu'à ce que les étapes deviennent naturelles et que vous deveniez un expert ! Alors pourquoi devriez-vous faire confiance à ce guide ? C'est une excellente question ! Voici mon histoire : En 25 mois, j
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

Nomad '✨Maker - TOP✨ Ai GENERATOR

-
Nomad '✨Maker - TOP✨ Ai GENERATOR TOP  generator https://beta.openai.com/playground https://chat.openai.com/chat https://platform.openai.com/api-keys 🚀 TOP impressionnantes invites ChatGPT *°: https://github.com/f/awesome-chatgpt-prompts https://prompts.chat/ https://gptstore.ai/gpts https://allgpts.co/ https://www.toolify.ai/fr/gpts https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fchat.openai.com%2Fg%2F https://deuxmillevingtetun.blogspot.com/2024/03/comment-creer-des-gpts-via-chatgpt-pour.html https://deuxmillevingtetun.blogspot.com/2024/03/chatgpt-notre-guide-pour-creer-les.html My Chat GPT  BOT's perso *°: https://chatgpt.com/g/g-6PeWeMS1L-superassistant-de-description-du-produit SuperAssistant de description du produit Créer une création qui aide à générer des descriptions de produits ALiEXPRESS pour un magasin de DROPSHiPPiNG Créer une création qui aide à générer des descriptions de produits ALiEXPRESS  super BOOSTER SEO pour Google et pour un magasin de DROPSHiPPiNG
Lire la suite

T🌴'artistiK -📗 Books and Publications Spotlight | Lulu

-
Image
T-artistiK - Books and Publications Spotlight | Lulu https://www.lulu.com/spotlight/tartistik/ À propos de T-artistiK Tous les outils pros et les contenus pour les acteurs,comédiens,animateurs,villages-vacances,hôtels-club,troupes/atelier, asso ou cours/formation… .  Passionés d'animation & de Spectacle PROs ou AMATEURs et VOUS…;aussi pour passer de très bonnes soirées entre amis ….  …AMBIANCE & RIRES 100% GARANTIS….  !  A lire sans modération, à toutes heures et à toutes occasions n'importe quand dans la journée pour retrouver le Sourire et la BONNE HUMEUR !  !  Idéal pour être en pleine santé & pleine forme… Que du BIEN ETRE…!  Retrouvez-nous également sur : https://sites.google.com/view/ql--lp/Accueil/web-creations/lulu-comspotlightquizziland?authuser=0 - RÉFÉRENCE dans les domaines de l'Animation & du Spectacle pro & amateur .  .................................................. .................................................. Publications de T-arti
Lire la suite

Diagnostiquer et récupérer une messagerie piratée | AVG

-
Image
Diagnostiquer et récupérer une messagerie piratée | AVG Comment savoir si votre e-mail a été piraté et comment le récupérer Quand votre messagerie se fait pirater, c’est comme si toute votre vie numérique était entre les mains de quelqu’un d’autre. Apprenez ici à déterminer si votre boîte Gmail a été piratée, identifiez les autres comptes de messagerie piratés et voyez ce que vous pouvez faire après une violation de messagerie. Découvrez ensuite comment une application de sécurité robuste peut veiller sur la sécurité de votre messagerie. Télécharger AVG Antivirus GRATUIT Disponible aussi sur  Android ,  iOS ,  Mac 2021 Produit de l’année 2021 Produit de l’année Editor's Rating Excellent Comment savoir si quelqu’un a piraté mon compte de messagerie ? Les signaux d’alerte d’une messagerie piratée indiquent tous que vous avez perdu le contrôle de votre messagerie. Par exemple, si vous n’avez plus accès à votre boîte de réception Gmail, c’est un signe fort que votre compte Google a été
Lire la suite

115 idées de revenus passifs pour obtenir de l'argent pour travailler pour vous en 2021 - Blog Ippei

-
Image
115 idées de revenus passifs pour obtenir de l'argent pour travailler pour vous en 2021 - Blog Ippei 115 idées de revenus passifs pour obtenir de l'argent pour travailler pour vous en 2021 9 juillet 2020 7   commentaires Meilleurs messages Comment démarrer une entreprise de génération de leads pour des bénéfices insensés (5 étapes) Lire la suite Faux gourous contre vrais (repérage des escroqueries par des coachs de réussite en ligne légitimes) Lire la suite 10 secrets pour démarrer une agence de marketing numérique en 2021 Lire la suite Meilleurs cours de rencontres en ligne, livres, communautés pour hommes en 2021 Lire la suite Andrei Jikh - Les 10 meilleures leçons que j'ai apprises (qui changent la vie) Lire la suite Examen Graham Stephan : Top 10 des leçons et examen hebdomadaire du mentorat (est-ce légitime ?) Lire la suite Ippei Kanehara I became a full-time internet Entrepreneur in 2014 through  lead generation . (Still My #1 Recommendation) A form of digital marketi
Lire la suite

6 tunnels de vente indispensables pour vendre sur Internet

-
Image
6 tunnels de vente indispensables pour vendre sur Internet 6 tunnels de vente pour vendre efficacement sur internet Quels  tunnels de vente  choisir pour vendre sur Internet ? Quel est le tunnel de vente le plus adapté à mon business modèle ? Téléchargement d’ebook, prise de rdv, webinar, e-commerce, lancement… nous passons au crible chaque  funnel de vente  pour vous afin de faire le meilleur choix ! Le  tunnel de vente  est le parcours que le prospect va suivre pour se transformer en client . Au début du funnel se trouvent les actions marketing d’engagement. Et le tunnel débouche sur une conversion : c’est ce que l’on appelle l’entonnoir de conversion. Autrement dit, l’objectif du tunnel de vente est de vendre quelque chose : un produit, un service, un ebook, une vidéo, un cours, un webinar… Découvrez  comment mettre en place le(s) bon(s) tunnel(s) de vente sur votre site web pour vendre sur internet . Définition du tunnel de vente Comment créer un tunnel de vente ? 6 exemples de tun
Lire la suite

ai-collection/README.fr.md at main · ai-collection/ai-collection · GitHub

-
ai-collection/README.fr.md at main · ai-collection/ai-collection · GitHub Index 🤪   Amusant 🎲   Animation & Modélisation 3D 🏯   Architecture & Design D'Intérieur 💻   Assistant De Code Et De Base De Données 📧   Assistant De Messagerie 🎓   Assistant De Recherche ✍️   Assistante D'Écriture 😎   Avatars 🗳   Avis Et Recommandations 🧰   Boîte À Outils Des Créateurs 🤖 💬   Chatbot 🛒   Commerce Électronique 📈   Comptabilité Et Finance 🕸   Création De Sites Web 📊   Diapositives Et Présentations 📢   Discours 🌄   Générateur D'Art Et D'Images ⚜️   Générateur De Logos 📠   Génération De Contenu Et Référencement 🎁 💡   Idées De Cadeau 🎮   Jeux 👩‍⚖️   Juridique 💡   La Génération D'Idées 👩‍🎤   Mode 🔍   Moteurs De Recherche 🎼   Musique Et Génération Audio 🧞‍♂️   Organisation & Automatisation 🏖   Planificateur De Vacances Et De Voyages 🔌   Plugins Et Extensions 🚀   Productivité Et Croissance Personnelle 👩‍💼   Ressources Humaines Et Cv 📸   Ret
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

Stratégie dropshipping : Les 10 leviers marketing pour votre boutique

-
Image
Stratégie dropshipping : Les 10 leviers marketing pour votre boutique 10 leviers marketing efficaces pour la stratégie dropshipping de votre boutique en ligne   4/5   Partager Lors de la  création d'un site dropshipping , une stratégie marketing efficace va vous permettre d'acquérir plus de trafic et de générer davantage de ventes ! Mais quels sont les leviers d’acquisition indispensables pour promouvoir votre boutique qui vous permettront de devenir populaire sur Internet ? Découvrez les différents leviers du digital pour élaborer une bonne stratégie webmarketing et générer de nombreuses ventes sur internet en dropshipping. Le référencement naturel Indissociable à tout marketing digital,  le SEO ou le référencement naturel est un des leviers indispensables pour développer une stratégie de dropshipping efficace . Il permet d’améliorer votre positionnement dans les résultats de recherche Google en attirant du trafic qualifié, naturellement et spontanément. En créant des contenus
Lire la suite