Excel 2010 - Charts in Depth/6 - Layout Tab Options Using Axes and Gridlines/6-1 Modifying axis scaling.mp4 27.7 MB
Excel 2010 - Advanced Formatting Techniques/7 - Tables, Themes, Styles and Other Visualization Tools/7-1 Converting data into a table and reformatting it.mov 26.7 MB
Excel 2010 - Charts in Depth/1 - Understanding Excel Chart Concepts/1-2 Selecting the right chart type.mp4 26.7 MB
Excel 2010 - Charts in Depth/7 - Layout Tab Options Using the Analysis Tools/7-1 Analyzing existing and future data with trendlines.mp4 23.4 MB
Excel 2010 - Charts in Depth/1 - Understanding Excel Chart Concepts/1-1 Identifying chart elements like plot area, chart area, gridlines, and legends.mp4 22.3 MB
Excel 2010 - Charts in Depth/12 - Printing and Sharing Charts/12-1 Printing charts.mp4 21.3 MB
Excel 2010 - Charts in Depth/3 - Fine-Tuning Charts with Design Tab Choices/3-3 Dealing with empty and hidden cells.mp4 20.9 MB
Excel 2010 - Charts in Depth/2 - Creating Basic Charts Quickly/2-5 Creating graphic-in-cell charts with sparklines.mp4 20.7 MB
Excel 2010 - Charts in Depth/10 - Adjusting Specific Chart Types/10-3 Using pie charts.mp4 19.9 MB
Excel 2010 - Charts in Depth/5 - Layout Tab Options Adding Titles, Labels, and Legends/5-8 Adding and editing data labels.mp4 19.9 MB
Excel 2010 - Charts in Depth/8 - Format Tab Options Adding Shapes and WordArt Styles/8-2 Adding shape effects.mp4 19.8 MB
Excel 2010 - Charts in Depth/10 - Adjusting Specific Chart Types/10-2 Using line charts.mp4 19.8 MB
Excel 2010 - Advanced Formatting Techniques/7 - Tables, Themes, Styles and Other Visualization Tools/7-2 Using styles and themes for consistent formatting.mov 17.8 MB
Excel 2010 - Charts in Depth/8 - Format Tab Options Adding Shapes and WordArt Styles/8-1 Selecting shape fill and outline.mp4 17.1 MB
Excel 2010 - Advanced Formatting Techniques/1 - Adjusting Numeric Formats Quickly/1-1 Working with the numeric formatting options.mov 17.0 MB
Excel 2010 - Pivot Tables in Depth/Exercise Files/Ch09/Relationship.xlsx 16.3 MB
Excel 2010 - Pivot Tables in Depth/Exercise Files/Ch09/Import.xlsx 16.2 MB
Excel 2010 - Pivot Tables in Depth/Exercise Files/Ch09/Manage.xlsx 16.2 MB
Excel 2010 - Pivot Tables in Depth/Exercise Files/Ch09/AddTable.xlsx 16.2 MB
Excel 2010 - Charts in Depth/7 - Layout Tab Options Using the Analysis Tools/7-4 Adding error bars.mp4 15.9 MB
Excel 2010 - Advanced Formatting Techniques/7 - Tables, Themes, Styles and Other Visualization Tools/7-4 Fine-tuning shape effects.mov 13.8 MB
Excel 2010 - Advanced Formatting Techniques/7 - Tables, Themes, Styles and Other Visualization Tools/7-6 Formatting Sparklines for optimum impact.mov 13.7 MB
Excel 2010 - Charts in Depth/5 - Layout Tab Options Adding Titles, Labels, and Legends/5-5 Specifying the position of tick marks and axis labels.mp4 13.6 MB
Excel 2010 - Advanced Formatting Techniques/1 - Adjusting Numeric Formats Quickly/1-5 Building custom date formats.mov 13.5 MB
Excel 2010 - Pivot Tables in Depth/3 - Sorting and Filtering PivotTable Data/3-8 Filtering a PivotTable with report filter fields.mp4 13.0 MB
Excel 2010 - Pivot Tables in Depth/2 - Summarizing PivotTable Data/2-2 Changing the PivotTable data field summary operation.mp4 12.9 MB
Excel 2010 - Pivot Tables in Depth/10 - Working with DAX Expressions/10-6 Using filters in aggregate functions.mp4 12.7 MB
Excel 2010 - Charts in Depth/5 - Layout Tab Options Adding Titles, Labels, and Legends/5-6 Changing the numeric format on labels.mp4 12.7 MB
Excel 2010 Essential Training/8 - Collaborating with Others/8-6 Saving files in shared locations.mov 12.7 MB
Excel 2010 - Pivot Tables in Depth/9 - Getting Started with PowerPivot/9-6 Creating relationships between tables.mp4 12.6 MB
Excel 2010 - Pivot Tables in Depth/2 - Summarizing PivotTable Data/2-6 Using PivotTable data in a formula.mp4 12.6 MB
Excel 2010 - Charts in Depth/3 - Fine-Tuning Charts with Design Tab Choices/3-4 Choosing a chart layout.mp4 12.5 MB
Excel 2010 - Charts in Depth/9 - Using Other Formatting Tools/9-2 Filling an area with a color gradient.mp4 12.4 MB
Excel 2010 - Pivot Tables in Depth/1 - Creating and Pivoting PivotTables/1-2 Formatting data for use in a PivotTable.mp4 12.4 MB
Excel 2010 - Pivot Tables in Depth/9 - Getting Started with PowerPivot/9-4 Managing table columns.mp4 12.4 MB
Excel 2010 - Charts in Depth/3 - Fine-Tuning Charts with Design Tab Choices/3-2 Setting a default chart type and creating a template.mp4 12.2 MB
Excel 2010 - Advanced Formatting Techniques/6 - Displaying Data as an Outline/6-1 Setting up data for outlining.mov 12.2 MB
Excel 2010 - Advanced Formatting Techniques/4 - Other Valuable Formatting Tools/4-5 Adding a background image to a worksheet.mov 12.2 MB
Excel 2010 - Charts in Depth/11 - Changing a Chart's Data Source/11-2 Creating charts from multiple data sources.mp4 12.2 MB
Excel 2010 - Pivot Tables in Depth/1 - Creating and Pivoting PivotTables/1-9 Updating and refreshing PivotTable data sources.mp4 12.1 MB
Excel 2010 - Charts in Depth/9 - Using Other Formatting Tools/9-1 Formatting lines and borders.mp4 11.9 MB
Excel 2010 - Charts in Depth/11 - Changing a Chart's Data Source/11-3 Adding new data using a table.mp4 11.9 MB
Excel 2010 - Pivot Tables in Depth/6 - Creating and Manipulating PivotCharts/6-6 Changing a PivotChart's chart type.mp4 11.9 MB
Excel 2010 - Pivot Tables in Depth/1 - Creating and Pivoting PivotTables/1-3 Creating a PivotTable.mp4 11.8 MB
Excel 2010 - Charts in Depth/1 - Understanding Excel Chart Concepts/1-4 Understanding the Ribbon and the Design, Layout, and Format tabs.mp4 11.8 MB
Excel 2010 - Pivot Tables in Depth/1 - Creating and Pivoting PivotTables/1-8 Consolidating data from multiple sources.mp4 11.6 MB
Excel 2010 - Pivot Tables in Depth/10 - Working with DAX Expressions/10-5 Using aggregate functions.mp4 11.6 MB
Excel 2010 - Pivot Tables in Depth/8 - Manipulating PivotTables Using Macros/8-1 Recording and reviewing a macro.mp4 11.6 MB
Excel 2010 - Pivot Tables in Depth/1 - Creating and Pivoting PivotTables/1-1 Introducing PivotTables.mp4 11.4 MB
Excel 2010 - Pivot Tables in Depth/10 - Working with DAX Expressions/10-4 Adding calculated columns and measures.mp4 11.3 MB
Excel 2010 - Advanced Formatting Techniques/9 - Dynamically Accentuating Data with Conditional Formatting/9-3 Creating formats based on formulas.mov 11.0 MB
Excel 2010 - Pivot Tables in Depth/5 - Applying Conditional Formatting to PivotTables/5-3 Formatting PivotTable cells using data bars.mp4 11.0 MB
Excel 2010 - Pivot Tables in Depth/6 - Creating and Manipulating PivotCharts/6-4 Formatting a PivotChart.mp4 11.0 MB
Excel 2010 - Charts in Depth/3 - Fine-Tuning Charts with Design Tab Choices/3-1 Switching rows and columns for a different view of the data.mp4 11.0 MB
Excel 2010 - Pivot Tables in Depth/10 - Working with DAX Expressions/10-2 Using DAX operators.mp4 10.9 MB
Excel 2010 - Advanced Formatting Techniques/5 - Row, Column, and Sheet Adjustments/5-3 Working with the Hide Unhide options.mov 10.9 MB
Excel 2010 - Charts in Depth/5 - Layout Tab Options Adding Titles, Labels, and Legends/5-2 Adding horizontal and vertical titles.mp4 10.9 MB
Excel 2010 - Charts in Depth/9 - Using Other Formatting Tools/9-5 Changing the rotation of chart text.mp4 10.9 MB
Excel 2010 - Charts in Depth/3 - Fine-Tuning Charts with Design Tab Choices/3-5 Choosing a chart style from 48 colorful variations.mp4 10.7 MB
Excel 2010 - Pivot Tables in Depth/3 - Sorting and Filtering PivotTable Data/3-6 Filtering a PivotTable using slicers.mp4 10.7 MB
Excel 2010 - Pivot Tables in Depth/5 - Applying Conditional Formatting to PivotTables/5-4 Formatting PivotTable cells using color scales.mp4 10.7 MB
Excel 2010 - Pivot Tables in Depth/1 - Creating and Pivoting PivotTables/1-4 Pivoting a PivotTable.mp4 10.7 MB
Excel 2010 - Charts in Depth/4 - Layout Tab Options Inserting Pictures, Shapes, and Text Boxes/4-2 Adding shapes and arrows.mp4 10.7 MB
Excel 2010 Essential Training/8 - Collaborating with Others/8-1 Importing and exporting data in Excel.mov 10.6 MB
Excel 2010 - Pivot Tables in Depth/7 - Printing PivotTables and PivotCharts/7-1 Printing a PivotTable.mp4 10.4 MB
Excel 2010 - Charts in Depth/4 - Layout Tab Options Inserting Pictures, Shapes, and Text Boxes/4-3 Adding floating text and text boxes.mp4 10.4 MB
Excel 2010 - Advanced Formatting Techniques/9 - Dynamically Accentuating Data with Conditional Formatting/9-2 Creating value-based formatting using data bars and color scales.mov 10.2 MB
Excel 2010 - Pivot Tables in Depth/3 - Sorting and Filtering PivotTable Data/3-7 Formatting slicers.mp4 10.1 MB
Excel 2010 - Pivot Tables in Depth/5 - Applying Conditional Formatting to PivotTables/5-7 Controlling how multiple rules are applied.mp4 9.9 MB
Excel 2010 - Pivot Tables in Depth/3 - Sorting and Filtering PivotTable Data/3-2 Creating a custom sort order.mp4 9.8 MB
Excel 2010 - Advanced Formatting Techniques/7 - Tables, Themes, Styles and Other Visualization Tools/7-3 Understanding the options in shape formatting.mov 9.6 MB
Excel 2010 - Pivot Tables in Depth/10 - Working with DAX Expressions/10-3 Surveying DAX functions.mp4 9.5 MB
Excel 2010 - Pivot Tables in Depth/5 - Applying Conditional Formatting to PivotTables/5-2 Highlighting the top or bottom values in a PivotTable.mp4 9.5 MB
Excel 2010 - Pivot Tables in Depth/1 - Creating and Pivoting PivotTables/1-6 Connecting to an external data source.mp4 9.4 MB
Excel 2010 - Pivot Tables in Depth/1 - Creating and Pivoting PivotTables/1-10 Managing PivotTables.mp4 9.4 MB
Excel 2010 - Advanced Formatting Techniques/5 - Row, Column, and Sheet Adjustments/5-2 Working with rows, columns, and sheets.mov 9.4 MB
Excel 2010 - Pivot Tables in Depth/4 - Formatting PivotTables/4-3 Changing the PivotTable layout.mp4 8.9 MB
Excel 2010 - Pivot Tables in Depth/8 - Manipulating PivotTables Using Macros/8-3 Creating a simple PivotTable presentation kit.mp4 8.9 MB
Excel 2010 Essential Training/8 - Collaborating with Others/8-3 Inserting and editing comments.mov 8.9 MB
Excel 2010 - Advanced Formatting Techniques/3 - Alignment Tools/3-5 Controlling titles and headings with the Wrap Text and Shrink to Fit options.mov 8.9 MB
Excel 2010 - Pivot Tables in Depth/3 - Sorting and Filtering PivotTable Data/3-3 Filtering a PivotTable field by selection.mp4 8.8 MB
Excel 2010 - Pivot Tables in Depth/10 - Working with DAX Expressions/10-1 Introducing the DAX language.mp4 8.7 MB
Excel 2010 - Advanced Formatting Techniques/4 - Other Valuable Formatting Tools/4-3 Copying formats quickly with dragging techniques and the Format Painter.mov 8.7 MB
Excel 2010 - Charts in Depth/5 - Layout Tab Options Adding Titles, Labels, and Legends/5-1 Adding, editing, and removing chart titles.mp4 8.7 MB
Excel 2010 - Pivot Tables in Depth/6 - Creating and Manipulating PivotCharts/6-3 Filtering a PivotChart.mp4 8.6 MB
Excel 2010 - Pivot Tables in Depth/5 - Applying Conditional Formatting to PivotTables/5-5 Formatting PivotTable cells using icon sets.mp4 8.6 MB
Excel 2010 Essential Training/12 - Creating and Using Charts/12-5 Creating and modifying a pie chart.mov 8.5 MB
Excel 2010 - Advanced Formatting Techniques/6 - Displaying Data as an Outline/6-2 Using outlining symbols and levels.mov 8.4 MB
Excel 2010 - Pivot Tables in Depth/6 - Creating and Manipulating PivotCharts/6-2 Pivoting a PivotChart.mp4 8.3 MB
Excel 2010 - Advanced Formatting Techniques/10 - Specialized Power Formatting Techniques/10-3 Displaying large values without using formulas.mov 8.2 MB
Excel 2010 - Charts in Depth/5 - Layout Tab Options Adding Titles, Labels, and Legends/5-9 Showing the source of a chart's data.mp4 7.1 MB
Excel 2010 - Pivot Tables in Depth/9 - Getting Started with PowerPivot/9-5 Adding tables to a PowerPivot mode.mp4 7.1 MB
Excel 2010 Essential Training/3 - Excel Formula Basics/3-4 Adding numbers using Sum and AutoSum.mov 7.0 MB
Excel 2010 Essential Training/9 - Exploring Excel's Database Features/9-4 Using tables to sort and filter data.mov 7.0 MB
Excel 2010 - Pivot Tables in Depth/6 - Creating and Manipulating PivotCharts/6-7 Adding a trendline to a PivotChart.mp4 7.0 MB
Excel 2010 - Pivot Tables in Depth/2 - Summarizing PivotTable Data/2-4 Creating a calculated field.mp4 7.0 MB
Excel 2010 Essential Training/10 - Analyzing Data/10-4 Using data tables in formulas.mov 6.8 MB
Excel 2010 - Advanced Formatting Techniques/5 - Row, Column, and Sheet Adjustments/5-1 Adjusting single and multiple row heights and column widths without commands.mov 6.8 MB
Excel 2010 - Advanced Formatting Techniques/3 - Alignment Tools/3-4 Simplifying title adjustments with the versatile Merge and Center commands.mov 6.7 MB
Excel 2010 Essential Training/10 - Analyzing Data/10-5 Using scenarios in formulas.mov 6.2 MB
Excel 2010 Essential Training/12 - Creating and Using Charts/12-6 Placing Excel charts into other Office applications.mov 6.1 MB
Excel 2010 - Charts in Depth/7 - Layout Tab Options Using the Analysis Tools/7-3 Adding high-low lines and up-down bars.mp4 6.1 MB
Excel 2010 Essential Training/10 - Analyzing Data/10-3 Working with Goal Seek.mov 6.1 MB
Excel 2010 - Pivot Tables in Depth/5 - Applying Conditional Formatting to PivotTables/5-8 Deleting a conditional formatting rule.mp4 6.1 MB
Excel 2010 - Advanced Formatting Techniques/4 - Other Valuable Formatting Tools/4-4 Formatting text from Word or the web with the Justify feature.mov 6.1 MB
Excel 2010 Essential Training/2 - Worksheet Basics/2-3 Entering data automatically with Auto Fill.mov 6.0 MB
Excel 2010 - Advanced Formatting Techniques/2 - Controlling Fonts, Borders, and Cell Colors/2-5 Using fill color and patterns for cell backgrounds.mov 6.0 MB
Excel 2010 - Charts in Depth/5 - Layout Tab Options Adding Titles, Labels, and Legends/5-3 Linking titles to content.mp4 6.0 MB
Excel 2010 - Advanced Formatting Techniques/3 - Alignment Tools/3-3 Indenting data and dollar signs.mov 6.0 MB
Excel 2010 - Advanced Formatting Techniques/7 - Tables, Themes, Styles and Other Visualization Tools/7-5 Learning the WordArt essentials for titles and headings.mov 5.9 MB
Excel 2010 Essential Training/3 - Excel Formula Basics/3-10 Using SUMIF and AVERAGEIF.mov 5.8 MB
Excel 2010 Essential Training/9 - Exploring Excel's Database Features/9-2 Joining data from multiple cells.mov 5.4 MB
Excel 2010 - Advanced Formatting Techniques/4 - Other Valuable Formatting Tools/4-1 Using the multipurpose Format Cells dialog box and the pop-up mini-toolbar.mov 5.4 MB
Excel 2010 - Advanced Formatting Techniques/10 - Specialized Power Formatting Techniques/10-1 Hiding repeating titles in a column to clarify printed output.mov 5.4 MB
Excel 2010 - Pivot Tables in Depth/3 - Sorting and Filtering PivotTable Data/3-1 Sorting PivotTable data.mp4 5.4 MB
Excel 2010 Essential Training/3 - Excel Formula Basics/3-6 Working with numbers in columns.mov 5.4 MB
Excel 2010 - Pivot Tables in Depth/4 - Formatting PivotTables/4-4 Changing the data field number format.mp4 5.3 MB
Excel 2010 Essential Training/1 - Getting Started/1-3 Finding the commands you need.mov 5.2 MB
Excel 2010 - Advanced Formatting Techniques/4 - Other Valuable Formatting Tools/4-2 Applying different formatting styles within the same cell.mov 5.1 MB