Excel Tutorial: Select in Excel non-contiguous cell ranges | ExcelCentral.com
In this video lesson you'll learn how to select non-contiguous cell ranges and view summary information in
Excel.
At
http://ExcelCentral.com you can view over 850 free Excel video lessons just like this one.
All in full HD with vari-speed and human-transcribed subtitles providing the perfect Excel learning environment. You can also track your progress through the course and print a certificate upon completion. Separate videos are provided for
Excel 2007,
Excel 2010 and Excel
2013.
Non-contiguous cells are blocks of cells that are not next to each other. You'll learn how to select cells using both the mouse and the keyboard and how to view quick summary information about the cells you have selected such as the Average,
Count,
Minimum, Maximum and Sum of the values selected.
This video comes from the Doing Useful
Work with Excel session (
Session 2 in our Excel
Essential Skills free video training course). This session includes the following video lessons:
▪
Lesson 2-1:
Enter text and numbers into a worksheet (9m 27s) http://excelcentral.com/excel2013/essential/lessons/02010-how-to-use-excel-text-and-numbers
.html
▪ Lesson 2-2:
Create a new workbook and view two workbooks at the same time (5m 38s) http://excelcentral.com/excel2013/essential/lessons/02020-create-new-workbook-and-view-two-workbooks-at-the-same-time.html
▪ Lesson 2-3: Use AutoSum to quickly calculate totals (4m 21s) http://excelcentral.com/excel2013/essential/lessons/02030-autosum-in-excel-quickly-calculate-totals.html
▪ Lesson 2-4:
Select a range of cells and understand
Smart Tags (6m 24s) http://excelcentral.com/excel2013/essential/lessons/02040-select-in-excel-range-of-cells-and-understand-smart-tags.html
▪ Lesson 2-5: Enter data into a range and copy data across a range (5m 45s) http://excelcentral.com/excel2013/essential/lessons/02050-excel-copy-data-across-a-range-and-enter-data-into-a-range.html
▪ Lesson 2-6: Select adjacent and non-adjacent rows and columns (3m 34s) http://excelcentral.com/excel2013/essential/lessons/02060-select-in-excel-rows-and-columns-adjacent-and-non-adjacent.html
▪ Lesson 2-7: Select non-contiguous cell ranges and view summary information (5m 23s) http://excelcentral.com/excel2013/essential/lessons/02070-select-in-excel-non-contiguous-cell-ranges-and-view-summary-information.html
▪ Lesson
2-8: AutoSelect a range of cells (5m 16s) http://excelcentral.com/excel2013/essential/lessons/02080-select-in-excel-with-autoselect-a-range-of-cells.html
▪ Lesson 2-9: Re-size rows and columns (5m 21s) http://excelcentral.com/excel2013/essential/lessons/02090-resize-excel-cells-rows-columns.html
▪ Lesson 2-10: Use AutoSum to sum a non-contiguous range (3m 53s) http://excelcentral.com/excel2013/essential/lessons/02100-autosum-in-excel-non-contiguous-ranges-sum.html
▪ Lesson 2-11: Use AutoSum to quickly calculate averages (5m 35s) http://excelcentral.com/excel2013/essential/lessons/02110-average-in-excel-autosum.html
▪ Lesson
2-12: Create your own formulas (7m 19s) http://excelcentral.com/excel2013/essential/lessons/02120-formulas-in-excel.html
▪ Lesson 2-13: Create functions using
Formula AutoComplete (6m 34s) http://excelcentral.com/excel2013/essential/lessons/02130-excel-autocomplete-formulas.html
▪ Lesson 2-14: Use AutoFill for text and numeric series (5m 29s) http://excelcentral.com/excel2013/essential/lessons/02140-excel-autofill-text-and-numeric-series.html
▪ Lesson 2-15: Use AutoFill to adjust formulas (7m 11s) http://excelcentral.com/excel2013/essential/lessons/02150-excel-formula-autofill.html
▪ Lesson 2-16: Use AutoFill options (5m 27s) http://excelcentral.com/excel2013/essential/lessons/02160-excel-autofill-options.html
▪ Lesson 2-17:
Speed up your AutoFills and create a custom fill series (6m 10s) http://excelcentral.com/excel2013/essential/lessons/02170-autofill-in-excel-speed-up-your-autofills-and-create-a-custom-fill-series.html
▪ Lesson
2-18: Use automatic
Flash Fill to split delimited text (5m 54s) http://excelcentral.com/excel2013/essential/lessons/02180-excel-flash-fill-split-text.html
▪ Lesson 2-19: Use manual Flash Fill to split text (6m 33s) http://excelcentral.com/excel2013/essential/lessons/02190-excel-flash-fill-manual-split-text.html
▪ Lesson 2-20: Use multiple example Flash Fill to concatenate text (6m 31s) http://excelcentral.com/excel2013/essential/lessons/02200-excel-flash-fill-multiple-example-concatenate.html
▪ Lesson 2-21: Use Flash Fill to solve common problems (5m 20s) http://excelcentral.com/excel2013/essential/lessons/02210-excel-flash-fill.html
▪ Lesson
2-22: Use the zoom control (3m 12s) http://excelcentral.com/excel2013/essential/lessons/02220-excel-zoom-in.html
▪ Lesson 2-23:
Print out a worksheet (12m 7s) http://excelcentral.com/excel2013/essential/lessons/02230-excel-print.html
You can watch any of the 850 Excel video lessons, free and without any required registration at http://excelcentral.com/excel2013/essential/tutorials/default.html.