种子简介

种子名称： Lynda.com - Excel 2010 Tutorial Collection (4 courses)
文件类型： 视频
文件数目： 246个文件
文件大小： 2.12 GB
收录时间： 2017-11-12 18:04
已经下载： 3次
资源热度： 189
最近下载： 2024-3-17 03:42

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:38ed72b5bd564da57110c50d0733dc31991408d3&dn=Lynda.com - Excel 2010 Tutorial Collection (4 courses) 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

Lynda.com - Excel 2010 Tutorial Collection (4 courses).torrent

Excel 2010 - Charts in Depth/10 - Adjusting Specific Chart Types/10-1 Using column and bar charts.mp434.09MB

Excel 2010 - Charts in Depth/10 - Adjusting Specific Chart Types/10-4 Using area, stock, and XY charts.mp434.08MB

Excel 2010 - Charts in Depth/10 - Adjusting Specific Chart Types/10-5 Using doughnut, bubble, and radar charts.mp430.67MB

Excel 2010 - Charts in Depth/6 - Layout Tab Options Using Axes and Gridlines/6-1 Modifying axis scaling.mp426.44MB

Excel 2010 - Advanced Formatting Techniques/7 - Tables, Themes, Styles and Other Visualization Tools/7-1 Converting data into a table and reformatting it.mov25.47MB

Excel 2010 - Charts in Depth/1 - Understanding Excel Chart Concepts/1-2 Selecting the right chart type.mp425.42MB

Excel 2010 - Charts in Depth/7 - Layout Tab Options Using the Analysis Tools/7-1 Analyzing existing and future data with trendlines.mp422.31MB

Excel 2010 - Charts in Depth/1 - Understanding Excel Chart Concepts/1-1 Identifying chart elements like plot area, chart area, gridlines, and legends.mp421.22MB

Excel 2010 - Charts in Depth/12 - Printing and Sharing Charts/12-1 Printing charts.mp420.34MB

Excel 2010 - Charts in Depth/3 - Fine-Tuning Charts with Design Tab Choices/3-3 Dealing with empty and hidden cells.mp419.89MB

Excel 2010 - Charts in Depth/2 - Creating Basic Charts Quickly/2-5 Creating graphic-in-cell charts with sparklines.mp419.77MB

Excel 2010 - Charts in Depth/1 - Understanding Excel Chart Concepts/1-3 Understanding chart terminology.mp419.3MB

Excel 2010 - Charts in Depth/10 - Adjusting Specific Chart Types/10-3 Using pie charts.mp418.99MB

Excel 2010 - Charts in Depth/5 - Layout Tab Options Adding Titles, Labels, and Legends/5-8 Adding and editing data labels.mp418.93MB

Excel 2010 - Charts in Depth/8 - Format Tab Options Adding Shapes and WordArt Styles/8-2 Adding shape effects.mp418.91MB

Excel 2010 - Charts in Depth/10 - Adjusting Specific Chart Types/10-2 Using line charts.mp418.86MB

Excel 2010 - Advanced Formatting Techniques/7 - Tables, Themes, Styles and Other Visualization Tools/7-2 Using styles and themes for consistent formatting.mov16.94MB

Excel 2010 - Charts in Depth/8 - Format Tab Options Adding Shapes and WordArt Styles/8-1 Selecting shape fill and outline.mp416.31MB

Excel 2010 - Advanced Formatting Techniques/1 - Adjusting Numeric Formats Quickly/1-1 Working with the numeric formatting options.mov16.17MB

Excel 2010 - Charts in Depth/7 - Layout Tab Options Using the Analysis Tools/7-4 Adding error bars.mp415.17MB

Excel 2010 - Advanced Formatting Techniques/1 - Adjusting Numeric Formats Quickly/1-3 Setting special formats for dates, times, phone numbers, fractions, etc.mov15.15MB

Excel 2010 - Pivot Tables in Depth/8 - Manipulating PivotTables Using Macros/8-2 Running a macro.mp415.1MB

Excel 2010 - Charts in Depth/12 - Printing and Sharing Charts/12-2 Copying and linking charts with Word and PowerPoint.mp414.76MB

Excel 2010 - Advanced Formatting Techniques/1 - Adjusting Numeric Formats Quickly/1-4 Building custom numeric formats.mov14.27MB

Excel 2010 - Charts in Depth/3 - Fine-Tuning Charts with Design Tab Choices/3-7 Moving and resizing a chart.mp414.25MB

