Questions ?    01- 4596122

Available Packages

Cambridge Info Tech

Advance Excel Advance Excel

Maximum Students: 1000 only

Package Price: Rs. 5000/-


Advance Excel Course Contain:  Cells, Worksheets, Sheet Tabs and Workbooks Column and Row Excel’s Golden Rule Keyboards Formula Basics and Lookup Example of Formulas Data Types Math How Formula Calculate In-Decrease Number Format Style Number Formatting Cell Reference Relative Relative and Abs

Advance Excel Course Contain: 

  1. Cells, Worksheets, Sheet Tabs and Workbooks
  2. Column and Row
  3. Excel’s Golden Rule
  4. Keyboards
  5. Formula Basics and Lookup
  6. Example of Formulas
  7. Data Types
  8. Math
  9. How Formula Calculate
  10. In-Decrease
  11. Number Format
  12. Style Number Formatting
  13. Cell Reference
  14. Relative
  15. Relative and Absolute
  16. Import Purchase Cost Sheet with Absolute
  17. Payroll Sheet
  18. Multiplication Table
  19. Sum product
  20. Round
  21. Table
  22. Text Extract & Join
  23. Is Item in List
  24. Is Not Item in List
  25. Data Validation
  26. Flash
  27. Flash Fill
  28. Sort
  29. Goal Seek
  30. Conditional Formatting
  31. Conditional Formatting with Example
  32. Filter
  33. Advanced Filter
  34. Subtotal
  35. VLOOKUP Retrieve Record
  36. Raw Data into Information using Formula or PivotTable
  37. Reminder about Sorting, Filtering and PivotTables from Excel
  38. Page Setup
  39. Chart Types
  40. Excel Keyboard Shortcuts