Head office, Rana Pratap Bagh, Delhi011 2721 1512+91 97116 99511

Course family

Computer & Office Skills

Beginners, school leavers and working adults

Use a computer with confidence at home and at work: documents, spreadsheets, the internet and fast, accurate typing.

Duration, fees and batch timings are quoted by the head office or your centre.

Students at computers in a classroom while a teacher helps one of them

In this family

  • 4courses
  • 6study books
  • 42lessons
  • 195practice questions
  • 15free ebooks

The courses

4 courses in this family

What each course is about, who it suits, what you practise and the study material that comes with it. Each course has a full page with every lesson, sample questions and admission details.

  1. Beginners, school leavers and working adults

    ADCA: advanced computer applications

    • 42lessons
    • 195questions
    • 17ebooks

    A broader programme that brings computer basics, office software, the internet and other applications together in one course.

    Who it suits

    • School leavers who want a broad computer course before college or work
    • Job seekers preparing for office, front-desk and data-entry work
    • Working adults who use a computer and want to fill the gaps
    • Shop and small-business owners who keep their records on a computer

    What you will practise

    • Know the parts of a computer, memory units and how files and folders are organised
    • Use Windows, File Explorer, keyboard shortcuts, the web browser and email with confidence
    • Write, format and print letters, tables and reports in Word, including mail merge
    • Build Excel sheets with formulas, IF and lookups, sort and filter data, and make charts
    • 21lessons
    • 90questions
    • 8ebooks

    From switching on to sending an email: Windows, files and folders, browsing, email and staying safe online.

    Who it suits

    • Adults using a computer for the first time
    • Students who need to type assignments and send email
    • Parents and elders who want to use the internet, email and online payments safely
    • Anyone planning to go on to MS Office or ADCA

    What you will practise

    • Use the Windows desktop and the Start menu, and switch the computer off properly
    • Create, rename, move and find files and folders in File Explorer
    • Search the web, write a proper email and send an attachment
    • Spot phishing messages and UPI or OTP fraud before they cost you money
  2. Students, job seekers and office staff

    MS Office: Word, Excel and PowerPoint

    • 21lessons
    • 105questions
    • 7ebooks

    Word for letters and documents, Excel for tables and calculations, and PowerPoint for presentations.

    Who it suits

    • Students who make projects, reports and presentations
    • Job seekers preparing for office work
    • Office staff who want to work faster in Word and Excel
    • Anyone who has finished a basic computer course and wants the next step

    What you will practise

    • Create, edit, proofread and format documents, and print them with headers and footers
    • Work with tables, pictures, styles, a table of contents and mail merge in Word
    • Use formulas, relative and absolute references, and functions such as SUM, IF, VLOOKUP and XLOOKUP
    • Sort and filter data in Excel and turn it into a chart
  3. Students, job seekers and office staff

    Typing in English, Hindi and regional languages

    • 14lessons
    • 55questions
    • 4ebooks

    Touch typing for speed and accuracy, in English and in Hindi and other Indian languages.

    Who it suits

    • Job seekers preparing for typing and data-entry tests
    • Students who type assignments and projects
    • Office staff who still type with two fingers
    • Shorthand learners, for whom fast typing is part of transcription

    What you will practise

    • Sit and place your hands correctly, with your fingers resting on the home row
    • Know which finger presses which key, without looking at the keyboard
    • Measure your speed in words per minute and your accuracy
    • Follow a daily practice plan that builds speed without losing accuracy

What you will learn

6 study books, 42 lessons.

Every lesson of the study books that come with these courses in the student portal. Open a lesson to see its key points. Your centre gives you the syllabus, the duration and the fee.

Computer Fundamentals

For ADCA, Basic computer and Typing

