imran M.

Not specified

• Excel Expert

  null
  Conducted data cleaning by efficiently removing duplicates, applying Text-to-Columns, utilizing TRIM, and addressing missing values. Established data entry rules, enabled error alerts, and created dynamic drop-down lists for validation purposes. Demonstrated expertise in advanced formulas such as XLOOKUP, INDEX/MATCH, nested IF statements, and various text functions. Designed interactive, automated executive dashboards for high-level data visualization, using Pivot Tables and Pivot Charts to summarize large datasets for trend analysis. Implemented user-friendly filters with interactive slicers and timelines for easier navigation through data. Applied conditional formatting to visually highlight key metrics, variances, and performance trends. Standardized executive report layouts to enhance readability and utilized custom number formatting for currencies, dates, percentages, and KPI indicators. Transformed unstructured raw data into optimized Excel Tables.

• Faculty of Arts

  Islamabad Board