Hi,
I do not know if this topic is suitable for the forum or not but I do hope if there is any insights or recommendations for what shall I do.
I am working as a budget accountant and using Excel for daily tasks at work.
I add balances for different departments in the 01-01-2017 and record expenses for each department till 31-12-2017.
I deduct each expense from each department's balance and make sure it has enough balance (money) otherwise I refuse to approve the expense.
I am using 2 Excel workbooks (1st titled DataEntry.xlsx) and (2nd titled Reports.xlsx).
I add the balances for each department in the DataEntry.xlsx workbook.
I added each expense for each department in the DataEntry.xlsx workbook.
I check the balance for each department from the DataEntry.xlsx workbook where I created pivot table and using calculation fields to know the remaining balance to check before I approve.
The data source in the Reports.xlsx workbook is a connection I created using the DataEntry.xlsx
Now I have a lot of departments and braches and different topics so I was thinking about creating or developing a software or application to help me.
I do not know coding at all but I want to learn and do this software to make my work easier because no one will assign this task to a developer at work and I do not have enough money to hire a freelancer and because I am not having a deadline I've thought or decided to do it myself as I know what I need exactly and this is a good thing I guess and I am interested to learn programing to do my task.
So where to get started? and will I need Access? or just Excel?
Also will I need to learn VB or C#?
Once again I am sorry if this off topic but I'm just used to get a lot of help for my work from this forum and this why I thought to ask about it here.