Excel 2010 - Charts in Depth/6 - Layout Tab Options Using Axes and Gridlines/6-2 Working with gridlines.mp414.17MB

Excel 2010 Essential Training/13 - Creating and Using Macros/13-2 Recording and using a simple macro.mov14.08MB

Excel 2010 - Pivot Tables in Depth/4 - Formatting PivotTables/4-1 Applying a PivotTable style.mp413.99MB

Excel 2010 - Charts in Depth/4 - Layout Tab Options Inserting Pictures, Shapes, and Text Boxes/4-1 Using pictures as chart elements.mp413.8MB

Excel 2010 - Pivot Tables in Depth/4 - Formatting PivotTables/4-2 Creating a PivotTable style.mp413.74MB

Excel 2010 - Advanced Formatting Techniques/1 - Adjusting Numeric Formats Quickly/1-2 Learning the important formatting keystroke shortcuts.mov13.57MB

Excel 2010 - Charts in Depth/2 - Creating Basic Charts Quickly/2-1 Selecting data to display as a chart.mp413.37MB

Excel 2010 - Charts in Depth/5 - Layout Tab Options Adding Titles, Labels, and Legends/5-4 Showing numbers of different scales.mp413.27MB

Excel 2010 Essential Training/14 - Customizing Excel/14-2 Customizing the Ribbon bar.mov13.18MB

Excel 2010 - Advanced Formatting Techniques/7 - Tables, Themes, Styles and Other Visualization Tools/7-4 Fine-tuning shape effects.mov13.16MB

Excel 2010 - Advanced Formatting Techniques/7 - Tables, Themes, Styles and Other Visualization Tools/7-6 Formatting Sparklines for optimum impact.mov13.07MB

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.mp412.97MB

Excel 2010 - Advanced Formatting Techniques/1 - Adjusting Numeric Formats Quickly/1-5 Building custom date formats.mov12.92MB

Excel 2010 - Pivot Tables in Depth/3 - Sorting and Filtering PivotTable Data/3-8 Filtering a PivotTable with report filter fields.mp412.42MB

Excel 2010 - Pivot Tables in Depth/2 - Summarizing PivotTable Data/2-2 Changing the PivotTable data field summary operation.mp412.33MB

Excel 2010 - Pivot Tables in Depth/10 - Working with DAX Expressions/10-6 Using filters in aggregate functions.mp412.12MB

Excel 2010 - Charts in Depth/5 - Layout Tab Options Adding Titles, Labels, and Legends/5-6 Changing the numeric format on labels.mp412.09MB

Excel 2010 Essential Training/8 - Collaborating with Others/8-6 Saving files in shared locations.mov12.08MB

Excel 2010 - Pivot Tables in Depth/9 - Getting Started with PowerPivot/9-6 Creating relationships between tables.mp412.06MB

Excel 2010 - Pivot Tables in Depth/2 - Summarizing PivotTable Data/2-6 Using PivotTable data in a formula.mp411.99MB

Excel 2010 - Advanced Formatting Techniques/2 - Controlling Fonts, Borders, and Cell Colors/2-4 Applying border styles and adjusting gridlines.mov11.97MB

Excel 2010 - Charts in Depth/3 - Fine-Tuning Charts with Design Tab Choices/3-4 Choosing a chart layout.mp411.89MB

Excel 2010 - Charts in Depth/9 - Using Other Formatting Tools/9-2 Filling an area with a color gradient.mp411.86MB

Excel 2010 - Pivot Tables in Depth/1 - Creating and Pivoting PivotTables/1-2 Formatting data for use in a PivotTable.mp411.79MB

Excel 2010 - Pivot Tables in Depth/9 - Getting Started with PowerPivot/9-4 Managing table columns.mp411.78MB

Excel 2010 - Charts in Depth/3 - Fine-Tuning Charts with Design Tab Choices/3-2 Setting a default chart type and creating a template.mp411.66MB

Excel 2010 - Advanced Formatting Techniques/6 - Displaying Data as an Outline/6-1 Setting up data for outlining.mov11.63MB

Excel 2010 - Advanced Formatting Techniques/4 - Other Valuable Formatting Tools/4-5 Adding a background image to a worksheet.mov11.61MB

Excel 2010 - Charts in Depth/11 - Changing a Chart's Data Source/11-2 Creating charts from multiple data sources.mp411.6MB

Excel 2010 - Pivot Tables in Depth/1 - Creating and Pivoting PivotTables/1-9 Updating and refreshing PivotTable data sources.mp411.55MB

