Excel: Offset function to get to the next find result

https://support.office.com/en-us/article/OFFSET-function-c8de19ae-dd79-4b9b-a14e-b4d906d11b66

Excel: to get relative position of a item we're looking for

Match function
https://support.office.com/en-us/article/MATCH-function-e8dffd45-c762-47d6-bf89-533f4a37673a

Excel: how to sort a set of data on another worksheet by reference

• Copy a range from Sheet1 to Sheet2, but do Paste Special and choose link
• Enable developer mode, and create a Macro with the code from this page:
• http://www.mrexcel.com/forum/excel-questions/583935-how-change-relative-values-absolute-mac.html
• Select all the cells you pasted a reference to and run the macro once
• Then select the cells on Sheet2 and sort them - wha la!

SUMIFS formula for Excel to sum based on condition across a set of cells

https://www.ablebits.com/office-addins-blog/2014/11/12/excel-sumifs-sumif-multiple-criteria/

Why D65 is the right white point to use for calibration

But you can't compare images on screen and on paper side by side:
http://www.color-image.com/2012/02/monitor-calibration-d65-white-point-soft-proofing/

Didn't know there was this org

https://www.washingtonpost.com/local/education/these-christian-teachers-want-to-bring-jesus-into-public-schools--legally/2016/03/12/bfd95986-dfd3-11e5-8d98-4b3d9215ade1_story.html

Sorting columns (by values in a row) in Excel

http://www.contextures.com/xlSort01.html

Best keynote timers I found online

http://www.ipresentee.com/keynote-countdown-timers/

Great tension photos

http://www.aarontilley.com/

For getting true gain/losses after selling Adobe ESPP or RSUs

This information can be found in the eTrade in the Understanding Your Cost Basis Information for Lots Sold After section. That section can be found by going to:

•  Employee Stock Plan Gains & Losses  (Account - > My Stock Plan -> My Account tab -> Gains & Losses) and filter for the last tax year. Expand the Sale details for the ESPP stock
• The section: Understanding Your Cost Basis Information for Lots Sold After …. has the cost Acquisition Cost and Ordinary Income Recognized

RSU Stocks:

For the RSUs  just need to add the actual cost of the stocks at the day that was vested. It also can be found as Ordinary Income Recognized in Understanding Your Cost Basis Information for Lots Sold After section.