Diwali offer: Flat 30% off on all courses plus free career counselling. Ends 5 Nov.Claim offer

Advanced Computer Course

Take your computer skills to the next level with Advanced MS Office, Tally, accounting software, hardware fundamentals, and professional productivity tools.

4–6 Months Offline / Online Certificate Provided Job-Ready Skills

Course Overview

The Advanced Computer Course at White Fortress Academy builds on fundamental computer skills and takes you to a professional level. This course is ideal for those who already know the basics and want to upskill for office jobs, accounting, or administrative roles.


You will master advanced features of MS Office (Word, Excel, PowerPoint), learn Tally for accounting and GST, understand computer hardware and troubleshooting, and work with professional productivity software used in offices across India.


By the end of this course you will be fully equipped for data entry, office administration, accounting assistant, and similar professional roles.

Course Curriculum

15 modules · 43 topics

Advanced MS Office

6 modules · Month 1–2
01

Advanced Excel Formulas

3 topics
  • Logical Functions
  • IF & nested IF
  • AND, OR & NOT
  • IFS & SWITCH
  • Lookup Functions
  • VLOOKUP & HLOOKUP
  • INDEX-MATCH
  • XLOOKUP
  • Text & Date Functions
  • LEFT, RIGHT & MID
  • TEXT & CONCAT
  • DATEDIF & EOMONTH
02

Excel Data Visualization

3 topics
  • Charts
  • Combo & dual-axis charts
  • Dynamic charts
  • Chart formatting
  • Dashboards
  • KPI cards
  • Slicers & timelines
  • Dashboard layout
  • Conditional Formatting
  • Data bars & icon sets
  • Rule-based highlighting
  • Sparklines
03

Pivot Tables & Analysis

3 topics
  • Pivot Tables
  • Create & refresh
  • Grouping
  • Calculated fields
  • Pivot Charts
  • Slicers & filters
  • Report layouts
  • Data Cleaning
  • Remove duplicates
  • Text to columns & Flash Fill
  • Data validation
04

Macros & Automation

3 topics
  • Macros
  • Record a macro
  • Run & assign to buttons
  • Macro security
  • Mail Merge
  • Data source setup
  • Merge to email & print
  • Large Reports
  • Page setup
  • Freeze panes & print titles
05

AI Tools with MS Office

3 topics
  • Prompt Writing
  • Writing clear prompts
  • Role & context prompts
  • Office Productivity
  • Summaries & insights
  • Drafting documents
  • Formula help
  • Responsible Use
  • Fact-checking AI
  • Data privacy
06

Google Workspace

3 topics
  • Docs & Sheets
  • Formatting
  • Formulas
  • Sharing permissions
  • Slides & Forms
  • Presentations
  • Surveys & quizzes
  • Google Drive
  • Folder organisation
  • Version history
  • Offline access

Tally & Accounting

9 modules · Month 2–3
07

Tally Prime Setup

3 topics
  • Introduction
  • Interface
  • Gateway of Tally
  • Features & configuration
  • Company Creation
  • Create & alter a company
  • Financial year
  • Security & passwords
  • Data Management
  • Backup
  • Restore
  • Data split
08

Accounting Basics

3 topics
  • Fundamentals
  • Accounting equation
  • Golden rules
  • Debit & credit
  • Books of Accounts
  • Journal
  • Ledger
  • Trial balance
  • Account Types
  • Personal accounts
  • Real & nominal accounts
09

Ledgers & Groups

3 topics
  • Ledger Creation
  • Single & multiple ledgers
  • Opening balances
  • Groups
  • Primary groups
  • Sub-groups
  • Cost Centres
  • Cost categories
  • Cost centre reports
10

Voucher Entry

2 topics
  • Voucher Types
  • Payment & receipt
  • Contra & journal
  • Sales & purchase
  • Notes & Alterations
  • Debit & credit notes
  • Voucher alteration
11

Inventory in Tally

