Ankit Sharma
1.23K subscribers
2 photos
1 file
18 links
๐Ÿ“Š Master Excel with smart tips & tricks.
โœจ Access PDFs, videos, tools & more.
๐Ÿ“ˆ Learn analysis, automation & dashboards.
๐Ÿš€ Join for smarter Excel solutions.
Download Telegram
Channel created
Welcome to our Telegram channel! ๐ŸŽ‰

I'm so excited to have you here! ๐Ÿš€ This is where you can enhance your Excel skills and take your productivity to the next level. ๐Ÿ’ผ

I regularly share tips, tricks, and insights to help you master Excel. From shortcuts to advanced techniques, you'll find everything you need to become a true Excel pro! ๐ŸŽฏ

Feel free to ask questions, connect with others, and most importantly, start learning. Let's make Excel your superpower! ๐Ÿ’ฅ
โค1
Hi Excelers ๐Ÿ‘‹

Thank you for your interest in my FREE Excel Shortcuts Guide ebook. ๐ŸŽ‰ I'm excited to help you enhance your Excel skills.

๐—ฆ๐—ฝ๐—ฒ๐—ฐ๐—ถ๐—ฎ๐—น ๐—š๐—ถ๐—ณ๐˜ ๐—ณ๐—ผ๐—ฟ ๐—ฌ๐—ผ๐˜‚!

I've created a special FREE ebook - "Excel Shortcut Mastery Guide" to make your work more productive!

โœ” 300+ Excel shortcuts
โœ” Time-saving tips
โœ” Productivity-boosting tricks

Whether you're a beginner or growing, this guide is here to help you. Let me know if you need any help. ๐Ÿ’ช

๐—›๐—ฒ๐—ฟ๐—ฒ'๐˜€ ๐˜†๐—ผ๐˜‚๐—ฟ ๐—น๐—ถ๐—ป๐—ธ ๐˜๐—ผ ๐—ฑ๐—ผ๐˜„๐—ป๐—น๐—ผ๐—ฎ๐—ฑ ๐˜๐—ต๐—ฒ ๐—™๐—ฅ๐—˜๐—˜ ๐—ฒ๐—ฏ๐—ผ๐—ผ๐—ธ:

https://drive.google.com/file/d/1o02B5lj8kAyAhmKUh7xuUJyI83L6LZt_/view?usp=drive_link
โค1
โœจ Free Excel Course (Basic to Advanced) โœจ
Here are the 4 course videos I promised โ€” watch them in this order for best results:

๐Ÿ“Œ 1. Excel Full Tutorial for Beginners (Basic to Advance)
๐Ÿ‘‰ https://youtu.be/Kjz_DDO4Fzs?si=bsbg2PeIIoK8yIQh

๐Ÿ“Œ 2. Top Excel Formulas Explained with Examples
๐Ÿ‘‰ https://youtu.be/ihs5Yajk9Vs?si=GzqIgIxbdKoEtzHo

๐Ÿ“Œ 3. Mastering Excel Charts & Data Visualization
๐Ÿ‘‰ https://youtu.be/wF8Vew_ydRQ?si=xgP0oV0Zvi_5gh_z

๐Ÿ“Œ 4. Complete Excel Project for Practice (Step-by-Step)
๐Ÿ‘‰ https://youtu.be/XbyiTh-6k9Q?si=fm9_5j2qxK-3cxiv

๐Ÿ“ฅ Watch, practice, and master Excel skills!
โค2
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!
โค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".
โค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 .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! ๐Ÿ’ปโœจ
โค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)
โค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
โค3