You'll learn how to swiftly navigate through your numbers and texts, spotting important trends and saving precious time in the process.

Open up the Codefinity Excel workbook and go to the Section 5 worksheet to follow along with the video.

Now, let's explore the key elements of data management and analysis in Excel.

Key Points

Use the Sort button to organize data alphabetically, numerically, or by date;
Sort individual columns or multiple columns to manage complex datasets effectively;
Apply custom sorting with the Custom Sort option to prioritize data based on your specific criteria;
Utilize the Sort A to Z and Sort Z to A for quick alphabetical or numerical sorting;
Explore advanced sorting options to sort by cell color, font color, or cell icon;
Handle ties in your data with secondary sorting criteria to define which entries appear first.

Завдання

Select cells C5 to C25. Click the Sort button, check My data has headers, and choose Product Name, Cell Values and A to Z to sort.
Select the range. Choose Expand the selection, and click Sort. Click Undo.
Select the range. Click the Sort button, check My data has headers, and choose Product Name, Cell Values and A to Z to sort.
Select the range. Select Reorder Level, choose Conditional Formatting Icon, select the red flag, and click OK.
Select the range. Select Category, Cell Colour and choose no colour. Click OK.
Select the range. Change to Unit Price, set Sort On to Cell Values, and choose Smallest to Largest.
Select the range. Select Last Order Date, keep Cell Values and choose Oldest to Newest.
Select the range. Open the Sort dialog, select Unit Price and Smallest to Largest, then click Add Level and select Reorder Level with Conditional Formatting Icon and On Top. Click OK.
Select the range. Choose Reorder Level, Cell Values and Smallest to Largest. Click OK.
To delete levels, highlight a level in the Sort dialog and click Delete.
For custom sorting, select Category, then Custom List and input your categories. Click OK.

Завдання

Select cells C5 to C25. Click the Sort button, check My data has headers, and choose Product Name, Cell Values and A to Z to sort.
Select the range. Choose Expand the selection, and click Sort. Click Undo.
Select the range. Click the Sort button, check My data has headers, and choose Product Name, Cell Values and A to Z to sort.
Select the range. Select Reorder Level, choose Conditional Formatting Icon, select the red flag, and click OK.
Select the range. Select Category, Cell Colour and choose no colour. Click OK.
Select the range. Change to Unit Price, set Sort On to Cell Values, and choose Smallest to Largest.
Select the range. Select Last Order Date, keep Cell Values and choose Oldest to Newest.
Select the range. Open the Sort dialog, select Unit Price and Smallest to Largest, then click Add Level and select Reorder Level with Conditional Formatting Icon and On Top. Click OK.
Select the range. Choose Reorder Level, Cell Values and Smallest to Largest. Click OK.
To delete levels, highlight a level in the Sort dialog and click Delete.
For custom sorting, select Category, then Custom List and input your categories. Click OK.

Mark tasks as Completed

Все було зрозуміло?

Секція 5. Розділ 1

Choose your plan

Sorting Data

Ever feel overwhelmed by a disorganized spreadsheet? Let's simplify that.

Sorting your data in Excel isn't just about making things look tidy — it's about making your data work for you.

You'll learn how to swiftly navigate through your numbers and texts, spotting important trends and saving precious time in the process.

Open up the Codefinity Excel workbook and go to the Section 5 worksheet to follow along with the video.

Now, let's explore the key elements of data management and analysis in Excel.

Key Points

Use the Sort button to organize data alphabetically, numerically, or by date;
Sort individual columns or multiple columns to manage complex datasets effectively;
Apply custom sorting with the Custom Sort option to prioritize data based on your specific criteria;
Utilize the Sort A to Z and Sort Z to A for quick alphabetical or numerical sorting;
Explore advanced sorting options to sort by cell color, font color, or cell icon;
Handle ties in your data with secondary sorting criteria to define which entries appear first.

Завдання

Select cells C5 to C25. Click the Sort button, check My data has headers, and choose Product Name, Cell Values and A to Z to sort.
Select the range. Choose Expand the selection, and click Sort. Click Undo.
Select the range. Click the Sort button, check My data has headers, and choose Product Name, Cell Values and A to Z to sort.
Select the range. Select Reorder Level, choose Conditional Formatting Icon, select the red flag, and click OK.
Select the range. Select Category, Cell Colour and choose no colour. Click OK.
Select the range. Change to Unit Price, set Sort On to Cell Values, and choose Smallest to Largest.
Select the range. Select Last Order Date, keep Cell Values and choose Oldest to Newest.
Select the range. Open the Sort dialog, select Unit Price and Smallest to Largest, then click Add Level and select Reorder Level with Conditional Formatting Icon and On Top. Click OK.
Select the range. Choose Reorder Level, Cell Values and Smallest to Largest. Click OK.
To delete levels, highlight a level in the Sort dialog and click Delete.
For custom sorting, select Category, then Custom List and input your categories. Click OK.

Завдання

Select cells C5 to C25. Click the Sort button, check My data has headers, and choose Product Name, Cell Values and A to Z to sort.
Select the range. Choose Expand the selection, and click Sort. Click Undo.
Select the range. Click the Sort button, check My data has headers, and choose Product Name, Cell Values and A to Z to sort.
Select the range. Select Reorder Level, choose Conditional Formatting Icon, select the red flag, and click OK.
Select the range. Select Category, Cell Colour and choose no colour. Click OK.
Select the range. Change to Unit Price, set Sort On to Cell Values, and choose Smallest to Largest.
Select the range. Select Last Order Date, keep Cell Values and choose Oldest to Newest.
Select the range. Open the Sort dialog, select Unit Price and Smallest to Largest, then click Add Level and select Reorder Level with Conditional Formatting Icon and On Top. Click OK.
Select the range. Choose Reorder Level, Cell Values and Smallest to Largest. Click OK.
To delete levels, highlight a level in the Sort dialog and click Delete.
For custom sorting, select Category, then Custom List and input your categories. Click OK.

