MS Office Level 2

Overview

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

PowerPoint

Internet & E-Mail

Keyboard Practice