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
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 ⬇️
❀2
❀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!
❀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. ⚑
❀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/
❀1
πŸ‘‰ Kya aap hamare Instagram page ko support kar rahe ho?
Anonymous Poll
89%
βœ… Support kar diya
11%
πŸ™Œ Abhi support karta hoon
❀1
Hello Excelers πŸ‘‹

As promised, here is the website link where you can easily create your ATS-friendly resume:

πŸ‘‰ https://www.resumeground.com/

I recommend using its free tools and templates β€” they will really help you create a professional resume.

Best wishes for your career πŸš€
❀2
Hello Excelers πŸ‘‹

Thanks for commenting on my reel πŸ™Œ

As promised, here is the PDF of my interview questions and answers that will help you better prepare for your next interview:

πŸ“„
Practice answering interview questions

All the best for your upcoming interviews πŸš€

Keep learning and growing! ✨
❀1
Hello Excelers πŸ‘‹

Thanks for commenting on my reel πŸ™Œ

As promised, here are 10 trusted websites where you can apply for free internships β€” suitable for both freshers and experienced candidates:

πŸ”— Internshala – https://internshala.com/

πŸ”— Naukri –
https://www.naukri.com/

πŸ”— Indeed –
https://indeed.com/

πŸ”— Unstop –
https://unstop.com/

πŸ”— Skill India Digital –
https://www.skillindiadigital.gov.in/

πŸ”— Prosple –
https://in.prosple.com/

πŸ”— TCS Careers –
https://www.tcs.com/

πŸ”— Virtual Internships –
https://www.virtualinternships.com/

πŸ”— Deloitte Careers –
https://www.deloitte.com/

πŸ”— Amazon Jobs –
https://www.amazon.jobs/en/

All the best for your internship journey πŸš€

Apply regularly and be consistent ✨
❀3πŸ”₯1
Hi Excelers πŸ‘‹

Thanks for commenting on my reel πŸ™Œ

As I promised, here is Gemini for Google Workspace – Prompting Guide 101 (by Google).

πŸ“„ Access your PDF here

This guide provides a comprehensive overview of writing effective prompts. It is extremely useful if you want to master the prompting step-by-step. ✨

Best wishes πŸš€
❀2πŸ‘1
Hey ExcelersπŸ‘‹

Use this prompt to build your ATS-friendly resume πŸ‘‡

Act as an expert resume writer.
Help me create a clean, professional, ATS-friendly resume.
Ask me for details step by step (don’t skip any part).

Here are the steps you must follow:

Ask for my Full Name & Contact Information

Ask my Target Job Title & Career Objective

Ask for my Education Details (degree, year, %/CGPA, college)

Ask for my Work Experience (company, role, dates, achievements with numbers)

Ask for my Skills (both technical & soft skills)

Ask for my Certifications / Projects

Ask me to share keywords from my target job description

βœ… Once I give all details, create a final resume in plain text with:

Clear section headings (SUMMARY, EXPERIENCE, EDUCATION, SKILLS, CERTIFICATIONS, PROJECTS, KEYWORDS)

Bullet points for achievements, showing measurable impact (% / numbers)

Simple formatting (no tables, no fancy fonts) so it passes ATS scans.

⚑ Bonus: Suggest 2–3 additional keywords that most recruiters expect for my target role, so I don’t miss them.


⚠️ Disclaimer: This prompt gives you a strong foundation, but once you add your personal touch and real details, your resume will become much more professional and impressive.
❀5
πŸ”₯ 12 Most In-Demand Skills – Complete Free Courses

As promised! Everyone who commented β€œSKILL” on my reel β€” here are all the full courses for you.

πŸ‘‡ Start learning any skill from here:

1️⃣ Data Analyst

https://youtu.be/VaSjiJMrq24?si=WTGx3hGK6ipGNcZ-

2️⃣ Artificial Intelligence

https://www.youtube.com/live/zE8soWrsg2Y?si=7TcUxqEHN8nztRxe

3️⃣ Machine Learning

https://youtu.be/LvC68w9JS4Y?si=uQtIN7krNTTi67zY

4️⃣ Digital Marketing

https://youtu.be/01Imoibt4as?si=_0VWsZOyAyrEe0ct

5️⃣ Data Science

https://youtu.be/gDZ6czwuQ18?si=F2vxhdwYrYSg0DHa

6️⃣ Generative AI

https://youtu.be/JQEwPa5FStM?si=OpYAVhsB6Ls4cVE
_

7️⃣ Cyber Security

https://youtu.be/v3iUx2SNspY?si=ySF6di6pU8L-pCsH

8️⃣ Programming (Beginner Friendly)

https://youtu.be/UrsmFxEIp5k?si=W3019mglRJ_74NEe

9️⃣ Cloud Computing – Full Course (2026)

https://youtu.be/JoNPWZcExNA?si=Qvt8G3D5KFMPdhD3

πŸ”Ÿ Business Analytics – Full Course (2025)

https://youtu.be/bftaMQjNkYI?si=kcCuuwP7VsWR4Zz
_

1️⃣1️⃣ Power BI – Full Course

https://youtu.be/qOTdpjLUELg?si=a2QB7gkIJIlqtX0I

1️⃣2️⃣ Prompt Engineering – Full Course (2025)

https://youtu.be/BUdwDOLQVWc?si=yrnXvx4JnPbaFWxW

🎁 Learn new skills and upgrade your career!
πŸ‘‰ Follow for more free learning resources.
❀6
πŸ”₯ The Ultimate Excel Mastery Course (Basic to Advanced)

Learn Excel from zero to expert, most simply and practically!

πŸ“˜ What You Will Learn Inside:

β€’ Excel basics
β€’ Essential formulas
β€’ Data cleaning & analysis
β€’ Charts & visual reports
β€’ Pivot tables
β€’ Smart automation tricks
β€’ Real office projects


🎁 What You Get:

β€’ Lifetime access
β€’ Step-by-step lessons
β€’ Practice files


πŸ’° Price: Only β‚Ή199
(Such courses usually cost β‚Ή1699–₹3500 elsewhere!)

πŸ“₯ For course details & to buy, contact: @ankitexceler
❀4
⭐ Join the Exceler Community – Lifetime Access (β‚Ή199)

What You Get:

β€’ Lifetime learning support
β€’ Exclusive Excel resources & files
β€’ Priority doubt-solving
β€’ Members-only tips & tools
β€’ Early access to new lessons
β€’ Community-only updates


How to Join:

β€’ Scan the QR / Use UPI ID
β€’ Send payment screenshot to
@ankitexceler

Welcome to the Exceler Family 🀝✨
❀3
Namaste Excelers πŸ‘‹

Aap sabka support aur pyar hi mujhe roz motivate karta hai ki main aapke liye aur bhi behtar Excel content banaun.

Isi journey ko aur strong banane ke liye Exceler Community banaayi gayi haiβ€”jahan par main aapko personal doubt support, exclusive courses, cheat sheets, handwritten notes aur bahut saari helpful cheezein deta hoon.


Jab bhi aapko koi doubt ho, bas message kar dena… main hamesha help ke liye hoon ❀️

2026 aane me sirf 25 din bache hain, aur mujhe full confidence hai ki hum milkar in 25 dino me Excel ko job-ready level tak seekh sakte hain.
Aapka har ek message, har ek support, mere liye bahut special hai.

Love you Exceler Family ❀️
Chalo saath me grow karte hain!
❀4
Please open Telegram to view this post
VIEW IN TELEGRAM