Windows

Introduction

  • Hardware, Software
  • Desktop, Task Bar, Icons,
  • Input & Output Device
  • Data Storage – Drive C: , D: … ,
  • Storage Capacity – GB, MB
  • Folder & File
  • Hard Disk Drive, HDD Partitions
  • Cut, Copy, Paste (Right Click Options),
  • Delete, Recycle Bin

Desktop Operations

  • View : Icon (Large, Medium, Small)
  • Auto Arrange Icon
  • Align Icons to grid
  • Show desktop icons
  • Sort by
  • Name | Size | Item Type | Date Modified
  • Personalize
  • Desktop Theme | Screen Saver
  • Sorting, Screen Saver
  • Taskbar

Windows Inbuilt Softwares

  • Paint Brush
  • Notepad

Connecting Peripherals

  • Keyboard | Mouse
  • Power Cable | VGA Cable | Lan Cable

Installation

  • Basic Softwares
  • Fonts
  • Drivers

MS-Word

Office Button

  • New | Open | Save | Save as
  • Print | Print Preview

Home

Insert

  • Cover Page | Blank Page | Page Break
  • Table | Design & Layout
  • Rows, Columns, Cells – Cut, Copy, Delete, Insert, Add Row in last
  • Merge | Split | Autofit | Borders and Shading
  • Cell Alignment | Text Direction
  • Distribute Rows and Columns Evenly
  • Picture | Clip Art | Shapes | Smart Art
  • Chart | Hyperlink | Bookmark
  • Header | Footer | Page Number | Quick Parts
  • Text Box | Word Art | Drop Cap
  • Equation | Symbol | Signature
  • Date & Time

Page Layout

  • Margin | Orientation | Size | Page Setup
  • Columns
  • Breaks | Line Numbers | Hyphenation
  • Indent | Spacing | Paragraph
  • Watermark | Page Color | Page Borders

View

Review

  • Spelling & Grammar | Research
  • New Comment | Delete
  • Protect Document

MS-PowerPoint

Home

  • New Slide | Layout | Reset | Delete
  • Drawing | Arrange

Insert

  • Pictures | Shapes | Word Art

Design

  • Page Setup | Orientation
  • Themes
  • Background

Animation

  • Custom Animation
  • Preview | Transition

Slide Show

  • Start Slide Show
  • From Beginning | From Current Slide
  • Custom Slide Show
  • Setup – Setup Slide Show | Hide Slide

View

  • Presentation Views
  • Show / Hide
  • Zoom / Color / Grayscale
  • Window
  • Macros

MS-Excel (Basic)

  • Terms
  • Worksheets | Formula Bar | Status Bar | Cell
  • Move Around the Worksheet
  • Up, Down, Right & Left Arrow Keys
  • Tab & Shift Tab
  • Page Up & Page Down | Ctrl + Home
  • Go to — F5 | Go to — Ctrl + G
  • The Name Box
  • Select Cells | Select Cells by dragging | F8
  • Select noncontiguous areas & Cells | Shift F8
  • Enter Data | Delete Data
  • Edit a Cell – Cut, Copy, Paste, Delete
  • Align Cell Entries
  • Left | Right | Center | Top | Bottom | Center | Orientation
  • Wrap Text
  • Fill Cells Automatically – Day, Month, Numbers
  • Merge | Split | Autofit
  • Select a column | Select a row
  • Column, Row & Cells – Insert | Delete
  • Create Borders | Add background color
  • Merge and Center
  • Work with Long Text | Change column width
  • Format Numbers
  • Ctrl D | Ctrl R
  • Calculate Percentage | Calculate Average
  • Sort | Filter | Freeze Panes
  • Change Case – Upper | Lower | Proper
  • Paste Values
  • Join Text | Split Text | Use of “”
  • Work with multiple worksheets

MS-Excel (Advanced)

  • Customize Quick Access Toolbar
  • Ribbon Display Options
  • Menu

Home

  • Conditional Formatting
  • Format as table
  • Cell Styles
  • Fill
  • Clear
  • Sort & Filter
  • Find & Select

Insert

  • Piovt Table
  • Table
  • Chart
  • Symbols

Page Layout

  • Margin
  • Orientation
  • Size
  • Print Area
  • Break
  • Print Titles

Review

  • Protect Sheet
  • Protect Workbook

