Download Excel 2010 Tutorials and Training videos from Lynda com Torrent

Torrent Contents Size: 1.33 GB

Excel 2010 Tutorials and Training videos from Lynda com

1.4.Lynda.com.Excel.2010.Power.Shortcuts

00 Introduction

	0001 Welcome.mov	MOV	18.46 MB
	0002 Using the exercise files.mov	MOV	339.74 KB

01 Top Ten Shortcuts

0101 Entering data or formulas in non-adjacent cells simultaneou.mov	MOV	2.69 MB
0102 Converting formulas to values with a simple drag.mov	MOV	3.46 MB
0103 Copying data or formulas down a column instantly.mov	MOV	3.77 MB
0104 Adjusting all or selected column widths or row heights in a.mov	MOV	3.27 MB
0105 Instantly displaying all worksheet formulas.mov	MOV	4.98 MB
0106 Two quick shortcuts for creating charts.mov	MOV	1.46 MB
0107 Print Preview.mov	MOV	1.67 MB
0108 Instant date or time entry.mov	MOV	1.36 MB
0109 Undo Redo Repeat.mov	MOV	4.85 MB
0110 Zooming in and out quickly.mov	MOV	6.27 MB

02 Ribbon and Quick Access Toolbar Tips

0201 Expanding and collapsing the Ribbon and Full Screen view.mov	MOV	2.8 MB
0202 Keyboard command access.mov	MOV	2.72 MB
0203 Quick Access toolbar display tips.mov	MOV	7.2 MB

03 Display Shortcuts

0301 Split screens and frozen titles in a flash.mov	MOV	12.71 MB
0302 Repeating title creation and suppression.mov	MOV	9.78 MB
0303 Customizing your display of Status Bar totals.mov	MOV	2.71 MB

04 Navigation Shortcuts

0401 Navigation shortcuts.mov	MOV	3.68 MB
0402 Tips for navigating between workbooks.mov	MOV	6.53 MB
0403 Navigating within worksheets.mov	MOV	7.82 MB

05 Selection Shortcuts

0501 Selecting an entire row column or worksheet.mov	MOV	5.33 MB
0502 Selecting noncontiguous ranges and visible cells only.mov	MOV	6.78 MB
0503 Selecting the current region and moving around region corne.mov	MOV	6.57 MB

06 Data Entry and Editing Shortcuts

0601 Accelerating data entry.mov	MOV	7.48 MB
0602 Auto-Fill techniques for entering dates.mov	MOV	6.13 MB
0603 Auto-Fill techniques for entering times.mov	MOV	2.97 MB
0604 Custom lists for rapid entry.mov	MOV	11.6 MB
0605 Cell editing tips.mov	MOV	3.31 MB

07 Drag-and-Drop Techniques

0701 Copy Move acceleration tips.mov	MOV	4.2 MB
0702 Worksheet Copy Move shortcuts.mov	MOV	3.29 MB
0703 Dragging and inserting variations.mov	MOV	4.72 MB
0704 Instantly displaying Paste Special options.mov	MOV	4.25 MB

08 Formula Shortcuts

0801 Rapid formula creation.mov	MOV	4.57 MB
0802 Selecting all cells that depend on the active cell.mov	MOV	6.64 MB
0803 Selecting all cells that can affect the active cell.mov	MOV	3.41 MB
0804 AutoSum shortcuts.mov	MOV	3.2 MB
0805 Rounding shortcuts.mov	MOV	5.53 MB
0806 Generating random numbers.mov	MOV	3.88 MB
0807 Counting unique entries.mov	MOV	4.35 MB
0808 Performing calculations without formulas.mov	MOV	3.75 MB

09 Operational Shortcuts

0901 Controlling rows and columns.mov	MOV	11.04 MB
0902 Realigning imported text.mov	MOV	2.72 MB
0903 Handling blank cells.mov	MOV	7.46 MB
0904 Collapsing and expanding detail.mov	MOV	5.75 MB

10 Formatting Shortcuts

1001 Formatting numbers.mov	MOV	10.27 MB
1002 Aligning data.mov	MOV	5.08 MB
1003 Adding background color for readability.mov	MOV	8.27 MB
1004 Formatting data conditionally.mov	MOV	2.83 MB
1005 Creating custom formats.mov	MOV	8.97 MB
1006 Formatting periods over 24 hours.mov	MOV	3.71 MB
1007 Applying strikethroughs and borders.mov	MOV	4.29 MB

11 Database Techniques

1101 Sorting shortcuts.mov	MOV	3.59 MB
1102 Cleaning up spaces.mov	MOV	8.97 MB
1103 Identifying duplicates.mov	MOV	6.31 MB
1104 Splitting columns.mov	MOV	5.02 MB
1105 Ensuring unique entries.mov	MOV	2.99 MB
1106 Forcing dates to be weekdays only.mov	MOV	4.33 MB
1107 Displaying unique items from large lists.mov	MOV	1.95 MB

