I will create and fix excel formulas, functions and errors

Anu

India

I speak Hindi, English

Data Analyst Turning Raw Data Into Actionable Insights

Hi, I’m Anu Jangid, a Data Analyst with hands-on experience in data cleaning, analysis, and reporting. I use Excel, SQL, Python, and Power BI to transform raw data into meaningful insights and clear d...
Read More
About this Gig

Is your Excel formula showing #N/A, #REF! or #VALUE!? Or do you need a new formula but do not know where to start? I will fix it or write it for you.


What I do:

- Fix broken formulas and find the real cause of errors

- Write VLOOKUP and INDEX MATCH lookups

- SUMIFS, COUNTIFS and IF formulas

- Clean text with TRIM, LEFT, RIGHT and TEXT

- Date formulas such as DATEDIF and WEEKDAY

- Nested formulas for multi-step calculations

- Work in Excel and Google Sheets


What you get:

- A working file with the formulas applied

- A short note on what was wrong and what I changed

- Your original file stays untouched


How I work:

1. Send your file and tell me what result you expect.

2. I confirm the right package and delivery time.

3. I deliver the fixed file with a short explanation.


Not sure which package? Message me with your file details and I will guide you.


Read More
create and fix excel formulas, functions and errors
Full Screen
create and fix excel formulas, functions and errors
Full Screen
Full Screen
create and fix excel formulas, functions and errorscreate and fix excel formulas, functions and errorscreate and fix excel formulas, functions and errors

Platform:

Google Sheets

•

Power BI

•

Microsoft Office

Development technology:

Power Query

•

Excel

•

VLOOKUP

Expertise:

Fixing

•

Pivot tables

•

Formulas

•

Functions

•

Cleaning

My Portfolio

Related tags