Browse categories
Explore
Fiverr Pro
English
$
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...
About this Gig
- 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.
Platform:
Excel
•
Google Sheets
•
Other
Development technology:
VBA
•
Power Query
•
Other
Expertise:
Formatting
•
Pivot tables
•
Formulas
•
Functions
•
Other
