I’ve recently given notice at my job (to move to the Bay Area), and the process of wrapping up in New York has given me the chance to reflect on a lot of skills I’ve learned in the past few years. One thing that’s been really amazing is learning how to code, which has changed… Continue reading Learning to Code in 2014
Category: Writing
Excel F-1 Work Authorization Calculator
I made this a long time ago, but it completely slipped my mind to post it until recently. This workbook is an Excel version I made for my office at NYU of the online work authorization calculator that I posted earlier.
The idea is the same: enter a student’s previous work authorization to see how much optional practical training (OPT) is remaining. If you enter the student’s completion date, it will tell you when the student can apply for (and use) post-completion OPT. To use it, you’ll need to download the workbook and enable content and macros.
As always, feedback is welcome.
Sharing limited data without sharing the whole spreadsheet
Recently a friend asked me how he could share some data that he was working on with colleagues. The problem is that he can’t share the entire spreadsheet. My suggestion is to use Google Sheets and the ImportRange function to share limited ranges with another spreadsheet. What’s great about this method is that you can… Continue reading Sharing limited data without sharing the whole spreadsheet