ABOUT THIS COURSE

In this Microsoft Excel Data Visualised and Data Formatting training course, delegates will learn how to quickly interpret and analyse data sources using Excel. After completing this course delegates will be able to: 

  • Apply conditional formatting rules
  • Apply conditional formatting formulas 
  • Manage and delete formatting rules
  • Adding and utilising Sparklines

COURSE CURRICULUM

  • 1

    Highlight Cell Rules

    • Less Than and Greater Than

    • Less Than, Greater Than and Equal To

    • Multiple Less Than, Greater Than and Equal To

    • Between

    • Equal To

    • Text That Contains

    • Date Occuring

    • Duplicates

  • 2

    Top and Bottom Rules

    • Above and Below Average

    • Top and Bottom Items

    • Top and Bottom Percentage

  • 3

    Managing and Clearing Formatting

    • Managing and Clearing Rules

  • 4

    Data Bars

    • Multiple Examples of Data Bars

  • 5

    Colour Scales

    • Multiple Examples of Colour Scales

  • 6

    Icon Sets

    • Multiple Examples of Icon Sets

  • 7

    Conditional Formatting Formulas

    • Date Conditional Formatting Formulas - Example 1

    • Date Conditional Formatting Formulas - Example 2

    • Duplicate Rows Formatting - COUNTIF Function

    • Empty Cell Formatting - AND Function Formulas

    • Multiple Nested Functions - IF, AND, OR

    • Target Setting - Standard Formulas

    • Text Formatting - Average Function

    • Wingdings Formatting - Chart Function

  • 8

    Data Validation and Conditional Formatting

    • Data Validation Lists and Conditional Formatting

  • 9

    Paste Special and Conditional Formatting

    • Conditional Formatting and Paste Special

  • 10

    Conditional Formatting and Linked Data

    • Linked Data and Conditional Formatting

  • 11

    Sparklines

    • Sparklines - Formatting and Modifying

    • Sparklines and Linked Picture - Dashboard

MEET YOUR INSTRUCTOR

Senior Instructor

Richard Walters

Richard Walters is one of NILC's Senior Level Trainer's with more than a decade of experience in IT and Business Skills training. Richard has a very advanced understanding of all Microsoft Office packages, particularly Excel, Word, PowerPoint, Visio and Project.

GET STARTED NOW

  • £99.99

    365 days access to Microsoft Excel Data Visualised and Formatting

    Get started now

FREQUENTLY ASKED QUESTIONS

When does the course start and finish?

The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.


How long do I have access to the course?

How does 1 years access sound? After enrolling, you have unlimited access to this course for 365 days - across any and all devices you own.


What if I am unhappy with the course?

We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 14 days and we will give you a full refund.

RECOMMENDED FOR YOU