Excel 2016 for PC - Evaluating Data

Rapid Skillz

Course

Online

£ 47.36 VAT inc.

*Indicative price

Original amount in USD:

$ 59

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    Flexible

  • Start date

    Different dates available

This Excel 2016 for PC – Evaluating Data online training series focuses on how to create data validation rules when entering data into your sheet and also to create conditional formatting to help visually analyze data that has already been inputted into the sheet.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

In this Excel 2016 for PC – Evaluating Data online training series presented by Dan Fanella, PhD, learn how Excel’s® validation tools allow you to control and validate the data that is entered into a cell. Data validation also enables you to format and set messages up based upon the data that is entered into a cell. Conditional formatting within Excel allows the user to format cells and data based on existing data in a worksheet – this way, you can create quick visual representation of the data based on specified conditions.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • MS Excel
  • PC training
  • PC
  • Excel
  • Conditional Formatting
  • Data tables
  • Pivot tables
  • Data validation
  • Advanced Formulas
  • Tables & Formatting
  • Advanced Charting
  • Pivot Reporting
  • VBA & Macros
  • Simulations & Solver

Teachers and trainers (1)

Name Name

Name Name

Teacher

Course programme

A. Getting Started
  • What you’ll learn
B. Data Validation
  • Specify data validation criteria
  • Create data validation rule messages
  • Identify invalid data within a data validation range
  • Create a data validation drop-down list
  • Find cells that contain Data Validation rules
  • Clear existing Data Validation rules
C. Conditional Formatting
  • Understand Conditional Formatting
  • Apply Greater Than Conditional Formatting
  • Apply other conditional operators
  • Checking for duplicate values
  • Apply Top/Bottom rules
  • Apply data bars
  • Apply color scales
  • Apply icon sets
  • Create a Conditional Formatting rule
  • Manage Conditional Formatting rules
  • Clear Conditional Formatting rules

Additional information

LENGTH

44 min

See related categories

Excel 2016 for PC - Evaluating Data

£ 47.36 VAT inc.

*Indicative price

Original amount in USD:

$ 59

The best Excel courses

See all

See all