12 Charting and Visual Object Tips

1201 Placing and adjusting charts.mov	MOV	3.17 MB
1202 Creating chart titles from cell content.mov	MOV	2.67 MB
1203 Creating and manipulating shapes.mov	MOV	6.15 MB
1204 Linking and unlinking pictures.mov	MOV	12.92 MB

13 Conclusion

1301 Goodbye.mov

MOV

131.85 KB

Exercise Files

Chapter01.xlsx	XLSX	158.09 KB
Chapter02.xlsx	XLSX	105.98 KB
Chapter03.xlsx	XLSX	114.79 KB
Chapter04.xlsx	XLSX	597.1 KB
Chapter04A.xlsx	XLSX	26.73 KB
Chapter05.xlsx	XLSX	105.29 KB
Chapter06.xlsx	XLSX	118.13 KB
Chapter07.xlsx	XLSX	116.84 KB
Chapter08.xlsx	XLSX	106.54 KB
Chapter09.xlsx	XLSX	115.82 KB
Chapter10.xlsx	XLSX	227.43 KB
Chapter11.xlsx	XLSX	282.98 KB
Chapter12.xlsx	XLSX	112.78 KB

jgtiso.nfo

NFO

7.29 KB

Lynda.com - Migrating from Excel 2003 to Excel 2010

00 Introduction

	0001 Welcome.mov	MOV	8.64 MB
	0002 Using the exercise files.mov	MOV	764.91 KB

01 Getting Started

0101 Understanding the reasons to switch.mov	MOV	3.59 MB
0102 Exploring the new Ribbon and Backstage view.mov	MOV	5.36 MB
0103 Controlling Excel 2010 with keyboard shortcuts.mov	MOV	6.81 MB
0104 Understanding the new file formats.mov	MOV	5.82 MB

02 Using Excel 2003 and Excel 2010 in a Mixed Environment

0201 Saving Excel 2010 spreadsheets to Excel 2003.mov	MOV	3.95 MB
0202 Converting older spreadsheets to Excel 2010.mov	MOV	3.16 MB
0203 Changing the default file format in Excel 2010.mov	MOV	4 MB
0204 Managing Excel 2003 files in Compatibility Mode.mov	MOV	3.3 MB
0205 Working with Excel 2010 files in older versions of Excel us.mov	MOV	3.22 MB
0206 Best practices for managing files in a mixed environment.mov	MOV	1.37 MB

03 Performing Common Excel 2003 Tasks in Excel 2010

0301 Working with formulas and functions.mov	MOV	3.92 MB
0302 Using Excel tables to manage lists of data.mov	MOV	6.76 MB
0303 Formatting a workbook.mov	MOV	4.8 MB
0304 Using conditional formatting.mov	MOV	5.15 MB
0305 Customizing the Ribbon and the Quick Access toolbar.mov	MOV	8.94 MB
0306 Creating macro-enabled workbooks and templates.mov	MOV	7.95 MB

04 Conclusion

0401 Goodbye.mov

MOV

324.7 KB

Exercise Files

Chap01

01_02

	TT Billing Statement1.xls	XLS	66 KB
	TT Billing Statement1.xlsx	XLSX	36.28 KB

01_03

	TT Billing Statement2.xls	XLS	66.5 KB
	TT Billing Statement2.xlsx	XLSX	36.3 KB

01_04

TT Billing Statement3.xls

XLS

66.5 KB

Chap02

02_01

Expense Report.xlsx

XLSX

56.48 KB

02_02

ExpenseBudget.xls

XLS

55.5 KB

02_03

ExpenseBudget.xlsx

XLSX

20.67 KB

02_04

ExpenseBudget.xls

XLS

41 KB

02_05

ExpenseBudget.xlsx

XLSX

20.66 KB

Chap03

03_01

TTExpenses.xls

XLS

55 KB

03_02

RevTable.xls

XLS

26 KB

03_03

	Sales Report1.xls	XLS	63.5 KB
	Sales Report1.xlsx	XLSX	30.36 KB

03_04

	TTExpenses.xls	XLS	48 KB
	TTExpenses.xlsx	XLSX	24.92 KB

03_05

	TTExpenses.xls	XLS	48 KB
	TTExpenses.xlsx	XLSX	25.03 KB

03_06

TTExpenses.xls	XLS	48 KB
TTExpenses.xlsm	XLSM	29.98 KB
TTExpenses.xlsx	XLSX	25 KB

Lynda.com Excel 2010 Working with Dates and Times

00 Introduction

	0001 Welcome.mov	MOV	9.22 MB
	0002 Using the exercise files.mov	MOV	362.17 KB

01 Excel's Date Time Entries

	0101 Understanding how Excel records and stores dates.mov	MOV	4.98 MB
	0102 Understanding how Excel records and stores times.mov	MOV	1.68 MB

