Interactive Excel Dashboards

Excel based tool for income, expenditures, assets etc. structure analysis. The dashboard (see the screenshot) allows to select any age range (or multiple age ranges), then VBA code automatically highlight selected ranges in the age ranges table and corresponding bars of the histogram as well as refreshes all tables and pie charts below to show income, expenditures, assets struc...
Read More

Excel VBA Tool for a Large Corporation

Complex Excel VBA project. Months of full time work. More than 10 thousands of VBA code rows. Complex Excel ribbon tabs and VBA forms created, progress bars used Multiple VBA procedures created: to open template files, to migrate data from older versions, to import and clean data from excel files, to perform complex calculations, to refresh pivot tables, to build matrix d...
Read More