How I use Excel in work

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

About zg119077

5081190214415846
This entry was posted in Uncategorized. Bookmark the permalink.

One Response to How I use Excel in work

  1. ld110711 says:

    I think I am almost doing the same thing as you did in your work. I am eager to learn Vlookup funchtion and If function in our class. Hopefully at the end of this semester, I can master both of them.

Comments are closed.