Excel 2010 - 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 2010 - 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 2010 - 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 2010 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 2010 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 2013 Power Shortcuts
Introduction2m 1s
1. Top Ten Shortcuts32m 35s
2. Controlling the Excel Program and Interface16m 33s
3. Managing Workbooks and Worksheets13m 48s
4. Organizing Data22m 59s
5. Entering and Formatting Data 24m 22s
6. Managing a Data Series13m 3s
7. Working with Dates and Times13m 8s
8. Creating Useful Formulas21m 39s
9. Managing Formulas17m 37s
10. Summarizing Data Using Charts and PivotTables18m 17s
Conclusion56s
Excel Books and Training
======================================================================
This DVDs are only suitable for a PC/laptop/Mac; it WILL NOT play on a TV
Payment mode : Pay on my account ,Buying via ebay or Paypal
Shipping : By Courier through all over India
Shipping charge : Rs 50/- Flat Rate shipping anywhere in India
You can get with in two days
Any Advanced Graphic Design Software Tutorials, IT Software Tutorials, Multimedia Software Tutorials, All Engineering purpose Software Tutorials & All Software Tutorials Available
For more details
Email : digitalcollections4u@gmail.com
https://www.facebook.com/TutorialsDvDs
