Lynda Excel 3Courses
File List
| File | Size |
|---|---|
| Excel 2010 Macros in Depth/lce2010m.cue | 74 B |
| Essential Training/15 Conclusion/1501 Goodbye.mov | 244.38 KB |
| Essential Training/00 Introduction/0002 Using the exercise files.mov | 756.53 KB |
| Managing Multiple Worksheets and Workbooks/00 Introduction/0002 Using the exercise files.mov | 1.36 MB |
| Essential Training/12 Creating and Using Charts/1201 Choosing chart types.mov | 1.73 MB |
| Essential Training/08 Collaborating with Others/0804 Sharing a workbook.mov | 1.76 MB |
| Essential Training/03 Excel Formula Basics/0305 Adding a whole worksheet.mov | 1.86 MB |
| Essential Training/10 Analyzing Data/1002 Using evaluation in Excel.mov | 2.24 MB |
| Essential Training/11 Advanced Analysis with PivotTables/1101 Discovering PivotTables.mov | 2.28 MB |
| Managing Multiple Worksheets and Workbooks/06 Conclusion/0601 Final thoughts.mov | 2.71 MB |
| Essential Training/13 Creating and Using Macros/1301 Understanding macros.mov | 2.8 MB |
| Essential Training/09 Exploring Excel's Database Features/0901 Splitting cell data into multiple cells.mov | 3 MB |
| Essential Training/11 Advanced Analysis with PivotTables/1102 Creating a basic PivotTable.mov | 3.03 MB |
| Essential Training/05 Advanced Formatting/0506 Creating and using original templates.mov | 3.06 MB |
| Essential Training/01 Getting Started/0101 Exploring three common uses for Excel.mov | 3.27 MB |
| Essential Training/03 Excel Formula Basics/0302 Entering data in a worksheet.mov | 3.33 MB |
| Essential Training/03 Excel Formula Basics/0308 Working with times and dates.mov | 3.38 MB |
| Managing Multiple Worksheets and Workbooks/Exercise Files/Exercise Files.rar | 3.54 MB |
| Essential Training/08 Collaborating with Others/0805 Tracking changes.mov | 3.65 MB |
| Essential Training/12 Creating and Using Charts/1203 Creating a column chart.mov | 3.66 MB |
| Essential Training/02 Worksheet Basics/0205 Changing a worksheet's structure.mov | 3.68 MB |
| Essential Training/01 Getting Started/0104 Using Backstage view or the File tab.mov | 3.92 MB |
| Essential Training/07 Large Excel Projects/0701 Finding and replacing data.mov | 3.97 MB |
| Essential Training/03 Excel Formula Basics/0311 Naming and using cell ranges.mov | 4.11 MB |
| Essential Training/02 Worksheet Basics/0202 Techniques for copying and pasting.mov | 4.3 MB |
| Essential Training/14 Customizing Excel/1401 Customizing the Quick Access toolbar.mov | 4.31 MB |
| Essential Training/07 Large Excel Projects/0703 Repeating row and column titles.mov | 4.34 MB |
| Essential Training/06 Printing Preparation/0602 Inserting headers and footers.mov | 4.43 MB |
| Essential Training/12 Creating and Using Charts/1202 Inserting Sparklines.mov | 4.52 MB |
| Essential Training/05 Advanced Formatting/0505 Using templates.mov | 4.56 MB |
| Essential Training/03 Excel Formula Basics/0301 Understanding formulas and functions.mov | 4.63 MB |
| Essential Training/05 Advanced Formatting/0503 Applying built-in styles.mov | 4.68 MB |
| Essential Training/09 Exploring Excel's Database Features/0905 Inserting automatic subtotals.mov | 4.69 MB |
| Essential Training/05 Advanced Formatting/0502 Coordinating a look using themes.mov | 4.82 MB |
| Essential Training/03 Excel Formula Basics/0309 Using IF.mov | 4.83 MB |
| Essential Training/07 Large Excel Projects/0702 Freezing panes.mov | 4.86 MB |
| Essential Training/03 Excel Formula Basics/0303 Adding numbers manually.mov | 4.86 MB |
| Essential Training/01 Getting Started/0103 Finding the commands you need.mov | 5 MB |
| Essential Training/03 Excel Formula Basics/0306 Working with numbers in columns.mov | 5.11 MB |
| Essential Training/06 Printing Preparation/0603 Printing and PDFs.mov | 5.13 MB |
| Essential Training/09 Exploring Excel's Database Features/0902 Joining data from multiple cells.mov | 5.18 MB |
| Essential Training/02 Worksheet Basics/0201 Creating a worksheet.mov | 5.38 MB |
| Essential Training/04 Essential Formatting/0402 Applying fonts, background colors, and borders.mov | 5.38 MB |
| Managing Multiple Worksheets and Workbooks/01 Mastering the Utility Tasks Associated with Multiple Worksheets/0104 Changing tab colors and renaming sheets.mov | 5.39 MB |
| Essential Training/04 Essential Formatting/0404 Using conditional formatting.mov | 5.5 MB |
| Essential Training/03 Excel Formula Basics/0310 Using SUMIF and AVERAGEIF.mov | 5.55 MB |
| Essential Training/04 Essential Formatting/0403 Adjusting columns, rows, and text.mov | 5.59 MB |
| Managing Multiple Worksheets and Workbooks/02 Working with Multiple Worksheets/0202 Copying, moving, and inserting data on different sheets.mov | 5.61 MB |
| Essential Training/02 Worksheet Basics/0203 Entering data automatically with Auto Fill.mov | 5.76 MB |
| Essential Training/10 Analyzing Data/1003 Working with Goal Seek.mov | 5.8 MB |
| Essential Training/12 Creating and Using Charts/1206 Placing Excel charts into other Office applications.mov | 5.83 MB |
| Essential Training/10 Analyzing Data/1005 Using scenarios in formulas.mov | 5.94 MB |
| Essential Training/02 Worksheet Basics/0204 Targeting large data groups.mov | 6.07 MB |
| Essential Training/03 Excel Formula Basics/0307 Preventing errors using absolute references.mov | 6.07 MB |
| Essential Training/06 Printing Preparation/0601 Making the pieces fit.mov | 6.11 MB |
| Essential Training/10 Analyzing Data/1004 Using data tables in formulas.mov | 6.51 MB |
| Essential Training/09 Exploring Excel's Database Features/0904 Using tables to sort and filter data.mov | 6.67 MB |
| Essential Training/03 Excel Formula Basics/0304 Adding numbers using Sum and AutoSum.mov | 6.72 MB |
| Essential Training/09 Exploring Excel's Database Features/0906 Creating lookup tables.mov | 6.78 MB |
| Essential Training/12 Creating and Using Charts/1204 Modifying a column chart.mov | 6.84 MB |
| Managing Multiple Worksheets and Workbooks/03 Linking Worksheets with Formulas/0301 Creating linkage formulas.mov | 6.84 MB |
| Managing Multiple Worksheets and Workbooks/04 Working with Multiple Workbooks/0401 Navigating between open workbooks.mov | 7 MB |
| Essential Training/07 Large Excel Projects/0707 Calculating formulas across worksheets.mov | 7.06 MB |
| Essential Training/10 Analyzing Data/1001 Using auditing to diagram.mov | 7.07 MB |
| Essential Training/11 Advanced Analysis with PivotTables/1104 Creating and modifying a PivotChart.mov | 7.14 MB |
| Essential Training/01 Getting Started/0105 Maintaining file compatibility.mov | 7.16 MB |
| Essential Training/01 Getting Started/0102 Touring the interface.mov | 7.18 MB |
| Essential Training/13 Creating and Using Macros/1303 Editing a macro.mov | 7.21 MB |
| Essential Training/00 Introduction/0001 Welcome.mov | 7.26 MB |
| Essential Training/05 Advanced Formatting/0504 Creating and sharing styles.mov | 7.31 MB |
| Essential Training/08 Collaborating with Others/0802 Setting workbook permissions.mov | 7.35 MB |
| Managing Multiple Worksheets and Workbooks/02 Working with Multiple Worksheets/0203 Applying global changes to worksheets.mov | 7.37 MB |
| Essential Training/07 Large Excel Projects/0705 Hiding or grouping rows and columns.mov | 7.51 MB |
| Managing Multiple Worksheets and Workbooks/01 Mastering the Utility Tasks Associated with Multiple Worksheets/0103 Copying and moving sheets within a workbook.mov | 7.55 MB |
| Essential Training/11 Advanced Analysis with PivotTables/1103 Modifying a PivotTable.mov | 7.64 MB |
| Managing Multiple Worksheets and Workbooks/05 Linking Formulas Across Multiple Workbooks/0501 Creating formulas that link worksheets in different workbooks.mov | 7.71 MB |
| Essential Training/04 Essential Formatting/0405 Using custom conditional formatting.mov | 7.72 MB |
| Essential Training/07 Large Excel Projects/0706 Managing worksheets.mov | 7.79 MB |
| Essential Training/04 Essential Formatting/0401 Formatting numbers and dates.mov | 7.81 MB |
| Essential Training/12 Creating and Using Charts/1205 Creating and modifying a pie chart.mov | 8.13 MB |
| Essential Training/Exercise Files/Exercise Files.rar | 8.22 MB |
| Essential Training/09 Exploring Excel's Database Features/0903 Basic and multi-field sorting.mov | 8.32 MB |
| Managing Multiple Worksheets and Workbooks/01 Mastering the Utility Tasks Associated with Multiple Worksheets/0102 Inserting and deleting new sheets.mov | 8.33 MB |
| Essential Training/08 Collaborating with Others/0803 Inserting and editing comments.mov | 8.46 MB |
| Essential Training/05 Advanced Formatting/0501 Inserting SmartArt.mov | 8.56 MB |
| Essential Training/07 Large Excel Projects/0704 Creating multiple custom worksheet views.mov | 8.78 MB |
| Essential Training/10 Analyzing Data/1006 Exploring the Analysis Toolpak.mov | 8.96 MB |
| Essential Training/14 Customizing Excel/1403 Setting Excel options.mov | 9.69 MB |
| Essential Training/04 Essential Formatting/0406 Adding pictures and shapes.mov | 9.81 MB |
| Managing Multiple Worksheets and Workbooks/04 Working with Multiple Workbooks/0402 Displaying multiple worksheets from different workbooks.mov | 9.97 MB |
| Essential Training/08 Collaborating with Others/0801 Importing and exporting data in Excel.mov | 10.1 MB |
| Managing Multiple Worksheets and Workbooks/03 Linking Worksheets with Formulas/0302 Creating 3D formulas for worksheets with identical layouts.mov | 10.32 MB |
| Managing Multiple Worksheets and Workbooks/05 Linking Formulas Across Multiple Workbooks/0502 Locating and managing links between multiple workbooks.mov | 11.02 MB |
| Managing Multiple Worksheets and Workbooks/01 Mastering the Utility Tasks Associated with Multiple Worksheets/0105 Using the Hide function on worksheet tabs.mov | 11.09 MB |
| Managing Multiple Worksheets and Workbooks/04 Working with Multiple Workbooks/0403 Copying and moving data and entire worksheets across different workbooks.mov | 11.98 MB |
| Essential Training/08 Collaborating with Others/0806 Saving files in shared locations.mov | 12.08 MB |
| Managing Multiple Worksheets and Workbooks/00 Introduction/0001 Welcome.mov | 12.33 MB |
| Essential Training/14 Customizing Excel/1402 Customizing the Ribbon bar.mov | 13.18 MB |
| Essential Training/13 Creating and Using Macros/1302 Recording and using a simple macro.mov | 14.08 MB |
| Managing Multiple Worksheets and Workbooks/02 Working with Multiple Worksheets/0201 Displaying multiple worksheets from the same workbook.mov | 17.55 MB |
Trackers
No trackers found.