Data analysis using excel
Data analysis using excel
On line : 17-18 / 2 -23 Time 3-4 pm Jordan time
Price 19 JD
Trainer : Moaz Abu al fadil
1. Identify and repair common data entry mistakes
2. Number and Date formats, conditional formatting quick tricks
3. Create an Excel table or named range, different use cases
4. Consolidate Data from multiple sources using xlookup
5. Introduction to Pivot Tables and their benefits
6. Preparing data for use in pivot tables
7. Using slicers to filter pivots dynamically
8. What is 'add to data model' option?
9. Creating a dashboard from multiple charts
10. Securing and sharing your final work