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

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

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 Karama Language and Computer Centre MS Access Karama Language and Computer Centre Advanced Excel and Basic MS Access Karama Language and Computer Centre

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?

or