3 topics
  • Stock Items
  • Units
  • Stock groups
  • Godowns
  • Orders
  • Purchase orders
  • Sales orders
  • Delivery notes
  • Stock Reports
  • Stock summary
  • Movement analysis
  • Reorder levels
12

GST in Tally

3 topics
  • Configuration
  • GST setup
  • Tax ledgers
  • HSN & SAC codes
  • Invoices
  • Sales invoices
  • Purchase invoices
  • Input & output tax adjustment
  • Returns
  • GSTR-1 overview
  • GSTR-3B overview
  • Reconciliation
13

Final Accounts & Reports

3 topics
  • Financial Statements
  • Profit & loss account
  • Balance sheet
  • Daily Books
  • Day book
  • Cash book
  • Bank book
  • Reports
  • Export to Excel
  • Print & email
14

Payroll in Tally

2 topics
  • Payroll Setup
  • Employee groups
  • Pay heads
  • Salary details
  • Processing
  • Attendance
  • Salary vouchers
  • Payslips
15

Banking & TDS Basics

3 topics
  • Banking
  • Bank reconciliation
  • Cheque printing
  • TDS
  • TDS concepts
  • TDS ledgers
  • Payment & return basics
  • Year-End
  • Closing entries
  • Year-end procedures

Practice Projects

Project 1Company accounts with GST in Tally Prime
Project 2Sales dashboard with pivot tables in Excel
Project 3Payroll sheet and salary slips
Project 4Mail-merge letters and certificates
Project 5Office LAN and shared printer setup
Project 6PC assembly and Windows installation

Software & Tools You Will Learn

MS Word (Advanced) MS Excel (Advanced) MS PowerPoint MS Access Tally Prime Google Workspace Adobe Acrobat OneDrive Zoom & Teams Windows 10/11

Career Opportunities

Office Administrator

Handle office operations, documentation, scheduling and correspondence professionally.

Data Entry Operator

Work in BPOs, banks, hospitals and companies managing data and records.

Accounts Assistant

Support accounting teams using Tally for GST, payroll and financial reports.

Computer Operator

Manage systems, peripherals and basic IT support in offices and institutions.

Course Details

Duration4–6 Months
ModeOffline (Delhi Centre) / Online Classes Available
Batch TimingMorning & Evening Batches (Mon–Sat)
EligibilityBasic computer knowledge required. Completion of Computer Basics course preferred.
CertificateCompletion Certificate from White Fortress Academy provided on passing
SupportPractical assignments + Resume building + Placement guidance

Frequently Asked Questions

How long is the Advanced Computer course in Delhi?

The Advanced Computer course takes 4–6 months.

Is the Advanced Computer course offline or online, and what are the batch timings?

Mode: Offline (Delhi Centre) / Online Classes Available. Batch timing: Morning & Evening Batches (Mon–Sat).

Who can join the Advanced Computer course? Do I need any prior knowledge?

Basic computer knowledge required. Completion of Computer Basics course preferred.

Will I get a certificate after the Advanced Computer course?

Yes. White Fortress Academy provides a completion certificate on passing the course.

Which tools and software will I learn in the Advanced Computer course?

You will work with advanced MS Word and Excel, MS PowerPoint, MS Access, Tally Prime, Google Workspace, Adobe Acrobat, OneDrive, Zoom & Teams and Windows 10/11.

What jobs can I aim for after the Advanced Computer course?

Career paths covered on this page include Office Administrator, Data Entry Operator, Accounts Assistant and Computer Operator. Hiring depends on your skills and the market. The academy's support includes practical assignments, resume building and placement guidance.

What is the fee for the Advanced Computer course, and can I try a demo class?

The fee is not listed on this page, so please ask the centre for the current fee and the next batch date. Call or WhatsApp +91 88104 71374, or visit 53, Maujpur Main Road, Opp. HDFC Bank, Delhi 110053 (Monday to Saturday, 9:00 AM to 8:00 PM). A free demo class is available.

Advance Your Career with Professional Computer Skills!

Enroll in the Advanced Computer Course and become job-ready for office, accounting, and administrative roles.

Enroll Now Ask on WhatsApp