OFFICE AUTOMATION

This is a basic computer course for beginners. In this course, you will learn how to use a computer step by step. We will teach you how to type documents, make presentations, use the internet, and send emails.

No need to worry if you have never used a computer before—this course is perfect for students, job seekers, and anyone who wants to improve their computer skills.

By the end of this course, you will feel confident using a computer in your daily life or at work.

What You Will Learn?

     Microsoft Word (Document)    

• 1. Document Creation and Editing:
     • Writing and editing text.
     • Using different fonts and font sizes.
     • Applying text styles like bold, italic, and underline.
  2. Formatting:
     • Setting page layout, including margins, orientation, and size.
     • Adjusting paragraph and line spacing.
     • Using headings, bullets, and numbering.
  3. Tables and Charts:
     • Creating and formatting tables.
     • Adding various types of charts and graphics.
  4. Images and Graphics:
     • Inserting images and clipart.
     • Using SmartArt and shapes.
  5. References and Content:
     • Adding tables of contents, indexes, and bibliographies.
     • Using footnotes and endnotes.
  6. Printing:
     • Printing documents and previewing print layout.
     • Adjusting print settings.
  7. Mail Merging and Mailing:
     • Using mail merge to create personalized letters, labels, and envelopes.
  8. Review and Commenting:
     • Checking spelling and grammar.
     • Adding comments and using track changes.
  9. Security and Sharing:
     • Protecting documents with passwords.
     • Sharing documents via email or online.
  10. Online Templates:
      • Using various templates for resumes, cover letters, reports, etc.

  MS Word is a versatile tool suitable for personal, educational, and professional tasks, enabling you to create effective and professional-looking documents.

•  

  Microsoft Excel (Datasheet)

  Basic Excel Syllabus

  Module 1: Introduction to Excel

  • Overview of Excel Interface
    • Ribbon, Tabs, and Menus
    • Workbook and Worksheet Structure
    • Cells, Rows, Columns

  Module 2: Basic Data Entry and Editing

  • Entering Data
    • Text, Numbers, Dates
    • Autofill and Flash Fill
  • Editing Data
    • Copy, Cut, Paste
    • Undo, Redo
    • Find and Replace

  Module 3: Formatting Worksheets

  • Cell Formatting
    • Font Styles, Sizes, and Colors
    • Cell Borders and Shading
  • Number Formatting
    • General, Number, Currency, Date, and Percentage Formats
  • Alignment and Text Control
    • Text Alignment, Wrap Text, Merge Cells

  Module 4: Basic Formulas and Functions

  • Introduction to Formulas
    • Basic Arithmetic (Addition, Subtraction, Multiplication, Division)
    • Using Cell References
  • Common Functions
    • SUM, AVERAGE, MIN, MAX
    • AutoSum Feature

  Module 5: Managing Worksheets

  • Working with Multiple Worksheets
    • Adding, Renaming, Deleting Worksheets
    • Moving and Copying Worksheets
  • Worksheet Views
    • Zooming, Freezing Panes, Split View

  Module 6: Data Management

  • Sorting and Filtering Data
    • Basic Sorting (Ascending, Descending)
    • Applying Filters
  • Tables
    • Creating and Formatting Tables
    • Table Styles and Quick Analysis

  Module 7: Introduction to Charts and Graphs

  • Creating Charts
    • Selecting Data for Charts
    • Types of Charts (Column, Line, Pie, Bar)
  • Formatting Charts
    • Chart Titles, Legends, and Labels
    • Chart Styles and Layouts

  Module 8: Basic Data Analysis

  • Conditional Formatting
    • Highlight Cell Rules, Top/Bottom Rules
    • Data Bars, Color Scales, Icon Sets
  • Simple Pivot Tables & Pivot Chart
    • Creating Pivot Tables & Chart
    • Using Pivot Table & Chart Fields

  Module 9: Printing and Page Layout

  • Page Setup
    • Margins, Orientation, Size
    • Print Area and Print Titles
  • Printing Options
    • Print Preview, Scaling
    • Headers and Footers

  Module 10: Basic Data Validation and Protection

  • Data Validation
    • Setting Validation Rules
    • Creating Drop-down Lists
  • Protecting Workbooks and Worksheets
    • Password Protection
    • Protecting Cells and Ranges

  MS Excel is a powerful tool for data management, analysis, and visualization. It’s ideal for tasks ranging from simple calculations to complex data modelling, making it essential for personal, academic, and professional use.