|
LinkedIn Learning Excel Tips Weekly Update 20190716\01.Excel Tips - New This Week\01.01.Use the new SORT and SORTBY functions to extract sorted lists.Update 20190716.mp4
[87fc8056a709b4f6]
|
18,557,789 |
F7A286E9 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\01.Excel Tips - New This Week\01.01.Use the new SORT and SORTBY functions to extract sorted lists.Update 20190716.srt |
10,074 |
76B540F7 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.002.Hide and unhide worksheets securely.Update 20190716.mp4
[fff387533275d0bd]
|
17,836,183 |
36B7500B |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.002.Hide and unhide worksheets securely.Update 20190716.srt |
13,078 |
06CAF037 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.003.Resizing, moving, copying, and manipulating charts and other objects.Update 20190716.mp4
[9b111aabcef2e4b6]
|
29,198,654 |
27ECB8AF |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.003.Resizing, moving, copying, and manipulating charts and other objects.Update 20190716.srt |
19,843 |
80D88A45 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.004.Using list boxes and combo boxes to facilitate forms creation.Update 20190716.mp4
[ed148f9620d1afe9]
|
22,524,042 |
C7FD7552 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.004.Using list boxes and combo boxes to facilitate forms creation.Update 20190716.srt |
15,214 |
0069EC63 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.005.Using the FORMULATEXT and N functions for worksheet and formula documentation.Update 20190716.mp4
[a0a47978a769845e]
|
17,201,386 |
0BB94A73 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.005.Using the FORMULATEXT and N functions for worksheet and formula documentation.Update 20190716.srt |
11,211 |
05F9A04C |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.006.Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells.Update 20190716.mp4
[ee5e346a3f444361]
|
24,908,759 |
FE704CBB |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.006.Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells.Update 20190716.srt |
15,412 |
36BE5E7F |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.007.Summarizing data from diverse ranges with Data Consolidate.Update 20190716.mp4
[6ab95e94f626bf54]
|
30,832,745 |
11D384A1 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.007.Summarizing data from diverse ranges with Data Consolidate.Update 20190716.srt |
18,864 |
3AF3C012 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.008.Using check boxes and Conditional Formatting together for dynamic displays.Update 20190716.mp4
[221948a392a50766]
|
42,415,863 |
66EB9D30 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.008.Using check boxes and Conditional Formatting together for dynamic displays.Update 20190716.srt |
23,886 |
52B3B1BF |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.009.Becoming more productive with these 10 tiny tips you'll use often.Update 20190716.mp4
[711da0842d1f923c]
|
25,268,551 |
47BEC152 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.009.Becoming more productive with these 10 tiny tips you'll use often.Update 20190716.srt |
17,097 |
887F2C24 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.010.Transposing data and charts for a different perspective on your data.Update 20190716.mp4
[cf835571d05ecc67]
|
31,770,569 |
E9B3882D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.010.Transposing data and charts for a different perspective on your data.Update 20190716.srt |
17,555 |
55E40739 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.011.Applying conditional formatting across rows of data.Update 20190716.mp4
[bac1920804c06d2]
|
21,445,666 |
E1922B7E |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.011.Applying conditional formatting across rows of data.Update 20190716.srt |
12,727 |
5D331458 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.012.Exploring various layouts for your PivotTable.Update 20190716.mp4
[71d5f69691a4f757]
|
14,533,790 |
94406C5F |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.012.Exploring various layouts for your PivotTable.Update 20190716.srt |
8,831 |
54BA83FB |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.013.Splitting and consolidating workbooks.Update 20190716.mp4
[393310d29c58b730]
|
21,523,596 |
BDC25E6E |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.013.Splitting and consolidating workbooks.Update 20190716.srt |
13,573 |
791CAB0E |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.014.Using date and time as metrics in a PivotTable.Update 20190716.mp4
[b5cad309416cd2b7]
|
24,322,134 |
464CC056 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.014.Using date and time as metrics in a PivotTable.Update 20190716.srt |
14,019 |
EC0709A2 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.015.Adding illustrations to your workbook.Update 20190716.mp4
[754fa464576e60f1]
|
35,255,803 |
9774663A |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.015.Adding illustrations to your workbook.Update 20190716.srt |
23,956 |
F5572DB3 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.016.Using Pick list, VLOOKUP, Table, and Chart together.Update 20190716.mp4
[1ed813cd70f685da]
|
23,669,034 |
A65A4AD0 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.016.Using Pick list, VLOOKUP, Table, and Chart together.Update 20190716.srt |
16,869 |
C8B54496 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.017.Using formulas to calculate values across worksheets and workbooks.Update 20190716.mp4
[54b78ed578f502e8]
|
30,949,502 |
5BD6EDF5 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.017.Using formulas to calculate values across worksheets and workbooks.Update 20190716.srt |
23,601 |
4C1AD311 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.018.Dynamically presenting data via chart slicers.Update 20190716.mp4
[1b9b2bfd61101d52]
|
21,416,319 |
9990A782 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.018.Dynamically presenting data via chart slicers.Update 20190716.srt |
15,118 |
B095FA6C |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.019.Parsing your data to create unique lists.Update 20190716.mp4
[6351d358282f4f62]
|
15,211,118 |
5E779D83 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.019.Parsing your data to create unique lists.Update 20190716.srt |
6,865 |
75BF3811 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.020.Using the REPT function to represent data visually.Update 20190716.mp4
[52da56386077887a]
|
9,250,793 |
3F36674B |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.020.Using the REPT function to represent data visually.Update 20190716.srt |
6,173 |
7404FCDD |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.021.Using source data from a table to make your PivotTable more dynamic.Update 20190716.mp4
[196efabb1fdd8f4b]
|
26,170,822 |
3DBC2BC3 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.021.Using source data from a table to make your PivotTable more dynamic.Update 20190716.srt |
15,296 |
BEAA0701 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.022.Accelerating Cut, Copy, Paste, and Insert tasks.Update 20190716.mp4
[6b80a406cd921770]
|
24,374,489 |
6F5E2679 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.022.Accelerating Cut, Copy, Paste, and Insert tasks.Update 20190716.srt |
15,880 |
F793F7F7 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.023.Increasing your productivity with custom lists.Update 20190716.mp4
[d13ea94a656cecde]
|
21,907,915 |
DBB829DC |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.023.Increasing your productivity with custom lists.Update 20190716.srt |
9,893 |
57760E45 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.024.Highlighting PivotTable results with conditional formatting.Update 20190716.mp4
[5314f15d8e8cbe0a]
|
20,160,632 |
1E98DD7C |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.024.Highlighting PivotTable results with conditional formatting.Update 20190716.srt |
12,267 |
D5B5BAF9 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.025.Customizing templates to fit your unique needs.Update 20190716.mp4
[f6161a526e86a133]
|
21,359,306 |
53537E87 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.025.Customizing templates to fit your unique needs.Update 20190716.srt |
12,893 |
DA211D3A |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.026.Creating dynamic charts with in-cell conditional formatting.Update 20190716.mp4
[79c717dcd8135245]
|
12,043,955 |
3E6B99D7 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.026.Creating dynamic charts with in-cell conditional formatting.Update 20190716.srt |
6,722 |
6318C4D8 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.027.Enhancing table filtering with slicers.Update 20190716.mp4
[5e4fc7a22008a888]
|
21,171,872 |
1303C1EB |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.027.Enhancing table filtering with slicers.Update 20190716.srt |
10,712 |
C6E171BE |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.028.Converting charts into pictures.Update 20190716.mp4
[5f0feefb658454ab]
|
16,699,301 |
EE75FC3B |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.028.Converting charts into pictures.Update 20190716.srt |
9,377 |
E34D0624 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.029.Custom grouping in PivotTables.Update 20190716.mp4
[b30cd1a2aa7f5d0e]
|
13,623,888 |
7F08A667 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.029.Custom grouping in PivotTables.Update 20190716.srt |
9,103 |
FBE83F9A |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.030.Quick formatting tips.Update 20190716.mp4
[c46efab53d954642]
|
24,532,124 |
7D53AEDA |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.030.Quick formatting tips.Update 20190716.srt |
15,610 |
E9FECEE7 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.031.The top five unknown but useful keyboard shortcuts.Update 20190716.mp4
[4048a71eebc99b62]
|
26,852,720 |
C43E2867 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.031.The top five unknown but useful keyboard shortcuts.Update 20190716.srt |
12,307 |
EABA4084 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.032.Using the TREND and GROWTH functions for projecting future results.Update 20190716.mp4
[9b917a67be8da7e3]
|
22,663,256 |
346CA3AC |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.032.Using the TREND and GROWTH functions for projecting future results.Update 20190716.srt |
10,553 |
6654759B |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.033.Using scroll bars and spin buttons to facilitate forms creation.Update 20190716.mp4
[d7fa7c59f9f15830]
|
24,699,431 |
91F715A8 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.033.Using scroll bars and spin buttons to facilitate forms creation.Update 20190716.srt |
19,554 |
BF2C6283 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.034.Creating colorful 3D buttons for worksheet annotation and macro buttons.Update 20190716.mp4
[ad358623cf4bc79a]
|
22,943,806 |
EF004941 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.034.Creating colorful 3D buttons for worksheet annotation and macro buttons.Update 20190716.srt |
12,660 |
40E28118 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.035.Calculating with hours, minutes, and times of day.Update 20190716.mp4
[a833542e462cdcf1]
|
31,098,376 |
A7E320A7 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.035.Calculating with hours, minutes, and times of day.Update 20190716.srt |
19,328 |
5BCD0F61 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.036.Tracking down cell dependencies across multiple worksheets and workbooks.Update 20190716.mp4
[2db9d89303442c8b]
|
22,797,429 |
CAEEDC47 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.036.Tracking down cell dependencies across multiple worksheets and workbooks.Update 20190716.srt |
11,708 |
9578AEAA |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.037.Discovering time-saving tools in the Go To Special feature.Update 20190716.mp4
[177dfaccc957e687]
|
41,989,599 |
F19F73E5 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.037.Discovering time-saving tools in the Go To Special feature.Update 20190716.srt |
21,012 |
EEBA1E9A |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.038.Adding, managing, and printing comments for worksheet documentation.Update 20190716.mp4
[ab05aef0ac070c3]
|
20,194,284 |
88D134A2 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.038.Adding, managing, and printing comments for worksheet documentation.Update 20190716.srt |
14,158 |
82BAE45A |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.039.Reducing data entry time by expanding AutoCorrect options.Update 20190716.mp4
[22f02e88da46ea1a]
|
19,910,069 |
83031CD8 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.039.Reducing data entry time by expanding AutoCorrect options.Update 20190716.srt |
11,740 |
EEF795A7 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.040.Setting up custom views for quick access to different worksheet displays.Update 20190716.mp4
[9963f032b24947e5]
|
26,297,633 |
B08D95F4 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.040.Setting up custom views for quick access to different worksheet displays.Update 20190716.srt |
11,874 |
0D85ABAC |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.041.Using hyperlinks for rapidly switching worksheet locations and jumping to websites.Update 20190716.mp4
[d50e2075524fd77a]
|
22,182,160 |
57F78D0B |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.041.Using hyperlinks for rapidly switching worksheet locations and jumping to websites.Update 20190716.srt |
14,364 |
974F03EF |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.042.Controlling worksheet security by allowing selected users to edit specific cell ranges.Update 20190716.mp4
[835fb5c902b3c2c5]
|
25,353,967 |
88089EFC |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.042.Controlling worksheet security by allowing selected users to edit specific cell ranges.Update 20190716.srt |
13,551 |
AF582AE3 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.043.Using option buttons, group boxes, and checkboxes to facilitate forms creation.Update 20190716.mp4
[e3746b70c52073f3]
|
20,896,333 |
D5D7BA50 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.043.Using option buttons, group boxes, and checkboxes to facilitate forms creation.Update 20190716.srt |
15,154 |
CE0898F9 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.044.Exploring what-if scenarios using Goal Seek.Update 20190716.mp4
[889ac75f5fa4a710]
|
29,400,568 |
114DB7E7 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.044.Exploring what-if scenarios using Goal Seek.Update 20190716.srt |
16,885 |
C9310EDC |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.045.Creating text, numerical, date, and time lists in a flash.Update 20190716.mp4
[8c270156363178ca]
|
18,759,467 |
FADCC6E2 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.045.Creating text, numerical, date, and time lists in a flash.Update 20190716.srt |
12,974 |
FB5D6CAF |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.046.Creating Variable Conditional Formatting Rules.Update 20190716.mp4
[c07a7221d79181c0]
|
32,293,157 |
A1204946 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.046.Creating Variable Conditional Formatting Rules.Update 20190716.srt |
15,130 |
44424E81 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.047.Handling Dates with unusual formats.Update 20190716.mp4
[20668c56d648d227]
|
21,233,139 |
2C22FC16 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.047.Handling Dates with unusual formats.Update 20190716.srt |
11,508 |
BDAD2292 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.048.Using wildcards (asterisk, tilde, and question mark).Update 20190716.mp4
[e99075457fe4899e]
|
39,981,669 |
D6E44734 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.048.Using wildcards (asterisk, tilde, and question mark).Update 20190716.srt |
18,320 |
9B071FB9 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.049.Custom formats using asterisk, semicolon, and brackets.Update 20190716.mp4
[e162e014da5674ef]
|
41,086,644 |
8F567CBB |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.049.Custom formats using asterisk, semicolon, and brackets.Update 20190716.srt |
23,490 |
7E983B33 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.050.Meeting unusual filtering needs via Advanced Filter.Update 20190716.mp4
[1499c528af8579ff]
|
49,998,914 |
E0C3CC90 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.050.Meeting unusual filtering needs via Advanced Filter.Update 20190716.srt |
23,277 |
2588D498 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.051.Create an Organization Chart.Update 20190716.mp4
[c467bd76016bfd42]
|
24,789,500 |
121CE412 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.051.Create an Organization Chart.Update 20190716.srt |
18,015 |
87BAC50D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.052.Two-way lookup using the MATCH and INDEX functions.Update 20190716.mp4
[37275c2c353ed4ee]
|
53,146,845 |
99011D7E |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.052.Two-way lookup using the MATCH and INDEX functions.Update 20190716.srt |
22,818 |
7B7CEB9C |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.053.Using Excel's error-checking functions.Update 20190716.mp4
[5557eb4f62a52828]
|
35,268,276 |
2F150A72 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.053.Using Excel's error-checking functions.Update 20190716.srt |
21,315 |
D3FD5955 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.054.Custom formats, relative addressing, and conditional formatting.Update 20190716.mp4
[cd03f1c20ba0e4eb]
|
25,110,401 |
1ACA46B9 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.054.Custom formats, relative addressing, and conditional formatting.Update 20190716.srt |
16,239 |
139E1801 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.055.Auditing.Update 20190716.mp4
[b492f0d2c0c985f]
|
32,147,216 |
182C94EE |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.055.Auditing.Update 20190716.srt |
18,894 |
3D7E68A0 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.056.Adding comments and shapes.Update 20190716.mp4
[a59c5842234b9ddc]
|
26,665,786 |
98049B6D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.056.Adding comments and shapes.Update 20190716.srt |
16,481 |
039B66C9 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.057.Drawing borders and border grids.Update 20190716.mp4
[2930d939aa4b4d7a]
|
22,395,195 |
31B24AEE |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.057.Drawing borders and border grids.Update 20190716.srt |
13,165 |
F4CDA3F8 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.058.Building a flexible monthly table using functions.Update 20190716.mp4
[a2843ce5b9bdaa4a]
|
34,401,345 |
4EB68948 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.058.Building a flexible monthly table using functions.Update 20190716.srt |
24,682 |
1BBF8E6E |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.059.Adding pictures as worksheet backgrounds.Update 20190716.mp4
[d28943360c9dbac]
|
21,020,609 |
D3E6C797 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.059.Adding pictures as worksheet backgrounds.Update 20190716.srt |
10,813 |
7F8CC702 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.060.ADDRESS, ROW, and COLUMN functions.Update 20190716.mp4
[e7a293ea27852b97]
|
29,009,645 |
DA1B6270 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.060.ADDRESS, ROW, and COLUMN functions.Update 20190716.srt |
16,646 |
E16E43FC |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.061.Join data with new CONCAT and TEXTJOIN functions.Update 20190716.mp4
[2b372acf5e046907]
|
18,420,733 |
13FCBDEC |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.061.Join data with new CONCAT and TEXTJOIN functions.Update 20190716.srt |
12,014 |
0DCBA329 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.062.Working with formulas in tables.Update 20190716.mp4
[79fa780a5f7b870b]
|
50,484,062 |
D12B4C42 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.062.Working with formulas in tables.Update 20190716.srt |
29,274 |
444C7E9E |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.063.Locating Data Validation rules and violations.Update 20190716.mp4
[dce3576fffb3a0a8]
|
29,929,719 |
ADB683F5 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.063.Locating Data Validation rules and violations.Update 20190716.srt |
15,465 |
8B38BB63 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.064.Creating an Excel template.Update 20190716.mp4
[a29c73979bf1aaf5]
|
24,309,579 |
6688F967 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.064.Creating an Excel template.Update 20190716.srt |
16,941 |
5E7D8CB5 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.065.Restoring missing column titles.Update 20190716.mp4
[4501f52ef195c19b]
|
27,647,140 |
F336492F |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.065.Restoring missing column titles.Update 20190716.srt |
14,203 |
4D8954D7 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.066.Creating a pick list dependent on another pick list.Update 20190716.mp4
[a9001aa727dc4255]
|
19,751,820 |
1F8552F2 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.066.Creating a pick list dependent on another pick list.Update 20190716.srt |
14,218 |
6BDADCD7 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.067.Using Command Shortcuts with the Alt key.Update 20190716.mp4
[e7d3588616450bf3]
|
21,180,736 |
B9AAE1BA |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.067.Using Command Shortcuts with the Alt key.Update 20190716.srt |
11,404 |
0A596890 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.068.Set up a macro for sorting dynamic data.Update 20190716.mp4
[4cb691fefca606b]
|
29,547,996 |
EEBCF6D5 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.068.Set up a macro for sorting dynamic data.Update 20190716.srt |
19,536 |
EAAADA35 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.069.Use random number functions for sorting and creating sample data.Update 20190716.mp4
[1c92906e374fe600]
|
30,226,726 |
1F909931 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.069.Use random number functions for sorting and creating sample data.Update 20190716.srt |
20,874 |
24EAA7A6 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.070.Use calcuated fields and calculated items in a PivotTable.Update 20190716.mp4
[1f92053b2afe7a62]
|
27,598,364 |
A5165636 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.070.Use calcuated fields and calculated items in a PivotTable.Update 20190716.srt |
17,824 |
8E4F6D05 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.071.Replace characters by position with the REPLACE function.Update 20190716.mp4
[9f00ac9e0bfae119]
|
16,325,050 |
D4EBD0BD |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.071.Replace characters by position with the REPLACE function.Update 20190716.srt |
10,579 |
3414CF66 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.072.Work with formulas in tables.Update 20190716.mp4
[fa1af876c6ee5e4f]
|
31,496,062 |
06D42517 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.072.Work with formulas in tables.Update 20190716.srt |
18,604 |
0EAB8E08 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.073.Keystroke shortcuts from A to Z - using the Ctrl key.Update 20190716.mp4
[734e448584f7f47f]
|
57,702,827 |
7A054DEF |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.073.Keystroke shortcuts from A to Z - using the Ctrl key.Update 20190716.srt |
32,664 |
D9BF99B3 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.074.Use special tricks for working with dates in Charts.Update 20190716.mp4
[3136eeab4caecf42]
|
34,809,766 |
01E61784 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.074.Use special tricks for working with dates in Charts.Update 20190716.srt |
21,907 |
23FEAD5D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.075.Use a data form for data entry and exploring data.Update 20190716.mp4
[395e4dd253ddec49]
|
26,116,582 |
98D4B0D0 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.075.Use a data form for data entry and exploring data.Update 20190716.srt |
13,561 |
8DCF2146 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.076.Creating an Excel template to simplify updating a monthly file.Update 20190716.mp4
[dd3114313fed2240]
|
20,616,261 |
0552FA22 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.076.Creating an Excel template to simplify updating a monthly file.Update 20190716.srt |
14,261 |
8F80B5CD |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.077.Calculate dates efficiently using Excel's hidden function - DATEDIF.Update 20190716.mp4
[702906fd3b69596a]
|
23,233,771 |
4E0D74FD |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.077.Calculate dates efficiently using Excel's hidden function - DATEDIF.Update 20190716.srt |
15,021 |
5CCE534A |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.078.Create dynamic sheet name references with the INDIRECT function.Update 20190716.mp4
[7ca8971589699e55]
|
20,098,024 |
343E0A39 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.078.Create dynamic sheet name references with the INDIRECT function.Update 20190716.srt |
12,929 |
67A52F71 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.079.Avoid errors and hidden data with the powerful AGGREGATE function.Update 20190716.mp4
[b4ecfe47afe142e5]
|
21,849,172 |
E8AC54A7 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.079.Avoid errors and hidden data with the powerful AGGREGATE function.Update 20190716.srt |
13,904 |
4CACC02B |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.080.Hide worksheets, row, columns, cells and other Excel elements.Update 20190716.mp4
[eb1368902c59f5e8]
|
29,149,401 |
C9E50BD4 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.080.Hide worksheets, row, columns, cells and other Excel elements.Update 20190716.srt |
15,523 |
093EBB27 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.081.Use slicers and charts together for dynamic presentations.Update 20190716.mp4
[a10fd0c7ae18a28b]
|
30,486,975 |
68D593C2 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.081.Use slicers and charts together for dynamic presentations.Update 20190716.srt |
18,400 |
E01B280C |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.082.Save a chart as a template - use the template for current or new charts.Update 20190716.mp4
[5b73f89ab41bb96e]
|
19,290,998 |
73968710 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.082.Save a chart as a template - use the template for current or new charts.Update 20190716.srt |
12,840 |
72953DBD |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.083.MAXIFS and MINIFS added to the COUNTIFSUMIF family of functions.Update 20190716.mp4
[16286ed32212b277]
|
23,802,804 |
F5AACB38 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.083.MAXIFS and MINIFS added to the COUNTIFSUMIF family of functions.Update 20190716.srt |
15,611 |
51BC4EA0 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.084.Adjust a chart's source data and adjust its series order.Update 20190716.mp4
[625e5809b3c90547]
|
27,197,676 |
1CBBCCDC |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.084.Adjust a chart's source data and adjust its series order.Update 20190716.srt |
18,228 |
9B8F393B |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.085.Use the OFFSET function for tabulating moving data.Update 20190716.mp4
[72f8ff2cce8073e4]
|
32,319,835 |
52FE0FD1 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.085.Use the OFFSET function for tabulating moving data.Update 20190716.srt |
20,571 |
FDDC23BA |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.086.Alter numeric data without formulas.Update 20190716.mp4
[9a83be07c2a48d02]
|
39,225,031 |
5C20C0BE |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.086.Alter numeric data without formulas.Update 20190716.srt |
20,105 |
475B49F8 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.087.Use Flash Fill to rapidly combine or separate columnar data.Update 20190716.mp4
[2ee427622e70232e]
|
35,976,486 |
079A3DA9 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.087.Use Flash Fill to rapidly combine or separate columnar data.Update 20190716.srt |
19,851 |
37485BFC |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.088.Adjust banded-row formatting.Update 20190716.mp4
[b5d6a132a9672407]
|
60,587,387 |
B1871F10 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.088.Adjust banded-row formatting.Update 20190716.srt |
29,463 |
5785A8C3 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.089.Change the shape of comment boxes and other objects.Update 20190716.mp4
[2d1baed473197cd3]
|
20,183,877 |
A3444B0F |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.089.Change the shape of comment boxes and other objects.Update 20190716.srt |
13,094 |
D36E3C53 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.090.How and when to use Excel's 10 rounding functions.Update 20190716.mp4
[d7c163b57b810f01]
|
37,065,234 |
1AC11B17 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.090.How and when to use Excel's 10 rounding functions.Update 20190716.srt |
25,324 |
382EC8B1 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.091.Calculate faster with the AutoSum button and AutoSum keystroke shortcut.Update 20190716.mp4
[79063bb84b971744]
|
19,825,115 |
99F4446C |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.091.Calculate faster with the AutoSum button and AutoSum keystroke shortcut.Update 20190716.srt |
13,932 |
56F63B77 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.092.How to use mixed cell references.Update 20190716.mp4
[a6423fe91d10c2f4]
|
24,551,997 |
464E39FD |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.092.How to use mixed cell references.Update 20190716.srt |
16,492 |
109EFBAA |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.093.Activate the Speak On Enter and Speak Cells features.Update 20190716.mp4
[68ac9c3c8aed812c]
|
15,428,007 |
4456D7CA |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.093.Activate the Speak On Enter and Speak Cells features.Update 20190716.srt |
10,007 |
98ED6561 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.094.Accelerate data entry with five special techniques.Update 20190716.mp4
[6e49e67c74ac871e]
|
33,055,574 |
C6CDC0A4 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.094.Accelerate data entry with five special techniques.Update 20190716.srt |
24,329 |
81DB9D33 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.095.Insert a text box or shape and link a cell's content to it.Update 20190716.mp4
[247d5877e675da81]
|
17,813,954 |
81AFA55E |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.095.Insert a text box or shape and link a cell's content to it.Update 20190716.srt |
12,793 |
708E1FA1 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.096.Use Watch Window and other techniques to track changing cells.Update 20190716.mp4
[bba3dde98d16716f]
|
31,136,663 |
849B446E |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.096.Use Watch Window and other techniques to track changing cells.Update 20190716.srt |
16,260 |
1605513B |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.097.How to create time interval entries.Update 20190716.mp4
[a2c5de7550c2b944]
|
33,952,827 |
44C0C740 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.097.How to create time interval entries.Update 20190716.srt |
22,232 |
CD4BAB4F |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.098.How to create frequency tabulations and distributions.Update 20190716.mp4
[d65c2823bf281a9a]
|
26,138,785 |
68B94D97 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.098.How to create frequency tabulations and distributions.Update 20190716.srt |
14,611 |
9C79598C |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.099.Create an expanded list from a summary using PivotTable techniques.Update 20190716.mp4
[cdee3421a45b5151]
|
38,519,752 |
4B145D4F |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.099.Create an expanded list from a summary using PivotTable techniques.Update 20190716.srt |
13,834 |
D05D9181 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.100.Solve matching issues with matching phone numbers and SS numbers.Update 20190716.mp4
[331374827bf6b84b]
|
37,387,637 |
FAC8C887 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.100.Solve matching issues with matching phone numbers and SS numbers.Update 20190716.srt |
19,199 |
2A0F4DB6 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.101.Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative.Update 20190716.mp4
[35e523681d95c632]
|
17,323,533 |
296EE56E |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.101.Use CHOOSE to calculate fiscal quarters and as a VLOOKUP alternative.Update 20190716.srt |
14,439 |
3FAC1F6C |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.102.Use Outlining tools to quickly expand and collapse data for dynamic presentations.Update 20190716.mp4
[560fa0bf90957dbe]
|
37,673,945 |
95051C76 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.102.Use Outlining tools to quickly expand and collapse data for dynamic presentations.Update 20190716.srt |
18,445 |
539C8520 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.103.Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting.Update 20190716.mp4
[1b77fa66cb5461c1]
|
31,528,511 |
EED03D94 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.103.Use the SUBTOTAL (and AGGREGATE) functions to avoid double counting.Update 20190716.srt |
19,191 |
8E259FE2 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.104.Create lists of all 2nd Tuesdays, last Tuesdays. and other date series.Update 20190716.mp4
[f5c97ce8af29177d]
|
31,235,883 |
C764B866 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.104.Create lists of all 2nd Tuesdays, last Tuesdays. and other date series.Update 20190716.srt |
20,092 |
0FDEB79F |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.105.Create linkage formulas that refer to other worksheets and workbooks.Update 20190716.mp4
[a61784d60066d39b]
|
31,309,451 |
062CD5D6 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.105.Create linkage formulas that refer to other worksheets and workbooks.Update 20190716.srt |
22,306 |
0B3F625D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.106.Formula nesting Using multiple functions in the same formula.Update 20190716.mp4
[c073e8420c9ff778]
|
40,884,466 |
8E36FBD6 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.106.Formula nesting Using multiple functions in the same formula.Update 20190716.srt |
26,263 |
4D122EE1 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.107.Keyboard shortcuts for numeric formats.Update 20190716.mp4
[6d97b5f05565446e]
|
27,110,546 |
7E07BCFE |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.107.Keyboard shortcuts for numeric formats.Update 20190716.srt |
15,753 |
C69F405C |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.108.Use the Subtotal command to analyze data with single- or multiple-level subtotals.Update 20190716.mp4
[3b2bdbb29a345591]
|
43,359,249 |
CB58C9F0 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.108.Use the Subtotal command to analyze data with single- or multiple-level subtotals.Update 20190716.srt |
17,495 |
6AF623F6 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.109.Work with MAX, MAXIFS, LARGE, and related functions.Update 20190716.mp4
[954e0e1f2c467f34]
|
25,782,718 |
0A19A290 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.109.Work with MAX, MAXIFS, LARGE, and related functions.Update 20190716.srt |
16,802 |
D14DA825 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.110.Use the dynamic TODAY and NOW functions for real-time up-to-date calculations.Update 20190716.mp4
[c1e97b8b2fe4c25a]
|
25,469,797 |
E7CD8B0C |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.110.Use the dynamic TODAY and NOW functions for real-time up-to-date calculations.Update 20190716.srt |
17,497 |
90D466A4 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.111.Use the FIND, MID, LEFT, and RIGHT functions.Update 20190716.mp4
[86a421d0841f5242]
|
31,272,038 |
80BDA55E |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.111.Use the FIND, MID, LEFT, and RIGHT functions.Update 20190716.srt |
19,898 |
BFEC5E3B |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.112.Flip the left-to-right order of columns with the INDEX function or sort by columns.Update 20190716.mp4
[74450a4c0c08a4e1]
|
30,812,139 |
0CBAE650 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.112.Flip the left-to-right order of columns with the INDEX function or sort by columns.Update 20190716.srt |
15,410 |
B3111903 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.113.Working with hidden data when copying cells and creating charts.Update 20190716.mp4
[ac79fd4e655bba7d]
|
42,918,582 |
0C131E88 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.113.Working with hidden data when copying cells and creating charts.Update 20190716.srt |
23,186 |
57EA2AAC |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.114.Use conditional formatting data bars to accentuate negative data.Update 20190716.mp4
[c594766ec791c9ce]
|
12,008,990 |
4E278CF2 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.114.Use conditional formatting data bars to accentuate negative data.Update 20190716.srt |
9,154 |
80F87E3E |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.115.Creative use of sparklines in merged cells with axes.Update 20190716.mp4
[c6b0ffac2bb6b445]
|
19,953,130 |
704E5357 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.115.Creative use of sparklines in merged cells with axes.Update 20190716.srt |
13,619 |
74F3445D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.116.Copy formats quickly using dragging techniques and the Format Painter.Update 20190716.mp4
[925b0175273ee4]
|
18,237,233 |
4DADAED0 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.116.Copy formats quickly using dragging techniques and the Format Painter.Update 20190716.srt |
10,827 |
00DD9327 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.117.Displaying multiple worksheets and workbooks together.Update 20190716.mp4
[8498c7bb5473b26]
|
33,978,011 |
029A42DC |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.117.Displaying multiple worksheets and workbooks together.Update 20190716.srt |
21,004 |
E6B4A0C9 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.118.Tips for creating and updating sample data.Update 20190716.mp4
[1886aa1b21421a06]
|
33,155,965 |
3FCD480C |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.118.Tips for creating and updating sample data.Update 20190716.srt |
21,814 |
98333812 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.119.Use conditional formatting to overcome formatting limitations of the IF function.Update 20190716.mp4
[c6e7c79a73c5e2ae]
|
25,309,020 |
69FAF634 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.119.Use conditional formatting to overcome formatting limitations of the IF function.Update 20190716.srt |
16,606 |
BAED7994 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.120.Use VLOOKUP, MATCH and Index functions with array formulas.Update 20190716.mp4
[84630ae7fce438f6]
|
31,337,114 |
B06668E5 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.120.Use VLOOKUP, MATCH and Index functions with array formulas.Update 20190716.srt |
19,613 |
A88B0D2D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.121.Summarize data from different worksheets with a PivotTable.Update 20190716.mp4
[a448ccb787c8fee9]
|
24,566,207 |
BF2E9AD8 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.121.Summarize data from different worksheets with a PivotTable.Update 20190716.srt |
13,944 |
F26C4D5D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.122.AutoFill shortcuts for date series, onetwo week intervals, EOM, and formulas.Update 20190716.mp4
[8e78de4de69b201e]
|
21,204,780 |
8A3EBFC3 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.122.AutoFill shortcuts for date series, onetwo week intervals, EOM, and formulas.Update 20190716.srt |
13,458 |
D0EBBDF3 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.123.Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions.Update 20190716.mp4
[8699c4fdb1050c03]
|
25,450,652 |
1736784A |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.123.Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions.Update 20190716.srt |
16,057 |
D72438C5 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.124.Use custom formulas in data validation to keep out bad data.Update 20190716.mp4
[c8c8a345a489bcdb]
|
36,705,753 |
C6B3671A |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.124.Use custom formulas in data validation to keep out bad data.Update 20190716.srt |
23,579 |
BEB233F4 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.125.Dealing with circular errors.Update 20190716.mp4
[5f31f5fa23a598b5]
|
23,453,684 |
C2BC02A6 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.125.Dealing with circular errors.Update 20190716.srt |
15,181 |
01CA534A |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.126.Tips for creating charts quickly.Update 20190716.mp4
[c7691f629ad39787]
|
20,175,859 |
8D43795B |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.126.Tips for creating charts quickly.Update 20190716.srt |
13,526 |
818DA0FB |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.127.Creating heat maps using conditional formatting.Update 20190716.mp4
[c5b6da05e3100a73]
|
36,602,346 |
3E65CA09 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.127.Creating heat maps using conditional formatting.Update 20190716.srt |
16,273 |
74EB76F6 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.128.Using the INDEX function to extract data by row and column.Update 20190716.mp4
[a5a2f5e28709749d]
|
29,756,562 |
BA67C49D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.128.Using the INDEX function to extract data by row and column.Update 20190716.srt |
20,954 |
D00EBA32 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.129.Displaying tips when using Excel in presentations.Update 20190716.mp4
[66bbb85988f384cb]
|
31,088,456 |
04BE0E42 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.129.Displaying tips when using Excel in presentations.Update 20190716.srt |
12,107 |
BF92583C |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.130.The Wrap Text, Merge and Center, and Indent options.Update 20190716.mp4
[95a693c41c78e4ca]
|
31,828,571 |
CB63EB43 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.130.The Wrap Text, Merge and Center, and Indent options.Update 20190716.srt |
18,149 |
A0F4AE70 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.131.Using fill effects (gradients, patterns, styles) for colorful cell background variations.Update 20190716.mp4
[687d11678256439f]
|
17,878,331 |
4C741B62 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.131.Using fill effects (gradients, patterns, styles) for colorful cell background variations.Update 20190716.srt |
10,766 |
F79102F9 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.132.Working with multiple worksheets simultaneously.Update 20190716.mp4
[886ddbc566fd643d]
|
27,256,614 |
A38BB1E8 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.132.Working with multiple worksheets simultaneously.Update 20190716.srt |
18,823 |
338BFAD4 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.133.Exploring font choices not found on the Home tab.Update 20190716.mp4
[807ca5a99b40d7ad]
|
12,249,614 |
B59F0FF0 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.133.Exploring font choices not found on the Home tab.Update 20190716.srt |
7,711 |
5896CFFB |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.134.Using WordArt for special titles and headings.Update 20190716.mp4
[aa18b37a7164633a]
|
15,251,030 |
E4E98843 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.134.Using WordArt for special titles and headings.Update 20190716.srt |
9,179 |
FCA3606C |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.135.Creating a 2-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions.Update 20190716.mp4
[df8c581bb871df33]
|
23,902,771 |
071B7CA9 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.135.Creating a 2-way lookup with VLOOKUP, HLOOKUP, INDEX, and MATCH functions.Update 20190716.srt |
13,464 |
54DC32D6 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.136.Borders and gridlines Exploring variations, options, and differences.Update 20190716.mp4
[72ec6c26be9d000f]
|
26,337,926 |
EE30BC77 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.136.Borders and gridlines Exploring variations, options, and differences.Update 20190716.srt |
17,127 |
24BD75A7 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.137.New Excel 2016 chart types Tree map and sunburst.Update 20190716.mp4
[7b66e488496be624]
|
31,590,087 |
80EE56F4 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.137.New Excel 2016 chart types Tree map and sunburst.Update 20190716.srt |
16,131 |
7CC8C92B |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.138.Freezing column and row titles.Update 20190716.mp4
[a9c1708e6fbf65d9]
|
43,880,687 |
27281CCD |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.138.Freezing column and row titles.Update 20190716.srt |
15,197 |
6A64FAB0 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.139.Use data validation to force entries to be uppercase or lowercase.Update 20190716.mp4
[ea6cf7362b5c4fd3]
|
26,751,423 |
81C1A038 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.139.Use data validation to force entries to be uppercase or lowercase.Update 20190716.srt |
20,967 |
148F1792 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.140.Avoiding common chart distortions.Update 20190716.mp4
[3180432c14833526]
|
34,319,186 |
928C211F |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.140.Avoiding common chart distortions.Update 20190716.srt |
22,409 |
17D99E16 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.141.Use the new Funnel chart available in Excel 365.Update 20190716.mp4
[349cf009772abe7a]
|
11,148,806 |
4684F063 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.141.Use the new Funnel chart available in Excel 365.Update 20190716.srt |
8,884 |
D4FE5073 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.142.Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character.Update 20190716.mp4
[d82865b6c4e9f3cc]
|
15,970,403 |
CD8EB4B8 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.142.Combine data using CONCATENATE, CONCAT, and TEXTJOIN functions and the ampersand (&) character.Update 20190716.srt |
12,066 |
99D0E960 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.143.Recognizing Excel Formula errors #NA, #VALUE!, #REF!, #DIV0!, #NUM, and #NAME!.Update 20190716.mp4
[5af05c01237ce10]
|
29,428,575 |
7C998B8E |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.143.Recognizing Excel Formula errors #NA, #VALUE!, #REF!, #DIV0!, #NUM, and #NAME!.Update 20190716.srt |
18,906 |
32C59EC3 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.144.Creating cross-totals with the SUMIFS function and mixed references.Update 20190716.mp4
[e023bdfa9bdb5c9b]
|
18,472,679 |
704CB783 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.144.Creating cross-totals with the SUMIFS function and mixed references.Update 20190716.srt |
10,834 |
978A8BB1 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.145.New Excel 2016 chart types Histogram, Pareto, and box, and whisker.Update 20190716.mp4
[f9b38a731e9898c1]
|
29,386,558 |
981F27ED |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.145.New Excel 2016 chart types Histogram, Pareto, and box, and whisker.Update 20190716.srt |
19,157 |
18A007D5 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.146.Using the AND and OR functions independently or within IF functions.Update 20190716.mp4
[baca3c784b07d9c4]
|
29,277,803 |
AECB3557 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.146.Using the AND and OR functions independently or within IF functions.Update 20190716.srt |
18,469 |
5A2CAA8F |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.147.Vertical and horizontal alignment settings and orientation options.Update 20190716.mp4
[96e6f466a34b547a]
|
19,437,582 |
3616DFD6 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.147.Vertical and horizontal alignment settings and orientation options.Update 20190716.srt |
13,561 |
24EA694D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.148.Sorting tips and shortcuts.Update 20190716.mp4
[321f2dae9630aa5]
|
34,007,110 |
AC553BBC |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.148.Sorting tips and shortcuts.Update 20190716.srt |
17,161 |
8CEDF6FD |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.149.A look at new chart types in Excel 2016 Waterfall.Update 20190716.mp4
[16732a35989b017f]
|
18,866,643 |
1C4316A4 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.149.A look at new chart types in Excel 2016 Waterfall.Update 20190716.srt |
13,690 |
2DEA8FE6 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.150.Work with formulas and formats Decimals and fractions.Update 20190716.mp4
[b50b0d039cbd2c3e]
|
14,189,448 |
2CF17AED |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.150.Work with formulas and formats Decimals and fractions.Update 20190716.srt |
11,158 |
E026E91F |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.151.Creating mixed reference formulas; converting to a table; applying conditional formatting.Update 20190716.mp4
[7fda4281147a1f3f]
|
29,247,876 |
5D53FEE6 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.151.Creating mixed reference formulas; converting to a table; applying conditional formatting.Update 20190716.srt |
14,506 |
FD073355 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.152.Control gridlines in charts and on worksheets.Update 20190716.mp4
[4dc86996ce3865fb]
|
22,734,522 |
8E9E78CA |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.152.Control gridlines in charts and on worksheets.Update 20190716.srt |
15,261 |
D555C365 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.153.Use the INDIRECT function with intersection formulas and range names to extract data.Update 20190716.mp4
[a703c8d284549242]
|
21,143,830 |
E0E321E9 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.153.Use the INDIRECT function with intersection formulas and range names to extract data.Update 20190716.srt |
12,458 |
F24A093D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.154.Using ExpandCollapse on PivotTables and PivotCharts for rapid display changes.Update 20190716.mp4
[f9121d6b49567ea0]
|
23,018,378 |
5E341967 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.154.Using ExpandCollapse on PivotTables and PivotCharts for rapid display changes.Update 20190716.srt |
14,375 |
D250BCAC |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.155.Control phone number and postal code formats using built-in options or customized formats.Update 20190716.mp4
[17f5be65316578ce]
|
19,610,526 |
D26C2464 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.155.Control phone number and postal code formats using built-in options or customized formats.Update 20190716.srt |
13,956 |
1477C65D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.156.Change the default Excel chart type; create and use chart templates.Update 20190716.mp4
[455dbc74eb4be24d]
|
20,066,448 |
D22B75B9 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.156.Change the default Excel chart type; create and use chart templates.Update 20190716.srt |
12,172 |
801FAED1 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.157.Create your own customized date and time formats.Update 20190716.mp4
[220fada8097e9f7e]
|
23,596,107 |
B93785AA |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.157.Create your own customized date and time formats.Update 20190716.srt |
15,358 |
E0254246 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.158.Create on-screen warnings and reminders with comments or data validation messages.Update 20190716.mp4
[113fb94f0bcabe3f]
|
19,704,606 |
02668DC2 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.158.Create on-screen warnings and reminders with comments or data validation messages.Update 20190716.srt |
12,105 |
3143907E |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.159.Use REPLACE for formats only, for data only, or for both.Update 20190716.mp4
[b7f03ba2872ae03]
|
23,554,395 |
205018EB |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.159.Use REPLACE for formats only, for data only, or for both.Update 20190716.srt |
11,488 |
5D837986 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.160.Create numeric formats Display in thousands or millions.Update 20190716.mp4
[6ee896370d20061e]
|
37,543,584 |
60F577E4 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.160.Create numeric formats Display in thousands or millions.Update 20190716.srt |
22,648 |
01D85696 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.161.Converting dates like 20102006 into usable date entries.Update 20190716.mp4
[2be0bb4f3394c3ca]
|
12,557,912 |
A543921D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.161.Converting dates like 20102006 into usable date entries.Update 20190716.srt |
8,366 |
5CCDBC92 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.162.Create custom lists for letter series like A to Z.Update 20190716.mp4
[ebfdbaefba3b72f4]
|
30,132,311 |
98C3DF2B |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.162.Create custom lists for letter series like A to Z.Update 20190716.srt |
12,881 |
45C7FB71 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.163.Freeze Panes and Split.Update 20190716.mp4
[45266ac2b898fcf1]
|
31,725,054 |
D0C65F0D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.163.Freeze Panes and Split.Update 20190716.srt |
12,064 |
3E515F9F |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.164.NETWORKDAYS.INTL and WORKDAY.INTL.Update 20190716.mp4
[dc6c833e07d74297]
|
15,459,208 |
83CCD90A |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.164.NETWORKDAYS.INTL and WORKDAY.INTL.Update 20190716.srt |
11,001 |
E5FFBBD7 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.165.Calculate % of change.Update 20190716.mp4
[4118fd23c241e43f]
|
14,683,214 |
7CE510DA |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.165.Calculate % of change.Update 20190716.srt |
10,542 |
9D1633F5 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.166.Fill in all blank cells within a range with either formatting or data.Update 20190716.mp4
[7fadf5249b6556a2]
|
17,360,876 |
C0F53ADB |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.166.Fill in all blank cells within a range with either formatting or data.Update 20190716.srt |
8,802 |
39FC16F9 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.167.Use the COUNT and COUNTA functions.Update 20190716.mp4
[791f91e613bbdba2]
|
14,603,036 |
7368FDB1 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.167.Use the COUNT and COUNTA functions.Update 20190716.srt |
8,181 |
0955AA65 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.168.Use workbook protection to prevent use of sheet commands.Update 20190716.mp4
[af17c9018a4bdccd]
|
18,872,604 |
279C78F8 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.168.Use workbook protection to prevent use of sheet commands.Update 20190716.srt |
11,696 |
5D382897 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.169.Rank data with the RANK and RANK.AVG functions.Update 20190716.mp4
[147a0a04057b516e]
|
16,890,696 |
A06C0555 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.169.Rank data with the RANK and RANK.AVG functions.Update 20190716.srt |
11,489 |
83D8A226 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.170.Use nonstandard fiscal years and quarters in PivotTables.Update 20190716.mp4
[cde8613bcb020e7f]
|
19,747,698 |
BB029D10 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.170.Use nonstandard fiscal years and quarters in PivotTables.Update 20190716.srt |
10,870 |
59A92CEE |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.171.Identify or extract unique entries in a list.Update 20190716.mp4
[7421d544414e201f]
|
23,785,538 |
CCA3C6CA |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.171.Identify or extract unique entries in a list.Update 20190716.srt |
11,004 |
5AB304E5 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.172.Keyboard, mouse, and command techniques for viewing worksheets.Update 20190716.mp4
[3b6da408665b3f8e]
|
28,374,800 |
C55441CB |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.172.Keyboard, mouse, and command techniques for viewing worksheets.Update 20190716.srt |
11,256 |
ED6008C3 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.173.Create artistic charts with random numbers.Update 20190716.mp4
[9e380c7985fb0f5b]
|
23,824,511 |
D7CCF2ED |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.173.Create artistic charts with random numbers.Update 20190716.srt |
15,244 |
3F1D0A9F |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.174.Extract day, month, and year from date fields.Update 20190716.mp4
[35338f26b4c84e3]
|
13,791,825 |
B8F27716 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.174.Extract day, month, and year from date fields.Update 20190716.srt |
10,213 |
1314FA5A |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.175.Compare data with EXACT, FIND, and SEARCH functions.Update 20190716.mp4
[a0b91024e2caed8d]
|
13,814,162 |
028F080D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.175.Compare data with EXACT, FIND, and SEARCH functions.Update 20190716.srt |
9,983 |
AC9795A7 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.176.How to covert ROMAN numberals.Update 20190716.mp4
[d29e7e07f9b61e72]
|
13,896,990 |
DC3CF814 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.176.How to covert ROMAN numberals.Update 20190716.srt |
8,224 |
CCC5A197 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.177.Use range names for more readable formulas.Update 20190716.mp4
[929179e7281dfe94]
|
16,255,994 |
D9853E61 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.177.Use range names for more readable formulas.Update 20190716.srt |
10,323 |
C6DE3C54 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.178.Customize your Quick Access Toolbar.Update 20190716.mp4
[374de8e9c55fa259]
|
21,314,655 |
9546C97D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.178.Customize your Quick Access Toolbar.Update 20190716.srt |
11,622 |
AF818E41 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.179.Conditional formatting based on date proximity.Update 20190716.mp4
[9e6d10ef9cc2c883]
|
14,417,488 |
29F5DE0E |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.179.Conditional formatting based on date proximity.Update 20190716.srt |
9,632 |
3EDE7ED5 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.180.How to adjust names.Update 20190716.mp4
[9f9de56ad4ae3b63]
|
16,993,410 |
237B4B12 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.180.How to adjust names.Update 20190716.srt |
10,225 |
C233B91E |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.181.Differences and limitations of converting data to a table.Update 20190716.mp4
[510b865b12d5a2c4]
|
19,688,047 |
DC331AFD |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.181.Differences and limitations of converting data to a table.Update 20190716.srt |
10,393 |
5054BD79 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.182.Avoid the #DIV0 error message.Update 20190716.mp4
[71852d9b29a67d6d]
|
14,423,588 |
3B362437 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.182.Avoid the #DIV0 error message.Update 20190716.srt |
9,941 |
0EF8DBE4 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.183.Explore formatting options not available on the Home tab.Update 20190716.mp4
[f6a0d935a1f5a362]
|
16,304,097 |
29F97AC9 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.183.Explore formatting options not available on the Home tab.Update 20190716.srt |
8,345 |
0896B2CC |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.184.Control table formatting with custom formats.Update 20190716.mp4
[61e6fb5ea00bc3f7]
|
12,791,158 |
375C0D97 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.184.Control table formatting with custom formats.Update 20190716.srt |
6,511 |
3A018426 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.185.Use date functions for age and tenure calculations.Update 20190716.mp4
[2b2113f75ac4125f]
|
17,228,288 |
2E910109 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.185.Use date functions for age and tenure calculations.Update 20190716.srt |
11,095 |
32FC690D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.186.Avoid unintentional entries when typing code numbers.Update 20190716.mp4
[f9c28f47f4d04e4]
|
9,986,522 |
4C630625 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.186.Avoid unintentional entries when typing code numbers.Update 20190716.srt |
8,355 |
55728A4F |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.187.Sorting by moving columns.Update 20190716.mp4
[2ebc55f6744c440]
|
16,057,963 |
21D43B68 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.187.Sorting by moving columns.Update 20190716.srt |
8,172 |
B524F037 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.188.Calculating cumulative totals.Update 20190716.mp4
[7a9215f7546f874f]
|
11,765,175 |
C75F27B0 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.188.Calculating cumulative totals.Update 20190716.srt |
7,988 |
E60EA456 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.189.Using the CONVERT function for different numbering systems.Update 20190716.mp4
[801e9a4bc067133]
|
13,477,174 |
654BDE91 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.189.Using the CONVERT function for different numbering systems.Update 20190716.srt |
8,606 |
91A1A3DA |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.190.Creating an automatically expanding chart by basing it on a table.Update 20190716.mp4
[1dbc94f88bf485ee]
|
11,846,742 |
8907525D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.190.Creating an automatically expanding chart by basing it on a table.Update 20190716.srt |
8,323 |
E55B7C6D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.191.Keystroke shortcuts using the Alt key.Update 20190716.mp4
[930117012bdd048a]
|
15,424,709 |
4483F885 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.191.Keystroke shortcuts using the Alt key.Update 20190716.srt |
11,416 |
865502DF |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.192.Using the Solver Add-in.Update 20190716.mp4
[2a86c53de52a483b]
|
12,320,260 |
3A5B9591 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.192.Using the Solver Add-in.Update 20190716.srt |
8,093 |
8237F5BC |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.193.Column widths, row heights, merging cells, and related formatting issues.Update 20190716.mp4
[11d88d4489ee23fe]
|
11,502,557 |
C1B8B815 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.193.Column widths, row heights, merging cells, and related formatting issues.Update 20190716.srt |
10,437 |
622CA8CA |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.194.Adjusting default layouts and date grouping in PivotTables.Update 20190716.mp4
[4268936e68e32bcf]
|
11,975,684 |
6DC8DA2D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.194.Adjusting default layouts and date grouping in PivotTables.Update 20190716.srt |
8,173 |
CA6264D1 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.195.Auditing cell content with Watch Window and dependent cell formulas.Update 20190716.mp4
[2269b6f2bef2da92]
|
10,425,770 |
6C04CB39 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.195.Auditing cell content with Watch Window and dependent cell formulas.Update 20190716.srt |
8,243 |
F0EED43D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.196.Use the LEN and REPT functions for specialized cell testing and display options.Update 20190716.mp4
[8c63442a2dabd684]
|
11,091,972 |
B578BF98 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.196.Use the LEN and REPT functions for specialized cell testing and display options.Update 20190716.srt |
10,791 |
DB969F39 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.197.Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters.Update 20190716.mp4
[5ab9d5417b022612]
|
12,558,133 |
78096C31 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.197.Use the TRIM and CLEAN functions to remove excess spaces and non-printing characters.Update 20190716.srt |
10,722 |
FACD8866 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.198.Create double-spaced and triple-spaced printouts while repeating column headings.Update 20190716.mp4
[9e73bdc00022277d]
|
13,330,608 |
D925B379 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.198.Create double-spaced and triple-spaced printouts while repeating column headings.Update 20190716.srt |
10,244 |
6A182C0A |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.199.Helpful keystroke shortcuts.Update 20190716.mp4
[9ad797e13c757e4c]
|
22,300,338 |
D56BCA48 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.199.Helpful keystroke shortcuts.Update 20190716.srt |
10,041 |
F89F9784 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.200.Identify weekdays and weekend days in data.Update 20190716.mp4
[a1f0638b62631649]
|
12,564,088 |
46D0C021 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.200.Identify weekdays and weekend days in data.Update 20190716.srt |
7,229 |
B6F65CEF |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.201.Use chart and filter for presentations.Update 20190716.mp4
[68a648c5b45ee14d]
|
9,977,462 |
943717C0 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.201.Use chart and filter for presentations.Update 20190716.srt |
9,592 |
C5FFA99A |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.202.Create picture links.Update 20190716.mp4
[65c09fdcbc2e7959]
|
20,163,855 |
17B5B155 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.202.Create picture links.Update 20190716.srt |
8,822 |
CF9DC79C |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.203.How to use the error-checking rules in Excel.Update 20190716.mp4
[a2cf81d8683a45dc]
|
14,294,360 |
FD517835 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.203.How to use the error-checking rules in Excel.Update 20190716.srt |
10,515 |
103E0562 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.204.Protect worksheets and lock cells.Update 20190716.mp4
[9f665acf19d4a36b]
|
18,073,858 |
D980499C |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.204.Protect worksheets and lock cells.Update 20190716.srt |
8,147 |
76818485 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.205.Use mixed addresses in Excel formulas.Update 20190716.mp4
[c8dfaca08ca0976d]
|
13,299,329 |
DD4E02C5 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.205.Use mixed addresses in Excel formulas.Update 20190716.srt |
9,980 |
54E5E258 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.206.Rapid filtering with Filter by Selection.Update 20190716.mp4
[3dddd278253f2940]
|
13,296,641 |
5743F24B |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.206.Rapid filtering with Filter by Selection.Update 20190716.srt |
10,305 |
A0980656 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.207.Display large values.Update 20190716.mp4
[ac37d3e84f877c0]
|
18,111,735 |
C34B0DF4 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.207.Display large values.Update 20190716.srt |
6,949 |
8993EBE8 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.208.Tracking down conditional formatting and data validation rules.Update 20190716.mp4
[4057b03a8605b3d4]
|
19,858,778 |
57CF38AD |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.208.Tracking down conditional formatting and data validation rules.Update 20190716.srt |
10,735 |
2B4A9FD7 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.209.Using check boxes and conditional formatting to provide interactive filter-like displays.Update 20190716.mp4
[1cdf2f6b4d11d281]
|
20,134,401 |
704CF5FC |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.209.Using check boxes and conditional formatting to provide interactive filter-like displays.Update 20190716.srt |
11,032 |
E7C0B37A |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.210.Transposing data and using the TRANSPOSE function.Update 20190716.mp4
[53b8028c025b3490]
|
14,059,355 |
F5484093 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.210.Transposing data and using the TRANSPOSE function.Update 20190716.srt |
10,694 |
DC269AEF |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.211.Displaying gridlines, borders, and columnrow headings when printing.Update 20190716.mp4
[c21876c33cbca5b3]
|
14,114,307 |
8FAD2B83 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.211.Displaying gridlines, borders, and columnrow headings when printing.Update 20190716.srt |
9,479 |
60A6FEE1 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.212.Exploring some of the 200-plus SmartArt graphic options.Update 20190716.mp4
[130e57f7a030125a]
|
9,473,136 |
620483B1 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.212.Exploring some of the 200-plus SmartArt graphic options.Update 20190716.srt |
7,475 |
6E8B30EF |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.213.Hidden tools and treasures in the Go To Special dialog box.Update 20190716.mp4
[b8525a1fca50244b]
|
21,024,770 |
97A1212D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.213.Hidden tools and treasures in the Go To Special dialog box.Update 20190716.srt |
12,046 |
137E184D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.214.Using the CEILING and FLOOR functions for specialized rounding needs.Update 20190716.mp4
[4ed49c5ad3dc02fb]
|
12,449,112 |
02820E20 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.214.Using the CEILING and FLOOR functions for specialized rounding needs.Update 20190716.srt |
9,841 |
7BC2DED7 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.215.Inserting, reshaping, and formatting shapes Rectangles, arrows, stars, and banners.Update 20190716.mp4
[443d5989eef0d5ea]
|
13,576,536 |
FC2A1223 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.215.Inserting, reshaping, and formatting shapes Rectangles, arrows, stars, and banners.Update 20190716.srt |
11,657 |
949FC545 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.216.Tabulating totals with the VLOOKUP function and array constants.Update 20190716.mp4
[394d86eb50d58161]
|
14,162,433 |
D36039C3 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.216.Tabulating totals with the VLOOKUP function and array constants.Update 20190716.srt |
10,563 |
632F3E03 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.217.Using the Advanced Filter for specialized filtering needs.Update 20190716.mp4
[235f7f998ec60682]
|
14,871,044 |
A948CA67 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.217.Using the Advanced Filter for specialized filtering needs.Update 20190716.srt |
10,905 |
18F9F0ED |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.218.Working with array formulas more easily.Update 20190716.mp4
[4c90c2d10e39189a]
|
11,589,633 |
429D4F8C |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.218.Working with array formulas more easily.Update 20190716.srt |
8,205 |
32717766 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.219.Using the new UNIQUE function to count and copy unique list entries.Update 20190716.mp4
[19e37ddb30d588a7]
|
10,722,816 |
BEFB456C |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.219.Using the new UNIQUE function to count and copy unique list entries.Update 20190716.srt |
6,491 |
4D6E2BEC |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.220.Creating and updating sample data.Update 20190716.mp4
[58e0c5f5bb0f8d48]
|
16,508,934 |
94F81564 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.220.Creating and updating sample data.Update 20190716.srt |
10,321 |
76CAEC9F |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.221.Format macros to make you a more efficient Excel user.Update 20190716.mp4
[56bec03e12d7b83d]
|
15,206,572 |
105EFCFB |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes\02.221.Format macros to make you a more efficient Excel user.Update 20190716.srt |
9,659 |
A00CE631 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\123_Book1.zip |
471,035 |
143A16B8 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\124_Quick_Charts.zip |
882,869 |
B101D158 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\125_Heat_Maps.zip |
52,392 |
704384C6 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\126_INDEX_Function.zip |
503,733 |
0443BA90 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\127_Display_Tips.zip |
342,502 |
F3CC6377 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\128_Wrap_text_Merge_Indent.zip |
61,566 |
87DC2D46 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\129_Fill_Effects.zip |
25,342 |
4114410F |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\130_Multiple_Worksheets.zip |
17,208 |
A7394C56 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\131_Other_Font_Options.zip |
376,140 |
498E236E |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\132_WordArt_Variations.zip |
436,716 |
37791DC0 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\133_Weekday_Weekend.zip |
524,751 |
2D3B551C |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\134_Two_Way_Lookups.zip |
369,248 |
7BA2EE47 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\135_Borders_Gridlines.zip |
448,733 |
4F967D70 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\149_Decimals_and_Fractions.zip |
27,067 |
20D5DABD |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\150_Mixed_References.zip |
66,833 |
8F134065 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\151_Chart_gridlines_and_borders.zip |
66,098 |
F0DC3F9A |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\152_INDIRECT_Intersection_RangeNames.zip |
19,109 |
84492C98 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\153_Expand_Collapse_PivotTables.zip |
126,397 |
AF13FDB6 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\154_Phone_and_ZipCode_Formats.zip |
13,364 |
E4D28F32 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\155_Default_Chart_Type_and_Chart_Templates.zip |
40,843 |
FE8433A4 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\156_Date_Time_Formats.zip |
123,301 |
C9F9F6AB |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\157_Comments_and_Reminders.zip |
187,802 |
E1B79AE5 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\158_Replace_Format_or_Content.zip |
158,375 |
2896AA88 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\159_Number_Formats.zip |
42,136 |
769BD57C |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\160_Date_Format_Conversions.zip |
136,904 |
68B70AC5 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\161_Custom_Lists.zip |
120,852 |
0119737D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\162_Freeze_Panes_and_Split_Screens.zip |
117,793 |
030EB29F |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\163_NETWORKDAYS_and_WORKDAY.zip |
27,792 |
704E114D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\164_Percent_change_and_Goal_Seek.zip |
22,652 |
4E9119D9 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\165_Fill_in_Blanks.zip |
156,310 |
EDD20978 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\166_COUNT_COUNTA_and_Status_Bar.zip |
147,481 |
EE2287AF |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\167_Excel_Sheet_Commands.zip |
224,211 |
DD9524AF |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\168_Ranking_Data.zip |
59,259 |
BEDF6A7D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\169_PivotTable_Date_Grouping.zip |
154,263 |
EEC7CF01 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\170_Unique_and_Duplicate_Data.zip |
216,018 |
568A0D55 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\171_Zoom_and_Display_Variations.zip |
264,919 |
4391CF93 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\172_Abstract_Art_with_Random_Numbers_and_Excel_Charts.zip |
74,789 |
19551A2F |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\173_YEAR_MONTH_DAY_WEEKDAY.zip |
231,461 |
0C5CA886 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\174_EXACT_FIND_SEARCH_Functions.zip |
16,866 |
9B98F8FE |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\175_ROMAN_ARABIC.zip |
20,823 |
22BB50B0 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\176_Range_Names.zip |
168,834 |
14BC236A |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\177_Customize_the_Quick_Access_Toolbar.zip |
61,328 |
ACF47E69 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\178_Adjusting_Names.zip |
19,078 |
AD4CBB1E |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\179_Date_Proximity_Formatting_final.zip |
19,546 |
E729D9DE |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\180_Table_Differences.zip |
242,447 |
DAF279FA |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\181_Avoiding_DIV_Error.zip |
30,311 |
6F3A52F3 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\182_FormattingOptions.zip |
243,360 |
053CD314 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\183_New_Table_Style.zip |
126,292 |
42AFBD2B |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\184_Date_Calculations.zip |
131,544 |
391D8775 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\185_Unintentional_Entries.zip |
14,820 |
5646C1E2 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\186_Sort_by_Moving_Columns.zip |
39,746 |
66FF489A |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\187_Cumulative_Totals.zip |
11,912 |
2622F6C1 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\188_CONVERT_Function.zip |
9,728 |
8AEA6EBF |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\189_Alt_Key_Shortcuts.zip |
25,223 |
8E7CA87E |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\189_Chart_based_on_a_Table.zip |
6,679 |
DB70D7CC |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\190_Solver.zip |
9,199 |
42679049 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\191_Columns_Widths.zip |
14,875 |
3B60D045 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\192_PivotTable_Settings.zip |
69,006 |
EC65D925 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\194_LEN_and_REPT.zip |
40,134 |
D010A147 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\194_Watch_Window.zip |
107,872 |
4378E03B |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\195_TRIM_and_CLEAN.zip |
76,869 |
C41C6533 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\196_Double_and_Triple_Spaced_Printing.zip |
150,324 |
A9AB938D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\197_Helpful_Keystroke_Shortcuts.zip |
313,166 |
7CA6D73A |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\198_Weekdays_and_Weekends.zip |
254,255 |
C8F9B117 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\199_Charts_and_Filters.zip |
16,021 |
027956F9 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\200_Linking_Pictures.zip |
67,832 |
D0B12B33 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\201_Error_Checking_Indicators.zip |
323,171 |
9FCDFDEA |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\202_Worksheet_Protection.zip |
56,857 |
A93048AA |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\203_Mixed_Cell_Addresses.zip |
18,743 |
0B5C10E5 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\204_Filter_by_Selection.zip |
75,069 |
A3FCE21B |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\205_Displaying_Large_Values.zip |
33,630 |
774D9BCA |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\206_ConditionalFormatting_and_DataValidation.zip |
109,713 |
06E8B124 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\207_CheckBox_ConditionalFormatting.zip |
109,799 |
A8B9A3D7 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\208_Transpose.zip |
16,348 |
1DE6389D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\209_Borders_Gridlines_Printing.zip |
16,733 |
968765F3 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\210_SmartArt.zip |
17,792 |
5AE6FFEC |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\211_GoTo_Special.zip |
416,061 |
4FC8AA03 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\212_CEILINGandFLOOR.zip |
10,206 |
79B99048 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\213_Shapes_and_Stars.zip |
16,387 |
0B13DC42 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\214_Array_Constants_withVLOOKUP.zip |
15,646 |
9CFC7C63 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\215_AdvancedFilter.zip |
353,230 |
0A31D7D6 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\216_ArrayFormulaUpdates.zip |
131,109 |
EA4FF919 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\217_UNIQUE_function.zip |
42,239 |
6AC30CFB |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\218_Sample_Data.zip |
52,476 |
D21D9217 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\219_Utility_Macros.zip |
17,231 |
E81D221A |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\220_SORT_and_SORTBY_Functions.zip |
64,136 |
F79A970D |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\01.Excel Tips - New This Week |
0 |
00000000 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716\02.Previous Episodes |
0 |
00000000 |
|
LinkedIn Learning Excel Tips Weekly Update 20190716 |
0 |
00000000 |
|
| Total size: |
5,285,729,029 |
|
