Anaol Megersa
Google Sheets expert building automated data workflows.
New to Contra
Anaol is ready for their next project!
Automated Project Tracker Redesign (Before & After)
Rebuilt a cluttered, manual tracking spreadsheet into a high-performance, automated business dashboard.
Key Enhancements Implemented:
*Formula Optimization: Replaced broken hardcoded text values with dynamic =DUE_DATE-TODAY() logic to automatically display real-time overdue statuses.
*Data Synchronization: Automated row behaviors so clicking the "Done" checkbox instantly changes the workflow status to "Completed".
*UI/UX Visual Overhaul: Removed default system gridlines, applied a professional dark header theme, and center-aligned columns to minimize user visual fatigue.
1
13
Stop sending messy spreadsheets to your clients. 🛑
A disorganized tracker creates confusion and slows down approvals. I help businesses transform chaotic data into clean, professional, and automated dashboards that make tracking project budgets effortless.
Swiped right to see the before-and-after transformation of a client's project tracker. 📊
Ready to clean up your workflows? Book my spreadsheet design service directly on my profile! ✨
1
23
Turning messy text into interactive dashboards! 📊
For my latest project, I rebuilt a chaotic task list into a streamlined project management dashboard.
I added automated formulas to track completion rates instantly, standard dropdown menus to keep team communication consistent, and interactive checkboxes. Now, instead of guessing "days left," the system automatically calculates precise timelines and highlights overdue tasks.
:
1
38
Formula Fix: Cleaning up spreadsheet errors! 🛠️
Here is a quick look at how I optimize lookup systems in Google Sheets. Instead of leaving ugly #N/A error codes when an ID isn't found, I wrapped the lookup formulas in IFERROR statements to output clean, readable status alerts ("ID Not Found").
Small details like proper error handling and clean currency formatting turn confusing sheets into user-friendly tools! Let me know if your business tracking sheets need a cleanup.
1
45
Data Cleaning & Spreadsheet Formatting
Transformed a messy, unformatted dataset into a clean, professional, and client-ready spreadsheet. Fixed inconsistent naming conventions, standardized text capitalization, corrected alignment issues, and applied consistent currency formatting to improve overall data readability.
1
50