Excel Tips and Tricks

Our team of equity experts have put together a few quick Excel demos to help stock plan professionals with their daily "chores".  These Excel tips and tricks will keep you in the know and on the go.

Do you have an idea for an Excel demo?

Fill out this form and we will add it to the list.

End of Quarter Date Function

Goal Seek Function for Modification Accounting


AND Function Instructions

SUMIFs with &

'Smarter' LOOKUP: Index Match with VLOOKUP

Index Match