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.

Task

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.

Task

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

Everything was clear?

Section 5. Chapter 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.

Task

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.

Task

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

Everything was clear?

Section 5. Chapter 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.

Task

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.

Task

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.

Everything was clear?

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.

Task

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.

Section 5. Chapter 1

Switch to desktop for real-world practiceContinue from where you are using one of the options below