Saturday Spreadsheet Applications

At my work I use excel to help me keep track of the recivables. I import data to the system and from the system to a spread sheet.  The easy organization of the program as well as it very useful tool allow me to have a better picture of what money is coming in and what is still outstanding. At my other job, excel was the tool I used in order to do the bookkeeping of the restaurant.  In general, I use excel for its organization, graphs and  calculation functions.

I am currently an accounting intern, basically resposible for billing.  Actually, I seldom use Excel at work.  I only use it when I do the check schedule and reconciliation.  I think Excel is useful for jobs working with number, but many companies want to monitor and have authority control on things change , so they now spend more money on some accounting and financing software.

Yuanyan Zheng

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

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

Actually i am currently unemployed, but at my last job as an assistant manager for a check cashing establishment i got tired of doing the daily closeouts manually.  I then thought of excel, because at that time i was taking the simnet test and came up with the idea to redesign the store sheets in excel.  I created the forms using all the formulas needed and it made everyone’s life easier,  it was fast and accurate.

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

I am currently doing an accounting internship at a custom furniture design company at the New York Design Center. My work mostly revolves around accounts payable, but I am exposed to other areas of accounting involved in the company.

I use excel at work to keep record of the company’s cash balance. I keep a record of the checks that were sent (date and check #), payments the company receives (date and sales order #). I then input the values on a sheet that keeps record of the current month’s balance.