Use the powerful COUNTIF family—8 functions—for statistical analysis - Microsoft Excel Tutorial

Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.

• Exercise File: Subscribe to access. 164_Percent_change_and_Goal_Seek.zip
• Exercise File: Subscribe to access. Ex_Files_Excel_Tips_Weekly_2018_Q2.zip
• Exercise File: Subscribe to access. 166_COUNT_COUNTA_and_Status_Bar.zip
• Exercise File: Subscribe to access. 165_Fill_in_Blanks.zip
• Exercise File: Subscribe to access. Ex_Files_Excel_Tips_Weekly_2018_Q3.zip
• Exercise File: Subscribe to access. 162_Freeze_Panes_and_Split_Screens.zip
• Exercise File: Subscribe to access. 203_Mixed_Cell_Addresses.zip
• Exercise File: Subscribe to access. 202_Worksheet_Protection.zip
• Exercise File: Subscribe to access. 161_Custom_Lists.zip
• Exercise File: Subscribe to access. 201_Error_Checking_Indicators.zip
• Exercise File: Subscribe to access. 205_Displaying_Large_Values.zip
• Exercise File: Subscribe to access. 163_NETWORKDAYS_and_WORKDAY.zip
• Exercise File: Subscribe to access. 204_Filter_by_Selection.zip
• Exercise File: Subscribe to access. 160_Date_Format_Conversions.zip
• Exercise File: Subscribe to access. 159_Number_Formats.zip
• Exercise File: Subscribe to access. 200_Linking_Pictures.zip
• Exercise File: Subscribe to access. 199_Charts_and_Filters.zip
• Exercise File: Subscribe to access. 198_Weekdays_and_Weekends.zip
• Exercise File: Subscribe to access. 197_Helpful_Keystroke_Shortcuts.zip
• Exercise File: Subscribe to access. 157_Comments_and_Reminders.zip
• Exercise File: Subscribe to access. 156_Date_Time_Formats.zip
• Exercise File: Subscribe to access. 196_Double_and_Triple_Spaced_Printing.zip
• Exercise File: Subscribe to access. 195_TRIM_and_CLEAN.zip
• Exercise File: Subscribe to access. 194_LEN_and_REPT.zip
• Exercise File: Subscribe to access. 158_Replace_Format_or_Content.zip
• Exercise File: Subscribe to access. 155_Default_Chart_Type_and_Chart_Templates.zip
• Exercise File: Subscribe to access. 154_Phone_and_ZipCode_Formats.zip
• Exercise File: Subscribe to access. 192_PivotTable_Settings.zip
• Exercise File: Subscribe to access. 151_Chart_gridlines_and_borders.zip
• Exercise File: Subscribe to access. 150_Mixed_References.zip
• Exercise File: Subscribe to access. 153_Expand_Collapse_PivotTables.zip
• Exercise File: Subscribe to access. 190_Solver.zip
• Exercise File: Subscribe to access. 152_INDIRECT_Intersection_RangeNames.zip
• Exercise File: Subscribe to access. 191_Columns_Widths.zip
• Exercise File: Subscribe to access. 149_Decimals_and_Fractions.zip
• Exercise File: Subscribe to access. 194_Watch_Window.zip
• Exercise File: Subscribe to access. 189_Alt_Key_Shortcuts.zip
• Exercise File: Subscribe to access. 123_Book1.zip
• Exercise File: Subscribe to access. 186_Sort_by_Moving_Columns.zip
• Exercise File: Subscribe to access. 185_Unintentional_Entries.zip
• Exercise File: Subscribe to access. 188_CONVERT_Function.zip
• Exercise File: Subscribe to access. 187_Cumulative_Totals.zip
• Exercise File: Subscribe to access. 184_Date_Calculations.zip
• Exercise File: Subscribe to access. 124_Quick_Charts.zip
• Exercise File: Subscribe to access. 183_New_Table_Style.zip
• Exercise File: Subscribe to access. 180_Table_Differences.zip
• Exercise File: Subscribe to access. 179_Date_Proximity_Formatting_final.zip
• Exercise File: Subscribe to access. 182_FormattingOptions.zip
• Exercise File: Subscribe to access. 181_Avoiding_DIV_Error.zip
• Exercise File: Subscribe to access. 126_INDEX_Function.zip
• Exercise File: Subscribe to access. 127_Display_Tips.zip
• Exercise File: Subscribe to access. 128_Wrap_text_Merge_Indent.zip
• Exercise File: Subscribe to access. 129_Fill_Effects.zip
• Exercise File: Subscribe to access. 125_Heat_Maps.zip
• Exercise File: Subscribe to access. 134_Two_Way_Lookups.zip
• Exercise File: Subscribe to access. 178_Adjusting_Names.zip
• Exercise File: Subscribe to access. 130_Multiple_Worksheets.zip
• Exercise File: Subscribe to access. 131_Other_Font_Options.zip
• Exercise File: Subscribe to access. 132_WordArt_Variations.zip
• Exercise File: Subscribe to access. 133_Weekday_Weekend.zip
• Exercise File: Subscribe to access. 175_ROMAN_ARABIC.zip
• Exercise File: Subscribe to access. 174_EXACT_FIND_SEARCH_Functions.zip
• Exercise File: Subscribe to access. 177_Customize_the_Quick_Access_Toolbar.zip
• Exercise File: Subscribe to access. 176_Range_Names.zip
• Exercise File: Subscribe to access. 135_Borders_Gridlines.zip
• Exercise File: Subscribe to access. 173_YEAR_MONTH_DAY_WEEKDAY.zip
• Exercise File: Subscribe to access. 172_Abstract_Art_with_Random_Numbers_and_Excel_Charts.zip
• Exercise File: Subscribe to access. 189_Chart_based_on_a_Table.zip
• Exercise File: Subscribe to access. 169_PivotTable_Date_Grouping.zip
• Exercise File: Subscribe to access. 171_Zoom_and_Display_Variations.zip
• Exercise File: Subscribe to access. 170_Unique_and_Duplicate_Data.zip
• Exercise File: Subscribe to access. 168_Ranking_Data.zip
• Exercise File: Subscribe to access. 167_Excel_Sheet_Commands.zip
• Exercise File: Subscribe to access. Ex_Files_Excel_Tips_Weekly_2018_Q1.zip
• Exercise File: Subscribe to access. 206_ConditionalFormatting_and_DataValidation.zip
• Exercise File: Subscribe to access. 207_CheckBox_ConditionalFormatting.zip
• Exercise File: Subscribe to access. 208_Transpose.zip
• Exercise File: Subscribe to access. 209_Borders_Gridlines_Printing.zip
• Exercise File: Subscribe to access. 210_SmartArt.zip
• Exercise File: Subscribe to access. 211_GoTo_Special.zip
• Exercise File: Subscribe to access. 212_CEILINGandFLOOR.zip
• Exercise File: Subscribe to access. 213_Shapes_and_Stars.zip
• Exercise File: Subscribe to access. 214_Array_Constants_withVLOOKUP.zip
• Exercise File: Subscribe to access. 215_AdvancedFilter.zip
• Exercise File: Subscribe to access. 216_ArrayFormulaUpdates.zip
• Exercise File: Subscribe to access. 217_UNIQUE_function.zip
• Exercise File: Subscribe to access. 218_Sample_Data.zip
• Exercise File: Subscribe to access. 219_Utility_Macros.zip
• Exercise File: Subscribe to access. 220_SORT_and_SORTBY_Functions.zip
• Exercise File: Subscribe to access. 221_Themes.zip
• Exercise File: Subscribe to access. 222_Financial_Functions.zip
• Exercise File: Subscribe to access. 223_BlankCellsInCharts.zip
• Exercise File: Subscribe to access. 224_CondFormattingBreakpoints.zip
• Exercise File: Subscribe to access. 225_New_Formulas.zip
• Exercise File: Subscribe to access. 226_Sort_by_Color.zip
• Exercise File: Subscribe to access. 227_Special_Characters.zip
• Exercise File: Subscribe to access. 228_Icons.zip
• Exercise File: Subscribe to access. 229_Random_Functions.zip
• Exercise File: Subscribe to access. 230_Area_Charts.zip
• Exercise File: Subscribe to access. 231_People_Graph.zip
• Exercise File: Subscribe to access. 232_GrowingChart.zip
• Exercise File: Subscribe to access. 233_ScenarioManager.zip
• Exercise File: Subscribe to access. 234_Status_Bar.zip
• Exercise File: Subscribe to access. 235_Columns_and_Rows.zip
• Exercise File: Subscribe to access. 236_Dates_in_Charts.zip
• Exercise File: Subscribe to access. 237_Geographic_Maps.zip
• Exercise File: Subscribe to access. 238_Date_Time_Series.zip
• Exercise File: Subscribe to access. 239_Data_Validation_and_Filter.zip
• Exercise File: Subscribe to access. 240_Find_Select.zip
• Exercise File: Subscribe to access. 241_AverageCountSubscript.zip
• Exercise File: Subscribe to access. 242_CopyFormats.zip
• Exercise File: Subscribe to access. 243_XLOOKUP_Function.zip
• Exercise File: Subscribe to access. 244_PivotTable_Settings.zip
• Exercise File: Subscribe to access. 245_FilterYearDay.zip
• Exercise File: Subscribe to access. 246_Sheet_Names.zip
• Exercise File: Subscribe to access. 247_Phone_ZipFormats.zip
• Exercise File: Subscribe to access. 248_Time_Math.zip
• Exercise File: Subscribe to access. 249_Prevent_Locate_Duplicates.zip
• Exercise File: Subscribe to access. 250_EDate_EMonth_DatedIF.zip
• Exercise File: Subscribe to access. 251_Find_Highlight_Formula_cells.zip
• Exercise File: Subscribe to access. 252_Text_Columns_Flash_Fill.zip
• Exercise File: Subscribe to access. 253_Cumulative_Formulas.zip
• Exercise File: Subscribe to access. 254_XMATCH_Function.zip
• Exercise File: Subscribe to access. 255_Hidden_Visible_Data.zip
• Exercise File: Subscribe to access. 256_Macro_Highlight_Formula_Cells.zip
• Exercise File: Subscribe to access. 257_TODAY_NOW_Date_Functions.zip
• Exercise File: Subscribe to access. 258_Prevent_Duplicates.zip
• Exercise File: Subscribe to access. 259_Hide_cells_rows_columns_sheets.zip
• Exercise File: Subscribe to access. 260_Align_Arrange_Rotate_Shapes.zip
• Exercise File: Subscribe to access. 261_Worksheet_Statistics.zip
• Exercise File: Subscribe to access. 262_Re_scaling_Column_and_Line_Charts.zip
• Exercise File: Subscribe to access. 263_Fill_Justify_Wrap_Text.zip
• Exercise File: Subscribe to access. 264_Names_Based_On_Column_Row_Headings.zip
• Exercise File: Subscribe to access. 265_SUBSTITUTE_and_REPLACE_Functions.zip
• Exercise File: Subscribe to access. 266_Buttons_for_Conditional_Formatting.zip
• Exercise File: Subscribe to access. 267_Wildcards_Part_1_Filter_and_Commands.zip
• Exercise File: Subscribe to access. 268_Wildcards_Part_2_Functions_.zip
• Exercise File: Subscribe to access. 269_IFS_Function.zip
• Exercise File: Subscribe to access. 270_Chart_Formatting_Gap_Width_Shadow_Glow_3D.zip
• Exercise File: Subscribe to access. 271_Protect_Cell_Ranges.zip
• Exercise File: Subscribe to access. 272_Geography_Data.zip
• Exercise File: Subscribe to access. 273_SEQUENCE_function.zip
• Exercise File: Subscribe to access. 274_LEN_SUBSTITUTE_and_TRIM_functions.zip
• Exercise File: Subscribe to access. 275_List_Box.zip
• Exercise File: Subscribe to access. 276_COUNT_COUNTA_and_COUNTBLANK_functions.zip
• Exercise File: Subscribe to access. 277_Banded_Rows_or_Columns.zip
• Exercise File: Subscribe to access. 278_Dragging_cells_with_Ctrl_Shift_and_Alt_Keys.zip
• Exercise File: Subscribe to access. 279_SWITCH_function.zip
• Exercise File: Subscribe to access. 280_Chart_Design_Tools.zip
• Exercise File: Subscribe to access. 281_PivotTable_Analysis.zip
• Exercise File: Subscribe to access. 282_Subtotal.zip
• Exercise File: Subscribe to access. 283_AGGREGATE_Function.zip
• Exercise File: Subscribe to access. 284_The_F9_Key.zip
• Exercise File: Subscribe to access. 285_XLOOKUP_XMATCH.zip
• Exercise File: Subscribe to access. 286_Paste_Special_Options.zip
• Exercise File: Subscribe to access. 287_Data_Entry_Tips.zip
• Exercise File: Subscribe to access. 288_LET_function.zip
• Exercise File: Subscribe to access. 289_Create_Worksheets_Fast.zip
• Exercise File: Subscribe to access. 290_MovingAverage.zip
• Exercise File: Subscribe to access. 291_Error_Checking_Functions.zip
• Exercise File: Subscribe to access. 292_Line_Wrap_and_Wrap_Text.zip
• Exercise File: Subscribe to access. 293_Cell_Colors_Patterns_Effects.zip
• Exercise File: Subscribe to access. 294_Dynamic_Arrays.zip
• Exercise File: Subscribe to access. 295_Fonts.zip
• Exercise File: Subscribe to access. 296_3D_Formulas.zip
• Exercise File: Subscribe to access. 297_Date_Formats.zip
• Exercise File: Subscribe to access. 298_Cell_Precedents.zip
• Exercise File: Subscribe to access. 299_Date_Controls_with_Data_Validation.zip
• Exercise File: Subscribe to access. 300_Managing_Duplicate_Data.zip
• Exercise File: Subscribe to access. 301_New_Data_Types.zip
• Exercise File: Subscribe to access. 302_FILTER_and_UNIQUE_functions.zip
• Exercise File: Subscribe to access. 303_UPPER_lower_Proper.zip
• Exercise File: Subscribe to access. 304_Custom_Filter.zip
• Exercise File: Subscribe to access. 26_01_Column_and_Bar_Charts.zip
• Exercise File: Subscribe to access. 26_02_Powers_and_Roots.zip
• Exercise File: Subscribe to access. 26_03_ISTEXT_ISNUMBER_ISNONTEXT.zip
• Exercise File: Subscribe to access. 26_04_Function_Names.zip
• Exercise File: Subscribe to access. 26_05_SUM_SUMPRODUCT_SUMIF.zip
• Exercise File: Subscribe to access. 26_06_Binary_Octal_Decimal_Hexadecimal.zip
• Exercise File: Subscribe to access. 26_07_Numeric_Formatting.zip
• Exercise File: Subscribe to access. 26_08_Dates_and_the_1930_2029_split.zip
• Exercise File: Subscribe to access. 26_09_Wildcard_lookups_XLOOKUP_and_XMATCH.zip
• Exercise File: Subscribe to access. 26_10_Slicers_Analysis.zip
• Exercise File: Subscribe to access. 26_11_Heat_Maps.zip
• Exercise File: Subscribe to access. 26_12_Validation_with_UNIQUE_and_SORT_functions.zip
• Exercise File: Subscribe to access. 26_13_Clustered_vs_Stacked_Chart_Types.zip
• Exercise File: Subscribe to access. 27_01_XLOOKUP.zip
• Exercise File: Subscribe to access. 27_02_Update_Date_Entries.zip
• Exercise File: Subscribe to access. 27_03_Eliminate_Spaces_and_Special_Characters.zip
• Exercise File: Subscribe to access. 27_04_Create_Range_Names_From_Headings.zip
• Exercise File: Subscribe to access. 27_05_Date_Series_Creation.zip
• Exercise File: Subscribe to access. 27_06_LAMBDA_Function.zip
• Exercise File: Subscribe to access. 27_07_Goal_Seek.zip
• Exercise File: Subscribe to access. 27_08_Sort_by_Custom_List.zip
• Exercise File: Subscribe to access. 27_09_INDIRECT_function.zip
• Exercise File: Subscribe to access. 27_10_Holiday_Calculations.zip
• Exercise File: Subscribe to access. 27_11_Paste_Special_Drag_Options.zip
• Exercise File: Subscribe to access. 27_12_SS_Numbers.zip
• Exercise File: Subscribe to access. 28_01_Five_Invaluable_Keystroke_Shortcuts.zip
• Exercise File: Subscribe to access. 28_02_New_Formula_Techniques.zip
• Exercise File: Subscribe to access. 28_03_Time_differencees.zip
• Exercise File: Subscribe to access. 28_04_Zoom_Techniques.zip
• Exercise File: Subscribe to access. 28_05_Outlining_Tools.zip
• Exercise File: Subscribe to access. 28_06_Analyze_Data.zip
• Exercise File: Subscribe to access. 28_07_UNIQUE_Unique_vs_Distinct.zip
• Exercise File: Subscribe to access. 28_08_Screen_Snip.zip
• Exercise File: Subscribe to access. 28_09_Sunburst_Charts.zip
• Exercise File: Subscribe to access. 28_10_Shadow_Glow_Reflection.zip
• Exercise File: Subscribe to access. 28_11_Printing_Tips.zip
• Exercise File: Subscribe to access. 29_01_Data_Validation_Multiple_Criteria.zip
• Exercise File: Subscribe to access. 29_02_Quick_Access_Toolbar_QAT_Tips.zip
• Exercise File: Subscribe to access. 29_03_Treemap_Charts.zip
• Exercise File: Subscribe to access. 29_04_Quick_Analysis_Button.zip
• Exercise File: Subscribe to access. 29_05_Dragging_Number_Cells.zip
• Exercise File: Subscribe to access. 29_06_Analyze_Sales_using_the_IF_MAX_and_COUNTIF_functions.zip
• Exercise File: Subscribe to access. 29_07_Hide_Unhide_Worksheets.zip
• Exercise File: Subscribe to access. 29_08_Fill_Justify_Re_wrap_text.zip
• Exercise File: Subscribe to access. 29_09_Date_Series_15th_and_Month_End.zip
• Exercise File: Subscribe to access. 29_10_Filling_Blank_Cells.zip
• Exercise File: Subscribe to access. 29_11_Sparklines_and_Conditional_Formatting.zip
• Exercise File: Subscribe to access. 29_12_Transpose.zip
• Exercise File: Subscribe to access. 30_01_Emojis_and_Pictures.zip
• Exercise File: Subscribe to access. 30_02_Advanced_Filter.zip
• Exercise File: Subscribe to access. 30_03_Combo_Charts.zip
• Exercise File: Subscribe to access. 30_04_MID_SEQUENCE_LEN_Functions.zip
• Exercise File: Subscribe to access. 30_05_PivotTable_Settings.zip
• Exercise File: Subscribe to access. 30_06_Navigation.zip
• Exercise File: Subscribe to access. 30_07_DATEDIF_Function.zip
• Exercise File: Subscribe to access. 30_08_Word_Art_Transform.zip
• Exercise File: Subscribe to access. 30_09_Dates_Months_Weekdays.zip
• Exercise File: Subscribe to access. 30_10_Linkage_Formulas.zip
• Exercise File: Subscribe to access. 30_11_XLOOKUP_Solutions.zip
• Exercise File: Subscribe to access. 30_12_TREND_and_GROWTH.zip
• Exercise File: Subscribe to access. 30_13_Stock_Charts.zip
• Exercise File: Subscribe to access. 31_01_Gridlines_On_Off.zip
• Exercise File: Subscribe to access. 31_02_Formulas_Changes.zip
• Exercise File: Subscribe to access. 31_03_Dependencies.zip
• Exercise File: Subscribe to access. 31_04_Replace_Formats.zip
• Exercise File: Subscribe to access. 31_05_Option_Buttons_and_Check_Boxes.zip
• Exercise File: Subscribe to access. 31_06_SORT_and_FILTER_Functions.zip
• Exercise File: Subscribe to access. 31_07_Moving_Average.zip
• Exercise File: Subscribe to access. 31_08_Data_Validation.zip
• Exercise File: Subscribe to access. 31_09_Picture_Links.zip
• Exercise File: Subscribe to access. 31_10_SUMIF_and_SUMIFS.zip
• Exercise File: Subscribe to access. 31_11_Multiple_PivotTables_from_one_source.zip
• Exercise File: Subscribe to access. 31_12_Conditional_Formatting_Icons.zip
• Exercise File: Subscribe to access. IMAGE_Function.zip
• Exercise File: Subscribe to access. 378_TOROW_and_TOCOL_functions.zip
• Exercise File: Subscribe to access. 379_Formulas_with_hidden_rows.zip
• Exercise File: Subscribe to access. 380_Bubble_charts.zip
• Exercise File: Subscribe to access. 381_CONCAT_TEXTJOIN_TEXTSPLIT_functions.zip
• Exercise File: Subscribe to access. 382_Shrink_to_fit_options.zip
• Exercise File: Subscribe to access. 383_Precedent_Cells.zip
• Exercise File: Subscribe to access. 384_Formula_editing.zip
• Exercise File: Subscribe to access. 385_Status_Bar_Control.zip
• Exercise File: Subscribe to access. 386_Sorting_Tips.zip
• Exercise File: Subscribe to access. 387_TEXTBEFORE_TEXTAFTER.zip
• Exercise File: Subscribe to access. 388_Quick_Chart_Titles.zip
• Exercise File: Subscribe to access. 390_TAKE_DROP_FILTER_SORTBY.zip
• Exercise File: Subscribe to access. 391_Pivot_Table_Detail.zip
• Exercise File: Subscribe to access. 392_Right_click_Filtering.zip
• Exercise File: Subscribe to access. 393_WRAPROWS_and_WRAPCOLS_Functions.zip
• Exercise File: Subscribe to access. 394_Dates_and_Times.zip
• Exercise File: Subscribe to access. 395_Creating_Charts_Quickly.zip
• Exercise File: Subscribe to access. 396_CHOOSEROWS_and_CHOOSECOLS_Functions.zip
• Exercise File: Subscribe to access. 397_Decimals_Rounding_Formulas.zip
• Exercise File: Subscribe to access. 398_Pivot_Table_Formatting.zip
• Exercise File: Subscribe to access. 399_DB_Functions.zip
• Exercise File: Subscribe to access. 400_Pie_Charts.zip
• Exercise File: Subscribe to access. 401_Quick_Sorting.zip
• Exercise File: Subscribe to access. 402_Charts_to_Pictures.zip
• Exercise File: Subscribe to access. 402_Tracking_Cell_Types.zip
• Exercise File: Subscribe to access. 403_BYROW_and_BYCOL_Functions.zip
• Exercise File: Subscribe to access. 404_Formula_Shortcuts.zip
• Exercise File: Subscribe to access. 405_3_D_Column_and_Bar_Chart.zip
• Exercise File: Subscribe to access. 406 _VSTACK_and_HSTACK_functions.zip
• Exercise File: Subscribe to access. 407_Calculating_by_Day_of_the_Week.zip
• Exercise File: Subscribe to access. 408_XMATCH_and_XLOOKUP.zip
• Exercise File: Subscribe to access. 409_Select_Cell_Ranges.zip
• Exercise File: Subscribe to access. 410_Inserting_Symbols.zip
• Exercise File: Subscribe to access. 411_Using_IS_Information_functions.zip
• Exercise File: Subscribe to access. 412_Using_LEFT_MID_TEXT_functions.zip
• Exercise File: Subscribe to access. 413_Edit_Go_To_Options.zip
• Exercise File: Subscribe to access. 414_Fiscal_Year_Calculations.zip
• Exercise File: Subscribe to access. 415_SORT_Left_Right.zip
• Exercise File: Subscribe to access. 416_Conditional_Formatting_Analysis.zip
• Exercise File: Subscribe to access. 417_Indenting.zip
• Exercise File: Subscribe to access. 418_FILTER_AND_OR_Functions.zip
• Exercise File: Subscribe to access. 419_Shapes_Linked_to_Worksheet_Cells.zip
• Exercise File: Subscribe to access. 420_Slicers_with_Charts.zip
• Exercise File: Subscribe to access. 421_Sort_by_Day_of_Month.zip
• Exercise File: Subscribe to access. 422_Wildcards.zip
• Exercise File: Subscribe to access. 423_FIND_SEARCH_COUNT_Functions.zip
• Exercise File: Subscribe to access. 424_Histogram_Charts.zip
• Exercise File: Subscribe to access. 425_AND_and_OR_Functions.zip
• Exercise File: Subscribe to access. 426_Flipping_Lists.zip
• Exercise File: Subscribe to access. 427_TEXTJOIN_CONCAT.zip
• Exercise File: Subscribe to access. 428_Excel_Options.zip
• Exercise File: Subscribe to access. 429_Alt_key_shortcuts.zip
• Exercise File: Subscribe to access. 430_COUNTIF_family.zip
• Exercise File: Subscribe to access. 431_Scatter_XY_Charts.zip