1. Advance Excel
Before=125,000 MMK, Now = 90,000 MMK (2 months/40hr) , 30% off for Old student. 
Course Outline အတိုချုပ်
(1) Ribbon Customization and Workbook, Worksheet, Contents Password Protection
(2) Customization to different formats
(3) Advance Conditional Formatting linking to Formulas and sparklines
(4) Combination of different functions with practical exercises (Vlook up, INDEX, MATCH, etc.)
(5) Working with data (Freezing Panes and View Option), advance Filtering, dropdown list data creation and data validation including message boxes prompt
(6) Developer tools (Creation of Buttons, Dropdown list/Combo box, Check box, option buttons, group box)
(7) Linking worksheets and hyperlink
(8) Data analyzing with Pivot Tables
(9) Using Macros
(10) Other Advance formulas and functions
No comments:
Post a Comment