2017-Lynda com-Cert_Prep_Excel_2016_Microsoft_Office_Expert_ 77-728 -IVY

1. 00-Introduction/01-Welcome.mp411.9MB
2. 00-Introduction/02-What_to_know_before_watching_this_course.mp4813.99KB
3. 00-Introduction/03-Using_the_exercise_files.mp42.01MB
4. 00-Introduction/04-Using_the_challenge_files.mp41.01MB
5. 01-Microsoft_Office_Specialist_(MOS)_Expert_Exam_Overview/01-Understand_the_different_kinds_of_Microsoft_Office_Specialist_certifications.mp43.97MB
6. 01-Microsoft_Office_Specialist_(MOS)_Expert_Exam_Overview/02-Prepare_for_the_test.mp44.64MB
7. 01-Microsoft_Office_Specialist_(MOS)_Expert_Exam_Overview/03-Overview_of_the_2016_MOS_Expert_exam_format_and_learning_objectives.mp45.86MB
8. 02-Manage_Workbook_Options_and_Settings/01-Manage_workbooks.mp412.62MB
9. 02-Manage_Workbook_Options_and_Settings/02-Reference_data_in_another_workbook.mp413.65MB
10. 02-Manage_Workbook_Options_and_Settings/03-Reference_data_using_structured_references.mp410.58MB
11. 02-Manage_Workbook_Options_and_Settings/04-Protect_worksheets_and_workbooks.mp415.1MB
12. 02-Manage_Workbook_Options_and_Settings/05-Challenge_Manage_workbook_options_and_settings.mp44.48MB
13. 02-Manage_Workbook_Options_and_Settings/06-Solution_Manage_workbook_options_and_setting.mp420.51MB
14. 03-Apply_Custom_Data_Formats_and_Layouts/01-Create_custom_formats_(number_time_and_date).mp415.43MB
15. 03-Apply_Custom_Data_Formats_and_Layouts/02-Populate_cells_by_using_advanced_Fill_Series_options.mp48.23MB
16. 03-Apply_Custom_Data_Formats_and_Layouts/03-Create_custom_conditional_formatting_rules_using_formulas.mp415.62MB
17. 03-Apply_Custom_Data_Formats_and_Layouts/04-Manage_conditional_formatting_rules.mp411.52MB
18. 03-Apply_Custom_Data_Formats_and_Layouts/05-Create_custom_styles_and_themes.mp422.21MB
19. 03-Apply_Custom_Data_Formats_and_Layouts/06-Insert_and_configure_form_controls.mp414.25MB
20. 03-Apply_Custom_Data_Formats_and_Layouts/07-Challenge_Apply_custom_data_formats_and_layouts.mp41.37MB
21. 03-Apply_Custom_Data_Formats_and_Layouts/08-Solution_Apply_custom_data_formats_and_layouts.mp426.17MB
22. 04-Create_Advanced_Formulas/01-Use_AND_OR_functions.mp415.1MB
23. 04-Create_Advanced_Formulas/02-Use_IFS_functions.mp415.82MB
24. 04-Create_Advanced_Formulas/03-Use_the_LOOKUP_function.mp423.22MB
25. 04-Create_Advanced_Formulas/04-Use_the_MATCH_and_INDEX_functions.mp412.94MB
26. 04-Create_Advanced_Formulas/05-Use_date_and_time_functions.mp416.42MB
27. 04-Create_Advanced_Formulas/06-Troubleshoot_formulas.mp417.47MB
28. 04-Create_Advanced_Formulas/07-Use_What_If_Analysis.mp412.89MB
29. 04-Create_Advanced_Formulas/08-Define_named_ranges_and_objects.mp417.9MB
30. 04-Create_Advanced_Formulas/09-Challenge_Create_advanced_formulas.mp41.33MB
31. 04-Create_Advanced_Formulas/10-Solution_Create_advanced_formulas.mp421.19MB
32. 05-Create_Advanced_Charts_and_Tables/01-Use_advanced_chart_formatting.mp412.49MB
33. 05-Create_Advanced_Charts_and_Tables/02-Create_and_modify_PivotTables_and_filter_with_slicers.mp414.3MB
34. 05-Create_Advanced_Charts_and_Tables/03-Format_PivotTables_and_use_GETPIVOTDATA.mp427.18MB
35. 05-Create_Advanced_Charts_and_Tables/04-Create_and_modify_PivotCharts.mp420.6MB
36. 05-Create_Advanced_Charts_and_Tables/05-Challenge_Create_advanced_charts_and_tables.mp41.35MB
37. 05-Create_Advanced_Charts_and_Tables/06-Solution_Create_advanced_charts_and_tables.mp419.55MB
38. 06-Final_Challenge/01-Challenge_Full_length_MOS_Expert_sample_exam_for_Excel_2016.mp42.22MB
39. 06-Final_Challenge/02-Solution_Full_length_MOS_Expert_sample_exam_for_Excel_2016.mp488.49MB
40. 07-Conclusion/Next steps-583084.mp41.08MB