|
Обратите внимание, что наш сайт не размещает какие-либо файлы из списка. Вы не можете скачать
эти файлы или скачать torrent-файл.
|
| 001 - Hide and unhide worksheets securely.mp4 |
17.01Мб |
| 001 - Hide and unhide worksheets securely.srt |
12.48Кб |
| 002 - Resizing, moving, copying, and manipulating charts and other objects.mp4 |
27.85Мб |
| 002 - Resizing, moving, copying, and manipulating charts and other objects.srt |
19.02Кб |
| 003 - Using list boxes and combo boxes to facilitate forms creation.mp4 |
21.48Мб |
| 003 - Using list boxes and combo boxes to facilitate forms creation.srt |
14.51Кб |
| 004 - Using the FORMULATEXT and N functions for worksheet and formula documentation.mp4 |
16.40Мб |
| 004 - Using the FORMULATEXT and N functions for worksheet and formula documentation.srt |
10.70Кб |
| 005 - Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells.mp4 |
23.75Мб |
| 005 - Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells.srt |
14.70Кб |
| 006 - Summarizing data from diverse ranges with Data - Consolidate.mp4 |
29.40Мб |
| 006 - Summarizing data from diverse ranges with Data - Consolidate.srt |
17.99Кб |
| 007 - Using check boxes and conditional formatting together for dynamic displays.mp4 |
40.45Мб |
| 007 - Using check boxes and conditional formatting together for dynamic displays.srt |
22.81Кб |
| 008 - Becoming more productive with these 10 tiny tips you'll use often.mp4 |
24.10Мб |
| 008 - Becoming more productive with these 10 tiny tips you'll use often.srt |
16.33Кб |
| 009 - Transposing data and charts for a different perspective on your data.mp4 |
30.30Мб |
| 009 - Transposing data and charts for a different perspective on your data.srt |
16.85Кб |
| 010 - Applying conditional formatting across rows of data.mp4 |
20.45Мб |
| 010 - Applying conditional formatting across rows of data.srt |
12.20Кб |
| 011 - Exploring various layouts for your PivotTable.mp4 |
13.86Мб |
| 011 - Exploring various layouts for your PivotTable.srt |
8.42Кб |
| 012 - Splitting and consolidating workbooks.mp4 |
20.53Мб |
| 012 - Splitting and consolidating workbooks.srt |
12.99Кб |
| 013 - Using date and time as metrics in a PivotTable.mp4 |
23.20Мб |
| 013 - Using date and time as metrics in a PivotTable.srt |
13.42Кб |
| 014 - Adding illustrations to your workbook.mp4 |
33.62Мб |
| 014 - Adding illustrations to your workbook.srt |
22.95Кб |
| 015 - Using a pick list, VLOOKUP, table, and chart together.mp4 |
22.57Мб |
| 015 - Using a pick list, VLOOKUP, table, and chart together.srt |
16.10Кб |
| 016 - Using formulas to calculate values across worksheets and workbooks.mp4 |
29.52Мб |
| 016 - Using formulas to calculate values across worksheets and workbooks.srt |
22.49Кб |
| 017 - Dynamically presenting data via chart slicers.mp4 |
20.42Мб |
| 017 - Dynamically presenting data via chart slicers.srt |
14.46Кб |
| 018 - Parsing your data to create unique lists.mp4 |
14.51Мб |
| 018 - Parsing your data to create unique lists.srt |
6.56Кб |
| 019 - Using the REPT function to represent data visually.mp4 |
8.82Мб |
| 019 - Using the REPT function to represent data visually.srt |
5.91Кб |
| 020 - Using source data from a table to make your PivotTable more dynamic.mp4 |
24.96Мб |
| 020 - Using source data from a table to make your PivotTable more dynamic.srt |
14.59Кб |
| 021 - Accelerating Cut, Copy, Paste, and Insert tasks.mp4 |
23.25Мб |
| 021 - Accelerating Cut, Copy, Paste, and Insert tasks.srt |
15.14Кб |
| 022 - Increasing your productivity with custom lists.mp4 |
20.89Мб |
| 022 - Increasing your productivity with custom lists.srt |
9.44Кб |
| 023 - Highlighting PivotTable results with conditional formatting.mp4 |
19.23Мб |
| 023 - Highlighting PivotTable results with conditional formatting.srt |
11.73Кб |
| 024 - Customizing templates to fit your unique needs.mp4 |
20.37Мб |
| 024 - Customizing templates to fit your unique needs.srt |
12.29Кб |
| 025 - Creating dynamic charts with in-cell conditional formatting.mp4 |
11.49Мб |
| 025 - Creating dynamic charts with in-cell conditional formatting.srt |
6.44Кб |
| 026 - Enhancing table filtering with slicers.mp4 |
20.19Мб |
| 026 - Enhancing table filtering with slicers.srt |
10.24Кб |
| 027 - Converting charts into pictures.mp4 |
15.93Мб |
| 027 - Converting charts into pictures.srt |
8.97Кб |
| 028 - Custom grouping in PivotTables.mp4 |
12.99Мб |
| 028 - Custom grouping in PivotTables.srt |
8.71Кб |
| 029 - Quick formatting tips.mp4 |
23.40Мб |
| 029 - Quick formatting tips.srt |
14.94Кб |
| 030 - The top five unknown but useful keyboard shortcuts.mp4 |
25.61Мб |
| 030 - The top five unknown but useful keyboard shortcuts.srt |
11.77Кб |
| 031 - Using the TREND and GROWTH functions for projecting future results.mp4 |
21.61Мб |
| 031 - Using the TREND and GROWTH functions for projecting future results.srt |
10.09Кб |
| 032 - Using scroll bars and spin buttons to facilitate forms creation.mp4 |
23.56Мб |
| 032 - Using scroll bars and spin buttons to facilitate forms creation.srt |
18.70Кб |
| 033 - Creating colorful 3D buttons for worksheet annotation and macro buttons.mp4 |
21.88Мб |
| 033 - Creating colorful 3D buttons for worksheet annotation and macro buttons.srt |
12.10Кб |
| 034 - Calculating with hours, minutes, and times of day.mp4 |
29.66Мб |
| 034 - Calculating with hours, minutes, and times of day.srt |
18.48Кб |
| 035 - Tracking down cell dependencies across multiple worksheets and workbooks.mp4 |
21.74Мб |
| 035 - Tracking down cell dependencies across multiple worksheets and workbooks.srt |
11.21Кб |
| 036 - Discovering time-saving tools in the Go To Special feature.mp4 |
40.04Мб |
| 036 - Discovering time-saving tools in the Go To Special feature.srt |
20.64Кб |
| 037 - Adding, managing, and printing comments for worksheet documentation.mp4 |
19.26Мб |
| 037 - Adding, managing, and printing comments for worksheet documentation.srt |
13.86Кб |
| 038 - Reducing data entry time by expanding AutoCorrect options.mp4 |
18.99Мб |
| 038 - Reducing data entry time by expanding AutoCorrect options.srt |
11.21Кб |
| 039 - Setting up custom views for quick access to different worksheet displays.mp4 |
25.08Мб |
| 039 - Setting up custom views for quick access to different worksheet displays.srt |
11.34Кб |
| 040 - Using hyperlinks for rapidly switching worksheet locations and jumping to websites.mp4 |
21.15Мб |
| 040 - Using hyperlinks for rapidly switching worksheet locations and jumping to websites.srt |
13.71Кб |
| 041 - Controlling worksheet security by allowing selected users to edit specific cell ranges.mp4 |
24.18Мб |
| 041 - Controlling worksheet security by allowing selected users to edit specific cell ranges.srt |
12.97Кб |
| 042 - Using option buttons, group boxes, and checkboxes to facilitate forms creation.mp4 |
19.93Мб |
| 042 - Using option buttons, group boxes, and checkboxes to facilitate forms creation.srt |
14.49Кб |
| 043 - Exploring what-if scenarios using Goal Seek.mp4 |
28.04Мб |
| 043 - Exploring what-if scenarios using Goal Seek.srt |
16.22Кб |
| 044 - Creating text, numerical, date, and time lists in a flash.mp4 |
17.89Мб |
| 044 - Creating text, numerical, date, and time lists in a flash.srt |
12.40Кб |
| 045 - Creating variable conditional formatting rules.mp4 |
30.80Мб |
| 045 - Creating variable conditional formatting rules.srt |
14.47Кб |
| 046 - Handling dates with unusual formats.mp4 |
20.25Мб |
| 046 - Handling dates with unusual formats.srt |
10.98Кб |
| 047 - Using wildcards (asterisk, tilde, and question mark).mp4 |
38.13Мб |
| 047 - Using wildcards (asterisk, tilde, and question mark).srt |
17.52Кб |
| 048 - Custom formats using asterisk, semicolon, and brackets.mp4 |
39.18Мб |
| 048 - Custom formats using asterisk, semicolon, and brackets.srt |
22.45Кб |
| 049 - Meeting unusual filtering needs via Advanced Filter.mp4 |
47.68Мб |
| 049 - Meeting unusual filtering needs via Advanced Filter.srt |
22.23Кб |
| 050 - Create an organization chart.mp4 |
23.64Мб |
| 050 - Create an organization chart.srt |
17.23Кб |
| 051 - Two-way lookup using the MATCH and INDEX functions.mp4 |
50.68Мб |
| 051 - Two-way lookup using the MATCH and INDEX functions.srt |
21.89Кб |
| 052 - Using Excel error-checking functions.mp4 |
33.63Мб |
| 052 - Using Excel error-checking functions.srt |
20.44Кб |
| 053 - Custom formats, relative addressing, and conditional formatting.mp4 |
23.95Мб |
| 053 - Custom formats, relative addressing, and conditional formatting.srt |
15.63Кб |
| 054 - Auditing.mp4 |
30.66Мб |
| 054 - Auditing.srt |
18.06Кб |
| 055 - Adding comments and shapes.mp4 |
25.43Мб |
| 055 - Adding comments and shapes.srt |
15.77Кб |
| 056 - Drawing borders and border grids.mp4 |
21.36Мб |
| 056 - Drawing borders and border grids.srt |
12.55Кб |
| 057 - Building a flexible monthly table using functions.mp4 |
32.81Мб |
| 057 - Building a flexible monthly table using functions.srt |
23.64Кб |
| 058 - Adding pictures as worksheet backgrounds.mp4 |
20.05Мб |
| 058 - Adding pictures as worksheet backgrounds.srt |
10.33Кб |
| 059 - ADDRESS, ROW, and COLUMN functions.mp4 |
27.67Мб |
| 059 - ADDRESS, ROW, and COLUMN functions.srt |
15.98Кб |
| 060 - Join data with new CONCAT and TEXTJOIN functions.mp4 |
17.57Мб |
| 060 - Join data with new CONCAT and TEXTJOIN functions.srt |
11.48Кб |
| 061 - Working with formulas in tables.mp4 |
48.15Мб |
| 061 - Working with formulas in tables.srt |
27.97Кб |
| 062 - Locating data validation rules and violations.mp4 |
28.54Мб |
| 062 - Locating data validation rules and violations.srt |
14.80Кб |
| 063 - Creating an Excel template.mp4 |
23.18Мб |
| 063 - Creating an Excel template.srt |
16.20Кб |
| 064 - Restoring missing column titles.mp4 |
26.37Мб |
| 064 - Restoring missing column titles.srt |
13.57Кб |
| 065 - Creating a pick list dependent on another pick list.mp4 |
18.84Мб |
| 065 - Creating a pick list dependent on another pick list.srt |
13.61Кб |
| 066 - Using command shortcuts with the Alt key.mp4 |
20.20Мб |
| 066 - Using command shortcuts with the Alt key.srt |
10.95Кб |
| 067 - Set up a macro for sorting dynamic data.mp4 |
28.18Мб |
| 067 - Set up a macro for sorting dynamic data.srt |
18.61Кб |
| 068 - Use random number functions for sorting and creating sample data.mp4 |
28.83Мб |
| 068 - Use random number functions for sorting and creating sample data.srt |
19.95Кб |
| 069 - Use calcuated fields and calculated items in a PivotTable.mp4 |
26.32Мб |
| 069 - Use calcuated fields and calculated items in a PivotTable.srt |
17.06Кб |
| 070 - Replace characters by position with the REPLACE function.mp4 |
15.57Мб |
| 070 - Replace characters by position with the REPLACE function.srt |
10.11Кб |
| 071 - Work with formulas in tables.mp4 |
30.04Мб |
| 071 - Work with formulas in tables.srt |
17.81Кб |
| 072 - Keystroke shortcuts from A to Z Using the Ctrl key.mp4 |
55.03Мб |
| 072 - Keystroke shortcuts from A to Z Using the Ctrl key.srt |
31.23Кб |
| 073 - Use special tricks for working with dates in charts.mp4 |
33.20Мб |
| 073 - Use special tricks for working with dates in charts.srt |
21.02Кб |
| 074 - Use a data form for data entry and exploring data.mp4 |
24.91Мб |
| 074 - Use a data form for data entry and exploring data.srt |
12.95Кб |
| 075 - Creating an Excel template to simplify updating a monthly file.mp4 |
19.66Мб |
| 075 - Creating an Excel template to simplify updating a monthly file.srt |
13.61Кб |
| 076 - Calculate dates efficiently using Excel's hidden function - DATEDIF.mp4 |
22.16Мб |
| 076 - Calculate dates efficiently using Excel's hidden function - DATEDIF.srt |
14.37Кб |
| 077 - Create dynamic sheet name references with the INDIRECT function.mp4 |
19.17Мб |
| 077 - Create dynamic sheet name references with the INDIRECT function.srt |
12.36Кб |
| 078 - Avoid errors and hidden data with the powerful AGGREGATE function.mp4 |
20.84Мб |
| 078 - Avoid errors and hidden data with the powerful AGGREGATE function.srt |
13.31Кб |
| 079 - Hide worksheets, row, columns, cells and other Excel elements.mp4 |
27.80Мб |
| 079 - Hide worksheets, row, columns, cells and other Excel elements.srt |
14.85Кб |
| 080 - Use slicers and charts together for dynamic presentations.mp4 |
29.07Мб |
| 080 - Use slicers and charts together for dynamic presentations.srt |
17.61Кб |
| 081 - Save a chart as a template Use the template for current or new charts.mp4 |
18.40Мб |
| 081 - Save a chart as a template Use the template for current or new charts.srt |
12.29Кб |
| 082 - MAXIFS and MINIFS added to the COUNTIF-SUMIF family of functions.mp4 |
22.70Мб |
| 082 - MAXIFS and MINIFS added to the COUNTIF-SUMIF family of functions.srt |
14.94Кб |
| 083 - Adjust a chart's source data and adjust its series order.mp4 |
25.94Мб |
| 083 - Adjust a chart's source data and adjust its series order.srt |
17.46Кб |
| 084 - Use the OFFSET function for tabulating moving data.mp4 |
30.82Мб |
| 084 - Use the OFFSET function for tabulating moving data.srt |
19.72Кб |
| 085 - Alter numeric data without formulas.mp4 |
37.41Мб |
| 085 - Alter numeric data without formulas.srt |
19.19Кб |
| 086 - Use Flash Fill to rapidly combine or separate columnar data.mp4 |
34.31Мб |
| 086 - Use Flash Fill to rapidly combine or separate columnar data.srt |
19.02Кб |
| 087 - Adjust banded-row formatting.mp4 |
57.78Мб |
| 087 - Adjust banded-row formatting.srt |
28.13Кб |
| 088 - Change the shape of comment boxes and other objects.mp4 |
19.25Мб |
| 088 - Change the shape of comment boxes and other objects.srt |
12.53Кб |
| 089 - How and when to use the 10 rounding functions in Excel.mp4 |
35.35Мб |
| 089 - How and when to use the 10 rounding functions in Excel.srt |
24.22Кб |
| 090 - Calculate faster with the AutoSum button and AutoSum keystroke shortcut.mp4 |
18.91Мб |
| 090 - Calculate faster with the AutoSum button and AutoSum keystroke shortcut.srt |
13.33Кб |
| 091 - How to use mixed cell references.mp4 |
23.41Мб |
| 091 - How to use mixed cell references.srt |
15.79Кб |
| 092 - Activate the Speak On Enter and Speak Cells features.mp4 |
14.71Мб |
| 092 - Activate the Speak On Enter and Speak Cells features.srt |
9.55Кб |
| 093 - Accelerate data entry with five special techniques.mp4 |
31.52Мб |
| 093 - Accelerate data entry with five special techniques.srt |
23.29Кб |
| 094 - Insert a text box or shape and link a cell's content to it.mp4 |
16.99Мб |
| 094 - Insert a text box or shape and link a cell's content to it.srt |
12.22Кб |
| 095 - Use Watch Window and other techniques to track changing cells.mp4 |
29.69Мб |
| 095 - Use Watch Window and other techniques to track changing cells.srt |
15.54Кб |
| 096 - How to create time interval entrie.mp4 |
32.38Мб |
| 096 - How to create time interval entrie.srt |
21.29Кб |
| 097 - How to create frequency tabulations and distributions.mp4 |
24.93Мб |
| 097 - How to create frequency tabulations and distributions.srt |
13.99Кб |
| 098 - Create an expanded list from a summary using PivotTable techniques.mp4 |
36.74Мб |
| 098 - Create an expanded list from a summary using PivotTable techniques.srt |
13.27Кб |
| 099 - Solve matching issues with matching phone numbers and SS numbers.mp4 |
35.66Мб |
| 099 - Solve matching issues with matching phone numbers and SS numbers.srt |
18.36Кб |
| 100 - Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative.mp4 |
16.52Мб |
| 100 - Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative.srt |
13.89Кб |
| 101 - Use outlining tools to quickly expand and collapse data for dynamic presentations.mp4 |
35.93Мб |
| 101 - Use outlining tools to quickly expand and collapse data for dynamic presentations.srt |
17.65Кб |
| 102 - Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting.mp4 |
30.07Мб |
| 102 - Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting.srt |
18.38Кб |
| 103 - Create lists of all 2nd Tuesdays, last Tuesdays. and other date series.mp4 |
29.79Мб |
| 103 - Create lists of all 2nd Tuesdays, last Tuesdays. and other date series.srt |
19.24Кб |
| 104 - Create linkage formulas that refer to other worksheets and workbooks.mp4 |
29.86Мб |
| 104 - Create linkage formulas that refer to other worksheets and workbooks.srt |
21.38Кб |
| 105 - Formula nesting - Using multiple functions in the same formula.mp4 |
38.99Мб |
| 105 - Formula nesting - Using multiple functions in the same formula.srt |
25.09Кб |
| 106 - Keyboard shortcuts for numeric formats.mp4 |
25.85Мб |
| 106 - Keyboard shortcuts for numeric formats.srt |
15.06Кб |
| 107 - Use the Subtotal command to analyze data with single- or multiple-level subtotals.mp4 |
41.35Мб |
| 107 - Use the Subtotal command to analyze data with single- or multiple-level subtotals.srt |
16.77Кб |
| 108 - Work with MAX, MAXIFS, LARGE, and related functions.mp4 |
24.59Мб |
| 108 - Work with MAX, MAXIFS, LARGE, and related functions.srt |
16.08Кб |
| 109 - Use the dynamic TODAY and NOW functions for real-time up-to-date calculations.mp4 |
24.29Мб |
| 109 - Use the dynamic TODAY and NOW functions for real-time up-to-date calculations.srt |
16.76Кб |
| 110 - Use the FIND, MID, LEFT, and RIGHT functions.mp4 |
29.82Мб |
| 110 - Use the FIND, MID, LEFT, and RIGHT functions.srt |
19.06Кб |
| 111 - Flip the left-to-right order of columns with the INDEX function or sort by columns.mp4 |
29.38Мб |
| 111 - Flip the left-to-right order of columns with the INDEX function or sort by columns.srt |
14.74Кб |
| 112 - Working with hidden data when copying cells and creating charts.mp4 |
40.93Мб |
| 112 - Working with hidden data when copying cells and creating charts.srt |
22.07Кб |
| 113 - Use conditional formatting data bars to accentuate negative data.mp4 |
11.45Мб |
| 113 - Use conditional formatting data bars to accentuate negative data.srt |
8.74Кб |
| 114 - Creative use of sparklines in merged cells with axes.mp4 |
19.03Мб |
| 114 - Creative use of sparklines in merged cells with axes.srt |
13.03Кб |
| 115 - Copy formats quickly using dragging techniques and the Format Painter.mp4 |
17.39Мб |
| 115 - Copy formats quickly using dragging techniques and the Format Painter.srt |
10.36Кб |
| 116 - Displaying multiple worksheets and workbooks together.mp4 |
32.40Мб |
| 116 - Displaying multiple worksheets and workbooks together.srt |
20.07Кб |
| 117 - Tips for creating and updating sample data.mp4 |
31.62Мб |
| 117 - Tips for creating and updating sample data.srt |
20.85Кб |
| 118 - Use conditional formatting to overcome formatting limitations of the IF function.mp4 |
24.14Мб |
| 118 - Use conditional formatting to overcome formatting limitations of the IF function.srt |
15.88Кб |
| 119 - Use VLOOKUP, MATCH, and INDEX functions with array formulas.mp4 |
29.89Мб |
| 119 - Use VLOOKUP, MATCH, and INDEX functions with array formulas.srt |
18.79Кб |
| 120 - Summarize data from different worksheets with a PivotTable.mp4 |
23.43Мб |
| 120 - Summarize data from different worksheets with a PivotTable.srt |
13.35Кб |
| 121 - AutoFill shortcuts for date series, one-two week intervals, EOM, and formulas.mp4 |
20.22Мб |
| 121 - AutoFill shortcuts for date series, one-two week intervals, EOM, and formulas.srt |
12.88Кб |
| 122 - Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions.mp4 |
24.27Мб |
| 122 - Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions.srt |
15.40Кб |
| 123_Book1.zip |
460.00Кб |
| 123 - Use custom formulas in data validation to keep out bad data.mp4 |
35.01Мб |
| 123 - Use custom formulas in data validation to keep out bad data.srt |
22.53Кб |
| 124_Quick_Charts.zip |
862.18Кб |
| 124 - Dealing with circular errors.mp4 |
22.37Мб |
| 124 - Dealing with circular errors.srt |
14.57Кб |
| 125_Heat_Maps.zip |
51.16Кб |
| 125 - Tips for creating charts quickly.mp4 |
19.24Мб |
| 125 - Tips for creating charts quickly.srt |
12.95Кб |
| 126_INDEX_Function.zip |
491.93Кб |
| 126 - Creating heat maps using conditional formatting.mp4 |
34.91Мб |
| 126 - Creating heat maps using conditional formatting.srt |
15.55Кб |
| 127_Display_Tips.zip |
334.47Кб |
| 127 - Using the INDEX function to extract data by row and column.mp4 |
28.38Мб |
| 127 - Using the INDEX function to extract data by row and column.srt |
20.02Кб |
| 128_Wrap_text_Merge_Indent.zip |
60.12Кб |
| 128 - Displaying tips when using Excel in presentations.mp4 |
29.65Мб |
| 128 - Displaying tips when using Excel in presentations.srt |
11.59Кб |
| 129_Fill_Effects.zip |
24.75Кб |
| 129 - The Wrap Text, Merge and Center, and Indent options.mp4 |
30.35Мб |
| 129 - The Wrap Text, Merge and Center, and Indent options.srt |
17.32Кб |
| 130_Multiple_Worksheets.zip |
16.80Кб |
| 130 - Using fill effects (gradients, patterns, styles) for colorful cell background variations.mp4 |
17.05Мб |
| 130 - Using fill effects (gradients, patterns, styles) for colorful cell background variations.srt |
10.29Кб |
| 131_Other_Font_Options.zip |
367.32Кб |
| 131 - Working with multiple worksheets simultaneously.mp4 |
25.99Мб |
| 131 - Working with multiple worksheets simultaneously.srt |
17.96Кб |
| 132_WordArt_Variations.zip |
426.48Кб |
| 132 - Exploring font choices not found on the Home tab.mp4 |
11.68Мб |
| 132 - Exploring font choices not found on the Home tab.srt |
7.38Кб |
| 133_Weekday_Weekend.zip |
512.45Кб |
| 133 - Using WordArt for special titles and headings.mp4 |
14.54Мб |
| 133 - Using WordArt for special titles and headings.srt |
8.78Кб |
| 134_Two_Way_Lookups.zip |
360.59Кб |
| 134 - Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions.mp4 |
22.80Мб |
| 134 - Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions.srt |
12.90Кб |
| 135_Borders_Gridlines.zip |
438.22Кб |
| 135 - Borders and gridlines - Exploring variations, options, and differences.mp4 |
25.12Мб |
| 135 - Borders and gridlines - Exploring variations, options, and differences.srt |
16.42Кб |
| 136 - New Excel 2016 chart types Tree map and sunburst.mp4 |
30.13Мб |
| 136 - New Excel 2016 chart types Tree map and sunburst.srt |
15.37Кб |
| 137 - Freezing column and row titles.mp4 |
41.85Мб |
| 137 - Freezing column and row titles.srt |
14.54Кб |
| 138 - Use data validation to force entries to be uppercase or lowercase.mp4 |
25.51Мб |
| 138 - Use data validation to force entries to be uppercase or lowercase.srt |
20.02Кб |
| 139 - Avoiding common chart distortions.mp4 |
32.73Мб |
| 139 - Avoiding common chart distortions.srt |
21.49Кб |
| 140 - Use the new funnel chart available in Excel 365.mp4 |
10.63Мб |
| 140 - Use the new funnel chart available in Excel 365.srt |
8.49Кб |
| 141 - Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character.mp4 |
15.23Мб |
| 141 - Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character.srt |
11.54Кб |
| 142 - Recognizing Excel Formula errors #NA, #VALUE!, #REF!, #DIV0!, #NUM, and #NAME!.mp4 |
28.07Мб |
| 142 - Recognizing Excel Formula errors #NA, #VALUE!, #REF!, #DIV0!, #NUM, and #NAME!.srt |
18.09Кб |
| 143 - Creating cross-totals with the SUMIFS function and mixed references.mp4 |
17.62Мб |
| 143 - Creating cross-totals with the SUMIFS function and mixed references.srt |
10.33Кб |
| 144 - New Excel 2016 chart types Histogram, Pareto, and box, and whisker.mp4 |
28.03Мб |
| 144 - New Excel 2016 chart types Histogram, Pareto, and box, and whisker.srt |
18.34Кб |
| 145 - Using the AND and OR functions independently or within IF functions.mp4 |
27.92Мб |
| 145 - Using the AND and OR functions independently or within IF functions.srt |
17.69Кб |
| 146 - Vertical and horizontal alignment settings and orientation options.mp4 |
18.54Мб |
| 146 - Vertical and horizontal alignment settings and orientation options.srt |
12.98Кб |
| 147 - Sorting tips and shortcuts.mp4 |
32.43Мб |
| 147 - Sorting tips and shortcuts.srt |
16.44Кб |
| 148 - A look at new chart types in Excel 2016 - Waterfall.mp4 |
17.99Мб |
| 148 - A look at new chart types in Excel 2016 - Waterfall.srt |
13.12Кб |
| 149_Decimals_and_Fractions.zip |
26.43Кб |
| 149 - Work with formulas and formats Decimals and fractions.mp4 |
13.53Мб |
| 149 - Work with formulas and formats Decimals and fractions.srt |
10.65Кб |
| 150_Mixed_References.zip |
65.27Кб |
| 150 - Creating mixed reference formulas; converting to a table; applying conditional formatting.mp4 |
27.89Мб |
| 150 - Creating mixed reference formulas; converting to a table; applying conditional formatting.srt |
13.92Кб |
| 151_Chart_gridlines_and_borders.zip |
64.55Кб |
| 151 - Control gridlines in charts and on worksheets.mp4 |
21.68Мб |
| 151 - Control gridlines in charts and on worksheets.srt |
14.64Кб |
| 152_INDIRECT_Intersection_RangeNames.zip |
18.66Кб |
| 152 - Use the INDIRECT function with intersection formulas and range names to extract data.mp4 |
20.16Мб |
| 152 - Use the INDIRECT function with intersection formulas and range names to extract data.srt |
11.90Кб |
| 153_Expand_Collapse_PivotTables.zip |
123.43Кб |
| 153 - Using Expand-Collapse on PivotTables and PivotCharts for rapid display changes.mp4 |
21.95Мб |
| 153 - Using Expand-Collapse on PivotTables and PivotCharts for rapid display changes.srt |
13.75Кб |
| 154_Phone_and_ZipCode_Formats.zip |
13.05Кб |
| 154 - Control phone number and postal code formats using built-in options or customized formats.mp4 |
18.70Мб |
| 154 - Control phone number and postal code formats using built-in options or customized formats.srt |
13.36Кб |
| 155_Default_Chart_Type_and_Chart_Templates.zip |
39.89Кб |
| 155 - Change the default Excel chart type; create and use chart templates.mp4 |
19.14Мб |
| 155 - Change the default Excel chart type; create and use chart templates.srt |
11.66Кб |
| 156_Date_Time_Formats.zip |
120.41Кб |
| 156 - Create your own customized date and time formats.mp4 |
22.50Мб |
| 156 - Create your own customized date and time formats.srt |
14.66Кб |
| 157_Comments_and_Reminders.zip |
183.40Кб |
| 157 - Create on-screen warnings and reminders with comments or data validation messages.mp4 |
18.79Мб |
| 157 - Create on-screen warnings and reminders with comments or data validation messages.srt |
11.61Кб |
| 158_Replace_Format_or_Content.zip |
154.66Кб |
| 158 - Use REPLACE for formats only, for data only, or for both.mp4 |
22.46Мб |
| 158 - Use REPLACE for formats only, for data only, or for both.srt |
10.96Кб |
| 159_Number_Formats.zip |
41.15Кб |
| 159 - Create numeric formats - Display in thousands or millions.mp4 |
35.80Мб |
| 159 - Create numeric formats - Display in thousands or millions.srt |
21.69Кб |
| 160_Date_Format_Conversions.zip |
133.70Кб |
| 160 - Converting dates like 20102006 into usable date entries.mp4 |
11.98Мб |
| 160 - Converting dates like 20102006 into usable date entries.srt |
7.99Кб |
| 161_Custom_Lists.zip |
118.02Кб |
| 161 - Create custom lists for letter series like A to Z.mp4 |
28.74Мб |
| 161 - Create custom lists for letter series like A to Z.srt |
12.31Кб |
| 162_Freeze_Panes_and_Split_Screens.zip |
115.03Кб |
| 162 - Freeze Panes and Split.mp4 |
30.26Мб |
| 162 - Freeze Panes and Split.srt |
11.51Кб |
| 163_NETWORKDAYS_and_WORKDAY.zip |
27.14Кб |
| 163 - NETWORKDAYS.INTL and WORKDAY.INTL.mp4 |
14.74Мб |
| 163 - NETWORKDAYS.INTL and WORKDAY.INTL.srt |
10.52Кб |
| 164_Percent_change_and_Goal_Seek.zip |
22.12Кб |
| 164 - Calculate % of change.mp4 |
14.00Мб |
| 164 - Calculate % of change.srt |
10.08Кб |
| 165_Fill_in_Blanks.zip |
152.65Кб |
| 165 - Fill in all blank cells within a range with either formatting or data.mp4 |
16.56Мб |
| 165 - Fill in all blank cells within a range with either formatting or data.srt |
8.41Кб |
| 166_COUNT_COUNTA_and_Status_Bar.zip |
144.02Кб |
| 166 - Use the COUNT and COUNTA functions.mp4 |
13.93Мб |
| 166 - Use the COUNT and COUNTA functions.srt |
7.83Кб |
| 167_Excel_Sheet_Commands.zip |
218.96Кб |
| 167 - Use workbook protection to prevent use of sheet commands.mp4 |
18.00Мб |
| 167 - Use workbook protection to prevent use of sheet commands.srt |
11.15Кб |
| 168_Ranking_Data.zip |
57.87Кб |
| 168 - Rank data with the RANK and RANK.AVG functions.mp4 |
16.11Мб |
| 168 - Rank data with the RANK and RANK.AVG functions.srt |
10.98Кб |
| 169_PivotTable_Date_Grouping.zip |
150.65Кб |
| 169 - Use nonstandard fiscal years and quarters in PivotTables.mp4 |
18.83Мб |
| 169 - Use nonstandard fiscal years and quarters in PivotTables.srt |
10.41Кб |
| 170_Unique_and_Duplicate_Data.zip |
210.96Кб |
| 170 - Identify or extract unique entries in a list.mp4 |
22.68Мб |
| 170 - Identify or extract unique entries in a list.srt |
10.54Кб |
| 171_Zoom_and_Display_Variations.zip |
258.71Кб |
| 171 - Keyboard, mouse, and command techniques for viewing worksheets.mp4 |
27.06Мб |
| 171 - Keyboard, mouse, and command techniques for viewing worksheets.srt |
10.78Кб |
| 172_Abstract_Art_with_Random_Numbers_and_Excel_Charts.zip |
73.04Кб |
| 172 - Create artistic charts with random numbers.mp4 |
22.72Мб |
| 172 - Create artistic charts with random numbers.srt |
14.57Кб |
| 173_YEAR_MONTH_DAY_WEEKDAY.zip |
226.04Кб |
| 173 - Extract day, month, and year from date fields.mp4 |
13.15Мб |
| 173 - Extract day, month, and year from date fields.srt |
9.75Кб |
| 174_EXACT_FIND_SEARCH_Functions.zip |
16.47Кб |
| 174 - Compare data with EXACT, FIND, and SEARCH functions.mp4 |
13.17Мб |
| 174 - Compare data with EXACT, FIND, and SEARCH functions.srt |
9.54Кб |
| 175_ROMAN_ARABIC.zip |
20.33Кб |
| 175 - How to covert ROMAN numberals.mp4 |
13.25Мб |
| 175 - How to covert ROMAN numberals.srt |
7.88Кб |
| 176_Range_Names.zip |
164.88Кб |
| 176 - Use range names for more readable formulas.mp4 |
15.50Мб |
| 176 - Use range names for more readable formulas.srt |
9.93Кб |
| 177_Customize_the_Quick_Access_Toolbar.zip |
59.89Кб |
| 177 - Customize your Quick Access Toolbar.mp4 |
20.33Мб |
| 177 - Customize your Quick Access Toolbar.srt |
11.12Кб |
| 178_Adjusting_Names.zip |
18.63Кб |
| 178 - Conditional formatting based on date proximity.mp4 |
13.75Мб |
| 178 - Conditional formatting based on date proximity.srt |
9.21Кб |
| 179_Date_Proximity_Formatting_final.zip |
19.09Кб |
| 179 - How to adjust names.mp4 |
16.21Мб |
| 179 - How to adjust names.srt |
9.82Кб |
| 180_Table_Differences.zip |
236.76Кб |
| 180 - Differences and limitations of converting data to a table.mp4 |
18.78Мб |
| 180 - Differences and limitations of converting data to a table.srt |
9.97Кб |
| 181_Avoiding_DIV_Error.zip |
29.60Кб |
| 181 - Avoid the #DIV0 error message.mp4 |
13.76Мб |
| 181 - Avoid the #DIV0 error message.srt |
9.47Кб |
| 182_FormattingOptions.zip |
237.66Кб |
| 182 - Explore formatting options not available on the Home tab.mp4 |
15.55Мб |
| 182 - Explore formatting options not available on the Home tab.srt |
8.00Кб |
| 183_New_Table_Style.zip |
123.33Кб |
| 183 - Control table formatting with custom formats.mp4 |
12.20Мб |
| 183 - Control table formatting with custom formats.srt |
6.23Кб |
| 184_Date_Calculations.zip |
128.46Кб |
| 184 - Use date functions for age and tenure calculations.mp4 |
16.43Мб |
| 184 - Use date functions for age and tenure calculations.srt |
10.57Кб |
| 185_Unintentional_Entries.zip |
7.62Кб |
| 185 - Avoid unintentional entries when typing code numbers.mp4 |
9.52Мб |
| 185 - Avoid unintentional entries when typing code numbers.srt |
8.01Кб |
| 186_Sort_by_Moving_Columns.zip |
38.81Кб |
| 186 - Sorting by moving columns.mp4 |
15.31Мб |
| 186 - Sorting by moving columns.srt |
7.83Кб |
| 187_Cumulative_Totals.zip |
11.63Кб |
| 187 - Calculating cumulative totals.mp4 |
11.22Мб |
| 187 - Calculating cumulative totals.srt |
7.63Кб |
| 188_CONVERT_Function.zip |
9.50Кб |
| 188 - Using the CONVERT function for different numbering systems.mp4 |
12.85Мб |
| 188 - Using the CONVERT function for different numbering systems.srt |
8.24Кб |
| 189_Alt_Key_Shortcuts.zip |
24.63Кб |
| 189_Chart_based_on_a_Table.zip |
6.52Кб |
| 189 - Creating an automatically expanding chart by basing it on a table.mp4 |
11.30Мб |
| 189 - Creating an automatically expanding chart by basing it on a table.srt |
7.97Кб |
| 190_Solver.zip |
8.98Кб |
| 190 - Keystroke shortcuts using the Alt key.mp4 |
14.71Мб |
| 190 - Keystroke shortcuts using the Alt key.srt |
10.90Кб |
| 191_Columns_Widths.zip |
14.53Кб |
| 191 - Using the Solver Add-in.mp4 |
11.75Мб |
| 191 - Using the Solver Add-in.srt |
7.73Кб |
| 192_PivotTable_Settings.zip |
67.39Кб |
| 192 - Column widths, row heights, merging cells, and related formatting issues.mp4 |
10.97Мб |
| 192 - Column widths, row heights, merging cells, and related formatting issues.srt |
9.98Кб |
| 193 - Adjusting default layouts and date grouping in PivotTables.mp4 |
11.42Мб |
| 193 - Adjusting default layouts and date grouping in PivotTables.srt |
7.82Кб |
| 194_LEN_and_REPT.zip |
39.19Кб |
| 194_Watch_Window.zip |
105.34Кб |
| 194 - Auditing cell content with Watch Window and dependent cell formulas.mp4 |
9.94Мб |
| 194 - Auditing cell content with Watch Window and dependent cell formulas.srt |
7.92Кб |
| 195_TRIM_and_CLEAN.zip |
75.07Кб |
| 195 - Use the LEN and REPT functions for specialized cell testing and display options.mp4 |
10.58Мб |
| 195 - Use the LEN and REPT functions for specialized cell testing and display options.srt |
10.30Кб |
| 196_Double_and_Triple_Spaced_Printing.zip |
146.80Кб |
| 196 - Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters.mp4 |
11.98Мб |
| 196 - Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters.srt |
10.23Кб |
| 197_Helpful_Keystroke_Shortcuts.zip |
305.83Кб |
| 197 - Create double-spaced and triple-spaced printouts while repeating column headings.mp4 |
12.71Мб |
| 197 - Create double-spaced and triple-spaced printouts while repeating column headings.srt |
9.79Кб |
| 198_Weekdays_and_Weekends.zip |
248.30Кб |
| 198 - Helpful keystroke shortcuts.mp4 |
21.27Мб |
| 198 - Helpful keystroke shortcuts.srt |
9.60Кб |
| 199_Charts_and_Filters.zip |
15.65Кб |
| 199 - Identify weekdays and weekend days in data.mp4 |
11.98Мб |
| 199 - Identify weekdays and weekend days in data.srt |
6.92Кб |
| 200_Linking_Pictures.zip |
66.24Кб |
| 200 - Use chart and filter for presentations.mp4 |
9.52Мб |
| 200 - Use chart and filter for presentations.srt |
9.19Кб |
| 201_Error_Checking_Indicators.zip |
315.60Кб |
| 201 - Create picture links.mp4 |
19.23Мб |
| 201 - Create picture links.srt |
8.41Кб |
| 202_Worksheet_Protection.zip |
55.52Кб |
| 202 - How to use the error-checking rules in Excel.mp4 |
13.63Мб |
| 202 - How to use the error-checking rules in Excel.srt |
10.03Кб |
| 203_Mixed_Cell_Addresses.zip |
18.30Кб |
| 203 - Protect worksheets and lock cells.mp4 |
17.24Мб |
| 203 - Protect worksheets and lock cells.srt |
7.77Кб |
| 204_Filter_by_Selection.zip |
73.31Кб |
| 204 - Use mixed addresses in Excel formulas.mp4 |
12.68Мб |
| 204 - Use mixed addresses in Excel formulas.srt |
9.53Кб |
| 205_Displaying_Large_Values.zip |
32.84Кб |
| 205 - Rapid filtering with Filter by Selection.mp4 |
12.68Мб |
| 205 - Rapid filtering with Filter by Selection.srt |
9.87Кб |
| 206_ConditionalFormatting_and_DataValidation.zip |
107.14Кб |
| 206 - Display large values.mp4 |
17.27Мб |
| 206 - Display large values.srt |
6.64Кб |
| 207_CheckBox_ConditionalFormatting.zip |
107.23Кб |
| 207 - Tracking down conditional formatting and data validation rules.mp4 |
18.94Мб |
| 207 - Tracking down conditional formatting and data validation rules.srt |
10.22Кб |
| 208_Transpose.zip |
15.96Кб |
| 208 - Transposing data and using the TRANSPOSE function.mp4 |
13.41Мб |
| 208 - Transposing data and using the TRANSPOSE function.srt |
10.18Кб |
| 209_Borders_Gridlines_Printing.zip |
16.34Кб |
| 209 - Displaying gridlines, borders, and column_row headings when printing.mp4 |
13.46Мб |
| 209 - Displaying gridlines, borders, and column_row headings when printing.srt |
9.01Кб |
| 210_SmartArt.zip |
17.38Кб |
| 210 - Exploring some of the 200-plus SmartArt graphic options.mp4 |
9.03Мб |
| 210 - Exploring some of the 200-plus SmartArt graphic options.srt |
7.11Кб |
| 211_GoTo_Special.zip |
406.31Кб |
| 211 - Using the CEILING and FLOOR functions for specialized rounding needs.mp4 |
11.87Мб |
| 211 - Using the CEILING and FLOOR functions for specialized rounding needs.srt |
9.37Кб |
| 212_CEILINGandFLOOR.zip |
9.97Кб |
| 212 - Inserting, reshaping, and formatting shapes - Rectangles, arrows, stars, and banners.mp4 |
12.95Мб |
| 212 - Inserting, reshaping, and formatting shapes - Rectangles, arrows, stars, and banners.srt |
11.09Кб |
| 213_Shapes_and_Stars.zip |
16.00Кб |
| 213 - Tabulating totals with the VLOOKUP function and array constants.mp4 |
13.51Мб |
| 213 - Tabulating totals with the VLOOKUP function and array constants.srt |
10.04Кб |
| 214_Array_Constants_withVLOOKUP.zip |
15.28Кб |
| 214 - Working with array formulas more easily.mp4 |
11.05Мб |
| 214 - Working with array formulas more easily.srt |
7.88Кб |
| 215_AdvancedFilter.zip |
344.95Кб |
| 215 - Using the new UNIQUE function to count and copy unique list entries.mp4 |
10.23Мб |
| 215 - Using the new UNIQUE function to count and copy unique list entries.srt |
6.20Кб |
| 216_ArrayFormulaUpdates.zip |
128.04Кб |
| 216 - Creating and updating sample data.mp4 |
15.74Мб |
| 216 - Creating and updating sample data.srt |
9.83Кб |
| 217_UNIQUE_function.zip |
41.25Кб |
| 217 - Format macros to make you a more efficient Excel user.mp4 |
14.50Мб |
| 217 - Format macros to make you a more efficient Excel user.srt |
9.18Кб |
| 218_Sample_Data.zip |
51.25Кб |
| 218 - Use the new SORT and SORTBY functions to extract sorted lists.mp4 |
17.70Мб |
| 218 - Use the new SORT and SORTBY functions to extract sorted lists.srt |
9.59Кб |
| 219_Utility_Macros.zip |
16.83Кб |
| 219 - Use themes to adjust worksheet colors, fonts, and effects.mp4 |
11.30Мб |
| 219 - Use themes to adjust worksheet colors, fonts, and effects.srt |
7.31Кб |
| 220_SORT_and_SORTBY_Functions.zip |
62.63Кб |
| 220 - Calculate loan payments and investments with PMT and FV functions.mp4 |
12.35Мб |
| 220 - Calculate loan payments and investments with PMT and FV functions.srt |
11.25Кб |
| 221_Themes.zip |
39.96Кб |
| 221 - Use the XLOOKUP function to replace VLOOKUP.mp4 |
14.96Мб |
| 221 - Use the XLOOKUP function to replace VLOOKUP.srt |
10.41Кб |
| 222_Financial_Functions.zip |
9.04Кб |
| 222 - Chart display options with blank cells in source data.mp4 |
10.13Мб |
| 222 - Chart display options with blank cells in source data.srt |
7.66Кб |
| 223_BlankCellsInCharts.zip |
333.02Кб |
| 223 - Adjust Conditional Formatting rules by altering percentage breakpoints.mp4 |
12.08Мб |
| 223 - Adjust Conditional Formatting rules by altering percentage breakpoints.srt |
8.63Кб |
| 224_CondFormattingBreakpoints.zip |
20.72Кб |
| 224 - Discover new formula capabilities with new functions and dynamic arrays.mp4 |
13.68Мб |
| 224 - Discover new formula capabilities with new functions and dynamic arrays.srt |
9.39Кб |
| 225_New_Formulas.zip |
45.17Кб |
| 225 - Sort or filter data based on color font or cell color background.mp4 |
23.75Мб |
| 225 - Sort or filter data based on color font or cell color background.srt |
11.33Кб |
| 226_Sort_by_Color.zip |
73.82Кб |
| 226 - Simplify the use of special characters and symbols.mp4 |
11.49Мб |
| 226 - Simplify the use of special characters and symbols.srt |
10.08Кб |
| 227_Special_Characters.zip |
12.84Кб |
| 227 - Select from over 800 icons to enliven worksheets.mp4 |
16.46Мб |
| 227 - Select from over 800 icons to enliven worksheets.srt |
11.94Кб |
| 228_Icons.zip |
42.37Кб |
| 228 - Use the new RANDARRAY function that replaces RAND and RANDBETWEEN.mp4 |
15.76Мб |
| 228 - Use the new RANDARRAY function that replaces RAND and RANDBETWEEN.srt |
11.56Кб |
| 229_Random_Functions.zip |
12.99Кб |
| 229 - How and when to use an area chart.mp4 |
11.11Мб |
| 229 - How and when to use an area chart.srt |
8.27Кб |
| 230_Area_Charts.zip |
8.70Кб |
| 230 - Insert colorful images with the People Graph Add-in.mp4 |
14.87Мб |
| 230 - Insert colorful images with the People Graph Add-in.srt |
10.63Кб |
| 231_People_Graph.zip |
59.43Кб |
| 231 - Use formulas to create interactive charts.mp4 |
11.25Мб |
| 231 - Use formulas to create interactive charts.srt |
10.87Кб |
| 232_GrowingChart.zip |
14.16Кб |
| 232 - Track variables using the Scenario Manager.mp4 |
16.33Мб |
| 232 - Track variables using the Scenario Manager.srt |
7.96Кб |
| 233_ScenarioManager.zip |
27.28Кб |
| 233 - Get totals quickly without creating formulas.mp4 |
16.76Мб |
| 233 - Get totals quickly without creating formulas.srt |
9.03Кб |
| 234_Status_Bar.zip |
65.27Кб |
| 234 - Use column or row references to create dynamic formulas.mp4 |
13.23Мб |
| 234 - Use column or row references to create dynamic formulas.srt |
7.86Кб |
| 235_Columns_and_Rows.zip |
59.83Кб |
| 235 - Overcoming obstacles when working with dates in charts.mp4 |
12.15Мб |
| 235 - Overcoming obstacles when working with dates in charts.srt |
9.57Кб |
| 236_Dates_in_Charts.zip |
10.02Кб |
| 236 - Create map-type charts based on geographical locations.mp4 |
9.49Мб |
| 236 - Create map-type charts based on geographical locations.srt |
8.27Кб |
| 237_Geographic_Maps.zip |
8.11Кб |
| 237 - Techniques for creating date series.mp4 |
10.81Мб |
| 237 - Techniques for creating date series.srt |
8.99Кб |
| 238_Date_Time_Series.zip |
16.18Кб |
| 238 - Extract filtered data with data validation and the FILTER function.mp4 |
13.97Мб |
| 238 - Extract filtered data with data validation and the FILTER function.srt |
8.08Кб |
| 239_Data_Validation_and_Filter.zip |
70.41Кб |
| 239 - Use Find and Replace to change cell contents and formats.mp4 |
21.75Мб |
| 239 - Use Find and Replace to change cell contents and formats.srt |
10.42Кб |
| 240_Find_Select.zip |
157.70Кб |
| 240 - Add formula tools and symbols to the Quick Access Toolbar.mp4 |
16.51Мб |
| 240 - Add formula tools and symbols to the Quick Access Toolbar.srt |
9.31Кб |
| 241_AverageCountSubscript.zip |
57.23Кб |
| 241 - Change PivotTable settings for titles and summaries.mp4 |
16.75Мб |
| 241 - Change PivotTable settings for titles and summaries.srt |
10.95Кб |
| 242_CopyFormats.zip |
22.89Кб |
| 242 - Use the Excel filtering capability for dates.mp4 |
13.11Мб |
| 242 - Use the Excel filtering capability for dates.srt |
8.69Кб |
| 243_XLOOKUP_Function.zip |
165.03Кб |
| 243 - Use worksheet names in formulas.mp4 |
11.93Мб |
| 243 - Use worksheet names in formulas.srt |
10.32Кб |
| 244_PivotTable_Settings.zip |
46.41Кб |
| 244 - Use data validation rules with special phone and social security formats.mp4 |
12.94Мб |
| 244 - Use data validation rules with special phone and social security formats.srt |
10.81Кб |
| 245_FilterYearDay.zip |
28.36Кб |
| 245 - Work with time calculations in formulas.mp4 |
11.43Мб |
| 245 - Work with time calculations in formulas.srt |
8.60Кб |
| 246_Sheet_Names.zip |
74.02Кб |
| 246 - Prevent and locate duplicate worksheet entries.mp4 |
13.80Мб |
| 246 - Prevent and locate duplicate worksheet entries.srt |
8.27Кб |
| 247_Phone_ZipFormats.zip |
9.04Кб |
| 247 - Look forward and backward using EDATE and other date functions.mp4 |
15.84Мб |
| 247 - Look forward and backward using EDATE and other date functions.srt |
9.62Кб |
| 248_Time_Math.zip |
48.20Кб |
| 248 - Display and highlight worksheet formula cells.mp4 |
15.23Мб |
| 248 - Display and highlight worksheet formula cells.srt |
10.13Кб |
| 249_Prevent_Locate_Duplicates.zip |
77.52Кб |
| 249 - Split or join columnar data with Text to Columns or Flash Fill.mp4 |
13.17Мб |
| 249 - Split or join columnar data with Text to Columns or Flash Fill.srt |
8.63Кб |
| 250_EDate_EMonth_DatedIF.zip |
129.25Кб |
| 250 - Highlight milestone data with conditional formatting and cumulative formulas.mp4 |
12.72Мб |
| 250 - Highlight milestone data with conditional formatting and cumulative formulas.srt |
9.75Кб |
| 251_Find_Highlight_Formula_cells.zip |
16.10Кб |
| 251 - Use the XMATCH function to replace MATCH.mp4 |
9.47Мб |
| 251 - Use the XMATCH function to replace MATCH.srt |
6.09Кб |
| 252_Text_Columns_Flash_Fill.zip |
10.67Кб |
| 252 - Create a powerful macro.mp4 |
13.80Мб |
| 252 - Create a powerful macro.srt |
8.15Кб |
| 253_Cumulative_Formulas.zip |
9.61Кб |
| 253 - Work with hidden and visible data in filtered and subtotaled lists.mp4 |
21.59Мб |
| 253- Work with hidden and visible data in filtered and subtotaled lists.srt |
9.86Кб |
| 254_XMATCH_Function.zip |
38.30Кб |
| 254 - Use TODAY, NOW, YEARFRAC, and DATEDIF.mp4 |
15.99Мб |
| 254 - Use TODAY, NOW, YEARFRAC, and DATEDIF.srt |
11.14Кб |
| 255_Hidden_Visible_Data.zip |
85.18Кб |
| 255 - Use data validation rules to prevent duplicate entries in a range.mp4 |
16.00Мб |
| 255 - Use data validation rules to prevent duplicate entries in a range.srt |
8.36Кб |
| 256_Macro_Highlight_Formula_Cells.zip |
16.94Кб |
| 256 - Use various techniques to hide cells, rows, columns, and worksheets.mp4 |
18.09Мб |
| 256 - Use various techniques to hide cells, rows, columns, and worksheets.srt |
9.13Кб |
| 257_TODAY_NOW_Date_Functions.zip |
57.37Кб |
| 257 - Align, arrange, and rotate shapes in worksheets.mp4 |
17.31Мб |
| 257 - Align, arrange, and rotate shapes in worksheets.srt |
10.45Кб |
| 258_Prevent_Duplicates.zip |
48.99Кб |
| 258 - File documentation with the Workbook Statistics button.mp4 |
11.33Мб |
| 258 - File documentation with the Workbook Statistics button.srt |
7.78Кб |
| 259_Hide_cells_rows_columns_sheets.zip |
172.99Кб |
| 259 - Avoid misleading visuals when rescaling.mp4 |
13.63Мб |
| 259 - Avoid misleading visuals when rescaling.srt |
10.14Кб |
| 26_02_Powers_and_Roots.zip |
24.29Кб |
| 26_03_ISTEXT_ISNUMBER_ISNONTEXT.zip |
457.79Кб |
| 26_04_Function_Names.zip |
100.67Кб |
| 26_05_SUM_SUMPRODUCT_SUMIF.zip |
1.29Мб |
| 26_06_Binary_Octal_Decimal_Hexadecimal.zip |
39.10Кб |
| 26_07_Numeric_Formatting.zip |
20.44Кб |
| 26_08_Dates_and_the_1930_2029_split.zip |
11.53Кб |
| 26_09_Wildcard_lookups_XLOOKUP_and_XMATCH.zip |
95.19Кб |
| 26_10_Slicers_Analysis.zip |
129.69Кб |
| 26_11_Heat_Maps.zip |
58.27Кб |
| 26_12_Validation_with_UNIQUE_and_SORT_functions.zip |
58.11Кб |
| 26_13_Clustered_vs_Stacked_Chart_Types.zip |
42.11Кб |
| 260_Align_Arrange_Rotate_Shapes.zip |
18.30Кб |
| 260 - Use the Fill Justify feature to wrap long text.mp4 |
10.18Мб |
| 260 - Use the Fill Justify feature to wrap long text.srt |
7.29Кб |
| 261_Worksheet_Statistics.zip |
427.01Кб |
| 261 - Create range names from Column and Row headings.mp4 |
12.14Мб |
| 261 - Create range names from Column and Row headings.srt |
7.13Кб |
| 262_Re_scaling_Column_and_Line_Charts.zip |
56.60Кб |
| 262 - Use the SUBSTITUTE and REPLACE functions.mp4 |
14.28Мб |
| 262 - Use the SUBSTITUTE and REPLACE functions.srt |
8.88Кб |
| 263_Fill_Justify_Wrap_Text.zip |
9.35Кб |
| 263 - Accelerate Conditional Formatting with the Quick Access Toolbar.mp4 |
13.70Мб |
| 263 - Accelerate Conditional Formatting with the Quick Access Toolbar.srt |
7.67Кб |
| 264_Names_Based_On_Column_Row_Headings.zip |
9.88Кб |
| 264 - Use wildcard symbols in functions.mp4 |
17.98Мб |
| 264 - Use wildcard symbols in functions.srt |
8.92Кб |
| 265_SUBSTITUTE_and_REPLACE_Functions.zip |
63.17Кб |
| 265 - Use wildcard symbols in filtering and commands.mp4 |
20.60Мб |
| 265 - Use wildcard symbols in filtering and commands.srt |
10.83Кб |
| 266_Buttons_for_Conditional_Formatting.zip |
190.71Кб |
| 266 - Condense lengthy nested IF functions with the newer IFS function.mp4 |
11.21Мб |
| 266 - Condense lengthy nested IF functions with the newer IFS function.srt |
8.24Кб |
| 267_Wildcards_Part_1_Filter_and_Commands.zip |
27.73Кб |
| 267 - Add flair to charts with these formatting options Gap width, shadow, glow, 3D, and more.mp4 |
14.54Мб |
| 267 - Add flair to charts with these formatting options Gap width, shadow, glow, 3D, and more.srt |
12.02Кб |
| 268_Wildcards_Part_2_Functions_.zip |
292.64Кб |
| 268 - Control worksheet security by allowing selected users to edit specific cell ranges.mp4 |
15.31Мб |
| 268 - Control worksheet security by allowing selected users to edit specific cell ranges.srt |
10.35Кб |
| 269_IFS_Function.zip |
121.08Кб |
| 269 - Retrieve vital data based on location using the Geography tool.mp4 |
11.44Мб |
| 269 - Retrieve vital data based on location using the Geography tool.srt |
8.54Кб |
| 27_01_XLOOKUP.zip |
160.10Кб |
| 27_02_Update_Date_Entries.zip |
115.25Кб |
| 27_03_Eliminate_Spaces_and_Special_Characters.zip |
17.03Кб |
| 27_04_Create_Range_Names_From_Headings.zip |
20.12Кб |
| 27_05_Date_Series_Creation.zip |
12.19Кб |
| 27_06_LAMBDA_Function.zip |
71.08Кб |
| 27_07_Goal_Seek.zip |
308.97Кб |
| 27_08_Sort_by_Custom_List.zip |
80.02Кб |
| 27_09_INDIRECT_function.zip |
24.69Кб |
| 27_10_Holiday_Calculations.zip |
21.12Кб |
| 27_11_Paste_Special_Drag_Options.zip |
293.03Кб |
| 27_12_SS_Numbers.zip |
94.13Кб |
| 270_Chart_Formatting_Gap_Width_Shadow_Glow_3D.zip |
30.18Кб |
| 270 - Use the new SEQUENCE function to quickly build numeric and date arrays.mp4 |
10.87Мб |
| 270 - Use the new SEQUENCE function to quickly build numeric and date arrays.srt |
10.40Кб |
| 271_Protect_Cell_Ranges.zip |
56.20Кб |
| 271 - Calculating text length and word count with LEN, TRIM, and SUBSTITUTE functions.mp4 |
14.22Мб |
| 271 - Calculating text length and word count with LEN, TRIM, and SUBSTITUTE functions.srt |
11.21Кб |
| 272_Geography_Data.zip |
15.99Кб |
| 272 - Create a list box to facilitate selection of data from a list.mp4 |
14.72Мб |
| 272 - Create a list box to facilitate selection of data from a list.srt |
10.25Кб |
| 273_SEQUENCE_function.zip |
438.53Кб |
| 273 - Use various Excel count functions - COUNT, COUNTA, COUNTBLANK, and more.mp4 |
14.73Мб |
| 273 - Use various Excel count functions - COUNT, COUNTA, COUNTBLANK, and more.srt |
9.93Кб |
| 274_LEN_SUBSTITUTE_and_TRIM_functions.zip |
13.60Кб |
| 274 - Enhance readability with banded rows via conditional formatting.mp4 |
18.76Мб |
| 274 - Enhance readability with banded rows via conditional formatting.srt |
9.90Кб |
| 275_List_Box.zip |
126.80Кб |
| 275 - Seven different ways to drag data using the Ctrl, Shift, and Alt keys.mp4 |
16.74Мб |
| 275 - Seven different ways to drag data using the Ctrl, Shift, and Alt keys.srt |
11.32Кб |
| 276_COUNT_COUNTA_and_COUNTBLANK_functions.zip |
52.09Кб |
| 276 - Use the SWITCH function - Compare with IFS, CHOOSE, and other lookup functions.mp4 |
13.43Мб |
| 276 - Use the SWITCH function - Compare with IFS, CHOOSE, and other lookup functions.srt |
11.28Кб |
| 277_Banded_Rows_or_Columns.zip |
181.48Кб |
| 277 - Adjust charts quickly with quick layout, change colors, and chart styles options.mp4 |
10.61Мб |
| 277 - Adjust charts quickly with quick layout, change colors, and chart styles options.srt |
9.28Кб |
| 278_Dragging_cells_with_Ctrl_Shift_and_Alt_Keys.zip |
81.02Кб |
| 278 - Analyze PivotTable data with 13 different Show Values As options.mp4 |
21.79Мб |
| 278 - Analyze PivotTable data with 13 different Show Values As options.srt |
8.72Кб |
| 279_SWITCH_function.zip |
20.82Кб |
| 279 - Expand-collapse or sort displayed results when using the SUBTOTAL command.mp4 |
22.22Мб |
| 279 - Expand-collapse or sort displayed results when using the SUBTOTAL command.srt |
10.71Кб |
| 28_01_Five_Invaluable_Keystroke_Shortcuts.zip |
163.89Кб |
| 28_02_New_Formula_Techniques.zip |
262.63Кб |
| 28_03_Time_differencees.zip |
47.18Кб |
| 28_04_Zoom_Techniques.zip |
79.12Кб |
| 28_05_Outlining_Tools.zip |
202.31Кб |
| 28_06_Analyze_Data.zip |
252.88Кб |
| 28_07_UNIQUE_Unique_vs_Distinct.zip |
49.92Кб |
| 28_08_Screen_Snip.zip |
1.13Мб |
| 28_09_Sunburst_Charts.zip |
651.41Кб |
| 28_10_Shadow_Glow_Reflection.zip |
834.59Кб |
| 28_11_Printing_Tips.zip |
77.30Кб |
| 280_Chart_Design_Tools.zip |
27.21Кб |
| 280 - Use the AGGREGATE function to circumvent errors and ignore hidden data.mp4 |
21.40Мб |
| 280 - Use the AGGREGATE function to circumvent errors and ignore hidden data.srt |
10.06Кб |
| 281_PivotTable_Analysis.zip |
77.48Кб |
| 281 - Use the F9 key to evaluate parts of a formula, recalculate random entries, and control iteration.mp4 |
17.90Мб |
| 281 - Use the F9 key to evaluate parts of a formula, recalculate random entries, and control iteration.srt |
11.78Кб |
| 282_Subtotal.zip |
120.14Кб |
| 282 - Using last-to-first (bottom-up) searches with XLOOKUP and XMATCH.mp4 |
13.73Мб |
| 282 - Using last-to-first (bottom-up) searches with XLOOKUP and XMATCH.srt |
8.21Кб |
| 283_AGGREGATE_Function.zip |
235.42Кб |
| 283 - Explore Paste Special options - Skip Blanks, Column Widths, Add, Transpose, and more.mp4 |
20.94Мб |
| 283 - Explore Paste Special options - Skip Blanks, Column Widths, Add, Transpose, and more.srt |
10.51Кб |
| 284_The_F9_Key.zip |
20.72Кб |
| 284 - Reduce data entry drudgery with Ctrl+Enter, AutoComplete, and AutoCorrect.mp4 |
15.42Мб |
| 284 - Reduce data entry drudgery with Ctrl+Enter, AutoComplete, and AutoCorrect.srt |
11.45Кб |
| 285_XLOOKUP_XMATCH.zip |
76.66Кб |
| 285 - Using the LET function to simplify formulas via programming concepts.mp4 |
17.30Мб |
| 285 - Using the LET function to simplify formulas via programming concepts.srt |
9.06Кб |
| 286_Paste_Special_Options.zip |
61.87Кб |
| 286 - Create 51 new US State worksheets, or any multiple cluster of worksheets, in a flash.mp4 |
14.37Мб |
| 286 - Create 51 new US State worksheets, or any multiple cluster of worksheets, in a flash.srt |
8.11Кб |
| 287_Data_Entry_Tips.zip |
13.16Кб |
| 287 - Create moving averages with formulas and chart trendlines.mp4 |
17.39Мб |
| 287 - Create moving averages with formulas and chart trendlines.srt |
11.25Кб |
| 288_LET_function.zip |
37.26Кб |
| 288 - Use error-checking functions in Excel - IFERROR, ISERR, and ISERROR.mp4 |
19.93Мб |
| 288 - Use error-checking functions in Excel - IFERROR, ISERR, and ISERROR.srt |
11.29Кб |
| 289_Create_Worksheets_Fast.zip |
13.12Кб |
| 289 - Use Alt+Enter and Wrap Text for line-wrapping titles and improving formula readability.mp4 |
14.44Мб |
| 289 - Use Alt+Enter and Wrap Text for line-wrapping titles and improving formula readability.srt |
10.08Кб |
| 29_01_Data_Validation_Multiple_Criteria.zip |
14.72Кб |
| 29_02_Quick_Access_Toolbar_QAT_Tips.zip |
35.54Кб |
| 29_03_Treemap_Charts.zip |
650.78Кб |
| 29_04_Quick_Analysis_Button.zip |
167.50Кб |
| 29_05_Dragging_Number_Cells.zip |
13.02Кб |
| 29_06_Analyze_Sales_using_the_IF_MAX_and_COUNTIF_functions.zip |
22.32Кб |
| 29_07_Hide_Unhide_Worksheets.zip |
602.03Кб |
| 29_08_Fill_Justify_Re_wrap_text.zip |
17.56Кб |
| 29_09_Date_Series_15th_and_Month_End.zip |
11.09Кб |
| 29_10_Filling_Blank_Cells.zip |
103.53Кб |
| 29_11_Sparklines_and_Conditional_Formatting.zip |
16.46Кб |
| 29_12_Transpose.zip |
23.21Кб |
| 290_MovingAverage.zip |
36.38Кб |
| 290 - Work with cell colors, patterns, and effects to emphasize data and provide visual flair.mp4 |
19.68Мб |
| 290 - Work with cell colors, patterns, and effects to emphasize data and provide visual flair.srt |
8.92Кб |
| 291_Error_Checking_Functions.zip |
14.58Кб |
| 291 - Dynamic array formulas, new ways to calculate - One formula displays results in multiple cells.mp4 |
17.56Мб |
| 291 - Dynamic array formulas, new ways to calculate - One formula displays results in multiple cells.srt |
9.47Кб |
| 292_Line_Wrap_and_Wrap_Text.zip |
20.04Кб |
| 292 - Fonts such as Arial and Calibri and a rundown of various available fonts in Excel.mp4 |
24.25Мб |
| 292 - Fonts such as Arial and Calibri and a rundown of various available fonts in Excel.srt |
12.57Кб |
| 293_Cell_Colors_Patterns_Effects.zip |
26.99Кб |
| 293 - Use 3D formulas to tabulate data from multiple worksheets with the same layout.mp4 |
17.91Мб |
| 293 - Use 3D formulas to tabulate data from multiple worksheets with the same layout.srt |
12.65Кб |
| 294_Dynamic_Arrays.zip |
51.00Кб |
| 294 - Multiple built-in date formats as well as tons of self-defined variations; m_d_y and mmm-d-yyyy.mp4 |
21.08Мб |
| 294 - Multiple built-in date formats as well as tons of self-defined variations; m_d_y and mmm-d-yyyy.srt |
12.20Кб |
| 295_Fonts.zip |
73.68Кб |
| 295 - Where does that cell get its data from - Tracking down cell precedents.mp4 |
16.20Мб |
| 295 - Where does that cell get its data from - Tracking down cell precedents.srt |
7.91Кб |
| 296_3D_Formulas.zip |
19.45Кб |
| 296 - Controlling date entry restrictions using data validation.mp4 |
10.36Мб |
| 296 - Controlling date entry restrictions using data validation.srt |
7.44Кб |
| 297_Date_Formats.zip |
14.49Кб |
| 297 - Remove duplicates from a list vs. creating a new list without duplicates.mp4 |
23.28Мб |
| 297 - Remove duplicates from a list vs. creating a new list without duplicates.srt |
8.51Кб |
| 298_Cell_Precedents.zip |
31.36Кб |
| 298 - New data types Extract valuable online data into your worksheets.mp4 |
15.83Мб |
| 298 - New data types Extract valuable online data into your worksheets.srt |
10.21Кб |
| 299_Date_Controls_with_Data_Validation.zip |
16.92Кб |
| 299 - Use the FILTER and UNIQUE functions together for dynamic extractions.mp4 |
21.90Мб |
| 299 - Use the FILTER and UNIQUE functions together for dynamic extractions.srt |
9.40Кб |
| 30_01_Emojis_and_Pictures.zip |
398.85Кб |
| 30_02_Advanced_Filter.zip |
169.51Кб |
| 30_03_Combo_Charts.zip |
14.39Кб |
| 30_04_MID_SEQUENCE_LEN_Functions.zip |
478.00Кб |
| 30_05_PivotTable_Settings.zip |
76.80Кб |
| 30_06_Navigation.zip |
554.95Кб |
| 300_Managing_Duplicate_Data.zip |
176.14Кб |
| 300 - Adjusting text entries with the UPPER, LOWER, and PROPER functions.mp4 |
17.48Мб |
| 300 - Adjusting text entries with the UPPER, LOWER, and PROPER functions.srt |
9.33Кб |
| 301_New_Data_Types.zip |
314.70Кб |
| 301 - Refine filtering needs via custom filter options.mp4 |
24.95Мб |
| 301 - Refine filtering needs via custom filter options.srt |
10.71Кб |
| 302_FILTER_and_UNIQUE_functions.zip |
55.12Кб |
| 302 - Comparing column charts and bar charts Pros and cons.mp4 |
21.33Мб |
| 303_UPPER_lower_Proper.zip |
13.39Кб |
| 303 - How to use exponentiation (powers and roots) in Excel formulas.mp4 |
16.98Мб |
| 303 - How to use exponentiation (powers and roots) in Excel formulas.srt |
9.98Кб |
| 304_Custom_Filter.zip |
77.51Кб |
| 304 - Tracking down errors with the ISTEXT, ISNUMBER, and ISNONTEXT functions.mp4 |
11.64Мб |
| 304 - Tracking down errors with the ISTEXT, ISNUMBER, and ISNONTEXT functions.srt |
8.61Кб |
| 305 - Tips for saving time when typing function names.mp4 |
23.87Мб |
| 305 - Tips for saving time when typing function names.srt |
13.01Кб |
| 306 - SUMIFS, SUMPRODUCT, and SUM functions compared and contrasted.mp4 |
19.24Мб |
| 306 - SUMIFS, SUMPRODUCT, and SUM functions compared and contrasted.srt |
12.33Кб |
| 307 - Conversion of values into binary, octal, decimal, and hexadecimal equivalents.mp4 |
15.24Мб |
| 307 - Conversion of values into binary, octal, decimal, and hexadecimal equivalents.srt |
8.49Кб |
| 308 - Quick number formatting with keystroke shortcuts and icon buttons.mp4 |
30.35Мб |
| 308 - Quick number formatting with keystroke shortcuts and icon buttons.srt |
14.37Кб |
| 309 - Date calculation and formatting issues related to the 2029-2030 switch.mp4 |
13.21Мб |
| 309 - Date calculation and formatting issues related to the 2029-2030 switch.srt |
9.24Кб |
| 310 - Using wildcards in the new XLOOKUP and XMATCH functions.mp4 |
21.79Мб |
| 310 - Using wildcards in the new XLOOKUP and XMATCH functions.srt |
14.02Кб |
| 311 - Using slicers as analytical tools.mp4 |
27.94Мб |
| 311 - Using slicers as analytical tools.srt |
12.21Кб |
| 312 - Conditional formatting using contrasting heat maps on multiple vs.single ranges.mp4 |
28.44Мб |
| 312 - Conditional formatting using contrasting heat maps on multiple vs.single ranges.srt |
10.56Кб |
| 313 - Create dynamic pick lists using the UNIQUE and SORT functions, and data validation.mp4 |
24.38Мб |
| 313 - Create dynamic pick lists using the UNIQUE and SORT functions, and data validation.srt |
12.10Кб |
| 314 - Contrasting uses of clustered column and stacked column charts.mp4 |
24.61Мб |
| 314 - Contrasting uses of clustered column and stacked column charts.srt |
13.88Кб |
| 315 - Use the XLOOKUP function with multiple column criteria and multiple column results.mp4 |
18.83Мб |
| 315 - Use the XLOOKUP function with multiple column criteria and multiple column results.srt |
8.89Кб |
| 316 - Tips for updating entire columns of date entries when using real or sample data.mp4 |
12.97Мб |
| 316 - Tips for updating entire columns of date entries when using real or sample data.srt |
8.33Кб |
| 317 - Using TRIM, CLEAN and other functions to clean up text data.mp4 |
21.27Мб |
| 317 - Using TRIM, CLEAN and other functions to clean up text data.srt |
11.48Кб |
| 318 - Create multiple range names from the top row and-or left column.mp4 |
17.40Мб |
| 318 - Create multiple range names from the top row and-or left column.srt |
10.58Кб |
| 319 - Use dragging techniques to extend dates by weekdays only, month, or year.mp4 |
10.51Мб |
| 319 - Use dragging techniques to extend dates by weekdays only, month, or year.srt |
7.22Кб |
| 320 - Use the LAMBDA function to create worksheet functions.mp4 |
15.61Мб |
| 320 - Use the LAMBDA function to create worksheet functions.srt |
11.49Кб |
| 321 - Get the formula results you want using Goal Seek.mp4 |
15.39Мб |
| 321 - Get the formula results you want using Goal Seek.srt |
9.14Кб |
| 322 - Sort your data based on a Custom List that you define.mp4 |
27.10Мб |
| 322 - Sort your data based on a Custom List that you define.srt |
11.48Кб |
| 323 - Create a dynamic sheet name reference with the INDIRECT function.mp4 |
12.81Мб |
| 323 - Create a dynamic sheet name reference with the INDIRECT function.srt |
8.68Кб |
| 324 - Calculate dates and-or days of the week for selected future holidays.mp4 |
12.16Мб |
| 324 - Calculate dates and-or days of the week for selected future holidays.srt |
8.41Кб |
| 325 - Use dragging techniques for faster Paste Special options.mp4 |
20.10Мб |
| 325 - Use dragging techniques for faster Paste Special options.srt |
10.37Кб |
| 326 - How to use and not use SS numbers; fake SS numbers; display as XXX-XX-9999.mp4 |
16.71Мб |
| 326 - How to use and not use SS numbers; fake SS numbers; display as XXX-XX-9999.srt |
9.73Кб |
| 327 - Five indispensable keystroke shortcuts for Windows and Mac users.mp4 |
16.63Мб |
| 327 - Five indispensable keystroke shortcuts for Windows and Mac users.srt |
10.73Кб |
| 328 - Using new formula-writing techniques to simplify wide-ranging formulas.mp4 |
23.50Мб |
| 328 - Using new formula-writing techniques to simplify wide-ranging formulas.srt |
11.52Кб |
| 329 - Calculate time differences within days and across multiple days.mp4 |
17.14Мб |
| 329 - Calculate time differences within days and across multiple days.srt |
11.13Кб |
| 330 - Use keyboard, mouse, and commands to zoom in-out quickly in Excel Windows and Mac versions.mp4 |
29.03Мб |
| 330 - Use keyboard, mouse, and commands to zoom in-out quickly in Excel Windows and Mac versions.srt |
10.89Кб |
| 331 - Make dynamic presentations with rapid expand-collapse detail features in outlining.mp4 |
22.20Мб |
| 331 - Make dynamic presentations with rapid expand-collapse detail features in outlining.srt |
11.43Кб |
| 332 - Get data analysis suggestions with the Analyze Data (formerly Ideas) tool.mp4 |
21.65Мб |
| 332 - Get data analysis suggestions with the Analyze Data (formerly Ideas) tool.srt |
11.39Кб |
| 333 - Using the Distinct vs. Unique options when using the UNIQUE function.mp4 |
18.32Мб |
| 333 - Using the Distinct vs. Unique options when using the UNIQUE function.srt |
8.72Кб |
| 334 - Use the Screen Snip tool or keystroke shortcut to take a picture of the screen or a portion of it.mp4 |
18.62Мб |
| 334 - Use the Screen Snip tool or keystroke shortcut to take a picture of the screen or a portion of it.srt |
8.38Кб |
| 335 - Exploring Excel's Sunburst chart to display hierarchical data.mp4 |
23.46Мб |
| 335 - Exploring Excel's Sunburst chart to display hierarchical data.srt |
10.80Кб |
| 336 - Creating floating text boxes with shadow, reflection, glow, and other shape effects.mp4 |
12.59Мб |
| 336 - Creating floating text boxes with shadow, reflection, glow, and other shape effects.srt |
9.15Кб |
| 337 - Page Setup tip Print repeating titles, shrink-to-fit, landscape-portrait, double-spaced layout.mp4 |
18.95Мб |
| 337 - Page Setup tip Print repeating titles, shrink-to-fit, landscape-portrait, double-spaced layout.srt |
12.63Кб |
| 338 - Use Data Validation based on multiple criteria.mp4 |
13.27Мб |
| 338 - Use Data Validation based on multiple criteria.srt |
10.66Кб |
| 339 - Customize the Quick Access Toolbar using the Alt key or a mouse.mp4.crdownload |
11.03Мб |
| 339 - Customize the Quick Access Toolbar using the Alt key or a mouse.srt |
10.63Кб |
| 340 - Exploring treemap charts to display hierarchical data.mp4 |
23.39Мб |
| 340 - Exploring treemap charts to display hierarchical data.srt |
11.76Кб |
| 341 - Use the Quick Analysis tool for easy access to power tools.mp4 |
12.84Мб |
| 341 - Use the Quick Analysis tool for easy access to power tools.srt |
7.31Кб |
| 342 - Create a number series with the Ctrl key and left-right mouse button.mp4 |
17.90Мб |
| 342 - Create a number series with the Ctrl key and left-right mouse button.srt |
11.98Кб |
| 343 - Combine IF, MAX, VALUE, and COUNTIF functions to analyze sales.mp4 |
14.44Мб |
| 343 - Combine IF, MAX, VALUE, and COUNTIF functions to analyze sales.srt |
9.11Кб |
| 344 - Unhide multiple worksheets at once and use the very hidden option.mp4 |
18.85Мб |
| 344 - Unhide multiple worksheets at once and use the very hidden option.srt |
9.69Кб |
| 345 - Use the Fill Justify command to quickly rewrap text into different cells.mp4 |
9.99Мб |
| 345 - Use the Fill Justify command to quickly rewrap text into different cells.srt |
6.98Кб |
| 346 - Create a 15th day or end-of-month series and adjust to weekdays only.mp4 |
10.99Мб |
| 346 - Create a 15th day or end-of-month series and adjust to weekdays only.srt |
8.83Кб |
| 347 - Use the Go To Special option to select and populate blank cells.mp4 |
21.34Мб |
| 347 - Use the Go To Special option to select and populate blank cells.srt |
10.73Кб |
| 348 - Accentuate values with conditional formatting and sparklines.mp4 |
20.22Мб |
| 348 - Accentuate values with conditional formatting and sparklines.srt |
12.19Кб |
| 349 - Transpose data with formula substitution and the TRANSPOSE function.mp4 |
16.02Мб |
| 349 - Transpose data with formula substitution and the TRANSPOSE function.srt |
8.81Кб |
| 350 - Use emojis and other symbols in formulas and charts.mp4 |
19.67Мб |
| 350 - Use emojis and other symbols in formulas and charts.srt |
11.19Кб |
| 351 - Use the Advanced Filter for specialized filtering needs.mp4 |
21.74Мб |
| 351 - Use the Advanced Filter for specialized filtering needs.srt |
10.73Кб |
| 352 - Combo charts Combine different chart types to present data more clearly.mp4 |
16.40Мб |
| 352 - Combo charts Combine different chart types to present data more clearly.srt |
11.56Кб |
| 353 - Combining the SEQUENCE, LEN, and MID functions to extract data into multiple cells.mp4 |
20.11Мб |
| 353 - Combining the SEQUENCE, LEN, and MID functions to extract data into multiple cells.srt |
12.32Кб |
| 354 - Exploring Edit Default Layout options when using PivotTables.mp4 |
16.46Мб |
| 354 - Exploring Edit Default Layout options when using PivotTables.srt |
8.15Кб |
| 355 - Navigation tips Shortcuts to jump within and between worksheets and workbooks.mp4 |
26.18Мб |
| 355 - Navigation tips Shortcuts to jump within and between worksheets and workbooks.srt |
11.70Кб |
| Ex_Files_Excel_Tips_Weekly_2018_Q1.zip |
1.08Мб |
| Ex_Files_Excel_Tips_Weekly_2018_Q2.zip |
1.49Мб |
| Ex_Files_Excel_Tips_Weekly_2018_Q3.zip |
1.47Мб |