02 Creating Date Time Entries

0201 Looking at standard date time entry options and acceptable alternatives.mov	MOV	3.16 MB
0202 Using instant date time entry.mov	MOV	1.56 MB
0203 Using TODAY and NOW functions for dynamic date time entry.mov	MOV	3.16 MB
0204 Using Auto Fill to enter date and time series.mov	MOV	6.45 MB

03 Date Time Formatting

0301 Exploring keystroke shortcuts.mov	MOV	2.32 MB
0302 Formatting time for hours over 24.mov	MOV	2.44 MB
0303 Creating custom date formatting.mov	MOV	2.88 MB

04 Excel's Date Time Functions

0401 EOMONTH and EDATE Setting ends of months and future past dates.mov	MOV	4.83 MB
0402 DATEDIF Calculating date differences by year, month, day, and more.mov	MOV	4.79 MB
0403 WEEKDAY Determining the day of the week.mov	MOV	1.96 MB
0404 NETWORKDAYS Calculating working days.mov	MOV	2.54 MB
0405 WORKDAY Calculating an ending date.mov	MOV	1.99 MB
0406 DATEVALUE and TIMEVALUE Converting text entries into dates and times.mov	MOV	3.38 MB

05 Calculating with Dates and Times

0501 Calculating date differences across days, months, and years.mov	MOV	2.05 MB
0502 Calculating time differences within and across days.mov	MOV	5.85 MB
0503 Calculating fiscal years and quarters.mov	MOV	6.26 MB
0504 Rounding time calculations to convenient intervals.mov	MOV	5.44 MB
0505 Using times with currency calculations.mov	MOV	2.9 MB
0506 Calculating holidays (Labor Day, Thanksgiving, Memorial Day, etc.).mov	MOV	1.96 MB

06 Using Dates and Times with Excel Commands

0601 Using special date filters with date data.mov	MOV	4.5 MB
0602 Using date controls in data validation rules.mov	MOV	6.29 MB
0603 Using date functions in data validation rules.mov	MOV	3.47 MB
0604 Converting unusually formatted dates into usable data (text to columns).mov	MOV	4.3 MB

07 Conclusion

0701 Goodbye.mov

MOV

269.41 KB

Exercise Files

Chapter01

	01_BusinessData.xlsx	XLSX	132.35 KB
	02_BusinessData.xlsx	XLSX	132.35 KB

Chapter02

01_BusinessData.xlsx	XLSX	132.18 KB
02_BusinessData.xlsx	XLSX	132.17 KB
03_BusinessData.xlsx	XLSX	132.15 KB
04_BusinessData.xlsx	XLSX	134.24 KB

Chapter03

01_BusinessData.xlsx	XLSX	132.18 KB
02_BusinessData.xlsx	XLSX	137.16 KB
03_BusinessData.xlsx	XLSX	137.13 KB

Chapter04

01_BusinessData.xlsx	XLSX	136.92 KB
02_BusinessData.xlsx	XLSX	133.96 KB
03_BusinessData.xlsx	XLSX	135.91 KB
04_BusinessData.xlsx	XLSX	133.21 KB
05_BusinessData.xlsx	XLSX	133.21 KB
06_BusinessData.xlsx	XLSX	157.28 KB

Chapter05

01_BusinessData.xlsx	XLSX	151.2 KB
02_BusinessData.xlsx	XLSX	144.73 KB
03_BusinessData.xlsx	XLSX	151.29 KB
04_BusinessData.xlsx	XLSX	156.84 KB
05_BusinessData.xlsx	XLSX	157.44 KB
06_BusinessData.xlsx	XLSX	156.95 KB

Chapter06

01_BusinessData.xlsx	XLSX	144.41 KB
02_BusinessData.xlsx	XLSX	147.69 KB
03_BusinessData.xlsx	XLSX	146.24 KB
04_BusinessData.xlsx	XLSX	145.58 KB

quasar.nfo

NFO

3.24 KB

Lynda.com.Excel.2010.Essential.Training-QUASAR

00 Introduction

	0001 Welcome.mov	MOV	7.26 MB
	0002 Using the exercise files.mov	MOV	756.53 KB

01 Getting Started

0101 Exploring three common uses for Excel.mov	MOV	3.27 MB
0102 Touring the interface.mov	MOV	7.18 MB
0103 Finding the commands you need.mov	MOV	5 MB
0104 Using Backstage view or the File tab.mov	MOV	3.92 MB
0105 Maintaining file compatibility.mov	MOV	7.16 MB

02 Worksheet Basics

0201 Creating a worksheet.mov	MOV	5.38 MB
0202 Techniques for copying and pasting.mov	MOV	4.3 MB
0203 Entering data automatically with Auto Fill.mov	MOV	5.76 MB
0204 Targeting large data groups.mov	MOV	6.07 MB
0205 Changing a worksheet's structure.mov	MOV	3.68 MB

