Computer Basics and MS Office - Complete Tutorial

Sundeep Saradhi Kanthety via YouTube

Start learning Write review

Details

Start learning

Provider

YouTube
Pricing

Free Video
Languages

English
Duration & workload

22 hours 3 minutes
Sessions

On-Demand
Level

Beginner

Found in

Learn computer fundamentals and Microsoft Office applications through this comprehensive course covering hardware assembly, operating systems, and productivity software. Master PC building from component selection to assembly, understand computer memory types and virus protection, and explore internet basics and system configuration. Develop proficiency in MS Paint for basic graphics editing before progressing to the complete MS Office suite. Gain expertise in MS Word through text formatting, paragraph styling, page layouts, mail merge, watermarking, headers and footers, and hyperlink creation. Build advanced Excel skills including cell manipulation, formulas, VLOOKUP functions, data validation, conditional formatting, pivot tables, and various chart types, plus master specialized functions for text manipulation, date calculations, and data analysis. Create professional presentations in PowerPoint with custom layouts, animations, transitions, image editing, and multiple export formats. Enhance your computer literacy with keyboard shortcuts, file management, system utilities like Task Manager, and Windows customization techniques including registry modifications and command prompt operations. Apply practical tips for screen capture, internet speed testing, and advanced Excel features like freezing panes and linking data between applications, while also exploring modern AI tools like ChatGPT for productivity enhancement.

Syllabus

