Microsoft Office:PeopleNTech

Microsoft Office

About The Course

At modern days, Microsoft office (Excel, Word, PowerPoint and Access) has become one of the most useful tools at colleges, corporate offices for organizing, handling and presenting data and information. Over 90% of the corporate professionals rely on Microsoft office works and that makes MS Office tools very significant in our regular lives.

 We are here for you to boost and strengthen your understanding on advanced Microsoft office tools: Excel, Word, PowerPoint and Outlook. This is an Advanced level MS-OFFICE Training, Which includes:

MODULE 1: Microsoft Word

 

Microsoft Word: Part 1

  • Introduction to Microsoft Word
  • Effectively Formatting a Document with Styles
  • Prepare Documents for Printing and Exporting
  • Create and Manage Table Layouts
  • Manage Templates

Microsoft Word: Part 2

  • Manage Large Documents
  • Working with Page and Section Breaks
  • Build Dynamic Table of Contents
  • Perform Mail Merges to create Mailing Labels and Form Letters
  • Track and Accept/Reject Changes to a Document
  • Insert Media and Images
  • Introduction to Microsoft Word

MODULE 2: Microsoft PowerPoint Master Class

  • Create Slide
  • Graph and Chart
  • SmartArt
  • Animation
  • Print a PowerPoint Slide

MODULE 3: Microsoft Excel

Introduction with Excel

  • Creating Workbook
  • Introduce Startup Screen
  • Selecting, Moving & Resizing Cells
  • Fill and Auto Fill
  • Add Delete Hide Row Columns
  • Managing Worksheet
  • Quick Access Toolbar
  • Shortcuts
  • Saving Excel File
  • Marge and Centering
  • Managing List & Database Concept
  • Frees Pans

Formatting Cell

  • Font and Alignment
  • Fill & Border
  • Data Type
  • Format Painter

Copy & Paste

Hyperlink

Cell Reference

  • Cell References
  • Cell References (Relative & Absolute)
  • Define Names
  • Offset Function

Excel Functions (Basic)

  • Structure of Excel Function
  • Order of operation
  • Basic Excel Formulas
  • AutoSum
  • Summation Minimum Maximum Average Count Functions
  • Frequently used functions

Find and Replace

  • Text Find & Replace
  • Advanced Find & Replace
  • Find & Replace Formatting
  • Common Mistakes in Replace All

Data Validation

  • Basic Data Validation
  • Data Validation by Formula

Conditional Formatting

  • Basic Conditional Formatting
  • Conditional Formatting by Formula

Sort & Filtering

  • Basic Sort Options
  • Sort by Custom List
  • Filtering Options

Subtotal

  Calculation Based on Logic 

  •   IF Function (Basic)
  • Multiple use of IF Function in one formula
  • And Function
  • OR Function
  • Integration of AND/OR logic with
  • IF Function IF Functions (sum, count, average)
  • IFS Function (sum, count, average)

Date Formulas

  • Calculate Age
  • Mention Date inside Function
  • Import or Export Date by Formula
  • Working Day Calculation
  • Time-Related Functions 

Vlookup Hlookup Functions

Index and Match Functions

Printing Document Perfectly

  • Page Setup
  • Scale to Fit
  • Header Footer Setup
  • Repeat Print Areas

Manage Duplicate Data

Text to Coolum

PrivotTable

Charts

PrivotChart

Text Functions

Managing Multiple Windows

Template

Formatting by Formula

Slicer

Table

Formula Auditing

Managing Comments in Excel

Spell Check

Security Issue in Excel

  • Protect Sheet and Workbook
  • Protecting Excel Worksheets and Workbooks

Introduction to Excel Macro

Macro Project

 

 

MODULE 4: Microsoft Access Master Class

  • Understand the structure of the database file and its advantages.
  • Creating table, forms, query and reports by Microsoft Access

MODULE 5: Review

  • All Module Overview.
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech