Construction and infrastructure firms
Planners and BIM teams use Revit, Primavera and MS Project every day.
Courses in Mylapore – online, hybrid or classroom
Working professionals can add Excel, Power BI or design skills in evening online batches.
Mylapore · Chennai districtOnline · HybridClassroom: Katpadi · Vellore · Ranipet
DistrictChennai
Taluks in district17
Start withAdvanced Excel
Ways to studyOnline · Hybrid · Classroom
Classroom centresKatpadi · Vellore · Ranipet
WhatsApp repliesMon–Sat 9:30–6:30, Sun 9–2 IST
02Mylapore
Learning from Mylapore
Mylapore is Chennai’s old cultural district around the Kapaleeshwarar temple and the Marina, with professional offices, schools and colleges.
Working professionals can add Excel, Power BI or design skills in evening online batches.
How learners from Mylapore study: classroom batches run at Katpadi, Vellore and Ranipet; everyone else joins live online or hybrid batches with the same syllabus, projects and certificate.
01Local jobs
Who hires around Chennai district
Chennai is the largest job market within reach of Vellore, roughly two to three hours away along the Chennai–Bengaluru corridor with Katpadi Junction on the main rail line. The software belt along Old Mahabalipuram Road and the parks at Siruseri and Taramani sit beside the engineering estates of Guindy and Ambattur, the auto-component plants to the south and west, and a steady flow of building and infrastructure projects around the city.
Finance and shared-services centres
Accounts and reporting roles ask for Tally, GST and advanced Excel.
06Compare
Four courses, side by side
| Course | Hours | Who it suits | First project |
|---|---|---|---|
| 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. | One-click report macro |
| 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. | Sales performance dashboard |
| UI/UX Design | 80 h | Beginners and graduates who want a complete path from user research to finished, testable UI designs and a portfolio. | Persona and journey map pack |
| Digital Marketing | 60–320 h | Beginners who want a 60-hour foundation in websites, SEO, Google Ads, social media, email and freelancing. | Business website on WordPress |
07Study plan
Your first 69 weeks from Mylapore
At around seven hours a week, alongside college or work. Faster or slower is fine; finish each project before moving on.
- Weeks 1–3: Advanced Excel (24 h)
- Weeks 4–12: Power BI (30–60 h)
- Weeks 13–23: UI/UX Design (80 h)
- Weeks 24–69: Digital Marketing (60–320 h)
Not sure what to pick for Mylapore?
Tell a counsellor your background and goal. You get the right course, the syllabus, the next batch and a free demo class.
03Your learning path
From Mylapore, step by step
Advanced Excel 24 h
You will learn to
- Look up data with VLOOKUP, XLOOKUP, INDEX-MATCH and INDIRECT
- Model decisions with Goal Seek, Data Tables, Scenario Manager and Solver
- Summarise data with pivot tables, calculated fields, grouping and slicers
Project to build: One-click report macro. Record a macro that cleans, formats and prints a daily report.
Tools covered: Goal Seek, Data Tables, Scenario Manager, Microsoft Excel (Microsoft 365 / Office), Pivot tables, pivot charts and slicers, Macro recorder, Solver add-in.
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.
Power BI 30–60 h
You will learn to
- Build a data model with correct relationships, cardinality and filter flow
- Use AI visuals such as Q&A, Key Influencers and the Decomposition Tree
- Publish, share and schedule refresh of reports in the Power BI Service
Project to build: Sales performance dashboard. Model orders, products and regions, then track revenue, top products and month-on-month growth with DAX measures.
Tools covered: DAX (Data Analysis Expressions), Power BI Service (publishing, sharing, dashboards), Power BI Desktop, M Language, Bookmarks, buttons and page navigation.
Foundation level: Beginners and graduates who want a hands-on, 60-hour, day-by-day route from first chart to Power Query cleaning, M language and a finished project.
UI/UX Design 80 h
You will learn to
- Apply colour theory, typography, layout, iconography and Google Material Design to UI screens
- Plan a UX project using design thinking and user-centred design principles
- Run usability tests, analyse feedback and present a finished portfolio and project report
Project to build: Redesign of a local service app. Interview users of a food-order, bus-ticket or clinic-booking flow, find pain points and propose a cleaner journey.
Tools covered: HTML5, CSS3, JavaScript, jQuery and Bootstrap, Design thinking and user-centred design process, Google Analytics for user behaviour insights, Interactive prototypes for web, mobile and tablet, Low-fidelity and high-fidelity wireframes.
Foundation level: Beginners and graduates who want a complete path from user research to finished, testable UI designs and a portfolio.
Digital Marketing 60–320 h
You will learn to
- Plan, launch and optimise Google search, display, video and remarketing campaigns
- Set up a WordPress website with domain, hosting, plugins and SEO basics
- Run Facebook and Instagram campaigns with Business Manager, Pixel and custom audiences
Project to build: Google Business Profile makeover. Optimise a listing with posts, products, photos and a review link to improve local visibility.
Tools covered: Canva, Google Business Profile (Google My Business), Keyword research tools, Google Ads, WordPress.
Professional level: Learners who want the 156-hour Professional programme with an added digital marketing simulation to practise campaign decisions.
04Careers
Roles that fit work around Mylapore
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: manage emails, calls and appointments; coordinate office supplies, vendors and visitors.
Skills employers ask for: Time management; Email and internet skills; MS PowerPoint presentations.
Where careers start: Data Entry Operator / Office Assistant.
Planning Engineer / Project Planner
A planning engineer, also called a project planner, builds and maintains the schedule that tells everyone what must happen, in what order and by when.
Day to day: analyse delays and support extension-of-time claims; update weekly progress and analyse the critical path.
Skills employers ask for: Communication with site and management teams; MS Project scheduling; Critical path method and float analysis.
Where careers start: Junior Planning Engineer.
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: understand finance processes and gather requirements; set up accounts payable, receivable and asset accounting.
Skills employers ask for: Documentation and user training; Controlling basics (cost and profit centres); GST and tax configuration awareness.
Where careers start: SAP End User / Trainee.
Guides worth reading
How to Become a Data Analyst: A Step-by-Step Roadmap for Freshers
Data analyst roles are open to graduates from almost any stream. Here is the skill order, the tools and the projects that help you get your first job.
Career guidance · 8 min readHow to Build a Design Portfolio That Gets You Interviews
A practical guide to building a design portfolio for CAD, BIM, interior, product and UI/UX roles, even if you have never worked on a paid project.
Design & Engineering · 9 min readWhat to Put in a Fresher Portfolio for CAD, IT and Accounts Jobs
A certificate shows you attended; a portfolio shows you can do the work. Here is what to include for CAD, IT and accounts roles and how to present it.
Career guidance · 5 min read05FAQ
Mylapore – FAQ
Still have a question? Message us on WhatsApp.
Ask on WhatsAppWhich course should I start with in Mylapore?
Working professionals can add Excel, Power BI or design skills in evening online batches. A sensible order is Advanced Excel first, then Power BI once you are comfortable.
Do I need my own laptop?
Not for classroom batches, as the centre has lab systems. A Windows laptop is useful for practice and needed for online classes, because Power BI Desktop runs on Windows.
Can I take the course online or in hybrid mode?
Classroom, online and hybrid modes are offered, depending on trainer availability for your batch. Tell the counsellor your preference when you enquire.
Can I learn online from Mylapore?
Yes. CareerKraft runs live, trainer-led online and hybrid batches with the same syllabus, projects and certificate as classroom batches, so learners in Mylapore do not have to relocate.
08Explore more