03 Excel Formula Basics

0301 Understanding formulas and functions.mov	MOV	4.63 MB
0302 Entering data in a worksheet.mov	MOV	3.33 MB
0303 Adding numbers manually.mov	MOV	4.86 MB
0304 Adding numbers using Sum and AutoSum.mov	MOV	6.72 MB
0305 Adding a whole worksheet.mov	MOV	1.86 MB
0306 Working with numbers in columns.mov	MOV	5.11 MB
0307 Preventing errors using absolute references.mov	MOV	6.07 MB
0308 Working with times and dates.mov	MOV	3.38 MB
0309 Using IF.mov	MOV	4.83 MB
0310 Using SUMIF and AVERAGEIF.mov	MOV	5.55 MB
0311 Naming and using cell ranges.mov	MOV	4.11 MB

04 Essential Formatting

0401 Formatting numbers and dates.mov	MOV	7.81 MB
0402 Applying fonts, background colors, and borders.mov	MOV	5.38 MB
0403 Adjusting columns, rows, and text.mov	MOV	5.59 MB
0404 Using conditional formatting.mov	MOV	5.5 MB
0405 Using custom conditional formatting.mov	MOV	7.72 MB
0406 Adding pictures and shapes.mov	MOV	9.81 MB

05 Advanced Formatting

0501 Inserting SmartArt.mov	MOV	8.56 MB
0502 Coordinating a look using themes.mov	MOV	4.82 MB
0503 Applying built-in styles.mov	MOV	4.68 MB
0504 Creating and sharing styles.mov	MOV	7.31 MB
0505 Using templates.mov	MOV	4.56 MB
0506 Creating and using original templates.mov	MOV	3.06 MB

06 Printing Preparation

0601 Making the pieces fit.mov	MOV	6.11 MB
0602 Inserting headers and footers.mov	MOV	4.43 MB
0603 Printing and PDFs.mov	MOV	5.13 MB

07 Large Excel Projects

0701 Finding and replacing data.mov	MOV	3.97 MB
0702 Freezing panes.mov	MOV	4.86 MB
0703 Repeating row and column titles.mov	MOV	4.34 MB
0704 Creating multiple custom worksheet views.mov	MOV	8.78 MB
0705 Hiding or grouping rows and columns.mov	MOV	7.51 MB
0706 Managing worksheets.mov	MOV	7.79 MB
0707 Calculating formulas across worksheets.mov	MOV	7.06 MB

08 Collaborating with Others

0801 Importing and exporting data in Excel.mov	MOV	10.1 MB
0802 Setting workbook permissions.mov	MOV	7.35 MB
0803 Inserting and editing comments.mov	MOV	8.46 MB
0804 Sharing a workbook.mov	MOV	1.76 MB
0805 Tracking changes.mov	MOV	3.65 MB
0806 Saving files in shared locations.mov	MOV	12.08 MB

09 Exploring Excel's Database Features

0901 Splitting cell data into multiple cells.mov	MOV	3 MB
0902 Joining data from multiple cells.mov	MOV	5.18 MB
0903 Basic and multi-field sorting.mov	MOV	8.32 MB
0904 Using tables to sort and filter data.mov	MOV	6.67 MB
0905 Inserting automatic subtotals.mov	MOV	4.69 MB
0906 Creating lookup tables.mov	MOV	6.78 MB

10 Analyzing Data

1001 Using auditing to diagram.mov	MOV	7.07 MB
1002 Using evaluation in Excel.mov	MOV	2.24 MB
1003 Working with Goal Seek.mov	MOV	5.8 MB
1004 Using data tables in formulas.mov	MOV	6.51 MB
1005 Using scenarios in formulas.mov	MOV	5.94 MB
1006 Exploring the Analysis Toolpak.mov	MOV	8.96 MB

11 Advanced Analysis with PivotTables

1101 Discovering PivotTables.mov	MOV	2.28 MB
1102 Creating a basic PivotTable.mov	MOV	3.03 MB
1103 Modifying a PivotTable.mov	MOV	7.64 MB
1104 Creating and modifying a PivotChart.mov	MOV	7.14 MB

12 Creating and Using Charts

1201 Choosing chart types.mov	MOV	1.73 MB
1202 Inserting Sparklines.mov	MOV	4.52 MB
1203 Creating a column chart.mov	MOV	3.66 MB
1204 Modifying a column chart.mov	MOV	6.84 MB
1205 Creating and modifying a pie chart.mov	MOV	8.13 MB
1206 Placing Excel charts into other Office applications.mov	MOV	5.83 MB

13 Creating and Using Macros

1301 Understanding macros.mov	MOV	2.8 MB
1302 Recording and using a simple macro.mov	MOV	14.08 MB
1303 Editing a macro.mov	MOV	7.21 MB