Excel 2010 - Charts in Depth/9 - Using Other Formatting Tools/9-1 Formatting lines and borders.mp411.37MB

Excel 2010 - Charts in Depth/11 - Changing a Chart's Data Source/11-3 Adding new data using a table.mp411.36MB

Excel 2010 - Pivot Tables in Depth/6 - Creating and Manipulating PivotCharts/6-6 Changing a PivotChart's chart type.mp411.31MB

Excel 2010 - Pivot Tables in Depth/1 - Creating and Pivoting PivotTables/1-3 Creating a PivotTable.mp411.25MB

Excel 2010 - Charts in Depth/1 - Understanding Excel Chart Concepts/1-4 Understanding the Ribbon and the Design, Layout, and Format tabs.mp411.22MB

Excel 2010 - Pivot Tables in Depth/1 - Creating and Pivoting PivotTables/1-8 Consolidating data from multiple sources.mp411.05MB

Excel 2010 - Pivot Tables in Depth/10 - Working with DAX Expressions/10-5 Using aggregate functions.mp411.05MB

Excel 2010 - Pivot Tables in Depth/8 - Manipulating PivotTables Using Macros/8-1 Recording and reviewing a macro.mp411.05MB

Excel 2010 - Pivot Tables in Depth/1 - Creating and Pivoting PivotTables/1-1 Introducing PivotTables.mp410.92MB

Excel 2010 - Pivot Tables in Depth/10 - Working with DAX Expressions/10-4 Adding calculated columns and measures.mp410.77MB

Excel 2010 - Advanced Formatting Techniques/9 - Dynamically Accentuating Data with Conditional Formatting/9-3 Creating formats based on formulas.mov10.51MB

Excel 2010 - Pivot Tables in Depth/5 - Applying Conditional Formatting to PivotTables/5-3 Formatting PivotTable cells using data bars.mp410.5MB

Excel 2010 - Pivot Tables in Depth/6 - Creating and Manipulating PivotCharts/6-4 Formatting a PivotChart.mp410.46MB

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.mp410.45MB

Excel 2010 - Pivot Tables in Depth/10 - Working with DAX Expressions/10-2 Using DAX operators.mp410.44MB

Excel 2010 - Advanced Formatting Techniques/5 - Row, Column, and Sheet Adjustments/5-3 Working with the Hide Unhide options.mov10.41MB

Excel 2010 - Charts in Depth/5 - Layout Tab Options Adding Titles, Labels, and Legends/5-2 Adding horizontal and vertical titles.mp410.4MB

Excel 2010 - Charts in Depth/9 - Using Other Formatting Tools/9-5 Changing the rotation of chart text.mp410.37MB

Excel 2010 - Charts in Depth/3 - Fine-Tuning Charts with Design Tab Choices/3-5 Choosing a chart style from 48 colorful variations.mp410.25MB

Excel 2010 - Pivot Tables in Depth/3 - Sorting and Filtering PivotTable Data/3-6 Filtering a PivotTable using slicers.mp410.24MB

Excel 2010 - Pivot Tables in Depth/5 - Applying Conditional Formatting to PivotTables/5-4 Formatting PivotTable cells using color scales.mp410.24MB

Excel 2010 - Pivot Tables in Depth/1 - Creating and Pivoting PivotTables/1-4 Pivoting a PivotTable.mp410.17MB

Excel 2010 - Charts in Depth/4 - Layout Tab Options Inserting Pictures, Shapes, and Text Boxes/4-2 Adding shapes and arrows.mp410.16MB

Excel 2010 Essential Training/8 - Collaborating with Others/8-1 Importing and exporting data in Excel.mov10.1MB

Excel 2010 - Pivot Tables in Depth/7 - Printing PivotTables and PivotCharts/7-1 Printing a PivotTable.mp49.94MB

Excel 2010 - Charts in Depth/4 - Layout Tab Options Inserting Pictures, Shapes, and Text Boxes/4-3 Adding floating text and text boxes.mp49.9MB

Excel 2010 Essential Training/4 - Essential Formatting/4-6 Adding pictures and shapes.mov9.81MB

Excel 2010 - Pivot Tables in Depth/1 - Creating and Pivoting PivotTables/1-5 Configuring a PivotTable.mp49.71MB

Excel 2010 Essential Training/14 - Customizing Excel/14-3 Setting Excel options.mov9.69MB

Excel 2010 - Advanced Formatting Techniques/9 - Dynamically Accentuating Data with Conditional Formatting/9-2 Creating value-based formatting using data bars and color scales.mov9.69MB

