Sfoglia categorie
Esplora
Fiverr Pro
Italiano
$
USD
I will create excel spreadsheet , formula , charts and dashboard
I am a Mechanical Engineer with expertise in AutoCAD 2D design, P&IDs (Piping and Instrumentation Diagrams), plant layouts, PFDs, UFDs (Utility Flow Diagrams), BFDs (Block Flow Diagrams), and piping i...
Informazioni su questo servizio
- Excel Formula: Crafting and optimizing formulas for accurate data calculations.
- Excel Dashboard: Designing dynamic and interactive dashboards for comprehensive data analysis.
- Data Validation: Implementing validation rules to ensure data accuracy and integrity.
- Conditional Formatting: Applying formatting rules based on specified conditions for better data visualization.
- Sorting & Filtering: Organizing and filtering data to facilitate analysis and decision-making.
- Professional Spreadsheet Design: Enhancing the appearance of spreadsheets for a polished and professional look.
- Text/Data Splitting: Breaking down text or data into separate cells for better organization and analysis.
- Pivot Table and Charts: Creating pivot tables and charts to summarize and visualize data trends.
- Excel Functions: Expertise in functions like VLOOKUP, HLOOKUP, COUNTIF, COUNTIFS, SUMIF/SUMIFS, and INDEX MATCH for advanced data manipulation.
- Data Manipulation: Manipulating data efficiently through sorting, filtering, generating reports, and removing duplicates.
- File Conversion: Converting various file formats including PDF, Word, and scanned pages to Excel or CSV format for easy data manipulation and analysis.
Piattaforma:
Excel
•
Fogli Google
•
Altro
Tecnologia di sviluppo:
vba
•
Power Query
•
Altro
Expertise:
Formattazione
•
Tabelle pivot
•
Formule
•
Funzioni
•
Altro
