| 001 Welcome.mp4 | 6.03 MB | ||
| 002 What you should know before watching this course.mp4 | 625.67 KB | ||
| 003 Using the exercise files.mp4 | 1.03 MB | ||
| 004 Using the challenges.mp4 | 779.81 KB | ||
| 005 Compare the different Microsoft Office Specialist certifications.mp4 | 4.05 MB | ||
| 006 Prepare for the exam.mp4 | 5.19 MB | ||
| 007 Exam format and registration process.mp4 | 7.04 MB | ||
| 008 Create new workbooks.mp4 | 8.76 MB | ||
| 009 Add, copy, and move worksheets.mp4 | 11.1 MB | ||
| 010 Use hyperlinks to navigate workbooks.mp4 | 6.55 MB | ||
| 011 Use named ranges in navigation and formulas.mp4 | 10.35 MB | ||
| 012 Use Find and Replace for conditional formatting and data validation.mp4 | 8.47 MB | ||
| 013 Format using styles or themes.mp4 | 10.52 MB | ||
| 014 Format using the Page Layout ribbon.mp4 | 9.49 MB | ||
| 015 Insert headers and footers into worksheets.mp4 | 12.79 MB | ||
| 016 Insert columns and rows; hide and unhide data.mp4 | 9.08 MB | ||
| 017 Configure worksheets and workbooks for printing.mp4 | 17.28 MB | ||
| 018 Add values to workbook properties.mp4 | 15.31 MB | ||
| 019 Challenge - Worksheets and workbooks.mp4 | 3.68 MB | ||
| 020 Solution - Worksheets and workbooks.mp4 | 24.62 MB | ||
| 021 Use Append to insert data into cells.mp4 | 14.25 MB | ||
| 022 Move data between cells, worksheets, and workbooks.mp4 | 23.95 MB | ||
| 023 Format worksheets using merge, cell styles, and number formats.mp4 | 18.63 MB | ||
| 024 Resize cells to accommodate text.mp4 | 20.32 MB | ||
| 025 Format cells using merge and align options.mp4 | 15.99 MB | ||
| 026 Apply conditional formatting.mp4 | 22.77 MB | ||
| 027 Create and use named ranges.mp4 | 12.01 MB | ||
| 028 Use Find and Replace.mp4 | 17.67 MB | ||
| 029 Challenge - Cells and ranges.mp4 | 1.39 MB | ||
| 030 Solution - Cells and ranges.mp4 | 20.4 MB | ||
| 031 Create tables.mp4 | 24.32 MB | ||
| 032 Modify tables.mp4 | 17.36 MB | ||
| 033 Filter and sort tables.mp4 | 22.99 MB | ||
| 034 Challenge - Create and modify tables.mp4 | 1.58 MB | ||
| 035 Solution - Create and modify tables.mp4 | 17.47 MB | ||
| 036 Use relative and absolute references in formulas.mp4 | 14.47 MB | ||
| 037 Understand the order of operations in formulas.mp4 | 8.19 MB | ||
| 038 Summarize data using functions.mp4 | 19.09 MB | ||
| 039 Utilize conditional logic in functions.mp4 | 29.8 MB | ||
| 040 Use the CONCATENATE function to combine text.mp4 | 18.79 MB | ||
| 041 Challenge - Formulas and functions.mp4 | 3.11 MB | ||
| 042 Solution - Formulas and functions.mp4 | 32.13 MB | ||
| 043 Create charts and add data series.mp4 | 18.72 MB | ||
| 044 Format charts.mp4 | 12.06 MB | ||
| 045 Insert and format graphic objects.mp4 | 16.48 MB | ||
| 046 Challenge - Charts and objects.mp4 | 2.5 MB | ||
| 047 Solution - Charts and objects.mp4 | 15.24 MB | ||
| 048 Challenge - Full-length practice exam.mp4 | 2.2 MB | ||
| 049 Solution - Full-length practice exam.mp4 | 104.36 MB | ||
| 050 Next steps.mp4 | 1.17 MB | ||
| Ex_Files_Excel2013_MSOffice_ExamPrep | |||
| Exercise Files | |||
| Chapter 1 | |||
| MOS Excel 2013 Objectives.docx | 13.76 KB | ||
| Chapter 2 | |||
| 02_02 ModifyWorksheets.xlsx | 24.96 KB | ||
| 02_03 Hyperlinks.xlsx | 33.58 KB | ||
| 02_04 NamedRanges.xlsx | 21.07 KB | ||
| 02_05 Find.xlsx | 67.13 KB | ||
| 02_06 Format.xlsx | 53.89 KB | ||
| 02_06 FormatWorksheets.xlsx | 84.99 KB | ||
| 02_07 PageLayout.xlsx | 53.32 KB | ||
| 02_08 HeadersFooters.xlsx | 84.99 KB | ||
| 02_09 InsertCells.xlsx | 85.41 KB | ||
| 02_09 InsertHide.xlsx | 53.86 KB | ||
| 02_10 Configure.xlsx | 65.39 KB | ||
| 02_11 AddValues.xlsx | 18.3 KB | ||
| 02_11 Values.xlsx | 12.68 KB | ||
| 02_12 Challenge.xlsx | 26.87 KB | ||
| My 02_12 Challenge.xlsx | 31.28 KB | ||
| Chapter 3 | |||
| 03_01 AppendData.xlsx | 74.5 KB | ||
| 03_01 AppendData.xlsx.dmg | 35.87 KB | ||
| 03_01 WestSales.txt | 431 B | ||
| 03_01 WestSales.txt.dmg | 19.11 KB | ||
| 03_02 CopyMoveData.xlsx | 77.8 KB | ||
| 03_02 CopyMoveData.xlsx.dmg | 37.74 KB | ||
| 03_03 FormatCellsStyles.xlsx | 83.45 KB | ||
| 03_03 FormatCellsStyles.xlsx.dmg | 89.21 KB | ||
| 03_04 AccomodateText.xlsx | 431.64 KB | ||
| 03_04 AccomodateText.xlsx.dmg | 882.97 KB | ||
| 03_05 MergeAlign.xlsx | 543.85 KB | ||
| 03_05 MergeAlign.xlsx.dmg | 521.83 KB | ||
| 03_06 Conditional.xlsx | 371.48 KB | ||
| 03_06 Conditional.xlsx.dmg | 743.65 KB | ||
| 03_07 NamedRanges.xlsx | 16.82 KB | ||
| 03_08 FindReplace.xlsx | 486.31 KB | ||
| 03_09 Challenge.xlsx | 87.58 KB | ||
| 03_09 Vendor.txt | 169 B | ||
| Chapter 4 | |||
| 04_01 CreateTable.xlsx | 424.02 KB | ||
| 04_02 ModifyTable.xlsx | 424.81 KB | ||
| 04_03 FilterSort.xlsx | 373.79 KB | ||
| 04_04 Challenge.xlsx | 28.8 KB | ||
| My 04 Challenge Exercise.xlsx | 29.68 KB | ||
| Chapter 5 | |||
| 05_01 RelativeAbsolute.xlsx | 10.8 KB | ||
| 05_02 Order.xlsx | 20.08 KB | ||
| 05_03 Summarize.xlsx | 131.29 KB | ||
| 05_04 ConditionalLogic.xlsx | 64.25 KB | ||
| 05_05 Concatenate.xlsx | 65.86 KB | ||
| 05_06 Challenge.xlsx | 571.1 KB | ||
| My 05_06 Challenge Exercise.xlsx | 599.85 KB | ||
| Chapter 6 | |||
| 06_01 CreateChart.xlsx | 27.15 KB | ||
| 06_02 FormatChart.xlsx | 30.54 KB | ||
| 06_03 GraphicObjects.xlsx | 58.49 KB | ||
| 06_04 Challenge.xlsx | 18.67 KB | ||
| Crop.jpg?042148 | 592.61 KB | ||
| My 06_04 Challenge Exercise.xlsx | 29.48 KB | ||
| WorldMap.jpg?042148 | 486.17 KB | ||
| Chapter 7 | |||
| 07_01 Final Challenge.xlsx | 96.13 KB | ||
| Logo.jpg?042148 | 2.07 MB | ||
| My Excel 2013 Challenge.xlsx | 156.13 KB | ||
| New Clients.txt | 283 B | ||
| ▲ 107 total files | |||
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
////////////////////////////////////////////////////////////////////
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
[ CourseWikia ] Lynda - Excel for the Web Tips and Tricks (Office 365 - Microsoft 365) Posted by
freecoursewb in Other
|
185.6 MB | freecoursewb | 5 years | 0 | 0 |
| 91.7 MB | freecoursewb | 5 years | 0 | 0 | |
| 868.6 MB | freecoursewb | 5 years | 0 | 0 | |
|
[ DevCourseWeb ] Lynda - Excel - Setting Up a Database (Office 365 - Microsoft 365) Posted by
freecoursewb in Other
|
207.9 MB | freecoursewb | 5 years | 0 | 0 |
| 215.36 MB | tutsnode | 5 years | 12 | 1 |
All Comments