I will fix excel formulas, xlookup, index match and errors
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

