|
|
0
|
|
310 KB
|
|
|
01 - introduction.mp4
|
MP4
|
29.7 MB
|
|
|
02 - excel-2019-useful-keyboard-shortcuts-and-tips.mp4
|
MP4
|
105.2 MB
|
|
|
03 - customizing-the-quick-access-toolbar.mp4
|
MP4
|
16.1 MB
|
|
|
04 - customizing-the-ribbon.mp4
|
MP4
|
22.1 MB
|
|
|
05 - using-keyboard-to-access-ribbon.mp4
|
MP4
|
9.8 MB
|
|
|
06 - the-best-techniques-for-inserting-deleting-hidin.mp4
|
MP4
|
33 MB
|
|
|
07 - undo-redo-and-repeat.mp4
|
MP4
|
24.2 MB
|
|
|
08 - 4-ways-to-protect-excel-workbooks-worksheets-and.mp4
|
MP4
|
75.5 MB
|
|
|
09 - navigate-between-workbooks-quickly.mp4
|
MP4
|
23.1 MB
|
|
|
10 - applying-document-themes-in-a-workbook.mp4
|
MP4
|
12.1 MB
|
|
|
11 - saving-excel-as-a-read-only-web-page-file.mp4
|
MP4
|
21.5 MB
|
|
|
12 - navigate-between-worksheets-quickly.mp4
|
MP4
|
24.1 MB
|
|
|
13 - how-to-create-a-hyperlink-to-other-worksheets.mp4
|
MP4
|
25 MB
|
|
|
14 - how-to-prevent-someone-to-unhide-a-worksheet.mp4
|
MP4
|
30.5 MB
|
|
|
15 - copying-and-moving-worksheets-with-various-ways.mp4
|
MP4
|
32.5 MB
|
|
|
16 - entering-data-to-multiple-worksheets-at-a-time.mp4
|
MP4
|
17 MB
|
|
|
17 - how-to-print-a-2-page-worksheet-on-1-page.mp4
|
MP4
|
18.5 MB
|
|
|
18 - hiding-scrollbars-in-a-worksheet.mp4
|
MP4
|
20 MB
|
|
|
19 - how-to-set-the-number-of-worksheets.mp4
|
MP4
|
13.1 MB
|
|
|
20 - learning-different-techniques-for-navigating-within-a-given-worksheet.mp4
|
MP4
|
31.6 MB
|
|
|
21 - how-to-create-and-save-custom-views-of-a-worksheet.mp4
|
MP4
|
33.9 MB
|
|
|
22 - solving-the-problem-with-leading-zero.mp4
|
MP4
|
23.2 MB
|
|
|
23 - how-to-add-text-to-a-number.mp4
|
MP4
|
14.6 MB
|
|
|
24 - how-to-enter-a-line-break-into-one-of-your-cells-data.mp4
|
MP4
|
26 MB
|
|
|
25 - using-wrap-text-and-shrink-cell-tools-to-have-the-size-of-the-cells-right.mp4
|
MP4
|
19.6 MB
|
|
|
26 - creating-a-conditional-format-based-on-a-value.mp4
|
MP4
|
22.7 MB
|
|
|
27 - blocking-a-user-to-interact-outside-a-specific-range.mp4
|
MP4
|
18.9 MB
|
|
|
28 - how-to-hide-the-status-bar.mp4
|
MP4
|
13.2 MB
|
|
|
29 - changing-values-without-formulas.mp4
|
MP4
|
16.3 MB
|
|
|
30 - how-to-highlight-formula-cells-using-conditional-formatting.mp4
|
MP4
|
24.9 MB
|
|
|
31 - how-to-color-rows-using-conditional-formatting.mp4
|
MP4
|
24.3 MB
|
|
|
32 - how-to-format-numbers-using-keystroke-shortcuts.mp4
|
MP4
|
12.4 MB
|
|
|
33 - how-to-modify-or-create-a-cell-style.mp4
|
MP4
|
37.3 MB
|
|
|
34 - duplicate-records-and-how-to-get-rid-of-these.mp4
|
MP4
|
19.7 MB
|
|
|
35 - creating-bulleted-list.mp4
|
MP4
|
16.3 MB
|
|
|
36 - format-painter-tips.mp4
|
MP4
|
29.2 MB
|
|
|
37 - how-to-insert-a-watermark.mp4
|
MP4
|
17.5 MB
|
|
|
38 - making-your-comments-stand-out.mp4
|
MP4
|
19.2 MB
|
|
|
39 - creating-a-custom-list.mp4
|
MP4
|
31 MB
|
|
|
40 - the-paste-special-feature.mp4
|
MP4
|
27.2 MB
|
|
|
41 - using-fill-handle-to-enter-sequences-of-values.mp4
|
MP4
|
16.6 MB
|
|
|
42 - how-to-use-flashfill-to-fill-values-in-a-range-rapidly.mp4
|
MP4
|
16.6 MB
|
|
|
43 - how-to-select-data-using-various-keystroke-shortcuts.mp4
|
MP4
|
27.5 MB
|
|
|
44 - how-to-set-a-specific-print-area.mp4
|
MP4
|
13 MB
|
|
|
45 - entering-data-quickly-and-efficiently.mp4
|
MP4
|
21.6 MB
|
|
|
46 - copying-and-moving-data-with-various-ways.mp4
|
MP4
|
17.6 MB
|
|
|
47 - using-pick-from-drop-down-list-and-enter-data-quickly.mp4
|
MP4
|
10.1 MB
|
|
|
48 - using-autocorrect-to-enter-data-fast.mp4
|
MP4
|
12.9 MB
|
|
|
49 - how-to-freeze-titles-and-split-screens.mp4
|
MP4
|
32.4 MB
|
|
|
50 - how-to-create-a-data-entry-form.mp4
|
MP4
|
26.7 MB
|
|
|
51 - filling-non-adjacent-cells-with-the-current-entry.mp4
|
MP4
|
20 MB
|
|
|
52 - highlighting-blank-cells-and-sorting-columns-with-them.mp4
|
MP4
|
24.9 MB
|
|
|
53 - filling-random-values-into-every-cell-in-a-selection.mp4
|
MP4
|
13.8 MB
|
|
|
54 - how-to-generate-random-decimal-numbers-between-0-and-1.mp4
|
MP4
|
11.1 MB
|
|
|
55 - how-to-use-countif-and-data-validation-to-prevent-duplications.mp4
|
MP4
|
22.6 MB
|
|
|
56 - how-to-add-comments-inside-formulas.mp4
|
MP4
|
14.8 MB
|
|
|
57 - the-autosum-magic.mp4
|
MP4
|
18.5 MB
|
|
|
58 - identifying-and-fixing-error-inside-of-an-excel-formula.mp4
|
MP4
|
17.2 MB
|
|
|
59 - finding-related-formulas-easy.mp4
|
MP4
|
15.7 MB
|
|
|
60 - how-to-enter-the-current-date-or-time.mp4
|
MP4
|
8.3 MB
|
|
|
61 - using-the-new-in-excel-2013-function-pduration.mp4
|
MP4
|
10.8 MB
|
|
|
62 - how-to-round-values-with-various-ways.mp4
|
MP4
|
24 MB
|
|
|
63 - converting-formulas-to-values-easy.mp4
|
MP4
|
15.3 MB
|
|
|
64 - using-named-ranges-in-formulas.mp4
|
MP4
|
31 MB
|
|
|
65 - displaying-all-worksheet-formulas-in-a-second.mp4
|
MP4
|
14 MB
|
|
|
66 - using-trim-function-to-get-rid-of-unwanted-spaces.mp4
|
MP4
|
25.7 MB
|
|
|
67 - how-to-calculate-a-person-s-age.mp4
|
MP4
|
11.8 MB
|
|
|
68 - how-to-convert-values-between-measurement-systems.mp4
|
MP4
|
12.1 MB
|
|
|
69 - locking-and-hiding-formula-cells.mp4
|
MP4
|
22.7 MB
|
|
|
70 - formatting-data-as-table-with-table-styles.mp4
|
MP4
|
31.9 MB
|
|
|
71 - using-the-table-reference-to-create-a-formula.mp4
|
MP4
|
19.9 MB
|
|
|
72 - how-to-create-separate-worksheets-from-pivottable.mp4
|
MP4
|
12.9 MB
|
|
|
73 - create-mini-charts-using-sparklines.mp4
|
MP4
|
27.4 MB
|
|
|
74 - linking-chart-titles-with-cell-content.mp4
|
MP4
|
18.7 MB
|
|
|
75 - how-to-make-all-the-charts-exactly-the-same-size.mp4
|
MP4
|
15.9 MB
|
|
|
76 - how-to-deal-with-missing-data-for-a-chart.mp4
|
MP4
|
15.6 MB
|
|
|
77 - creating-a-chart-with-keyboard-shortcuts.mp4
|
MP4
|
12.3 MB
|
|
|
78 - how-to-analyze-an-active-workbook-using-the-inquire-add-in.mp4
|
MP4
|
34.6 MB
|
|
|
79 - how-to-compare-two-lists-of-items-and-identify-difference-between-them.mp4
|
MP4
|
25.5 MB
|
|
|
80 - using-quick-analysis-tool-to-find-information-about-data.mp4
|
MP4
|
18.4 MB
|
|
|
81 - getting-data-from-a-pdf-file.mp4
|
MP4
|
10.3 MB
|
|
|
82 - presenting-information-in-a-more-compact-way-using-group-tool.mp4
|
MP4
|
17.8 MB
|
|
|
83 - applying-goal-seek-tool-to-find-a-target.mp4
|
MP4
|
19 MB
|
|
|
84 - forecasting-scenarios-with-scenario-manager.mp4
|
MP4
|
23.2 MB
|
|
|
85 - monitoring-the-value-in-a-worksheet-using-watch-window.mp4
|
MP4
|
23.2 MB
|
|
|
86 - calculating-running-totals.mp4
|
MP4
|
13.4 MB
|
|
|
Resources.rar
|
RAR
|
2.2 MB
|
|
|
TutsNode.com.txt
|
TXT
|
102.4 B
|
|
|
[TGx]Downloaded from torrentgalaxy.to .txt
|
TXT
|
614.4 B
|
|
|
1
|
|
37.5 KB
|
|
|
2
|
|
181.4 KB
|
|
|
3
|
|
444.3 KB
|
|
|
4
|
|
149.6 KB
|
|
|
5
|
|
487.6 KB
|
|
|
6
|
|
38.8 KB
|
|
|
7
|
|
149.2 KB
|
|
|
8
|
|
91.2 KB
|
|
|
9
|
|
393.8 KB
|
|
|
10
|
|
477.9 KB
|
|
|
11
|
|
16.1 KB
|
|
|
12
|
|
45.3 KB
|
|
|
13
|
|
307.5 KB
|
|
|
14
|
|
335.4 KB
|
|
|
15
|
|
502.4 KB
|
|
|
16
|
|
56.7 KB
|
|
|
17
|
|
327.3 KB
|
|
|
18
|
|
352.3 KB
|
|
|
19
|
|
16.7 KB
|
|
|
20
|
|
265.1 KB
|
|
|
21
|
|
26.6 KB
|
|
|
22
|
|
44.9 KB
|
|
|
23
|
|
54.7 KB
|
|
|
24
|
|
80.1 KB
|
|
|
25
|
|
195.8 KB
|
|
|
26
|
|
338.8 KB
|
|
|
27
|
|
372.9 KB
|
|
|
28
|
|
24.3 KB
|
|
|
29
|
|
281.2 KB
|
|
|
30
|
|
286.3 KB
|
|
|
31
|
|
336.9 KB
|
|
|
32
|
|
368.9 KB
|
|
|
33
|
|
328.1 KB
|
|
|
34
|
|
352.4 KB
|
|
|
35
|
|
413.3 KB
|
|
|
36
|
|
409.6 KB
|
|
|
37
|
|
384.5 KB
|
|
|
38
|
|
511.9 KB
|
|
|
39
|
|
482.2 KB
|
|
|
40
|
|
28.2 KB
|
|
|
41
|
|
96.5 KB
|
|
|
42
|
|
303.8 KB
|
|
|
43
|
|
398.8 KB
|
|
|
44
|
|
341.2 KB
|
|
|
45
|
|
33.8 KB
|
|
|
46
|
|
110 KB
|
|
|
47
|
|
336 KB
|
|
|
48
|
|
480.2 KB
|
|
|
49
|
|
4.1 KB
|
|
|
50
|
|
108.4 KB
|
|
|
51
|
|
225.5 KB
|
|
|
52
|
|
385.2 KB
|
|
|
53
|
|
501.1 KB
|
|
|
54
|
|
313.1 KB
|
|
|
55
|
|
494.8 KB
|
|
|
56
|
|
429.4 KB
|
|
|
57
|
|
448 KB
|
|
|
58
|
|
174.4 KB
|
|
|
59
|
|
226.7 KB
|
|
|
60
|
|
428.3 KB
|
|
|
61
|
|
79.3 KB
|
|
|
62
|
|
267.5 KB
|
|
|
63
|
|
392.6 KB
|
|
|
64
|
|
206.4 KB
|
|
|
65
|
|
212.6 KB
|
|
|
66
|
|
392.6 KB
|
|
|
67
|
|
481.4 KB
|
|
|
68
|
|
236.9 KB
|
|
|
69
|
|
92.6 KB
|
|
|
70
|
|
327.9 KB
|
|
|
71
|
|
421.7 KB
|
|
|
72
|
|
503.3 KB
|
|
|
73
|
|
52.5 KB
|
|
|
74
|
|
139.4 KB
|
|
|
75
|
|
67.6 KB
|
|
|
76
|
|
202.9 KB
|
|
|
77
|
|
407.1 KB
|
|
|
78
|
|
455.8 KB
|
|
|
79
|
|
157.4 KB
|
|
|
80
|
|
369.9 KB
|
|
|
81
|
|
202.7 KB
|
|
|
82
|
|
236.1 KB
|
|
|
83
|
|
456.3 KB
|
|
|
84
|
|
248.8 KB
|
|
|
85
|
|
188.6 KB
|
