Uploaded August 2025 | Updated November 2026, 3 hours ago
Excel doesn't have DENSE RANK. But sometimes that is exactly what we need. In this video, learn how to use UNIQUE() with LARGE or SORT to create dense rank in Excel, just like how it is in SQL.
Sample file: chandoo.org/wp/wp-content/uploads/2025/08/dense-rank-excel.xlsx
More Excel formulas: youtube.com/playlist?list=PLmejDGrsgFyDUK8Q_CfZEtQvmRqV0UMm_
#excel #sql #rank
Excel doesn't have DENSE RANK. But sometimes that is exactly what we need. In this video, learn how to use UNIQUE() with LARGE or SORT to create dense rank in Excel, just like how it is in SQL.
Sample file: chandoo.org/wp/wp-content/uploads/2025/08/dense-rank-excel.xlsx
More Excel formulas: youtube.com/playlist?list=PLmejDGrsgFyDUK8Q_CfZEtQvmRqV0UMm_
#excel #sql #rank










![How to make PERFECT Data Analyst Resume for Beginners [2025]
🎉 Unlock AI for $10 per month → https://ntn.so/Chandoo2
~
Make the perfect entry level data resume with three easy steps.
Step 1: Set up your resume for success with a clear and well-defined template. Then customize it for the job you are applying for.
Step 2: Build Impact with Limited Experience by highlighting transferable skills, using ATR style bullet points and creating a strong summary to reflect your passion.
Step 3: Stand out with personal branding and social media presence by setting up LinkedIn & GitHub profiles, double checking everything on the resume.
Step 4 (optional): Use my free Resume template & resume checker (AI) tool to see if your resume is a good fit for the job.
Notion template link 👉 https://rain-speedwell-127.notion.site/Job-Resume-Match-1228f52290ec801aae70e44f0cbf73c6?pvs=4
💼 Resources for you:
📃 Notion template - https://rain-speedwell-127.notion.site/Job-Resume-Match-1228f52290ec801aae70e44f0cbf73c6?pvs=4
💻 Learning:
Data analyst Roadmap (12 weeks) - https://youtu.be/R3bZ0LLv3Fk
Free data analyst course - https://www.youtube.com/playlist?list=PLmejDGrsgFyCD25L2XEKESQEw8smsY6WO
🎤 Interview prep:
Mistakes to avoid in the interviews - https://youtu.be/f7lBYh1_9BQ
Power BI Interview questions - https://youtu.be/aZihsRsEYTE
Data analyst interview questions - https://youtu.be/MX6Ee_ubE1s
Sample technical question - https://youtu.be/cMEvyhvd5Es
👩💻 Courses:
Power BI course - https://chandoo.org/wp/power-bi-course/
Excel Course - https://chandoo.org/wp/excel-school-program/
⏱ Video topics:
0:00 - 3 steps to make a stunning entry level resume
0:18 - Step 1 (setting up for success)
3:17 - Step 2 (build impact with limited or no experience)
4:09 - Jo on how she hires
5:40 - How to write ATR Bullet Points
7:38 - Jonathan on how he hires
9:34 - Step 3 (standing out from the crowd)
13:04 - My Notion Template and how to use it
~
👍 All the best with your job search.
#resume #dataanalyst #jobsearch How to make PERFECT Data Analyst Resume for Beginners [2025]](https://i.ytimg.com/vi/bYlHkbF-IfM/mqdefault.jpg)