Lynda Excel 2013 Prepare for the Microsoft Office Specialist Certification Exam 77 420

Lynda Excel 2013 Prepare for the Microsoft Office Specialist Certification Exam 77 420

Name	Lynda - Excel 2013 Prepare for the Microsoft Office Specialist Certification Exam (77-420)	DOWNLOAD Copy Link
Total Size	769.1 MB
Total Files	107
Hash	33F5D03802E87A369BEF73063E1E5308E68F06E8

/
049 Solution - Full-length practice exam.mp4	109.4 MB
042 Solution - Formulas and functions.mp4	33.7 MB
039 Utilize conditional logic in functions.mp4	31.3 MB
020 Solution - Worksheets and workbooks.mp4	25.8 MB
031 Create tables.mp4	25.5 MB
022 Move data between cells, worksheets, and workbooks.mp4	25.1 MB
033 Filter and sort tables.mp4	24.1 MB
026 Apply conditional formatting.mp4	23.9 MB
030 Solution - Cells and ranges.mp4	21.4 MB
024 Resize cells to accommodate text.mp4	21.3 MB
038 Summarize data using functions.mp4	20.0 MB
040 Use the CONCATENATE function to combine text.mp4	19.7 MB
043 Create charts and add data series.mp4	19.6 MB
023 Format worksheets using merge, cell styles, and number formats.mp4	19.5 MB
028 Use Find and Replace.mp4	18.5 MB
035 Solution - Create and modify tables.mp4	18.3 MB
032 Modify tables.mp4	18.2 MB
017 Configure worksheets and workbooks for printing.mp4	18.1 MB
045 Insert and format graphic objects.mp4	17.3 MB
025 Format cells using merge and align options.mp4	16.8 MB
018 Add values to workbook properties.mp4	16.1 MB
047 Solution - Charts and objects.mp4	16.0 MB
036 Use relative and absolute references in formulas.mp4	15.2 MB
021 Use Append to insert data into cells.mp4	14.9 MB
015 Insert headers and footers into worksheets.mp4	13.4 MB
044 Format charts.mp4	12.6 MB
027 Create and use named ranges.mp4	12.6 MB
009 Add, copy, and move worksheets.mp4	11.6 MB
013 Format using styles or themes.mp4	11.0 MB
011 Use named ranges in navigation and formulas.mp4	10.9 MB
014 Format using the Page Layout ribbon.mp4	9.9 MB
016 Insert columns and rows; hide and unhide data.mp4	9.5 MB
008 Create new workbooks.mp4	9.2 MB
012 Use Find and Replace for conditional formatting and data validation.mp4	8.9 MB
037 Understand the order of operations in formulas.mp4	8.6 MB
007 Exam format and registration process.mp4	7.4 MB
010 Use hyperlinks to navigate workbooks.mp4	6.9 MB
001 Welcome.mp4	6.3 MB
006 Prepare for the exam.mp4	5.4 MB
005 Compare the different Microsoft Office Specialist certifications.mp4	4.2 MB
019 Challenge - Worksheets and workbooks.mp4	3.9 MB
041 Challenge - Formulas and functions.mp4	3.3 MB
046 Challenge - Charts and objects.mp4	2.6 MB
048 Challenge - Full-length practice exam.mp4	2.3 MB
034 Challenge - Create and modify tables.mp4	1.7 MB
029 Challenge - Cells and ranges.mp4	1.5 MB
050 Next steps.mp4	1.2 MB
003 Using the exercise files.mp4	1.1 MB
004 Using the challenges.mp4	798.5 KB
002 What you should know before watching this course.mp4	640.7 KB
/Exercise Files/Chapter 7/
Logo.jpg	2.2 MB
My Excel 2013 Challenge.xlsx	159.9 KB
07_01 Final Challenge.xlsx	98.4 KB
New Clients.txt	0.3 KB
/Exercise Files/Chapter 3/
03_04 AccomodateText.xlsx.dmg	904.2 KB
03_06 Conditional.xlsx.dmg	761.5 KB
03_05 MergeAlign.xlsx	556.9 KB
03_05 MergeAlign.xlsx.dmg	534.4 KB
03_08 FindReplace.xlsx	498.0 KB
03_04 AccomodateText.xlsx	442.0 KB
03_06 Conditional.xlsx	380.4 KB
03_03 FormatCellsStyles.xlsx.dmg	91.4 KB
03_09 Challenge.xlsx	89.7 KB
03_03 FormatCellsStyles.xlsx	85.5 KB
03_02 CopyMoveData.xlsx	79.7 KB
03_01 AppendData.xlsx	76.3 KB
03_02 CopyMoveData.xlsx.dmg	38.6 KB
03_01 AppendData.xlsx.dmg	36.7 KB
03_01 WestSales.txt.dmg	19.6 KB
03_07 NamedRanges.xlsx	17.2 KB
03_01 WestSales.txt	0.4 KB
03_09 Vendor.txt	0.2 KB
/Exercise Files/Chapter 5/
My 05_06 Challenge Exercise.xlsx	614.2 KB
05_06 Challenge.xlsx	584.8 KB
05_03 Summarize.xlsx	134.4 KB
05_05 Concatenate.xlsx	67.4 KB
05_04 ConditionalLogic.xlsx	65.8 KB
05_02 Order.xlsx	20.6 KB
05_01 RelativeAbsolute.xlsx	11.1 KB
/Exercise Files/Chapter 6/
Crop.jpg	606.8 KB
WorldMap.jpg	497.8 KB
06_03 GraphicObjects.xlsx	59.9 KB
06_02 FormatChart.xlsx	31.3 KB
My 06_04 Challenge Exercise.xlsx	30.2 KB
06_01 CreateChart.xlsx	27.8 KB
06_04 Challenge.xlsx	19.1 KB
/Exercise Files/Chapter 4/
04_02 ModifyTable.xlsx	435.0 KB
04_01 CreateTable.xlsx	434.2 KB
04_03 FilterSort.xlsx	382.8 KB
My 04 Challenge Exercise.xlsx	30.4 KB
04_04 Challenge.xlsx	29.5 KB
/Exercise Files/Chapter 2/
02_09 InsertCells.xlsx	87.5 KB
02_08 HeadersFooters.xlsx	87.0 KB
02_06 FormatWorksheets.xlsx	87.0 KB
02_05 Find.xlsx	68.7 KB
02_10 Configure.xlsx	67.0 KB
02_06 Format.xlsx	55.2 KB
02_09 InsertHide.xlsx	55.2 KB
02_07 PageLayout.xlsx	54.6 KB
02_03 Hyperlinks.xlsx	34.4 KB
My 02_12 Challenge.xlsx	32.0 KB
02_12 Challenge.xlsx	27.5 KB
02_02 ModifyWorksheets.xlsx	25.6 KB
02_04 NamedRanges.xlsx	21.6 KB
02_11 AddValues.xlsx	18.7 KB
02_11 Values.xlsx	13.0 KB
/Exercise Files/Chapter 1/
MOS Excel 2013 Objectives.docx	14.1 KB
Total files 107