14 Customizing Excel

1401 Customizing the Quick Access toolbar.mov	MOV	4.31 MB
1402 Customizing the Ribbon bar.mov	MOV	13.18 MB
1403 Setting Excel options.mov	MOV	9.69 MB

15 Conclusion

1501 Goodbye.mov

MOV

244.38 KB

Exercise Files

chapt 1

backstage view.xlsx	XLSX	151.49 KB
current format.xlsx	XLSX	146.3 KB
older format workbook.xls	XLS	34.5 KB
ribbon bar.xlsx	XLSX	151.46 KB
touring the interface.xlsx	XLSX	136.93 KB
what is excel for.xlsx	XLSX	143.51 KB

chapt 10

analysis toolpack.xlsx	XLSX	138.12 KB
auditing.xlsx	XLSX	138 KB
data tables.xlsx	XLSX	138.97 KB
evaluate.xlsx	XLSX	22.08 KB
goal seek.xlsx	XLSX	135.09 KB
scenarios.xlsx	XLSX	133.17 KB

chapt 11

create pivot table.xlsx	XLSX	136.04 KB
modifying a pivottable.xlsx	XLSX	140.87 KB
pivot chart.xlsx	XLSX	147.5 KB
pivot table.xlsx	XLSX	155.76 KB

chapt 12

column chart.xlsx	XLSX	134.82 KB
insert pie chart.docx	DOCX	43.22 KB
insert pie chart.pptx	PPTX	75.16 KB
modifying a chart.xlsx	XLSX	136.59 KB
pie chart.xlsx	XLSX	134.82 KB
placing chart.xlsx	XLSX	137 KB
sparklines.xlsx	XLSX	136.5 KB

chapt 13

editing macro.xlsm	XLSM	156.54 KB
northeast data.xlsx	XLSX	134.73 KB
overseas data.xlsx	XLSX	135.07 KB
recording macro.xlsx	XLSX	134.74 KB
southeast data.xlsx	XLSX	134.72 KB
west data.xlsx	XLSX	135.21 KB

chapt 14

Bob's Customizations.exportedUI	EXPORTEDUI	1.06 KB
customizing QAT.xlsx	XLSX	138.28 KB
customizing ribbon.xlsx	XLSX	138.28 KB
setting options.xlsx	XLSX	138.28 KB

chapt 2

autofill.xlsx	XLSX	9.19 KB
clipboard.xlsx	XLSX	8.77 KB
rows and columns.xlsx	XLSX	136.93 KB
selections.xlsx	XLSX	11.55 KB

chapt 3

absolute refs.xlsx	XLSX	11.15 KB
average.xlsx	XLSX	12.6 KB
creating range names.xlsx	XLSX	20.64 KB
dates.xlsx	XLSX	11.43 KB
expense report.xlsx	XLSX	9.39 KB
formulas and functions.xlsx	XLSX	9.33 KB
if.xlsx	XLSX	135.75 KB
manual.xlsx	XLSX	11.25 KB
sum.xlsx	XLSX	12.62 KB
sumif.xlsx	XLSX	137.79 KB
whole worksheet.xlsx	XLSX	12.6 KB

chapt 4

adjusting.xlsx	XLSX	12.13 KB
bottle.jpg	JPG	48.46 KB
conditional formatting.xlsx	XLSX	136.5 KB
custom conditional formatting.xlsx	XLSX	136.56 KB
fonts.xlsx	XLSX	11.76 KB
formatting numbers.xlsx	XLSX	11.62 KB
pictures - finished.xlsx	XLSX	73.98 KB
pictures.xlsx	XLSX	14.51 KB

chapt 5

custom styles.xlsx	XLSX	137.97 KB
garlic.jpg	JPG	50.95 KB
gift pack.jpg	JPG	31.38 KB
herbs.jpg	JPG	19.33 KB
logo.jpg	JPG	160.84 KB
merge styles.xlsx	XLSX	137 KB
smart art.xlsx	XLSX	135.87 KB
styles.xlsx	XLSX	137.69 KB
themes.xlsx	XLSX	25.47 KB
turn into template.xlsx	XLSX	135.62 KB

chapt 6

create PDFs.xlsx	XLSX	89.16 KB
headers and footers.xlsx	XLSX	67.83 KB
logo.jpg	JPG	24.15 KB
page size.xlsx	XLSX	67.65 KB

chapt 7

3D formulas.xlsx	XLSX	151.87 KB
find and replace.xlsx	XLSX	137.24 KB
freezing panes.xlsx	XLSX	153.39 KB
grouping.xlsx	XLSX	137.57 KB
managing worksheets.xlsx	XLSX	136.53 KB
repeating rows.xlsx	XLSX	137.26 KB
views.xlsx	XLSX	140.17 KB

chapt 8

