Lynda Excel 3Courses | 9B43E891FCFD219C37BEFF59ADB6598936221BA0

Lynda Excel 3Courses

Name	Lynda.Excel.3Courses	DOWNLOAD Copy Link
Total Size	1.2 GB
Total Files	104
Hash	9B43E891FCFD219C37BEFF59ADB6598936221BA0

/Excel 2010 Macros in Depth/
lce2010m.cue	0.1 KB
lce2010m.bin	456.2 MB
/Essential Training/15 Conclusion/
1501 Goodbye.mov	250.2 KB
/Essential Training/00 Introduction/
0002 Using the exercise files.mov	774.7 KB
0001 Welcome.mov	7.6 MB
/00 Introduction/
0002 Using the exercise files.mov	1.4 MB
0001 Welcome.mov	12.9 MB
/.../12 Creating and Using Charts/
1201 Choosing chart types.mov	1.8 MB
1203 Creating a column chart.mov	3.8 MB
1202 Inserting Sparklines.mov	4.7 MB
1206 Placing Excel charts into other Office applications.mov	6.1 MB
1204 Modifying a column chart.mov	7.2 MB
1205 Creating and modifying a pie chart.mov	8.5 MB
/.../08 Collaborating with Others/
0804 Sharing a workbook.mov	1.8 MB
0805 Tracking changes.mov	3.8 MB
0802 Setting workbook permissions.mov	7.7 MB
0803 Inserting and editing comments.mov	8.9 MB
0801 Importing and exporting data in Excel.mov	10.6 MB
0806 Saving files in shared locations.mov	12.7 MB
/.../03 Excel Formula Basics/
0305 Adding a whole worksheet.mov	2.0 MB
0302 Entering data in a worksheet.mov	3.5 MB
0308 Working with times and dates.mov	3.5 MB
0311 Naming and using cell ranges.mov	4.3 MB
0301 Understanding formulas and functions.mov	4.9 MB
0309 Using IF.mov	5.1 MB
0303 Adding numbers manually.mov	5.1 MB
0306 Working with numbers in columns.mov	5.4 MB
0310 Using SUMIF and AVERAGEIF.mov	5.8 MB
0307 Preventing errors using absolute references.mov	6.4 MB
0304 Adding numbers using Sum and AutoSum.mov	7.0 MB
/.../10 Analyzing Data/
1002 Using evaluation in Excel.mov	2.4 MB
1003 Working with Goal Seek.mov	6.1 MB
1005 Using scenarios in formulas.mov	6.2 MB
1004 Using data tables in formulas.mov	6.8 MB
1001 Using auditing to diagram.mov	7.4 MB
1006 Exploring the Analysis Toolpak.mov	9.4 MB
/.../11 Advanced Analysis with PivotTables/
1101 Discovering PivotTables.mov	2.4 MB
1102 Creating a basic PivotTable.mov	3.2 MB
1104 Creating and modifying a PivotChart.mov	7.5 MB
1103 Modifying a PivotTable.mov	8.0 MB
/06 Conclusion/
0601 Final thoughts.mov	2.8 MB
/.../13 Creating and Using Macros/
1301 Understanding macros.mov	2.9 MB
1303 Editing a macro.mov	7.6 MB
1302 Recording and using a simple macro.mov	14.8 MB
/.../09 Exploring Excel's Database Features/
0901 Splitting cell data into multiple cells.mov	3.2 MB
0905 Inserting automatic subtotals.mov	4.9 MB
0902 Joining data from multiple cells.mov	5.4 MB
0904 Using tables to sort and filter data.mov	7.0 MB
0906 Creating lookup tables.mov	7.1 MB
0903 Basic and multi-field sorting.mov	8.7 MB
/.../05 Advanced Formatting/
0506 Creating and using original templates.mov	3.2 MB
0505 Using templates.mov	4.8 MB
0503 Applying built-in styles.mov	4.9 MB
0502 Coordinating a look using themes.mov	5.1 MB
0504 Creating and sharing styles.mov	7.7 MB
0501 Inserting SmartArt.mov	9.0 MB
/.../01 Getting Started/
0101 Exploring three common uses for Excel.mov	3.4 MB
0104 Using Backstage view or the File tab.mov	4.1 MB
0103 Finding the commands you need.mov	5.2 MB
0105 Maintaining file compatibility.mov	7.5 MB
0102 Touring the interface.mov	7.5 MB
/Exercise Files/
Exercise Files.rar	3.7 MB
/.../02 Worksheet Basics/
0205 Changing a worksheet's structure.mov	3.9 MB
0202 Techniques for copying and pasting.mov	4.5 MB
0201 Creating a worksheet.mov	5.6 MB
0203 Entering data automatically with Auto Fill.mov	6.0 MB
0204 Targeting large data groups.mov	6.4 MB
/.../07 Large Excel Projects/
0701 Finding and replacing data.mov	4.2 MB
0703 Repeating row and column titles.mov	4.5 MB
0702 Freezing panes.mov	5.1 MB
0707 Calculating formulas across worksheets.mov	7.4 MB
0705 Hiding or grouping rows and columns.mov	7.9 MB
0706 Managing worksheets.mov	8.2 MB
0704 Creating multiple custom worksheet views.mov	9.2 MB
/.../14 Customizing Excel/
1401 Customizing the Quick Access toolbar.mov	4.5 MB
1403 Setting Excel options.mov	10.2 MB
1402 Customizing the Ribbon bar.mov	13.8 MB
/.../06 Printing Preparation/
0602 Inserting headers and footers.mov	4.6 MB
0603 Printing and PDFs.mov	5.4 MB
0601 Making the pieces fit.mov	6.4 MB
/.../04 Essential Formatting/
0402 Applying fonts, background colors, and borders.mov	5.6 MB
0404 Using conditional formatting.mov	5.8 MB
0403 Adjusting columns, rows, and text.mov	5.9 MB
0405 Using custom conditional formatting.mov	8.1 MB
0401 Formatting numbers and dates.mov	8.2 MB
0406 Adding pictures and shapes.mov	10.3 MB
/.../01 Mastering the Utility Tasks Associated with Multiple Worksheets/
0104 Changing tab colors and renaming sheets.mov	5.7 MB
0103 Copying and moving sheets within a workbook.mov	7.9 MB
0102 Inserting and deleting new sheets.mov	8.7 MB
0105 Using the Hide function on worksheet tabs.mov	11.6 MB
0101 Learning basic navigation tips.mov	19.2 MB
/.../02 Working with Multiple Worksheets/
0202 Copying, moving, and inserting data on different sheets.mov	5.9 MB
0203 Applying global changes to worksheets.mov	7.7 MB
0201 Displaying multiple worksheets from the same workbook.mov	18.4 MB
/.../03 Linking Worksheets with Formulas/
0301 Creating linkage formulas.mov	7.2 MB
0302 Creating 3D formulas for worksheets with identical layouts.mov	10.8 MB
0303 Summarizing multiple worksheets with PivotTables or Consolidate.mov	20.5 MB
/.../04 Working with Multiple Workbooks/
0401 Navigating between open workbooks.mov	7.3 MB
0402 Displaying multiple worksheets from different workbooks.mov	10.5 MB
0403 Copying and moving data and entire worksheets across different workbooks.mov	12.6 MB
/.../05 Linking Formulas Across Multiple Workbooks/
0501 Creating formulas that link worksheets in different workbooks.mov	8.1 MB
0502 Locating and managing links between multiple workbooks.mov	11.6 MB
0503 Summarizing data from multiple workbooks with PivotTables or Consolidate.mov	20.1 MB
/Essential Training/Exercise Files/
Exercise Files.rar	8.6 MB
Total files 104