Learning Excel Tips Weekly

Good

Administrator
Staff member
#1
This tips-based course will show Excel users productivity-boosting tricks, cool hidden features, need-to-know functions, and advanced content on subjects such as using PivotTables for data analysis. Tune in every Tuesday for a new tip from expert Dennis Taylor. Each tutorial is a short, self-contained lesson guaranteed to give you new insights into Excel.

Note: Because this is an ongoing series, viewers will not receive a certificate of completion.

Code:
https://www.rovideo.net/videos/1103/01-01-auditing-cell-content-with-watch-window-and-dependent-cell-formulas-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1104/02-002-hide-and-unhide-worksheets-securely-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1105/02-003-resizing-moving-copying-and-manipulating-charts-and-other-objects-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1106/02-004-using-list-boxes-and-combo-boxes-to-facilitate-forms-creation-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1107/02-005-using-the-formulatext-and-n-functions-for-worksheet-and-formula-documentation-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1108/02-006-using-the-isblank-and-countblank-functions-to-check-for-and-tabulate-blank-cells-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1109/02-007-summarizing-data-from-diverse-ranges-with-data-consolidate-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1110/02-008-using-check-boxes-and-conditional-formatting-together-for-dynamic-displays-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1111/02-009-becoming-more-productive-with-these-10-tiny-tips-you-ll-use-often-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1112/02-010-transposing-data-and-charts-for-a-different-perspective-on-your-data-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1113/02-011-applying-conditional-formatting-across-rows-of-data-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1114/02-012-exploring-various-layouts-for-your-pivottable-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1115/02-013-splitting-and-consolidating-workbooks-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1116/02-014-using-date-and-time-as-metrics-in-a-pivottable-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1117/02-015-adding-illustrations-to-your-workbook-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1118/02-016-using-pick-list-vlookup-table-and-chart-together-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1119/02-017-using-formulas-to-calculate-values-across-worksheets-and-workbooks-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1120/02-018-dynamically-presenting-data-via-chart-slicers-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1121/02-019-parsing-your-data-to-create-unique-lists-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1122/02-020-using-the-rept-function-to-represent-data-visually-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1123/02-021-using-source-data-from-a-table-to-make-your-pivottable-more-dynamic-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1124/02-022-accelerating-cut-copy-paste-and-insert-tasks-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1125/02-023-increasing-your-productivity-with-custom-lists-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1126/02-024-highlighting-pivottable-results-with-conditional-formatting-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1127/02-025-customizing-templates-to-fit-your-unique-needs-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1128/02-026-creating-dynamic-charts-with-in-cell-conditional-formatting-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1129/02-027-enhancing-table-filtering-with-slicers-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1130/02-028-converting-charts-into-pictures-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1131/02-029-custom-grouping-in-pivottables-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1132/02-030-quick-formatting-tips-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1133/02-031-the-top-five-unknown-but-useful-keyboard-shortcuts-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1134/02-032-using-the-trend-and-growth-functions-for-projecting-future-results-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1135/02-033-using-scroll-bars-and-spin-buttons-to-facilitate-forms-creation-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1136/02-034-creating-colorful-3d-buttons-for-worksheet-annotation-and-macro-buttons-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1137/02-035-calculating-with-hours-minutes-and-times-of-day-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1138/02-036-tracking-down-cell-dependencies-across-multiple-worksheets-and-workbooks-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1139/02-037-discovering-time-saving-tools-in-the-go-to-special-feature-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1140/02-038-adding-managing-and-printing-comments-for-worksheet-documentation-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1141/02-039-reducing-data-entry-time-by-expanding-autocorrect-options-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1142/02-040-setting-up-custom-views-for-quick-access-to-different-worksheet-displays-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1143/02-041-using-hyperlinks-for-rapidly-switching-worksheet-locations-and-jumping-to-websites-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1144/02-042-controlling-worksheet-security-by-allowing-selected-users-to-edit-specific-cell-ranges-update-20181218-learning-excel-tips-weekly/
 

