I always look for the blog. 🙂 On Guitar Tricks, it is pretty much buried down in the footer. What this shows me is that their entire site is pretty much designed to become part of the membership. Their blog goes under the “News” section of the membership. It is open to the public. I can see the point of this, though, because essentially the entire site is gated. Unless a person finds them on search, by the time a person finds the blog, they’re an email subscriber and have the free membership.
In the spirit of Spring Cleaning and the tax season deadline, I figured I’d give out an audit that people might actually appreciate. We perform audits for prospective and existing customer eCommerce sites to evaluate where they might be losing sales. We have developed our Website Audit Template specifically for eCommerce websites, and it has been extremely helpful so we wanted to share it with you. To get access to your own copy of the eCommerce site audit template (spreadsheet form), just click the text link or fill in your email at the bottom of the page to subscribe to our blog and get instant access!
Special Unicode Characters in Data Validation Lists: ☐, ☑, ✓, ✔ - This may be my favorite approach. You can include special characters like this in a Data Validation drop-down list. This isn't quite as good as clicking once to fill in a checkbox, but it is great for the mobile Excel apps. The only hard part is remembering how to insert a check mark symbol in Excel. For more information, see my article Using Unicode Character Symbols in Excel.
Google Sheets beat Microsoft to the punch and introduced a Checkbox as one of the Data Validation options. You can go to Insert > Checkbox to quickly create one, and you can customize it by going to Data > Data Validation. I've updated most of the Google Sheets versions of my checklists to use that feature. I hope Excel gets smart and introduces a similar feature some day.
Recent Examples on the Web Fortunately, most of the following checklist items are reasonably easy to implement, without requiring much heavy lifting. — Russ Wiles, azcentral, "Follow these steps to keep your personal finances in check during the coronavirus pandemic," 29 Mar. 2020 In Seattle, officials are distributing hygiene kits and provide tips and checklists on prevention to shelter operators. — Popular Science, "COVID-19 could hit homeless communities hard," 18 Mar. 2020 In Seattle, officials are distributing hygiene kits and provide tips and checklists on prevention to shelter operators. — Michael Cousineau, The Conversation, "Coronavirus could hit homeless hard, and that could hit everyone hard," 13 Mar. 2020 True, the building was missing a few amenities: doorman, garage, gym (all must-haves on Henderson’s original checklist). — Jennifer Fernandez, House Beautiful, "Shawn Henderson Turned This Turn-of-the-Century NYC Apartment Into a Hidden Gem," 10 Mar. 2020 Most significantly, the copilot had had difficulty locating checklists and performing in emergency scenarios. — Fortune, "After first 737 Max crash, why did Boeing’s pilot warning fail to stop second plane from going down?," 9 Mar. 2020 The second document provided a checklist that included developing contingency plans, establishing key relationships across communities, providing supplies to prevent spread at events and planning for staff absences. — Alison Dirr, Milwaukee Journal Sentinel, "Wisconsin Elections Commission issues guidance on coronavirus ahead of April election," 6 Mar. 2020 Since tackling your entire house and yard at once can be overwhelming, take things one step at a time by following this checklist. — Amanda Garrity, Good Housekeeping, "Follow This Spring Yard Clean Up Checklist to Make Your Patio and Lawn Summer-Ready," 29 Jan. 2020 Elevator buttons have been added to the checklist, too. — Sarah Mervosh, New York Times, "These 4 People Are Facing the Coronavirus Head-on," 12 Mar. 2020