Advanced Excel Expert - On-Site - Lahore

We are looking for an Advanced Excel Expert who can create custom Excel solutions for reporting, planning, tracking, analysis, and calculation needs. The ideal candidate should have strong experience in building spreadsheets from scratch and should be able to turn business requirements into clear, accurate, and easy-to-use Excel files.

Responsibilities

• Develop custom Excel workbooks for business, finance, reporting, and operational tasks.
• Build calculators, dashboards, trackers, reports, logs, and planning sheets.
• Use advanced formulas and functions to automate calculations and manage data across worksheets.
• Set up dropdowns, data validation, conditional formatting, tables, charts, and summary sections.
• Review and test workbook logic, formulas, and linked cells before final delivery.
• Improve existing Excel files by fixing errors, improving structure, and making them more user-friendly.

Required Skills

• Strong command of Microsoft Excel.
• Advanced knowledge of formulas such as IF, IFS, IFERROR, SUMIF, SUMIFS, COUNTIF, COUNTIFS, XLOOKUP, VLOOKUP, INDEX, MATCH, FILTER, SORT, UNIQUE, TEXT, DATE, EOMONTH, TODAY, PMT, FV, PV, NPV, and IRR.
• Experience with PivotTables, charts, workbook protection, named ranges, and spreadsheet logic.
• Ability to build clean, accurate, and well-structured Excel files for different business needs.
• Basic knowledge of Power Query, VBA, macros, or Google Sheets is a plus.

Qualifications

• Strong analytical and problem-solving skills with the ability to handle large datasets
• Experience in data visualization and creating custom dashboards
• Attention to detail and a thorough understanding of data accuracy and organizational standards
• Bachelor's degree in Computer Science, Mathematics, Business, or a related field
• Experience in business analysis or financial modeling is a plus
• Ability to work effectively in an on-site, collaborative team environment