Excel 2010 - Pivot Tables in Depth/3 - Sorting and Filtering PivotTable Data/3-7 Formatting slicers.mp49.59MB

Excel 2010 - Pivot Tables in Depth/5 - Applying Conditional Formatting to PivotTables/5-7 Controlling how multiple rules are applied.mp49.4MB

Excel 2010 - Pivot Tables in Depth/3 - Sorting and Filtering PivotTable Data/3-2 Creating a custom sort order.mp49.35MB

Excel 2010 - Advanced Formatting Techniques/7 - Tables, Themes, Styles and Other Visualization Tools/7-3 Understanding the options in shape formatting.mov9.13MB

Excel 2010 - Pivot Tables in Depth/10 - Working with DAX Expressions/10-3 Surveying DAX functions.mp49.08MB

Excel 2010 - Pivot Tables in Depth/5 - Applying Conditional Formatting to PivotTables/5-2 Highlighting the top or bottom values in a PivotTable.mp49.03MB

Excel 2010 - Pivot Tables in Depth/1 - Creating and Pivoting PivotTables/1-6 Connecting to an external data source.mp49.01MB

Excel 2010 - Pivot Tables in Depth/1 - Creating and Pivoting PivotTables/1-10 Managing PivotTables.mp49MB

Excel 2010 - Advanced Formatting Techniques/5 - Row, Column, and Sheet Adjustments/5-2 Working with rows, columns, and sheets.mov8.98MB

Excel 2010 Essential Training/10 - Analyzing Data/10-6 Exploring the Analysis Toolpak.mov8.96MB

Excel 2010 - Pivot Tables in Depth/2 - Summarizing PivotTable Data/2-1 Adding, removing, and positioning subtotals and grand totals.mp48.89MB

Excel 2010 Essential Training/7 - Large Excel Projects/7-4 Creating multiple custom worksheet views.mov8.78MB

Excel 2010 - Pivot Tables in Depth/7 - Printing PivotTables and PivotCharts/7-2 Printing each item on its own page.mp48.77MB

Excel 2010 - Charts in Depth/9 - Using Other Formatting Tools/9-4 Working with chart text.mp48.71MB

Excel 2010 - Pivot Tables in Depth/2 - Summarizing PivotTable Data/2-3 Summarizing more than one data field.mp48.7MB

Excel 2010 - Charts in Depth/9 - Using Other Formatting Tools/9-3 Specifying line style, color, and weight.mp48.64MB

Excel 2010 - Charts in Depth/11 - Changing a Chart's Data Source/11-1 Pasting new data into a chart.mp48.6MB

Excel 2010 - Pivot Tables in Depth/6 - Creating and Manipulating PivotCharts/6-1 Creating a PivotChart.mp48.57MB

Excel 2010 Essential Training/5 - Advanced Formatting/5-1 Inserting SmartArt.mov8.56MB

Excel 2010 - Pivot Tables in Depth/4 - Formatting PivotTables/4-3 Changing the PivotTable layout.mp48.48MB

Excel 2010 - Pivot Tables in Depth/8 - Manipulating PivotTables Using Macros/8-3 Creating a simple PivotTable presentation kit.mp48.48MB

Excel 2010 Essential Training/8 - Collaborating with Others/8-3 Inserting and editing comments.mov8.46MB

Excel 2010 - Advanced Formatting Techniques/3 - Alignment Tools/3-5 Controlling titles and headings with the Wrap Text and Shrink to Fit options.mov8.45MB

Excel 2010 - Pivot Tables in Depth/3 - Sorting and Filtering PivotTable Data/3-3 Filtering a PivotTable field by selection.mp48.41MB

Excel 2010 Essential Training/9 - Exploring Excel's Database Features/9-3 Basic and multi-field sorting.mov8.32MB

Excel 2010 - Pivot Tables in Depth/10 - Working with DAX Expressions/10-1 Introducing the DAX language.mp48.29MB

Excel 2010 - Advanced Formatting Techniques/4 - Other Valuable Formatting Tools/4-3 Copying formats quickly with dragging techniques and the Format Painter.mov8.27MB

Excel 2010 - Charts in Depth/5 - Layout Tab Options Adding Titles, Labels, and Legends/5-1 Adding, editing, and removing chart titles.mp48.27MB

Excel 2010 - Pivot Tables in Depth/6 - Creating and Manipulating PivotCharts/6-3 Filtering a PivotChart.mp48.23MB

