Cart Contents
Categories
- New Products (5)
- Specials (22)
- Featured (5)
- Bestsellers (5)
- CDs (12)
- Books (24)
- Bundles (18)
- Utilities (9)
- Misc (2)
- DVDs (6)
- eBooks (21)
Bestsellers
VBA and Macros for Microsoft Excel
2500 Excel VBA Examples
Learn Excel from Mr Excel E-Book
Guerilla Data Analysis
Slide Your Way Through Excel VBA
Guerilla Data Analysis E-Book
Join the Excellers League
Complete PDF - Learn Excel
Speedometer Chart Creator
Pivot Table Data Crunching
Sale Item
Currency
Product Details
|
Total Training for Excel 2007 Advanced
SKU: 112
|
Overview
Bill Jelen's Power Excel seminar for Excel 2007 right on your desktop! Play the DVD-ROM to see the concept demonstrated and then open the project files to try it yourself!
This course covers: Lesson 1: SUMMARIZING DATA (58 min)
- Advanced Subtotals
- Formatting the Subtotal Rows
- Adding and Copying with Subtotals
- Consolidating Data
- Introducing the SUMIF Command
- Working with the SUMIF Command
- Using Array Formulas
- Looking at AutoSum Tricks
- Utilizing Fill Handle Tricks
- Creating a Pivot Table
- Rearranging Fields in a Pivot Table
- Explaining the Report Layout Options
- Using the Report Filters Feature
- Using Top 10 & Date Filters
- Handling Blank Cells
- Drilling Down in the Pivot Table
- Sorting a Pivot Table
- Formatting a Pivot Table
- Creating Custom Formats
- Explaining the Grouping Options
- Adding Formulas to a Pivot Table
- Changing a Calculation in a Pivot Table
- Replicating a Pivot Table
- Counting with a Pivot Table
- Using Pivot Charts
- Charts Refresher
- Moving, Sizing & Copying Charts
- Formatting Charts
- Formatting a Series
- Exploring the Home & Format Ribbons
- Deciding What Chart Format to Use
- Show a Time Series with Column or Line Charts
- Using Combination Charts
- Using Line Chart Accessories
- Using Bar Charts to Show Comparisons
- Using Component Charts
- Using Correlation Charts
- Exploring Other Charts
- Chart Lies Revealed & Advanced Chart Types
- Creating a Custom Layout
- Using Conditional Formatting
- Using Advanced Conditional Formatting
- Highlighting, Sorting & Filtering Columns
- Using SmartArt Functions
- Using Different SmartArt Graphics
- Embedding a Formula into a Shape
- Using Goal Seek to Find an Answer
- Auditing Formulas
- Shrinking the Formula Bar
- Understanding Errors
- Joining Text Columns
- Using Custom Formatting Codes
- Pasting Values
- Using Paste Special
- Breaking Apart Text
- Converting Text to Numbers
- Using Date Functions
- Using Bizarre Date Functions
- Using Exponents
- Using the VLOOKUP Function
- Using Index Match
- Using the Offset Function
- Using the Convert Function
- Looking at Interesting but Obscure Functions
- Using the Rand Function
- Working with Regression
- Ranking & Sorting Formulas
- Displaying the Developer Tab
- Recording a Simple Macro
- Simplifying the Macro
- Recording Using Relative References
- Showing Off New Tips in Excel 2007
- Tips for Handling Worksheets
- Using Excel as a Word Processor
- Miscellaneous Tips
- Validating Data
- Changing Text Entry Direction
- Using Speak Cells
- Final Comments & Credits
Related Products
SKU: 146
|
|
 |
|
SKU: 169
|
|
|
|
SKU: 139
|
|
|
|
SKU: 127
|
|
|
|
Reviews
Add Your ReviewCurrently there are no reviews for this product. Share your opinion with others, be the first to write a review.
Tell a Friend
