Orientation
Set-up, goals and a quick check of what you already know about data cleaning in excel.
A focused 20–104 hours Excel for Data Engineering internship with a hands-on mini-project, delivered by CADD Centre at all three CareerKraft centres. Best suited to Engineering and management students.
01What you will cover
Turn raw engineering or production data into an automated Excel report.
02Inside the course
Microsoft Excel is the spreadsheet program in Microsoft 365 and Office. Most people know how to type data and add a column, but Advanced Excel is about the features that do real work: conditional and array formulas, VLOOKUP, XLOOKUP and INDEX-MATCH, data validation lists, pivot tables and charts, Goal Seek, Scenario Manager and Solver, and macros that record repeated steps.
Working through Advanced Excel, you will learn to use absolute, relative and mixed references correctly in formulas, apply SUMIFS, COUNTIFS, nested IF, IFERROR and text and date functions and look up data with VLOOKUP, XLOOKUP, INDEX-MATCH and INDIRECT.
You will work with Microsoft Excel (Microsoft 365 / Office), Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH, INDIRECT and Pivot tables, pivot charts and slicers; the Certificate in Advanced Excel programme includes modules such as Excel Introduction and Customisation, Basic Functions and Referencing and Formatting and Protection.
Roles to aim for include MIS Executive – prepares daily and monthly reports for management and Data Entry / Back-Office Executive – maintains accurate records and summaries in Excel. You should be able to use a computer and open, type into and save an Excel file. The Certificate course starts with a refresher of basics, so you do not need to be an everyday Excel user to join.
03How it runs
Set-up, goals and a quick check of what you already know about data cleaning in excel.
Short sessions on lookup and logical functions and pivot tables and charts, each followed by hands-on lab exercises.
Build your project step by step with trainer reviews.
Present your work, get feedback and receive your completion certificate.
Placements

Knitwear Designer & Quality Checker
SGS India Pvt. Ltd, Bengaluru

Design Engineer, Assistant Engineer - Design
Hirise Drafting and Consulting Pvt. Ltd, Eversendai Construction Pvt. Ltd (ECPL), Chennai

CNC Lathe Programmer
Propel Valve Pvt. Ltd

Design Engineer
New Auto Tech Pvt. Ltd
05FAQ
Still have a question? The counsellor at the centre you prefer replies on WhatsApp.
Ask on WhatsAppThe Excel for Data Engineering internship runs for 20–104 hours, depending on the track you choose. Weekday, weekend and fast-track batches are available.
It is best suited to Engineering and management students. A counsellor can check your background in a quick call or WhatsApp chat.
Yes – you receive an internship completion certificate after completing the programme and the project review.
It is a fee-based internship course you can take while still studying, with a mini-project and certificate. It is not a job and does not include a stipend. Graduates who have completed their degree can apply for a stipend-based internship with CareerKraft on our Work with us page.
It covers conditional and lookup formulas, data validation, Excel Tables, pivot tables and charts, what-if analysis, protection and macros, including how to record, run and manage them.
Anyone who can use a computer and basic Excel can join – students, freshers, office staff and professionals. No commerce or programming background is needed.
At CareerKraft Katpadi (Near Aascars Cinemas), Vellore (Near Raja Theatre) or Ranipet (Near SBI, Muthukadai) – in classroom, online or hybrid mode.
04More internships
Run a structural and thermal simulation of a component and present the results.
View internship CADD CentreModel and assemble a mechanical product with full drawings and BOM.
View internship CADD CentreDesign an automotive or aerospace component with surfaces, assembly and drawings.
View internship CADD CentreCreate a parametric product family with assembly and drawings.
View internshipStart today
WhatsApp opens with your details, addressed to the brand and centre you choose. The counsellor replies with the fee and next batch date.
Free counselling
Every course runs at all three centres.
Free
Tell us your name and we'll send the complete syllabus, fee and next batch date for your course.