Excel 2010 - Pivot Tables in Depth/5 - Applying Conditional Formatting to PivotTables/5-5 Formatting PivotTable cells using icon sets.mp48.16MB

Excel 2010 Essential Training/12 - Creating and Using Charts/12-5 Creating and modifying a pie chart.mov8.13MB

Excel 2010 - Advanced Formatting Techniques/6 - Displaying Data as an Outline/6-2 Using outlining symbols and levels.mov7.98MB

Excel 2010 - Pivot Tables in Depth/6 - Creating and Manipulating PivotCharts/6-2 Pivoting a PivotChart.mp47.92MB

Excel 2010 - Advanced Formatting Techniques/0 - Introduction/0-1 Welcome.mov7.91MB

Excel 2010 - Pivot Tables in Depth/3 - Sorting and Filtering PivotTable Data/3-5 Filtering a PivotTable using a search filter.mp47.88MB

Excel 2010 Essential Training/4 - Essential Formatting/4-1 Formatting numbers and dates.mov7.81MB

Excel 2010 - Advanced Formatting Techniques/10 - Specialized Power Formatting Techniques/10-3 Displaying large values without using formulas.mov7.8MB

Excel 2010 Essential Training/7 - Large Excel Projects/7-6 Managing worksheets.mov7.79MB

Excel 2010 Essential Training/4 - Essential Formatting/4-5 Using custom conditional formatting.mov7.72MB

Excel 2010 - Advanced Formatting Techniques/8 - Adding Pictures/8-1 Converting a chart to a picture and adding new images.mov7.66MB

Excel 2010 - Pivot Tables in Depth/2 - Summarizing PivotTable Data/2-5 Grouping PivotTable fields.mp47.66MB

Excel 2010 - Advanced Formatting Techniques/2 - Controlling Fonts, Borders, and Cell Colors/2-1 Applying and adjusting fonts and font colors.mov7.65MB

Excel 2010 Essential Training/11 - Advanced Analysis with PivotTables/11-3 Modifying a PivotTable.mov7.64MB

Excel 2010 - Pivot Tables in Depth/9 - Getting Started with PowerPivot/9-3 Importing PowerPivot data.mp47.6MB

Excel 2010 - Pivot Tables in Depth/9 - Getting Started with PowerPivot/9-2 Downloading and installing PowerPivot.mp47.56MB

Excel 2010 - Advanced Formatting Techniques/3 - Alignment Tools/3-2 Creating angled text variations for greater variety and readability.mov7.52MB

Excel 2010 Essential Training/7 - Large Excel Projects/7-5 Hiding or grouping rows and columns.mov7.51MB

Excel 2010 - Pivot Tables in Depth/5 - Applying Conditional Formatting to PivotTables/5-1 Highlighting cells by applying a rule.mp47.48MB

Excel 2010 - Charts in Depth/5 - Layout Tab Options Adding Titles, Labels, and Legends/5-7 Adding, editing, and removing legends.mp47.42MB

Excel 2010 Essential Training/8 - Collaborating with Others/8-2 Setting workbook permissions.mov7.35MB

Excel 2010 Essential Training/5 - Advanced Formatting/5-4 Creating and sharing styles.mov7.31MB

Excel 2010 - Pivot Tables in Depth/3 - Sorting and Filtering PivotTable Data/3-4 Filtering a PivotTable by rule.mp47.29MB

Excel 2010 Essential Training/0 - Introduction/0-1 Welcome.mov7.26MB

Excel 2010 Essential Training/13 - Creating and Using Macros/13-3 Editing a macro.mov7.21MB

Excel 2010 Essential Training/1 - Getting Started/1-2 Touring the interface.mov7.18MB

Excel 2010 Essential Training/1 - Getting Started/1-5 Maintaining file compatibility.mov7.16MB

Excel 2010 - Pivot Tables in Depth/6 - Creating and Manipulating PivotCharts/6-5 Changing a PivotChart's layout.mp47.15MB

Excel 2010 Essential Training/11 - Advanced Analysis with PivotTables/11-4 Creating and modifying a PivotChart.mov7.14MB

Excel 2010 Essential Training/10 - Analyzing Data/10-1 Using auditing to diagram.mov7.07MB

Excel 2010 Essential Training/7 - Large Excel Projects/7-7 Calculating formulas across worksheets.mov7.06MB

Excel 2010 - Charts in Depth/8 - Format Tab Options Adding Shapes and WordArt Styles/8-3 Applying WordArt styles.mp47.05MB

