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
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.