Good

Administrator
Staff member
#2
Code:
https://www.rovideo.net/videos/1145/02-043-using-option-buttons-group-boxes-and-checkboxes-to-facilitate-forms-creation-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1146/02-044-exploring-what-if-scenarios-using-goal-seek-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1147/02-045-creating-text-numerical-date-and-time-lists-in-a-flash-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1148/02-046-creating-variable-conditional-formatting-rules-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1149/02-047-handling-dates-with-unusual-formats-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1150/02-048-using-wildcards-asterisk-tilde-and-question-mark-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1151/02-049-custom-formats-using-asterisk-semicolon-and-brackets-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1152/02-050-meeting-unusual-filtering-needs-via-advanced-filter-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1153/02-051-create-an-organization-chart-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1154/02-052-two-way-lookup-using-the-match-and-index-functions-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1155/02-053-using-excel-s-error-checking-functions-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1156/02-054-custom-formats-relative-addressing-and-conditional-formatting-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1157/02-055-auditing-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1158/02-056-adding-comments-and-shapes-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1159/02-057-drawing-borders-and-border-grids-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1160/02-058-building-a-flexible-monthly-table-using-functions-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1161/02-059-adding-pictures-as-worksheet-backgrounds-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1162/02-060-address-row-and-column-functions-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1163/02-061-join-data-with-new-concat-and-textjoin-functions-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1164/02-062-working-with-formulas-in-tables-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1165/02-063-locating-data-validation-rules-and-violations-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1166/02-064-creating-an-excel-template-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1167/02-065-restoring-missing-column-titles-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1168/02-066-creating-a-pick-list-dependent-on-another-pick-list-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1169/02-067-pasting-picture-links-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1170/02-068-using-command-shortcuts-with-the-alt-key-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1171/02-069-set-up-a-macro-for-sorting-dynamic-data-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1172/02-070-use-random-number-functions-for-sorting-and-creating-sample-data-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1173/02-071-use-calcuated-fields-and-calculated-items-in-a-pivottable-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1174/02-072-replace-characters-by-position-with-the-replace-function-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1175/02-073-work-with-formulas-in-tables-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1176/02-074-keystroke-shortcuts-from-a-to-z-using-the-ctrl-key-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1177/02-075-use-special-tricks-for-working-with-dates-in-charts-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1178/02-076-use-a-data-form-for-data-entry-and-exploring-data-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1179/02-077-creating-an-excel-template-to-simplify-updating-a-monthly-file-update-20181218-learning-excel-tips-weekly/

https://www.rovideo.net/videos/1180/02-078-calculate-dates-efficiently-using-excel-s-hidden-function-datedif-update-20181218-learning-excel-tips-weekly/
 

Good

