How can organise daily work in office, while having multi task and create daily reports.
It is very massive job to do daily work in a same way, also makes bore to a professional, below are some solutions which can do your work interesting
Tips and Tricks:-
First Step – try to segregate daily reports and processes to create it
Create a copy of report with formulas, delete except Top 10 rows with formulas ( it means – Structure with Formulas), so next time you will have to refresh and drag your formula to create that report.
If no. of ad-hoc works and requirements are more, so try to use pivot table very frequently. Because it is easy to do data and number crunching with pivot table and DATA TOOLS.
Do not feel bad if you have to stay for long hours in office .if you are beginner in excel need to do some R & D to learn new formulas
and tricks, more than 100 websites are available for your help.
Do Googling frequently if you are not in hurry or remember it to solve later on. Because your current problems are your growth and experience.
Try to learn VBA, but first try to be good in excel, because Excel is having lots of inbuilt functionality. Which can solve very much tricky task without VBA. It will help you a lot when you will try to learn VBA.