Advanced Excel Tutorial

Advanced Excel Tutorial Advanced Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in Microsoft Excel 2013. It has plenty of screenshots that explain how to use a particular feature, in a step-by-step manner. This tutorial has been designed for all those readers who depend heavily on MS-Excel to prepare charts, tables, and professional reports that involve complex data. It will help all those readers who use MS-Excel regularly to analyze data. The readers of this tutorial are expected to have a good prior understanding of the basic features available in Microsoft Excel. ---- TABLE OF CONTENTS: 1. Advanced Excel - Chart Recommendations 2. Advanced Excel - Format Charts 3. Advanced Excel - Chart Design 4. Advanced Excel - Richer Data Labels 5. Advanced Excel - Leader Lines 6. Advanced Excel - New Functions 7. Advanced Excel - Instant Data Analysis 8. Advanced Excel - Sorting Data by Color 9. Advanced Excel - Slicers 10. Advanced Excel - Flash Fill 11. Excel - PivotTable Recommendations 12. Advanced Excel - Data Model 13. Advanced Excel - Power Pivot 14. Advanced Excel - External Data Connection 15. Advanced Excel - Pivot Table Tools 16. Advanced Excel - Power View 17. Advanced Excel - Visualizations 18. Advanced Excel - Pie Charts 19. Advanced Excel - Additional Features 20. Advanced Excel - Power View in Services 21. Advanced Excel - Format Reports 22. Advanced Excel - Handling Integers 23. Advanced Excel - Templates 24. Advanced Excel - Inquire 25. Advanced Excel - Workbook Analysis 26. Advanced Excel - Manage Passwords 27. Advanced Excel - File Formats 28. Advanced Excel - Discontinued Features