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...