Administrator
Staff member
#3
Code:
https://www.rovideo.net/videos/1181/02-079-create-dynamic-sheet-name-references-with-the-indirect-function-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1182/02-080-how-to-use-locked-cells-and-sheet-protection-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1183/02-081-avoid-errors-and-hidden-data-with-the-powerful-aggregate-function-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1184/02-082-hide-worksheets-row-columns-cells-and-other-excel-elements-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1185/02-083-use-slicers-and-charts-together-for-dynamic-presentations-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1186/02-084-save-a-chart-as-a-template-use-the-template-for-current-or-new-charts-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1187/02-085-maxifs-and-minifs-added-to-the-countifsumif-family-of-functions-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1188/02-086-adjust-a-chart-s-source-data-and-adjust-its-series-order-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1189/02-087-use-the-offset-function-for-tabulating-moving-data-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1190/02-088-alter-numeric-data-without-formulas-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1191/02-089-use-flash-fill-to-rapidly-combine-or-separate-columnar-data-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1192/02-090-adjust-banded-row-formatting-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1193/02-091-change-the-shape-of-comment-boxes-and-other-objects-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1194/02-092-how-and-when-to-use-excel-s-10-rounding-functions-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1195/02-093-calculate-faster-with-the-autosum-button-and-autosum-keystroke-shortcut-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1196/02-094-how-to-use-mixed-cell-references-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1197/02-095-adjust-formatting-to-display-large-values-in-thousands-millions-etc-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1198/02-096-activate-the-speak-on-enter-and-speak-cells-features-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1199/02-097-accelerate-data-entry-with-five-special-techniques-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1200/02-098-insert-a-text-box-or-shape-and-link-a-cell-s-content-to-it-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1201/02-099-use-watch-window-and-other-techniques-to-track-changing-cells-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1202/02-100-how-to-create-time-interval-entries-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1203/02-101-how-to-create-frequency-tabulations-and-distributions-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1204/02-102-create-an-expanded-list-from-a-summary-using-pivottable-techniques-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1205/02-103-solve-matching-issues-with-matching-phone-numbers-and-ss-numbers-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1206/02-104-use-choose-to-calculate-fiscal-quarters-and-as-a-vlookup-alternative-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1207/02-105-use-outlining-tools-to-quickly-expand-and-collapse-data-for-dynamic-presentations-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1208/02-106-use-the-subtotal-and-aggregate-functions-to-avoid-double-counting-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1209/02-107-create-lists-of-all-2nd-tuesdays-last-tuesdays-and-other-date-series-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1210/02-108-create-linkage-formulas-that-refer-to-other-worksheets-and-workbooks-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1211/02-109-formula-nesting-using-multiple-functions-in-the-same-formula-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1212/02-110-keyboard-shortcuts-for-numeric-formats-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1213/02-111-use-the-subtotal-command-to-analyze-data-with-single-or-multiple-level-subtotals-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1214/02-112-work-with-max-maxifs-large-and-related-functions-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1215/02-113-use-the-dynamic-today-and-now-functions-for-real-time-up-to-date-calculations-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1216/02-114-use-the-find-mid-left-and-right-functions-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1217/02-115-flip-the-left-to-right-order-of-columns-with-the-index-function-or-sort-by-columns-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1218/02-116-working-with-hidden-data-when-copying-cells-and-creating-charts-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1219/02-117-use-conditional-formatting-data-bars-to-accentuate-negative-data-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1220/02-118-creative-use-of-sparklines-in-merged-cells-with-axes-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1221/02-119-copy-formats-quickly-using-dragging-techniques-and-the-format-painter-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1222/02-120-displaying-multiple-worksheets-and-workbooks-together-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1223/02-121-tips-for-creating-and-updating-sample-data-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1224/02-122-use-conditional-formatting-to-overcome-formatting-limitations-of-the-if-function-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1225/02-123-use-vlookup-match-and-index-functions-with-array-formulas-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1226/02-124-summarize-data-from-different-worksheets-with-a-pivottable-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1227/02-125-autofill-shortcuts-for-date-series-onetwo-week-intervals-eom-and-formulas-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1228/02-126-create-summary-statistics-using-countifs-sumifs-and-averageifs-functions-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1229/02-127-use-custom-formulas-in-data-validation-to-keep-out-bad-data-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1230/02-128-dealing-with-circular-errors-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1231/02-129-tips-for-creating-charts-quickly-update-20181218-learning-excel-tips-weekly/
 

Good

