Urgent Excel Directory Mission List

Job ID: 40005640

Budget: $10 – $30 USD

I have a raw doc list of pastors and churches that needs to be turned into a polished, corporate-looking directory within the next 10 hours. Here is exactly what I need:

• One main sheet called “ALL” that contains every record, laid out in this column order: Pastor First Last Name | Church Name | Email | Contact Tel | WhatsApp (Y/N) | Address | Country | Notes. Please activate AutoFilter on the header row so I can sort or filter by any field at will.

• A prominent title and our mission statement centred at the very top of the sheet, styled with standard, conservative corporate colours and fonts (Calibri/Arial, dark grey or navy accents are fine).

• Freeze the header row, apply clear zebra-striping or similar light conditional formatting for readability, and keep the overall visual tone professional and corporate—no bright or playful palettes.

• Tabs labelled Liberia, Sierra Leone, South Africa and Ghana must be present, but instead of separate datasets they can simply display filtered views (or connected pivot tables) pulling from the “ALL” sheet, so the single source of truth remains intact.

• Protect all formulas or connections, leave data cells editable, and ensure the file opens cleanly in both the latest Microsoft 365 and Excel 2016.

Confidentiality is critical; please do not add this file to any public portfolio or share the data. If you can deliver the finished workbook, fully formatted and tested, within 10 hours of acceptance, let’s get started right away.
Related categories: Data Processing Data Entry Excel Excel VBA Excel Macros