I will create advanced excel dashboards and reports with formulas


About this gig
Need to make sense of your data in Excel without spending hours?
I build Excel dashboards and reports that do the heavy lifting for you: no more manual updates, no more confusing spreadsheets.
WHAT I DELIVER:
Interactive dashboards with slicers & timelines
Pivot tables & pivot charts for multi-dimensional analysis
Advanced formulas (INDEX-MATCH, XLOOKUP, SUMIFS, array formulas)
Conditional formatting for visual highlights
Data validation & dropdown menus
Automated calculations that update when data changes
EXAMPLES:
Graduate data dashboard by district, specialization & gender
Sales tracking with monthly trends & YoY comparisons
Survey analysis with cross-tabulation & charts
KPI scorecards with traffic light indicators
DELIVERABLES:
.xlsx file (fully functional)
Instructions sheet with how-to-use notes
Source data sheet (separated)
Portfolio: https://fms-data-analyst.web.app/
Send me a message, and I'll review your data for FREE!
Don't let your data sit in a boring spreadsheet. Let's make it work for you!
Get to know Fatima M Salman
Data Analytics Specialist
- FromPalestinian Territories
- Member sinceOct 2016
- Last delivery5 years
Languages
English, Arabic
My Portfolio
Other Data Visualization Services I Offer
FAQ
What version of Excel do you use?
I use Microsoft 365, but I can save files in .xlsx format compatible with Excel 2016 and later.
Can you work with large datasets?
Yes! For very large datasets (100K+ rows), I use Power Query to optimize performance.
Will the dashboard update automatically when I add new data?
In the Premium package, yes! I'll set up the dashboard so you can paste new data and everything refreshes.
Do you write VBA macros?
I can include simple VBA automation in the Premium package. For complex macro projects, please message me first.
Can you add charts that update dynamically?
Absolutely — all my charts are connected to pivot tables and will update as your data changes.
