Create Tool:
Create Time:1970-01-01 08:00:00
File Size:6.03 GB
File Count:756
File Hash:1e173b857dda2393edd309e59f63ec0bc51b20d9
| 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.40 MB |
| 004 - Using the FORMULATEXT and N functions for worksheet and formula documentation.srt | 10.70 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.70 KB |
| 006 - Summarizing data from diverse ranges with Data - Consolidate.mp4 | 29.40 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.10 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.30 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.20 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.20 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.10 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.40 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.70 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.10 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.40 KB |
| 045 - Creating variable conditional formatting rules.mp4 | 30.80 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.80 KB |
| 063 - Creating an Excel template.mp4 | 23.18 MB |
| 063 - Creating an Excel template.srt | 16.20 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.20 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.20 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.80 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.40 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.70 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.40 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.40 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.80 MB |
| 134 - Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions.srt | 12.90 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.90 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.70 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.50 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.80 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.00 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.00 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.50 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.00 KB |
| 183 - Control table formatting with custom formats.mp4 | 12.20 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.30 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.90 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.30 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.60 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.20 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.50 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.70 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.30 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.60 KB |
| 246 - Prevent and locate duplicate worksheet entries.mp4 | 13.80 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.80 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.00 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.70 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.60 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.40 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.90 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.40 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.90 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.30 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.20 MB |
| 295 - Where does that cell get its data from - Tracking down cell precedents.srt | 7.91 KB |
| Exercise Files/123_Book1.zip | 460.00 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.80 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.40 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.70 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.60 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.50 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.80 KB |
| Exercise Files/197_Helpful_Keystroke_Shortcuts.zip | 305.83 KB |
| Exercise Files/198_Weekdays_and_Weekends.zip | 248.30 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.60 KB |
| Exercise Files/202_Worksheet_Protection.zip | 55.52 KB |
| Exercise Files/203_Mixed_Cell_Addresses.zip | 18.30 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.00 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.70 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.70 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.20 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.10 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.30 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.30 KB |
| Exercise Files/261_Worksheet_Statistics.zip | 427.01 KB |
| Exercise Files/262_Re_scaling_Column_and_Line_Charts.zip | 56.60 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.20 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.60 KB |
| Exercise Files/275_List_Box.zip | 126.80 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.00 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 |
| No trackers found |
TorrentBank
Copyright © 2024