I will fix microsoft excel formula issues

Pakistan

I speak Urdu, English, French

11 orders completed

Contact with Confidence!

My name is Adnan Qureshi, and I am an IT graduate with over 10 years of experience in the Telecommunication industry as an IT Operation Manager. During my time in this position, I ensured proper ser...
About this Gig

Welcome to my Gig!

 

If you need help with Excel Spreadsheets, Formulas, Functions, Macros, and fixing errors, you've come to the right place!

 

I specialize in a wide range of tasks, including:

 

  • VLOOKUP/HLOOKUP: Retrieve data from different Excel worksheets or ranges.
  • INDEX-MATCH: Find and retrieve data using more advanced lookup methods.
  • IF/SUMIF/SUMIFS/IFERROR/SUMPRODUCT: Create customized calculations and summaries.
  • COUNTIF/COUNTIFS: Count occurrences based on specific conditions.
  • DROP DOWN & DATA VALIDATION: Create user-friendly drop-down menus and ensure data accuracy.
  • CONDITIONAL FORMATTING: Apply formatting based on specific conditions to make your data stand out.
  • REMOVING DUPLICATES: Clean up your data by removing duplicate entries.
  • Formula Automation/Linking: Automate tasks and link data across different worksheets or workbooks.
  • Fixing up #DIV/0, #N/A, #NAME?, #NULL!, #NUM!, #REF!, AND #VALUE! errors in Excel sheets.
  • Splitting text/data/formulas into different cells for better organization and analysis.
  • Resolving any other formula-related issues as per your requirements.

 

I also offer services to create new Excel spreadsheets with formulas or macros as per your needs.

Platform:

Excel

Google Sheets

Development technology:

VBA

Expertise:

Formatting

Fixing

Forms

Pivot tables

Formulas