Excel 2010 - Charts in Depth/2 - Creating Basic Charts Quickly/2-2 Creating charts instantly with shortcuts.mp47.05MB

Excel 2010 - Charts in Depth/2 - Creating Basic Charts Quickly/2-4 Creating presentation-ready charts with just a few adjustments.mp46.93MB

Excel 2010 - Charts in Depth/3 - Fine-Tuning Charts with Design Tab Choices/3-6 Changing the location of a chart.mp46.84MB

Excel 2010 Essential Training/12 - Creating and Using Charts/12-4 Modifying a column chart.mov6.84MB

Excel 2010 Essential Training/9 - Exploring Excel's Database Features/9-6 Creating lookup tables.mov6.78MB

Excel 2010 - Charts in Depth/5 - Layout Tab Options Adding Titles, Labels, and Legends/5-9 Showing the source of a chart's data.mp46.77MB

Excel 2010 - Pivot Tables in Depth/9 - Getting Started with PowerPivot/9-5 Adding tables to a PowerPivot mode.mp46.75MB

Excel 2010 Essential Training/3 - Excel Formula Basics/3-4 Adding numbers using Sum and AutoSum.mov6.72MB

Excel 2010 Essential Training/9 - Exploring Excel's Database Features/9-4 Using tables to sort and filter data.mov6.67MB

Excel 2010 - Pivot Tables in Depth/6 - Creating and Manipulating PivotCharts/6-7 Adding a trendline to a PivotChart.mp46.63MB

Excel 2010 - Pivot Tables in Depth/2 - Summarizing PivotTable Data/2-4 Creating a calculated field.mp46.63MB

Excel 2010 Essential Training/10 - Analyzing Data/10-4 Using data tables in formulas.mov6.51MB

Excel 2010 - Advanced Formatting Techniques/5 - Row, Column, and Sheet Adjustments/5-1 Adjusting single and multiple row heights and column widths without commands.mov6.44MB

Excel 2010 - Advanced Formatting Techniques/3 - Alignment Tools/3-4 Simplifying title adjustments with the versatile Merge and Center commands.mov6.43MB

Excel 2010 - Advanced Formatting Techniques/3 - Alignment Tools/3-1 Adjusting horizontal and vertical cell alignment.mov6.4MB

Excel 2010 - Advanced Formatting Techniques/10 - Specialized Power Formatting Techniques/10-2 Restoring missing title data in a column.mov6.36MB

Excel 2010 - Charts in Depth/0 - Introduction/0-1 Welcome.mp46.33MB

Excel 2010 - Advanced Formatting Techniques/8 - Adding Pictures/8-3 Adding borders and effects to pictures.mov6.26MB

Excel 2010 - Advanced Formatting Techniques/9 - Dynamically Accentuating Data with Conditional Formatting/9-1 Creating value-based formatting using logical operators.mov6.26MB

Excel 2010 - Pivot Tables in Depth/9 - Getting Started with PowerPivot/9-1 Introducing PowerPivot.mp46.19MB

Excel 2010 Essential Training/6 - Printing Preparation/6-1 Making the pieces fit.mov6.11MB

Excel 2010 Essential Training/3 - Excel Formula Basics/3-7 Preventing errors using absolute references.mov6.07MB

Excel 2010 Essential Training/2 - Worksheet Basics/2-4 Targeting large data groups.mov6.07MB

Excel 2010 - Pivot Tables in Depth/5 - Applying Conditional Formatting to PivotTables/5-6 Editing conditional formatting rules.mp46.03MB

Excel 2010 - Advanced Formatting Techniques/2 - Controlling Fonts, Borders, and Cell Colors/2-3 Applying underline, strikethrough, subscript, and superscript formatting .mov5.98MB

Excel 2010 Essential Training/10 - Analyzing Data/10-5 Using scenarios in formulas.mov5.94MB

Excel 2010 Essential Training/12 - Creating and Using Charts/12-6 Placing Excel charts into other Office applications.mov5.83MB

Excel 2010 - Charts in Depth/7 - Layout Tab Options Using the Analysis Tools/7-3 Adding high-low lines and up-down bars.mp45.82MB

Excel 2010 Essential Training/10 - Analyzing Data/10-3 Working with Goal Seek.mov5.8MB

Excel 2010 - Pivot Tables in Depth/5 - Applying Conditional Formatting to PivotTables/5-8 Deleting a conditional formatting rule.mp45.79MB

