Radenkovich’s P(a)lace

Microsoft Office Environment

• Financial Statement - this project show how Excel and Word documents could be linked and used besto from both packages. Example is financial statement on both English (amounts in $) and Serbian (amounts in RSD) version. Trial Balance has been pulled from company ERP in more or less standard format, classification matrix has been used to classify figures from trial balance into proper positions on Balance Sheet, Income Statements and over 20 breakdown tables. Tables in Word document are linked to Excel sheet so after any changes in Excel calculations all you have to do is to refresh linked tables in Word with simple click. Excel files itself include use of VLOOKUP, IF, ISERROR functions.
• IT Rules! - this MS Access Database Project could be done as standard Access Database, but I have choose a real SQL server for background (MSSQL or MSDE as you like). Front end ADP work really fast. Even on remote location on WAN. Projected database model does not make possible to loose inventory items.
• Sales Investment