Text Functions

Text Functions This quick video explains the Text Functions in Excel. Working with text learn how to convert to upper or lower case, remove unnecessary spaces and extract elements of a cell. Learn to work with Lower, Proper, Trim, Exact and Concatenate....

Sorting data alphabetically

Sorting Data Alphabetically This quick video explains how to sort Data Alphabetically in Excel Sorting data alphabetically is the most common way of sorting textual data in Excel – usually in Ascending going from A – Z or in descending Z – A order. Learn how to Sort...

Applying a Filter

Applying a Filter This quick video explains how to Apply a Filter in your Excel worksheet. Once a Filter has been enabled on a list or table – we can turn on or off a filter and use it to select a range of cells that matches the filter selected. [et_social_follow...

Filtering by date number and text

Filtering by Date , Number and Text This quick video explains how to Filter by Date, Number and Text in Excel. Filtering by Date Number and Text. Once a filter is applied to a list – we can filter based on the values in each of the rows. Here we look at applying...

Sorting and Filtering by Format

Sorting and Filtering by Format This quick video explains Sorting and Filtering by Format in Excel. Sorting and Filtering by Format Excel provides a powerful new Filtering option – that allows us to Filter based on the format that the cell has been formatted in. This...

Data Validation

Data Validation This quick video explains using Data Validation in Excel. We can use Excel’s powerful Data Validation rules to ensure that data entered into a cell is of the correct type and range for the table it is being inserted into – we can restrict the values...