Lynda - Excel 2013: Prepare for the Microsoft Office Specialist
- Type:
- Other > Other
- Files:
- 107
- Size:
- 733.45 MiB (769078372 Bytes)
- Uploaded:
- 2016-05-08 10:37:44 GMT
- By:
-
2boweb
- Seeders:
- 1
- Leechers:
- 0
- Comments
- 0
- Info Hash: 33F5D03802E87A369BEF73063E1E5308E68F06E8
(Problems with magnets links are fixed by upgrading your torrent client!)
Lynda - Excel 2013: Prepare for the Microsoft Office Specialist Certification Exam (77-420) FYI : This Course will be good to the Best for DL within 30 days after has been posed, after that it might not be good DL already, please do me favour to continue seeding to keep this torrent alive. 4h 5m Beginner Apr 04, 2016 | Uploaded in May 8, 2016 by 2boweb Subject: Business Software: Excel Office Author: Jennifer McBee Demonstrate your knowledge of Excel by becoming a Microsoft Office Specialist. Study to pass the MOS Excel 2013 certification exam. This course, created by Microsoft Certified Trainer Jennifer McBee, helps test takers prepare for exam 77-420, which covers the five main skills on the MOS Excel 2013 exam: creating worksheets and workbooks, cells and ranges, formulas and functions, and charts and other objects. Disclaimer: Microsoft does not produce, provide, or endorse this video training course. The course first explores the MOS certification program, its cost, and its format. Jennifer then walks through all of the Excel certification objectives in detail. She includes free practice files so you can follow along as she demonstrates each skill. There are challenges to test your skills at the end of almost every chapter, and the full-length, 50-minute practice exam at the end of the course will ensure you're ready for the real exam. Topics include: • Preparing for the exam • Understanding the registration process • Creating new Excel workbooks and worksheets • Formatting data • Inserting columns and rows • Moving data • Applying conditional formatting • Creating tables • Applying formulas and functions • Summarizing data • Creating charts • Taking a full-length practice exam ////////////////////////////////////////////////////////////////////
| 049 Solution - Full-length practice exam.mp4 | 104.36 MiB |
| 042 Solution - Formulas and functions.mp4 | 32.13 MiB |
| 039 Utilize conditional logic in functions.mp4 | 29.8 MiB |
| 020 Solution - Worksheets and workbooks.mp4 | 24.62 MiB |
| 031 Create tables.mp4 | 24.32 MiB |
| 022 Move data between cells, worksheets, and workbooks.mp4 | 23.95 MiB |
| 033 Filter and sort tables.mp4 | 22.99 MiB |
| 026 Apply conditional formatting.mp4 | 22.77 MiB |
| 030 Solution - Cells and ranges.mp4 | 20.4 MiB |
| 024 Resize cells to accommodate text.mp4 | 20.32 MiB |
| 038 Summarize data using functions.mp4 | 19.09 MiB |
| 040 Use the CONCATENATE function to combine text.mp4 | 18.79 MiB |
| 043 Create charts and add data series.mp4 | 18.72 MiB |
| 023 Format worksheets using merge, cell styles, and number formats.mp4 | 18.63 MiB |
| 028 Use Find and Replace.mp4 | 17.67 MiB |
| 035 Solution - Create and modify tables.mp4 | 17.47 MiB |
| 032 Modify tables.mp4 | 17.36 MiB |
| 017 Configure worksheets and workbooks for printing.mp4 | 17.28 MiB |
| 045 Insert and format graphic objects.mp4 | 16.48 MiB |
| 025 Format cells using merge and align options.mp4 | 15.99 MiB |
| 018 Add values to workbook properties.mp4 | 15.31 MiB |
| 047 Solution - Charts and objects.mp4 | 15.24 MiB |
| 036 Use relative and absolute references in formulas.mp4 | 14.47 MiB |
| 021 Use Append to insert data into cells.mp4 | 14.25 MiB |
| 015 Insert headers and footers into worksheets.mp4 | 12.79 MiB |
| 044 Format charts.mp4 | 12.06 MiB |
| 027 Create and use named ranges.mp4 | 12.01 MiB |
| 009 Add, copy, and move worksheets.mp4 | 11.1 MiB |
| 013 Format using styles or themes.mp4 | 10.52 MiB |
| 011 Use named ranges in navigation and formulas.mp4 | 10.35 MiB |
| 014 Format using the Page Layout ribbon.mp4 | 9.49 MiB |
| 016 Insert columns and rows; hide and unhide data.mp4 | 9.08 MiB |
| 008 Create new workbooks.mp4 | 8.76 MiB |
| 012 Use Find and Replace for conditional formatting and data validation.mp4 | 8.47 MiB |
| 037 Understand the order of operations in formulas.mp4 | 8.19 MiB |
| 007 Exam format and registration process.mp4 | 7.04 MiB |
| 010 Use hyperlinks to navigate workbooks.mp4 | 6.55 MiB |
| 001 Welcome.mp4 | 6.03 MiB |
| 006 Prepare for the exam.mp4 | 5.19 MiB |
| 005 Compare the different Microsoft Office Specialist certifications.mp4 | 4.05 MiB |
| 019 Challenge - Worksheets and workbooks.mp4 | 3.68 MiB |
| 041 Challenge - Formulas and functions.mp4 | 3.11 MiB |
| 046 Challenge - Charts and objects.mp4 | 2.5 MiB |
| 048 Challenge - Full-length practice exam.mp4 | 2.2 MiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 7/Logo.jpg | 2.07 MiB |
| 034 Challenge - Create and modify tables.mp4 | 1.58 MiB |
| 029 Challenge - Cells and ranges.mp4 | 1.39 MiB |
| 050 Next steps.mp4 | 1.17 MiB |
| 003 Using the exercise files.mp4 | 1.03 MiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 3/03_04 AccomodateText.xlsx.dmg | 882.97 KiB |
| 004 Using the challenges.mp4 | 779.81 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 3/03_06 Conditional.xlsx.dmg | 743.65 KiB |
| 002 What you should know before watching this course.mp4 | 625.67 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 5/My 05_06 Challenge Exercise.xlsx | 599.85 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 6/Crop.jpg | 592.61 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 5/05_06 Challenge.xlsx | 571.1 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 3/03_05 MergeAlign.xlsx | 543.85 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 3/03_05 MergeAlign.xlsx.dmg | 521.83 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 3/03_08 FindReplace.xlsx | 486.31 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 6/WorldMap.jpg | 486.17 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 3/03_04 AccomodateText.xlsx | 431.64 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 4/04_02 ModifyTable.xlsx | 424.81 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 4/04_01 CreateTable.xlsx | 424.02 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 4/04_03 FilterSort.xlsx | 373.79 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 3/03_06 Conditional.xlsx | 371.48 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 7/My Excel 2013 Challenge.xlsx | 156.13 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 5/05_03 Summarize.xlsx | 131.29 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 7/07_01 Final Challenge.xlsx | 96.13 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 3/03_03 FormatCellsStyles.xlsx.dmg | 89.21 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 3/03_09 Challenge.xlsx | 87.58 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 2/02_09 InsertCells.xlsx | 85.41 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 2/02_08 HeadersFooters.xlsx | 84.99 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 2/02_06 FormatWorksheets.xlsx | 84.99 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 3/03_03 FormatCellsStyles.xlsx | 83.45 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 3/03_02 CopyMoveData.xlsx | 77.8 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 3/03_01 AppendData.xlsx | 74.5 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 2/02_05 Find.xlsx | 67.13 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 5/05_05 Concatenate.xlsx | 65.86 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 2/02_10 Configure.xlsx | 65.39 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 5/05_04 ConditionalLogic.xlsx | 64.25 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 6/06_03 GraphicObjects.xlsx | 58.49 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 2/02_06 Format.xlsx | 53.89 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 2/02_09 InsertHide.xlsx | 53.86 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 2/02_07 PageLayout.xlsx | 53.32 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 3/03_02 CopyMoveData.xlsx.dmg | 37.74 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 3/03_01 AppendData.xlsx.dmg | 35.87 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 2/02_03 Hyperlinks.xlsx | 33.58 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 2/My 02_12 Challenge.xlsx | 31.28 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 6/06_02 FormatChart.xlsx | 30.54 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 4/My 04 Challenge Exercise.xlsx | 29.68 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 6/My 06_04 Challenge Exercise.xlsx | 29.48 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 4/04_04 Challenge.xlsx | 28.8 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 6/06_01 CreateChart.xlsx | 27.15 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 2/02_12 Challenge.xlsx | 26.87 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 2/02_02 ModifyWorksheets.xlsx | 24.96 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 2/02_04 NamedRanges.xlsx | 21.07 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 5/05_02 Order.xlsx | 20.08 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 3/03_01 WestSales.txt.dmg | 19.11 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 6/06_04 Challenge.xlsx | 18.67 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 2/02_11 AddValues.xlsx | 18.3 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 3/03_07 NamedRanges.xlsx | 16.82 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 1/MOS Excel 2013 Objectives.docx | 13.76 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 2/02_11 Values.xlsx | 12.68 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 5/05_01 RelativeAbsolute.xlsx | 10.8 KiB |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 3/03_01 WestSales.txt | 431 B |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 7/New Clients.txt | 283 B |
| Ex_Files_Excel2013_MSOffice_ExamPrep/Exercise Files/Chapter 3/03_09 Vendor.txt | 169 B |
