Packt The Microsoft Excel Data Analysis Toolkit Bundl-XQZT

Another exquisit release
Packt.The.Microsoft.Excel.Data.Analysis.Toolkit.Bundl-XQZT
     Title: The Microsoft Excel Data Analysis Toolkit Bundl
 Publisher: Packt
  Category: Data
      Size: 5968M
     Files: 10F
      Date: 2021-07-30
  Course #: 9781803239262
 Published: Packt
   Updated: N/A
       URL: https://www.packtpub.com/video/data/9781803239262
    Author: Simon Sez IT
  Duration: 24 hours 59 minutes
 Exer/Code: [X]
Installation:
Unpack that shit, run that shit
Description:
A complete guide to the Microsoft Excel data analysis

22M	01.01-introduction.mkv
50M	02.01-a_recap_of_basic_formulas.mkv
33M	02.02-absolute_versus_relative_referencing.mkv
8.2M	02.03-exercise_01.mkv
12M	03.01-merging_data_from_different_sources.mkv
43M	03.02-looking_up_information_with_vlookup_(exact).mkv
26M	03.03-looking_up_information_with_vlookup_(approx.).mkv
40M	03.04-how_to_use_vlookup_with_data_that_expands.mkv
49M	03.05-using_hlookup.mkv
49M	03.06-combining_vlookup_and_match.mkv
69M	03.07-using_index_match_and_xlookup.mkv
34M	03.08-data_validation_lists_with_lookups.mkv
26M	03.09-exercise_02.mkv
22M	04.01-how_to_use_the_if_function.mkv
29M	04.02-more_examples_of_the_if_function.mkv
26M	04.03-working_with_nested_ifs.mkv
35M	04.04-the_ifs_function.mkv
37M	04.05-error_handling_with_iferror_and_ifna.mkv
45M	04.06-using_max_and_min_instead_of_the_if_function.mkv
47M	04.07-using_sumifs_and_countifs.mkv
6.1M	04.08-exercise_03.mkv
64M	05.01-splitting_data_using_text_functions.mkv
19M	05.02-using_the_flash_fill_command.mkv
36M	05.03-concatenating_data.mkv
36M	05.04-standardizing_data.mkv
39M	05.05-formatting_data_as_a_table.mkv
9.8M	05.06-exercise_04.mkv
13M	06.01-an_introduction_to_pivottables.mkv
50M	06.02-creating_a_pivottable.mkv
54M	06.03-summarizing_data.mkv
60M	06.04-calculations_in_pivottables.mkv
39M	06.05-using_slicers_to_filter_information.mkv
7.4M	06.06-exercise_05.mkv
42M	07.01-creating_a_pivot_chart.mkv
57M	07.02-formatting_a_pivot_chart.mkv
31M	07.03-using_sparklines.mkv
58M	07.04-a_basic_interactive_dashboard.mkv
12M	07.05-exercise_06.mkv
29M	08.01-forecast_sheets.mkv
30M	08.02-the_forecast_function.mkv
6.3M	08.03-exercise_07.mkv
45M	09.01-conditional_formatting.mkv
53M	09.02-the_indirect_function.mkv
42M	09.03-the_offset_function.mkv
20M	09.04-using_histograms.mkv
27M	09.05-regression.mkv
8.8M	09.06-exercise_08.mkv
31M	10.01-goal_seek.mkv
32M	10.02-scenario_manager.mkv
29M	10.03-data_tables.mkv
27M	10.04-solver.mkv
6.8M	10.05-exercise_09.mkv
2.9M	11.01-summary.mkv
27M	12.01-introduction_to_the_advanced_excel_2019.mkv
18M	12.02-advanced_excel_2019_learning_structure.mkv
57M	13.01-functions-part_1.mkv
34M	13.02-functions-part_2.mkv
25M	13.03-autosum.mkv
44M	14.01-how_date_and_time_works.mkv
39M	14.02-basic_date_and_time_functions.mkv
42M	14.03-complex_date_and_time_functions.mkv
49M	15.01-using_text_functions-part_1.mkv
48M	15.02-using_text_functions-part_2.mkv
39M	16.01-logical_functions.mkv
8.9M	16.02-exercise_01.mkv
56M	17.01-lookup_functions-part_1.mkv
32M	17.02-lookup_functions-part_2.mkv
23M	17.03-exercise_02.mkv
37M	18.01-financial_functions_and_terminology.mkv
37M	18.02-personal_financial_functions.mkv
30M	18.03-principal_and_interest_payments.mkv
21M	18.04-depreciation.mkv
6.6M	18.05-exercise_03.mkv
54M	19.01-statistical_functions_for_description-part_1.mkv
54M	19.02-statistical_functions_for_description-part_2.mkv
47M	19.03-statistical_functions_for_forecasting-part_1.mkv
47M	19.04-statistical_functions_for_forecasting-part_2.mkv
7.4M	19.05-exercise_04.mkv
36M	19.06-one_click_forecasting.mkv
44M	19.07-statistical_functions_for_inference.mkv
52M	20.01-connecting_to_other_workbooks.mkv
51M	20.02-connecting_to_access_databases.mkv
31M	20.03-connecting_web_data_sources.mkv
57M	20.04-get_and_transform.mkv
21M	20.05-exercise_05.mkv
48M	21.01-introduction_to_tables.mkv
42M	21.02-working_with_tables.mkv
34M	21.03-table_references.mkv
22M	21.04-table_styles.mkv
5.9M	21.05-exercise_6.mkv
40M	22.01-introduction_to_pivot_tables.mkv
51M	22.02-working_with_pivot_tables.mkv
50M	22.03-filters_and_slicers.mkv
34M	22.04-pivot_and_charts.mkv
9.9M	22.05-exercise_07.mkv
41M	23.01-what_if_analysis.mkv
45M	23.02-scenario_manager.mkv
31M	23.03-goal_seek.mkv
48M	23.04-solver.mkv
7.2M	23.05-exercise_08.mkv
27M	24.01-area_charts.mkv
19M	24.02-surface_charts.mkv
22M	24.03-radar_charts.mkv
31M	24.04-bubble_charts.mkv
38M	24.05-sparklines.mkv
36M	24.06-stock_charts.mkv
14M	24.07-exercise_9.mkv
40M	25.01-web_app-part_1.mkv
40M	25.02-web_app-part_2.mkv
3.4M	26.01-summary.mkv
16M	27.01-introduction_to_advanced_pivottables.mkv
50M	27.02-pivottables_recap.mkv
40M	28.01-importing_data_from_a_text_file.mkv
33M	28.02-importing_data_from_access.mkv
19M	28.03-exercise_01.mkv
70M	29.01-cleaning_data.mkv
63M	29.02-tabular_data.mkv
14M	29.03-exercise_02.mkv
50M	30.01-creating_and_manipulating_a_pivottable.mkv
48M	30.02-combining_data_from_multiple_worksheets.mkv
44M	30.03-grouping_and_ungrouping.mkv
43M	30.04-report_layouts.mkv
34M	30.05-formatting_error_values_and_empty_cells.mkv
6.4M	30.06-exercise_03.mkv
46M	31.01-pivottable_styles.mkv
65M	31.02-custom_number_formatting.mkv
7.0M	31.03-exercise_04.mkv
45M	32.01-summarizing_values.mkv
36M	32.02-show_values_as.mkv
7.2M	32.03-exercise_05.mkv
35M	33.01-advanced_sorting.mkv
56M	33.02-advanced_filtering.mkv
9.2M	33.03-exercise_06.mkv
55M	34.01-inserting_and_formatting_slicers.mkv
29M	34.02-inserting_and_formatting_timelines.mkv
32M	34.03-connecting_slicers_to_multiple_pivottables.mkv
22M	34.04-using_slicers_in_protected_workbooks.mkv
9.3M	34.05-exercise_07.mkv
34M	35.01-creating_a_calculated_field.mkv
33M	35.02-creating_a_calculated_item.mkv
42M	35.03-solve_order_and_list_formulas.mkv
37M	35.04-getpivotdata.mkv
27M	35.05-exercise_08.mkv
46M	36.01-creating_a_pivot_chart.mkv
62M	36.02-formatting_a_pivot_chart-part_1.mkv
61M	36.03-formatting_a_pivot_chart-part_2.mkv
48M	36.04-creating_a_map_chart_using_pivot_data.mkv
55M	36.05-dynamic_chart_titles.mkv
42M	36.06-include_a_sparkline_with_your_pivottable.mkv
31M	36.07-exercise_09.mkv
38M	37.01-highlighting_cell_rules.mkv
40M	37.02-graphical_conditional_formats.mkv
26M	37.03-conditional_formatting_and_slicers.mkv
9.7M	37.04-exercise_10.mkv
91M	38.01-creating_an_interactive_dashboard-part_1.mkv
55M	38.02-creating_an_interactive_dashboard-part_2.mkv
18M	38.03-updating_pivot_charts_and_pivottables.mkv
14M	38.04-exercise_11.mkv
2.5M	39.01-summary.mkv
29M	40.01-introduction.mkv
30M	41.01-filter_a_dataset_using_a_formula.mkv
51M	41.02-sort_a_dataset_using_a_formula_and_defined_variables.mkv
41M	41.03-multiple_dependent_dynamic_drop-down_lists.mkv
45M	41.04-perform_a_2-way_lookup.mkv
65M	41.05-make_decisions_with_complex_logical_calculations.mkv
62M	41.06-extracting_parts_of_a_text_string.mkv
53M	41.07-creating_a_dynamic_chart_title.mkv
54M	41.08-finding_the_last_occurrence_of_a_value_in_a_list.mkv
43M	41.09-looking_up_information_with_xlookup.mkv
31M	41.10-find_the_st_match_to_a_value.mkv
5.3M	42.01-summary.mkv
59M	9781803239262_Code.zip
5.9G	total