Administrator
Staff member
#4
Code:
https://www.rovideo.net/videos/1232/02-130-creating-heat-maps-using-conditional-formatting-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1233/02-131-using-the-index-function-to-extract-data-by-row-and-column-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1234/02-132-displaying-tips-when-using-excel-in-presentations-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1235/02-133-the-wrap-text-merge-and-center-and-indent-options-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1236/02-134-using-fill-effects-gradients-patterns-styles-for-colorful-cell-background-variations-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1237/02-135-working-with-multiple-worksheets-simultaneously-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1238/02-136-exploring-font-choices-not-found-on-the-home-tab-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1239/02-137-using-wordart-for-special-titles-and-headings-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1240/02-138-differentiating-weekdays-and-weekends-in-excel-data-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1241/02-139-creating-a-2-way-lookup-with-vlookup-hlookup-index-and-match-functions-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1242/02-140-borders-and-gridlines-exploring-variations-options-and-differences-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1243/02-141-new-excel-2016-chart-types-tree-map-and-sunburst-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1244/02-142-freezing-column-and-row-titles-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1245/02-143-use-data-validation-to-force-entries-to-be-uppercase-or-lowercase-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1246/02-144-avoiding-common-chart-distortions-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1247/02-145-use-the-new-funnel-chart-available-in-excel-365-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1248/02-146-combine-data-using-concatenate-concat-and-textjoin-functions-and-the-ampersand-character-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1249/02-147-recognizing-excel-formula-errors-na-value-ref-div0-num-and-name-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1250/02-148-creating-cross-totals-with-the-sumifs-function-and-mixed-references-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1251/02-149-new-excel-2016-chart-types-histogram-pareto-and-box-and-whisker-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1252/02-150-using-the-and-and-or-functions-independently-or-within-if-functions-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1253/02-151-vertical-and-horizontal-alignment-settings-and-orientation-options-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1254/02-152-sorting-tips-and-shortcuts-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1255/02-153-a-look-at-new-chart-types-in-excel-2016-waterfall-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1256/02-154-work-with-formulas-and-formats-decimals-and-fractions-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1257/02-155-creating-mixed-reference-formulas-converting-to-a-table-applying-conditional-formatting-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1258/02-156-control-gridlines-in-charts-and-on-worksheets-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1259/02-157-use-the-indirect-function-with-intersection-formulas-and-range-names-to-extract-data-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1260/02-158-using-expandcollapse-on-pivottables-and-pivotcharts-for-rapid-display-changes-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1261/02-159-control-phone-number-and-postal-code-formats-using-built-in-options-or-customized-formats-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1262/02-160-change-the-default-excel-chart-type-create-and-use-chart-templates-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1263/02-161-create-your-own-customized-date-and-time-formats-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1264/02-162-create-on-screen-warnings-and-reminders-with-comments-or-data-validation-messages-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1265/02-163-use-replace-for-formats-only-for-data-only-or-for-both-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1266/02-164-create-numeric-formats-display-in-thousands-or-millions-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1267/02-165-converting-dates-like-20102006-into-usable-date-entries-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1268/02-166-create-custom-lists-for-letter-series-like-a-to-z-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1269/02-167-freeze-panes-and-split-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1270/02-168-networkdays-intl-and-workday-intl-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1271/02-169-calculate-of-change-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1272/02-170-fill-in-all-blank-cells-within-a-range-with-either-formatting-or-data-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1273/02-171-use-the-count-and-counta-functions-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1274/02-172-use-workbook-protection-to-prevent-use-of-sheet-commands-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1275/02-173-rank-data-with-the-rank-and-rank-avg-functions-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1276/02-174-use-nonstandard-fiscal-years-and-quarters-in-pivottables-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1277/02-175-identify-or-extract-unique-entries-in-a-list-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1278/02-176-keyboard-mouse-and-command-techniques-for-viewing-worksheets-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1279/02-177-create-artistic-charts-with-random-numbers-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1280/02-178-extract-day-month-and-year-from-date-fields-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1281/02-179-compare-data-with-exact-find-and-search-functions-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1282/02-180-how-to-covert-roman-numberals-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1283/02-181-use-range-names-for-more-readable-formulas-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1284/02-182-customize-your-quick-access-toolbar-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1285/02-183-conditional-formatting-based-on-date-proximity-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1286/02-184-how-to-adjust-names-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1287/02-185-differences-and-limitations-of-converting-data-to-a-table-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1288/02-186-avoid-the-div0-error-message-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1289/02-187-explore-formatting-options-not-available-on-the-home-tab-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1290/02-188-control-table-formatting-with-custom-formats-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1291/02-189-use-date-functions-for-age-and-tenure-calculations-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1292/02-190-avoid-unintentional-entries-when-typing-code-numbers-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1293/02-191-sorting-by-moving-columns-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1294/02-192-calculating-cumulative-totals-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1295/02-193-using-the-convert-function-for-different-numbering-systems-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1296/02-194-creating-an-automatically-expanding-chart-by-basing-it-on-a-table-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1297/02-195-keystroke-shortcuts-using-the-alt-key-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1298/02-196-using-the-solver-add-in-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1299/02-197-column-widths-row-heights-merging-cells-and-related-formatting-issues-update-20181218-learning-excel-tips-weekly/
https://www.rovideo.net/videos/1300/02-198-adjusting-default-layouts-and-date-grouping-in-pivottables-update-20181218-learning-excel-tips-weekly/
 

