I need expert help converting a complex Excel workbook with formulas and utilities into an editable Google Sheet. The existing Excel file contains a worksheet linked cells, SUMIFS, COUNTIFS and other advanced formulas to calculate metrics. Conditional formatting is also used extensively. The goal is to recreate an identical online version of this workbook using Google Sheets so our team can collaborate remotely. Applicants should have extensive experience with both Excel and Google Sheets and the ability to mimic complicated formulas across sheets. The converted Sheet must retain full functionality of the original file including automatic recalculations. Formatting like charts, conditional fills and others should match the Excel version for easy reference. Proficiency translating pivot tables, data validation and other Excel features to Google Sheets is essential.
I would love also to have your advise if you see there's something I can add to the document in order to improve it.
