Excel 2013 - Evaluating Data

Rapid Skillz

Course

Online

£ 47.45 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

In this tutorial series, Excel 2013 – Evaluating Data, we’ll cover a variety of ways to set, control, and check that data entered into Microsoft® Excel® 2013 is valid. From creating error messages to checking data, this series will cover how to get the most out of the data validation functions in Excel.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

In Excel 2013 – Evaluating Data, you’ll learn the specifics of Data Validation, including identifying invalid data and creating a data validation drop-down list. Instructor Dan Kuemmel guides you through Conditional Formatting next, where he’ll discuss highlight cells, data bars, icon sets, and more!
This training course is for Microsoft Office Excel 2013 for Windows.

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
  • Excel
  • Conditional Formatting
  • Data tables
  • Pivot table
  • Advanced Formulas
  • Tables & Formatting
  • Advanced Charting
  • Pivot Reporting
  • VBA & Macros
  • Simulations & Solver
  • Excel Productivity

Teachers and trainers (1)

Name Name

Name Name

Teacher

Course programme

A. Getting Started
  • What you’ll learn in this training
B. Data Validation
  • Specifying data validation criteria
  • Creating data validation rule messages
  • Identifying invalid data within a data validation range
  • Creating a data validation drop-down list
  • Finding cells that contain Data Validation rules
  • Clearing existing Data Validation rules
C. Conditional Formatting
  • Understanding conditional formatting
  • Managing Conditional Formatting rules
  • Clearing Conditional Formatting rules
  • Applying Highlight Cells rules pt. 1
  • Applying Highlight Cells rules pt. 2
  • Applying Highlight Cells rules pt. 3
  • Applying Top/Bottom rules
  • Applying data bars
  • Applying color scales
  • Applying icon sets
  • Creating a Conditional Formatting rule

Additional information

LENGTH

40 min

See related categories

Excel 2013 - Evaluating Data

£ 47.45 VAT inc.

*Indicative price

Original amount in USD:

$ 59

The best Excel courses

See all

See all