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.

Master VLOOKUP and HLOOKUP to efficiently retrieve data, create dynamic lookups, and improve your data analysis skills.

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

Mastering Vlookup and Hlookup

Free Excel Courses

Master VLOOKUP and HLOOKUP to efficiently retrieve data, create dynamic lookups, and improve your data analysis skills.

About the Course

Master VLOOKUP and HLOOKUP to efficiently retrieve data, create dynamic lookups, and improve your data analysis skills.

What You’ll Learn

Introduction to VLOOKUP and HLOOKUP
How to find data from one dataset to another with the help of Vlookup and Hlookup?
Dynamic lookups with table references
Limitations of Vlookup

Course Format

This course consists of on-demand video lessons that you can access anytime, anywhere. Learn at your own pace and revisit lessons as needed.

Who It’s For

Data Analysts
Business Intelligence Professionals
Anyone who wants to improve their Excel skills
Students

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)

Why Take This Course

This course provides essential skills to perform precise data lookups and enhance your analytical capabilities. Proficiency in VLOOKUP and HLOOKUP enhances the ability to handle complex datasets and make informed decisions based on precise data retrieval.