Ankit Sharma
1.24K 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
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
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)
❀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! πŸ’Όβœ¨
❀2
I’ve been inactive for a few days β€” no posts, no reels. Back now with consistent, better content!

❀️ 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!
❀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.
❀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 ⬇️
❀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