Automation & E-commerce
Articles about automation & e-commerce, practical decisions, tools and systems.
Google Sheets named range: hand over a checkable total
Name a fixed range in Google Sheets, use it in a SUM formula and compare the inputs with expected arithmetic. Keep a clear handover note and honest checks.
Read article
Google Sheets split text to columns: check four records
Use Google Sheets split text to columns with a known comma separator, compare four fictional records with their expected fields and reopen the saved result.
Read article
Google Docs selected-text word count: check one passage
Use Google Docs selected-text word count to measure one passage, distinguish words from characters, revise a fictional brief and repeat the same scope check.
Read article
Gmail attachment search by filename: identify one file
Gmail attachment search by filename helps locate a known file. Inspect its label on the individual message, record the decision, and reopen your local note.
Read article
Google Sheets two-column sort: verify complete records
Google Sheets two-column sort uses two ordered keys. Sort six practice records, check every ID and its fields, then reopen the sheet and the saved check card.
Read article
Google Forms paragraph character limit: set and check it
Set a Google Forms paragraph character limit and record a clear boundary check. Use fictional 20- and 21-character inputs with a saved, reusable test worksheet.
Read article
Copy an earlier Google Docs version without restoring
Copy an earlier Google Docs version into a separate file. Keep the working document current and use a worksheet to check both links and the text you observe.
Read article
Google Sheets filter views: save a personal work queue
Use Google Sheets filter views to save a focused work queue. Follow a five-row exercise, reopen the named view, and separate view links from file access rights.
Read article
Gmail filters: label supplier emails without hiding them
Build Gmail filters that label incoming supplier messages. Check matching and nonmatching examples, keep mail visible, and record what remains untested today.
Read article
Protect formula cells in Google Sheets: an edit test
Protect formula cells in Google Sheets while keeping inputs editable. Compare warnings with restricted editors and record an honest separate-account test.
Read article
Repeat Excel print headers: a worksheet checking guide
Repeat Excel print headers with a fixed title-row setting. Prepare a fictional list, inspect available preview pages, and save a workbook plus checking note.
Read article
Excel drop-down list: build an order-status entry check
Build an Excel drop-down list for ten fictional orders. Configure the source and Stop alert, then record entry checks separately from untested paste behaviour.
Read article