
Closed
Posted
Paid on delivery
Developed an interactive Sales Dashboard using Pivot Tables, Charts, Slicers, and advanced Excel formulas. Created an Automated Employee Payroll System with salary, PF, HRA, and tax calculations. Designed an Inventory Management System with stock tracking and low-stock alerts. Built a GST Invoice & Billing System with automatic CGST, SGST, and IGST calculations. Created a Student Management System for attendance, marks, grades, and fee tracking. Prepared Financial Reports and Dashboards using Pivot Tables, Conditional Formatting, and Charts. Performed Data Cleaning, Analysis, and Reporting using Advanced Excel functions and tools. Created and managed a company in Tally Prime with GST, including ledgers, stock items, vouchers, and GST transactions. Generated Profit & Loss, Balance Sheet, Trial Balance, Stock Summary, and GST Reports in Tally Prime. Designed professional documents in MS Word using Mail Merge, Tables, SmartArt, Headers/Footers, and Templates. Developed professional PowerPoint presentations with animations, transitions, SmartArt, charts, and multimedia. Managed and analyzed data in MS Excel using formulas, Pivot Tables, What-If Analysis, Data Validation, and Dashboards. Created and managed databases using MS Access with tables, queries, forms, and reports. Utilized AI tools (e.g., ChatGPT, Microsoft Copilot, Canva AI) for content creation, data analysis, document drafting, and presentation preparation. Completed practical assignments in MS-CIT, covering Windows, Internet, MS Office, digital productivity, and online services. Applied MS Office applications to create business reports, spreadsheets, presentations, and official documentation. Worked on real-world business scenarios involving data analysis, accounting, reporting, office automation, and AI-assisted productivity.
Project ID: 40600378
6 proposals
Remote project
Active 6 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
6 freelancers are bidding on average ₹18,667 INR for this job

Your 15-module Office Automation suite — from GST Invoice to Tally Prime P&L to MS Access databases — is exactly the kind of multi-system project I handle best. Here is how I will execute each piece: Sales Dashboard: Pivot Tables with Slicers and Conditional Formatting so critical numbers surface without digging. Payroll Engine: Salary, PF, HRA, and tax calculations locked in protected sheets — your HR team enters inputs, formulas handle the rest. Inventory System: Structured Excel Tables with low-stock alert thresholds using conditional rules tied to reorder quantities you define. GST Billing: CGST, SGST, and IGST logic built in, with state-detection driving which tax line activates automatically. Tally Prime: Full company setup with ledgers, stock items, vouchers, and GST transactions, plus P&L, Balance Sheet, Trial Balance, and Stock Summary reports. Student Management: Attendance, marks, grades, and fee tracking consolidated in one view with grade formulas matching your institution's grading scale. AI-Assisted Work: ChatGPT and Copilot applied to Mail Merge templates, PowerPoint animations, and data-cleaning workflows to reduce turnaround time. One risk worth flagging: MS Access linked queries can break if file paths shift between machines — I will use relative path references to prevent that. For the GST Billing System, should IGST activate automatically when buyer and seller states differ, or do you want a manual override option?
₹22,500 INR in 5 days
7.1
7.1

Hi, I can develop and improve your complete office automation system using Excel, Tally Prime, MS Access, Word, PowerPoint, and AI-assisted productivity tools. The best solution is to first review your required workflows, existing files, calculation rules, reports, and output formats. I’ll then build clean, automated solutions for sales dashboards, payroll, inventory, GST billing, student records, financial reporting, databases, and professional business documents. I’m comfortable with advanced Excel formulas, Pivot Tables, slicers, charts, VBA, conditional formatting, data validation, Tally Prime with GST, MS Access forms/reports, Word Mail Merge, PowerPoint presentations, data cleaning, accounting reports, and AI-assisted document preparation. Deliverables can include: * Interactive Excel dashboards * Automated payroll calculations * Inventory and low-stock alerts * GST invoice and billing system * Financial and management reports * Tally Prime entries and reports * MS Access database solutions * Professional Word documents * Business PowerPoint presentations * Documentation and user guidance I’ll focus on accurate calculations, easy-to-use files, clean presentation, and practical automation that reduces repetitive office work. Best regards Ankit
₹12,500 INR in 2 days
2.7
2.7

Hi, I read your project carefully and I can deliver exactly what you need. I can start immediately and show you the first preview in a few hours. Let’s discuss the details
₹15,000 INR in 2 days
0.0
0.0

Hello, I have nearly 8 years of experience in Finance and Accounting, including General Ledger, Bank Reconciliation, Accounts Payable, Accounts Receivable, GST, TDS, financial statement preparation, and month-end closing. I am proficient in Tally, Excel, and I can complete your work accurately and on time. I have handled similar accounting tasks and can start immediately. I look forward to working with you. Thank you.
₹20,000 INR in 7 days
0.0
0.0

As an experienced and skilled professional in accounting and excel, my immense proficiency in office automation aligns directly with the comprehensive tasks listed for this project. From developing interactive dashboards using pivot tables, charts, and slicers to creating payroll systems and inventory management solutions - I have been tactfully navigating such high-demand projects for years. Apart from my solid foundation in accounting, I augment it with exceptional Excel skills that encompass advanced formulas, data cleaning & analysis, and report generation - just what your project needs. Furthermore, my efficiency extends to creating and managing databases using MS Access too! Over time, I've expanded my capabilities by investing in AI tools like ChatGPT and Microsoft Copilot for enhanced content creation, data analysis, document drafting - hence embellishing my deliverables. Completing practical assignments in MS-CIT only fortified my proficiency with MS Office applications allowing me to craft business reports, spreadsheets, presentations alongside maintaining official documentation. Emphatically speaking, you need someone who can practically manifest all the requirements into a seamless narrative of automation and productivity. I resonate with your project's endeavors and extensively believe I can deliver exactly what you're looking for. With me on board, esteemed quality isn't a mere promise but an empowered action plan.
₹25,000 INR in 7 days
0.0
0.0

Mumbai, India
Member since Jul 22, 2026
₹12500-37500 INR
₹600-1500 INR
$15-25 USD / hour
₹600-1500 INR
$10-30 USD
₹750-1250 INR / hour
₹100-400 INR / hour
$8-15 USD / hour
$15-25 USD / hour
₹600-1500 INR
₹600-5000 INR
€250-750 EUR
$30-250 AUD
$2-8 USD / hour
$30-250 AUD
₹750-1250 INR / hour
€250-750 EUR
₹750-1250 INR / hour
₹1500-12500 INR
₹400-750 INR / hour
$30-250 USD
₹600-1500 INR