Basic Excel Training (1 Day)

₱999.00
₱999.00
Unavailable
per item
SKU:
This module contains the most essential formulas and tools in MS Excel.

Who is this for: General non-heavy users of MS Excel

Topics:
​
I.  Essential Excel Functions
  • Basic Arithmetic Formulas: SUM, AVERAGE, etc.
  • Text Functions: LEFT, RIGHT, CONCATENATE, etc.
  • Math Functions: COUNTIF, SUMIF, RANK, etc.
  • Basic Logical Functions: IF
  • Basic Lookup Functions: VLOOKUP
 
II.  Data Management
  • Text- to- Columns
  • Conditional Formatting
    • Applying Conditional  Formatting
    • Data Bars, Color Scales, and Icon Sets
  • Flash Fill
  • Subtotal
  • Consolidate Tool
  • Data Validation
    • Creating Basic Dropdown Lists
    • Other Data Validation Options
               
III.  Charting
  • Review of Basic Chart Elements
    • Gridlines
    • Axes
    • Data Tables
    • Data Labels
    • Legends
 
VII.  Introduction to PivotTables
  • Creating  PivotTables
  • Modifying Value Field Settings

Email us to reserve your class: [email protected]
Or contact us at 0977-103-1800