Excel 2010 - Advanced Formatting Techniques/4 - Other Valuable Formatting Tools/4-4 Formatting text from Word or the web with the Justify feature.mov5.79MB

Excel 2010 Essential Training/2 - Worksheet Basics/2-3 Entering data automatically with Auto Fill.mov5.76MB

Excel 2010 - Advanced Formatting Techniques/2 - Controlling Fonts, Borders, and Cell Colors/2-5 Using fill color and patterns for cell backgrounds.mov5.69MB

Excel 2010 - Charts in Depth/5 - Layout Tab Options Adding Titles, Labels, and Legends/5-3 Linking titles to content.mp45.69MB

Excel 2010 - Advanced Formatting Techniques/3 - Alignment Tools/3-3 Indenting data and dollar signs.mov5.67MB

Excel 2010 - Pivot Tables in Depth/0 - Introduction/0-1 Welcome.mp45.64MB

Excel 2010 - Pivot Tables in Depth/1 - Creating and Pivoting PivotTables/1-7 Connecting to an Access database.mp45.61MB

Excel 2010 Essential Training/4 - Essential Formatting/4-3 Adjusting columns, rows, and text.mov5.59MB

Excel 2010 - Advanced Formatting Techniques/7 - Tables, Themes, Styles and Other Visualization Tools/7-5 Learning the WordArt essentials for titles and headings.mov5.59MB

Excel 2010 Essential Training/3 - Excel Formula Basics/3-10 Using SUMIF and AVERAGEIF.mov5.55MB

Excel 2010 Essential Training/4 - Essential Formatting/4-4 Using conditional formatting.mov5.5MB

Excel 2010 Essential Training/4 - Essential Formatting/4-2 Applying fonts, background colors, and borders.mov5.38MB

Excel 2010 Essential Training/2 - Worksheet Basics/2-1 Creating a worksheet.mov5.38MB

Excel 2010 Essential Training/9 - Exploring Excel's Database Features/9-2 Joining data from multiple cells.mov5.18MB

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.mov5.17MB

Excel 2010 - Advanced Formatting Techniques/10 - Specialized Power Formatting Techniques/10-1 Hiding repeating titles in a column to clarify printed output.mov5.16MB

Excel 2010 - Pivot Tables in Depth/3 - Sorting and Filtering PivotTable Data/3-1 Sorting PivotTable data.mp45.15MB

Excel 2010 Essential Training/6 - Printing Preparation/6-3 Printing and PDFs.mov5.13MB

Excel 2010 Essential Training/3 - Excel Formula Basics/3-6 Working with numbers in columns.mov5.11MB

Excel 2010 - Pivot Tables in Depth/4 - Formatting PivotTables/4-4 Changing the data field number format.mp45.05MB

Excel 2010 Essential Training/1 - Getting Started/1-3 Finding the commands you need.mov5MB

Excel 2010 - Advanced Formatting Techniques/4 - Other Valuable Formatting Tools/4-2 Applying different formatting styles within the same cell.mov4.89MB

Excel 2010 Essential Training/3 - Excel Formula Basics/3-3 Adding numbers manually.mov4.86MB

Excel 2010 Essential Training/7 - Large Excel Projects/7-2 Freezing panes.mov4.86MB

Excel 2010 Essential Training/3 - Excel Formula Basics/3-9 Using IF.mov4.83MB

Excel 2010 Essential Training/5 - Advanced Formatting/5-2 Coordinating a look using themes.mov4.82MB

Excel 2010 Essential Training/9 - Exploring Excel's Database Features/9-5 Inserting automatic subtotals.mov4.69MB

Excel 2010 Essential Training/5 - Advanced Formatting/5-3 Applying built-in styles.mov4.68MB

Excel 2010 Essential Training/3 - Excel Formula Basics/3-1 Understanding formulas and functions.mov4.63MB

Excel 2010 Essential Training/5 - Advanced Formatting/5-5 Using templates.mov4.56MB

Excel 2010 Essential Training/12 - Creating and Using Charts/12-2 Inserting Sparklines.mov4.52MB

Excel 2010 - Pivot Tables in Depth/7 - Printing PivotTables and PivotCharts/7-3 Printing a PivotChart.mp44.5MB

Excel 2010 - Charts in Depth/7 - Layout Tab Options Using the Analysis Tools/7-2 Adding drop lines.mp44.44MB

Excel 2010 Essential Training/6 - Printing Preparation/6-2 Inserting headers and footers.mov4.43MB

