This Working Droid Episode 108 Basic Bills Management

Episode Guide

  • N30 = Net 30 Days - Invoices due 30 days after the invoice date
  • Start a spreadsheet in your favorite software (i.e. Excel, iWorks, Sheets)
  • Enter terms as figure (i.e. 30, 45, 60,etc.)
  • Set formula to add the number of days from the invoice date
  • Adjust due dates base on odd days or weird billing cycles

Direct Download

E-Mail Me

Online Contact Form

Support Geek I/O on Patreon!

HeadphonesNeil Amazon Author Profile

This Working Droid Episode 68 Google Drive Templates

Episode Guide

  • Default forms for regular transactions
  • Copy and paste from original form to keep formatting
  • Edit templates to customize cells
  • E-Mail directly from Google Drive
  • Save as PDF
  • http://drive.google.com/templates

Direct Download

E-Mail - headphonesneil@yahoo.com

Geek I/O Website

[Sponsor - Puget] Visit http://geek-io.com/puget to start building your custom computer today!

This Working Droid Episode 52 Spreadsheet Formatting

Episode Guide

  • Autosize (or manually resize) columns to avoid seeing ‘####’ to ensure all numbers are visible
  • Set numbers to show $, decimals, etc. to differentiate between types
  • Wrap text to fit labels properly
  • Merge cells to help create overarching labels
  • Use standard dates formatting
  • Create labels in columns to use Autofilter
  • Landscape vs Portrait page layout

Direct Download

E-Mail me or fill out our online contact form!

Support Geek I/O on Patreon!

HeadphonesNeil Amazon Author Profile

Sponsor - ProXPN

  • Safely and securely browse the internet
  • Keep your personal data protected
  • Access location sensitive content like NetFlix and YouTube
  • Visit http://proxpn.com and use promo code 'GEEK20' for 20% off your order!