CLASSROOM
TENTATIVE

SCHEDULES


Dec 2, 2017 9:00 am 18:00 pm
REGISTER NOW

MICROSOFT

BASIC MS EXCEL

DESCRIPTION
MS Excel is a powerful tool. You’ll be surprised that you have not maximized the use of its basic functions yet.
COURSE CONTENT

 

Module I : Excel Functions

  • Text Functions
               - Combining Cells
               - Extracting Cell Contents
               - Changing Case of Texts
  • Logical Functions
               - Basic IF Statements
               - Nested and Series IFs
     
  • Math Functions   

                  - Math Functions

  •  Lookup Functions

                  - VLOOKUP


Module II : Database Management

  • Sorting Options
  • Text- to- Columns
  • Remove Duplicates
  • Conditional Formatting
          - Basic Conditional Formatting
          - Data Bars, Color Scales, and Icon Sets
  • Data Validation
          - Modifying Error Alerts
  • Subtotal Tool
          - Group and Ungroup
          - Basic Subtotal
  • Data Consolidation
          - Consolidate Tool


Module III : Tables and Charts
 

  • Charts
          - Review of Chart Elements
          - Basic Chart Design


Module IV : Pivot Reports
 

  • PivotTable
          - Basic Pivot Features
          - Slicers
          - Drilling Down