Text to Columns

Text to Columns This quick video will explain how to split contents of a cell across multiple cells. Regularly when importing a text file – multiple pieces of data will end up in one cell – the Text to Columns option allows to us to split the contents of a cell across...

Importing CSV files

Importing CSV Files This quick video explains how to Import Text or CSV Files. CSV Files are one of the most common TXT file types you will come across. We are regularly required to work CSV files in Excel and there are a number of options that are presented when...

Manage Conditional Formatting Rules

Manage Conditional Formatting Rules This quick video explains how to Manage the Rules and options within Conditional Formatting in Excel Learn how to manage the rules and options within conditional formatting – changing and understanding these rules is important to...

Icon Sets

Icon Sets This quick video explains how you use Icon Sets in Conditional Formatting in Excel Traffic light icons, signal bars, indicators and other symbols can be used to highlight values in a range of cells and compare them with each other using icon sets....

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