BASIC EXCEL SHEET COURSE
A practical Excel training programme designed to build the spreadsheet skills required for day-to-day office administration, data entry, reporting, calculations and basic accounting. The programme focuses on commonly used Excel features and practical office applications.
Course Format
About the Programme
The programme introduces learners to Excel from the fundamentals and progressively develops practical skills required for day-to-day office administration.
It covers worksheet management, data entry, formatting, formulas, essential functions, sorting and filtering, tables, conditional formatting, dates, text functions, logical functions, data validation, basic accounting, office expense management, attendance management, MIS reporting, charts, graphs and professional printing/page setup.
Whom Is This Course For?
Office Staff & Administrators
Learners who need Excel for common office administration, daily records, correspondence, and operational tracking.
Accounts & Data Entry Professionals
Individuals handling basic billing, expense vouchers, cashbook receipts, attendance logs, and data entries.
Beginners Starting Their Excel Journey
Anyone with little to no previous spreadsheet experience looking to build practical, structured workplace skills.
Small Business Owners & Freelancers
Entrepreneurs who want to maintain simple financial summaries, track client orders, and manage business records easily.
Course Content
Excel Foundations & Worksheet Management
Excel interface, workbook, worksheet, rows, columns, cells, Ribbon; creating, renaming, copying, moving, deleting and organizing worksheets.
Data Entry, Formatting & Essential Functions
Text, numbers, dates, currency, serial numbers, fonts, borders, alignments; formula structure and core functions: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA.
Cell References, Sorting, Filtering & Tables
Relative, absolute, and mixed references; AutoFilter, custom sorting; creating and formatting structured Excel tables with automated total rows.
Conditional Formatting, Date & Text Functions
Highlighting duplicates, top/bottom values; date math with TODAY, DAY, MONTH, YEAR; text cleanup using LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER, PROPER.
Logical Functions, Data Validation & Basic Accounting
Decision-making with IF, AND, OR; dynamic drop-down lists; tracking income, payments, receipts, outstanding amounts, simple ledgers and cashflow.
Office Expense Management, MIS, Charts & Project
Monthly expense summaries, employee attendance logs, basic MIS management reports, column/bar/line/pie charts, page setup scaling, PDF output and final project.
Project
Expense Tracking Sheet
Recording daily office vouchers, category allocations, date stamps, and vendor entries with structured data formatting.
Monthly Summary & Budget vs Actual
Automated summary formulas comparing planned operational budgets with actual departmental expenditure.
Attendance & Leave Calculator
Staff attendance tracker computing working days, leaves, and basic payroll inputs using logical formulas.
MIS Dashboard & Print-Ready Layout
Visual presentation using dynamic charts, summary KPI cards, and configured page layouts for one-click PDF export.
What Will the Learner Get
Practical foundational Excel skills covering worksheet creation and management, accurate data entry, professional formatting, basic formulas and functions, cell references, sorting and filtering, tables, conditional formatting, date and text handling, logical formulas, data validation, MIS reporting, charts and print/PDF preparation.
How Will This Course Help
The course helps learners use Excel for routine office and accounting-related tasks in a structured manner. It develops the ability to organise data, perform calculations, prepare summaries, track expenses and attendance, create basic MIS reports, present information through charts and prepare worksheets for printing or PDF sharing.
Earning Opportunity
There is no earning opportunity or income-generation promise on completion of this course. The program develops practical Excel skills relevant to office administration, data handling, reporting and basic accounting; learners may apply these skills in their own work or professional activities.
Why Choose SPANDAN?
SPANDAN focuses on practical, easy-to-understand Excel skills for everyday office work, reporting and accounting. Designed around real-world applications and hands-on learning, helping learners build usable workplace skills. Aims to make Excel simple, practical and relevant to learners' day-to-day professional needs.
Refund Policy
Request for a refund within 24 hours after attending the 1st Class / Session, if dissatisfied. No refund request will be accepted after 24-hours of attending the 1st Class / Session. Refund will be made for the Full amount except GST.