comments.xlsx	XLSX	201.43 KB
export this.xlsx	XLSX	135.95 KB
import data.csv	CSV	2.11 KB
import data.txt	TXT	2.11 KB
import into this.xlsx	XLSX	136.31 KB
kalamata.jpg	JPG	62.34 KB
multi-pack 1.jpg	JPG	31.38 KB
permissions.xlsx	XLSX	144 KB
protecting.xlsx	XLSX	138.75 KB
saving shared locations.xlsx	XLSX	11.88 KB
sharing.xlsx	XLSX	138.76 KB

chapt 9

lookups.xlsx	XLSX	135.1 KB
merging.xlsx	XLSX	139.02 KB
sorting.xlsx	XLSX	139.02 KB
splitting.xlsx	XLSX	138.79 KB
subtotals.xlsx	XLSX	139.44 KB
tables.xlsx	XLSX	139.67 KB

quasar.nfo

NFO

3.12 KB

Lynda.com.Excel.2010.New.Features-QUASAR

00 Introduction

	0001 Welcome.mov	MOV	7.59 MB
	0002 Using the exercise files.mov	MOV	574.92 KB

01 File Tab, AKA Backstage View

0101 Customizing the Ribbon bar.mov	MOV	10.77 MB
0102 Looking at Backstage view.mov	MOV	3.72 MB
0103 Maintaining compatibility.mov	MOV	7.2 MB
0104 Making templates easier.mov	MOV	6.46 MB
0105 Handling document versions.mov	MOV	5.31 MB
0106 Changing the file type and converting to Adobe PDF.mov	MOV	4.87 MB
0107 Preparing to share a document.mov	MOV	6.77 MB
0108 Making printing easier.mov	MOV	4.54 MB

02 Collaboration Tools

0201 Setting document permissions.mov	MOV	3.98 MB
0202 Sharing a document by email.mov	MOV	4.02 MB
0203 Sharing a document on the free Microsoft SkyDrive web site.mov	MOV	10.73 MB
0204 Sharing a document through a Microsoft SharePoint portal.mov	MOV	6.88 MB

03 Data Tools

	0301 Using enhanced smart tags and the Paste preview.mov	MOV	3.72 MB
	0302 Filtering a table by searching.mov	MOV	3.13 MB

04 Graphic Features

0401 Inserting Sparklines.mov	MOV	6.06 MB
0402 Applying the enhanced conditional formatting features.mov	MOV	2.63 MB
0403 Formatting math equations with the improved equation tools.mov	MOV	6.97 MB
0404 Editing pictures with the improved picture tools.mov	MOV	5.56 MB

05 Pivot Tables

	0501 Using the Slicer to make PivotTables more interactive.mov	MOV	2.6 MB
	0502 Analyzing data from multiple sources using the PowerPivot plug-in.mov	MOV	14.96 MB

06 Going Beyond the Desktop

0601 Editing a worksheet in the Excel Web App.mov

MOV

10.41 MB

07 Conclusion

0701 Goodbye.mov

MOV

199.48 KB

Exercise Files

chapt 1

01_02_backstage.xlsx	XLSX	151.48 KB
01_03_current format.xlsx	XLSX	161.17 KB
01_04_turn into template.xlsx	XLSX	150.72 KB
01_05_properties.xlsx	XLSX	396.16 KB
01_06_converting.xlsx	XLSX	396.17 KB
01_07_preparing.xlsx	XLSX	146.13 KB
01_08_printing.xlsx	XLSX	151.17 KB
03 older format workbook.xls	XLS	260.5 KB

chapt 2

02_01_permissions.xlsx	XLSX	150.84 KB
02_02_sharing.xlsx	XLSX	150.85 KB
02_03_sky drive.xlsx	XLSX	11.82 KB
02_04_sharepoint.xlsx	XLSX	11.83 KB

chapt 3

	03_01_smart tags.xlsx	XLSX	150.57 KB
	03_02_filter.xlsx	XLSX	135.46 KB

chapt 4

04_01_sparklines.xlsx	XLSX	151.27 KB
04_02_conditional formatting.xlsx	XLSX	151.35 KB
04_03_equations.xlsx	XLSX	153.85 KB
04_04_bottles.jpg	JPG	31.39 KB
04_04_olive_tree_valley.jpg	JPG	47.8 KB

chapt 5

05_01_slicer.xlsx

XLSX

140.26 KB

05_02_powerpivot sales reps.xlsx

XLSX

12.76 KB

05_02_powerpivot sales volume.xlsx

XLSX

12.79 KB

05_02_product codes.accdb

ACCDB

412 KB

Finished

05_02_powerpivot analysis.xlsx

XLSX

276.41 KB

chapt 6

06_01_web app.xlsx

XLSX

12.52 KB

quasar.nfo

NFO

3.05 KB

Lynda.com.Excel.VBA.in.Depth-QUASAR

