Reply to thread

Message: <blockquote data-quote="kasun1986" data-source="post: 5602320" data-attributes="member: 15200">Total Training for Microsoft Excel 2007 Advanced<img src="http://www.picestoon.com/out.php/i42619_15556958.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" />Title: Microsoft Excel 2007 AdvancedCategory: Communication & Office ToolsPresenter: Bill JelenPlatform: WindowsFormat: DVD-ROMRunning Time: 6 Hrs, 1 DVDLevel: Intermediate to AdvancedProject Files: IncludedNow that you got your feet wet learning the new features in Microsoft Excel 2007 in the first video series, Total Training for Microsoft Excel 2007: Essentials, you're ready to dive into the advanced capabilities. While creating pivot tables and macros seems daunting, you'll be at ease learning some new techniques that will streamline your next data analysis project. Sit back and discover how to unleash the power of Excel with this in-depth video series.Lesson 1: SUMMARIZING DATA (58 min)1. Advanced Subtotals2. Formatting the Subtotal Rows3. Adding and Copying with Subtotals4. Consolidating Data5. Introducing the SUMIF Command6. Working with the SUMIF Command7. Using Array Formulas8. Looking at AutoSum Tricks9. Utilizing Fill Handle TricksLesson 2: WORKING WITH PIVOT TABLES (52 min)1. Creating a Pivot Table2. Rearranging Fields in a Pivot Table3. Explaining the Report Layout Options4. Using the Report Filters Feature5. Using Top 10 & Date Filters6. Handling Blank Cells7. Drilling Down in the Pivot Table8. Sorting a Pivot Table9. Formatting a Pivot Table10. Creating Custom Formats11. Explaining the Grouping Options12. Adding Formulas to a Pivot Table13. Changing a Calculation in a Pivot Table14. Replicating a Pivot Table15. Counting with a Pivot Table16. Using Pivot ChartsLesson 3: CHARTING IN EXCEL (75 min)1. Charts Refresher2. Moving, Sizing & Copying Charts3. Formatting Charts4. Formatting a Series5. Exploring the Home & Format Ribbons6. Deciding What Chart Format to Use7. Show a Time Series with Column or Line Charts8. Using Combination Charts9. Using Line Chart Accessories10. Using Bar Charts to Show Comparisons11. Using Component Charts12. Using Correlation Charts13. Exploring Other Charts14. Chart Lies Revealed & Advanced Chart Types15. Creating a Custom LayoutLesson 4: GETTING VISUAL (28 min)1. Using Conditional Formatting2. Using Advanced Conditional Formatting3. Highlighting, Sorting & Filtering Columns4. Using SmartArt Functions5. Using Different SmartArt Graphics6. Embedding a Formula into a ShapeLesson 5: CREATING POWERFUL FORMULAS (85 min)1. Using Goal Seek to Find an Answer2. Auditing Formulas3. Shrinking the Formula Bar4. Understanding Errors5. Joining Text Columns6. Using Custom Formatting Codes7. Pasting Values8. Using Paste Special9. Breaking Apart Text10. Converting Text to Numbers11. Using Date Functions12. Using Bizarre Date Functions13. Using Exponents14. Using the VLOOKUP Function15. Using Index Match16. Using the Offset Function17. Using the Convert Function18. Looking at Interesting but Obscure Functions19. Using the Rand Function20. Working with Regression21. Ranking & Sorting FormulasLesson 6: RECORDING MACROS (18 min)1. Displaying the Developer Tab2. Recording a Simple Macro3. Simplifying the Macro4. Recording Using Relative ReferencesLesson 7: TIPS & TRICKS (28 min)1. Showing Off New Tips in Excel 20072. Tips for Handling Worksheets3. Using Excel as a Word Processor4. Miscellaneous Tips5. Validating Data6. Changing Text Entry Direction7. Using Speak Cells8. Final Comments & CreditsDownload:[code]http://rapidshare.com/files/165883412/Trainsignal__20MicrosoftExcel2007Advanced_Oxava.com.part01.rarhttp://rapidshare.com/files/165883406/Trainsignal__20MicrosoftExcel2007Advanced_Oxava.com.part02.rarhttp://rapidshare.com/files/165883386/Trainsignal__20MicrosoftExcel2007Advanced_Oxava.com.part03.rarhttp://rapidshare.com/files/165883541/Trainsignal__20MicrosoftExcel2007Advanced_Oxava.com.part04.rarhttp://rapidshare.com/files/165883326/Trainsignal__20MicrosoftExcel2007Advanced_Oxava.com.part05.rarhttp://rapidshare.com/files/165883434/Trainsignal__20MicrosoftExcel2007Advanced_Oxava.com.part06.rarhttp://rapidshare.com/files/165883349/Trainsignal__20MicrosoftExcel2007Advanced_Oxava.com.part07.rarhttp://rapidshare.com/files/165883490/Trainsignal__20MicrosoftExcel2007Advanced_Oxava.com.part08.rarhttp://rapidshare.com/files/165882665/Trainsignal__20MicrosoftExcel2007Advanced_Oxava.com.part09.rar[/code]Pass:[code]www.oxava.com[/code]</blockquote>

Verification: Dawasata paya keeyak thibeda?

Top Bottom