Good

Administrator
Staff member
#5
Short url:
Code:
https://sld.one/Hb6m
https://sld.one/AXmAFVG
https://sld.one/wZfr
https://sld.one/5mbcIb
https://sld.one/qYyzd1
https://sld.one/B9Vp3Lt
https://sld.one/IV2dq
https://sld.one/O7blh
https://sld.one/NLoWZc
https://sld.one/aoYEBYDl
https://sld.one/yNBv2YOS
https://sld.one/BZAhoNcW
https://sld.one/QWDB
https://sld.one/gnULrxK
https://sld.one/CXSY1
https://sld.one/CvJdPZ
https://sld.one/Lhv2
https://sld.one/iSSEop9z
https://sld.one/lnZylY7
https://sld.one/EyA9ln
https://sld.one/oZEQV
https://sld.one/pBXZZM
https://sld.one/rtkZ
https://sld.one/btFE4sS
https://sld.one/WtVoL2Dm
https://sld.one/viQ1kd3
https://sld.one/DvSpG
https://sld.one/nplT
https://sld.one/4acm
https://sld.one/CFvX
https://sld.one/r6xfM9r
https://sld.one/6xcb
https://sld.one/sRjP
https://sld.one/E7WW
https://sld.one/pgXSp
https://sld.one/hU6Spd
https://sld.one/gZ5L
https://sld.one/8n1ki
https://sld.one/2Mepwz
https://sld.one/EnczCfV
https://sld.one/gXlvVS
https://sld.one/4dLdv
https://sld.one/nsNW
https://sld.one/ZTkYJr
https://sld.one/b0hGfvY8
https://sld.one/C5D6R
https://sld.one/raXa
https://sld.one/1Q1x
https://sld.one/V6xxM
https://sld.one/w5bV
https://sld.one/6kduA0Dx
https://sld.one/06xq
https://sld.one/LPzTk
https://sld.one/oawPEI
https://sld.one/1T1wIw
https://sld.one/TZ3YrV
https://sld.one/Xibi3bJ
https://sld.one/GH0wLR
https://sld.one/rVxsG
https://sld.one/JhpARw
https://sld.one/Lzq03W
https://sld.one/QY9K
https://sld.one/4fh8q
https://sld.one/aK8KZ3i
https://sld.one/L0QeB
https://sld.one/6YEOp
https://sld.one/i25v8FQ
https://sld.one/85sVpVT
https://sld.one/7576S
https://sld.one/efLwO1
https://sld.one/qDG19
https://sld.one/JS38
https://sld.one/g47uA
https://sld.one/yyYxP
https://sld.one/BVsrKcA6
https://sld.one/pQCE
https://sld.one/KPjMypxG
https://sld.one/v3DdfSOj
https://sld.one/Dfyb4
https://sld.one/kADQ
https://sld.one/0JfD2
https://sld.one/bv92s34
https://sld.one/njcVJC
https://sld.one/G0p1E0
https://sld.one/7ZUa0
https://sld.one/b9ijI
https://sld.one/4Pfsia
https://sld.one/k5cm9F
https://sld.one/3EOI437p
https://sld.one/oZqNl
https://sld.one/0omB
https://sld.one/YLaSs
https://sld.one/XEHpM5
https://sld.one/hjfkbwvd
https://sld.one/v4A7
https://sld.one/OFajPZ
https://sld.one/uyt0l
https://sld.one/rqj1rKS
https://sld.one/AED18
https://sld.one/tjCHR61
 

