Visual Basic for Apps Jobs

I have an Excel workbook packed with productivity figures that needs to tell its story clearly in an upcoming presentation. My audience is non-technical, so visuals must be intuitive: clean tables with strategic highlights rather than complex charts. Here’s what I need: • A set of formatted tables that surface the key productivity metrics—think conditional-formatted cells, sparklines, or color-coded variances—so trends and outliers pop at a glance. • An easy-to-follow layout: summary at the top, detailed breakdowns below, each section clearly labeled for quick navigation when I’m presenting. • Light automation where it helps (simple formulas, named ranges, perhaps a few slicers) so I can refresh the data without re-doing the design. Accept...

I have a sales performance sheet. I want an experienced person who is specialized in advanced Excel formulas and who can automate the sheet. The sheet is already automated. Some of the formulas are not working, and I want to add some more stuff into it, so I need someone who can actually do the stuff.

I have a working Excel VBA macro that end-users should be able to run, but I don’t want them to see or tinker with the underlying code. I’d like you to implement password protection on the VBA project so that: • The code window stays hidden unless the correct password is entered. • Users can still execute the macro without needing that password. • Both viewing and editing the code are blocked. Compatibility needs to span any common desktop build—Excel 2016, 2019, and Microsoft 365—so please use methods that work across those versions with no add-ins required on the client’s side. Deliverables I expect: 1. The secured workbook (or a stripped-down sample if you can’t touch my production file) with the password protection in place. 2. ...

Make a professional banking app in Microsoft access format. Currency preferably in (K) Zambian kwacha It should be able to collect customer, account, and transaction details e.g. bank statements, loan details.