Complete PC Assembling Guide (2025) | Learn to Build a Computer at Home
CREATION OF BOOTABLE PENDRIVE FOR STORING ISO IMAGE || BOOTABLE USB || BOOTABLE PENDRIVE
HOW TO INSTALL WINDOWS 10 ( STEP BY STEP )
COMPUTER LANGUAGES(MACHINE LANGUAGE-ASSEMBLY LANGUAGE-HIGH LEVEL LANGUAGE) AND LANGUAGE TRANSLATORS
WHAT IS BOOTING PROCESS || HARD BOOTING & SOFT BOOTING || COMPUTER BOOTING PROCESS
COMPUTER MEMORY || TYPES OF MEMORY || MEASURING COMPUTER MEMORY
WHAT IS COMPUTER VIRUS ? || TYPES OF VIRUSES || MALICIOUS SOFTWARE (VIRUS)
INTERNET BASICS || BASICS OF INTERNET || HOW INTERNET WORKS ?
CONFIGURATION OF DESKTOP/LAPTOP || SYSTEM CONFIGURATION || COMPUTER CONFIGURATION
MS-PAINT COMPLETE TUTORIAL || PAINT TUTORIAL || MS PAINT APPLICATION
INTRODUCTION TO MS-OFFICE || MS-OFFICE
INTRODUCTION TO MS-WORD PART - 1 || MS WORD INTRODUCTION || MS WORD BASICS
TEXT FORMATTING OPTIONS - MS-WORD PART-2
PARAGRAPHS AND STYLES - MS-WORD PART-3
PAGE BORDERS AND SHADING - MS-WORD PART-4
INSERTING TABLES AND SHAPES - MS-WORD PART-5
PAGE LAYOUTS - MS-WORD PART-6
MAIL MERGE - MS-WORD PART-7
WATERMARKING - MS-WORD PART 8
HEADER & FOOTER , PAGE NUMBER - MS-WORD PART - 9 || PAGE NUMBERING || HEADER || FOOTER IN WORD
HYPERLINKS - MS-WORD PART - 10 || HYPERLINKS
INTRODUCTION TO MS-EXCEL PART - 1 || MS EXCEL INTRODUCTION || MS EXCEL BASICS
WORKING ON CELLS - MS EXCEL PART - 2
TEXT FORMATTING - MS EXCEL PART - 3
ALIGNMENT - MS EXCEL PART- 4
BASIC FORMULA - MS EXCEL PART- 5
VLOOKUP - MS EXCEL PART- 6
PROTECTING SHEET AND WORKBOOK - MS EXCEL PART - 7
DATA VALIDATION - MS EXCEL PART - 8
CONDITIONAL FORMATTING - MS EXCEL PART - 9
FREEZE PANES - MS EXCEL PART - 10
PRINT TITLES IN EXCEL || REPEAT TITLES IN EVERYPAGE IN EXCEL - MS EXCEL PART - 11
TEXT TO COLUMNS - MS EXCEL PART - 12
SUBTOTAL - MS EXCEL PART - 13
IF FUNCTION - MS EXCEL PART - 14
NESTED - IF FUNCTION - MS EXCEL PART - 15
MATCH & INDEX FUNCTIONS - MS EXCEL PART - 16 || MATCH FUNCTION || INDEX FUNCTION
COUNT( ), COUNTIF( ) & COUNTIFS( ) - MS EXCEL PART - 17
COLUMN CHART - MS EXCEL PART - 18
PIE CHART(2-D PIE, 3-D PIE & DOUGHNUT) - MS EXCEL PART - 19
REMOVE DUPLICATES - MS EXCEL PART - 20
SPLIT AND JOIN TEXT IN EXCEL || SPLIT TEXT TO COLUMNS || CONCATENATE TEXT || MS-OFFICE
PROPER( ) , LOWER( ) , UPPER( ) FUNCTIONS IN EXCEL
AGE CALCULATION (IN YEARS, MONTHS, DAYS) USING DATEDIF FUNCTION IN EXCEL || MSOFFICE
NUMBER CONVERSION FUNCTIONS IN EXCEL || MS-OFFICE
NOW( ) , TODAY( ) FUNCTIONS IN EXCEL || WORKING ON DATES || MS-OFFICE
HOW TO GET EMOJIS IN EXCEL || INSERTION OF EMOJIS IN EXCEL || MS-OFFICE
LINKING CELLS FROM DIFFERENT SHEETS IN EXCEL || EXCEL SHEETS || MS-OFFICE
LARGE( ) AND SMALL( ) FUNCTIONS IN EXCEL || LARGE AND SMALL FUNCTIONS || MS-OFFICE
CONVERT( ) FUNCTION IN EXCEL || UNIT CONVERSION IN EXCEL || MS-OFFICE
RANDOM NUMBER GENERATOR FUNCTIONS IN EXCEL || rand( ) & randbetween( ) in EXCEL || MS-OFFICE
ROUND( ) , ROUNDUP( ) , ROUNDDOWN( ) AND TRUNC( ) FUNCTIONS IN EXCEL || MS-OFFICE || MS-EXCEL
INTRODUCTION TO POWERPOINT PART - 1 || POWERPOINT INTRODUCTION || POWERPOINT BASICS
LAYOUT & DESIGN IN POWERPOINT PART - 2 || MS-OFFICE || POWERPOINT BASICS
INSERT TEXT IN POWERPOINT PART - 3 || MS-OFFICE || POWERPOINT BASICS
INSERT MENU (ALL OPTIONS) IN POWERPOINT PART - 4 || MS-OFFICE || POWERPOINT
BACKGROUND REMOVAL OF AN IMAGE IN POWERPOINT PART - 5 || HOW TO REMOVE BACKGROUND OF AN IMAGE
TRANSITIONS ON SLIDES IN POWERPOINT PART - 6 || HOW TO ADD TRANSITIONS TO SLIDES || MS-OFFICE
HOW TO APPLY ANIMATIONS IN POWERPOINT PART - 7 || ANIMATIONS IN POWERPOINT || MSOFFICE
IMAGE FORMATTING OPTIONS IN POWERPOINT PART - 8 || IMAGE EDITING OPTIONS || MS-OFFICE || POWER POINT
SAVE AS OPTION IN POWERPOINT (PDF-MP4-JPG-GIF-BMP) PART - 9 || SAVE SLIDES IN DIFFERENT FORMATS
FUNCTIONAL KEYS IN KEYBOARD (F1 TO F12)
FILE EXTENSIONS || LIST OF FILE EXTENSIONS || HOW TO ENABLE FILE EXTENSION - COMPUTER BASICS
RUN COMMAND SHORTCUTS || SHORTCUTS IN RUN WINDOW || BASICS OF COMPUTER
WINDOWS BUTTON SHORTCUTS || START BUTTON SHORTCUTS || BASICS OF COMPUTER
NOTEPAD COMPLETE TUTORIAL || NOTEPAD TUTORIAL || NOTEPAD APPLICATION
CONTROL BUTTON SHORTCUTS || CONTROL SHORTCUTS || BASICS OF COMPUTER
PORTS AND CONVERTERS IN COMPUTER || TYPES OF PORST AND CONVERTERS || BASICS OF COMPUTER
SHIFT BUTTON SHORTCUTS || SHORTCUTS ON SHIFT BUTTON || BASICS OF COMPUTER
TASK MANAGER IN COMPUTER || TASK MANAGER || COMPUTER PERFORMANCE || COMPUTER BASICS
DATE & TIME OPTION - DISPLAY MULTIPLE CLOCKS || CHANGE DATE AND TIME || BASICS OF COMPUTER
MOUSE AND KEYBOARD PROPERTIES || CHANGING MOUSE POINTERS || CHNAGE KEYBOARD OPTIONS
HOW TO CHANGE FOLDER ICON || CHANGE ICON OF FOLDER || CUSTOMIZED ICON FOR FOLDER
AUTOPLAY OPTION FOR REMOVABLE DRIVES || AUTOPLAY FILES AND FOLDERS || BASICS OF COMPUTER
CUSTOMIZE TASKBAR ICONS IN WINDOWS 10 || HOW TO MAKE TASKBAR ICONS VISIBLE OR HIDDEN IN WINDOWS 10
SHORTCUT FOR SHUTDOWN AND RESTART IN WINDOWS 10 || HOW TO CREATE SHORTCUT FOR SHUTDOWN AND RESTART
ON-SCREEN (VIRTUAL) KEYBOARD IN WINDOWS 10 || VIRTUAL KEYBOARD || WINDOWS 10
MOUSE POINTER AND TEXT CURSOR SETTINGS IN WINDOWS 10 || WINDOWS 10
BASIC 50 COMPUTER TERMINOLOGY || COMPUTER TERMINOLOGY || COMPUTER BASICS
BUILT-IN SCREEN CAPTURE AND RECORDER IN WINDOWS 10 || SCREEN RECORDER AND CAPTURE || WINDOWS 10 TIPS
HOW TO CHECK INTERNET DOWNLOAD AND UPLOAD SPEED || SPEED TEST
HOW TO ENABLE SECONDS IN SYSTEM CLOCK || SECONDS IN SYSTEM TIME || REGISTRY HACKS || REGEDIT
REMOVAL OF SHORTCUT ARROWS ON ICONS IN WINDOWS 10 || REGISTRY HACKS
REMOVAL OF RUN HISTORY IN WINDOWS 10 || CLEAR RUN HISTORY || REGISTRY HACKS
HOW TO HIDE DISK DRIVES IN THIS PC / MY COMPUTER || REGISTRY HACKS
COMMAND PROMPT (DOS PROMPT) TRICKS & TIPS IN WINDOWS || COMMAND PROMPT HACKS
HOW TO FREEZE MULTIPLE ROWS & COLUMNS IN EXCEL || MS-EXCEL || FREEZE PANES OPTION || MS-OOFICE
Master MS Office in 7 Hours! Word, Excel & PowerPoint Full Course || Complete Tutorial
LINKING EXCEL TO WORD || MS-OFFICE TRICKS || WORD & EXCEL
IDENTIFYING BLANK CELLS OR MISSING DATA IN EXCEL || MS-OFFICE TRICKS || WORD & EXCEL TIPS & TRICKS
What is ChatGPT ? || How to use ChatGPT ? || AI ChatBot || OpenAI
COMPUTER KEYBOARD SHORTCUTS || CTRL, SHIFT, RUN COMMAND SHORTCUTS || SHORTKEYS || WINDOWS OS

Taught by

Sundeep Saradhi Kanthety

Reviews

5.0 rating, based on 3 Class Central reviews

Start your review of Computer Basics and MS Office - Complete Tutorial

Muhammad Aftab Ashraf
1

I recently completed the course Computer Basics and MS Office – Complete Tutorial and it was very helpful for me. The course explains computer fundamentals in a simple and easy way, which is great for beginners. I learned important MS Office skills like MS Word, Excel, and PowerPoint that are very useful for office work and daily tasks. The lessons were clear, practical, and easy to follow. This course improved my confidence in using computers. I highly recommend it to students, job seekers, and anyone who wants basic computer and MS Office skills.
Mohamed Rafi

Completing a free online computer course was an incredibly rewarding experience. The course was well-structured, easy to follow, and perfect for beginners as well as those looking to refresh their skills. The lessons covered essential topics like basic computer operations, internet usage, and common software applications. I especially appreciated the practical exercises, which helped reinforce what I learned. The flexibility of studying at my own pace made it convenient to balance with other responsibilities. Despite being free, the quality of content was impressive and professionally delivered. Overall, this course boosted my confidence and improved my digital skills significantly.
Tu Ka

Amazingggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg