MS EXCEL PIVOT TABLE

I made a summary using pivot for my boss to see the subcontractors' active sites per area with their corresponding milestones.



MS EXCEL AND GOOGLE SHEET

I was tasked to update the manpower of our project team and reflect it in our online database through MS Excel and Google Sheets.

MS EXCEL VLOOKUP

I need to report why the sites were put on hold daily and to do that, I used the vlookup function to align the data with our regional tracker.

MS EXCEL AGEING DELAY FUNCTION

Another thing I need to do in our issue register tracker is to keep an eye on the number of days the issue started and the day the issue was resolved. I used the ageing delay function to keep things simple.

MS POWERPOINT

As a project coordinator, one of my tasks is to update the manpower steadily. Accordingly, I should also update our organizational chart. I used MS Powerpoint since we also use this during meetings with the client.

FINANCIAL MANAGEMENT

Since I was not satisfied with the given template for the budget tracker, I created the sample above so that I can see all the needed info in one go.

EMAIL REQUESTS