GIFT City near Gandhinagar is India’s first international financial services centre, alongside government offices and IT firms. Finance and data skills are in demand.
Who hires
Finance and fintech. Firms hire analysts and reporting staff.
IT and services. Companies hire testers and developers.
Government and education. Offices need strong office and data skills.
Connect to files with live and extract connections and use the Excel interpreter
Combine data sources with joins, blends and unions and create sets
Apply forecasting and clustering in Tableau
Project to build: District-wise map analysis. Plot data on a map of Tamil Nadu districts and customise colours and filters to show patterns.
Tools covered: Excel interpreter, Tableau forecasting and clustering, Tableau Desktop, Live and extract connections, Table calculations and LOD expressions.
Foundation level: Graduates and professionals who want a practical 40-hour course on data preparation, visualisation and dashboards using Tableau.
Use AI visuals such as Q&A, Key Influencers and the Decomposition Tree
Design reports with charts, maps, matrix, cards, KPIs, slicers and bookmarks
Clean and reshape data with Power Query: split, merge, append, pivot and unpivot
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: Custom visuals, Scheduled refresh, M Language, Microsoft Excel (Advanced Excel level), Bookmarks, buttons and page navigation.
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.
Use absolute, relative and mixed references correctly in formulas
Apply SUMIFS, COUNTIFS, nested IF, IFERROR and text and date functions
Look up data with VLOOKUP, XLOOKUP, INDEX-MATCH and INDIRECT
Project to build: Loan EMI and scenario model. Use PMT, Data Tables and Scenario Manager to compare loan options.
Tools covered: Excel Tables and named ranges, Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH, INDIRECT, Data validation and dependent lists, Macro recorder, Array formulas.
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.
04Careers
Roles that fit work around Gandhinagar and GIFT City
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; manage emails, calls and appointments.
Skills employers ask for: MS PowerPoint presentations; MS Word document formatting; Email and internet skills.
Where careers start: Data Entry Operator / Office Assistant.
Which course should I start with in Gandhinagar and GIFT City?
GIFT City near Gandhinagar is India’s first international financial services centre, alongside government offices and IT firms. A sensible order is Data Analytics first, then Power BI once you are comfortable.
Which level should I choose?
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.
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 learn online from Gandhinagar and GIFT City?
Yes. CareerKraft runs live, trainer-led online and hybrid batches with the same syllabus, projects and certificate as classroom batches, so learners in Gandhinagar and GIFT City do not have to relocate.
08Explore more
Everything you can do from Gandhinagar and GIFT City
