I will create excel formulas and lookups

Botswana

I speak English, Tswana

Excel Data Cleanup, Formulas and Reports

I help individuals and small businesses organize Excel spreadsheets and make them easier to use. My services include data cleanup, consistent formatting, basic formulas and lookups, data validation, a...
About this Gig

Need help calculating totals, counting records or finding matching information in Excel?

I will create up to 3 basic formulas in one Excel workbook using your existing, organized data.

Examples include:

Multiplication for quantities and prices

SUM, SUMIF and COUNTIF for totals and counts

IF and simple logical conditions

AVERAGE, MIN and MAX

VLOOKUP to retrieve matching information

One formula means one distinct calculation or lookup. Copying the same formula down a column counts as one, not a separate formula for every cell.

You will receive an editable Excel workbook with the formulas intact and a short explanation of how to use them. Delivery is within 2 days, with 1 revision covering the original agreed requirements.

This package excludes macros, VBA, complex nested formulas, dashboards, external data connections and workbook-wide troubleshooting.

Please message me before ordering with your requirements, Excel version and a sample with sensitive information removed. I will review the task and confirm whether it fits this package.

Platform:

Excel

Development technology:

Excel

•

VLOOKUP

Expertise:

Formulas

•

Functions