Download link
File List
-
00-Introduction/01-Welcome.mp4 11.9 MB
00-Introduction/01-Welcome.srt 2.33 KB
00-Introduction/02-What_to_know_before_watching_this_course.mp4 813.99 KB
00-Introduction/02-What_to_know_before_watching_this_course.srt 741 B
00-Introduction/03-Using_the_exercise_files.mp4 2.01 MB
00-Introduction/03-Using_the_exercise_files.srt 1.2 KB
00-Introduction/04-Using_the_challenge_files.mp4 1.01 MB
00-Introduction/04-Using_the_challenge_files.srt 1001 B
01-Microsoft_Office_Specialist_(MOS)_Expert_Exam_Overview/01-Understand_the_different_kinds_of_Microsoft_Office_Specialist_certifications.mp4 3.97 MB
01-Microsoft_Office_Specialist_(MOS)_Expert_Exam_Overview/01-Understand_the_different_kinds_of_Microsoft_Office_Specialist_certifications.srt 2.83 KB
01-Microsoft_Office_Specialist_(MOS)_Expert_Exam_Overview/02-Prepare_for_the_test.mp4 4.64 MB
01-Microsoft_Office_Specialist_(MOS)_Expert_Exam_Overview/02-Prepare_for_the_test.srt 4.93 KB
01-Microsoft_Office_Specialist_(MOS)_Expert_Exam_Overview/03-Overview_of_the_2016_MOS_Expert_exam_format_and_learning_objectives.mp4 5.86 MB
01-Microsoft_Office_Specialist_(MOS)_Expert_Exam_Overview/03-Overview_of_the_2016_MOS_Expert_exam_format_and_learning_objectives.srt 5.71 KB
02-Manage_Workbook_Options_and_Settings/01-Manage_workbooks.mp4 12.62 MB
02-Manage_Workbook_Options_and_Settings/01-Manage_workbooks.srt 7.78 KB
02-Manage_Workbook_Options_and_Settings/02-Reference_data_in_another_workbook.mp4 13.65 MB
02-Manage_Workbook_Options_and_Settings/02-Reference_data_in_another_workbook.srt 7.5 KB
02-Manage_Workbook_Options_and_Settings/03-Reference_data_using_structured_references.mp4 10.58 MB
02-Manage_Workbook_Options_and_Settings/03-Reference_data_using_structured_references.srt 7.01 KB
02-Manage_Workbook_Options_and_Settings/04-Protect_worksheets_and_workbooks.mp4 15.1 MB
02-Manage_Workbook_Options_and_Settings/04-Protect_worksheets_and_workbooks.srt 8.56 KB
02-Manage_Workbook_Options_and_Settings/05-Challenge_Manage_workbook_options_and_settings.mp4 4.48 MB
02-Manage_Workbook_Options_and_Settings/05-Challenge_Manage_workbook_options_and_settings.srt 2.92 KB
02-Manage_Workbook_Options_and_Settings/06-Solution_Manage_workbook_options_and_setting.mp4 20.51 MB
02-Manage_Workbook_Options_and_Settings/06-Solution_Manage_workbook_options_and_setting.srt 11.86 KB
03-Apply_Custom_Data_Formats_and_Layouts/01-Create_custom_formats_(number_time_and_date).mp4 15.43 MB
03-Apply_Custom_Data_Formats_and_Layouts/01-Create_custom_formats_(number_time_and_date).srt 8.07 KB
03-Apply_Custom_Data_Formats_and_Layouts/02-Populate_cells_by_using_advanced_Fill_Series_options.mp4 8.23 MB
03-Apply_Custom_Data_Formats_and_Layouts/02-Populate_cells_by_using_advanced_Fill_Series_options.srt 5.05 KB
03-Apply_Custom_Data_Formats_and_Layouts/03-Create_custom_conditional_formatting_rules_using_formulas.mp4 15.62 MB
03-Apply_Custom_Data_Formats_and_Layouts/03-Create_custom_conditional_formatting_rules_using_formulas.srt 7.96 KB
03-Apply_Custom_Data_Formats_and_Layouts/04-Manage_conditional_formatting_rules.mp4 11.52 MB
03-Apply_Custom_Data_Formats_and_Layouts/04-Manage_conditional_formatting_rules.srt 5.97 KB
03-Apply_Custom_Data_Formats_and_Layouts/05-Create_custom_styles_and_themes.mp4 22.21 MB
03-Apply_Custom_Data_Formats_and_Layouts/05-Create_custom_styles_and_themes.srt 12.88 KB
03-Apply_Custom_Data_Formats_and_Layouts/06-Insert_and_configure_form_controls.mp4 14.25 MB
03-Apply_Custom_Data_Formats_and_Layouts/06-Insert_and_configure_form_controls.srt 9.42 KB
03-Apply_Custom_Data_Formats_and_Layouts/07-Challenge_Apply_custom_data_formats_and_layouts.mp4 1.37 MB
03-Apply_Custom_Data_Formats_and_Layouts/07-Challenge_Apply_custom_data_formats_and_layouts.srt 945 B
03-Apply_Custom_Data_Formats_and_Layouts/08-Solution_Apply_custom_data_formats_and_layouts.mp4 26.17 MB
03-Apply_Custom_Data_Formats_and_Layouts/08-Solution_Apply_custom_data_formats_and_layouts.srt 12.77 KB
04-Create_Advanced_Formulas/01-Use_AND_OR_functions.mp4 15.1 MB
04-Create_Advanced_Formulas/01-Use_AND_OR_functions.srt 9.53 KB
04-Create_Advanced_Formulas/02-Use_IFS_functions.mp4 15.82 MB
04-Create_Advanced_Formulas/02-Use_IFS_functions.srt 8.75 KB
04-Create_Advanced_Formulas/03-Use_the_LOOKUP_function.mp4 23.22 MB
04-Create_Advanced_Formulas/03-Use_the_LOOKUP_function.srt 10.9 KB
04-Create_Advanced_Formulas/04-Use_the_MATCH_and_INDEX_functions.mp4 12.94 MB
04-Create_Advanced_Formulas/04-Use_the_MATCH_and_INDEX_functions.srt 7.76 KB
04-Create_Advanced_Formulas/05-Use_date_and_time_functions.mp4 16.42 MB
04-Create_Advanced_Formulas/05-Use_date_and_time_functions.srt 9.57 KB
04-Create_Advanced_Formulas/06-Troubleshoot_formulas.mp4 17.47 MB
04-Create_Advanced_Formulas/06-Troubleshoot_formulas.srt 10.48 KB
04-Create_Advanced_Formulas/07-Use_What_If_Analysis.mp4 12.89 MB
04-Create_Advanced_Formulas/07-Use_What_If_Analysis.srt 8.65 KB
04-Create_Advanced_Formulas/08-Define_named_ranges_and_objects.mp4 17.9 MB
04-Create_Advanced_Formulas/08-Define_named_ranges_and_objects.srt 10.07 KB
04-Create_Advanced_Formulas/09-Challenge_Create_advanced_formulas.mp4 1.33 MB
04-Create_Advanced_Formulas/09-Challenge_Create_advanced_formulas.srt 866 B
04-Create_Advanced_Formulas/10-Solution_Create_advanced_formulas.mp4 21.19 MB
04-Create_Advanced_Formulas/10-Solution_Create_advanced_formulas.srt 10.79 KB
05-Create_Advanced_Charts_and_Tables/01-Use_advanced_chart_formatting.mp4 12.49 MB
05-Create_Advanced_Charts_and_Tables/01-Use_advanced_chart_formatting.srt 8.65 KB
05-Create_Advanced_Charts_and_Tables/02-Create_and_modify_PivotTables_and_filter_with_slicers.mp4 14.3 MB
05-Create_Advanced_Charts_and_Tables/02-Create_and_modify_PivotTables_and_filter_with_slicers.srt 8.94 KB
05-Create_Advanced_Charts_and_Tables/03-Format_PivotTables_and_use_GETPIVOTDATA.mp4 27.18 MB
05-Create_Advanced_Charts_and_Tables/03-Format_PivotTables_and_use_GETPIVOTDATA.srt 12.89 KB
05-Create_Advanced_Charts_and_Tables/04-Create_and_modify_PivotCharts.mp4 20.6 MB
05-Create_Advanced_Charts_and_Tables/04-Create_and_modify_PivotCharts.srt 10.91 KB
05-Create_Advanced_Charts_and_Tables/05-Challenge_Create_advanced_charts_and_tables.mp4 1.35 MB
05-Create_Advanced_Charts_and_Tables/05-Challenge_Create_advanced_charts_and_tables.srt 916 B
05-Create_Advanced_Charts_and_Tables/06-Solution_Create_advanced_charts_and_tables.mp4 19.55 MB
05-Create_Advanced_Charts_and_Tables/06-Solution_Create_advanced_charts_and_tables.srt 8.71 KB
06-Final_Challenge/01-Challenge_Full_length_MOS_Expert_sample_exam_for_Excel_2016.mp4 2.22 MB
06-Final_Challenge/01-Challenge_Full_length_MOS_Expert_sample_exam_for_Excel_2016.srt 1.58 KB
06-Final_Challenge/02-Solution_Full_length_MOS_Expert_sample_exam_for_Excel_2016.mp4 88.49 MB
06-Final_Challenge/02-Solution_Full_length_MOS_Expert_sample_exam_for_Excel_2016.srt 43.99 KB
07-Conclusion/Next steps-583084.en.srt 733 B
07-Conclusion/Next steps-583084.mp4 1.08 MB
Ex_Files_Excel2016_MOS_Cert_Prep.zip 6.22 MB
Download Info
-
Tips
“2017-Lynda.com-Cert_Prep_Excel_2016_Microsoft_Office_Expert_(77-728)-IVY” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.
-
DMCA Notice and Takedown Procedure
If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.