Lynda Excel 3Courses Team MJY | E46FCEA9A7787FF8F0F039CC96B8ADD3C558175F

Lynda Excel 3Courses Team MJY

Name	Lynda.Excel.3Courses - Team MJY	DOWNLOAD Copy Link
Total Size	1.2 GB
Total Files	234
Hash	E46FCEA9A7787FF8F0F039CC96B8ADD3C558175F

/Essential Training/00 Introduction/
0001 Welcome.mov	7.6 MB
0002 Using the exercise files.mov	774.7 KB
/.../01 Getting Started/
0101 Exploring three common uses for Excel.mov	3.4 MB
0102 Touring the interface.mov	7.5 MB
0103 Finding the commands you need.mov	5.2 MB
0104 Using Backstage view or the File tab.mov	4.1 MB
0105 Maintaining file compatibility.mov	7.5 MB
/.../02 Worksheet Basics/
0201 Creating a worksheet.mov	5.6 MB
0202 Techniques for copying and pasting.mov	4.5 MB
0203 Entering data automatically with Auto Fill.mov	6.0 MB
0204 Targeting large data groups.mov	6.4 MB
0205 Changing a worksheet's structure.mov	3.9 MB
/.../03 Excel Formula Basics/
0301 Understanding formulas and functions.mov	4.9 MB
0302 Entering data in a worksheet.mov	3.5 MB
0303 Adding numbers manually.mov	5.1 MB
0304 Adding numbers using Sum and AutoSum.mov	7.0 MB
0305 Adding a whole worksheet.mov	2.0 MB
0306 Working with numbers in columns.mov	5.4 MB
0307 Preventing errors using absolute references.mov	6.4 MB
0308 Working with times and dates.mov	3.5 MB
0309 Using IF.mov	5.1 MB
0310 Using SUMIF and AVERAGEIF.mov	5.8 MB
0311 Naming and using cell ranges.mov	4.3 MB
/.../04 Essential Formatting/
0401 Formatting numbers and dates.mov	8.2 MB
0402 Applying fonts, background colors, and borders.mov	5.6 MB
0403 Adjusting columns, rows, and text.mov	5.9 MB
0404 Using conditional formatting.mov	5.8 MB
0405 Using custom conditional formatting.mov	8.1 MB
0406 Adding pictures and shapes.mov	10.3 MB
/.../05 Advanced Formatting/
0501 Inserting SmartArt.mov	9.0 MB
0502 Coordinating a look using themes.mov	5.1 MB
0503 Applying built-in styles.mov	4.9 MB
0504 Creating and sharing styles.mov	7.7 MB
0505 Using templates.mov	4.8 MB
0506 Creating and using original templates.mov	3.2 MB
/.../06 Printing Preparation/
0601 Making the pieces fit.mov	6.4 MB
0602 Inserting headers and footers.mov	4.6 MB
0603 Printing and PDFs.mov	5.4 MB
/.../07 Large Excel Projects/
0701 Finding and replacing data.mov	4.2 MB
0702 Freezing panes.mov	5.1 MB
0703 Repeating row and column titles.mov	4.5 MB
0704 Creating multiple custom worksheet views.mov	9.2 MB
0705 Hiding or grouping rows and columns.mov	7.9 MB
0706 Managing worksheets.mov	8.2 MB
0707 Calculating formulas across worksheets.mov	7.4 MB
/.../08 Collaborating with Others/
0801 Importing and exporting data in Excel.mov	10.6 MB
0802 Setting workbook permissions.mov	7.7 MB
0803 Inserting and editing comments.mov	8.9 MB
0804 Sharing a workbook.mov	1.8 MB
0805 Tracking changes.mov	3.8 MB
0806 Saving files in shared locations.mov	12.7 MB
/.../09 Exploring Excel's Database Features/
0901 Splitting cell data into multiple cells.mov	3.2 MB
0902 Joining data from multiple cells.mov	5.4 MB
0903 Basic and multi-field sorting.mov	8.7 MB
0904 Using tables to sort and filter data.mov	7.0 MB
0905 Inserting automatic subtotals.mov	4.9 MB
0906 Creating lookup tables.mov	7.1 MB
/.../10 Analyzing Data/
1001 Using auditing to diagram.mov	7.4 MB
1002 Using evaluation in Excel.mov	2.4 MB
1003 Working with Goal Seek.mov	6.1 MB
1004 Using data tables in formulas.mov	6.8 MB
1005 Using scenarios in formulas.mov	6.2 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
1103 Modifying a PivotTable.mov	8.0 MB
1104 Creating and modifying a PivotChart.mov	7.5 MB
/.../12 Creating and Using Charts/
1201 Choosing chart types.mov	1.8 MB
1202 Inserting Sparklines.mov	4.7 MB
1203 Creating a column chart.mov	3.8 MB
1204 Modifying a column chart.mov	7.2 MB
1205 Creating and modifying a pie chart.mov	8.5 MB
1206 Placing Excel charts into other Office applications.mov	6.1 MB
/.../13 Creating and Using Macros/
1301 Understanding macros.mov	2.9 MB
1302 Recording and using a simple macro.mov	14.8 MB
1303 Editing a macro.mov	7.6 MB
/.../14 Customizing Excel/
1401 Customizing the Quick Access toolbar.mov	4.5 MB
1402 Customizing the Ribbon bar.mov	13.8 MB
1403 Setting Excel options.mov	10.2 MB
/Essential Training/15 Conclusion/
1501 Goodbye.mov	250.2 KB
/Essential Training/Exercise Files/chapt 1/
backstage view.xlsx	155.1 KB
current format.xlsx	149.8 KB
older format workbook.xls	35.3 KB
ribbon bar.xlsx	155.1 KB
touring the interface.xlsx	140.2 KB
what is excel for.xlsx	147.0 KB
/Essential Training/Exercise Files/chapt 10/
analysis toolpack.xlsx	141.4 KB
auditing.xlsx	141.3 KB
data tables.xlsx	142.3 KB
evaluate.xlsx	22.6 KB
goal seek.xlsx	138.3 KB
scenarios.xlsx	136.4 KB
/Essential Training/Exercise Files/chapt 11/
create pivot table.xlsx	139.3 KB
modifying a pivottable.xlsx	144.2 KB
pivot chart.xlsx	151.0 KB
pivot table.xlsx	159.5 KB
/Essential Training/Exercise Files/chapt 12/
column chart.xlsx	138.1 KB
insert pie chart.docx	44.3 KB
insert pie chart.pptx	77.0 KB
modifying a chart.xlsx	139.9 KB
pie chart.xlsx	138.1 KB
placing chart.xlsx	140.3 KB
sparklines.xlsx	139.8 KB
/Essential Training/Exercise Files/chapt 13/
editing macro.xlsm	160.3 KB
northeast data.xlsx	138.0 KB
overseas data.xlsx	138.3 KB
recording macro.xlsx	138.0 KB
southeast data.xlsx	137.9 KB
west data.xlsx	138.5 KB
/Essential Training/Exercise Files/chapt 14/
Bob's Customizations.exportedUI	1.1 KB
customizing QAT.xlsx	141.6 KB
customizing ribbon.xlsx	141.6 KB
setting options.xlsx	141.6 KB
/Essential Training/Exercise Files/chapt 2/
autofill.xlsx	9.4 KB
clipboard.xlsx	9.0 KB
rows and columns.xlsx	140.2 KB
selections.xlsx	11.8 KB
/Essential Training/Exercise Files/chapt 3/
absolute refs.xlsx	11.4 KB
average.xlsx	12.9 KB
creating range names.xlsx	21.1 KB
dates.xlsx	11.7 KB
expense report.xlsx	9.6 KB
formulas and functions.xlsx	9.6 KB
if.xlsx	139.0 KB
manual.xlsx	11.5 KB
sum.xlsx	12.9 KB
sumif.xlsx	141.1 KB
whole worksheet.xlsx	12.9 KB
/Essential Training/Exercise Files/chapt 4/
adjusting.xlsx	12.4 KB
bottle.jpg	49.6 KB
conditional formatting.xlsx	139.8 KB
custom conditional formatting.xlsx	139.8 KB
fonts.xlsx	12.0 KB
formatting numbers.xlsx	11.9 KB
pictures - finished.xlsx	75.8 KB
pictures.xlsx	14.9 KB
/Essential Training/Exercise Files/chapt 5/
custom styles.xlsx	141.3 KB
garlic.jpg	52.2 KB
gift pack.jpg	32.1 KB
herbs.jpg	19.8 KB
logo.jpg	164.7 KB
merge styles.xlsx	140.3 KB
smart art.xlsx	139.1 KB
styles.xlsx	141.0 KB
themes.xlsx	26.1 KB
turn into template.xlsx	138.9 KB
/Essential Training/Exercise Files/chapt 6/
create PDFs.xlsx	91.3 KB
headers and footers.xlsx	69.5 KB
logo.jpg	24.7 KB
page size.xlsx	69.3 KB
/Essential Training/Exercise Files/chapt 7/
3D formulas.xlsx	155.5 KB
find and replace.xlsx	140.5 KB
freezing panes.xlsx	157.1 KB
grouping.xlsx	140.9 KB
managing worksheets.xlsx	139.8 KB
repeating rows.xlsx	140.6 KB
views.xlsx	143.5 KB
/Essential Training/Exercise Files/chapt 8/
comments.xlsx	206.3 KB
export this.xlsx	139.2 KB
import data.csv	2.2 KB
import data.txt	2.2 KB
import into this.xlsx	139.6 KB
kalamata.jpg	63.8 KB
multi-pack 1.jpg	32.1 KB
permissions.xlsx	147.5 KB
protecting.xlsx	142.1 KB
saving shared locations.xlsx	12.2 KB
sharing.xlsx	142.1 KB
/Essential Training/Exercise Files/chapt 9/
lookups.xlsx	138.3 KB
merging.xlsx	142.4 KB
sorting.xlsx	142.4 KB
splitting.xlsx	142.1 KB
subtotals.xlsx	142.8 KB
tables.xlsx	143.0 KB
/Essential Training/
www.moviejockey.com.txt	0.0 KB
/Excel 2010 Macros in Depth/
lce2010m.bin	456.2 MB
lce2010m.cue	0.1 KB
www.moviejockey.com.txt	0.0 KB
/00 Introduction/
0001 Welcome.mov	12.9 MB
0002 Using the exercise files.mov	1.4 MB
/.../01 Mastering the Utility Tasks Associated with Multiple Worksheets/
0101 Learning basic navigation tips.mov	19.2 MB
0102 Inserting and deleting new sheets.mov	8.7 MB
0103 Copying and moving sheets within a workbook.mov	7.9 MB
0104 Changing tab colors and renaming sheets.mov	5.7 MB
0105 Using the Hide function on worksheet tabs.mov	11.6 MB
/.../02 Working with Multiple Worksheets/
0201 Displaying multiple worksheets from the same workbook.mov	18.4 MB
0202 Copying, moving, and inserting data on different sheets.mov	5.9 MB
0203 Applying global changes to worksheets.mov	7.7 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
/06 Conclusion/
0601 Final thoughts.mov	2.8 MB
/Exercise Files/Chapter 01/
HiddenSheets.xlsx	378.2 KB
Hyperlink State File.xlsx	121.6 KB
RegionalFile.xlsx	21.8 KB
RegionalFile2.xlsx	21.7 KB
SalesData.xlsx	21.8 KB
Sample.xlsx	379.7 KB
/Exercise Files/Chapter 02/
DepartmentData.xlsx	376.5 KB
RegionalData.xlsx	21.8 KB
SalesData.xlsx	21.8 KB
Sample.xlsx	376.4 KB
/Exercise Files/Chapter 03/
3D Formulas.xlsx	114.2 KB
LinkageFormulas.xlsx	22.2 KB
PivotTableSummary.xlsx	21.3 KB
Sample.xlsx	21.8 KB
/Exercise Files/Chapter 04/
Chartdata2011.xlsx	961.0 KB
DivisionFiles.xlsx	376.5 KB
Olive-Arizona.xlsx	21.9 KB
Olive-California.xlsx	22.9 KB
Olive-Nevada.xlsx	20.9 KB
Olive-Oregon.xlsx	21.5 KB
QuarterlyBudget.xlsx	75.5 KB
StateSalesData.xlsx	51.3 KB
/Exercise Files/Chapter 05/
Arizona.xlsx	28.9 KB
California.xlsx	29.0 KB
CorpLink.xlsx	15.7 KB
CorporateData.xlsx	378.4 KB
Olive-Arizona.xlsx	21.9 KB
Olive-California.xlsx	22.9 KB
Olive-Nevada.xlsx	20.9 KB
Olive-Oregon.xlsx	21.5 KB
Olive-WesternConsolidation.xlsx	8.4 KB
Oregon.xlsx	28.9 KB
Washington.xlsx	29.0 KB
~$CorporateData.xlsx	0.2 KB
/Managing Multiple Worksheets and Workbooks/
www.moviejockey.com.txt	0.0 KB
/
www.moviejockey.com.txt	0.0 KB
Total files 234