Learn how a computer works, from its parts and devices to memory units, number systems, software, operating systems and file management.

  • 7 lessons
  • About 21 min of reading
  • 35 practice questions
  • 25 key terms
  1. 1Introduction to Computers4 key points · 3 min read
    • A computer accepts input, processes it, produces output and stores results.
    • Data is raw facts; information is processed data with meaning.
    • GIGO means wrong input gives wrong output.
    • Hardware is the physical machine; software is the set of programs that run on it.
  2. 2Parts of a Computer4 key points · 3 min read
    • The CPU carries out instructions; its parts are the ALU, the Control Unit and registers.
    • The motherboard is the main circuit board that connects every part.
    • The SMPS converts AC mains power into low-voltage DC.
    • Peripherals connect through ports such as USB and HDMI.
  3. 3Input and Output Devices4 key points · 3 min read
    • Input devices send data in; output devices show, print or play results.
    • OCR reads printed text, OMR reads marked bubbles, and MICR reads cheque characters.
    • Dot matrix printers are impact printers; inkjet and laser printers are not.
    • A touchscreen is both an input and an output device.
  4. 4Memory and Storage Devices4 key points · 3 min read
    • RAM is volatile working memory; ROM is non-volatile and holds start-up firmware.
    • Cache sits between the CPU and RAM to speed up access.
    • HDDs store data magnetically; SSDs and pen drives use flash memory.
    • Always keep a backup of important files in more than one place.
  5. 5Bits, Bytes and Number Systems5 key points · 3 min read
    • 8 bits make a byte and 4 bits make a nibble.
    • In the binary convention, each unit (KB, MB, GB, TB) is 1024 times the one before it.
    • Binary is base 2, octal base 8, decimal base 10 and hexadecimal base 16.
    • 1101 in binary is 13 in decimal; one hex digit equals 4 bits.
    • ASCII codes English characters; Unicode covers scripts such as Devanagari.
  6. 6Software and Operating Systems5 key points · 3 min read
    • System software runs the computer; application software does tasks for the user.
    • A compiler translates the whole program first; an interpreter works one statement at a time.
    • Open-source software shares its source code; proprietary software does not.
    • The OS manages processes, memory, files, devices, security and the user interface.
    • POST is the hardware check the firmware runs at start-up.
  7. 7File Management Concepts4 key points · 3 min read
    • A file holds data; a folder holds files and other folders.
    • The extension after the last full stop tells the file type.
    • A path is the full address of a file or folder, such as C:\Users\Aman\Documents.
    • Copy keeps the original; move takes it away from the old location.

Windows, Internet and Email

For ADCA and Basic computer

Use Windows confidently, manage files and folders, browse and search the web, write proper emails, stay safe from online and UPI fraud, and keep files in the cloud.

  • 7 lessons
  • About 21 min of reading
  • 35 practice questions
  • 25 key terms
  1. 1The Windows Desktop4 key points · 3 min read
    • The taskbar holds pinned and open apps; the notification area shows the clock and status icons.
    • Deleting a shortcut does not delete the original file.
    • Files deleted normally from the computer's own drive go to the Recycle Bin and can be restored.
    • Windows 11 centres the taskbar icons by default; Windows 10 places Start at the left.
  2. 2File Explorer, Files and Folders4 key points · 3 min read
    • Windows key + E opens File Explorer; Ctrl + Shift + N creates a new folder; F2 renames.
    • Ctrl + click picks separate items; Shift + click picks a range.
    • Delete sends items to the Recycle Bin; Shift + Delete removes them permanently.
    • Turn on file name extensions to recognise file types and fake files.
  3. 3Keyboard Shortcuts4 key points · 3 min read
    • Ctrl + C, Ctrl + X and Ctrl + V copy, cut and paste; Ctrl + Z undoes.
    • Alt + Tab switches windows; Windows + L locks the computer.
    • Windows + Shift + S captures part of the screen.
    • Ctrl + Shift + Esc opens Task Manager to close a frozen program.
  4. 4Web Browsers and Searching4 key points · 3 min read
    • The internet is the network; the web is the collection of pages you open in a browser.
    • https means an encrypted connection, not an honest website.
    • Quotes find an exact phrase, a minus sign excludes a word, and site: searches one site.
    • Private windows do not hide your activity from websites or your network.
  5. 5Email: Etiquette and Attachments4 key points · 3 min read
    • Bcc hides recipients' addresses from each other; Cc does not.
    • Reply all goes to everyone in To and Cc, so use it only when needed.
    • A clear subject, polite tone and checked attachment make a professional email.
    • Share files larger than the attachment limit as a cloud link.
  6. 6Online Safety and UPI/OTP Fraud Awareness4 key points · 3 min read
    • Use long, unique passwords and turn on two-step verification.
    • Entering your UPI PIN approves a payment; you never need it to receive money.
    • Never share an OTP, PIN or CVV with anyone, including callers who claim to be from a bank.
    • Report cyber fraud quickly on 1930 or at cybercrime.gov.in.
  7. 7Cloud Storage and Sharing4 key points · 3 min read
    • Cloud storage keeps files on internet servers that you reach by signing in.
    • DigiLocker is the Government of India's platform for official documents.
    • Sync copies deletions too, so it is not a full backup.
    • Share sensitive files only with named people and give view-only access.

