MS Office Level 2 Al Majaz Star Computer Training Center

Course Outline

  • 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


  • 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)
  • 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


  • 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




MCTC Training Institute

Affordable and Professional training institute is now giving you the opportunity to join our family. You can now expand your thoughts, improve your skills and be familiar to the real world. The success of ATI relays on your professional skills development. Our highly qualified trained and competent faculty makes you one of the unique candidates in this competitive environment.

See all Al Majaz Star Computer Training Center courses

Contact information not available.

Courses you can instantly connect with... MS Office (Word, Excel, Powerpoint) Package CyberModo

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?