Excel Mastery Workshop
Unlock the full potential of MS Excel with our immersive workshop!
Interactive, Workshop
Live Classes, Experiential Learning. Rs. 99 only
JUNO SCHOOL OF BUSINESS is backed by
What will you learn?
Dive into a transformative learning experience as our MS Excel Workshop equips you with essential skills and knowledge. Here's what you can expect to gain:
01
Excel Fundamentals
- Efficient navigation through ribbons and menus.
- Utilizing the quick access toolbar for personalized efficiency.
- Formatting techniques for clear and organized data.
- Leveraging auto-fill and flash fill for rapid input.
- Understanding relative and absolute referencing.
- Creating and using named ranges for clarity.
- Basic calculations (SUM, AVERAGE, etc.).
- Application of logical functions (IF, AND, OR)
02
Advanced Formulas
- Creating complex calculations with nested functions.
- Implementing array formulas for advanced manipulation.
- Utilizing VLOOKUP and HLOOKUP for data retrieval.
- Harnessing INDEX and MATCH for flexible referencing.
- Applying statistical functions for data analysis.
- Understanding and implementing regression analysis.
- Debugging formulas and identifying errors.
- Evaluating and tracing precedents and dependents.
03
Data Visualization
- Building various chart types for effective representation.
- Customizing charts for visual clarity and impact.
- Adding data labels, annotations, trendlines, and sparklines.
- Incorporating conditional formatting for visual insights.
- Applying color scales and icon sets for visual analysis.
- Setting up conditional formatting based on cell values.
- Designing impactful dashboards for data storytelling.
- Implementing interactivity for enhanced user engagement.
04
Time-Saving Tips
- Utilizing essential shortcuts for quick navigation.
- Personalizing shortcuts for tailored workflow optimization.
- Implementing rules for accurate data entry.
- Creating drop-down lists for controlled input.
- Recording and executing macros for repetitive tasks.
- Basic understanding of VBA (Visual Basic for Applications).
- Organizing workbooks and sheets for streamlined access.
- Using templates for standardized document creation.
Some of our Mentors
Tarun Matta
founder - iimjobs.com, hirist.com (Acquired by Naukri.com) and Juno School of Business
IIM Indore and IIT (BHU), Varanasi
Sharat Dhall
COO - PolicyBazaar
ex-COO - Yatra.com
XLRI and BITS Pilani
Amandeep Kohli
Customer Success Head - Coursera for Business
IMT Ghaziabad and VIT Vellore
Premanshu Singh
SVP - Online Payments at Paytm
IIM Ahmedabad and INSEAD
Rohit Koshy
Director - EY
IIM Kozhikode and IIT Delhi
Himadri Neogi
Juno School of Business
City & Guild (UK)
JUNO Pedagogy
Our experiential learning program makes you more employable and increases the likelihood of success in you career !
EXPERIENTIAL LEARNING
Learn sales by doing! Role plays, Projects, Internships, to help you learn the art of sales.
MASTER CLASSES
Industry practitioners teach you the latest sales techniques used in the Industry.
CUTTING EDGE TOOLS
Learn on cutting edge CRM and other sales tools used in the Industry.
PLACEMENT SUPPORT
Fast track access to top employers to help you get hired as you complete the course!
Our students love us
"The best part of Sales Training with Juno School is that they let you experience Sales via case studies, discussions, assignments, projects and activities. The course is designed in a way that it not only sharpens the sales skills but also increases self confidence & gives tremendous exposure."
- Roopali Sirohi
"Sales training with Juno really taught me "Consultative Selling" skills. I feel confident about myself and my abilities to perform well. Highlight of the course for me are the assignments & tasks where I learnt so much about my own strengths & weaknesses. I now know how to probe and understand the needs of the customers."
- Sneha Dargan
"The course offered me great help in building my acumen in sales and skills required in the industry. It is designed to provide a lot of opportunities to interact and share experiences within the sessions; helping one to form a great network. Assignments encourage us to go to market to experience the real-life sales situations, and learn from those."
- Vivek Sharma
Become a Certified Excel Professional!
You can include this in your resume and Linkedin profile. This will add credibility to your candidature when you apply for jobs
FAQs
What is the duration of the workshop?
The duration of the workshop would be about two hours.
Will it be Live classes or recorded videos?
This is an interactive workshop that is delivered through a live session. The session would be about two hours.
What are the timings?
The workshop is conducted from 8-9:30pm. Please drop us a mail - hello@junoschool.org or call us @ +91 - 9205947216 to book a slot.
Do you share recordings of the sessions?
The workshop is not recorded. Please drop us a mail - hello@junoschool.org or call us @ +91 - 9205947216 if you miss the session. We will accommodate you on another day.
Will I get a certificate on completion of the workshop?
Yes, you will get a certificate on successful completion of the workshop. You may add it in your resume or Linkedin profile. It will bring credibility to your candidature when you apply for jobs.
Is there any minimum qualification for the workshop?
No, there is no minimum qualification for this workshop.
Meet our Founder
Tarun Matta is the founder of Juno School of Business. He has extensive entrepreneurial experience in the employability, education, and recruitment space. Prior to Juno School of Business, he founded iimjobs.com – an exclusive recruitment platform for management professionals in India. iimjobs.com was acquired by Naukri.com in May 2019.
Tarun holds a B.Tech degree in Computer Science & Engineering from IIT (BHU), Varanasi and an MBA from Indian Institute of Management, Indore.
Let us guide you !
Talk to our counsellor and understand our courses better.
hello@junoschool.org
+91 - 7042789220
Juno Learning Private Limited
innov8, 3rd Floor, Orchid Centre Near IILM Institute, Sector 53, next to Sector 54, Gurugram, Haryana 122022
©2022 Juno Learning Private Limited. All rights reserved.