Excel 2010 Essential Training/7 - Large Excel Projects/7-3 Repeating row and column titles.mov4.34MB

Excel 2010 Essential Training/14 - Customizing Excel/14-1 Customizing the Quick Access toolbar.mov4.31MB

Excel 2010 Essential Training/2 - Worksheet Basics/2-2 Techniques for copying and pasting.mov4.3MB

Excel 2010 - Advanced Formatting Techniques/8 - Adding Pictures/8-2 Applying picture styles.mov4.27MB

Excel 2010 - Pivot Tables in Depth/2 - Summarizing PivotTable Data/2-7 Drilling down to the underlying data.mp44.19MB

Excel 2010 Essential Training/3 - Excel Formula Basics/3-11 Naming and using cell ranges.mov4.11MB

Excel 2010 Essential Training/7 - Large Excel Projects/7-1 Finding and replacing data.mov3.97MB

Excel 2010 - Charts in Depth/2 - Creating Basic Charts Quickly/2-3 Creating charts with standard menu commands.mp43.92MB

Excel 2010 Essential Training/1 - Getting Started/1-4 Using Backstage view or the File tab.mov3.92MB

Excel 2010 - Advanced Formatting Techniques/2 - Controlling Fonts, Borders, and Cell Colors/2-2 Adding custom formats with font color variations.mov3.74MB

Excel 2010 - Advanced Formatting Techniques/10 - Specialized Power Formatting Techniques/10-5 Formatting a list for double-spaced printing.mov3.71MB

Excel 2010 Essential Training/2 - Worksheet Basics/2-5 Changing a worksheet's structure.mov3.68MB

Excel 2010 Essential Training/12 - Creating and Using Charts/12-3 Creating a column chart.mov3.66MB

Excel 2010 Essential Training/8 - Collaborating with Others/8-5 Tracking changes.mov3.65MB

Excel 2010 - Pivot Tables in Depth/3 - Sorting and Filtering PivotTable Data/3-9 Clearing and reapplying PivotTable filters.mp43.56MB

Excel 2010 - Advanced Formatting Techniques/10 - Specialized Power Formatting Techniques/10-4 Formatting column row titles.mov3.45MB

Excel 2010 Essential Training/3 - Excel Formula Basics/3-8 Working with times and dates.mov3.38MB

Excel 2010 Essential Training/3 - Excel Formula Basics/3-2 Entering data in a worksheet.mov3.33MB

Excel 2010 Essential Training/1 - Getting Started/1-1 Exploring three common uses for Excel.mov3.27MB

Excel 2010 Essential Training/5 - Advanced Formatting/5-6 Creating and using original templates.mov3.06MB

Excel 2010 Essential Training/11 - Advanced Analysis with PivotTables/11-2 Creating a basic PivotTable.mov3.03MB

Excel 2010 Essential Training/9 - Exploring Excel's Database Features/9-1 Splitting cell data into multiple cells.mov3MB

Excel 2010 Essential Training/13 - Creating and Using Macros/13-1 Understanding macros.mov2.8MB

Excel 2010 - Charts in Depth/0 - Introduction/0-2 Using the exercise files.mp42.7MB

Excel 2010 Essential Training/11 - Advanced Analysis with PivotTables/11-1 Discovering PivotTables.mov2.28MB

Excel 2010 Essential Training/10 - Analyzing Data/10-2 Using evaluation in Excel.mov2.24MB

Excel 2010 Essential Training/3 - Excel Formula Basics/3-5 Adding a whole worksheet.mov1.86MB

Excel 2010 Essential Training/8 - Collaborating with Others/8-4 Sharing a workbook.mov1.76MB

Excel 2010 Essential Training/12 - Creating and Using Charts/12-1 Choosing chart types.mov1.73MB

Excel 2010 - Advanced Formatting Techniques/Conclusion/Final thoughts.mov1.73MB

Excel 2010 - Pivot Tables in Depth/Conclusion/Additional resources.mp41.51MB

Excel 2010 - Charts in Depth/Conclusion/Next steps.mp41.41MB

Excel 2010 - Pivot Tables in Depth/0 - Introduction/0-2 Using the exercise files.mp41.14MB

Excel 2010 - Advanced Formatting Techniques/0 - Introduction/0-2 Using the exercise files.mov1004.79KB

Excel 2010 Essential Training/0 - Introduction/0-2 Using the exercise files.mov756.53KB

Excel 2010 Essential Training/Conclusion/Goodbye.mov244.38KB