Author Archives: zg119077

I am currently interning at accounts payable department for a restaurant.  Most time  I use Microsoft Dynamics GP for accounting purpose.  Excel is very helpful to maintain and update vendor list and monthly account payable reconciliation.  In general, the most frequent feature I used for my work is filter and sort.  when I encounter large amount of transactions, filter feature helps me find the target easily.

Few days ago, my supervisor asked me if I know how to do conditional Vlookup.  I knew Vlookup and If function.  so I told her to combine two functions.  However, That is not she want.  She probably should try Offset function.  Whatever, Excel is very useful in business.

Hope everyone have a great semester! 😀

Zhong Ge

https://blogs.baruch.cuny.edu/members/zg119077/

Zhong Ge