I will teach you how to use ai for excel data cleaning, formatting, and more
AI Consultant, Digital Marketing Consultant, and AI SEO Content Writer
Top Rated
Top Rated sellers are individually selected by Fiverr after meeting specific benchmarks for quality and service.
About this Gig
Use AI to Build and Edit Excel Spreadsheets with Simple Prompts
Stop spending hours manually building, fixing, and formatting spreadsheets. Learn how to connect Microsoft Excel to Claude AI or Microsoft Copilot and use plain English prompts to do the heavy lifting for you.
What You'll Learn
By the end of our session, you'll know how to prompt AI to complete:
- Data cleaning: Remove duplicates, fix inconsistencies, and standardize formats.
- Formatting: Color coding, conditional formatting, borders, etc.
- Adding formulas: SUM, VLOOKUP, IF statements, nested formulas, and more.
- Fixing broken formulas: Diagnose errors and get them corrected instantly.
- Creating charts and graphs: Bar, pie, line, scatter, and combo charts.
- Consolidating data: Merge multiple sheets or workbooks into one.
- Duplicating and restructuring: Copy, reorganize, and reshape data layouts.
- Sorting and filtering: Organize data by any criteria.
- Pivot tables: Summarize large datasets.
- Data validation: Set up dropdowns, rules, and input restrictions.
- Automating repetitive tasks: Build standardized templates.
- Data Mining: Analyze data for meaningful insights.
I train in other AI topics too!
Service type:
1:1 lessons
Topic:
AI for businesses
AI engine:
Other
Clients I’ve worked with
MEGA Sign
High-Tech Company
I curated over 200 pieces of digital marketing content for this Fiverr client.
Nov 2019-Nov 2022
Holmes Organics CBD
Nutrition
Client required informative content to drive traffic to their CBD blog that was in line with CBD marketing restrictions.
Dec 2018-Sep 2022

