Free how-to guides

• Excel & PDF

  How to convert a PDF table to Excel without retyping (and fix the errors)

  Four ways to get a PDF table into Excel (Mac and scans too), plus tested formulas to fix numbers stored as text, trailing minus signs and broken dates.

• Excel

  How to remove duplicates in Excel but keep the right row

  Excel keeps the first duplicate it finds. Learn to keep the latest date or highest value instead, flag duplicates with tested formulas, and fix common misses.

• Excel

  How to clean messy data in Excel: 9 fixes

  A tested checklist for cleaning messy Excel data: TRIM not working, numbers stored as text, dates not recognized, inconsistent spelling, blanks and duplicates.

• WordPress

  Fix WordPress “Missed schedule”: replace WP-Cron with a real cron job in cPanel

  Scheduled posts stuck on Missed Schedule? Replace WP-Cron with a real cPanel cron job (GoDaddy included), with tested commands, a test and a one-line undo.

• Marketing

  Lead magnet checklist: what to include, how long it should be, and a template outline

  What makes a good lead magnet, how long it should be, content, design and CAN-SPAM checklists, plus a copy-ready page-by-page outline.

• Presentations

  Pitch deck slide order for a small business: 10 slides

  The 10-slide pitch deck order for small businesses, a bank-loan version based on what lenders check, how many slides to use, and mistakes to avoid.

Also try our free in-browser tools: the CSV cleaner and the project price estimator.