00 Introduction

	0001 Welcome.mov	MOV	4.7 MB
	0002 Using the exercise files.mov	MOV	279.59 KB

01 Introducing Visual Basic for Applications

0101 Introducing object-oriented programming.mov	MOV	1.62 MB
0102 Examining the Excel object model.mov	MOV	3.59 MB
0103 Working in the Visual Basic editor.mov	MOV	4.98 MB
0104 Setting VBA project properties.mov	MOV	2.38 MB
0105 Creating, exporting, and deleting code modules.mov	MOV	6.57 MB
0106 Creating a subroutine or function.mov	MOV	5.74 MB
0107 Controlling procedure scope and visibility.mov	MOV	3.28 MB
0108 Adding comments to the code.mov	MOV	3.54 MB
0109 Running a VBA routine.mov	MOV	4.59 MB
0110 Adding code to a recorded macro.mov	MOV	3.18 MB

02 Defining Variables, Constants, and Calculations

0201 Introducing Excel VBA data types.mov	MOV	6.72 MB
0202 Declaring variables and requiring declaration before use.mov	MOV	4.19 MB
0203 Managing variable scope.mov	MOV	3.71 MB
0204 Defining static variables and constants.mov	MOV	5.07 MB
0205 Creating a calculation using mathematical operators.mov	MOV	3.55 MB
0206 Defining arrays.mov	MOV	7.06 MB
0207 Defining and using object variables.mov	MOV	2.78 MB
0208 Streamlining code references using With End With statements.mov	MOV	3.6 MB

03 Adding Logic to Your VBA Code

0301 Repeating a task using a For Next loop.mov	MOV	2.49 MB
0302 Stepping through all items of a collection using a For Each loop.mov	MOV	3.05 MB
0303 Repeating a task with a Do loop.mov	MOV	5.3 MB
0304 Performing a task when conditions are met using If Then.mov	MOV	7.18 MB
0305 Selecting which action to take using a Case statement.mov	MOV	1.76 MB

04 Debugging You VBA Code

0401 Managing errors using On Error statements.mov	MOV	4.68 MB
0402 Stepping through a subroutine or function.mov	MOV	5.64 MB
0403 Setting breakpoints in the code.mov	MOV	2.57 MB
0404 Verifying output using the Immediate window.mov	MOV	3.82 MB
0405 Watching a value in a routine.mov	MOV	2.94 MB

05 Managing Workbook Elements and Data in VBA

0501 Writing a value to a cell.mov	MOV	3.62 MB
0502 Cutting, copying, and pasting cell data.mov	MOV	5.14 MB
0503 Finding values in cells.mov	MOV	4.21 MB
0504 Referring to cells using the Offset function.mov	MOV	2.97 MB
0505 Concatenating text strings.mov	MOV	4.01 MB
0506 Returning part of a string.mov	MOV	2.83 MB
0507 Managing worksheets with VBA.mov	MOV	5.59 MB
0508 Managing workbooks with VBA.mov	MOV	3.89 MB

06 Adding Advanced Elements to Your Workbook

0601 Turning off screen updating within a macro.mov	MOV	2.54 MB
0602 Using worksheet functions in a macro.mov	MOV	2.38 MB
0603 Acquiring values using an input box or message box.mov	MOV	5.13 MB
0604 Calling a subroutine from another subroutine.mov	MOV	2.02 MB

07 Using Excel Events in Your VBA Code

0701 Running a procedure when you open, close, or save a workbook.mov	MOV	4.32 MB
0702 Running a procedure when a cell range changes.mov	MOV	4.58 MB
0703 Triggering a procedure using a specific key sequence.mov	MOV	3.71 MB

08 Putting it All Together

0801 Applying techniques in a Capstone project.mov

MOV

6.06 MB

09 Conclusion

0901 Goodbye.mov

MOV

250.85 KB

Exercise Files

Ch01

Comments.xlsm	XLSM	39.93 KB
Commission.xlsm	XLSM	37.55 KB
ModulesManaged.xlsm	XLSM	9.9 KB
ProjectProperties.xlsm	XLSM	15.95 KB
RecordFirst.xlsm	XLSM	17.88 KB
RunAMacro.xlsm	XLSM	39.1 KB
Scope.xlsm	XLSM	41.37 KB
Scope.xlsx	XLSX	37.45 KB
VBEditor.xlsm	XLSM	13.86 KB
VBEditor.xlsx	XLSX	9.81 KB

Ch02

ConstantStatic.xlsm	XLSM	39.81 KB
DimVariables.xlsm	XLSM	39.04 KB
MonthlySales.xlsm	XLSM	18.4 KB
Operators.xlsm	XLSM	40.74 KB
ShippingCharges.xlsm	XLSM	18.27 KB
Types.xlsm	XLSM	15.95 KB
VariableScope.xlsm	XLSM	37.72 KB
WithExample.xlsm	XLSM	8.98 KB