MS Word

For ADCA and MS Office

Create, edit, format and print professional documents in Microsoft Word, from simple letters and tables to long reports with a table of contents and mail-merged letters.

  • 7 lessons
  • About 28 min of reading
  • 35 practice questions
  • 25 key terms
  1. 1Getting Started with MS Word5 key points · 4 min read
    • Word is a word processor for letters, reports and other documents.
    • Commands sit in ribbon tabs and groups; the dialog box launcher opens more options.
    • Word wraps lines automatically, so press Enter only for a new paragraph.
    • Ctrl+S saves, F12 opens Save As, and Word files use the .docx extension.
    • Print Layout view shows the page as it will print.
  2. 2Editing, Proofing and Reviewing Text5 key points · 4 min read
    • Double-click selects a word, triple-click selects a paragraph and Ctrl+A selects everything.
    • Ctrl+X, Ctrl+C and Ctrl+V cut, copy and paste; Ctrl+Z undoes and Ctrl+Y redoes.
    • Ctrl+H opens Find and Replace; Replace All changes every match at once.
    • F7 checks spelling and grammar; a red wavy line marks a possible spelling mistake.
    • Track Changes (Ctrl+Shift+E) records edits so they can be accepted or rejected.
  3. 3Formatting Text and Paragraphs5 key points · 4 min read
    • Character formatting changes letters; paragraph formatting changes whole paragraphs.
    • Ctrl+B, Ctrl+I and Ctrl+U apply bold, italic and underline.
    • Ctrl+L, Ctrl+E, Ctrl+R and Ctrl+J set left, center, right and justified alignment.
    • Bullets suit unordered items and numbering suits steps; Tab and Shift+Tab change list levels.
    • Format Painter copies formatting; double-click it to use it several times.
  4. 4Page Layout, Headers, Footers and Printing5 key points · 4 min read
    • The Layout tab controls margins, orientation, paper size and columns.
    • Ctrl+Enter inserts a page break; section breaks allow different layouts in one document.
    • Headers and footers repeat on every page; inserted page numbers update automatically.
    • Watermark, Page Color and Page Borders are on the Design tab.
    • Ctrl+P opens Print, with settings for copies, page ranges and a preview.
  5. 5Working with Tables5 key points · 4 min read
    • A table is made of rows, columns and cells.
    • Tab moves to the next cell, and Tab in the last cell adds a new row.
    • Merge Cells joins cells into one; Split Cells divides one cell.
    • Layout > Formula with =SUM(ABOVE) totals a column, but the result is updated with F9.
    • Repeat Header Rows shows the heading row on every page of a long table.
  6. 6Pictures, Shapes and Other Objects5 key points · 4 min read
    • Pictures, shapes, icons, SmartArt and charts are all on the Insert tab.
    • The Picture Format tab offers Crop, Picture Styles, corrections and Alt Text.
    • Wrap Text controls how text flows around a picture; In Line with Text is the default.
    • Hold Shift while drawing a shape to keep it perfectly round or square.
    • Ctrl+K inserts a hyperlink, and Symbol inserts characters such as ₹.
  7. 7Styles, Table of Contents and Mail Merge5 key points · 4 min read
    • A style is named formatting; Normal, Heading 1 and Heading 2 are common styles.
    • Modifying a style updates every paragraph that uses it.
    • References > Table of Contents builds a contents list from heading styles; Update Table refreshes it.
    • Mail merge combines a main document with a data source through merge fields.
    • The mail merge commands are on the Mailings tab, ending with Finish & Merge.

MS Excel

For ADCA and MS Office

