10 December 2025
Data Analyst - The Rising Power of Data
WHY DATA ANLYTICS Value of Data Analysis in the Modern EraDa...
Duration
40 Hours - 240 HoursMode
Live Online / Offline ClassesEMI
Start at Rs. 2000 P.M (No Cost EMI)Language
English / HindiWhy E-Accounting & Tax:
E-Accounting and Taxation has emerged as one of India's fastest-growing career fields, with accounting jobs increasing by up to 30% annually after the implementation of GST. From large MNCs and CA firms to growing startups and SMEs — every business needs skilled professionals who can manage their accounts, file GST returns, handle income tax compliance, and analyze financial data. F1 Macro Technologies' Certified Enterprise Accountant (CEA) program is designed to make you industry-ready in this high-demand field within months, not years.
What You'll Learn:
Our CEA program goes far beyond basic bookkeeping. You'll gain deep expertise in MS Office, Tally Prime (Accounting + Inventory + Payroll), Basic & Advance GST, GST Returns E-Filing, ITR + TDS Filing, Advance Excel, Power BI, and Company E-Filings & Compliances. The course also includes Advance Business Registrations & Licensing — covering MSME, Startup India, FSSAI, Shop & Establishment Act, and GEM Services — making you a complete accounting and tax consultant capable of handling any client requirement.
Career Growth & Salary:
Entry-level Certified Enterprise Accountants in India earn ₹2–3 Lakhs per annum, with experienced professionals reaching ₹4–8 Lakhs per annum. With added Analytics specialization, salaries climb to ₹8–15 Lakhs per annum. Senior accountants and tax consultants with 5–10+ years of experience can earn ₹15–20+ Lakhs per annum. Whether you choose to work in MNCs, join a CA firm, become a GST practitioner, or set up your own accounting consultancy — the CEA certification opens doors at every career level.
Why F1 Macro Technologies:
With 12+ years in IT training, 4,000+ students placed in top companies (Infosys, HCL, Genpact, Accenture, Bosch, Bank of America, Citibank, IBM, and more), and 5,000+ trainees coached — F1 Macro Technologies delivers what classroom theory cannot: practical, job-ready skills. Our CEA program is taught by industry experts including Chartered Accountants, Company Secretaries, and senior tax consultants. You'll work on 3–5 live client projects per module and complete a 3-month internship with practising CAs/CSs — making you employable from Day 1.
Master
MS Word, Excel basics, and PowerPoint for professional documentation, business
reports, and corporate presentations. Build a strong foundation in the tools
every accountant uses daily.
Key Topics Covered:
•
Computer
fundamentals, Word document formatting, Mail Merge, Tables & Templates
•
Excel
basics, formulas, formatting, charts & data handling
•
PowerPoint
slides, SmartArt, transitions, and corporate presentations
•
Macros
in Word for automation
🎯 Project:
Create a complete corporate letterhead, business letter template, and investor
presentation deck.
Become
a Tally expert — the most widely used accounting software in India. Cover
everything from company creation to advanced inventory management and payroll
processing.
Key Topics Covered:
•
Company
creation, Ledger & Group setup, Voucher entries (Sales, Purchase, Payment,
Receipt, Contra)
•
Inventory
management — Stock items, Godowns, BOM, Multi-currency, Manufacturing Journal
•
Purchase
Orders, Sales Orders, Delivery Notes, Credit/Debit Notes
•
Payroll
processing — Pay Heads, Salary, PF/ESI/Gratuity, Statutory Reports
•
Reports:
Balance Sheet, P&L, Trial Balance, Stock Summary, Day Book
🎯 Project:
Set up a full company in Tally and process 1 month of real business
transactions including sales, purchase, inventory, and payroll.
1. GST Fundamentals
Learn important GST concepts, taxation structure, and business classifications.
Understand the foundation of India’s indirect tax system in a practical way.
2. GST Rates & Schemes
Study GST rates, composition schemes, and their impact on businesses.
Gain clarity on how GST affects pricing and compliance.
3. GST in Tally ERP 9
Implement GST practically using Tally ERP 9 software.
Learn account setup and GST configuration for businesses.
4. Ledger Creation & Entries
Create GST ledgers and record accounting transactions accurately.
Understand entry management for daily business operations.
5. Advanced GST Transactions
Work on GST transactions under common and multiple ledger systems.
Analyze GST reports and business-specific accounting entries.
6. Reverse Charge Mechanism (RCM)
Learn RCM concepts, entries, and tax liability adjustments.
Understand practical accounting treatment under GST rules.
7. Advance Receipts & Payments
Record advance receipts and payments under GST provisions.
Manage taxation and adjustments related to advances.
8. GST Adjustment Entries
Pass journal and adjustment entries related to GST liabilities.
Learn practical correction and reconciliation processes.
Become
a GST Practitioner — handle live GST registration, return filing, and ITC
reconciliation directly on the GST portal.
Key Topics Covered:
•
Live
GST registration & GSTN obtaining
•
Filing
GSTR-1 (Outward), GSTR-3B (Monthly), GSTR-9 (Annual), GSTR-4 (Composition)
•
Input
Tax Credit (ITC) — claim, reversal, reconciliation
•
DSC
setup, Interest & late fee calculations, Payment of tax
•
Input
Service Distributor (ISD) returns
🎯 Project: File live GST returns on real client data — end-to-end practical filing experience.
Master
Indian Income Tax — from PAN application to filing all 7 ITR forms. Become
capable of handling tax filings for individuals, businesses, and companies.
Key Topics Covered:
•
PAN
application & e-filing portal registration
•
All
7 ITR forms — ITR-1 to ITR-7 (Salaried, HUF, Business, Companies, Trusts)
•
Profit
& Loss and Balance Sheet finalization for ITR
•
TDS
return filing, ratios calculation for loan ITRs
•
Communication
& client handling for tax filings
🎯 Project: File live ITRs and TDS returns on real client data — experience all 7 ITR types
Transform data into insights with Power BI’s 9+ sub-modules and interactive dashboards. Master visualizations, DAX, and live projects to drive business decisions with confidence!
• Introduction to Power BI: Understand Power BI’s workflow, benefits, and components, including Power BI Desktop, Services, and Mobile Apps, with installation and setup.
• Data Connection & Transformation: Master data connectors, Query Editor, and tools for shaping data (text, numbers, dates) for analysis-ready formats.
• Data Modeling & Relationships: Learn data modeling, normalization, Star/Snowflake schemas, and manage relationships (Primary/Foreign Keys, Cardinality, Active/Inactive).
• DAX for Analysis: Use Data Analysis Expressions (DAX) to create calculated columns, measures, and apply aggregation, logical, and date functions.
• Interactive Visualizations: Build and customize visuals, dashboards, and reports with drill-downs, marketplace visuals (Word Cloud, Shape Map), and Row-Level Security.
• Data Exploration & Insights: Leverage Power BI Service for quick insights, natural language queries, and full-screen dashboards for organizational sharing.
• Publishing & Collaboration: Publish reports, manage content packs, schedule data refreshes, and share via Power BI Workspace with usage metrics and subscriptions.
Real-World Applications: Apply skills in 3-4 live projects on Sales, HR, and Financial Data, creating actionable business insights
Learn
the complete process of company incorporation, ROC filings, DSC setup, and
ongoing compliance — making you an end-to-end corporate consultant.
Key Topics Covered:
•
Company
incorporation — types, documents, MCA portal e-filing
•
DIN,
CIN, DSC application & e-filing of ROC returns
•
Drafting
resolutions, minutes, notices, fee challans
•
Director
& shareholder appointment process
•
Post-incorporation
licenses based on industry
🎯 Project:
3–4 live client projects on company registration and compliance filings.
Become
the go-to consultant for new businesses. Learn all major government
registrations and licenses Indian businesses need to operate legally.
Key Topics Covered:
•
MSME
/ Udyam Registration — eligibility, documentation, government benefits
•
Startup
India Registration — DPIIT recognition, tax holidays, IPR fast-tracking
•
FSSAI
License (Food Business) — Basic, State, Central licensing
•
Shop
& Establishment Act registration
•
GEM
(Government e-Marketplace) vendor registration
•
On-demand:
IEC (Import-Export Code), Professional Tax, etc.
🎯 Project:
Case studies — registration journey of a café, a tech startup, and an MSME (5+
scenarios).
The
differentiator of our CEA-Pro program — gain real-world experience by working
alongside practicing Chartered Accountants, Company Secretaries, and Tax
Consultants.
What You'll Do:
•
Practical
consulting overview — start-up to advisory
•
Direct
client handling and one-to-one communication
•
File
real ITRs for clients — end-to-end ownership
•
Manage
company compliance in day-to-day operations
•
Apply
for industry-specific licenses on behalf of clients
🎯 Outcome:
Walk out as a job-ready Accounting & Tax Professional with 3 months of
verified industry experience on your resume.
Self Practice Accountant
Accounts Executive
GST Accountant
Analytics Executive
Finance Executive
Senior Accountant
GST Practitioner
Account & Tax Consultant
Self Business Accountant
Data Analyst
On the Spot Offers - Extra 10% on the Spot Admission
The CEA program is open to 12th-pass students, B.Com/BBA/MBA graduates, working professionals looking to switch careers, and entrepreneurs who want to manage their own books. No prior accounting experience is required for CEA (Tier 1)
— we start from the basics. For higher tiers (CEA-A, CEA-P, CEA-Pro), basic computer literacy is helpful but not mandatory.
Each tier builds on the previous one.
CEA (80 hrs) covers MS Office, Tally, and Basic GST — perfect for beginners.
CEA-A (120 hrs) adds Advance Excel and Power BI for MIS roles.
CEA-P (120 hrs) adds Income Tax + TDS Filing and Business Registration — ideal for tax consultants.
CEA-Pro (200 hrs + 3-month internship) is our flagship — adds Company E-Filings, Advance Registration, and a verified internship with practising CAs/CSs.
Yes — F1 Macro Technologies offers 100% placement assistance to all CEA students. We have placed 6500+ students in companies like Infosys, HCL, Genpact, Bosch, Bank of America, Citibank, Accenture, IBM, Samsung, and many more. Our support includes resume building, mock interviews, in-house placement drives, and MNC referrals through our alumni network.
You'll master industry-standard tools including Tally Prime (with GST), MS Office (Word, Excel, PowerPoint), Advance Excel, Power BI, GST Portal (live e-filing), Income Tax e-filing portal, MCA portal for company e-filings, and various government registration portals (Udyam, Startup India, FSSAI, GEM, etc.). All training is hands-on with real client data — not just theory.
Absolutely. F1 Macro Technologies is an ISO 9001:2015 certified institute with 12+ years of training expertise. Our certification is widely recognized across MNCs and CA firms. Salary-wise: entry-level CEAs earn ₹2–3 LPA, mid-level professionals earn ₹4–8 LPA, and CEAs with analytics specialization (CEA-A and above) can earn ₹8–15 LPA. Senior accountants with 5+ years of experience reach ₹7–10+ LPA
Our students are successfully placed in top companies across industries
See how F1 Macro Technologies is bridging the gap between education and employment. Our students don’t just graduate; they get hired. With dual certifications and real-world internship experience, we provide the platform you need to build a bright, future-proof career in Data Analytics.