Ch03

Case.xlsm	XLSM	38.94 KB
ForEach.xlsm	XLSM	18.46 KB
ForNext.xlsm	XLSM	17.45 KB
IfThen.xlsm	XLSM	39.46 KB
Suggestions.xlsm	XLSM	40.44 KB

Ch04

Breaking.xlsm	XLSM	41.93 KB
CheckError.xlsm	XLSM	13.46 KB
Immediate.xlsm	XLSM	42.31 KB
Stepping.xlsm	XLSM	42.6 KB
Watch.xlsm	XLSM	16.77 KB

Ch05

Concatenate.xlsm	XLSM	15.42 KB
CutPaste.xlsm	XLSM	17.31 KB
CutStrings.xlsm	XLSM	12.46 KB
Find.xlsm	XLSM	13.39 KB
Offset.xlsm	XLSM	39.83 KB
Workbooks.xlsm	XLSM	12.44 KB
Worksheets.xlsm	XLSM	38.42 KB
Writing.xlsm	XLSM	39.84 KB

Ch06

Boxes.xlsm	XLSM	40.83 KB
Calling.xlsm	XLSM	40.46 KB
Flashing.xlsm	XLSM	41.41 KB
WorksheetFunctions.xlsm	XLSM	38.79 KB

Ch07

.TEMP_com.apple.iWork.Numbers_1443_296003542_1

image1.tiff

TIFF

1.04 MB

ChangeRange.xlsm

XLSM

39.41 KB

ManipulateWorkbook.xlsm

XLSM

41.33 KB

OnKey.xlsm

XLSM

39.55 KB

Ch08

Capstone.xlsm

XLSM

45.5 KB

quasar.nfo

NFO

3.17 KB

Lynda.com.Excel2010.Beta.Real.World.projects-iRONiSO

00.01.Introduction

	60273_00_01_MM01_welcome.mov	MOV	2.47 MB
	60273_00_02_SC11_exerfiles.mov	MOV	516.99 KB

00.02.Microsoft Excel

60273_01_01_SC11_sparklines.mo.mov	MOV	4.53 MB
60273_01_02_SC11_custom.mov	MOV	5.63 MB
60273_01_03_SC11_pivot.mov	MOV	5.71 MB
60273_01_04_SC11_visual.mov	MOV	5.79 MB
60273_01_05_SC11_pasting.mov	MOV	5.86 MB

00.03.Conclusion

60273_02_01_SC11_goodbye.mov

MOV

193 KB

00.04.Exercise Files

AllData.xlsx	XLSX	1.02 MB
Customizing.xlsm	XLSM	19.38 KB
GreenhouseTiming.xlsx	XLSX	63.23 KB
Hydrangea.xlsx	XLSX	8.42 KB
Hydrangeas.jpg	JPG	581.33 KB
NewProductReports.xlsx	XLSX	8.26 KB
SalesPerformance.xlsx	XLSX	20.1 KB

ironiso.nfo

NFO

6.51 KB

i.nfo

NFO

1.88 KB

Description

									Show full description
								

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
Formation Excel 2010 Niveau Intermediaire Posted by Hrund in Movies - Documentary Posted in Movies - Documentary 0 451.02 MB 8 years ago Hrund	Size 451.02 MB	Files 1	Age 8 years ago	Seeds 0	Leechs 0	Source
Lynda - Setting Up a Database in Excel 2010 with Dennis Taylor Posted by 2boweb in Movies - Other Movies Posted in Movies - Other Movies 1 111.81 MB 11 years ago 2boweb	Size 111.81 MB	Files 18	Age 11 years ago	Seeds 1	Leechs 0	Source
MS Excel 2010 VBA Programming Posted by aligrt in Movies - Other Movies Posted in Movies - Other Movies 1 186.33 MB 12 years ago aligrt	Size 186.33 MB	Files 1	Age 12 years ago	Seeds 1	Leechs 0	Source
(Video2Brain) Excel 2010 graficos y presentacion de datos (Esp) Posted by enrey01 in Movies - Other Movies Posted in Movies - Other Movies 1 217.65 MB 12 years ago enrey01	Size 217.65 MB	Files 1	Age 12 years ago	Seeds 1	Leechs 0	Source
Lynda - Excel 2010 Tutorial Collection (4 courses) Posted by azda in Movies - Other Movies Posted in Movies - Other Movies 0 2.42 GB 13 years ago azda	Size 2.42 GB	Files 435	Age 13 years ago	Seeds 0	Leechs 1	Source

Excel 2010 Tutorials and Training videos from Lynda com

Torrent Contents Size: 1.33 GB

Description

Related Torrents

Location

Trackers

Media Information

General

Video Streams

Audio Streams

Latest News

Latest Searches

Sites In Our Index

Popular Tags