Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

Excel - Analysing Data with Conditional Formatting

Simon Lambourne, Microsoft Certified Trainer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
3 Videos (25m)
    • Applying Conditional Formatting

      8:31
    • Top Bottom Rules

      5:25
    • Text, Duplicate and Formula Rules

      11:16

About This Class

Excel is not just about figures and formulas. There are other tools available to make analysing data visually easier. Conditional Formatting allows you to colour in cells based upon their value.

For Example, you can set high numbers to turn red and low numbers green.

This course will give you an introduction into setting up and creating your own Conditional Formatting rules to suit your needs. You could use Conditional Formatting when reporting on anything from sales figures, feedback scores to exam marks.

This course will show you which rules work best with which type of information you are working with. And you can follow along with the course using the exercises found in the Class Project.

Enjoy!

1

Student

--

Projects

0

Reviews (0)

Simon Lambourne

Microsoft Certified Trainer

I have been an IT trainer for over 8 years and have acquired many skills in teaching different software packages to students of all abilities. I aim to build confidence in all attendees of the courses that I teach, for both large and small groups. Through my professional conduct and enthusiasm when working with learners of mixed levels, I am able to create good rapport with students, which forms a high-quality learning environment. I believe it is important to enjoy attending each training co...

See full profile