| Lynda.com - Excel 2010 Essential Training/00 Introduction/0001 Welcome.mov |
7.3 MB |
| Lynda.com - Excel 2010 Essential Training/00 Introduction/0002 Using the exercise files.mov |
757 KB |
| Lynda.com - Excel 2010 Essential Training/01 Getting Started/0101 Exploring three common uses for Excel.mov |
3.3 MB |
| Lynda.com - Excel 2010 Essential Training/01 Getting Started/0102 Touring the interface.mov |
7.2 MB |
| Lynda.com - Excel 2010 Essential Training/01 Getting Started/0103 Finding the commands you need.mov |
5 MB |
| Lynda.com - Excel 2010 Essential Training/01 Getting Started/0104 Using Backstage view or the File tab.mov |
3.9 MB |
| Lynda.com - Excel 2010 Essential Training/01 Getting Started/0105 Maintaining file compatibility.mov |
7.2 MB |
| Lynda.com - Excel 2010 Essential Training/02 Worksheet Basics/0201 Creating a worksheet.mov |
5.4 MB |
| Lynda.com - Excel 2010 Essential Training/02 Worksheet Basics/0202 Techniques for copying and pasting.mov |
4.3 MB |
| Lynda.com - Excel 2010 Essential Training/02 Worksheet Basics/0203 Entering data automatically with Auto Fill.mov |
5.8 MB |
| Lynda.com - Excel 2010 Essential Training/02 Worksheet Basics/0204 Targeting large data groups.mov |
6.1 MB |
| Lynda.com - Excel 2010 Essential Training/02 Worksheet Basics/0205 Changing a worksheet's structure.mov |
3.7 MB |
| Lynda.com - Excel 2010 Essential Training/03 Excel Formula Basics/0301 Understanding formulas and functions.mov |
4.6 MB |
| Lynda.com - Excel 2010 Essential Training/03 Excel Formula Basics/0302 Entering data in a worksheet.mov |
3.3 MB |
| Lynda.com - Excel 2010 Essential Training/03 Excel Formula Basics/0303 Adding numbers manually.mov |
4.9 MB |
| Lynda.com - Excel 2010 Essential Training/03 Excel Formula Basics/0304 Adding numbers using Sum and AutoSum.mov |
6.7 MB |
| Lynda.com - Excel 2010 Essential Training/03 Excel Formula Basics/0305 Adding a whole worksheet.mov |
1.9 MB |
| Lynda.com - Excel 2010 Essential Training/03 Excel Formula Basics/0306 Working with numbers in columns.mov |
5.1 MB |
| Lynda.com - Excel 2010 Essential Training/03 Excel Formula Basics/0307 Preventing errors using absolute references.mov |
6.1 MB |
| Lynda.com - Excel 2010 Essential Training/03 Excel Formula Basics/0308 Working with times and dates.mov |
3.4 MB |
| Lynda.com - Excel 2010 Essential Training/03 Excel Formula Basics/0309 Using IF.mov |
4.8 MB |
| Lynda.com - Excel 2010 Essential Training/03 Excel Formula Basics/0310 Using SUMIF and AVERAGEIF.mov |
5.6 MB |
| Lynda.com - Excel 2010 Essential Training/03 Excel Formula Basics/0311 Naming and using cell ranges.mov |
4.1 MB |
| Lynda.com - Excel 2010 Essential Training/04 Essential Formatting/0401 Formatting numbers and dates.mov |
7.8 MB |
| Lynda.com - Excel 2010 Essential Training/04 Essential Formatting/0402 Applying fonts, background colors, and borders.mov |
5.4 MB |
| Lynda.com - Excel 2010 Essential Training/04 Essential Formatting/0403 Adjusting columns, rows, and text.mov |
5.6 MB |
| Lynda.com - Excel 2010 Essential Training/04 Essential Formatting/0404 Using conditional formatting.mov |
5.5 MB |
| Lynda.com - Excel 2010 Essential Training/04 Essential Formatting/0405 Using custom conditional formatting.mov |
7.7 MB |
| Lynda.com - Excel 2010 Essential Training/04 Essential Formatting/0406 Adding pictures and shapes.mov |
9.8 MB |
| Lynda.com - Excel 2010 Essential Training/05 Advanced Formatting/0501 Inserting SmartArt.mov |
8.6 MB |
| Lynda.com - Excel 2010 Essential Training/05 Advanced Formatting/0502 Coordinating a look using themes.mov |
4.8 MB |
| Lynda.com - Excel 2010 Essential Training/05 Advanced Formatting/0503 Applying built-in styles.mov |
4.7 MB |
| Lynda.com - Excel 2010 Essential Training/05 Advanced Formatting/0504 Creating and sharing styles.mov |
7.3 MB |
| Lynda.com - Excel 2010 Essential Training/05 Advanced Formatting/0505 Using templates.mov |
4.6 MB |
| Lynda.com - Excel 2010 Essential Training/05 Advanced Formatting/0506 Creating and using original templates.mov |
3.1 MB |
| Lynda.com - Excel 2010 Essential Training/06 Printing Preparation/0601 Making the pieces fit.mov |
6.1 MB |
| Lynda.com - Excel 2010 Essential Training/06 Printing Preparation/0602 Inserting headers and footers.mov |
4.4 MB |
| Lynda.com - Excel 2010 Essential Training/06 Printing Preparation/0603 Printing and PDFs.mov |
5.1 MB |
| Lynda.com - Excel 2010 Essential Training/07 Large Excel Projects/0701 Finding and replacing data.mov |
4 MB |
| Lynda.com - Excel 2010 Essential Training/07 Large Excel Projects/0702 Freezing panes.mov |
4.9 MB |
| Lynda.com - Excel 2010 Essential Training/07 Large Excel Projects/0703 Repeating row and column titles.mov |
4.3 MB |
| Lynda.com - Excel 2010 Essential Training/07 Large Excel Projects/0704 Creating multiple custom worksheet views.mov |
8.8 MB |
| Lynda.com - Excel 2010 Essential Training/07 Large Excel Projects/0705 Hiding or grouping rows and columns.mov |
7.5 MB |
| Lynda.com - Excel 2010 Essential Training/07 Large Excel Projects/0706 Managing worksheets.mov |
7.8 MB |
| Lynda.com - Excel 2010 Essential Training/07 Large Excel Projects/0707 Calculating formulas across worksheets.mov |
7.1 MB |
| Lynda.com - Excel 2010 Essential Training/08 Collaborating with Others/0801 Importing and exporting data in Excel.mov |
10.1 MB |
| Lynda.com - Excel 2010 Essential Training/08 Collaborating with Others/0802 Setting workbook permissions.mov |
7.4 MB |
| Lynda.com - Excel 2010 Essential Training/08 Collaborating with Others/0803 Inserting and editing comments.mov |
8.5 MB |
| Lynda.com - Excel 2010 Essential Training/08 Collaborating with Others/0804 Sharing a workbook.mov |
1.8 MB |
| Lynda.com - Excel 2010 Essential Training/08 Collaborating with Others/0805 Tracking changes.mov |
3.6 MB |
| Lynda.com - Excel 2010 Essential Training/08 Collaborating with Others/0806 Saving files in shared locations.mov |
12.1 MB |
| Lynda.com - Excel 2010 Essential Training/09 Exploring Excel's Database Features/0901 Splitting cell data into multiple cells.mov |
3 MB |
| Lynda.com - Excel 2010 Essential Training/09 Exploring Excel's Database Features/0902 Joining data from multiple cells.mov |
5.2 MB |
| Lynda.com - Excel 2010 Essential Training/09 Exploring Excel's Database Features/0903 Basic and multi-field sorting.mov |
8.3 MB |
| Lynda.com - Excel 2010 Essential Training/09 Exploring Excel's Database Features/0904 Using tables to sort and filter data.mov |
6.7 MB |
| Lynda.com - Excel 2010 Essential Training/09 Exploring Excel's Database Features/0905 Inserting automatic subtotals.mov |
4.7 MB |
| Lynda.com - Excel 2010 Essential Training/09 Exploring Excel's Database Features/0906 Creating lookup tables.mov |
6.8 MB |
| Lynda.com - Excel 2010 Essential Training/10 Analyzing Data/1001 Using auditing to diagram.mov |
7.1 MB |
| Lynda.com - Excel 2010 Essential Training/10 Analyzing Data/1002 Using evaluation in Excel.mov |
2.2 MB |
| Lynda.com - Excel 2010 Essential Training/10 Analyzing Data/1003 Working with Goal Seek.mov |
5.8 MB |
| Lynda.com - Excel 2010 Essential Training/10 Analyzing Data/1004 Using data tables in formulas.mov |
6.5 MB |
| Lynda.com - Excel 2010 Essential Training/10 Analyzing Data/1005 Using scenarios in formulas.mov |
5.9 MB |
| Lynda.com - Excel 2010 Essential Training/10 Analyzing Data/1006 Exploring the Analysis Toolpak.mov |
9 MB |
| Lynda.com - Excel 2010 Essential Training/11 Advanced Analysis with PivotTables/1101 Discovering PivotTables.mov |
2.3 MB |
| Lynda.com - Excel 2010 Essential Training/11 Advanced Analysis with PivotTables/1102 Creating a basic PivotTable.mov |
3 MB |
| Lynda.com - Excel 2010 Essential Training/11 Advanced Analysis with PivotTables/1103 Modifying a PivotTable.mov |
7.6 MB |
| Lynda.com - Excel 2010 Essential Training/11 Advanced Analysis with PivotTables/1104 Creating and modifying a PivotChart.mov |
7.1 MB |
| Lynda.com - Excel 2010 Essential Training/12 Creating and Using Charts/1201 Choosing chart types.mov |
1.7 MB |
| Lynda.com - Excel 2010 Essential Training/12 Creating and Using Charts/1202 Inserting Sparklines.mov |
4.5 MB |
| Lynda.com - Excel 2010 Essential Training/12 Creating and Using Charts/1203 Creating a column chart.mov |
3.7 MB |
| Lynda.com - Excel 2010 Essential Training/12 Creating and Using Charts/1204 Modifying a column chart.mov |
6.8 MB |
| Lynda.com - Excel 2010 Essential Training/12 Creating and Using Charts/1205 Creating and modifying a pie chart.mov |
8.1 MB |
| Lynda.com - Excel 2010 Essential Training/12 Creating and Using Charts/1206 Placing Excel charts into other Office applications.mov |
5.8 MB |
| Lynda.com - Excel 2010 Essential Training/13 Creating and Using Macros/1301 Understanding macros.mov |
2.8 MB |
| Lynda.com - Excel 2010 Essential Training/13 Creating and Using Macros/1302 Recording and using a simple macro.mov |
14.1 MB |
| Lynda.com - Excel 2010 Essential Training/13 Creating and Using Macros/1303 Editing a macro.mov |
7.2 MB |
| Lynda.com - Excel 2010 Essential Training/14 Customizing Excel/1401 Customizing the Quick Access toolbar.mov |
4.3 MB |
| Lynda.com - Excel 2010 Essential Training/14 Customizing Excel/1402 Customizing the Ribbon bar.mov |
13.2 MB |
| Lynda.com - Excel 2010 Essential Training/14 Customizing Excel/1403 Setting Excel options.mov |
9.7 MB |
| Lynda.com - Excel 2010 Essential Training/15 Conclusion/1501 Goodbye.mov |
244 KB |
| Lynda.com - Excel 2010 Essential Training/Exercise Files/Ex_Files_Excel2010_EssT.zip |
8.2 MB |
Magnet link
