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 75 Excel Macros

Episode Guide

  • Automate common tasks in Excel
  • Record regular tasks if fields remain the same
  • Record and edit VBA code to scan for similar fields
  • Create loops to “scan” through worksheet for preset information
  • Copy only data desired into new sheet(s)
  • Set page formatting

Direct Download

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

Support Geek I/O on Patreon!

HeadphonesNeil Amazon Author Profile

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!