Formulas

  1. Logical
    1. IF | IFS | IFERROR
    2. AND | OR | NOT
    3. TRUE | FALSE
  2. Text (Download Examples)
    1. UPPER | LOWER | PROPER
    2. TRIM
    3. FIND
    4. LEFT | RIGHT | MID
    5. LEN
    6. REPLACE
    7. SUBSTITUTE
  3. Date & Time (Download Examples)
    1. DATE | DATEDIF
    2. TODAY | NOW
    3. EDATE
    4. EOMONTH
    5. TIME | HOUR | MINUTE | SECOND
  4. Lookup & References
    1. LOOKUP | VLOOKUP |
    2. HLOOKUP
    3. INDEX | MATCH
    4. ROW | ROWS
    5. COLUMN | COLUMNS
  5. Maths & Trig (Download Examples)
    1. SUM | SUMIF |SUMIFS
    2. SUMPRODUCT
    3. RANDBETWEEN

More Functions

  1. Statical (Download Examples)
    1. COUNT | COUNTA
    2. COUNTBLANK
    3. COUNTIF | COUNTIFS
    4. MAX | MIN
  2. Information (Download Examples)
    1. ISBLANK
    2. ISNUMBER
    3. ISTEXT

Data

  • Text to columns
  • Remove Duplicates
  • Data Validation
  • Consolidate
  • What if analysis
  • Group | Ungroup
  • Subtotal

View

  • Normal | Page Break Preview
  • Page Layout | Custom Views
  • Ruler | Formula Bar
  • Gridlines | Headings
  • Zoom | New Window | Arrange All
  • Fridge Panes | Split | Hide
  • Macros

Google Workspace

Google Chrome

  • Tab | Window | Incognito | log in
  • Bookmark | History | Password

Gmail

  • Account Creation
  • Sending Email | Reply
  • Attach – Single File | Multiple Files
  • Sent
  • Forward Email | CC
  • Add Photo to account
  • Change Password
  • Delete Account

Google Forms

  • Creating a New Form from Template or by using a blank Form
  • Editing Form | Edit Questions | Add Questions
  • Copy/Delete /Duplicate Questions
  • Required Questions
  • More Buttons
  • Form Colors/Themes
  • Preview Form
  • Advanced Form Settings
  • Send Form | Viewing Responses
  • Close Form
  • View Form and Form Responses
  • Delete Form

Google Sheets

  • Menu – File | Edit | View | Insert | Format | Data | Tools
  • Share
  • Version History
  • Comment History
  • Make available offline
  • Filter Views
  • Formulas

Google Calendar

  • Access Google Calendar
  • Create an Event
  • Quick Add
  • Invite Guests
  • Share Your Calendar
  • Share calendar with others
  • Share calendar with specific people
  • Add Calendars
  • Under My calendars
  • Under Other calendars
  • Customize Calendar Settings
  • View your Calendar
  • Notification Settings
  • Search Calendar

Google Docs

  • Real-Time Collaboration
  • Suggesting Mode
  • Explore Tool
  • Integration with Google Drive
  • Linking to Google Sheets

Google Slides

  • Audience Q&A
  • Shared Slides for Collaboration
  • Adding YouTube Videos Directly
  • Version History for Slides
  • Google Keep Integration

Graphic Design

  • Welcome Screen
  • Parts of the Screen | Standard Toolbar | Toolbox
  • Property Box | Status Bar
  • Pick Tool
  • Rectangle Tool
  • Use of Ctrl for “Square”
  • Object Size
  • Zoom through scroll
  • Color the Object
  • Copy – Paste
  • Ctrl + C , Right Click, ‘+’
  • Repeat (Ctrl + R)
  • Flip with Ctrl
  • Multiple selection of object
  • Mirror (Horizontally & Vertically)
  • Group (Ctrl + G)
  • Center the object (P)
  • Text Tool (F8)
  • Break (Ctrl + K)
  • Set the number
  • Ctrl + PgUp / PgDn / Home / Eng
  • About Layers
  • Shape Tool (F10)
  • Property Bar
  • Convert to Curve
  • Cusp node | Smooth node
  • Symmetrical node
  • Convert to line
  • Break Curve
  • Join two nodes
  • Bezier Tool
  • Pen Tool
  • Smart Fill Tool
  • Creating Basic Objects
  • Drawing Rectangles and Squares
  • Adding Corners
  • Draing Elipses and Circles
  • Drawing Polygones and stars
  • Drawng lines
  • Drawing perfect shapes
  • Transforming objects
  • Copying and moving objects
  • Duplicate objects
  • Using step and Repeat
  • Power Clip
  • Aligning and Distributing Objects
  • Import Image
  • Copy Image
  • Using Guidelines
  • Using Rulers
  • Color Eyedrapper Tool
Scroll to Top