Course Details

MS Office Level 2 Classroom Course is a more detailed course. This is a very professionally compact program designed for the students, keeping in mind the recent professional requirements. Course details are as follows:

• MICROSOFT WORD
  • Introduction
  • Manipulating Text
  • Formatting Document
  • Enhancing a Document
  • Columns and Graphics
  • Tabs
  • Mail Merge
  • Printing
  • Headers & Footers
  • Page Numbering and Breaks
  • Themes
  • Thesaurs
  • Auto Features of Words
  • Templates
• MICROSOFT EXCEL
  • Introduction
  • How to make Formula in Excel
  • How to use Functions
  • Cell Formatting
  • Page Setup
  • Sorting & Subtotal
  • Implementing the Complicated Formula
  • In Formula
  • Nested if Formula
  • Filter & Advance Filter
  • Chart Creation
  • P/L Account Report
  • Functions with Examples
  • Consolidate
  • Scenario Summary Report
  • Goal Seek
  • Logical Functions (SUMIF, COUNTIF ETC)
  • Data Functions (DSUM, DAVERAGE ETC)
• PIVOT TABLE
  • Look-up Function
  • Vlookup
  • Invoice Preparation
  • Rank Formula
  • Budget Preparation
  • Conditional Formatting
  • Name Manager & Name Define
  • Track Precedent
  • Trace Dependent
  • Data Validation
  • Text to Column
  • Freeze pan option information about macros
• MICROSOFT ACCESS
  • Create Table
  • Format Table
  • Edit Table
  • Lookv Up Table
  • Attach with Table
  • Picture (Logo) with Table
  • Create Simple Form
  • Edit Form
  • Command Button on Form
  • How to take Report
• POWER POINT
• INTERNET & E-MAIL
• KEYBOARD PRACTICE