Mark tasks as Completed

Все було зрозуміло?

Секція 5. Розділ 1

Choose your plan

Sorting Data

Ever feel overwhelmed by a disorganized spreadsheet? Let's simplify that.

Sorting your data in Excel isn't just about making things look tidy — it's about making your data work for you.

You'll learn how to swiftly navigate through your numbers and texts, spotting important trends and saving precious time in the process.

Open up the Codefinity Excel workbook and go to the Section 5 worksheet to follow along with the video.

Now, let's explore the key elements of data management and analysis in Excel.

Key Points

Use the Sort button to organize data alphabetically, numerically, or by date;
Sort individual columns or multiple columns to manage complex datasets effectively;
Apply custom sorting with the Custom Sort option to prioritize data based on your specific criteria;
Utilize the Sort A to Z and Sort Z to A for quick alphabetical or numerical sorting;
Explore advanced sorting options to sort by cell color, font color, or cell icon;
Handle ties in your data with secondary sorting criteria to define which entries appear first.

Завдання

Select cells C5 to C25. Click the Sort button, check My data has headers, and choose Product Name, Cell Values and A to Z to sort.
Select the range. Choose Expand the selection, and click Sort. Click Undo.
Select the range. Click the Sort button, check My data has headers, and choose Product Name, Cell Values and A to Z to sort.
Select the range. Select Reorder Level, choose Conditional Formatting Icon, select the red flag, and click OK.
Select the range. Select Category, Cell Colour and choose no colour. Click OK.
Select the range. Change to Unit Price, set Sort On to Cell Values, and choose Smallest to Largest.
Select the range. Select Last Order Date, keep Cell Values and choose Oldest to Newest.
Select the range. Open the Sort dialog, select Unit Price and Smallest to Largest, then click Add Level and select Reorder Level with Conditional Formatting Icon and On Top. Click OK.
Select the range. Choose Reorder Level, Cell Values and Smallest to Largest. Click OK.
To delete levels, highlight a level in the Sort dialog and click Delete.
For custom sorting, select Category, then Custom List and input your categories. Click OK.

Завдання

Select cells C5 to C25. Click the Sort button, check My data has headers, and choose Product Name, Cell Values and A to Z to sort.
Select the range. Choose Expand the selection, and click Sort. Click Undo.
Select the range. Click the Sort button, check My data has headers, and choose Product Name, Cell Values and A to Z to sort.
Select the range. Select Reorder Level, choose Conditional Formatting Icon, select the red flag, and click OK.
Select the range. Select Category, Cell Colour and choose no colour. Click OK.
Select the range. Change to Unit Price, set Sort On to Cell Values, and choose Smallest to Largest.
Select the range. Select Last Order Date, keep Cell Values and choose Oldest to Newest.
Select the range. Open the Sort dialog, select Unit Price and Smallest to Largest, then click Add Level and select Reorder Level with Conditional Formatting Icon and On Top. Click OK.
Select the range. Choose Reorder Level, Cell Values and Smallest to Largest. Click OK.
To delete levels, highlight a level in the Sort dialog and click Delete.
For custom sorting, select Category, then Custom List and input your categories. Click OK.

Все було зрозуміло?

Ever feel overwhelmed by a disorganized spreadsheet? Let's simplify that.

Sorting your data in Excel isn't just about making things look tidy — it's about making your data work for you.

You'll learn how to swiftly navigate through your numbers and texts, spotting important trends and saving precious time in the process.

Open up the Codefinity Excel workbook and go to the Section 5 worksheet to follow along with the video.

Now, let's explore the key elements of data management and analysis in Excel.

Key Points

Use the Sort button to organize data alphabetically, numerically, or by date;
Sort individual columns or multiple columns to manage complex datasets effectively;
Apply custom sorting with the Custom Sort option to prioritize data based on your specific criteria;
Utilize the Sort A to Z and Sort Z to A for quick alphabetical or numerical sorting;
Explore advanced sorting options to sort by cell color, font color, or cell icon;
Handle ties in your data with secondary sorting criteria to define which entries appear first.

Завдання

Select cells C5 to C25. Click the Sort button, check My data has headers, and choose Product Name, Cell Values and A to Z to sort.
Select the range. Choose Expand the selection, and click Sort. Click Undo.
Select the range. Click the Sort button, check My data has headers, and choose Product Name, Cell Values and A to Z to sort.
Select the range. Select Reorder Level, choose Conditional Formatting Icon, select the red flag, and click OK.
Select the range. Select Category, Cell Colour and choose no colour. Click OK.
Select the range. Change to Unit Price, set Sort On to Cell Values, and choose Smallest to Largest.
Select the range. Select Last Order Date, keep Cell Values and choose Oldest to Newest.
Select the range. Open the Sort dialog, select Unit Price and Smallest to Largest, then click Add Level and select Reorder Level with Conditional Formatting Icon and On Top. Click OK.
Select the range. Choose Reorder Level, Cell Values and Smallest to Largest. Click OK.
To delete levels, highlight a level in the Sort dialog and click Delete.
For custom sorting, select Category, then Custom List and input your categories. Click OK.

Секція 5. Розділ 1

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів