2016-Lynda com-Cert_Prep_Excel_2016_Microsoft_Office_Specialist_ 77-727 -IVY

1. 00-Introduction/01-Welcome.mp48.81MB
2. 00-Introduction/02-Who_should_take_this_course.mp4473.89KB
3. 00-Introduction/03-Using_the_exercise_files.mp41.64MB
4. 00-Introduction/04-Using_the_challenges.mp41.33MB
5. 01-Microsoft_Office_Specialist_Exam_Ocerview/01-Compare_the_different_Microsoft_Office_Specialist_certifications.mp44.47MB
6. 01-Microsoft_Office_Specialist_Exam_Ocerview/02-Prepare_for_the_exam.mp44.8MB
7. 01-Microsoft_Office_Specialist_Exam_Ocerview/03-Exam_format_and_registration_process.mp46.84MB
8. 02-Create_and_Manage_Workbooks_and_Worksheets/01-Create_worksheets_and_workbooks.mp415.95MB
9. 02-Create_and_Manage_Workbooks_and_Worksheets/02-Navigate_in_worksheets_and_workbooks.mp417.94MB
10. 02-Create_and_Manage_Workbooks_and_Worksheets/03-Format_worksheets_and_workbooks.mp412.43MB
11. 02-Create_and_Manage_Workbooks_and_Worksheets/04-Configure_page_setup_and_headers_footers.mp412.15MB
12. 02-Create_and_Manage_Workbooks_and_Worksheets/05-Customize_options_and_views_for_worksheets_and_workbooks.mp414.93MB
13. 02-Create_and_Manage_Workbooks_and_Worksheets/06-Configure_worksheets_and_workbooks_for_distribution.mp416.4MB
14. 02-Create_and_Manage_Workbooks_and_Worksheets/07-Challenge_Create_and_manage_workbooks_and_worksheets.mp44.49MB
15. 02-Create_and_Manage_Workbooks_and_Worksheets/08-Solution_Create_and_manage_workbooks_and_worksheets.mp420.47MB
16. 03-Manage_Data_Cells_and_Ranges/01-Insert_data_in_cells_and_ranges.mp411.83MB
17. 03-Manage_Data_Cells_and_Ranges/02-Format_cells_and_ranges.mp417.57MB
18. 03-Manage_Data_Cells_and_Ranges/03-Summarize_data_with_conditional_formatting.mp48.81MB
19. 03-Manage_Data_Cells_and_Ranges/04-Summarize_and_organize_data.mp49.63MB
20. 03-Manage_Data_Cells_and_Ranges/05-Challenge_Manage_data_cells_and_ranges.mp41.36MB
21. 03-Manage_Data_Cells_and_Ranges/06-Solution_Manage_data_cells_and_ranges.mp48.48MB
22. 04-Create_Tables/01-Create_and_manage_tables.mp414.89MB
23. 04-Create_Tables/02-Manage_table_styles_and_options.mp414.31MB
24. 04-Create_Tables/03-Filter_and_sort_a_table.mp424.15MB
25. 04-Create_Tables/04-Challenge_Create_and_manage_tables.mp41.39MB
26. 04-Create_Tables/05-Solution_Create_and_manage_tables.mp49.81MB
27. 05-Perform_Operations_with_Formulas_and_Functions/01-Summarize_data_by_using_functions.mp415.28MB
28. 05-Perform_Operations_with_Formulas_and_Functions/02-Use_conditional_operation_functions_IF_and_COUNTIF_functions.mp414.71MB
29. 05-Perform_Operations_with_Formulas_and_Functions/03-Use_conditional_operation_functions_SUMIF_and_AVERAGEIF.mp411.03MB
30. 05-Perform_Operations_with_Formulas_and_Functions/04-Format_and_modify_text_by_using_functions.mp46.78MB
31. 05-Perform_Operations_with_Formulas_and_Functions/05-Combine_text_using_functions_and_flash_fill.mp49.14MB
32. 05-Perform_Operations_with_Formulas_and_Functions/06-Challenge_Perform_operations_with_formulas_and_functions.mp41.34MB
33. 05-Perform_Operations_with_Formulas_and_Functions/07-Solution_Perform_operations_with_formulas_and_functions.mp423.37MB
34. 06-Create_Charts_and_Objects/01-Create_charts.mp410.68MB
35. 06-Create_Charts_and_Objects/02-Format_charts.mp411.47MB
36. 06-Create_Charts_and_Objects/03-Insert_and_format_objects.mp411.35MB
37. 06-Create_Charts_and_Objects/04-Challenge_Create_charts_and_objects.mp41.32MB
38. 06-Create_Charts_and_Objects/05-Solution-Create_charts_and_objects.mp410.03MB
39. 07-Final_Practice_Exam/01-Challenge_Full_length_practice_exam.mp41.72MB
40. 07-Final_Practice_Exam/02-Solution_Full_length_practice_exam.mp486.33MB
41. 08-Conclusion/01-Next_steps.mp4808.47KB