Work with cells, ranges and formulas in Microsoft Excel, use functions such as SUM, IF, VLOOKUP and XLOOKUP, and sort, filter, chart and print your data.

  • 7 lessons
  • About 27 min of reading
  • 35 practice questions
  • 25 key terms
  1. 1Getting Started with Excel5 key points · 4 min read
    • A workbook (.xlsx) contains worksheets made of columns, rows and cells.
    • A cell address is the column letter followed by the row number, such as B4.
    • A range such as A1:C5 uses a colon to mean "from A1 to C5".
    • Text aligns left and numbers align right by default; ##### means the column is too narrow.
    • The fill handle continues series such as Jan, Feb, Mar.
  2. 2Formatting Cells and Worksheets5 key points · 3 min read
    • Formatting changes how a value looks, not the value itself.
    • Ctrl+1 opens Format Cells, where you can choose formats such as Currency with the ₹ symbol.
    • Gridlines do not print by default; use Borders for tables you will print.
    • Wrap Text, Merge & Center and AutoFit help data fit neatly.
    • Conditional Formatting changes a cell's look automatically based on its value.
  3. 3Formulas and Basic Functions5 key points · 4 min read
    • Every formula starts with =; use cell references so results update automatically.
    • Excel calculates brackets first, then powers, then * and /, then + and -.
    • COUNT counts cells with numbers, while COUNTA counts cells that are not empty.
    • AVERAGE ignores empty cells but includes zeros.
    • Alt+= inserts AutoSum; errors such as #DIV/0!, #NAME? and #REF! point to the cause of a problem.
  4. 4Relative, Absolute and Mixed References5 key points · 4 min read
    • Relative references (A1) change when a formula is copied; this is the default.
    • Absolute references ($A$1) stay fixed wherever the formula is copied.
    • Mixed references ($A1 or A$1) lock only the column or only the row.
    • F4 cycles through the reference types while you edit a formula.
    • Use an absolute reference or a named cell for one value, such as a rate, used by many formulas.
  5. 5Decisions and Lookups: IF, VLOOKUP and XLOOKUP4 key points · 4 min read
    • IF(test, value_if_true, value_if_false) returns one of two results; text results go in double quotes.
    • VLOOKUP searches the first column of a table and returns a value from a column to its right.
    • Use FALSE as VLOOKUP's last argument for an exact match; a value that is not found gives #N/A.
    • XLOOKUP needs Microsoft 365 or Excel 2021 and later; it matches exactly by default and can return from any column.
  6. 6Sorting and Filtering Data5 key points · 4 min read
    • Keep one heading row and no blank rows inside a list you want to sort or filter.
    • Sort A to Z or Z to A sorts whole rows; Data > Sort sorts by several columns.
    • Filter (Ctrl+Shift+L) hides rows that do not match, without deleting them.
    • Ctrl+T turns a list into an Excel Table with automatic filters and formatting.
    • Freeze Top Row keeps the headings visible while you scroll.
  7. 7Charts and Printing5 key points · 4 min read
    • Select the data with its headings and use Insert > Recommended Charts or a chart type.
    • Column charts compare categories, line charts show change over time and pie charts show parts of a whole.
    • The Chart Design and Format tabs add titles, labels and styles; charts update when the data changes.
    • Fit Sheet on One Page, Print Area and Print Titles control what prints and how.
    • Gridlines do not print unless you tick Gridlines > Print.

MS PowerPoint

For ADCA and MS Office

