Excel_Data_Cleaning_Practice_Workbook (1).xlsx
29.6 KB
🚀 Excel Data Cleaning Practice Sheet is Here!
Master the Top 5 Excel cleaning hacks with 350+ real rows of data.
Perfect for beginners, jobseekers & data entry users.
📁 Download here: Excel_Data_Cleaning_Practice_Workbook.xlsx
✅ Practice removing duplicates, trimming spaces, fixing numbers & more — just like a pro!
Master the Top 5 Excel cleaning hacks with 350+ real rows of data.
Perfect for beginners, jobseekers & data entry users.
📁 Download here: Excel_Data_Cleaning_Practice_Workbook.xlsx
✅ Practice removing duplicates, trimming spaces, fixing numbers & more — just like a pro!
❤1
🧠💥 Hidden Offer: How to get Perplexity Pro FREE for 1 year (worth ₹17,000!)
🚨 No clickbait — this is an official offer from Airtel + Perplexity AI.
Here’s how to get it in just 3 minutes:
✅ Step-by-step guide:
1. Update or install the “Airtel Thanks” app (Android/iOS)
2. Log in with your Airtel mobile number
3. On the home screen, scroll down to find the “Airtel Exclusive” banner or search for “Perplexity.”
4. Tap on the Perplexity Pro offer
5. Click on Claim Now → it will redirect you to Perplexity’s site
6. Log in or sign up on Perplexity using the same Airtel number/email
7. Done! You get 1 year of Pro access for free (no credit card required)
🔐 You now have access to an AI research tool that is better than ChatGPT for real-time insights, office tasks, and student research.
🔥 Use it for writing, summaries, emails, presentations, learning, and more — completely ad-free and super fast!
📌 Share this post in your groups before the offer ends.
📩 For visual steps, check out my Instagram reel @ankitexceler.
💬 If you are stuck anywhere, message me "CLAIM".
🚨 No clickbait — this is an official offer from Airtel + Perplexity AI.
Here’s how to get it in just 3 minutes:
✅ Step-by-step guide:
1. Update or install the “Airtel Thanks” app (Android/iOS)
2. Log in with your Airtel mobile number
3. On the home screen, scroll down to find the “Airtel Exclusive” banner or search for “Perplexity.”
4. Tap on the Perplexity Pro offer
5. Click on Claim Now → it will redirect you to Perplexity’s site
6. Log in or sign up on Perplexity using the same Airtel number/email
7. Done! You get 1 year of Pro access for free (no credit card required)
🔐 You now have access to an AI research tool that is better than ChatGPT for real-time insights, office tasks, and student research.
🔥 Use it for writing, summaries, emails, presentations, learning, and more — completely ad-free and super fast!
📌 Share this post in your groups before the offer ends.
📩 For visual steps, check out my Instagram reel @ankitexceler.
💬 If you are stuck anywhere, message me "CLAIM".
❤2
Apply Links for Data Analyst Jobs (Fresher | ₹5–10 LPA):
1. AMS India
https://www.amsindia.org/Homes/Job_Description?Pk_Career_Id=31
2. IIFL Home Finance (Gurugram)
https://www.naukri.com/job-listings-data-analyst-iifl-home-finance-gurugram-1-to-3-years-100725014037
3. Mercer (Gurugram)
https://www.naukri.com/job-listings-data-analyst-survey-administration-marsh-mclennan-global-services-india-private-limited-gurugram-1-to-6-years-220725922260
4. CryptoChakra
https://www.linkedin.com/jobs/view/4267885160
5. Fintune
https://in.indeed.com/viewjob?jk=ad5112064b3cd911
Let me know once applied. Best of luck!💼🚀
1. AMS India
https://www.amsindia.org/Homes/Job_Description?Pk_Career_Id=31
2. IIFL Home Finance (Gurugram)
https://www.naukri.com/job-listings-data-analyst-iifl-home-finance-gurugram-1-to-3-years-100725014037
3. Mercer (Gurugram)
https://www.naukri.com/job-listings-data-analyst-survey-administration-marsh-mclennan-global-services-india-private-limited-gurugram-1-to-6-years-220725922260
4. CryptoChakra
https://www.linkedin.com/jobs/view/4267885160
5. Fintune
https://in.indeed.com/viewjob?jk=ad5112064b3cd911
Let me know once applied. Best of luck!💼🚀
❤2
🚀 Convert any PDF to Excel using Chat GPT!
Use this smart prompt to extract tabular data from your PDFs in just seconds ⚡
PROMPT 1:
You are now an advanced Excel expert with 5+ years of experience in handling complex data. Your task is to extract all structured table data from the uploaded PDF and convert it into a clean, usable Excel sheet.
Keep these rules in mind:
1. Extract only actual data tables — avoid page numbers, headers, and footers.
2. Maintain all table columns and row structures exactly as shown.
3. If the PDF contains multiple tables, organize each into a separate Excel sheet.
4. Provide the result in downloadable
5. If any data looks unclear, ask for clarification before processing.
Let’s begin. Please upload the PDF file.
PROMPT 2:
You are a highly skilled Excel Data Specialist with over 5+ years of experience in handling, formatting, and cleaning complex datasets.
I will upload a structured PDF file that contains tabular data.
Your job is to extract all the tables from this PDF and convert them into a clean, copy-paste-ready Excel table format, preserving column alignment, data accuracy, and date/number formatting.
Ensure the output appears exactly as an Excel sheet, with proper columns and rows.
Do not summarize. Just output the full table.
🧠 What this prompt does:
✅ Automatically detects table data
✅ Cleans and converts it into Excel
✅ Handles multiple tables with ease
✅ Saves hours of manual work
📩 Need help using this prompt?
DM me on Instagram 👉 @ankitexceler
Use this smart prompt to extract tabular data from your PDFs in just seconds ⚡
PROMPT 1:
You are now an advanced Excel expert with 5+ years of experience in handling complex data. Your task is to extract all structured table data from the uploaded PDF and convert it into a clean, usable Excel sheet.
Keep these rules in mind:
1. Extract only actual data tables — avoid page numbers, headers, and footers.
2. Maintain all table columns and row structures exactly as shown.
3. If the PDF contains multiple tables, organize each into a separate Excel sheet.
4. Provide the result in downloadable
.xlsx format, properly formatted and cleaned.5. If any data looks unclear, ask for clarification before processing.
Let’s begin. Please upload the PDF file.
PROMPT 2:
You are a highly skilled Excel Data Specialist with over 5+ years of experience in handling, formatting, and cleaning complex datasets.
I will upload a structured PDF file that contains tabular data.
Your job is to extract all the tables from this PDF and convert them into a clean, copy-paste-ready Excel table format, preserving column alignment, data accuracy, and date/number formatting.
Ensure the output appears exactly as an Excel sheet, with proper columns and rows.
Do not summarize. Just output the full table.
🧠 What this prompt does:
✅ Automatically detects table data
✅ Cleans and converts it into Excel
✅ Handles multiple tables with ease
✅ Saves hours of manual work
📩 Need help using this prompt?
DM me on Instagram 👉 @ankitexceler
❤2
Hi Excelers 👋
Thanks for commenting "FUNCTION" on my post.
As promised, here's your FREE Excel PDF to clear all your confusion about functions ✅
🔗https://drive.google.com/file/d/1WpK22sGRgkcXcT7qkgatmFDNMDL1OJ3s/view?usp=drive_link
This quick guide will help you understand:
• Difference between formulas and functions
• How to write correct functions
• 10+ essential Excel functions for beginners
If you find this helpful, feel free to share it or tag me in your story.
And don't forget to follow @ankitexceler for more Excel content like this! 💻✨
Thanks for commenting "FUNCTION" on my post.
As promised, here's your FREE Excel PDF to clear all your confusion about functions ✅
🔗https://drive.google.com/file/d/1WpK22sGRgkcXcT7qkgatmFDNMDL1OJ3s/view?usp=drive_link
This quick guide will help you understand:
• Difference between formulas and functions
• How to write correct functions
• 10+ essential Excel functions for beginners
If you find this helpful, feel free to share it or tag me in your story.
And don't forget to follow @ankitexceler for more Excel content like this! 💻✨
❤1
Hi Excelers 👋
Thank you so much for commenting 'ROADMAP' on my post 🙌
As I promised, here’s your free guide:
📘 Excel Career Roadmap – 8 Job Roles You Can Master
👉 https://drive.google.com/file/d/1hlr7q0BeoceITDRf7R--RUFVk-kXUCC3/view?usp=sharing
This PDF will help you:
✅ Explore 8 high-paying Excel-based jobs
✅ Learn skills step by step with roadmaps
✅ Access free resources to start practicing today
✨ My advice -> Don’t just download it, pick one role & start learning consistently.
Even 1 hour of focused practice daily can change your career in the next 90 days.
If you ever feel stuck, you can always DM me — I’ll be happy to guide you. 🤝
Best of luck with your Excel journey 🚀
— Ankit Sharma (@ankitexceler)
Thank you so much for commenting 'ROADMAP' on my post 🙌
As I promised, here’s your free guide:
📘 Excel Career Roadmap – 8 Job Roles You Can Master
👉 https://drive.google.com/file/d/1hlr7q0BeoceITDRf7R--RUFVk-kXUCC3/view?usp=sharing
This PDF will help you:
✅ Explore 8 high-paying Excel-based jobs
✅ Learn skills step by step with roadmaps
✅ Access free resources to start practicing today
✨ My advice -> Don’t just download it, pick one role & start learning consistently.
Even 1 hour of focused practice daily can change your career in the next 90 days.
If you ever feel stuck, you can always DM me — I’ll be happy to guide you. 🤝
Best of luck with your Excel journey 🚀
— Ankit Sharma (@ankitexceler)
❤1
Hi Excelers 👋
Here are the Microsoft free courses I promised ⬇️
1️⃣ Career Essentials in Data Analysis
🔗 https://www.linkedin.com/learning/paths/career-essentials-in-data-analysis-by-microsoft-and-linkedin
2️⃣ Microsoft Power BI Data Analyst
🔗 https://www.coursera.org/professional-certificates/microsoft-power-bi-data-analyst
3️⃣ Data Analysis Using Excel (Imperial Business School)
🔗 https://learning.edx.org/course/course-v1:ImperialBusinessX+ICBS004+2T2022/home
4️⃣ Analyze & Present with Microsoft 365 Copilot
🔗 https://www.edx.org/learn/computer-science/microsoft-draft-analyze-and-present-with-microsoft-365-copilot?index=product&queryId=d09b5d2de75170d9b38817e558451639&position=4
💡 Some certificates may be paid — choose Audit to learn for free.
Enjoy learning & keep growing! 🚀
– Ankit Sharma | @AnkitExceler
Here are the Microsoft free courses I promised ⬇️
1️⃣ Career Essentials in Data Analysis
🔗 https://www.linkedin.com/learning/paths/career-essentials-in-data-analysis-by-microsoft-and-linkedin
2️⃣ Microsoft Power BI Data Analyst
🔗 https://www.coursera.org/professional-certificates/microsoft-power-bi-data-analyst
3️⃣ Data Analysis Using Excel (Imperial Business School)
🔗 https://learning.edx.org/course/course-v1:ImperialBusinessX+ICBS004+2T2022/home
4️⃣ Analyze & Present with Microsoft 365 Copilot
🔗 https://www.edx.org/learn/computer-science/microsoft-draft-analyze-and-present-with-microsoft-365-copilot?index=product&queryId=d09b5d2de75170d9b38817e558451639&position=4
💡 Some certificates may be paid — choose Audit to learn for free.
Enjoy learning & keep growing! 🚀
– Ankit Sharma | @AnkitExceler
❤3
Hi Excelers 👋
Here’s your PwC Fresher Data Analyst Apply Link:
📌 Apply: https://tinyurl.com/mperchrm
Details:
Role: Data Analyst (Big 4 – PwC)
Salary: ₹5–7 LPA
Eligibility: BE/BTech/ME/MTech/MCA (Freshers)
Skills: SQL/Python, Excel, Tableau/Power BI, Data Analysis
Good to Have: Cloud, Risk Mgmt, Consulting
Location: India (check job listing for specifics)
💡 Apply ASAP — fresher seats fill quickly! 🚀
— Ankit Sharma (@ankitexceler)
Here’s your PwC Fresher Data Analyst Apply Link:
📌 Apply: https://tinyurl.com/mperchrm
Details:
Role: Data Analyst (Big 4 – PwC)
Salary: ₹5–7 LPA
Eligibility: BE/BTech/ME/MTech/MCA (Freshers)
Skills: SQL/Python, Excel, Tableau/Power BI, Data Analysis
Good to Have: Cloud, Risk Mgmt, Consulting
Location: India (check job listing for specifics)
💡 Apply ASAP — fresher seats fill quickly! 🚀
— Ankit Sharma (@ankitexceler)
❤3
Hi Excelers 👋
Thanks for commenting "TATA" on my reel.
As promised, here are the 4 free online internships by Tata Group – each comes with a certificate 🏅
Perfect for freshers to build real skills and boost your resume 📈
📌 Master Link (All Tata Internships):
https://www.theforage.com/simulations?companies=tata
🎓 Individual Internships:
Data Visualisation Internship:
https://www.theforage.com/simulations/tata/data-visualisation-p5xo
Data Analytics Internship:
https://www.theforage.com/simulations/tata/data-analytics-t3zr
Cybersecurity Internship:
https://www.theforage.com/simulations/tata/cybersecurity-sbda
ESG (Environment, Social & Governance) Internship:
https://www.theforage.com/simulations/tata/esg-j4vw
✅ Start any internship, complete at your own pace, and get a certificate.
Let me know which one you’re starting first! 💼✨
Thanks for commenting "TATA" on my reel.
As promised, here are the 4 free online internships by Tata Group – each comes with a certificate 🏅
Perfect for freshers to build real skills and boost your resume 📈
📌 Master Link (All Tata Internships):
https://www.theforage.com/simulations?companies=tata
🎓 Individual Internships:
Data Visualisation Internship:
https://www.theforage.com/simulations/tata/data-visualisation-p5xo
Data Analytics Internship:
https://www.theforage.com/simulations/tata/data-analytics-t3zr
Cybersecurity Internship:
https://www.theforage.com/simulations/tata/cybersecurity-sbda
ESG (Environment, Social & Governance) Internship:
https://www.theforage.com/simulations/tata/esg-j4vw
✅ Start any internship, complete at your own pace, and get a certificate.
Let me know which one you’re starting first! 💼✨
❤2
I’ve been inactive for a few days — no posts, no reels. Back now with consistent, better content!
❤️ PLEASE KEEP SUPPORTING ❤️
❤️ PLEASE KEEP SUPPORTING ❤️
❤1🥰1
Hi Excelers 👋
As I promised in the reel, here are 5 free Excel courses for you:
1️⃣ https://www.mygreatlearning.com/academy/learn-for-free/courses/excel-for-beginners
2️⃣ https://www.mygreatlearning.com/academy/learn-for-free/courses/excel-vba-for-beginners
3️⃣ https://www.mygreatlearning.com/academy/learn-for-free/courses/excel-for-intermediate-level
4️⃣ https://www.mygreatlearning.com/academy/learn-for-free/courses/chatgpt-for-excel
5️⃣ https://www.mygreatlearning.com/academy/learn-for-free/courses/data-analytics-using-excel
⚠️ Please note: These courses are free, but some certificates may require a paid subscription.
Happy learning! ✨📊
👉 Let me know which course you are starting first!
As I promised in the reel, here are 5 free Excel courses for you:
1️⃣ https://www.mygreatlearning.com/academy/learn-for-free/courses/excel-for-beginners
2️⃣ https://www.mygreatlearning.com/academy/learn-for-free/courses/excel-vba-for-beginners
3️⃣ https://www.mygreatlearning.com/academy/learn-for-free/courses/excel-for-intermediate-level
4️⃣ https://www.mygreatlearning.com/academy/learn-for-free/courses/chatgpt-for-excel
5️⃣ https://www.mygreatlearning.com/academy/learn-for-free/courses/data-analytics-using-excel
⚠️ Please note: These courses are free, but some certificates may require a paid subscription.
Happy learning! ✨📊
👉 Let me know which course you are starting first!
❤1
How can you find and replace data in Excel?
Anonymous Quiz
31%
Ctrl + F
20%
Ctrl + H
31%
Ctrl + R
17%
All of the above
❤1
Hi Excelers 👋
As I promised, here are 5 of the best resume builder websites you can try for free:
1️⃣ https://create.microsoft.com/en-us/templates/resumes
2️⃣ https://resume.io/resume-templates
3️⃣ https://enhancv.com/resume-templates/
4️⃣ https://www.canva.com/resumes/templates/
5️⃣ https://novoresume.com/resume-templates
✨ You can use any of these to build a professional, ATS-proof, and eye-catching resume within minutes.
👉 Need any help with building your resume or choosing the right template?
DM me on Instagram @AnkitExceler — I’ll be happy to guide you.
As I promised, here are 5 of the best resume builder websites you can try for free:
1️⃣ https://create.microsoft.com/en-us/templates/resumes
2️⃣ https://resume.io/resume-templates
3️⃣ https://enhancv.com/resume-templates/
4️⃣ https://www.canva.com/resumes/templates/
5️⃣ https://novoresume.com/resume-templates
✨ You can use any of these to build a professional, ATS-proof, and eye-catching resume within minutes.
👉 Need any help with building your resume or choosing the right template?
DM me on Instagram @AnkitExceler — I’ll be happy to guide you.
❤2
Which function is used to sum a range of cells in Excel?
Anonymous Quiz
9%
AVG()
11%
MAX()
80%
SUM()
1%
TOTAL()
❤1
What is the keyboard shortcut for copying cells in Excel?
Anonymous Quiz
11%
Ctrl + X
86%
Ctrl + C
3%
Ctrl + V
0%
Ctrl + Z
❤1
🚀 Excel Shortcuts A–Z (Must-Know!)
Ctrl + A > Select all data/worksheet
Ctrl + B > Bold text instantly
Ctrl + C > Copy selected cells
Ctrl + D > Fill down (copy content from above)
Ctrl + E > Flash Fill patterns
Ctrl + F > Find values/text
Ctrl + G > Go To any cell
Ctrl + H > Find & Replace quickly
Ctrl + I > Italic text
Ctrl + J > Add line break in cell
Ctrl + K > Insert hyperlink
Ctrl + L > Turn data into Table
Ctrl + N > New workbook
Ctrl + O > Open workbook
Ctrl + P > Print sheet
Ctrl + Q > Quick Analysis tool
Ctrl + R > Fill right (copy from left)
Ctrl + S > Save workbook
Ctrl + T > Convert range to table
Ctrl + U > Underline text
Ctrl + V > Paste selection
Ctrl + W > Close workbook
Ctrl + X > Cut selection
Ctrl + Y > Redo last action
Ctrl + Z > Undo last action
Excel mastery = Speed! ⚡
Which shortcut do you use daily? Comment below ⬇️
Ctrl + A > Select all data/worksheet
Ctrl + B > Bold text instantly
Ctrl + C > Copy selected cells
Ctrl + D > Fill down (copy content from above)
Ctrl + E > Flash Fill patterns
Ctrl + F > Find values/text
Ctrl + G > Go To any cell
Ctrl + H > Find & Replace quickly
Ctrl + I > Italic text
Ctrl + J > Add line break in cell
Ctrl + K > Insert hyperlink
Ctrl + L > Turn data into Table
Ctrl + N > New workbook
Ctrl + O > Open workbook
Ctrl + P > Print sheet
Ctrl + Q > Quick Analysis tool
Ctrl + R > Fill right (copy from left)
Ctrl + S > Save workbook
Ctrl + T > Convert range to table
Ctrl + U > Underline text
Ctrl + V > Paste selection
Ctrl + W > Close workbook
Ctrl + X > Cut selection
Ctrl + Y > Redo last action
Ctrl + Z > Undo last action
Excel mastery = Speed! ⚡
Which shortcut do you use daily? Comment below ⬇️
❤2
What is MS Excel?
Anonymous Quiz
66%
Spreadsheet
22%
Database Management
1%
Presentation
11%
Workbook
❤2
Hi Excelers 👋
Thanks for commenting on my reel! As promised, here are the 3 FREE TCS certificate courses for you:
1️⃣ TCS iON Career Edge - Young Professional
🔗 https://www.tcsion.com/courses/career-edge-young-professional/
2️⃣ TCS iON Career Edge - IT Primer
🔗 https://www.tcsion.com/courses/career-edge-it-course/
3️⃣ TCS iON Career Edge - Interview and Job Readiness
🔗 https://www.tcsion.com/courses/career-edge-interview-and-job-readiness/
📌 Save these links & start learning today 🚀
✅ Also, keep following @ankitexceler for more free courses, internships & career tips!
Thanks for commenting on my reel! As promised, here are the 3 FREE TCS certificate courses for you:
1️⃣ TCS iON Career Edge - Young Professional
🔗 https://www.tcsion.com/courses/career-edge-young-professional/
2️⃣ TCS iON Career Edge - IT Primer
🔗 https://www.tcsion.com/courses/career-edge-it-course/
3️⃣ TCS iON Career Edge - Interview and Job Readiness
🔗 https://www.tcsion.com/courses/career-edge-interview-and-job-readiness/
📌 Save these links & start learning today 🚀
✅ Also, keep following @ankitexceler for more free courses, internships & career tips!
❤1
Hi Excelers 👋
Here are some super useful Excel Shortcuts 🧑💻
KEYS -> ACTION
Ctrl + 1 -> Open Format Cells dialog
Ctrl + 2 -> Bold selected text/cell
Ctrl + 3 -> Italicize selected text/cell
Ctrl + 4 -> Underline selected text/cell
Ctrl + 5 -> Strikethrough
Ctrl + 6 -> Toggle objects (show/hide)
Ctrl + 7 -> Show/Hide toolbar
Ctrl + 8 -> Show/Hide outline symbols
Ctrl + 9 -> Hide selected rows
Start using these daily and speed up your work. 🚀
Follow for more Excel hacks. ⚡
Here are some super useful Excel Shortcuts 🧑💻
KEYS -> ACTION
Ctrl + 1 -> Open Format Cells dialog
Ctrl + 2 -> Bold selected text/cell
Ctrl + 3 -> Italicize selected text/cell
Ctrl + 4 -> Underline selected text/cell
Ctrl + 5 -> Strikethrough
Ctrl + 6 -> Toggle objects (show/hide)
Ctrl + 7 -> Show/Hide toolbar
Ctrl + 8 -> Show/Hide outline symbols
Ctrl + 9 -> Hide selected rows
Start using these daily and speed up your work. 🚀
Follow for more Excel hacks. ⚡
❤2
Hi Excelers 👋
Abhi hamare Instagram page ki situation thodi tough chal rahi hai 😟
Instagram hamare content ko jyada logon tak push nahi kar raha...
Aur honestly, agar aap sabhi ka support na mila to ye PAGE DEAD bhi ho sakta hai 💔
Aap hi log ho jo is page ko bacha sakte ho. 🙏
Bas ek chhoti si request hai:
Jaake hamare page ki reels ko Like ❤️, Comment 💬, Save 📌, aur Share 🔄 karo.
Aapka har ek support hamare liye bahut valuable hai ✨
https://www.instagram.com/ankitexceler/
Abhi hamare Instagram page ki situation thodi tough chal rahi hai 😟
Instagram hamare content ko jyada logon tak push nahi kar raha...
Aur honestly, agar aap sabhi ka support na mila to ye PAGE DEAD bhi ho sakta hai 💔
Aap hi log ho jo is page ko bacha sakte ho. 🙏
Bas ek chhoti si request hai:
Jaake hamare page ki reels ko Like ❤️, Comment 💬, Save 📌, aur Share 🔄 karo.
Aapka har ek support hamare liye bahut valuable hai ✨
https://www.instagram.com/ankitexceler/
❤1
👉 Kya aap hamare Instagram page ko support kar rahe ho?
Anonymous Poll
89%
✅ Support kar diya
11%
🙌 Abhi support karta hoon
❤1