computerclasses

Short Term Courses

Fee: - Rs.699 to Rs.1099 Per month

Basic IT

  • Basic IT
  • Computer fundamentals
  • MS-word
  • MS-excel
  • MS-PPT
  • Typing
  • Internet surfing



  • Excel Programming with VBA & Macro

  • Macros & Visual Basic
  • Recording Macros Basics
  • Referring to Ranges with Excel VBA
  • User defined functions
  • Looping & flow control
  • User forms


  • MIS






















Advance Excel

  • Introduction and Basic Overview Working with Workbook and Worksheets Formatting Cells
  • Customized formatting of Cells
  • Cell References (Absolute, Relative & Mixed) Shortcut Keys
  • Other Features (Paste Special and finding and replacing data etc.)
  • Text Formulas (CONCATENATE, UPPER, LOWER)
  • PROPER, DATE, MOD, MODE, TODAY, NOW)
  • Inserting Comments
  • Use of Go to Feature
  • Use of? to Join data in different cells Logical formula (IF function and its use) Conditional Formatting and its Use in different scenarios.
  • Logical Complex Formulas (IF, OR, AND & IFERROR)
  • Use of Nested IF formula with examples
  • Other Text Formulas (TEXT, CLEAN, TRIM, Len, T
  • COUNT, COUNTA
  • COUNTBLANK, COUNTIF, SUBTOTAL)
  • Defining Cell Range & Name Manager
  • Applying Auto filter Use of Advanced Filter
  • Displaying Unique Record by using Advanced Filter Freezing and Unfreezing Panes
  • Linking of Worksheets & Workbooks
  • Open websites, existing files etc. by Inserting Hyperlink More useful formulas (RIGHT, LEFT, LEN, FIND, SUMIF & SUMPRODUCT) Formatting
  • Financial Formulas (PMT, PV, DISC, DB, IRR, NPV etc.)
  • Text to Column to fetch data
  • Lookup & Reference cell Formulas (CELL, ADDRESS, ROW, COLUMN)
  • LOOKUP, VLOOKUP, HLOOKUP, MATCH, OFFSET, SUMPRODUCT