ADVANCED EXCEL VIDEO TUTORIAL COLLECTION OF COURSE ON 2 IN INDIA

Excel Essential Training Introduction1m 35s 1. Getting Started19m 31s 2. Worksheet Basics21m 23s 3. Excel Formula Basics47m 50s 4. Essential Formatting33m 57s 5. Advanced Formatting25m 27s 6. Printing Preparation13m 23s 7. Large Excel Projects34m 3s 8. Collaborating with Others36m 34s 9. Exploring Excel's Database Features27m 30s 10. Analyzing Data32m 56s 11. Advanced Analysis with PivotTables18m 1s 12. Creating and Using Charts26m 58s 13. Creating and Using Macros21m 53s 14. Customizing Excel20m 33s Conclusion16s Excel - Advanced Formatting Techniques 1. Adjusting Numeric Formats Quickly 33m 29s 2. Controlling Fonts, Borders, and Cell Colors 16m 0s 3. Alignment Tools 17m 30s 4. Other Valuable Formatting Tools 15m 24s 5. Row, Column, and Sheet Adjustments 14m 13s 6. Displaying Data as an Outline 9m 25s 7. Tables, Themes, Styles, and Other Essential Data Visualization Tools 36m 22s 8. Adding Pictures8m 57s 9. Dynamically Accentuating Data with Conditional Formatting 16m 56s 10. Specialized Power Formatting Techniques 12m 54s Conclusion27s Excel - Charts in Depth Introduction1m 50s 1. Understanding Excel Chart Concepts20m 16s 2. Creating Basic Charts Quickly16m 3s 3. Fine-Tuning Charts with Design Tab Choices24m 26s 4. Layout Tab Options: Inserting Pictures, Shapes, and Text Boxes9m 49s 5. Layout Tab Options: Adding Titles, Labels, and Legends29m 53s 6. Layout Tab Options: Using Axes and Gridlines12m 7s 7. Layout Tab Options: Using the Analysis Tools13m 57s 8. Format Tab Options: Adding Shapes and WordArt Styles12m 3s 9. Using Other Formatting Tools16m 12s 10. Adjusting Specific Chart Types39m 53s 11. Changing a Chart's Data Source10m 0s 12. Printing and Sharing Charts11m 29s Conclusion44s Excel - Pivot Tables in Depth Introduction1m 38s 1. Creating and Pivoting PivotTables38m 8s 2. Summarizing PivotTable Data23m 33s 3. Sorting and Filtering PivotTable Data28m 9s 4. Formatting PivotTables15m 2s 5. Applying Conditional Formatting to PivotTables24m 33s 6. Creating and Manipulating PivotCharts24m 0s 7. Printing PivotTables and PivotCharts9m 27s 8. Manipulating PivotTables Using Macros13m 30s 9. Getting Started with PowerPivot19m 17s 10. Working with DAX Expressions24m 30s Conclusion59s Excel Macros In Depth Introduction1m 28s 1. Getting Started 27m 15s 2. Running a Macro (Execute, Play Back, Etc.) 14m 34s 3. Using Visual Basic for Applications (VBA)10m 45s 4. Recording a Macro in Stages 14m 4s 5. Creating Non-Recordable VBA Code 32m 59s 6. Macro Project: Converting a Mailing List into a Database List48m 51s 7. The Personal Macro Workbook 14m 0s Conclusion27s Excel Books and Training