Diamond mines and contractors
Electrical and instrumentation maintenance planning at diamond mines.
Botswana’s diamond mines, Gaborone’s services sector and public-works programme hire technical and finance staff. India is three and a half hours ahead.
01Botswana
Diamond mining at Jwaneng and Orapa is the economic backbone, Gaborone’s banks, insurers and government offices form the services side, and a steady public-works programme supports civil and electrical contractors.
Botswana is three and a half hours behind India, so late-afternoon Indian classes suit evening study.
At Botswana’s mines, electrical CAD with PLC and SCADA covers drawing and maintenance, and Gaborone office staff would rather begin with Advanced Excel and Power BI.
Electrical and instrumentation maintenance planning at diamond mines.
Reporting, accounts and data roles.
Civil drafting and scheduling.
02Courses that fit
Plant automation upkeep at mines.
44–64 hPanel and cable drawings for mine and utility work.
64–80 hDashboards for bank and office reporting.
30–60 hReconciliation and reporting.
24 hRoads and drainage for public works.
40–80 hScheduling for civil packages.
40–104 h03Joining from Botswana
Learners in Botswana study live online; Botswana is about three and a half hours behind India.
06Compare
| Course | Hours | Who it suits | First project |
|---|---|---|---|
| PLC & SCADA | 44–64 h | Beginners in automation who want a 44-hour course on Mitsubishi FX PLCs with GX Works2 and Wonderware InTouch SCADA. | Conveyor sorting |
| 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. | Report pack |
| Power BI | 30–60 h | Working professionals and Excel users who want a focused 30-hour course on Power Query, data modelling, DAX and report design. | Monthly MIS from multiple files |
| 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
At around seven hours a week, alongside college or work. Faster or slower is fine; finish each project before moving on.
04Your learning path
You will learn to
Project to build: Alarm and trend dashboard. Set analog and discrete alarms, log them and show real-time and historical trends exported to Excel.
Tools covered: Omron CX-Supervisor and CX-Simulator, Omron CX-Programmer (CP1E), Siemens TIA Portal (S7-1200), Siemens WinCC, Mitsubishi GX Works2 (FX series).
Foundation level: Learners who want a 64-hour Siemens-focused course with STEP 7, TIA Portal (S7-1200), FBD and WinCC SCADA.
You will learn to
Project to build: PLC I/O wiring set. Insert PLC modules, connect field devices and number the I/O wires.
Tools covered: Schematic and panel reports, BOM export to spreadsheet, Catalog Browser and component libraries, Bus bar, conduit and wire size calculations, AutoCAD Electrical Project Manager, Symbol Builder and Circuit Builder.
Foundation level: Beginners who need AutoCAD drafting basics first and then full AutoCAD Electrical schematic, PLC and panel work in 64 hours.
You will learn to
Project to build: Monthly MIS from multiple files. Append a folder of monthly Excel or CSV files in Power Query so next month's report updates with one refresh.
Tools covered: Excel Macros and VBA (Advanced Certificate level), Scheduled refresh, AI visuals: Q&A, Key Influencers, Decomposition Tree, M Language, Custom visuals.
Master level: Learners who want both tools in one 54-hour programme: 24 hours of Advanced Excel with Macros and VBA, then 30 hours of Power BI.
You will learn to
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: Array formulas, Microsoft Excel (Microsoft 365 / Office), Solver add-in, Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH, INDIRECT, Pivot tables, pivot charts and slicers.
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
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: maintain physical and digital files and records; type and format letters, reports and documents in Word.
Skills employers ask for: Time management; Email and internet skills; File and record management.
Where careers start: Data Entry Operator / Office Assistant.
An SAP FICO consultant sets up and supports the finance side of SAP, the ERP system used by many large companies.
Day to day: understand finance processes and gather requirements; support month-end and year-end closing activities.
Skills employers ask for: Accounting and finance fundamentals; Bank accounting and reconciliation; GST and tax configuration awareness.
Where careers start: SAP End User / Trainee.
A quantity surveyor measures the materials and work in a construction project and turns them into costs, bills of quantities, contractor bills and cost reports.
Day to day: prepare bills of quantities and cost estimates; link model elements with cost data for 5D analysis.
Skills employers ask for: Bill of quantities preparation; Advanced Excel for costing; Navisworks quantification and 5D workflows.
Where careers start: Junior QS / Billing Engineer.
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 readFrom accounts and HR to engineering and sales, Excel shows up in almost every job. Here are the skills that matter most and how to build them step by step.
Career guidance · 8 min readYou do not need a big city to learn job-ready software. Here is the setup, the weekly routine and the support habits that make online classes work.
Career guidance · 5 min readTell a counsellor your background and goal. You get the right course, the syllabus, the next batch and a free demo class.
08FAQ
Still have a question? Message us on WhatsApp.
Ask on WhatsAppPLC and SCADA with electrical CAD is the usual pairing.
Advanced Excel with Power BI covers most reporting needs.
Diamond mining at Jwaneng and Orapa is the economic backbone, Gaborone’s banks, insurers and government offices form the services side, and a steady public-work A sensible order is PLC & SCADA first, then Electrical CAD (AutoCAD Electrical) once you are comfortable.
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.
If you already know Excel well, the 30-hour Certificate is the quickest route. If your Excel is basic, the 54-hour Advanced Certificate covers Advanced Excel and VBA first. The 60-hour course suits learners who want more practice with chart types, Power Query and M language.
Yes. CareerKraft runs live, trainer-led online and hybrid batches with the same syllabus, projects and certificate as classroom batches, so learners in Botswana do not have to relocate.
09Explore more
Start from anywhere
Tell us your city, course and preferred time. We reply on WhatsApp.