1 / 4

Master Excel: Series, Ranges & Sorting Tips

Learn to create series, copy ranges, and sort data easily in Excel with step-by-step instructions. Boost your productivity now!

allistair-buck
Télécharger la présentation

Master Excel: Series, Ranges & Sorting Tips

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Series, Ranges, and Sorting

  2. Series: A list of sequential numbers, dates, times, or text • To create a series: • Enter the data for the first and second cells  select the two cells  then drag the “FILL HANDLE” for the selection over the cells you want to fill.

  3. Range – An area made up of two or more cells in an Excel Worksheet. • To Copy Ranges: • Highlight the range of cells --> Right click and select copy OR Ctrl +C • To Paste Ranges: • Click the cell where you want your range to be pasted --> Right click and select paste OR Ctrl +V

  4. To Sort Within Excel: • Highlight the group of cells you want to sort  Menu Bar  Data  Sort • If you have selected more than one column, Excel will ask which column you wish to sort by.

More Related