Build clear, attractive presentations in Microsoft PowerPoint with layouts, themes, pictures, charts, transitions and animations, then deliver them confidently as a slide show.

  • 7 lessons
  • About 28 min of reading
  • 35 practice questions
  • 25 key terms
  1. 1Getting Started with PowerPoint5 key points · 4 min read
    • A presentation is a set of slides; PowerPoint files use the .pptx extension.
    • Normal view has the slide thumbnails pane, the slide pane and the Notes pane.
    • Slide Sorter view is best for rearranging slides.
    • Speaker notes are for the presenter and do not appear on the slide.
    • Plan the purpose, audience and outline first, and keep one main idea per slide.
  2. 2Slides, Layouts and Text5 key points · 4 min read
    • Ctrl+M adds a new slide; a layout sets which placeholders a slide has.
    • Tab demotes a bullet to a sub-point and Shift+Tab promotes it.
    • Ctrl+D duplicates the selected slide, and Hide Slide skips a slide during the show.
    • If AutoFit is shrinking your text, split the content across more slides.
    • Speaker notes go in the Notes pane and can be printed as Notes Pages.
  3. 3Themes, Backgrounds and the Slide Master5 key points · 4 min read
    • A theme applies matching colours, fonts and backgrounds; Variants offer other colour schemes.
    • Widescreen (16:9) is the default slide size; Standard (4:3) is also available.
    • Format Background with Apply to All changes the background of every slide.
    • The Slide Master (View > Slide Master) controls the look of all slides, such as a logo on every slide.
    • Insert > Header & Footer adds slide numbers, the date and footer text.
  4. 4Pictures, Shapes, SmartArt and Charts5 key points · 4 min read
    • Pictures, shapes, SmartArt, tables, charts, icons and media are added from the Insert tab.
    • Hold Shift to draw a perfect circle or square; Ctrl+D duplicates an object.
    • Ctrl+G groups objects, and Align and Distribute line them up evenly.
    • Convert to SmartArt turns a bulleted list into a diagram.
    • A chart in PowerPoint opens a small spreadsheet window for its data.
  5. 5Slide Transitions5 key points · 4 min read
    • A transition is the effect as one slide changes to the next, and it plays as its slide enters.
    • Transitions are set on the Transitions tab; Effect Options change the direction.
    • Apply To All gives every slide the same transition.
    • After moves to the next slide automatically after a set time; On Mouse Click waits for the presenter.
    • Morph (Microsoft 365, PowerPoint 2019 and later) smoothly moves objects between two similar slides.
  6. 6Animations5 key points · 4 min read
    • Animations move objects on a slide; transitions move between slides.
    • The four types are Entrance, Emphasis, Exit and Motion Paths.
    • Choosing a new effect from the gallery replaces the old one; Add Animation adds a second effect.
    • On Click, With Previous and After Previous control when an animation starts.
    • The Animation Pane lists and reorders every animation on a slide.
  7. 7Presenting the Slide Show5 key points · 4 min read
    • F5 starts the show from the beginning, Shift+F5 from the current slide, and Esc ends it.
    • During the show, B blanks the screen and a slide number followed by Enter jumps to that slide.
    • Presenter View shows your notes, the next slide and a timer while the audience sees only the slide.
    • Set Up Slide Show can run a looping kiosk show, and Hide Slide skips a slide.
    • Handouts with 3 slides per page include lines for notes; Export can create a PDF or a video.

Typing

For ADCA, Basic computer and Typing

Learn touch typing the right way: posture, the home row, which finger presses which key, accuracy before speed, measuring WPM, a daily practice plan and the basics of Hindi typing.

  • 7 lessons
  • About 22 min of reading
  • 20 practice questions
  • 25 key terms
  1. 1Touch Typing and Correct Posture4 key points · 3 min read
    • Touch typing uses all ten fingers without looking at the keyboard.
    • Sit upright with feet flat, elbows at about 90 degrees and wrists straight.
    • Keep the monitor about an arm's length away, top of screen at or below eye level.
    • Press keys lightly and take short breaks to protect your hands and eyes.
  2. 2The Home Row4 key points · 3 min read
    • The home row keys are A S D F for the left hand and J K L ; for the right.
    • The bumps on F and J help you find the home row without looking.
    • Every finger reaches, presses and returns to its home key.
    • Use one thumb consistently for the space bar.
  3. 3The Finger-to-Key Map4 key points · 3 min read
    • Each finger covers a slanting column of keys above and below its home key.
    • The index fingers each cover two columns; the little fingers cover the edge keys.
    • Use the Shift key on the opposite side from the letter you are typing.
    • On the numeric keypad, rest on 4, 5 and 6; the 5 key has a bump.
  4. 4Accuracy Before Speed4 key points · 3 min read
    • Accuracy comes first; speed grows when correct movements become automatic.
    • Never look at the keys; use the bumps on F and J to find your place.
    • Type to a steady, even rhythm instead of in bursts.
    • Practise your weak keys and letter pairs with short targeted drills.
  5. 5Measuring Speed and Accuracy4 key points · 3 min read
    • A standard word is 5 characters, including spaces and punctuation.
    • Gross WPM is total characters divided by 5, divided by the minutes.
    • Net WPM subtracts a penalty for uncorrected errors; accuracy is correct characters as a percentage.
    • Different tests use different rules, so read the official instructions for yours.
  6. 6Building a Practice Plan4 key points · 3 min read
    • Practise 20 to 30 minutes every day rather than in long, occasional sessions.
    • Each session should include a warm-up, weak keys, word drills, passages and one timed test.
    • Practise with real material that includes capitals, numbers and punctuation.
    • Plateaus are normal; slow down, focus on accuracy and drill weak letter pairs.
  7. 7Hindi Typing Basics5 key points · 4 min read
    • Unicode Hindi works everywhere; legacy-font text needs that exact font installed.
    • Inscript is the standard layout, with vowels mostly on the left and consonants on the right.
    • Remington comes from Hindi typewriters; skill on one layout does not transfer to the other.
    • Windows key + Space switches between English and Hindi keyboards.
    • In Unicode, matras follow the consonant, and the halant joins consonants into conjuncts.

