Basic Computer Skills: Hands-On Training for Beginners

Computer Basics, Basic Computer Course, Windows 11 Basics, Microsoft Word, PowerPoint, Excel, Basic Computer Skills

Parts of Computer, Difference between Data and Information, Information Processing Cycle
Computer Hardware
Keyboard, QWERTY Layout, Alphanumeric Keys, Function Keys, Cursor Movement Keys, Modifier Keys
The different variants of mouse
Video and Sound, Printers
How Computer Processes Data, The Central Processing Unit, RAM, Cache Memory, Buses
Modern CPUs
Microsoft Word Basics
Microsoft Powerpoint Basics
Microsoft Excel Basics
Storage Devices (Magnetic Storage devices, Optical Storage Devices, Solid State Drives)
Computer Networks (Basics)
Internet and World Wide Web

Course Content

Essential Computer Setup & Navigation

Using AI to Answer Your Questions and Learn Faster
Turning Your Computer On, Off, Restarting, and Putting It to Sleep
Using a Mouse and Keyboard: Essential Skills for Beginners
Mastering Left Click, Right Click, Selecting, and Drag & Drop

Working with Windows Operating System

Installing, Removing, and Managing Apps

Device Settings and Everyday Adjustments

Typing, Text, and Document Handling

How to Create Files and Folders

Microsoft Word

Microsoft Word – Launching
MS Word – User Interface
MS Word English – Save and Save As
Home Tab -English Font Group Commands NEW
MS Word-Bullets and Numbering
Microsoft Word – MultiList Level
Microsoft Word Text Alignments – Line and Paragraph Spacing
Microsoft Word – SORT Command Functionality
Microsoft Word – Color Shading and Text Borders
MS Word – Text Styles and Table of Contents I known as Index
MS Word – Find and Replace
MS Word – Copy Paste Functions
MS Word – Insert Tabe – Pages Group – Page Cover and Blank Page and Page Br
MS Word – Table – All Table Tools Explained
MS Word – Insert Pictures and Edit Pictures
MS Word – Shapes, Icons, 3D Models Explained
MS Word – Smart Art, Charts and Screenshot utilities
MS Word – Links to WebPages
MS Word – Links to Existing Files
MS Word-Book Marks and HyperLinks
MS Word-Headers Footers and Page Numbers
MS Word-How to Insert Objects
MS Word-Insert Text from File
MS Word- Water Marks
MS Word-LayoutTab-Page Margins, Orientation, Size, Columns, Hyphanesation an
MS Word-Layout-Paragraph Indent, Spacing-Backward-Forward
MS Word-Page Borders, Page Colors
MS Word- Mail Merge – Complete Process with Real Time Mails and Documents
MS Word-Review-Spelling and Grammar-Set Proofing Language
MS Word-Review- Disable Auto-Hyper Links
MS Word-Protection-Document Protection and Data Protection

MS Excel – Beginner to Advanced

Download Practice Excel Files Here
E1.1 How to Launch MS Excel
E1.2 Start Screen – Back Stage Screen – Navigating MS Excel
E1.3 User Interface – Navigating MS Excel Workbook Screen
E1.4 Home Tab – Basic Editing Tools
E1.5 Copy and Paste I using Multiple Tools in MS Excel
E2.1 Customize Ribbon Bar – Tabs, Groups, Commands I Tools
E2.2 Text to Column – Multiple methods
E2.3 Speak Cells – Data Reading Tool
E2.4 Comments – Add, Edit, Delete, Copy Paste, Background change
E2.5 Filters in MS Excel
E2.6 Freeze Panes and Split Window
E2.– Basic Tools to Know
Fill Series – Basics, Advanced, Flash Fill
Conditional Formatting
Hyperlinks to Sheets, Web pages, Files
Header and Footer Settings
Printing and Paper Settings
Import Data from Web
Import Data from Text File with Auto Refresh
Import Objects into Excel
Fill Series and Data, Sheet Control
Characteristics of a cell
Cell References – Relative Ref, Absolute Ref, Mixed Ref
Custom View
Sheet protection
Cell Protection
Compare sheets side by side I View Sheets side by side
Compare sheets from Multiple Files
Working with cells, rows, columns, Specific Size, Auto Fit
Working with sheets rename, colour, copy, move, grouping
Working with Sheets in MS Excel

Things to remember before starting formulas

SUM
SUMIF
SUMIFS
SUBTOTAL
AGGREGATE
SUMPRODUCT
SUMSQ
SUMX2MY2, SUMX2PY2, SUMXMY2 I Maths and Trigonometry
DSUM – DATA BASE SUM
IMSUM vs IMSUB – Complex Data Calculations
Sum Related Formulas”

Count Related Formulas

Logical IF-Related Formulas in MS Excel

LOGICAL TEST with Comparative Operators
IF
IF AND vs IF OR
IFS vs NESTEDIF
IFERROR
SWITCH
Logical IF-Related Formulas in MS Excel
LEFT, RIGHT, MID and LEN
FIND vs SEARCH
REPLACE vs SUBSTITUTE

Text Formatting and Conversion

PMT – EMI Calculator

Using TODAY, NOW
DATE, DATEVALUE, TIME, TIME VALUE
DATEDIF AND EXTRACT YEARS, MONTHS, DAYS, HOURS, MIN, SECONDS
Calculating Future and Past Dates -EDATA, EOMONTH, WORKINGDAYS, NET WORKIN
Calculate Days using – DAY, DAYS, NETWORKING DAYS
Calculate Hours and Hourly Charges
Date and Time Related Formulas – MCQs
PPMT, IPMT – Loan Statement Preparation
FV – Investment Calculator

DATA SEARCH – Lookup related formulas

