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

Top Bottom Rules

Top Bottom Rules This quick video explains Top Bottom rules in Conditional Formatting Top Bottom rules in conditional formatting provide a useful way of highlighting the top or bottom values in a range. If you have a group of cells we can ask Excel to take out the top...

Highlight Cell Rules

Highlight Cell Rules This quick video explains Highlighting Cells in Conditional Formatting in Excel. Highlight Cell Rules. Conditional formatting provides a powerful way to highlight data in a list. The foundation of conditional formatting are the rules you need to...

Extra Pivot Table options in Excel 2013

Extra Pivot Table Options in Excel 2013 This quick video will show you the difference between Excel 2010 and Excel 2013 Pivot Tables Excel adds a number of New Features in Excel 2013. Here you can find the differences between Excel 2010 and Excel 2013 Pivot Tables –...

Editing Pivot Table options

Editing Pivot Table Options This quick video will show you your different Options to Edit in Pivot Tables . The Pivot Table options allows us to name our Pivot Table – useful if you have a number of Pivot Tables. We can also modify change the layout, totals, display,...