Microsoft Excel Advanced

As the company continues to grow and operational challenges become increasingly complex, it strives to enhance performance and efficiency through the development of high-quality human resources. In this regard, proficiency in productivity software such as advanced Microsoft Excel has become essential and plays a crucial role in ensuring the smooth execution of daily operational activities by Analyzing, Planning, Making Best & Quick Decision.


MICROSOFT EXCEL ADVANCED
1. Advanced Excel Formulas and Functions.
2. Data Cleaning & Normalization
3. Data Validation and Subtotal.
4. Application Merging, Import External Data
5. Data Analysis, Visualization and Business Intelligence.
6. Interactive Dashboard & Presentation
7. Logical Analysis.
8. Pivot Table Advanced.
9. Power Query, Forecasting, Prediction/ Forecasting
10. Automation (Macro)
11. Collaboration and Security in Excel.
12. Shortcut Key, Tips and Tricks in Excel.
13. Automation Report
14. Case Studies & Real Project Work Simulation (Sales, Inventory, Financial, HR, Budget Plan, etc)