I require assistance in resolving and troubleshooting various Excel formula and functional issues that I have encountered. As a non-specialist Excel user, complex calculations and nested functions often prove challenging for me to decipher and implement correctly. The tasks will involve analyzing Excel workbooks containing numerical data and conditional formatting, identifying logic or syntax errors in the formulae, and providing corrected formulas or VBA code as solutions.
Some examples of the type of problems include calculating totals and weighted averages across multiple sheets, indexing and matching data based on criteria, aggregating variable ranges, and creating pivot tables and charts from raw data. My ultimate goal is to streamline processes, gain a better understanding of Excel's capabilities, and reduce reliance on manual workarounds. The ability to communicate steps clearly both verbally and in writing is important.
Prior experience working with advanced Excel features such as Vlookups, IF statements, conditional formatting etc. as well as excellent analytical and troubleshooting skills will be valued. As I will be providing the files and data for review, discretion must be maintained. This is a short-term contracting opportunity. The successful bidder will have proven expertise in untangling complex Excel issues to deliver robust, well documented solutions.
Minimalist Portfolio Website edit Category: CSS, Graphic Design, HTML, JavaScript, PHP, UI / User Interface, Web Design, Web Development, Website Optimization Budget: ₹100 - ₹400 INR
08-Dec-2025 17:04 GMT
TradingView Pine Script Strategy Development Needed Category: Backtesting, Data Analysis, Data Visualization, Financial Analysis, Financial Markets, Financial Software Development, Market Analysis, Market Research, Pine Script, Risk Management Budget: $30 - $250 USD
08-Dec-2025 17:04 GMT
Watercolor Family Holiday Portrait Category: Art Installation, Digital Art, Digital Painting, Graphic Design, Illustration, Photoshop, Visual Arts Budget: $10 - $30 USD
08-Dec-2025 17:03 GMT
Figma UX Visual Appeal Overhaul Category: Accessibility, Figma, Graphic Design, Icon Design, Logo Design, UI / User Interface, User Interface / IA, UX / User Experience Budget: $30 - $250 USD
Verify Chinese Business Addresses Online Category: Business Analysis, Data Entry, Data Management, Data Processing, Documentation, Excel, Research, Simplified Chinese Translator, Translation, Virtual Assistant Budget: $30 - $250 USD
08-Dec-2025 16:59 GMT
Android Gambling App Development Category: Android, Android App Development, IPhone, Mobile App Development, Mobile Development, PhoneGap, UI / User Interface, UX / User Experience Budget: ₹37500 - ₹75000 INR
08-Dec-2025 16:59 GMT
E-Commerce Web Design for Pharma Company Category: ECommerce, Graphic Design, Inventory Management, Magento, Payment Gateway Integration, PHP, Web Development, Web Design, Website Optimization, WooCommerce Budget: $30 - $250 USD
08-Dec-2025 16:58 GMT
Urgent WordPress UX Fixes Category: CSS, HTML, PHP, UI / User Interface, User Experience Research, Web Development, WooCommerce, WordPress Budget: $30 - $75 USD
08-Dec-2025 16:58 GMT
Historical Novel English Arabic Translation Category: Arabic Translator, Creative Writing, Editing, English (US) Translator, English Translation, Proofreading, Publishing, Translation Budget: $250 - $750 USD
