Saturday Spreadsheet Applications

Excel is my main tool at work , since I manage the accounting department in a Real state company,I need to keep track of my  Account Receivables , Accounts Payable , The Monthly Budget , Depreciation of tangibles and intangible Assets, Calculate interest for Mortgages, Calculate commissions for agents  and so forth. I really found excel as a major help in my position.  Despite the basic knowledge I have about excel I am so eager to learn a lot more and bring new ideas for my team at work  .

Excel provides lots of financial functions and statistical functions which would be very useful to me since my major is actuarial science . Also there are all the regular functions for doing calculations available, which would also be a large part of their work. Basically, anyone that has a need to do regular calculations can make use of a spreadsheet to do them

-Roger Hsu

I have been using excel for some time now and I have always used simple charts and graphs to visually analyze financial data.  Recently I learned about dashboards and how powerful they can be.  I would like to learn more about creating dashboards that are dynamic and flexible.  Knowing how to create a well designed dashboard can help anyone get up to the next level at their job.  I hope we cover this topic in class as it is a skill that is necessary in today’s competitive business environment.

– Pedro Orta