I will fix excel formulas, xlookup, index match and errors

United Kingdom

I speak English
👋 Hi, I'm Elison Rodrigues! I'm an Excel specialist helping individuals and businesses solve spreadsheet problems quickly and efficiently. 💼 I can help with: * Excel formulas (XLOOKUP, INDEX/MATC...
About this Gig

Hi, welcome to The World of Excel & Infographic Dashboards.


Are you looking for an infographic dashboard that moves simultaneously as the data's modified or looking for formulas to be fixed instead of getting those annoying errors (i.e., #Div/0, #N.A., etc.)


Well, you are in the right place for all excel related queries.


Through my Gig, I can help you with any task as follows:

  • Data analysis via graph representation
  • VLOOKUP/HLOOKUP/XLOOKUP
  • IF/IFS/SUMIF/SUMIFS/IFERROR/SUMPRODUCT
  • COUNT/COUNTA/COUNTIF/COUNTIFS
  • DROP DOWN - DATA VALIDATION
  • CONDITIONAL FORMATTING
  • Identifying unique values + removal of duplicates
  • Linking formulae with multiple cells
  • Fixing errors (I.E., #DIV/0, #N/A, #REF)
  • Locking & freezing panes.


I will create an interactive/infographic dashboard that's linked to your data where you can select what type of data you need to see via a slicer.


Before placing your order


Please contact me before placing an order. Send me a brief description of your requirements (and your spreadsheet if possible) so I can assess the work, recommend the correct package, and ensure the best possible solution.

I look forward to helping you solve your Excel challenges!


Platform:

Excel

Google Sheets

Development technology:

VBA

Excel

VLOOKUP

Expertise:

Formatting

Fixing

Formulas

Charts

Data validation