MS Excel Expert

Phần 1: Sharing And Maintaining Workbooks

   1. Save Workbook As Template – Setting Workbook Properties

   2. Protect Workbook – Edit Cell Ranges In Protected Sheet

   3. Share Workbook – Update Changes – Display All Changes

Phần 2: Applying Formulas And Functions

   1. Trace Precedent Cells

        Define Data Validation Rules

        Remove The Data Validation Rules

        Error Checking

        Trace Error

        Watch Window

   2. Iterative Calculation

   3. IF

       SUMIF – SUMIFS

       COUNTIF – COUNTIFS

       AVERAGEIF – AVERAGEIFS

       VLOOKUP – HLOOKUP

Phần 3: Presenting Data Visually

   1. Chart

   2. Consolidate

   3. Goal Seek

   4. Scenario

   5. Pivot Table – Pivot Table Insert Slicer – Pivot Table Chart

Phần 4: working with macro and forms

   1. Macro

   2. Spin Button

   3. Button Control Macro