Refinery and oil-sector contractors
Piping, electrical and instrumentation roles.
Learn Online from Guwahati – Northeast Gateway Skills for Oil, Tea & IT
Guwahati is the Northeast’s commercial gateway, with a refinery, the tea auction trade, IIT Guwahati and a growing service sector.
Guwahati · AssamLive online · Hybrid · Classroom+91 8111 029 125
01Guwahati
Guwahati gateway to the Northeast
The city’s refinery, tea auction centre, port-and-rail trade links and IIT Guwahati create a mix of industrial, trading and research employers. The wider Northeast depends on Guwahati for supply, services and education, so firms here hire for logistics, accounts and IT support.
Distance from southern India makes online delivery the only practical format, and evening batches fit around work in the city.
Where the jobs are
Tea trading and warehousing
Accounts, stock and logistics reporting.
IIT Guwahati and the services sector
Software, data and support roles.
02Courses that fit
What to learn for Guwahati
PDMS (Piping Design)
Piping design for refinery contractors.
40 hElectrical CAD (AutoCAD Electrical)
Panel and cable drawings.
64–80 hTally Prime
Tea trade and warehouse accounts.
80–110 hAdvanced Excel
Stock and logistics reporting.
24 hPython
Entry skill for software and data roles.
50–120 hSoftware Testing (Selenium)
A first job in IT services.
80 hTake the same courses live online
03Joining from Guwahati
How learning works
Guwahati learners study live online.
Where we teach: classroom batches run at our Katpadi, Vellore and Ranipet centres in Tamil Nadu; learners elsewhere join live online or hybrid batches.
06Compare
Four courses, side by side
| Course | Hours | Who it suits | First project |
|---|---|---|---|
| PDMS (Piping Design) | 40 h | Mechanical and chemical engineers, diploma holders and piping draughtsmen who want to start 3D plant piping design. | Clash-free unit area |
| Electrical CAD (AutoCAD Electrical) | 64–80 h | Beginners who need AutoCAD drafting basics first and then full AutoCAD Electrical schematic, PLC and panel work in 64 hours. | Panel sizing from an SLD |
| Tally Prime | 80–110 h | Students and job seekers who want a full 80-hour grounding in accounting, inventory, GST, TDS and payroll in TallyPrime. | Bank reconciliation and year-end |
| Advanced Excel | 24 h | Students, job seekers and office users who want to go from Excel basics to lookups, pivot tables, arrays, Solver and macros in 24 hours. | Invoice template with drop-downs |
07Study plan
Your first 36 weeks from Guwahati
At around seven hours a week, alongside college or work. Faster or slower is fine; finish each project before moving on.
- Weeks 1–6: PDMS (Piping Design) (40 h)
- Weeks 7–17: Electrical CAD (AutoCAD Electrical) (64–80 h)
- Weeks 18–33: Tally Prime (80–110 h)
- Weeks 34–36: Advanced Excel (24 h)
04Your learning path
From Guwahati, step by step
PDMS (Piping Design) 40 h
You will learn to
- Generate isometrics, spool drawings, nozzle and line schedules and pipe MTO reports
- Position, edit and align equipment using PDMS positioning and model editor tools
- Create pipes and branches, add components and set specifications and bores
Project to build: Isometrics, spools and MTO. Generate pipe isometrics, break them into spools and produce pipe and tube MTO reports.
Tools covered: Clash and data consistency checks, Report and MTO generation, Equipment application and parametric equipment, Spooler, Design Explorer.
Foundation level: Mechanical and chemical engineers, diploma holders and piping draughtsmen who want to start 3D plant piping design.
Electrical CAD (AutoCAD Electrical) 64–80 h
You will learn to
- Create and manage AutoCAD Electrical projects and drawings
- Build custom symbols and reusable circuits with Symbol Builder and Circuit Builder
- Run audits and generate BOM, wire and panel reports
Project to build: Control panel layout. Create the panel GA with footprints, DIN rails, terminals and balloons linked to the schematic.
Tools covered: Connector and point-to-point wiring tools, Symbol Builder and Circuit Builder, Schematic and panel reports, BOM export to spreadsheet, Wire numbering and signal arrows, Bus bar, conduit and wire size calculations.
Foundation level: Beginners who need AutoCAD drafting basics first and then full AutoCAD Electrical schematic, PLC and panel work in 64 hours.
Tally Prime 80–110 h
You will learn to
- Create a company, ledgers, groups and inventory masters in TallyPrime
- Use cost centres, budgets, multiple currencies, interest and bank reconciliation
- Secure, back up, split and move company data to a new financial year
Project to build: Bank reconciliation and year-end. Reconcile the bank book and carry the company forward to the next financial year.
Tools covered: GST configuration and reports, Bank reconciliation, Migration from Tally.ERP 9, Cost centres, budgets and scenarios, TDS and Challan 281.
Professional level: Students and job seekers who want a full 80-hour grounding in accounting, inventory, GST, TDS and payroll in TallyPrime.
Advanced Excel 24 h
You will learn to
- Record, run and manage macros to automate repeated tasks
- Protect sheets and workbooks and prepare them for printing
- 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: Solver add-in, Array formulas, Pivot tables, pivot charts and slicers, Microsoft Excel (Microsoft 365 / Office), 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.
05Careers
Roles that fit work around Guwahati
Office Administrator / Data Entry
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: coordinate office supplies, vendors and visitors; maintain physical and digital files and records.
Skills employers ask for: MS Excel data entry and basic formulas; MS Word document formatting; MS PowerPoint presentations.
Where careers start: Data Entry Operator / Office Assistant.
MIS Executive
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: create pivot tables, charts and dashboards; automate repetitive reports with formulas and macros.
Skills employers ask for: VLOOKUP, XLOOKUP and INDEX-MATCH; Pivot tables and charts; Accuracy and time management.
Where careers start: MIS Assistant.
SAP FICO Consultant
An SAP FICO consultant sets up and supports the finance side of SAP, the ERP system used by many large companies.
Day to day: test configurations and support users during go-live; set up accounts payable, receivable and asset accounting.
Skills employers ask for: Accounting and finance fundamentals; Asset accounting; Bank accounting and reconciliation.
Where careers start: SAP End User / Trainee.
Guides worth reading
Tally Prime and GST: Building an Accounting Career in India
TallyPrime and GST knowledge open steady accounts jobs in almost every town. Here is what the work involves, which skills matter and how to grow from there.
Business & Management · 8 min readAutoCAD vs SolidWorks: Which Should You Learn First?
AutoCAD and SolidWorks solve different problems. Here is how to pick the right starting point for your branch, your target job and your time.
Design & Engineering · 8 min readPrimavera vs MS Project: Which Planning Tool Should You Learn?
Both tools build schedules, track progress and manage resources, but they suit different projects and employers. Here is how to choose the right one first.
Business & Management · 8 min readNot sure what to pick for Guwahati?
Tell a counsellor your background and goal. You get the right course, the syllabus, the next batch and a free demo class.
08FAQ
Guwahati – FAQ
Still have a question? Message us on WhatsApp.
Ask on WhatsAppWhich course supports oil-sector contracting?
PDMS and electrical CAD are the common choices.
Can I attend from outside the city?
Yes. Anyone in the Northeast with a stable connection can join.
Which course should I start with in Guwahati?
The city’s refinery, tea auction centre, port-and-rail trade links and IIT Guwahati create a mix of industrial, trading and research employers. A sensible order is PDMS (Piping Design) first, then Electrical CAD (AutoCAD Electrical) once you are comfortable.
What does an Advanced Excel course cover?
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.
Is placement support available?
Yes. We help with resumes, mock interviews and job leads. A job is not guaranteed.
Can I learn online from Guwahati?
You can. Every course is available as a live online class, and learners in Guwahati who want lab time can add an occasional visit to one of the centres in Tamil Nadu.
09Explore more
Everything you can do from Guwahati
Courses
Careers and internships
Trust and results
Tools and help
More places
Also see
Start your course
Ask about courses from Guwahati
Tell us your city, course and preferred time. We reply on WhatsApp.
- Live online, hybrid or classroom at Katpadi, Vellore or Ranipet
- Batches to suit your college or work timings
- Free counselling and a syllabus on WhatsApp
- One number for everything: +91 8111 029 125