Magnetz

Title: Lynda Com - ExcelGroup: NOGRPYear: 2010Source: Lynda.Com

Info Hash

53B85F223C316F8A2A97C7EA863A9B1D159FBC8F

Source

Unverified

Total Size

470.07 MB

Total Files

81

Seeders

2

Leechers

0

Health

2.00

Score

4

Type

Bookware

File List

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

Trackers

No trackers found.