In the student portal

Practise until you are sure, then take the exam.

Students of the institute and its member centres sign in to read these study books lesson by lesson and test themselves on each one. Your centre gives you your login when you enrol.

  • 6study books
  • 195practice questions
  • 150glossary terms
  • Fresh questions each time

    Each test is a random set of up to 20 questions from the study book’s question bank.

  • One minute per question

    A timer counts down while you answer, as in an exam hall.

  • Every answer explained

    At the end you see the right answer and an explanation for each question.

  • Typing speed test

    Practice passages in English and Hindi, with your words per minute and accuracy kept in your results.

Free ebooks

15 free ebooks for computer courses.

Branded PDF ebooks anyone can read or download: open a title for its contents page, or download the PDF straight away.

Good to know

Who these courses are for.

  • Useful for

    • Office, front-desk and data-entry work
    • School and college assignments
    • Everyday computer use at home and in a small business
  • Who can join

    • Students above 12 years of age can take admission
    • At the Delhi head office or an authorised member centre
    • Beginners, school leavers and working adults
  • Study notes

    • Gurukul E-Notes, online notes for students, cover basic computer, MS Office and the internet
    • Your centre gives you the course material

Admission

From your first question to your certificate.

The usual steps, at the head office or at a member centre.

Start with a question
  1. Ask about the course

    Call or WhatsApp the head office, or visit your nearest member centre. Ask for the duration, the fee and the batch timings in writing.

  2. Fill the admission form

    Admission forms are supplied by the head office to every centre.

  3. Learn in class

    Attend your batch at the centre, with the course material, the study books in the student portal and study notes.

  4. Take the exam

    The institute prefers written exams, taken in front of a teacher.

  5. Receive your certificate

    Students who pass get a Gurukul Technicals Institute certificate and marksheet. Employers can ask the head office to verify it.

Questions about computer courses

Still have a question?

Chat on WhatsApp
Who can take admission?

Students above 12 years of age can take admission. Tell the head office or your centre what you already know, and they will suggest where to start.

How long is the course and what is the fee?

Duration, fees and batch timings depend on the course and the centre. Ask the head office or your nearest member centre, and get the details in writing before you pay.

Where are the classes?

At the head office in Delhi (A-10, Chief Commissioner Colony, opposite Rana Pratap Bagh) and at authorised member centres. Call or WhatsApp the head office to find the nearest centre.

Is there an exam and a certificate?

Yes. The institute prefers written exams, taken in front of a teacher. Students who pass receive a Gurukul Technicals Institute certificate and marksheet, which the head office verifies on request.

What study material comes with the course?

Students of the institute and its member centres sign in to the student portal to read 6 study books for these courses (Computer Fundamentals, Windows, Internet and Email, MS Word, MS Excel, MS PowerPoint, Typing) and take timed practice tests. The free ebooks on this page can be downloaded by anyone.

Are study notes provided?

Students of the institute and its member centres get Gurukul E-Notes, online study notes. For these courses they cover basic computer, MS Office and the internet.

GTI Franchise Network

Teach computer courses at your own centre.

Member centres run the institute’s courses under their own name, with exams, certificates and support from the head office.

An instructor teaching a class of students seated with robotics kits and computers
WhatsApp us