Download Lynda com Excel 2010 Essential Training + 2 Extra Courses - Team MJY Torrent

Torrent Contents Size: 1.08 GB

Lynda com Excel 2010 Essential Training + 2 Extra Courses - Team MJY

Essential Training

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

www.moviejockey.com.txt

TXT

19 B

Excel 2010 Macros in Depth

lce2010m.bin	BIN	435.07 MB
lce2010m.cue	CUE	79 B
www.moviejockey.com.txt	TXT	19 B

Managing Multiple Worksheets and Workbooks

00 Introduction

	0001 Welcome.mov	MOV	12.33 MB
	0002 Using the exercise files.mov	MOV	1.36 MB

01 Mastering the Utility Tasks Associated with Multiple Worksheets

0101 Learning basic navigation tips.mov	MOV	18.34 MB
0102 Inserting and deleting new sheets.mov	MOV	8.33 MB
0103 Copying and moving sheets within a workbook.mov	MOV	7.55 MB
0104 Changing tab colors and renaming sheets.mov	MOV	5.39 MB
0105 Using the Hide function on worksheet tabs.mov	MOV	11.09 MB

02 Working with Multiple Worksheets

0201 Displaying multiple worksheets from the same workbook.mov	MOV	17.55 MB
0202 Copying, moving, and inserting data on different sheets.mov	MOV	5.61 MB
0203 Applying global changes to worksheets.mov	MOV	7.37 MB

03 Linking Worksheets with Formulas

0301 Creating linkage formulas.mov	MOV	6.84 MB
0302 Creating 3D formulas for worksheets with identical layouts.mov	MOV	10.32 MB
0303 Summarizing multiple worksheets with PivotTables or Consolidate.mov	MOV	19.51 MB

04 Working with Multiple Workbooks

0401 Navigating between open workbooks.mov	MOV	7 MB
0402 Displaying multiple worksheets from different workbooks.mov	MOV	9.97 MB
0403 Copying and moving data and entire worksheets across different workbooks.mov	MOV	11.98 MB

05 Linking Formulas Across Multiple Workbooks

0501 Creating formulas that link worksheets in different workbooks.mov	MOV	7.71 MB
0502 Locating and managing links between multiple workbooks.mov	MOV	11.02 MB
0503 Summarizing data from multiple workbooks with PivotTables or Consolidate.mov	MOV	19.17 MB

06 Conclusion

0601 Final thoughts.mov

MOV

2.71 MB

Exercise Files

Chapter 01

HiddenSheets.xlsx	XLSX	369.35 KB
Hyperlink State File.xlsx	XLSX	118.8 KB
RegionalFile.xlsx	XLSX	21.33 KB
RegionalFile2.xlsx	XLSX	21.22 KB
SalesData.xlsx	XLSX	21.29 KB
Sample.xlsx	XLSX	370.84 KB

Chapter 02

DepartmentData.xlsx	XLSX	367.65 KB
RegionalData.xlsx	XLSX	21.3 KB
SalesData.xlsx	XLSX	21.32 KB
Sample.xlsx	XLSX	367.61 KB

Chapter 03

3D Formulas.xlsx	XLSX	111.51 KB
LinkageFormulas.xlsx	XLSX	21.64 KB
PivotTableSummary.xlsx	XLSX	20.79 KB
Sample.xlsx	XLSX	21.3 KB

Chapter 04

Chartdata2011.xlsx	XLSX	938.44 KB
DivisionFiles.xlsx	XLSX	367.64 KB
Olive-Arizona.xlsx	XLSX	21.39 KB
Olive-California.xlsx	XLSX	22.36 KB
Olive-Nevada.xlsx	XLSX	20.43 KB
Olive-Oregon.xlsx	XLSX	20.96 KB
QuarterlyBudget.xlsx	XLSX	73.76 KB
StateSalesData.xlsx	XLSX	50.1 KB

Chapter 05

Arizona.xlsx	XLSX	28.22 KB
California.xlsx	XLSX	28.3 KB
CorpLink.xlsx	XLSX	15.37 KB
CorporateData.xlsx	XLSX	369.5 KB
Olive-Arizona.xlsx	XLSX	21.39 KB
Olive-California.xlsx	XLSX	22.36 KB
Olive-Nevada.xlsx	XLSX	20.43 KB
Olive-Oregon.xlsx	XLSX	20.96 KB
Olive-WesternConsolidation.xlsx	XLSX	8.25 KB
Oregon.xlsx	XLSX	28.27 KB
Washington.xlsx	XLSX	28.29 KB
~$CorporateData.xlsx	XLSX	165 B

www.moviejockey.com.txt

TXT

19 B

www.moviejockey.com.txt

TXT

19 B

Description

Show full description

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
Lynda.com - Indesign - CC Essential Training Posted by Tepii13 in Apps - Windows Posted in Apps - Windows 0 2.04 GB 8 years ago Tepii13	Size 2.04 GB	Files 1	Age 8 years ago	Seeds 0	Leechs 0	Source
Lynda com Excel 2007 Macros in Depth-MovieJockey.com Posted by surfingalien in Apps - Windows Posted in Apps - Windows 0 180.6 MB 14 years ago surfingalien	Size 180.6 MB	Files 15	Age 14 years ago	Seeds 0	Leechs 0	Source
Lynda.com.Audio.for.Film.and.Video.with.Pro.Tools.9-QUASAR Posted by RARBG in Apps - Windows Posted in Apps - Windows 0 2.3 GB 15 years ago RARBG	Size 2.3 GB	Files 1	Age 15 years ago	Seeds 0	Leechs 0	Source
Lynda.com.ActionScript.3.0.in.Flash.Professional.CS5.Essential.Training-QUASAR Posted by RARBG in Apps - Windows Posted in Apps - Windows 0 695 MB 15 years ago RARBG	Size 695 MB	Files 1	Age 15 years ago	Seeds 0	Leechs 0	Source
Lynda com Foundations of Programming Fundamentals Posted by surfingalien in Apps - Windows Posted in Apps - Windows 0 1 GB 15 years ago surfingalien	Size 1 GB	Files 25	Age 15 years ago	Seeds 0	Leechs 0	Source

Lynda com Excel 2010 Essential Training + 2 Extra Courses - Team MJY

Torrent Contents Size: 1.08 GB

Description

Related Torrents

Location

Trackers

Latest News

Latest Searches

Sites In Our Index

Popular Tags