The Juno School is a learning platform that offers free courses in marketing, Excel, data analysis, AI tools, communication, business, and career development. Designed for working professionals and students, it helps users upskill with expert-led, short-format courses.

Is the Juno School app free to use?

Yes, the app offers access to 1000+ free courses.

How do I download the Juno School app?

You can download the Juno School app from the Google Play Store or Apple App Store by searching for “Juno School.”

What kind of Courses are available on Juno?

Juno School offers workshops on Excel, ChatGPT, marketing, sales, business development, video editing, data analysis, leadership, public speaking, SEO, automation, and more. Each workshop is practical, expert-led, and designed to be completed in under an hour.

Do I get certificates for completing workshops?

Yes. You receive a digital certificate after completing each workshop, which you can download and share on LinkedIn or with employers.

How are the workshops structured?

Each workshop typically includes a 30-60 minute video, real-world examples, downloadable resources, and a certificate on completion.

Who are the instructors on Juno School?

Juno School workshops are led by industry professionals and experts with years of experience in their respective fields, including marketing, AI, data, and sales.

Learn smart data retrieval, logical conditions, dynamic lookups & forecasting in Excel using VLOOKUP, XLOOKUP, IF, INDEX-MATCH & more.

Course Structure

Price: FREE
Duration: 60 minutes
Format: On-demand video lessons
Mode: Self-paced
Certificate: Yes, with completion

Join the Course on Juno Mobile App

25 Excel Formulas to Get You Noticed by CXOs – Hindi

Free MS Excel Courses

Learn smart data retrieval, logical conditions, dynamic lookups & forecasting in Excel using VLOOKUP, XLOOKUP, IF, INDEX-MATCH & more.

About the Course

Unlock the power of Excel and impress your CXOs! This course, delivered in Hindi, will equip you with 25 essential Excel formulas to master data retrieval, logical conditions, dynamic lookups, and forecasting. Learn to leverage VLOOKUP, XLOOKUP, IF, INDEX-MATCH, and more to become an Excel pro.

Course Structure

Price: FREE
Duration: 60 minutes
Format: On-demand video lessons
Mode: Self-paced
Certificate: Yes, with completion
Where: Available on the Juno School mobile app (Android & iOS)

What You’ll Learn

Mastered Lookup Techniques: Explore VLOOKUP, HLOOKUP, XLOOKUP, and INDEX-MATCH to perform smart, condition-based data retrieval across vertical and horizontal datasets.
Logical & Conditional Functions: Learn practical usage of IF, IFERROR, SWITCH, AND, OR to automate grading systems, validations, and logic-based outputs.
Randomized Data Generation: Get hands-on experience with RANDBETWEEN and RANDARRAY to simulate dynamic test data for dashboards, reports, and training datasets.
Data Cleaning & Formatting: Use TEXT, TEXTJOIN, SUBTOTAL, and FILTER functions for formatting, summarizing, and preparing clean datasets for dashboards.
Forecasting & Trends: Cover TREND and FORECAST functions to project future values using historical data, useful in sales, pricing, and planning analysis.
Advanced Navigation & Matching: Apply XMATCH, ROW, and COLUMN functions for dynamic referencing and precise positional lookups within large data tables.

Course Format

This course consists of on-demand video lessons, allowing you to learn at your own pace and on your own schedule. Access the course anytime, anywhere via the Juno School mobile app.

Who It’s For

This course is perfect for:

Anyone who wants to improve their Excel skills
Professionals who work with data and need to perform lookups, calculations, and analysis
Individuals who want to impress their CXOs with their Excel expertise
Anyone looking to gain a competitive edge in the job market