Hi, I'm Rowel
I am a graduate of Business Administration with 12 years of experience in BPO industries.
I love spreadsheet and I am enthusiastic in creating excel automation and data visualization.
I can create website using wordpress and elementor with SEO content writing. I can do basic graphic and video editing.
Report Analytics Projects
Time and Motion Tracker
- Start/EndButton – once click, the start or end time will show in real time, no idle time
- End Shift Button = once click, end shift line will show at the bottom, disable the start time
- Customizable header on column D to J
- Processor name is automated populating the username based on Excel Application
- Date is also auto show and enabled AHT for handling time
HR dashboard in Excel
- If you add/remove a data on database, the dashboard will auto update
- Dashboard was created through powerpivot and data modelling
- Calculation was made using DAX
Interactive Data Entry Form with database
- Data entry form when user input data it will auto-populate on database
- It helps the user to monitor available stocks by adding or subtracting quantity
- Date is real-time and automated when user input data
- VBA/Macro Enabled
HR Dashboard in PowerBI Desktop
- Dashboard was made by data model star schema
- It shows data about gender, training and performances, employment status
- Date table was created as a holder for all the dates filtered
- All data was interpreted using DAX calculations
Time and Motion Tracker
- Start/EndButton – once click, the start or end time will show in real time, no idle time
- End Shift Button = once click, end shift line will show at the bottom, disable the start time
- Customizable header on column D to J
- Processor name is automated populating the username based on Excel Application
- Date is also auto show and enabled AHT for handling time
HR dashboard in Excel
- If you add/remove a data on database, the dashboard will auto update
- Dashboard was created through powerpivot and data modelling
- Calculation was made using DAX
Interactive Data Entry Form with database
- Data entry form when user input data it will auto-populate on databas
- It helps the user to monitor available stocks by adding or subtracting quantity
- Date is real-time and automated when user input data
- VBA/Macro Enabled
HR Dashboard in PowerBI Desktop
- Dashboard was made by data model star schema
- It shows data about gender, training and performances, employment status
- Date table was created as a holder for all the dates filtered
- All data was interpreted using DAX calculations
Graphics (Canva)
Video Editing (Capcut)
SEO Content Writing
Automation
Master Excel Automation: Boost Productivity with Powerful Tips & Tricks
Excel is one of the most powerful tools for managing data, performing calculations, and creating visual representations of complex information. However, its true potential is unlocked when you automate repetitive tasks.
Rowel Cruz
March 25, 2025
No Comments
Excel
How to Use Excel Like a Pro: Essential Functions and Shortcuts
Microsoft Excel is one of the most powerful tools for managing data, whether you’re working in a business, personal finances, or academic research.
Rowel Cruz
March 25, 2025
No Comments
Automation
Excel Automation for Beginners: Step-by-Step Guide to Save Time and Effort
Excel is one of the most powerful tools available for managing and analyzing data.
Rowel Cruz
March 24, 2025
No Comments
Tools
Web Design
Social Media
SEO
Report Analytics
