Sorting Data in Excel using a Custom List

Sorting Data in Excel using a Custom List  This quick video explains Sorting Data in Excel using a custom list. Excel provides a mechanism to sort using a custom list – this allows us to specify the preferred sort order for a list. So instead of a simple alphabetic...

Custom Cell Formats

Custom Cell Formats This quick video explains how you can Customize the Format of a Cell in Excel. Sometimes in Excel we want to be able to customize the format of a cell – using options which are not available in the normal list of formatting options in Excel....

Flash fill

Flash Fill This quick video explains Flash Fill in Excel. This is a new feature in Excel 2013 – it attempts to workout how to extract data merged into one cell into multiple columns – for example to extract the first name and last name from a single cell....

Slicer tool

Slicer Tool This quick video explains how to use the Slicer Tool to view Data in Excel. The Slicer Tool provides powerful ways of looking at Data in a Pivot Table in different ways. Its new since Excel 2010 but very popular with Pivot Table users. [et_social_follow...

Data Bars

Data Bars This quick video explains Data Bars in Conditional Formatting in Excel. Data Bars – are little graphs that appear in the background of numbered cells that have had conditional formatting applied to them. They provide a useful way of highlighting and...

Show Data Bars and Values as separate columns

Show Data Bars and Values as Separate Columns This quick video explains how to Show Data Bars and Values as Separate Columns in Excel. Learn how to use Conditional Formatting to display Data Bars in a separate cell to the value that is used for conditional formatting...