Esemwenghian Edith Osagie

PROJECT SAMPLES Google Suite/MS Office Drive,Sheets,Form Survey, PPT. and Zapier automation Google Drive Structured Google Drive I designed a structured Google Drive system that streamlines file management, enhances accessibility, and ensures data security for businesses and professionals. Key Featuresof the system: -Strategic Folder Structures – Categorized for easy navigation and workflow optimization -Access Control & Permissions – Ensuring the right people have the right access -Document & File Naming Best Practices – Enhancing searchability -Collaboration-Ready – Designed for teams and individuals to work efficiently. I displayed this system in a short Loom video. Structured folders Sub-folders Access & Permissions Forms Streamlined Google Form for Client Onboarding Automate Workflow with Zapier I designed a streamlined Google Form to help businesses efficiently collect essential client information during the onboarding process. This form reduces back-and-forth emails, organizes responses in real-time, and ensures smooth communication. Key Features of the Google Form: User-friendly layout: Divided into sections for clarity Required fields: Ensuring critical information is provided Multiple-choice options: Simplifying client preferences Automated data collection: Responses are stored in Google Sheets for easy tracking For integration of Google Form responses with other tools, this form was automated with Zapier such that new responses in sheets will trigger creation of trello cards. I can do same for a CRM tool A partial view of the form Sheets Customized Tracking System in Google Sheets: Sample: Project & Task Tracker I designed a streamlined Project & Task Tracker in Google Sheets, enabling businesses to track projects, assign priorities, monitor deadlines.This system simplifies workflow management and ensures on-time task completion. Key Features: -Track multiple projects and tasks -Assign priorities, due dates, and statuses -Auto-update task progress using dropdowns -Conditional formatting for easy visualization Formated a column so any task past the due date and not marked "Completed" will automatically turn red, making it easy to track overdue tasks. Automated task reminder system using Zapier, Google Sheets, and Gmail to track approching deadlines, ensuring smooth project management. Slides Google Slides Presentation I design engaging presentations that leave a lasting impression. This sample presentation demonstrates my ability to create visually appealing, structured, and professional slides. Google Contact Google Slides Presentation I design engaging presentations that leave a lasting impression. This sample presentation demonstrates my ability to create visually appealing, structured, and professional slides. Importing contacts Before meets After Label creation Before sorting After sorting