Course curriculum

    1. 1.How to change vertical format to horizonal format

    2. 2.Date & Time Function

    3. 3.How to write service year (DateDif)

    4. 4.How to separate and join (Text to Column,Concantenate)

    1. 1.Operator

    2. 2.Date Format Change (dmy to mdy)

    3. 3.Workday, Networkday

    4. 4.How to sum hours

    5. 5.Rounding Number

    6. 6.How to change number to text

    7. 7.Unit Converter

    8. 8.How to know no.of package and left pcs

    9. 9.How to change to text format

    10. 10.Replace/Substitute word

    1. 1.Excell Option Knowledge

    2. 2. Information Function

    3. 3. Mode, Median

    4. 4.How to do ranking

    5. 5.Max,Large,Min,Small

    6. 6.Count Functions

    7. 7.Average Functions

    8. 8. Sum Functions

    1. 1.Conditional Formatting

    2. 2.Simple IF

    3. 3. Compound IF(IF_AND,OR)

    4. 4.Nested IF (IFS)

    5. 5.Vlookup, Hlookup

    6. 6. Nested Vlookup (multi)

    1. 1. ROW, COLUMN Function

    2. 2. INDEX, MATCH Function

    3. 3. Data Validation

    4. 4. How to calculate Loan Payment, Interest

    5. 5. How to do Loan Schedule

    6. 6. CHOOSE Function

    7. 7.OFFSET Function

    8. 8. TRANSPONE Function

    9. 9. How to use Hyperlink

    1. 1. Protect Excel Sheet, Workbook, Cell with password

    2. 2. How to sum with multi excel sheet using SUM, INDIRECT Function

    3. 3. Two way data validation using INDIRECT Function

    4. 4. How to do Organization Chart in excel

About this course

  • $100.00
  • 47 lessons
  • 11 hours of video content

Discover your potential, starting today