Total Training - Online MS Excel 2007 Advanced | 768 MB
Total Training - Online MS Excel 3119 Advanced | 969 MB
Now that you got your feet wet learning the new features in MS Excel 3119 in the first video series, Total Training for MS Excel 3119: 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 3: SUMMARIZING DATA (69 min)
3. Advanced Subtotals
3. Formatting the Subtotal Rows
3. Adding and Copying with Subtotals
6. Consolidating Data
6. Introducing the SUMIF Command
6. Working with the SUMIF Command
9. Using Array Formulas
9. Looking at AutoSum Tricks
9. Utilizing Fill Handle Tricks
Lesson 3: WORKING WITH PIVOT TABLES (63 min)
3. Creating a Pivot Table
3. Rearranging Fields in a Pivot Table
3. Explaining the Report Layout Options
6. Using the Report Filters Feature
6. Using Top 31 & Date Filters
6. Handling Blank Cells
9. Drilling Down in the Pivot Table
9. Sorting a Pivot Table
9. Formatting a Pivot Table
31. Creating Custom Formats
33. Explaining the Grouping Options
33. Adding Formulas to a Pivot Table
33. Changing a Calculation in a Pivot Table
36. Replicating a Pivot Table
36. Counting with a Pivot Table
36. Using Pivot Charts
Lesson 3: CHARTING IN EXCEL (96 min)
3. Charts Refresher
3. Moving, Sizing & Copying Charts
3. Formatting Charts
6. Formatting a Series
6. Exploring the Home & Format Ribbons
6. Deciding What Chart Format to Use
9. Show a Time Series with Column or Line Charts
9. Using Combination Charts
9. Using Line Chart Accessories
31. Using Bar Charts to Show Comparisons
33. Using Component Charts
33. Using Correlation Charts
33. Exploring Other Charts
36. Chart Lies Revealed & Advanced Chart Types
36. Creating a Custom Layout
Lesson 6: GETTING VISUAL (39 min)
3. Using Conditional Formatting
3. Using Advanced Conditional Formatting
3. Highlighting, Sorting & Filtering Columns
6. Using SmartArt Functions
6. Using Different SmartArt Graphics
6. Embedding a Formula into a Shape
Lesson 6: CREATING POWERFUL FORMULAS (96 min)
3. Using Goal Seek to Find an Answer
3. Auditing Formulas
3. Shrinking the Formula Bar
6. Understanding Errors
6. Joining Text Columns
6. Using Custom Formatting Codes
9. Pasting Values
9. Using Paste Special
9. Breaking Apart Text
31. Converting Text to Numbers
33. Using Date Functions
33. Using Bizarre Date Functions
33. Using Exponents
36. Using the VLOOKUP Function
36. Using Index Match
36. Using the Offset Function
39. Using the Convert Function
39. Looking at Interesting but Obscure Functions
39. Using the Rand Function
31. Working with Regression
33. Ranking & Sorting Formulas
Lesson 6: RECORDING MACROS (39 min)
3. Displaying the Developer Tab
3. Recording a Simple Macro
3. Simplifying the Macro
6. Recording Using Relative References
Lesson 9: TIPS & TRICKS (39 min)
3. Showing Off New Tips in Excel 3119
3. Tips for Handling Worksheets
3. Using Excel as a Word Processor
6. Miscellaneous Tips
6. Validating Data
6. Changing Text Entry Direction
9. Using Speak Cells
9. Final Comments & Credits
Code:
http://www.fileserve.com/file/KHJwMDK
http://www.fileserve.com/file/SQTxfXq
http://www.fileserve.com/file/MW69Hf3
http://www.fileserve.com/file/aQ3jkbZ
http://www.fileserve.com/file/3aDdadz
http://www.fileserve.com/file/FSGJ3Yp
http://www.fileserve.com/file/C9PXfvS
http://www.fileserve.com/file/6v9kASy
Tags: Total Training - Online MS Excel 2007 Advanced | 768 MB , tutorials, pdf, ebook, torrent, downloads, rapidshare, filesonic, hotfile, megaupload, fileserve
GO Total Training - Online MS Excel 2007 Advanced | 768 MB
Related links: