Excel 2013: Prepare for the Microsoft Office Specialist Certification Exam (77-420) Год выпуска: 04/2016 Производитель: Lynda Сайт производителя: lynda.com/Excel-tutorials/Excel-2013-Prepare-Microsoft-Office-Specialist-Certification-Exam-77-420/439680-2.html Автор: Jennifer McBee Продолжительность: 4:05 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: 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. 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. Продемонстрировать свое знание Excel, став специалистом Майкрософт офис. Учиться, чтобы сдать сертификационный экзамен МОС в Excel 2013. Этот курс, созданный Microsoft сертифицированный тренер Дженифер Макби, помогает тестируемых подготовиться к экзамену 77-420, который охватывает пять основных навыков на МОС в Excel 2013 ЕГЭ: создание рабочих листов и книг, ячеек и диапазонов, формулы и функции, диаграммы и другие объекты. Курс в первую очередь исследует программе MOS сертификации, ее стоимости, и ее Формат. Затем Дженнифер проходит через все цели сертификации в Excel подробно. Она включает в себя бесплатные файлы, так что вы можете следовать, как она демонстрирует каждый навык. Есть задачи, чтобы проверить свои навыки в конце почти каждой главы, и полный-длина, 50-минутная практика, экзамен в конце курса будет убедиться, что вы готовы к реальному экзамену.
Содержание
Introduction 2m 9s Welcome 51s What you should know before watching this course 15s Using the exercise files 32s Using the challenges 31s 1. Microsoft Office Specialist Exam Overview 7m 7s Compare the different Microsoft Office Specialist certifications 2m 0s Prepare for the exam 2m 12s Exam format and registration process 2m 55s 2. Create and Manage Workbooks and Worksheets 57m 52s Create new workbooks 3m 20s Add, copy, and move worksheets 5m 8s Use hyperlinks to navigate workbooks 2m 52s Use named ranges in navigation and formulas 4m 45s Use Find and Replace for conditional formatting and data validation 3m 3s Format using styles or themes 3m 35s Format using the Page Layout ribbon 3m 27s Insert headers and footers into worksheets 4m 47s Insert columns and rows; hide and unhide data 3m 45s Configure worksheets and workbooks for printing 6m 19s Add values to workbook properties 6m 11s Challenge: Worksheets and workbooks 1m 29s Solution: Worksheets and workbooks 9m 11s 3. Create and Modify Cells and Ranges 56m 25s Use Append to insert data into cells 5m 35s Move data between cells, worksheets, and workbooks 8m 17s Format worksheets using merge, cell styles, and number formats 6m 8s Resize cells to accommodate text 6m 45s Format cells using merge and align options 6m 21s Apply conditional formatting 6m 32s Create and use named ranges 4m 50s Use Find and Replace 5m 28s Challenge: Cells and ranges 32s Solution: Cells and ranges 5m 57s 4. Create and Modify Tables 24m 3s Create tables 6m 15s Modify tables 4m 51s Filter and sort tables 7m 0s Challenge: Create and modify tables 35s Solution: Create and modify tables 5m 22s 5. Apply Formulas and Functions 41m 19s Use relative and absolute references in formulas 5m 55s Understand the order of operations in formulas 3m 46s Summarize data using functions 5m 35s Utilize conditional logic in functions 7m 59s Use the CONCATENATE function to combine text 7m 11s Challenge: Formulas and functions 1m 6s Solution: Formulas and functions 9m 47s 6. Create Charts and Objects 24m 56s Create charts and add data series 7m 48s Format charts 4m 44s Insert and format graphic objects 6m 49s Challenge: Charts and objects 51s Solution: Charts and objects 4m 44s 7. Final Practice Exam 31m 42s Challenge: Full-length practice exam 59s Solution: Full-length practice exam 30m 43s Conclusion 22s Next steps 22s
[Lynda.com / Jennifer McBee] Excel 2013: Prepare for the Microsoft Office Specialist Certification Exam (77-420) [2016, ENG] download torrent for free and without registration
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}