TorBT - Torrents and Magnet Links Search Engine
Latest Searches: %e4%ba%ba%e7%8b%97, gears, 動物, %e8%80%81%e7%8e%8b, 聊天, fsdss-304, 皇帝, 虐待, 婴儿, gracie gates its not

(2015-2022) Excel Tips Weekly (Updated 10.05.2022)

Magnet Download Download Torrent
File Name
Size
001 - Hide and unhide worksheets securely.mp4
17 MB
001 - Hide and unhide worksheets securely.srt
12 kB
002 - Resizing, moving, copying, and manipulating charts and other objects.mp4
28 MB
002 - Resizing, moving, copying, and manipulating charts and other objects.srt
19 kB
003 - Using list boxes and combo boxes to facilitate forms creation.mp4
22 MB
003 - Using list boxes and combo boxes to facilitate forms creation.srt
14 kB
004 - Using the FORMULATEXT and N functions for worksheet and formula documentation.mp4
16 MB
004 - Using the FORMULATEXT and N functions for worksheet and formula documentation.srt
11 kB
005 - Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells.mp4
24 MB
005 - Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells.srt
15 kB
006 - Summarizing data from diverse ranges with Data - Consolidate.mp4
29 MB
006 - Summarizing data from diverse ranges with Data - Consolidate.srt
18 kB
007 - Using check boxes and conditional formatting together for dynamic displays.mp4
40 MB
007 - Using check boxes and conditional formatting together for dynamic displays.srt
23 kB
008 - Becoming more productive with these 10 tiny tips you'll use often.mp4
24 MB
008 - Becoming more productive with these 10 tiny tips you'll use often.srt
16 kB
009 - Transposing data and charts for a different perspective on your data.mp4
30 MB
009 - Transposing data and charts for a different perspective on your data.srt
17 kB
010 - Applying conditional formatting across rows of data.mp4
20 MB
010 - Applying conditional formatting across rows of data.srt
12 kB
011 - Exploring various layouts for your PivotTable.mp4
14 MB
011 - Exploring various layouts for your PivotTable.srt
8.4 kB
012 - Splitting and consolidating workbooks.mp4
20 MB
012 - Splitting and consolidating workbooks.srt
13 kB
013 - Using date and time as metrics in a PivotTable.mp4
23 MB
013 - Using date and time as metrics in a PivotTable.srt
13 kB
014 - Adding illustrations to your workbook.mp4
34 MB
014 - Adding illustrations to your workbook.srt
23 kB
015 - Using a pick list, VLOOKUP, table, and chart together.mp4
23 MB
015 - Using a pick list, VLOOKUP, table, and chart together.srt
16 kB
016 - Using formulas to calculate values across worksheets and workbooks.mp4
30 MB
016 - Using formulas to calculate values across worksheets and workbooks.srt
22 kB
017 - Dynamically presenting data via chart slicers.mp4
20 MB
017 - Dynamically presenting data via chart slicers.srt
14 kB
018 - Parsing your data to create unique lists.mp4
14 MB
018 - Parsing your data to create unique lists.srt
6.6 kB
019 - Using the REPT function to represent data visually.mp4
8.8 MB
019 - Using the REPT function to represent data visually.srt
5.9 kB
020 - Using source data from a table to make your PivotTable more dynamic.mp4
25 MB
020 - Using source data from a table to make your PivotTable more dynamic.srt
15 kB
021 - Accelerating Cut, Copy, Paste, and Insert tasks.mp4
23 MB
021 - Accelerating Cut, Copy, Paste, and Insert tasks.srt
15 kB
022 - Increasing your productivity with custom lists.mp4
21 MB
022 - Increasing your productivity with custom lists.srt
9.4 kB
023 - Highlighting PivotTable results with conditional formatting.mp4
19 MB
023 - Highlighting PivotTable results with conditional formatting.srt
12 kB
024 - Customizing templates to fit your unique needs.mp4
20 MB
024 - Customizing templates to fit your unique needs.srt
12 kB
025 - Creating dynamic charts with in-cell conditional formatting.mp4
12 MB
025 - Creating dynamic charts with in-cell conditional formatting.srt
6.4 kB
026 - Enhancing table filtering with slicers.mp4
20 MB
026 - Enhancing table filtering with slicers.srt
10 kB
027 - Converting charts into pictures.mp4
16 MB
027 - Converting charts into pictures.srt
9.0 kB
028 - Custom grouping in PivotTables.mp4
13 MB
028 - Custom grouping in PivotTables.srt
8.7 kB
029 - Quick formatting tips.mp4
23 MB
029 - Quick formatting tips.srt
15 kB
030 - The top five unknown but useful keyboard shortcuts.mp4
26 MB
030 - The top five unknown but useful keyboard shortcuts.srt
12 kB
031 - Using the TREND and GROWTH functions for projecting future results.mp4
22 MB
031 - Using the TREND and GROWTH functions for projecting future results.srt
10 kB
032 - Using scroll bars and spin buttons to facilitate forms creation.mp4
24 MB
032 - Using scroll bars and spin buttons to facilitate forms creation.srt
19 kB
033 - Creating colorful 3D buttons for worksheet annotation and macro buttons.mp4
22 MB
033 - Creating colorful 3D buttons for worksheet annotation and macro buttons.srt
12 kB
034 - Calculating with hours, minutes, and times of day.mp4
30 MB
034 - Calculating with hours, minutes, and times of day.srt
18 kB
035 - Tracking down cell dependencies across multiple worksheets and workbooks.mp4
22 MB
035 - Tracking down cell dependencies across multiple worksheets and workbooks.srt
11 kB
036 - Discovering time-saving tools in the Go To Special feature.mp4
40 MB
036 - Discovering time-saving tools in the Go To Special feature.srt
21 kB
037 - Adding, managing, and printing comments for worksheet documentation.mp4
19 MB
037 - Adding, managing, and printing comments for worksheet documentation.srt
14 kB
038 - Reducing data entry time by expanding AutoCorrect options.mp4
19 MB
038 - Reducing data entry time by expanding AutoCorrect options.srt
11 kB
039 - Setting up custom views for quick access to different worksheet displays.mp4
25 MB
039 - Setting up custom views for quick access to different worksheet displays.srt
11 kB
040 - Using hyperlinks for rapidly switching worksheet locations and jumping to websites.mp4
21 MB
040 - Using hyperlinks for rapidly switching worksheet locations and jumping to websites.srt
14 kB
041 - Controlling worksheet security by allowing selected users to edit specific cell ranges.mp4
24 MB
041 - Controlling worksheet security by allowing selected users to edit specific cell ranges.srt
13 kB
042 - Using option buttons, group boxes, and checkboxes to facilitate forms creation.mp4
20 MB
042 - Using option buttons, group boxes, and checkboxes to facilitate forms creation.srt
14 kB
043 - Exploring what-if scenarios using Goal Seek.mp4
28 MB
043 - Exploring what-if scenarios using Goal Seek.srt
16 kB
044 - Creating text, numerical, date, and time lists in a flash.mp4
18 MB
044 - Creating text, numerical, date, and time lists in a flash.srt
12 kB
045 - Creating variable conditional formatting rules.mp4
31 MB
045 - Creating variable conditional formatting rules.srt
14 kB
046 - Handling dates with unusual formats.mp4
20 MB
046 - Handling dates with unusual formats.srt
11 kB
047 - Using wildcards (asterisk, tilde, and question mark).mp4
38 MB
047 - Using wildcards (asterisk, tilde, and question mark).srt
18 kB
048 - Custom formats using asterisk, semicolon, and brackets.mp4
39 MB
048 - Custom formats using asterisk, semicolon, and brackets.srt
22 kB
049 - Meeting unusual filtering needs via Advanced Filter.mp4
48 MB
049 - Meeting unusual filtering needs via Advanced Filter.srt
22 kB
050 - Create an organization chart.mp4
24 MB
050 - Create an organization chart.srt
17 kB
051 - Two-way lookup using the MATCH and INDEX functions.mp4
51 MB
051 - Two-way lookup using the MATCH and INDEX functions.srt
22 kB
052 - Using Excel error-checking functions.mp4
34 MB
052 - Using Excel error-checking functions.srt
20 kB
053 - Custom formats, relative addressing, and conditional formatting.mp4
24 MB
053 - Custom formats, relative addressing, and conditional formatting.srt
16 kB
054 - Auditing.mp4
31 MB
054 - Auditing.srt
18 kB
055 - Adding comments and shapes.mp4
25 MB
055 - Adding comments and shapes.srt
16 kB
056 - Drawing borders and border grids.mp4
21 MB
056 - Drawing borders and border grids.srt
13 kB
057 - Building a flexible monthly table using functions.mp4
33 MB
057 - Building a flexible monthly table using functions.srt
24 kB
058 - Adding pictures as worksheet backgrounds.mp4
20 MB
058 - Adding pictures as worksheet backgrounds.srt
10 kB
059 - ADDRESS, ROW, and COLUMN functions.mp4
28 MB
059 - ADDRESS, ROW, and COLUMN functions.srt
16 kB
060 - Join data with new CONCAT and TEXTJOIN functions.mp4
18 MB
060 - Join data with new CONCAT and TEXTJOIN functions.srt
12 kB
061 - Working with formulas in tables.mp4
48 MB
061 - Working with formulas in tables.srt
28 kB
062 - Locating data validation rules and violations.mp4
28 MB
062 - Locating data validation rules and violations.srt
15 kB
063 - Creating an Excel template.mp4
23 MB
063 - Creating an Excel template.srt
16 kB
064 - Restoring missing column titles.mp4
26 MB
064 - Restoring missing column titles.srt
14 kB
065 - Creating a pick list dependent on another pick list.mp4
19 MB
065 - Creating a pick list dependent on another pick list.srt
14 kB
066 - Using command shortcuts with the Alt key.mp4
20 MB
066 - Using command shortcuts with the Alt key.srt
11 kB
067 - Set up a macro for sorting dynamic data.mp4
28 MB
067 - Set up a macro for sorting dynamic data.srt
19 kB
068 - Use random number functions for sorting and creating sample data.mp4
29 MB
068 - Use random number functions for sorting and creating sample data.srt
20 kB
069 - Use calcuated fields and calculated items in a PivotTable.mp4
26 MB
069 - Use calcuated fields and calculated items in a PivotTable.srt
17 kB
070 - Replace characters by position with the REPLACE function.mp4
16 MB
070 - Replace characters by position with the REPLACE function.srt
10 kB
071 - Work with formulas in tables.mp4
30 MB
071 - Work with formulas in tables.srt
18 kB
072 - Keystroke shortcuts from A to Z Using the Ctrl key.mp4
55 MB
072 - Keystroke shortcuts from A to Z Using the Ctrl key.srt
31 kB
073 - Use special tricks for working with dates in charts.mp4
33 MB
073 - Use special tricks for working with dates in charts.srt
21 kB
074 - Use a data form for data entry and exploring data.mp4
25 MB
074 - Use a data form for data entry and exploring data.srt
13 kB
075 - Creating an Excel template to simplify updating a monthly file.mp4
20 MB
075 - Creating an Excel template to simplify updating a monthly file.srt
14 kB
076 - Calculate dates efficiently using Excel's hidden function - DATEDIF.mp4
22 MB
076 - Calculate dates efficiently using Excel's hidden function - DATEDIF.srt
14 kB
077 - Create dynamic sheet name references with the INDIRECT function.mp4
19 MB
077 - Create dynamic sheet name references with the INDIRECT function.srt
12 kB
078 - Avoid errors and hidden data with the powerful AGGREGATE function.mp4
21 MB
078 - Avoid errors and hidden data with the powerful AGGREGATE function.srt
13 kB
079 - Hide worksheets, row, columns, cells and other Excel elements.mp4
28 MB
079 - Hide worksheets, row, columns, cells and other Excel elements.srt
15 kB
080 - Use slicers and charts together for dynamic presentations.mp4
29 MB
080 - Use slicers and charts together for dynamic presentations.srt
18 kB
081 - Save a chart as a template Use the template for current or new charts.mp4
18 MB
081 - Save a chart as a template Use the template for current or new charts.srt
12 kB
082 - MAXIFS and MINIFS added to the COUNTIF-SUMIF family of functions.mp4
23 MB
082 - MAXIFS and MINIFS added to the COUNTIF-SUMIF family of functions.srt
15 kB
083 - Adjust a chart's source data and adjust its series order.mp4
26 MB
083 - Adjust a chart's source data and adjust its series order.srt
18 kB
084 - Use the OFFSET function for tabulating moving data.mp4
31 MB
084 - Use the OFFSET function for tabulating moving data.srt
20 kB
085 - Alter numeric data without formulas.mp4
37 MB
085 - Alter numeric data without formulas.srt
19 kB
086 - Use Flash Fill to rapidly combine or separate columnar data.mp4
34 MB
086 - Use Flash Fill to rapidly combine or separate columnar data.srt
19 kB
087 - Adjust banded-row formatting.mp4
58 MB
087 - Adjust banded-row formatting.srt
28 kB
088 - Change the shape of comment boxes and other objects.mp4
19 MB
088 - Change the shape of comment boxes and other objects.srt
12 kB
089 - How and when to use the 10 rounding functions in Excel.mp4
35 MB
089 - How and when to use the 10 rounding functions in Excel.srt
24 kB
090 - Calculate faster with the AutoSum button and AutoSum keystroke shortcut.mp4
19 MB
090 - Calculate faster with the AutoSum button and AutoSum keystroke shortcut.srt
13 kB
091 - How to use mixed cell references.mp4
23 MB
091 - How to use mixed cell references.srt
16 kB
092 - Activate the Speak On Enter and Speak Cells features.mp4
15 MB
092 - Activate the Speak On Enter and Speak Cells features.srt
9.6 kB
093 - Accelerate data entry with five special techniques.mp4
32 MB
093 - Accelerate data entry with five special techniques.srt
23 kB
094 - Insert a text box or shape and link a cell's content to it.mp4
17 MB
094 - Insert a text box or shape and link a cell's content to it.srt
12 kB
095 - Use Watch Window and other techniques to track changing cells.mp4
30 MB
095 - Use Watch Window and other techniques to track changing cells.srt
16 kB
096 - How to create time interval entrie.mp4
32 MB
096 - How to create time interval entrie.srt
21 kB
097 - How to create frequency tabulations and distributions.mp4
25 MB
097 - How to create frequency tabulations and distributions.srt
14 kB
098 - Create an expanded list from a summary using PivotTable techniques.mp4
37 MB
098 - Create an expanded list from a summary using PivotTable techniques.srt
13 kB
099 - Solve matching issues with matching phone numbers and SS numbers.mp4
36 MB
099 - Solve matching issues with matching phone numbers and SS numbers.srt
18 kB
100 - Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative.mp4
16 MB
100 - Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative.srt
14 kB
101 - Use outlining tools to quickly expand and collapse data for dynamic presentations.mp4
36 MB
101 - Use outlining tools to quickly expand and collapse data for dynamic presentations.srt
18 kB
102 - Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting.mp4
30 MB
102 - Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting.srt
18 kB
103 - Create lists of all 2nd Tuesdays, last Tuesdays. and other date series.mp4
30 MB
103 - Create lists of all 2nd Tuesdays, last Tuesdays. and other date series.srt
19 kB
104 - Create linkage formulas that refer to other worksheets and workbooks.mp4
30 MB
104 - Create linkage formulas that refer to other worksheets and workbooks.srt
21 kB
105 - Formula nesting - Using multiple functions in the same formula.mp4
39 MB
105 - Formula nesting - Using multiple functions in the same formula.srt
25 kB
106 - Keyboard shortcuts for numeric formats.mp4
26 MB
106 - Keyboard shortcuts for numeric formats.srt
15 kB
107 - Use the Subtotal command to analyze data with single- or multiple-level subtotals.mp4
41 MB
107 - Use the Subtotal command to analyze data with single- or multiple-level subtotals.srt
17 kB
108 - Work with MAX, MAXIFS, LARGE, and related functions.mp4
25 MB
108 - Work with MAX, MAXIFS, LARGE, and related functions.srt
16 kB
109 - Use the dynamic TODAY and NOW functions for real-time up-to-date calculations.mp4
24 MB
109 - Use the dynamic TODAY and NOW functions for real-time up-to-date calculations.srt
17 kB
110 - Use the FIND, MID, LEFT, and RIGHT functions.mp4
30 MB
110 - Use the FIND, MID, LEFT, and RIGHT functions.srt
19 kB
111 - Flip the left-to-right order of columns with the INDEX function or sort by columns.mp4
29 MB
111 - Flip the left-to-right order of columns with the INDEX function or sort by columns.srt
15 kB
112 - Working with hidden data when copying cells and creating charts.mp4
41 MB
112 - Working with hidden data when copying cells and creating charts.srt
22 kB
113 - Use conditional formatting data bars to accentuate negative data.mp4
12 MB
113 - Use conditional formatting data bars to accentuate negative data.srt
8.7 kB
114 - Creative use of sparklines in merged cells with axes.mp4
19 MB
114 - Creative use of sparklines in merged cells with axes.srt
13 kB
115 - Copy formats quickly using dragging techniques and the Format Painter.mp4
17 MB
115 - Copy formats quickly using dragging techniques and the Format Painter.srt
10 kB
116 - Displaying multiple worksheets and workbooks together.mp4
32 MB
116 - Displaying multiple worksheets and workbooks together.srt
20 kB
117 - Tips for creating and updating sample data.mp4
32 MB
117 - Tips for creating and updating sample data.srt
21 kB
118 - Use conditional formatting to overcome formatting limitations of the IF function.mp4
24 MB
118 - Use conditional formatting to overcome formatting limitations of the IF function.srt
16 kB
119 - Use VLOOKUP, MATCH, and INDEX functions with array formulas.mp4
30 MB
119 - Use VLOOKUP, MATCH, and INDEX functions with array formulas.srt
19 kB
120 - Summarize data from different worksheets with a PivotTable.mp4
23 MB
120 - Summarize data from different worksheets with a PivotTable.srt
13 kB
121 - AutoFill shortcuts for date series, one-two week intervals, EOM, and formulas.mp4
20 MB
121 - AutoFill shortcuts for date series, one-two week intervals, EOM, and formulas.srt
13 kB
122 - Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions.mp4
24 MB
122 - Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions.srt
15 kB
123 - Use custom formulas in data validation to keep out bad data.mp4
35 MB
123 - Use custom formulas in data validation to keep out bad data.srt
22 kB
124 - Dealing with circular errors.mp4
22 MB
124 - Dealing with circular errors.srt
15 kB
125 - Tips for creating charts quickly.mp4
19 MB
125 - Tips for creating charts quickly.srt
13 kB
126 - Creating heat maps using conditional formatting.mp4
35 MB
126 - Creating heat maps using conditional formatting.srt
16 kB
127 - Using the INDEX function to extract data by row and column.mp4
28 MB
127 - Using the INDEX function to extract data by row and column.srt
20 kB
128 - Displaying tips when using Excel in presentations.mp4
30 MB
128 - Displaying tips when using Excel in presentations.srt
12 kB
129 - The Wrap Text, Merge and Center, and Indent options.mp4
30 MB
129 - The Wrap Text, Merge and Center, and Indent options.srt
17 kB
130 - Using fill effects (gradients, patterns, styles) for colorful cell background variations.mp4
17 MB
130 - Using fill effects (gradients, patterns, styles) for colorful cell background variations.srt
10 kB
131 - Working with multiple worksheets simultaneously.mp4
26 MB
131 - Working with multiple worksheets simultaneously.srt
18 kB
132 - Exploring font choices not found on the Home tab.mp4
12 MB
132 - Exploring font choices not found on the Home tab.srt
7.4 kB
133 - Using WordArt for special titles and headings.mp4
14 MB
133 - Using WordArt for special titles and headings.srt
8.8 kB
134 - Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions.mp4
23 MB
134 - Creating a two-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions.srt
13 kB
135 - Borders and gridlines - Exploring variations, options, and differences.mp4
25 MB
135 - Borders and gridlines - Exploring variations, options, and differences.srt
16 kB
136 - New Excel 2016 chart types Tree map and sunburst.mp4
30 MB
136 - New Excel 2016 chart types Tree map and sunburst.srt
15 kB
137 - Freezing column and row titles.mp4
42 MB
137 - Freezing column and row titles.srt
14 kB
138 - Use data validation to force entries to be uppercase or lowercase.mp4
26 MB
138 - Use data validation to force entries to be uppercase or lowercase.srt
20 kB
139 - Avoiding common chart distortions.mp4
33 MB
139 - Avoiding common chart distortions.srt
22 kB
140 - Use the new funnel chart available in Excel 365.mp4
11 MB
140 - Use the new funnel chart available in Excel 365.srt
8.5 kB
141 - Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character.mp4
15 MB
141 - Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character.srt
12 kB
142 - Recognizing Excel Formula errors #NA, #VALUE!, #REF!, #DIV0!, #NUM, and #NAME!.mp4
28 MB
142 - Recognizing Excel Formula errors #NA, #VALUE!, #REF!, #DIV0!, #NUM, and #NAME!.srt
18 kB
143 - Creating cross-totals with the SUMIFS function and mixed references.mp4
18 MB
143 - Creating cross-totals with the SUMIFS function and mixed references.srt
10 kB
144 - New Excel 2016 chart types Histogram, Pareto, and box, and whisker.mp4
28 MB
144 - New Excel 2016 chart types Histogram, Pareto, and box, and whisker.srt
18 kB
145 - Using the AND and OR functions independently or within IF functions.mp4
28 MB
145 - Using the AND and OR functions independently or within IF functions.srt
18 kB
146 - Vertical and horizontal alignment settings and orientation options.mp4
18 MB
146 - Vertical and horizontal alignment settings and orientation options.srt
13 kB
147 - Sorting tips and shortcuts.mp4
32 MB
147 - Sorting tips and shortcuts.srt
16 kB
148 - A look at new chart types in Excel 2016 - Waterfall.mp4
18 MB
148 - A look at new chart types in Excel 2016 - Waterfall.srt
13 kB
149 - Work with formulas and formats Decimals and fractions.mp4
14 MB
149 - Work with formulas and formats Decimals and fractions.srt
11 kB
150 - Creating mixed reference formulas; converting to a table; applying conditional formatting.mp4
28 MB
150 - Creating mixed reference formulas; converting to a table; applying conditional formatting.srt
14 kB
151 - Control gridlines in charts and on worksheets.mp4
22 MB
151 - Control gridlines in charts and on worksheets.srt
15 kB
152 - Use the INDIRECT function with intersection formulas and range names to extract data.mp4
20 MB
152 - Use the INDIRECT function with intersection formulas and range names to extract data.srt
12 kB
153 - Using Expand-Collapse on PivotTables and PivotCharts for rapid display changes.mp4
22 MB
153 - Using Expand-Collapse on PivotTables and PivotCharts for rapid display changes.srt
14 kB
154 - Control phone number and postal code formats using built-in options or customized formats.mp4
19 MB
154 - Control phone number and postal code formats using built-in options or customized formats.srt
13 kB
155 - Change the default Excel chart type; create and use chart templates.mp4
19 MB
155 - Change the default Excel chart type; create and use chart templates.srt
12 kB
156 - Create your own customized date and time formats.mp4
22 MB
156 - Create your own customized date and time formats.srt
15 kB
157 - Create on-screen warnings and reminders with comments or data validation messages.mp4
19 MB
157 - Create on-screen warnings and reminders with comments or data validation messages.srt
12 kB
158 - Use REPLACE for formats only, for data only, or for both.mp4
22 MB
158 - Use REPLACE for formats only, for data only, or for both.srt
11 kB
159 - Create numeric formats - Display in thousands or millions.mp4
36 MB
159 - Create numeric formats - Display in thousands or millions.srt
22 kB
160 - Converting dates like 20102006 into usable date entries.mp4
12 MB
160 - Converting dates like 20102006 into usable date entries.srt
8.0 kB
161 - Create custom lists for letter series like A to Z.mp4
29 MB
161 - Create custom lists for letter series like A to Z.srt
12 kB
162 - Freeze Panes and Split.mp4
30 MB
162 - Freeze Panes and Split.srt
12 kB
163 - NETWORKDAYS.INTL and WORKDAY.INTL.mp4
15 MB
163 - NETWORKDAYS.INTL and WORKDAY.INTL.srt
10 kB
164 - Calculate % of change.mp4
14 MB
164 - Calculate % of change.srt
10 kB
165 - Fill in all blank cells within a range with either formatting or data.mp4
17 MB
165 - Fill in all blank cells within a range with either formatting or data.srt
8.4 kB
166 - Use the COUNT and COUNTA functions.mp4
14 MB
166 - Use the COUNT and COUNTA functions.srt
7.8 kB
167 - Use workbook protection to prevent use of sheet commands.mp4
18 MB
167 - Use workbook protection to prevent use of sheet commands.srt
11 kB
168 - Rank data with the RANK and RANK.AVG functions.mp4
16 MB
168 - Rank data with the RANK and RANK.AVG functions.srt
11 kB
169 - Use nonstandard fiscal years and quarters in PivotTables.mp4
19 MB
169 - Use nonstandard fiscal years and quarters in PivotTables.srt
10 kB
170 - Identify or extract unique entries in a list.mp4
23 MB
170 - Identify or extract unique entries in a list.srt
10 kB
171 - Keyboard, mouse, and command techniques for viewing worksheets.mp4
27 MB
171 - Keyboard, mouse, and command techniques for viewing worksheets.srt
11 kB
172 - Create artistic charts with random numbers.mp4
23 MB
172 - Create artistic charts with random numbers.srt
15 kB
173 - Extract day, month, and year from date fields.mp4
13 MB
173 - Extract day, month, and year from date fields.srt
9.8 kB
174 - Compare data with EXACT, FIND, and SEARCH functions.mp4
13 MB
174 - Compare data with EXACT, FIND, and SEARCH functions.srt
9.5 kB
175 - How to covert ROMAN numberals.mp4
13 MB
175 - How to covert ROMAN numberals.srt
7.9 kB
176 - Use range names for more readable formulas.mp4
16 MB
176 - Use range names for more readable formulas.srt
9.9 kB
177 - Customize your Quick Access Toolbar.mp4
20 MB
177 - Customize your Quick Access Toolbar.srt
11 kB
178 - Conditional formatting based on date proximity.mp4
14 MB
178 - Conditional formatting based on date proximity.srt
9.2 kB
179 - How to adjust names.mp4
16 MB
179 - How to adjust names.srt
9.8 kB
180 - Differences and limitations of converting data to a table.mp4
19 MB
180 - Differences and limitations of converting data to a table.srt
10 kB
181 - Avoid the #DIV0 error message.mp4
14 MB
181 - Avoid the #DIV0 error message.srt
9.5 kB
182 - Explore formatting options not available on the Home tab.mp4
16 MB
182 - Explore formatting options not available on the Home tab.srt
8.0 kB
183 - Control table formatting with custom formats.mp4
12 MB
183 - Control table formatting with custom formats.srt
6.2 kB
184 - Use date functions for age and tenure calculations.mp4
16 MB
184 - Use date functions for age and tenure calculations.srt
11 kB
185 - Avoid unintentional entries when typing code numbers.mp4
9.5 MB
185 - Avoid unintentional entries when typing code numbers.srt
8.0 kB
186 - Sorting by moving columns.mp4
15 MB
186 - Sorting by moving columns.srt
7.8 kB
187 - Calculating cumulative totals.mp4
11 MB
187 - Calculating cumulative totals.srt
7.6 kB
188 - Using the CONVERT function for different numbering systems.mp4
13 MB
188 - Using the CONVERT function for different numbering systems.srt
8.2 kB
189 - Creating an automatically expanding chart by basing it on a table.mp4
11 MB
189 - Creating an automatically expanding chart by basing it on a table.srt
8.0 kB
190 - Keystroke shortcuts using the Alt key.mp4
15 MB
190 - Keystroke shortcuts using the Alt key.srt
11 kB
191 - Using the Solver Add-in.mp4
12 MB
191 - Using the Solver Add-in.srt
7.7 kB
192 - Column widths, row heights, merging cells, and related formatting issues.mp4
11 MB
192 - Column widths, row heights, merging cells, and related formatting issues.srt
10 kB
193 - Adjusting default layouts and date grouping in PivotTables.mp4
11 MB
193 - Adjusting default layouts and date grouping in PivotTables.srt
7.8 kB
194 - Auditing cell content with Watch Window and dependent cell formulas.mp4
9.9 MB
194 - Auditing cell content with Watch Window and dependent cell formulas.srt
7.9 kB
195 - Use the LEN and REPT functions for specialized cell testing and display options.mp4
11 MB
195 - Use the LEN and REPT functions for specialized cell testing and display options.srt
10 kB
196 - Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters.mp4
12 MB
196 - Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters.srt
10 kB
197 - Create double-spaced and triple-spaced printouts while repeating column headings.mp4
13 MB
197 - Create double-spaced and triple-spaced printouts while repeating column headings.srt
9.8 kB
198 - Helpful keystroke shortcuts.mp4
21 MB
198 - Helpful keystroke shortcuts.srt
9.6 kB
199 - Identify weekdays and weekend days in data.mp4
12 MB
199 - Identify weekdays and weekend days in data.srt
6.9 kB
200 - Use chart and filter for presentations.mp4
9.5 MB
200 - Use chart and filter for presentations.srt
9.2 kB
201 - Create picture links.mp4
19 MB
201 - Create picture links.srt
8.4 kB
202 - How to use the error-checking rules in Excel.mp4
14 MB
202 - How to use the error-checking rules in Excel.srt
10 kB
203 - Protect worksheets and lock cells.mp4
17 MB
203 - Protect worksheets and lock cells.srt
7.8 kB
204 - Use mixed addresses in Excel formulas.mp4
13 MB
204 - Use mixed addresses in Excel formulas.srt
9.5 kB
205 - Rapid filtering with Filter by Selection.mp4
13 MB
205 - Rapid filtering with Filter by Selection.srt
9.9 kB
206 - Display large values.mp4
17 MB
206 - Display large values.srt
6.6 kB
207 - Tracking down conditional formatting and data validation rules.mp4
19 MB
207 - Tracking down conditional formatting and data validation rules.srt
10 kB
208 - Transposing data and using the TRANSPOSE function.mp4
13 MB
208 - Transposing data and using the TRANSPOSE function.srt
10 kB
209 - Displaying gridlines, borders, and column_row headings when printing.mp4
14 MB
209 - Displaying gridlines, borders, and column_row headings when printing.srt
9.0 kB
210 - Exploring some of the 200-plus SmartArt graphic options.mp4
9.0 MB
210 - Exploring some of the 200-plus SmartArt graphic options.srt
7.1 kB
211 - Using the CEILING and FLOOR functions for specialized rounding needs.mp4
12 MB
211 - Using the CEILING and FLOOR functions for specialized rounding needs.srt
9.4 kB
212 - Inserting, reshaping, and formatting shapes - Rectangles, arrows, stars, and banners.mp4
13 MB
212 - Inserting, reshaping, and formatting shapes - Rectangles, arrows, stars, and banners.srt
11 kB
213 - Tabulating totals with the VLOOKUP function and array constants.mp4
14 MB
213 - Tabulating totals with the VLOOKUP function and array constants.srt
10 kB
214 - Working with array formulas more easily.mp4
11 MB
214 - Working with array formulas more easily.srt
7.9 kB
215 - Using the new UNIQUE function to count and copy unique list entries.mp4
10 MB
215 - Using the new UNIQUE function to count and copy unique list entries.srt
6.2 kB
216 - Creating and updating sample data.mp4
16 MB
216 - Creating and updating sample data.srt
9.8 kB
217 - Format macros to make you a more efficient Excel user.mp4
14 MB
217 - Format macros to make you a more efficient Excel user.srt
9.2 kB
218 - Use the new SORT and SORTBY functions to extract sorted lists.mp4
18 MB
218 - Use the new SORT and SORTBY functions to extract sorted lists.srt
9.6 kB
219 - Use themes to adjust worksheet colors, fonts, and effects.mp4
11 MB
219 - Use themes to adjust worksheet colors, fonts, and effects.srt
7.3 kB
220 - Calculate loan payments and investments with PMT and FV functions.mp4
12 MB
220 - Calculate loan payments and investments with PMT and FV functions.srt
11 kB
221 - Use the XLOOKUP function to replace VLOOKUP.mp4
15 MB
221 - Use the XLOOKUP function to replace VLOOKUP.srt
10 kB
222 - Chart display options with blank cells in source data.mp4
10 MB
222 - Chart display options with blank cells in source data.srt
7.7 kB
223 - Adjust Conditional Formatting rules by altering percentage breakpoints.mp4
12 MB
223 - Adjust Conditional Formatting rules by altering percentage breakpoints.srt
8.6 kB
224 - Discover new formula capabilities with new functions and dynamic arrays.mp4
14 MB
224 - Discover new formula capabilities with new functions and dynamic arrays.srt
9.4 kB
225 - Sort or filter data based on color font or cell color background.mp4
24 MB
225 - Sort or filter data based on color font or cell color background.srt
11 kB
226 - Simplify the use of special characters and symbols.mp4
12 MB
226 - Simplify the use of special characters and symbols.srt
10 kB
227 - Select from over 800 icons to enliven worksheets.mp4
16 MB
227 - Select from over 800 icons to enliven worksheets.srt
12 kB
228 - Use the new RANDARRAY function that replaces RAND and RANDBETWEEN.mp4
16 MB
228 - Use the new RANDARRAY function that replaces RAND and RANDBETWEEN.srt
12 kB
229 - How and when to use an area chart.mp4
11 MB
229 - How and when to use an area chart.srt
8.3 kB
230 - Insert colorful images with the People Graph Add-in.mp4
15 MB
230 - Insert colorful images with the People Graph Add-in.srt
11 kB
231 - Use formulas to create interactive charts.mp4
11 MB
231 - Use formulas to create interactive charts.srt
11 kB
232 - Track variables using the Scenario Manager.mp4
16 MB
232 - Track variables using the Scenario Manager.srt
8.0 kB
233 - Get totals quickly without creating formulas.mp4
17 MB
233 - Get totals quickly without creating formulas.srt
9.0 kB
234 - Use column or row references to create dynamic formulas.mp4
13 MB
234 - Use column or row references to create dynamic formulas.srt
7.9 kB
235 - Overcoming obstacles when working with dates in charts.mp4
12 MB
235 - Overcoming obstacles when working with dates in charts.srt
9.6 kB
236 - Create map-type charts based on geographical locations.mp4
9.5 MB
236 - Create map-type charts based on geographical locations.srt
8.3 kB
237 - Techniques for creating date series.mp4
11 MB
237 - Techniques for creating date series.srt
9.0 kB
238 - Extract filtered data with data validation and the FILTER function.mp4
14 MB
238 - Extract filtered data with data validation and the FILTER function.srt
8.1 kB
239 - Use Find and Replace to change cell contents and formats.mp4
22 MB
239 - Use Find and Replace to change cell contents and formats.srt
10 kB
240 - Add formula tools and symbols to the Quick Access Toolbar.mp4
16 MB
240 - Add formula tools and symbols to the Quick Access Toolbar.srt
9.3 kB
241 - Change PivotTable settings for titles and summaries.mp4
17 MB
241 - Change PivotTable settings for titles and summaries.srt
11 kB
242 - Use the Excel filtering capability for dates.mp4
13 MB
242 - Use the Excel filtering capability for dates.srt
8.7 kB
243 - Use worksheet names in formulas.mp4
12 MB
243 - Use worksheet names in formulas.srt
10 kB
244 - Use data validation rules with special phone and social security formats.mp4
13 MB
244 - Use data validation rules with special phone and social security formats.srt
11 kB
245 - Work with time calculations in formulas.mp4
11 MB
245 - Work with time calculations in formulas.srt
8.6 kB
246 - Prevent and locate duplicate worksheet entries.mp4
14 MB
246 - Prevent and locate duplicate worksheet entries.srt
8.3 kB
247 - Look forward and backward using EDATE and other date functions.mp4
16 MB
247 - Look forward and backward using EDATE and other date functions.srt
9.6 kB
248 - Display and highlight worksheet formula cells.mp4
15 MB
248 - Display and highlight worksheet formula cells.srt
10 kB
249 - Split or join columnar data with Text to Columns or Flash Fill.mp4
13 MB
249 - Split or join columnar data with Text to Columns or Flash Fill.srt
8.6 kB
250 - Highlight milestone data with conditional formatting and cumulative formulas.mp4
13 MB
250 - Highlight milestone data with conditional formatting and cumulative formulas.srt
9.8 kB
251 - Use the XMATCH function to replace MATCH.mp4
9.5 MB
251 - Use the XMATCH function to replace MATCH.srt
6.1 kB
252 - Create a powerful macro.mp4
14 MB
252 - Create a powerful macro.srt
8.2 kB
253 - Work with hidden and visible data in filtered and subtotaled lists.mp4
22 MB
253- Work with hidden and visible data in filtered and subtotaled lists.srt
9.9 kB
254 - Use TODAY, NOW, YEARFRAC, and DATEDIF.mp4
16 MB
254 - Use TODAY, NOW, YEARFRAC, and DATEDIF.srt
11 kB
255 - Use data validation rules to prevent duplicate entries in a range.mp4
16 MB
255 - Use data validation rules to prevent duplicate entries in a range.srt
8.4 kB
256 - Use various techniques to hide cells, rows, columns, and worksheets.mp4
18 MB
256 - Use various techniques to hide cells, rows, columns, and worksheets.srt
9.1 kB
257 - Align, arrange, and rotate shapes in worksheets.mp4
17 MB
257 - Align, arrange, and rotate shapes in worksheets.srt
10 kB
258 - File documentation with the Workbook Statistics button.mp4
11 MB
258 - File documentation with the Workbook Statistics button.srt
7.8 kB
259 - Avoid misleading visuals when rescaling.mp4
14 MB
259 - Avoid misleading visuals when rescaling.srt
10 kB
260 - Use the Fill Justify feature to wrap long text.mp4
10 MB
260 - Use the Fill Justify feature to wrap long text.srt
7.3 kB
261 - Create range names from Column and Row headings.mp4
12 MB
261 - Create range names from Column and Row headings.srt
7.1 kB
262 - Use the SUBSTITUTE and REPLACE functions.mp4
14 MB
262 - Use the SUBSTITUTE and REPLACE functions.srt
8.9 kB
263 - Accelerate Conditional Formatting with the Quick Access Toolbar.mp4
14 MB
263 - Accelerate Conditional Formatting with the Quick Access Toolbar.srt
7.7 kB
264 - Use wildcard symbols in functions.mp4
18 MB
264 - Use wildcard symbols in functions.srt
8.9 kB
265 - Use wildcard symbols in filtering and commands.mp4
21 MB
265 - Use wildcard symbols in filtering and commands.srt
11 kB
266 - Condense lengthy nested IF functions with the newer IFS function.mp4
11 MB
266 - Condense lengthy nested IF functions with the newer IFS function.srt
8.2 kB
267 - Add flair to charts with these formatting options Gap width, shadow, glow, 3D, and more.mp4
14 MB
267 - Add flair to charts with these formatting options Gap width, shadow, glow, 3D, and more.srt
12 kB
268 - Control worksheet security by allowing selected users to edit specific cell ranges.mp4
15 MB
268 - Control worksheet security by allowing selected users to edit specific cell ranges.srt
10 kB
269 - Retrieve vital data based on location using the Geography tool.mp4
11 MB
269 - Retrieve vital data based on location using the Geography tool.srt
8.5 kB
270 - Use the new SEQUENCE function to quickly build numeric and date arrays.mp4
11 MB
270 - Use the new SEQUENCE function to quickly build numeric and date arrays.srt
10 kB
271 - Calculating text length and word count with LEN, TRIM, and SUBSTITUTE functions.mp4
14 MB
271 - Calculating text length and word count with LEN, TRIM, and SUBSTITUTE functions.srt
11 kB
272 - Create a list box to facilitate selection of data from a list.mp4
15 MB
272 - Create a list box to facilitate selection of data from a list.srt
10 kB
273 - Use various Excel count functions - COUNT, COUNTA, COUNTBLANK, and more.mp4
15 MB
273 - Use various Excel count functions - COUNT, COUNTA, COUNTBLANK, and more.srt
9.9 kB
274 - Enhance readability with banded rows via conditional formatting.mp4
19 MB
274 - Enhance readability with banded rows via conditional formatting.srt
9.9 kB
275 - Seven different ways to drag data using the Ctrl, Shift, and Alt keys.mp4
17 MB
275 - Seven different ways to drag data using the Ctrl, Shift, and Alt keys.srt
11 kB
276 - Use the SWITCH function - Compare with IFS, CHOOSE, and other lookup functions.mp4
13 MB
276 - Use the SWITCH function - Compare with IFS, CHOOSE, and other lookup functions.srt
11 kB
277 - Adjust charts quickly with quick layout, change colors, and chart styles options.mp4
11 MB
277 - Adjust charts quickly with quick layout, change colors, and chart styles options.srt
9.3 kB
278 - Analyze PivotTable data with 13 different Show Values As options.mp4
22 MB
278 - Analyze PivotTable data with 13 different Show Values As options.srt
8.7 kB
279 - Expand-collapse or sort displayed results when using the SUBTOTAL command.mp4
22 MB
279 - Expand-collapse or sort displayed results when using the SUBTOTAL command.srt
11 kB
280 - Use the AGGREGATE function to circumvent errors and ignore hidden data.mp4
21 MB
280 - Use the AGGREGATE function to circumvent errors and ignore hidden data.srt
10 kB
281 - Use the F9 key to evaluate parts of a formula, recalculate random entries, and control iteration.mp4
18 MB
281 - Use the F9 key to evaluate parts of a formula, recalculate random entries, and control iteration.srt
12 kB
282 - Using last-to-first (bottom-up) searches with XLOOKUP and XMATCH.mp4
14 MB
282 - Using last-to-first (bottom-up) searches with XLOOKUP and XMATCH.srt
8.2 kB
283 - Explore Paste Special options - Skip Blanks, Column Widths, Add, Transpose, and more.mp4
21 MB
283 - Explore Paste Special options - Skip Blanks, Column Widths, Add, Transpose, and more.srt
10 kB
284 - Reduce data entry drudgery with Ctrl+Enter, AutoComplete, and AutoCorrect.mp4
15 MB
284 - Reduce data entry drudgery with Ctrl+Enter, AutoComplete, and AutoCorrect.srt
11 kB
285 - Using the LET function to simplify formulas via programming concepts.mp4
17 MB
285 - Using the LET function to simplify formulas via programming concepts.srt
9.1 kB
286 - Create 51 new US State worksheets, or any multiple cluster of worksheets, in a flash.mp4
14 MB
286 - Create 51 new US State worksheets, or any multiple cluster of worksheets, in a flash.srt
8.1 kB
287 - Create moving averages with formulas and chart trendlines.mp4
17 MB
287 - Create moving averages with formulas and chart trendlines.srt
11 kB
288 - Use error-checking functions in Excel - IFERROR, ISERR, and ISERROR.mp4
20 MB
288 - Use error-checking functions in Excel - IFERROR, ISERR, and ISERROR.srt
11 kB
289 - Use Alt+Enter and Wrap Text for line-wrapping titles and improving formula readability.mp4
14 MB
289 - Use Alt+Enter and Wrap Text for line-wrapping titles and improving formula readability.srt
10 kB
290 - Work with cell colors, patterns, and effects to emphasize data and provide visual flair.mp4
20 MB
290 - Work with cell colors, patterns, and effects to emphasize data and provide visual flair.srt
8.9 kB
291 - Dynamic array formulas, new ways to calculate - One formula displays results in multiple cells.mp4
18 MB
291 - Dynamic array formulas, new ways to calculate - One formula displays results in multiple cells.srt
9.5 kB
292 - Fonts such as Arial and Calibri and a rundown of various available fonts in Excel.mp4
24 MB
292 - Fonts such as Arial and Calibri and a rundown of various available fonts in Excel.srt
13 kB
293 - Use 3D formulas to tabulate data from multiple worksheets with the same layout.mp4
18 MB
293 - Use 3D formulas to tabulate data from multiple worksheets with the same layout.srt
13 kB
294 - Multiple built-in date formats as well as tons of self-defined variations; m_d_y and mmm-d-yyyy.mp4
21 MB
294 - Multiple built-in date formats as well as tons of self-defined variations; m_d_y and mmm-d-yyyy.srt
12 kB
295 - Where does that cell get its data from - Tracking down cell precedents.mp4
16 MB
295 - Where does that cell get its data from - Tracking down cell precedents.srt
7.9 kB
296 - Controlling date entry restrictions using data validation.mp4
10 MB
296 - Controlling date entry restrictions using data validation.srt
7.4 kB
297 - Remove duplicates from a list vs. creating a new list without duplicates.mp4
23 MB
297 - Remove duplicates from a list vs. creating a new list without duplicates.srt
8.5 kB
298 - New data types Extract valuable online data into your worksheets.mp4
16 MB
298 - New data types Extract valuable online data into your worksheets.srt
10 kB
299 - Use the FILTER and UNIQUE functions together for dynamic extractions.mp4
22 MB
299 - Use the FILTER and UNIQUE functions together for dynamic extractions.srt
9.4 kB
300 - Adjusting text entries with the UPPER, LOWER, and PROPER functions.mp4
18 MB
300 - Adjusting text entries with the UPPER, LOWER, and PROPER functions.srt
9.3 kB
301 - Refine filtering needs via custom filter options.mp4
25 MB
301 - Refine filtering needs via custom filter options.srt
11 kB
302 - Comparing column charts and bar charts Pros and cons.mp4
21 MB
303 - How to use exponentiation (powers and roots) in Excel formulas.mp4
17 MB
303 - How to use exponentiation (powers and roots) in Excel formulas.srt
10 kB
304 - Tracking down errors with the ISTEXT, ISNUMBER, and ISNONTEXT functions.mp4
12 MB
304 - Tracking down errors with the ISTEXT, ISNUMBER, and ISNONTEXT functions.srt
8.6 kB
305 - Tips for saving time when typing function names.mp4
24 MB
305 - Tips for saving time when typing function names.srt
13 kB
306 - SUMIFS, SUMPRODUCT, and SUM functions compared and contrasted.mp4
19 MB
306 - SUMIFS, SUMPRODUCT, and SUM functions compared and contrasted.srt
12 kB
307 - Conversion of values into binary, octal, decimal, and hexadecimal equivalents.mp4
15 MB
307 - Conversion of values into binary, octal, decimal, and hexadecimal equivalents.srt
8.5 kB
308 - Quick number formatting with keystroke shortcuts and icon buttons.mp4
30 MB
308 - Quick number formatting with keystroke shortcuts and icon buttons.srt
14 kB
309 - Date calculation and formatting issues related to the 2029-2030 switch.mp4
13 MB
309 - Date calculation and formatting issues related to the 2029-2030 switch.srt
9.2 kB
310 - Using wildcards in the new XLOOKUP and XMATCH functions.mp4
22 MB
310 - Using wildcards in the new XLOOKUP and XMATCH functions.srt
14 kB
311 - Using slicers as analytical tools.mp4
28 MB
311 - Using slicers as analytical tools.srt
12 kB
312 - Conditional formatting using contrasting heat maps on multiple vs.single ranges.mp4
28 MB
312 - Conditional formatting using contrasting heat maps on multiple vs.single ranges.srt
11 kB
313 - Create dynamic pick lists using the UNIQUE and SORT functions, and data validation.mp4
24 MB
313 - Create dynamic pick lists using the UNIQUE and SORT functions, and data validation.srt
12 kB
314 - Contrasting uses of clustered column and stacked column charts.mp4
25 MB
314 - Contrasting uses of clustered column and stacked column charts.srt
14 kB
315 - Use the XLOOKUP function with multiple column criteria and multiple column results.mp4
19 MB
315 - Use the XLOOKUP function with multiple column criteria and multiple column results.srt
8.9 kB
316 - Tips for updating entire columns of date entries when using real or sample data.mp4
13 MB
316 - Tips for updating entire columns of date entries when using real or sample data.srt
8.3 kB
317 - Using TRIM, CLEAN and other functions to clean up text data.mp4
21 MB
317 - Using TRIM, CLEAN and other functions to clean up text data.srt
12 kB
318 - Create multiple range names from the top row and-or left column.mp4
17 MB
318 - Create multiple range names from the top row and-or left column.srt
11 kB
319 - Use dragging techniques to extend dates by weekdays only, month, or year.mp4
10 MB
319 - Use dragging techniques to extend dates by weekdays only, month, or year.srt
7.2 kB
320 - Use the LAMBDA function to create worksheet functions.mp4
16 MB
320 - Use the LAMBDA function to create worksheet functions.srt
12 kB
321 - Get the formula results you want using Goal Seek.mp4
15 MB
321 - Get the formula results you want using Goal Seek.srt
9.1 kB
322 - Sort your data based on a Custom List that you define.mp4
27 MB
322 - Sort your data based on a Custom List that you define.srt
12 kB
323 - Create a dynamic sheet name reference with the INDIRECT function.mp4
13 MB
323 - Create a dynamic sheet name reference with the INDIRECT function.srt
8.7 kB
324 - Calculate dates and-or days of the week for selected future holidays.mp4
12 MB
324 - Calculate dates and-or days of the week for selected future holidays.srt
8.4 kB
325 - Use dragging techniques for faster Paste Special options.mp4
20 MB
325 - Use dragging techniques for faster Paste Special options.srt
10 kB
326 - How to use and not use SS numbers; fake SS numbers; display as XXX-XX-9999.mp4
17 MB
326 - How to use and not use SS numbers; fake SS numbers; display as XXX-XX-9999.srt
9.7 kB
327 - Five indispensable keystroke shortcuts for Windows and Mac users.mp4
17 MB
327 - Five indispensable keystroke shortcuts for Windows and Mac users.srt
11 kB
328 - Using new formula-writing techniques to simplify wide-ranging formulas.mp4
24 MB
328 - Using new formula-writing techniques to simplify wide-ranging formulas.srt
12 kB
329 - Calculate time differences within days and across multiple days.mp4
17 MB
329 - Calculate time differences within days and across multiple days.srt
11 kB
330 - Use keyboard, mouse, and commands to zoom in-out quickly in Excel Windows and Mac versions.mp4
29 MB
330 - Use keyboard, mouse, and commands to zoom in-out quickly in Excel Windows and Mac versions.srt
11 kB
331 - Make dynamic presentations with rapid expand-collapse detail features in outlining.mp4
22 MB
331 - Make dynamic presentations with rapid expand-collapse detail features in outlining.srt
11 kB
332 - Get data analysis suggestions with the Analyze Data (formerly Ideas) tool.mp4
22 MB
332 - Get data analysis suggestions with the Analyze Data (formerly Ideas) tool.srt
11 kB
333 - Using the Distinct vs. Unique options when using the UNIQUE function.mp4
18 MB
333 - Using the Distinct vs. Unique options when using the UNIQUE function.srt
8.7 kB
334 - Use the Screen Snip tool or keystroke shortcut to take a picture of the screen or a portion of it.mp4
19 MB
334 - Use the Screen Snip tool or keystroke shortcut to take a picture of the screen or a portion of it.srt
8.4 kB
335 - Exploring Excel's Sunburst chart to display hierarchical data.mp4
24 MB
335 - Exploring Excel's Sunburst chart to display hierarchical data.srt
11 kB
336 - Creating floating text boxes with shadow, reflection, glow, and other shape effects.mp4
13 MB
336 - Creating floating text boxes with shadow, reflection, glow, and other shape effects.srt
9.2 kB
337 - Page Setup tip Print repeating titles, shrink-to-fit, landscape-portrait, double-spaced layout.mp4
19 MB
337 - Page Setup tip Print repeating titles, shrink-to-fit, landscape-portrait, double-spaced layout.srt
13 kB
338 - Use Data Validation based on multiple criteria.mp4
13 MB
338 - Use Data Validation based on multiple criteria.srt
11 kB
339 - Customize the Quick Access Toolbar using the Alt key or a mouse.mp4.crdownload
11 MB
339 - Customize the Quick Access Toolbar using the Alt key or a mouse.srt
11 kB
340 - Exploring treemap charts to display hierarchical data.mp4
23 MB
340 - Exploring treemap charts to display hierarchical data.srt
12 kB
341 - Use the Quick Analysis tool for easy access to power tools.mp4
13 MB
341 - Use the Quick Analysis tool for easy access to power tools.srt
7.3 kB
342 - Create a number series with the Ctrl key and left-right mouse button.mp4
18 MB
342 - Create a number series with the Ctrl key and left-right mouse button.srt
12 kB
343 - Combine IF, MAX, VALUE, and COUNTIF functions to analyze sales.mp4
14 MB
343 - Combine IF, MAX, VALUE, and COUNTIF functions to analyze sales.srt
9.1 kB
344 - Unhide multiple worksheets at once and use the very hidden option.mp4
19 MB
344 - Unhide multiple worksheets at once and use the very hidden option.srt
9.7 kB
345 - Use the Fill Justify command to quickly rewrap text into different cells.mp4
10 MB
345 - Use the Fill Justify command to quickly rewrap text into different cells.srt
7.0 kB
346 - Create a 15th day or end-of-month series and adjust to weekdays only.mp4
11 MB
346 - Create a 15th day or end-of-month series and adjust to weekdays only.srt
8.8 kB
347 - Use the Go To Special option to select and populate blank cells.mp4
21 MB
347 - Use the Go To Special option to select and populate blank cells.srt
11 kB
348 - Accentuate values with conditional formatting and sparklines.mp4
20 MB
348 - Accentuate values with conditional formatting and sparklines.srt
12 kB
349 - Transpose data with formula substitution and the TRANSPOSE function.mp4
16 MB
349 - Transpose data with formula substitution and the TRANSPOSE function.srt
8.8 kB
350 - Use emojis and other symbols in formulas and charts.mp4
20 MB
350 - Use emojis and other symbols in formulas and charts.srt
11 kB
351 - Use the Advanced Filter for specialized filtering needs.mp4
22 MB
351 - Use the Advanced Filter for specialized filtering needs.srt
11 kB
352 - Combo charts Combine different chart types to present data more clearly.mp4
16 MB
352 - Combo charts Combine different chart types to present data more clearly.srt
12 kB
353 - Combining the SEQUENCE, LEN, and MID functions to extract data into multiple cells.mp4
20 MB
353 - Combining the SEQUENCE, LEN, and MID functions to extract data into multiple cells.srt
12 kB
354 - Exploring Edit Default Layout options when using PivotTables.mp4
16 MB
354 - Exploring Edit Default Layout options when using PivotTables.srt
8.1 kB
355 - Navigation tips Shortcuts to jump within and between worksheets and workbooks.mp4
26 MB
355 - Navigation tips Shortcuts to jump within and between worksheets and workbooks.srt
12 kB
Exercise Files/123_Book1.zip
460 kB
Exercise Files/124_Quick_Charts.zip
862 kB
Exercise Files/125_Heat_Maps.zip
51 kB
Exercise Files/126_INDEX_Function.zip
492 kB
Exercise Files/127_Display_Tips.zip
334 kB
Exercise Files/128_Wrap_text_Merge_Indent.zip
60 kB
Exercise Files/129_Fill_Effects.zip
25 kB
Exercise Files/130_Multiple_Worksheets.zip
17 kB
Exercise Files/131_Other_Font_Options.zip
367 kB
Exercise Files/132_WordArt_Variations.zip
426 kB
Exercise Files/133_Weekday_Weekend.zip
512 kB
Exercise Files/134_Two_Way_Lookups.zip
361 kB
Exercise Files/135_Borders_Gridlines.zip
438 kB
Exercise Files/149_Decimals_and_Fractions.zip
26 kB
Exercise Files/150_Mixed_References.zip
65 kB
Exercise Files/151_Chart_gridlines_and_borders.zip
64 kB
Exercise Files/152_INDIRECT_Intersection_RangeNames.zip
19 kB
Exercise Files/153_Expand_Collapse_PivotTables.zip
123 kB
Exercise Files/154_Phone_and_ZipCode_Formats.zip
13 kB
Exercise Files/155_Default_Chart_Type_and_Chart_Templates.zip
40 kB
Exercise Files/156_Date_Time_Formats.zip
120 kB
Exercise Files/157_Comments_and_Reminders.zip
183 kB
Exercise Files/158_Replace_Format_or_Content.zip
155 kB
Exercise Files/159_Number_Formats.zip
41 kB
Exercise Files/160_Date_Format_Conversions.zip
134 kB
Exercise Files/161_Custom_Lists.zip
118 kB
Exercise Files/162_Freeze_Panes_and_Split_Screens.zip
115 kB
Exercise Files/163_NETWORKDAYS_and_WORKDAY.zip
27 kB
Exercise Files/164_Percent_change_and_Goal_Seek.zip
22 kB
Exercise Files/165_Fill_in_Blanks.zip
153 kB
Exercise Files/166_COUNT_COUNTA_and_Status_Bar.zip
144 kB
Exercise Files/167_Excel_Sheet_Commands.zip
219 kB
Exercise Files/168_Ranking_Data.zip
58 kB
Exercise Files/169_PivotTable_Date_Grouping.zip
151 kB
Exercise Files/170_Unique_and_Duplicate_Data.zip
211 kB
Exercise Files/171_Zoom_and_Display_Variations.zip
259 kB
Exercise Files/172_Abstract_Art_with_Random_Numbers_and_Excel_Charts.zip
73 kB
Exercise Files/173_YEAR_MONTH_DAY_WEEKDAY.zip
226 kB
Exercise Files/174_EXACT_FIND_SEARCH_Functions.zip
16 kB
Exercise Files/175_ROMAN_ARABIC.zip
20 kB
Exercise Files/176_Range_Names.zip
165 kB
Exercise Files/177_Customize_the_Quick_Access_Toolbar.zip
60 kB
Exercise Files/178_Adjusting_Names.zip
19 kB
Exercise Files/179_Date_Proximity_Formatting_final.zip
19 kB
Exercise Files/180_Table_Differences.zip
237 kB
Exercise Files/181_Avoiding_DIV_Error.zip
30 kB
Exercise Files/182_FormattingOptions.zip
238 kB
Exercise Files/183_New_Table_Style.zip
123 kB
Exercise Files/184_Date_Calculations.zip
128 kB
Exercise Files/185_Unintentional_Entries.zip
7.6 kB
Exercise Files/186_Sort_by_Moving_Columns.zip
39 kB
Exercise Files/187_Cumulative_Totals.zip
12 kB
Exercise Files/188_CONVERT_Function.zip
9.5 kB
Exercise Files/189_Alt_Key_Shortcuts.zip
25 kB
Exercise Files/189_Chart_based_on_a_Table.zip
6.5 kB
Exercise Files/190_Solver.zip
9.0 kB
Exercise Files/191_Columns_Widths.zip
14 kB
Exercise Files/192_PivotTable_Settings.zip
67 kB
Exercise Files/194_LEN_and_REPT.zip
39 kB
Exercise Files/194_Watch_Window.zip
105 kB
Exercise Files/195_TRIM_and_CLEAN.zip
75 kB
Exercise Files/196_Double_and_Triple_Spaced_Printing.zip
147 kB
Exercise Files/197_Helpful_Keystroke_Shortcuts.zip
306 kB
Exercise Files/198_Weekdays_and_Weekends.zip
248 kB
Exercise Files/199_Charts_and_Filters.zip
16 kB
Exercise Files/200_Linking_Pictures.zip
66 kB
Exercise Files/201_Error_Checking_Indicators.zip
316 kB
Exercise Files/202_Worksheet_Protection.zip
56 kB
Exercise Files/203_Mixed_Cell_Addresses.zip
18 kB
Exercise Files/204_Filter_by_Selection.zip
73 kB
Exercise Files/205_Displaying_Large_Values.zip
33 kB
Exercise Files/206_ConditionalFormatting_and_DataValidation.zip
107 kB
Exercise Files/207_CheckBox_ConditionalFormatting.zip
107 kB
Exercise Files/208_Transpose.zip
16 kB
Exercise Files/209_Borders_Gridlines_Printing.zip
16 kB
Exercise Files/210_SmartArt.zip
17 kB
Exercise Files/211_GoTo_Special.zip
406 kB
Exercise Files/212_CEILINGandFLOOR.zip
10 kB
Exercise Files/213_Shapes_and_Stars.zip
16 kB
Exercise Files/214_Array_Constants_withVLOOKUP.zip
15 kB
Exercise Files/215_AdvancedFilter.zip
345 kB
Exercise Files/216_ArrayFormulaUpdates.zip
128 kB
Exercise Files/217_UNIQUE_function.zip
41 kB
Exercise Files/218_Sample_Data.zip
51 kB
Exercise Files/219_Utility_Macros.zip
17 kB
Exercise Files/220_SORT_and_SORTBY_Functions.zip
63 kB
Exercise Files/221_Themes.zip
40 kB
Exercise Files/222_Financial_Functions.zip
9.0 kB
Exercise Files/223_BlankCellsInCharts.zip
333 kB
Exercise Files/224_CondFormattingBreakpoints.zip
21 kB
Exercise Files/225_New_Formulas.zip
45 kB
Exercise Files/226_Sort_by_Color.zip
74 kB
Exercise Files/227_Special_Characters.zip
13 kB
Exercise Files/228_Icons.zip
42 kB
Exercise Files/229_Random_Functions.zip
13 kB
Exercise Files/230_Area_Charts.zip
8.7 kB
Exercise Files/231_People_Graph.zip
59 kB
Exercise Files/232_GrowingChart.zip
14 kB
Exercise Files/233_ScenarioManager.zip
27 kB
Exercise Files/234_Status_Bar.zip
65 kB
Exercise Files/235_Columns_and_Rows.zip
60 kB
Exercise Files/236_Dates_in_Charts.zip
10 kB
Exercise Files/237_Geographic_Maps.zip
8.1 kB
Exercise Files/238_Date_Time_Series.zip
16 kB
Exercise Files/239_Data_Validation_and_Filter.zip
70 kB
Exercise Files/240_Find_Select.zip
158 kB
Exercise Files/241_AverageCountSubscript.zip
57 kB
Exercise Files/242_CopyFormats.zip
23 kB
Exercise Files/243_XLOOKUP_Function.zip
165 kB
Exercise Files/244_PivotTable_Settings.zip
46 kB
Exercise Files/245_FilterYearDay.zip
28 kB
Exercise Files/246_Sheet_Names.zip
74 kB
Exercise Files/247_Phone_ZipFormats.zip
9.0 kB
Exercise Files/248_Time_Math.zip
48 kB
Exercise Files/249_Prevent_Locate_Duplicates.zip
78 kB
Exercise Files/250_EDate_EMonth_DatedIF.zip
129 kB
Exercise Files/251_Find_Highlight_Formula_cells.zip
16 kB
Exercise Files/252_Text_Columns_Flash_Fill.zip
11 kB
Exercise Files/253_Cumulative_Formulas.zip
9.6 kB
Exercise Files/254_XMATCH_Function.zip
38 kB
Exercise Files/255_Hidden_Visible_Data.zip
85 kB
Exercise Files/256_Macro_Highlight_Formula_Cells.zip
17 kB
Exercise Files/257_TODAY_NOW_Date_Functions.zip
57 kB
Exercise Files/258_Prevent_Duplicates.zip
49 kB
Exercise Files/259_Hide_cells_rows_columns_sheets.zip
173 kB
Exercise Files/260_Align_Arrange_Rotate_Shapes.zip
18 kB
Exercise Files/261_Worksheet_Statistics.zip
427 kB
Exercise Files/262_Re_scaling_Column_and_Line_Charts.zip
57 kB
Exercise Files/263_Fill_Justify_Wrap_Text.zip
9.3 kB
Exercise Files/264_Names_Based_On_Column_Row_Headings.zip
9.9 kB
Exercise Files/265_SUBSTITUTE_and_REPLACE_Functions.zip
63 kB
Exercise Files/266_Buttons_for_Conditional_Formatting.zip
191 kB
Exercise Files/267_Wildcards_Part_1_Filter_and_Commands.zip
28 kB
Exercise Files/268_Wildcards_Part_2_Functions_.zip
293 kB
Exercise Files/269_IFS_Function.zip
121 kB
Exercise Files/26_02_Powers_and_Roots.zip
24 kB
Exercise Files/26_03_ISTEXT_ISNUMBER_ISNONTEXT.zip
458 kB
Exercise Files/26_04_Function_Names.zip
101 kB
Exercise Files/26_05_SUM_SUMPRODUCT_SUMIF.zip
1.3 MB
Exercise Files/26_06_Binary_Octal_Decimal_Hexadecimal.zip
39 kB
Exercise Files/26_07_Numeric_Formatting.zip
20 kB
Exercise Files/26_08_Dates_and_the_1930_2029_split.zip
12 kB
Exercise Files/26_09_Wildcard_lookups_XLOOKUP_and_XMATCH.zip
95 kB
Exercise Files/26_10_Slicers_Analysis.zip
130 kB
Exercise Files/26_11_Heat_Maps.zip
58 kB
Exercise Files/26_12_Validation_with_UNIQUE_and_SORT_functions.zip
58 kB
Exercise Files/26_13_Clustered_vs_Stacked_Chart_Types.zip
42 kB
Exercise Files/270_Chart_Formatting_Gap_Width_Shadow_Glow_3D.zip
30 kB
Exercise Files/271_Protect_Cell_Ranges.zip
56 kB
Exercise Files/272_Geography_Data.zip
16 kB
Exercise Files/273_SEQUENCE_function.zip
438 kB
Exercise Files/274_LEN_SUBSTITUTE_and_TRIM_functions.zip
14 kB
Exercise Files/275_List_Box.zip
127 kB
Exercise Files/276_COUNT_COUNTA_and_COUNTBLANK_functions.zip
52 kB
Exercise Files/277_Banded_Rows_or_Columns.zip
182 kB
Exercise Files/278_Dragging_cells_with_Ctrl_Shift_and_Alt_Keys.zip
81 kB
Exercise Files/279_SWITCH_function.zip
21 kB
Exercise Files/27_01_XLOOKUP.zip
160 kB
Exercise Files/27_02_Update_Date_Entries.zip
115 kB
Exercise Files/27_03_Eliminate_Spaces_and_Special_Characters.zip
17 kB
Exercise Files/27_04_Create_Range_Names_From_Headings.zip
20 kB
Exercise Files/27_05_Date_Series_Creation.zip
12 kB
Exercise Files/27_06_LAMBDA_Function.zip
71 kB
Exercise Files/27_07_Goal_Seek.zip
309 kB
Exercise Files/27_08_Sort_by_Custom_List.zip
80 kB
Exercise Files/27_09_INDIRECT_function.zip
25 kB
Exercise Files/27_10_Holiday_Calculations.zip
21 kB
Exercise Files/27_11_Paste_Special_Drag_Options.zip
293 kB
Exercise Files/27_12_SS_Numbers.zip
94 kB
Exercise Files/280_Chart_Design_Tools.zip
27 kB
Exercise Files/281_PivotTable_Analysis.zip
78 kB
Exercise Files/282_Subtotal.zip
120 kB
Exercise Files/283_AGGREGATE_Function.zip
235 kB
Exercise Files/284_The_F9_Key.zip
21 kB
Exercise Files/285_XLOOKUP_XMATCH.zip
77 kB
Exercise Files/286_Paste_Special_Options.zip
62 kB
Exercise Files/287_Data_Entry_Tips.zip
13 kB
Exercise Files/288_LET_function.zip
37 kB
Exercise Files/289_Create_Worksheets_Fast.zip
13 kB
Exercise Files/28_01_Five_Invaluable_Keystroke_Shortcuts.zip
164 kB
Exercise Files/28_02_New_Formula_Techniques.zip
263 kB
Exercise Files/28_03_Time_differencees.zip
47 kB
Exercise Files/28_04_Zoom_Techniques.zip
79 kB
Exercise Files/28_05_Outlining_Tools.zip
202 kB
Exercise Files/28_06_Analyze_Data.zip
253 kB
Exercise Files/28_07_UNIQUE_Unique_vs_Distinct.zip
50 kB
Exercise Files/28_08_Screen_Snip.zip
1.1 MB
Exercise Files/28_09_Sunburst_Charts.zip
651 kB
Exercise Files/28_10_Shadow_Glow_Reflection.zip
835 kB
Exercise Files/28_11_Printing_Tips.zip
77 kB
Exercise Files/290_MovingAverage.zip
36 kB
Exercise Files/291_Error_Checking_Functions.zip
15 kB
Exercise Files/292_Line_Wrap_and_Wrap_Text.zip
20 kB
Exercise Files/293_Cell_Colors_Patterns_Effects.zip
27 kB
Exercise Files/294_Dynamic_Arrays.zip
51 kB
Exercise Files/295_Fonts.zip
74 kB
Exercise Files/296_3D_Formulas.zip
20 kB
Exercise Files/297_Date_Formats.zip
14 kB
Exercise Files/298_Cell_Precedents.zip
31 kB
Exercise Files/299_Date_Controls_with_Data_Validation.zip
17 kB
Exercise Files/29_01_Data_Validation_Multiple_Criteria.zip
15 kB
Exercise Files/29_02_Quick_Access_Toolbar_QAT_Tips.zip
36 kB
Exercise Files/29_03_Treemap_Charts.zip
651 kB
Exercise Files/29_04_Quick_Analysis_Button.zip
168 kB
Exercise Files/29_05_Dragging_Number_Cells.zip
13 kB
Exercise Files/29_06_Analyze_Sales_using_the_IF_MAX_and_COUNTIF_functions.zip
22 kB
Exercise Files/29_07_Hide_Unhide_Worksheets.zip
602 kB
Exercise Files/29_08_Fill_Justify_Re_wrap_text.zip
18 kB
Exercise Files/29_09_Date_Series_15th_and_Month_End.zip
11 kB
Exercise Files/29_10_Filling_Blank_Cells.zip
104 kB
Exercise Files/29_11_Sparklines_and_Conditional_Formatting.zip
16 kB
Exercise Files/29_12_Transpose.zip
23 kB
Exercise Files/300_Managing_Duplicate_Data.zip
176 kB
Exercise Files/301_New_Data_Types.zip
315 kB
Exercise Files/302_FILTER_and_UNIQUE_functions.zip
55 kB
Exercise Files/303_UPPER_lower_Proper.zip
13 kB
Exercise Files/304_Custom_Filter.zip
78 kB
Exercise Files/30_01_Emojis_and_Pictures.zip
399 kB
Exercise Files/30_02_Advanced_Filter.zip
170 kB
Exercise Files/30_03_Combo_Charts.zip
14 kB
Exercise Files/30_04_MID_SEQUENCE_LEN_Functions.zip
478 kB
Exercise Files/30_05_PivotTable_Settings.zip
77 kB
Exercise Files/30_06_Navigation.zip
555 kB
Exercise Files/Ex_Files_Excel_Tips_Weekly_2018_Q1.zip
1.1 MB
Exercise Files/Ex_Files_Excel_Tips_Weekly_2018_Q2.zip
1.5 MB
Exercise Files/Ex_Files_Excel_Tips_Weekly_2018_Q3.zip
1.5 MB