skip to Main Content
Basics of MS Excel

The Basics of MS Excel course offered by KAGR is a comprehensive program designed to equip individuals with essential skills and knowledge in Microsoft Excel. This course provides a solid foundation for Excel proficiency. Through practical case studies and hands-on exercises, participants will gain the expertise to efficiently analyze data, build dynamic dashboards, perform complex calculations, and tackle real-life consulting and analytics scenarios with confidence.

9 Hours

Recorded

In case any participant wants to claim GST credit, kindly email us a copy of your GST Certificate on info@kagr.club and we shall send the GST invoice to you.

Excel's Universal Relevance

In the modern job market, Excel proficiency is more than just a skill; it’s a fundamental requirement across diverse professions, including finance, marketing, and beyond.

Empowering Careers with Basic Excel

This course provides essential training in Microsoft Excel basics, covering spreadsheet management, data organization, and basic analysis. Perfect for those aiming for roles in administration, finance, or data entry.

Explore Limitless Career Possibilities

Boost your Excel expertise to open doors to diverse career paths in sectors like Finance, Marketing, and Administration.

How Will This Course Help?
Excel Profeciency

Enhance your Excel skills and become proficient in basic data analysis techniques.

Efficiency Boost

Boost your productivity in Excel by streamlining your workflow and mastering essential functions and tools.

Visualize Impact

Improve your data visualization skills and create impactful charts and graphs.

Certification Advantage

Gain a competitive edge in the job market with a recognized certification in Basic Excel.

Meet your Mentor!

Chinmay is working as an associate at a big4 firm in the valuation, modelling and economics practice. He is a commerce graduate from Mumbai University and has close to 4+ years of work experience across Investment Banking, Financial Due Diligence and Asset Management.

He is a content creator on LinkedIn with 35K+ followers. He has trained 6K+ participants including international students and has been a guest speaker on Analytics & Corporate Finance using MS Excel at top-tier institutes like EY, IIM-A, IIM-B, IIM-L, IIM-T, IIM-K, ISB Hyderabad, IIT – Guhawati, National Forensic Sciences university, various colleges at Mumbai University and Delhi University etc.

What Will You Learn?

Develop Basic Excel Skills

Gain a comprehensive understanding of basic Excel functions, formulas, and features, enabling you to efficiently manage and analyze data.

Increase Productivity  

Discover simple yet effective methods to enhance your productivity while working with data sets in Excel.
Master time-saving techniques and basic functions to streamline your workflow.

  Creative Interactive Dashboards

Acquire the skills to build dynamic and interactive dashboards that present data visually and facilitate effective decision-making.

Who Should Attend?

Students

Students looking to gain knowledge and enhance their skill set or any student pursuing some professional course and seeking internship.

Working Professional

Anyone eager to stay competitive in today’s rapidly evolving job market by continuously learning and adapting or anyone interested in exploring a new field or hobby to broaden their horizons.

Course Content

1. 100+ Keyboard shortcuts for speed & efficiency

2. Data Visualisation & how to automatically update chart using Excel Tables

3. EMI Computation in Excel for your new Iphone & target repayment with Goal Seek

4. The powerful & (Ampersand Operator) and LEN function

5. How to efficiently Sort, Filter data sets in excel

6. IF, AND, OR, AVERAGE, COUNTIF, SUMIF, MIN, MAX, LEFT, RIGHT, UNIQUE and 20+ important functions

7. Find & Replace Hacks

1. Understanding relative & absolute cell referencing in Excel and the new way to spill formulas using Dynamic Arrays based on matrix multiplication

2. Concept of Date in Excel.

3. VLOOKUP & how to be a better analyst by adding notes & comments by know knitty – gritty of Excel

4. Special Dialogue Box

5. Named Ranges & Formula Auditing Tools (Trace Precedents & Evaluate Formula)

6. Data Validation Lists

1. Leveraging the Machine Learning Algorithm in Excel (Flash Fill)

2. Using Pivot Tables to Analyse the workforce (organisational structure)

3. Dynamic Arrays with the new concept of Spill & #

4. Using Paste Special Dialogue Box to solve Lookup problem

5. Approximate lookups using the New XLOOKUP functions

6. Data Cleaning using =SUBSTITUTE() function

1. Web Scraping Data using Power Query

2. Understanding basics of VBA Macros (Theory) and activating developer tab

3. Basics of one drive/SharePoint

4. Theory on History of Excel and the versions

5. Theory on Financial Modeling

1. Take-Home case studies to real life consulting & analytics situation (Group Task for presentation)

2. Dynamically rank NIFTY 50 stocks based on sector & any 1 additional metrics/KPI

3. Dashboard Building

4. Perform 2D Lookups using the SUMPRODUCT functions

StudentsTestimonials
What our students' say:
Get Certified
Yes! You will be certified for this workshop on submission of your assignment.

Official And Verified

Receive an instructor signed certificate with institution’s logo to verify your achievements and increase your job prospects.

Easily Shareable

Add the certificate to your CV or your Resume or post it directly on LinkedIn. You can even post it on instagram and twitter.

FAQs
Questions generally asked about the course

You can contact KAGR by email at info@kagr.com or by phone at +91- 9137979582. KAGR’s customer support team will be available 24/7 to assist you.

We believe in the value our course offers, but we also understand the importance of satisfaction. We do have a refund policy in place. However, terms and conditions apply. We recommend reaching out to our support team for detailed information.

Yes, upon successfully completing the Basic Excel Course, you will receive a certificate that can be a valuable addition to your professional portfolio, showcasing your skills in basic level Excel.

Absolutely! The course covers basic excel functions and its use cases hence you don’t need to have prior knowledge of the same.

Rs. 499, inclusive of GST.

In case any participant wants to claim GST credit, kindly email us a copy of your GST Certificate on info@kagr.club and we shall send the GST invoice to you.