UG Certification

UG CERTIFICATION

Undergraduate (UG) Skill Development Program

Build Practical Commerce Skills for a Future-Ready Career

The UG Skill Development Program at Finlume Global is a comprehensive, hands-on certification course designed to equip commerce students with real-world financial and digital skills. Over seven months, students master the fundamentals of accounting, taxation, Excel analytics, and industry-relevant software like Tally, Zoho Books, and Power BI—culminating in a professional internship to apply everything they’ve learned.

Month 1 Basics of Accounting and Finance

Introduction to Accounting Principles (GAAP)
Understanding Debit and Credit Rules
Complete Accounting Cycle Explained
Journal Entries and Ledger Posting in Double-Entry System
Preparation of Trial Balance, Profit & Loss Account, and Balance Sheet
Overview of Financial Statements
Key Financial Ratios – Liquidity, Profitability, and Efficiency

Evaluation

Assignment 1: Journal & Ledger Practice Sheets (10 marks) Case Study: Analyse a company’s financial statement (10 marks) Monthly Test 1: MCQs + Practical (20 marks)

Month 2 Tally / Zoho Books + GST

Setting up company and masters in Tally/Zoho Books
Creating ledgers and recording sales, purchases, receipts, and payments
GST setup with concepts of CGST, SGST, and IGST
Recording GST-compliant transactions and generating reports
Preparing Profit & Loss Account, Balance Sheet, and GST Summary Report
Exporting reports and using MIS tools in the software

Evaluation

Practical Assignment: Create ledgers & voucher entries in Tally (10 marks) Project: GST Return Filing Simulation (10 marks) Monthly Test 2: Practical + Theory (20 marks)

Month 3 Advanced Excel for Commerce

Use basic to advanced functions like IF, AND, OR, VLOOKUP, HLOOKUP, and INDEX-MATCH
Apply formatting and data validation techniques
Create charts and graphs for effective data visualization
Utilize productivity shortcuts and accounting templates
Perform data sorting, filtering, and cleaning
Build and analyze Pivot Tables and Pivot Charts
Use conditional formatting for better data insights

Evaluation

Assignment: MIS Report on Sales Data (10 marks) Case Study: Clean and Analyze Raw Excel Data (10 marks) Monthly Test 3: Excel Task + MCQs (20 marks)

Month 4 Finance in Excel

Apply Time Value of Money functions: NPV, IRR, PV, and FV
Create EMI and loan amortization schedules
Conduct scenario and sensitivity analysis
Prepare budgets and perform variance analysis
Analyze break-even points and build profitability models
Design dashboards to track key financial KPIs

Evaluation

Assignment: Prepare Budget Sheet (10 marks) Project: Financial Model of a Startup (15 marks) Monthly Test 4: Excel Simulation Test (15 marks)

Month 5

Learn finance-specific resume writing techniques
Draft effective cover letters and practice professional email etiquette
Build and optimize your LinkedIn profile
Get tips for personal interviews and experience mock interview sessions
Improve communication skills and body language
Master time management and workplace etiquette

Evaluation

Assignment: Resume + LinkedIn Profile Submission (10 marks) Mock Interview & Feedback (10 marks) Monthly Test 5: Communication & Aptitude Test (20 marks)

Month 6 -7 Finance Internship (8 Weeks)

Work under CA/CS firms, accounting departments, or finance teams
Prepare financial reports using Excel
Maintain day-to-day bookkeeping and reconciliation
Assist in GST filing and update vendor/client ledgers
Participate in weekly reviews with mentors and maintain a logbook
Deliver a final presentation or report on key learnings

Evaluation

Internship Logbook (10 marks) Internship Project Report (20 marks) Final Viva Presentation (30 marks) Company Feedback (10 marks)

Enroll Now