Pantnagar and Rudrapur in the Kumaon foothills host auto, FMCG and electronics plants under the SIDCUL scheme. Many workers come from nearby hill districts.
Who hires
Auto and FMCG. Plants hire technicians and quality staff.
Draw accurately using coordinates, snaps, grid, polar tracking and dynamic input
Add dimensions, leaders, text and tables using proper styles
Draw isometric, sectional and detail views
Project to build: Block library with attributes. Build a set of symbols with attributes and extract a bill of materials.
Tools covered: Blocks, dynamic blocks and attributes, 3D solid and surface modelling, AutoLISP and Visual LISP, Dimension, text, table and leader styles, Parametric geometric and dimensional constraints.
Professional level: Learners who want a complete 80-hour course covering 2D drafting, dynamic blocks, parametric constraints, xrefs, express tools, 3D modelling and AutoLISP.
Look up data with VLOOKUP, XLOOKUP, INDEX-MATCH and INDIRECT
Apply SUMIFS, COUNTIFS, nested IF, IFERROR and text and date functions
Model decisions with Goal Seek, Data Tables, Scenario Manager and Solver
Project to build: Sales dashboard with pivots. Summarise a year of sales by region, product and month with pivot tables, charts and slicers.
Tools covered: Data validation and dependent lists, Microsoft Excel (Microsoft 365 / Office), Goal Seek, Data Tables, Scenario Manager, Macro recorder, Excel Tables and named ranges.
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.
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: build daily, weekly and monthly reports; create pivot tables, charts and dashboards.
Skills employers ask for: Data cleaning and validation; Advanced Excel formulas and functions; VLOOKUP, XLOOKUP and INDEX-MATCH.
Which course should I start with in Pantnagar and Rudrapur?
Pantnagar and Rudrapur in the Kumaon foothills host auto, FMCG and electronics plants under the SIDCUL scheme. A sensible order is PLC & SCADA first, then Basic Electrical (Executive Diploma) once you are comfortable.
Can I take the Basic Electrical course online or in hybrid mode?
Yes. Basic Electrical training is offered in classroom, online or hybrid mode, depending on trainer availability at your chosen centre. The counsellor will confirm which batches and modes are open when you enquire.
Which level should I choose?
Choose Essential for solid 2D drafting skills. Choose Proficient if you also want dynamic blocks, parametric constraints, xrefs, express tools, 3D modelling and AutoLISP.
Can I learn online from Pantnagar and Rudrapur?
You can. Every course is available as a live online class, and learners in Pantnagar and Rudrapur who want lab time can add an occasional visit to one of the centres in Tamil Nadu.