Good

Administrator
Staff member
#6
Code:
https://sld.one/zHFkD2CJ
https://sld.one/80yrRY
https://sld.one/RzHO
https://sld.one/LadWB
https://sld.one/rDtZa
https://sld.one/i2Z6xiw
https://sld.one/CIaf
https://sld.one/L2ONbNcQ
https://sld.one/NxPkfgT
https://sld.one/1YlA
https://sld.one/aIv6rVk
https://sld.one/aJKDyxti
https://sld.one/Xz4sQ
https://sld.one/NEqp
https://sld.one/5RbGL
https://sld.one/W5Oi
https://sld.one/lOwtYAqg
https://sld.one/hQIsfnX8
https://sld.one/Rvfuqbk
https://sld.one/gi4ypQc
https://sld.one/H5oAd
https://sld.one/6r7Z
https://sld.one/G66jZ
https://sld.one/cV5bowlw
https://sld.one/ix99XZ
https://sld.one/uKBsLSv
https://sld.one/72GW9oc
https://sld.one/FnixmUn
https://sld.one/Mfnx1
https://sld.one/9RyrYrum
https://sld.one/SYvlHL6
https://sld.one/ngN3tR
https://sld.one/qIQD83YL
https://sld.one/dMHqC4L
https://sld.one/5PEli
https://sld.one/jAtHPXwL
https://sld.one/y96d3m4X
https://sld.one/Y5slN6lf
https://sld.one/0xmhvgV
https://sld.one/f8vIL0
https://sld.one/0VcTeJrL
https://sld.one/YAHn0
https://sld.one/eMMiRd
https://sld.one/mOjNVG
https://sld.one/tDKGGmVE
https://sld.one/7e3yqh
https://sld.one/PhJlKPn
https://sld.one/WZCeJj
https://sld.one/eMkPjm
https://sld.one/doBzK
https://sld.one/SFD50ol
https://sld.one/TXyi2etF
https://sld.one/izROpW9
https://sld.one/VMgUCY
https://sld.one/AAC1Vp
https://sld.one/o1x3NMtX
https://sld.one/PpWvL
https://sld.one/n544xSC
https://sld.one/MP7twt
https://sld.one/aaSimA
https://sld.one/1qOCg
https://sld.one/UqRv
https://sld.one/CeK2X
https://sld.one/9C6YO
https://sld.one/kz2L761Y
https://sld.one/Va8f0Cb
https://sld.one/sLtj05Ge
https://sld.one/DPNbykbL
https://sld.one/oNrZXo
https://sld.one/uebePa
https://sld.one/Vr9vCie
https://sld.one/m1qZVKGE
https://sld.one/r4DgSm
https://sld.one/qjeTp
https://sld.one/IYp2W
https://sld.one/yFNqg
https://sld.one/6skgiD
https://sld.one/HBZKu64
https://sld.one/G5susEa
https://sld.one/rjpyF9X
https://sld.one/xbV1W
https://sld.one/IwWdj7bs
https://sld.one/iFd5Mvat
https://sld.one/ZHzv2
https://sld.one/S16V6x9
https://sld.one/Pegdd
https://sld.one/SbZ3H8eZ
https://sld.one/UEYp
https://sld.one/6tfSiZx
https://sld.one/JpQ7zk
https://sld.one/54il4l
https://sld.one/eYVc7o08
https://sld.one/fNXekgA
https://sld.one/5Z9l7j
https://sld.one/aptsG
https://sld.one/n9GDgN
https://sld.one/QYBpv0K
 

Sponsor

Top