Join Basic Computer Course in Dwarka Mor, New Delhi

Basic Computer Course

Basic Computer Course, As we all know very well the uses of computer system in every sector of our day by day work is increasing.
If you have some Office skills, with DGA Professional Institute, you can update to the latest version fast, or you if you’re just beginning, you can gain a comprehensive knowledge that include realistic work-place exercises.

Course Contents

Duration : 1½ Month | Classes: Mon-Sat, 1½ Hrs./day

• Module 1: Operating System- Windows
  • About Computers.
  • Hardware and Software.
  • Operating System and Windows.
  • Using Windows 7,8,10,
  • Working with Windows environment,
  • Using Windows Elements,
  • Windows Explorer, Control Panel, properties etc.
  • Installing Programs, creating files & folders.
  • Various Storage Devices.
  • Using Pen Drive, CD, DVD etc.
  • About Drivers and Their Uses.
  • Printing & Networking.

• Module 2: Microsoft Word- Professional Level
  • Introduction & Word Basics.
  • Introduction of MS-Word Window Elements.
  • Format Your Document.
  • Bullets & Numbering.
  • Working with Tabs.
  • Create & Apply Styles.
  • Advance Find and replace Techniques.
  • Inserting Graphics, Charts and Objects.
  • Setting up your Document.
  • Advanced Page Layout Tools.
  • Tables in Microsoft Word.
  • Creating Reports in Various Tabular format.
  • Inserting and formatting Pictures, Clip arts, Smart art, etc.
  • Hyperlinks and bookmarks with Cross Reference.
  • Inserting Header, Footers,Page Numbers.
  • Inserting Equations and Symbols.
  • Working with themes & Page backgrounds.
  • Paragraph formatting and Objects arrangement.
  • Setting Up Document for Print with Page Setup.
  • Using Referencing Tools
  • Advance Mail Merge Technique.
  • Creating Master Documents.
  • Track and Merge Documents.
  • Spelling & Grammar.
  • Using Track Changes & Comments.
  • Document Protection with passwords
  • Introduction to Macros, Recording & Uses.
  • Using macros to Automate Difficult tasks in Word Document.

• Module 3: Microsoft Excel
  • Excel Tabs, Options, Formatting & Printing.
    • An overview of Excel, Version & Spreadsheet concepts.
    • Workbooks, Worksheets, Rows, Columns and Cells.
    • Various Selection techniques.
    • Cell Contents – General, Text, Numbers, Dates etc.
    • Methods to Move, Copy & Paste data.
    • All the Options in Paste Special and Go To.
    • Insert, Delete and Hiding Rows & Columns.
    • Inserting and Deleting ranges.
    • Insert, Delete and Move Cells
    • Various Navigation techniques.
    • Sheet tab formatting and Renaming.
    • Copy and Clear Formats and Merge Cells.
    • Find, Replace and AutoCorrect.
  • Working With Formulas & Functions
    • SUM, SUBTOTAL, ADDRESS, AVERAGE, CHAR.
    • COLUMN, COLUMNS, CONCATENATE, COUNT
    • COUNTA, COUNTBLANK, EXACT, HYPERLINK.
    • RIGHT, LEFT, MID, LEN, LOWER, UPPER, TEXT
    • OFFSET, PROPER, MAX, SEARCH, TIME, DATE.
    • Page break preview, Headers and footers, Freezing
    • Print Preview, Page Setup, Print Titles & Data Alignments.
    • Cell Formatting, Alignment, Borders, Fill colors and Patterns.
    • Uses Conditional Formatting and Auto Formatting.
    • All Format Cells Options.
    • Uses of Toolbars and Formula Bar.
    • Viewing, Adding, Editing and Deleting Comments.
    • Auditing features and Tracing Formula errors.
    • Protect and Share Workbook, Worksheet and Cell ranges.
    • Using Freeze Panes.
    • Worksheets and Workbooks Calculation method.
    • Hide & Display Rows, Columns, Worksheet & Workbooks.
    • Methods to Move and Copy sheets.
    • Uses of Hyperlinks and Define Name.
    • DAY, MONTH, YEAR, FIND, REPLACE, ROUND, ROW, ROWS.
    • SUBSTITUTE, TODAY, TRANSPOSE, TRIM, INDIRECT.
    • NETWORKDAYS, DATEDIF, MOD, NOW etc.

• Module 4: Internet Concepts
  • Internet Concepts & Mail
  • How to connect to Internet.
  • Browsers & Surfing Inernet
  • Best Modern Browsers for Internet.
  • Network Concepts-LAN,MAN & WAN.
  • Using Search Engines(Google, Bing, Yahoo etc).
  • Mailing : Creating New Account, Send & Receive Mails.
  • Using MS-Outlook.

For More Details please visit : http://www.dga-edu.com/basic_computer_course.html or mail us at : info@dga-edu.com