How to Use Conditional Formatting in Microsoft Excel

In this two-minute video, Nicky explains how to use Conditional Formatting in Microsoft Excel.

Conditional Formatting is a great way to quickly see which data matches a certain filter at a glance. For example, you could highlight your biggest sales to make them easily stand out.

Word Courses from Happy Computers in London

At Happy, we have been hearing from learners about the different ways you use Microsoft Word. Some of you create multiple documents, often with lots of dynamic content and formatting. Others need to focus on one really big project, such as an annual report or a dissertation, where document structure and multiple drafts are critical. The knowledge and skills you require in each scenario are very different.

How to Improve Your Excel Spreadsheets With Data Validation

Have you ever seen an Excel spreadsheet with a dropdown list in it and wondered how it was done?

This is data validation. Data validation improves the data in your spreadsheets. It makes reporting much easier as there is no risk of typos and no risk of an entry not fitting into your criteria.

In this blog we will take data validation a step further and look at how to make one drop-down list change its values depending on the choice made in a previous drop-down.