INTERNSHIP DETAILS

Advance Excel Intern

CompanyTraining Basket
LocationNoida
Work ModeOn Site
PostedMarch 21, 2026
Internship Information
Core Responsibilities
The intern will analyze large datasets utilizing advanced Excel functions and tools to create dynamic dashboards and reports that provide business insights. Responsibilities also include generating weekly/monthly performance reports and collaborating with the team to understand reporting requirements.
Internship Type
full time
Company Size
101
Visa Sponsorship
No
Language
English
Working Hours
40 hours
Apply Now →

You'll be redirected to
the company's application page

About The Company
Training Basket doing business as Blogic Software Technology Private Limited commonly used as brand name offers advanced IT training & certifications to individuals and organizations in technologies in Cisco, Redhat, AWS, Azure, Cisco, Software Programming Languages and Web Technologies. We're the fastest growing IT training provider in India with the widest range of IT courses under one roof. Training Basket has 40+ certificate course training including that of Microsoft, Cisco, Oracle,VMware, Red Hat Official, Amazon Web Services (AWS), EC Council, Java among others. We make sure that all our students are made aware of the latest technology trends and that when they go out in the job market, they are the top most qualified candidates for the position. We aim to bridge the gap between the corporates seeking out for the students and students who are looking for a satisfactory job and thus for a win-win situation for all the people. In association with "Times of India"​ and "Red Hat Authorized Training Partner"​ we are aiming to give one-stop provider of high end training services to various individuals and enterprise. At TrainingBasket, we take proud in ourself for maintaining our position in the whole educational ecosystem as the top quality training provider in “specialized technologies” and thus being able to get the best placement package available for our students in blue chip companies though our placement portal Job Basket. Training Basket Noida only teaches the students, but also take corporate workshops and conducts various teaching programmes to promote the build up of adequate and devoted professionals for practice and cultivation which thus develops and distributes knowledge and grasp out to the larger association through continuation, at the national, provincial and international levels. Training Basket perceive and value the unlikeness, assortment, and morality of every individual
About the Role
Analyze large datasets using advanced Excel functions and tools
Create dynamic dashboards and reports for business insights
Use formulas such as VLOOKUP, HLOOKUP, INDEX-MATCH, IF, SUMIFS, COUNTIFS
Work with Pivot Tables, Pivot Charts, and Data Validation
Automate repetitive tasks using Macros/VBA (preferred)
Clean, organize, and validate data for accuracy
Collaborate with team members to understand reporting needs
Generate weekly/monthly performance reports

Requirements

Strong proficiency in Microsoft Excel (Advanced level)
Good understanding of data analysis and reporting
Familiarity with Excel functions, charts, and dashboards
Basic knowledge of VBA/Macros is a plus
Strong attention to detail and problem-solving skills
Ability to work with large datasets efficiently



Key Skills
Advanced ExcelData AnalysisDashboard CreationReportingVLOOKUPINDEX-MATCHPivot TablesPivot ChartsData ValidationMacrosVBAData CleaningProblem-Solving
Categories
Data & AnalyticsFinance & Accounting