Computer & Office Skills

Combo of Basic + Advanced Excel

This combo takes you through Excel completely — starting with the essentials and moving into advanced formulas, lookups, pivot tables, dashboards and analysis. Excel is the single most-requested office skill, and this course makes you genuinely capable with it. Practical, hands-on and immediately useful at work.

Duration: 1.5 Months
Format: Live 1-on-1
Level: Professional
Certificate: Osian NSDC

Overview

What this course is about

The Excel Combo course gives you one connected learning path from first spreadsheet steps to workplace reporting. Start with workbook navigation, formatting, tables, sorting and reliable data entry, then progress into formula design, lookup functions and analysis. A personal teacher can adjust the examples for study, accounts, sales, stock or office administration, making the progression useful for learners who do not want separate courses.

Your practice moves from simple totals and IF logic to SUMIFS, COUNTIFS, XLOOKUP and VLOOKUP, with careful attention to cell referencing and error checking. You will then summarise larger datasets using pivot tables, charts and slicers. Projects can include a stock dashboard, attendance summary, sales tracker or expense report, so each stage produces a file you can explain in an interview.

The course also introduces data validation, conditional formatting and Power Query for cleaning recurring files. Live one-on-one classes are arranged flexibly between 7 AM and 9 PM or on weekends, and you receive individual feedback on practice work. After completion, Osian Academy provides a certificate.

By the end

What you’ll be able to do

Set up structured workbooks and clean data entry templates
Use cell references, logical formulas and lookup functions accurately
Analyse records with SUMIFS, COUNTIFS and pivot tables
Build charts, slicers and dashboards for business summaries
Clean recurring spreadsheet files with Power Query basics
Complete an end-to-end Excel report from raw data to presentation

Syllabus

How the course flows

1
Computer FundamentalsWeek 1
How computers and the OS work day to day.
2
Documents & PresentationsWeek 2
Professional Word and PowerPoint work.
3
SpreadsheetsWeek 3
Formulas, functions and clean data in Excel.
4
Internet & ProductivityWeek 4
Email, cloud tools and staying organised.
5
Practice & CertificationWeeks 5–6
Real tasks and exam-style preparation.

Toolkit

Tools you’ll use

MS Word
MS Excel
MS PowerPoint
Windows
Google Workspace

Audience

Who this course is for

Beginners seeking a complete Excel learning route
Students preparing for office, data entry or MIS work
Job seekers changing from non-computer roles
Small business owners wanting sales and stock visibility
Professionals who need both foundations and advanced reporting

Where it leads

Roles this opens up

MIS and Reporting Executive
Prepare structured reports by combining data entry, formulas, pivots and dashboards.
Office Operations Assistant
Maintain trackers and turn daily records into useful summaries for supervisors.
Small Business Data Coordinator
Monitor stock, sales and expenses using organised Excel workbooks.

Questions

Before you enrol

The course is suitable for Microsoft 365 and recent standalone desktop versions, with explanations of older-version alternatives. If XLOOKUP or Power Query is unavailable, the teacher can demonstrate an equivalent workflow.

Yes, Excel on Mac can support the main learning path, although shortcuts and some Power Query options may vary. Your teacher will show the commands available on your device and note Windows-specific office practices.

You will work with staged files such as attendance, stock, sales and expense data, moving from entry to dashboard. The teacher can review your own non-confidential practice file and suggest cleaner formulas or layouts.

Yes, it covers both accurate spreadsheet preparation and the analysis skills expected in many data entry, MIS and office reporting tasks. Placement support offers resume help, mock interviews and referrals, but no job outcome is promised.

Basic Excel is best for essential spreadsheet confidence, while Advanced Excel assumes those foundations and focuses on analysis. The Combo connects both levels for learners who want a guided route without a sudden jump.

The teacher can identify your current level and spend less time on familiar steps while keeping the learning sequence clear. You will still practise foundational file organisation before moving into advanced reporting methods.