VLOOKUP – Basics – Rules – Exact Match – Approx Match
HLOOKUP – Basics
XLOOKUP Function – with VBA Code
MATCH Function vs INDEX Function
VLOOKUP-Advanced-1-Applying across multiple cells at a time
VLOOKUP-Advanced-2-Applying across multiple sheets
VLOOKUP-Advanced-3-Applying on large data
VLOOKUP-Advanced-4-Applying across multiple workbooks
DATA SEARCH – Lookup related formulas

Automation

Complete Billing Automation – Invoice Design, Tax Calculation, Logo n more
Comparison Table Perpetual Dashboards vs Interactive-Dynamic Dashboards
Perpetual-Static Dashboards I Part-1 I Creating KPI Key Performing Indicator
Perpetual-Static Dashboards I Part-2 I KPIs to Visualization
Interactive-Dynamic Dashboards I Creating Connected KPI I Connect Dashboar
Financial Reporting Dashboards Sales, Profit, Country wise, Product Wise
EXCEL Projects, Dashboards, Infographics, and Data Visualization
Excel Basics – 100 Interview Questions and Answers PDF
Excel Advanced – 100 Interview Questions and Answers
Excel with ChatGPT Interview Questions and Answers
TOP Companies Interview Questions and Answers for Different roles
Key Points and Samples Resumes

Microsoft PowerPoint – Full Course

How to Launch Microsoft PowerPoint
An introduction to User Interface
MS Power Point – Design Slide Background-NEW
MS PPT – Transition Basics
MS PPT – Animations
Text Gradient Effects
Hyper Link – Links to Product Pages, Web Pages
Project -1 – Department of Tourism
Project-2 – learn to create 10 options Infographic Presentation
Project-3 8 Option Page Style Info Graphic Presentation

Basic Computer Skills: Hands-On Training for Beginners

What Will You Learn?

Requirements

Course Content

Essential Computer Setup & Navigation

Using AI to Answer Your Questions and Learn Faster

Turning Your Computer On, Off, Restarting, and Putting It to Sleep

Using a Mouse and Keyboard: Essential Skills for Beginners

Mastering Left Click, Right Click, Selecting, and Drag & Drop

Working with Windows Operating System

Navigating Your Desktop: Icons, Taskbar, and Start Menu

Opening, Minimizing, Resizing, and Closing Windows

File Explorer and Finder: Managing Folders and Files

Using the Recycle Bin or Trash and Restoring Deleted Files

Essential Shortcuts: Copy, Paste, Undo, Redo, Select All

Installing, Removing, and Managing Apps

How to Download and Install Apps from Safe Sources

Uninstalling or Deleting Programs You No Longer Need

Finding Installed Apps Quickly Using the Search Bar

Managing Startup Apps That Slow Down Your Computer

Device Settings and Everyday Adjustments

Adjusting Volume, Brightness, and Display Preferences

Customizing Your Desktop Wallpaper and Theme

Adding a Second Monitor or Projector

Connecting a Mouse, Keyboard, or Webcam

Troubleshooting: Device Not Recognized

Typing, Text, and Document Handling

Opening, Saving, and Closing Text Documents

Selecting, Editing, and Moving Text Like a Pro

Using Spell Check and Word Count Tools

Typing Practice Tips to Build Speed and Accuracy

How to Create Files and Folders

Delete Functions – Temporary and Permanent Delete

How to Check System Configuration, CPU, Ram, HDD, Background Application and

Device Manager – Learn How to Enable and Disable Devices of a Computer

Account Login Settings – Enable and Disable Security

System Cleanup – Temp, Recent, Recycle bin cleaning

F1 to F12 Shortcut Keys

Computer Basics Quiz

Microsoft Word

Microsoft Word – Launching

MS Word – User Interface

MS Word English – Save and Save As

Home Tab -English Font Group Commands NEW

MS Word-Bullets and Numbering

Microsoft Word – MultiList Level

Microsoft Word Text Alignments – Line and Paragraph Spacing

Microsoft Word – SORT Command Functionality

Microsoft Word – Color Shading and Text Borders

MS Word – Text Styles and Table of Contents I known as Index

MS Word – Find and Replace

MS Word – Copy Paste Functions

MS Word – Insert Tabe – Pages Group – Page Cover and Blank Page and Page Br

MS Word – Table – All Table Tools Explained

MS Word – Insert Pictures and Edit Pictures

MS Word – Shapes, Icons, 3D Models Explained

MS Word – Smart Art, Charts and Screenshot utilities

MS Word – Links to WebPages

MS Word – Links to Existing Files

MS Word-Book Marks and HyperLinks

MS Word-Headers Footers and Page Numbers

MS Word-How to Insert Objects

MS Word-Insert Text from File

MS Word- Water Marks

MS Word-LayoutTab-Page Margins, Orientation, Size, Columns, Hyphanesation an

MS Word-Layout-Paragraph Indent, Spacing-Backward-Forward

MS Word-Page Borders, Page Colors

MS Word- Mail Merge – Complete Process with Real Time Mails and Documents

MS Word-Review-Spelling and Grammar-Set Proofing Language

MS Word-Review- Disable Auto-Hyper Links

MS Word-Protection-Document Protection and Data Protection

MS Excel – Beginner to Advanced

Download Practice Excel Files Here

E1.1 How to Launch MS Excel

E1.2 Start Screen – Back Stage Screen – Navigating MS Excel

E1.3 User Interface – Navigating MS Excel Workbook Screen

E1.4 Home Tab – Basic Editing Tools

E1.5 Copy and Paste I using Multiple Tools in MS Excel

E2.1 Customize Ribbon Bar – Tabs, Groups, Commands I Tools

E2.2 Text to Column – Multiple methods