Mundra is India’s largest private port, with a special economic zone, power plants and logistics parks across the Kutch coast. Port and warehouse firms look for records, electrical and planning skills.
Who hires
Port operations. Terminals and shipping agents hire clerks and planners.
Power and industry. Plants need electrical and maintenance staff.
Protect sheets and workbooks and prepare them for printing
Apply SUMIFS, COUNTIFS, nested IF, IFERROR and text and date functions
Summarise data with pivot tables, calculated fields, grouping and slicers
Project to build: Loan EMI and scenario model. Use PMT, Data Tables and Scenario Manager to compare loan options.
Tools covered: Macro recorder, Pivot tables, pivot charts and slicers, Excel Tables and named ranges, Data validation and dependent lists, Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH, INDIRECT.
Foundation level: Students, job seekers and office users who want to go from Excel basics to lookups, pivot tables, arrays, Solver and macros in 24 hours.
Secure, back up, split and move company data to a new financial year
Use cost centres, budgets, multiple currencies, interest and bank reconciliation
Apply the golden rules of accounting and double entry to real transactions
Project to build: Bank reconciliation and year-end. Reconcile the bank book and carry the company forward to the next financial year.
Tools covered: TallyPrime, Bank reconciliation, Backup, restore, import and export, TallyVault and security controls, Order processing, batches, BOM and POS.
Master level: Commerce students and accounts staff who want the complete TallyPrime foundation and advanced syllabus in 80 hours, including the newer release features.
Size cables, conduits and bus bars and select MCBs, MCCBs and fuses for a panel
Lay out panels with footprints, DIN rails, terminals and balloons
Run audits and generate BOM, wire and panel reports
Project to build: Report pack. Run audits and export the BOM, wire list and terminal report to a spreadsheet.
Tools covered: Wire numbering and signal arrows, Ladder and PLC module tools, Symbol Builder and Circuit Builder, Catalog Browser and component libraries, Connector and point-to-point wiring tools.
Professional level: Electrical students and draughtsmen who want AutoCAD Electrical plus practical panel design calculations in one 80-hour programme.
Create tabular and graphical reports and import or export schedules
Explain project management processes from initiation to closing
Build a Work Breakdown Structure and create activities
Project to build: Residential building schedule. Create the WBS, activities and relationships for a G+3 building and find the critical path.
Tools covered: Portfolios and dashboards, Resource analysis and levelling, User, EPS and OBS administration, Earned Value Analysis, Primavera P6 Professional (client).
Foundation level: Beginners who want a focused 40-hour Primavera P6 Foundation course on planning, scheduling, resources and tracking.
An MIS (management information systems) executive collects data from different departments and turns it into regular reports that managers use to run the business.
Day to day: automate repetitive reports with formulas and macros; clean and consolidate data in Excel.
Skills employers ask for: Accuracy and time management; Macros and automation basics; Pivot tables and charts.
A power system engineer studies how electricity flows through generators, transformers, cables, lines and loads, and makes sure the network is safe, reliable and efficient.
Day to day: run load flow and short-circuit studies; prepare study reports for clients and site teams.
Skills employers ask for: Power system fundamentals (per-unit, faults, load flow); MATLAB and Simulink modelling; Renewable energy integration basics.
An office administrator keeps the day-to-day work of an office running: handling documents, maintaining records, scheduling meetings, managing correspondence, coordinating with vendors and supporting managers.
Day to day: type and format letters, reports and documents in Word; enter and verify data in Excel and office software.
Skills employers ask for: Communication and phone etiquette; MS Excel data entry and basic formulas; Email and internet skills.
Where careers start: Data Entry Operator / Office Assistant.
Which course should I start with in Mundra and Kutch?
Mundra is India’s largest private port, with a special economic zone, power plants and logistics parks across the Kutch coast. A sensible order is Advanced Excel first, then Tally Prime once you are comfortable.
Is online or hybrid learning available?
Yes. Classroom, online and hybrid modes are available depending on trainer availability at your chosen centre.
How long is each Primavera level?
Certificate in Primavera Project Management is 40 hours. Proficient in Primavera with PPM Concepts and Advanced Certificate in Project Planning Management using Primavera are 64 hours each. Advanced Certificate in Enterprise Project Planning using Primavera is 80 hours, and Professional in Project Planning Management using Primavera is 104 hours.
Can I learn online from Mundra and Kutch?
Yes, from home. Classes are live with a trainer, recorded practice files are shared after each session, and the certificate is the same whether you learn online or in a classroom.
