Office Application
Microsoft Excel Advance
03-06-2020 21:16:54
* Microsoft Excel Advance
Silabus Microsoft Excel Advance
This Advanced Microsoft Excel training class is designed for trainee to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools and collaborate with others.
1. Special Table Feature
2. Using Formula Structured References
3. Created & Design worksheet with using Sparklines object
4. Analyzing Data
5. Function Vlookup & Hlookup
6. Function Logika “If” Advance
7. Working & Creating Dynamic Worksheet by Using Pivot Tables & Pivot Chart
8. Advance Chart
9. Reporting
1
Copyright 2010 © Rainusa IT Solutions & Training Provider Provider. All rights reserved.