2017 Lynda com Cert Prep Excel 2016 Microsoft Office Expert 77 728 IVY

2017 Lynda com Cert Prep Excel 2016 Microsoft Office Expert 77 728 IVY

Name	2017-Lynda.com-Cert_Prep_Excel_2016_Microsoft_Office_Expert_(77-728)-IVY	DOWNLOAD Copy Link
Total Size	556.7 MB
Total Files	79
Hash	6C826ACC98CE72A8C48E2754F9BF47ACC9C78A72

/00-Introduction/
01-Welcome.mp4	12.5 MB
01-Welcome.srt	2.4 KB
02-What_to_know_before_watching_this_course.mp4	833.5 KB
02-What_to_know_before_watching_this_course.srt	0.7 KB
03-Using_the_exercise_files.mp4	2.1 MB
03-Using_the_exercise_files.srt	1.2 KB
04-Using_the_challenge_files.mp4	1.1 MB
04-Using_the_challenge_files.srt	1.0 KB
/01-Microsoft_Office_Specialist_(MOS)_Expert_Exam_Overview/
01-Understand_the_different_kinds_of_Microsoft_Office_Specialist_certifications.mp4	4.2 MB
01-Understand_the_different_kinds_of_Microsoft_Office_Specialist_certifications.srt	2.9 KB
02-Prepare_for_the_test.mp4	4.9 MB
02-Prepare_for_the_test.srt	5.0 KB
03-Overview_of_the_2016_MOS_Expert_exam_format_and_learning_objectives.mp4	6.1 MB
03-Overview_of_the_2016_MOS_Expert_exam_format_and_learning_objectives.srt	5.8 KB
/02-Manage_Workbook_Options_and_Settings/
01-Manage_workbooks.mp4	13.2 MB
01-Manage_workbooks.srt	8.0 KB
02-Reference_data_in_another_workbook.mp4	14.3 MB
02-Reference_data_in_another_workbook.srt	7.7 KB
03-Reference_data_using_structured_references.mp4	11.1 MB
03-Reference_data_using_structured_references.srt	7.2 KB
04-Protect_worksheets_and_workbooks.mp4	15.8 MB
04-Protect_worksheets_and_workbooks.srt	8.8 KB
05-Challenge_Manage_workbook_options_and_settings.mp4	4.7 MB
05-Challenge_Manage_workbook_options_and_settings.srt	3.0 KB
06-Solution_Manage_workbook_options_and_setting.mp4	21.5 MB
06-Solution_Manage_workbook_options_and_setting.srt	12.1 KB
/03-Apply_Custom_Data_Formats_and_Layouts/
01-Create_custom_formats_(number_time_and_date).mp4	16.2 MB
01-Create_custom_formats_(number_time_and_date).srt	8.3 KB
02-Populate_cells_by_using_advanced_Fill_Series_options.mp4	8.6 MB
02-Populate_cells_by_using_advanced_Fill_Series_options.srt	5.2 KB
03-Create_custom_conditional_formatting_rules_using_formulas.mp4	16.4 MB
03-Create_custom_conditional_formatting_rules_using_formulas.srt	8.2 KB
04-Manage_conditional_formatting_rules.mp4	12.1 MB
04-Manage_conditional_formatting_rules.srt	6.1 KB
05-Create_custom_styles_and_themes.mp4	23.3 MB
05-Create_custom_styles_and_themes.srt	13.2 KB
06-Insert_and_configure_form_controls.mp4	14.9 MB
06-Insert_and_configure_form_controls.srt	9.6 KB
07-Challenge_Apply_custom_data_formats_and_layouts.mp4	1.4 MB
07-Challenge_Apply_custom_data_formats_and_layouts.srt	0.9 KB
08-Solution_Apply_custom_data_formats_and_layouts.mp4	27.4 MB
08-Solution_Apply_custom_data_formats_and_layouts.srt	13.1 KB
/04-Create_Advanced_Formulas/
01-Use_AND_OR_functions.mp4	15.8 MB
01-Use_AND_OR_functions.srt	9.8 KB
02-Use_IFS_functions.srt	9.0 KB
03-Use_the_LOOKUP_function.srt	11.2 KB
04-Use_the_MATCH_and_INDEX_functions.mp4	13.6 MB
04-Use_the_MATCH_and_INDEX_functions.srt	7.9 KB
05-Use_date_and_time_functions.mp4	17.2 MB
05-Use_date_and_time_functions.srt	9.8 KB
06-Troubleshoot_formulas.mp4	18.3 MB
06-Troubleshoot_formulas.srt	10.7 KB
07-Use_What_If_Analysis.mp4	13.5 MB
07-Use_What_If_Analysis.srt	8.9 KB
08-Define_named_ranges_and_objects.mp4	18.8 MB
08-Define_named_ranges_and_objects.srt	10.3 KB
09-Challenge_Create_advanced_formulas.mp4	1.4 MB
09-Challenge_Create_advanced_formulas.srt	0.9 KB
10-Solution_Create_advanced_formulas.mp4	22.2 MB
10-Solution_Create_advanced_formulas.srt	11.1 KB
/05-Create_Advanced_Charts_and_Tables/
01-Use_advanced_chart_formatting.mp4	13.1 MB
01-Use_advanced_chart_formatting.srt	8.9 KB
02-Create_and_modify_PivotTables_and_filter_with_slicers.mp4	15.0 MB
02-Create_and_modify_PivotTables_and_filter_with_slicers.srt	9.2 KB
03-Format_PivotTables_and_use_GETPIVOTDATA.mp4	28.5 MB
03-Format_PivotTables_and_use_GETPIVOTDATA.srt	13.2 KB
04-Create_and_modify_PivotCharts.mp4	21.6 MB
04-Create_and_modify_PivotCharts.srt	11.2 KB
05-Challenge_Create_advanced_charts_and_tables.mp4	1.4 MB
05-Challenge_Create_advanced_charts_and_tables.srt	0.9 KB
06-Solution_Create_advanced_charts_and_tables.mp4	20.5 MB
06-Solution_Create_advanced_charts_and_tables.srt	8.9 KB
/06-Final_Challenge/
01-Challenge_Full_length_MOS_Expert_sample_exam_for_Excel_2016.mp4	2.3 MB
01-Challenge_Full_length_MOS_Expert_sample_exam_for_Excel_2016.srt	1.6 KB
02-Solution_Full_length_MOS_Expert_sample_exam_for_Excel_2016.mp4	92.8 MB
02-Solution_Full_length_MOS_Expert_sample_exam_for_Excel_2016.srt	45.0 KB
/07-Conclusion/
Next steps-583084.en.srt	0.7 KB
Next steps-583084.mp4	1.1 MB
/
Ex_Files_Excel2016_MOS_Cert_Prep.zip	6.5 MB
Total files 79