Pryor Learning TM Logo Pryor Learning TM Logo
  • Find a Course
    • For You
      • Live Seminars
      • In-Person Events
      • 60-Minute Webinars
      • Other Learning
        Products
      • PryorPlus Course List
    • For Your Team
      • Corporate
      • Government
      • Onsite
    • Training categories
      • Administrative Assistant, Front Desk & Reception
      • Communication Training
      • Computer Software
      • Customer Service
      • Evelyn Wood Speed Reading
      • Finance & Accounting
      • Grammar & Business Writing
      • Human Resources
      • IT
      • Management & Leadership
      • Marketing
      • Microsoft Excel
      • Microsoft Office
      • OSHA & Workplace Safety
      • Personal Development
      • Project Management
      • QuickBooks
      • Sales Training
      • Time Management
      • All Categories
      • Content Spotlight

        Microsoft® Excel® Basics

        (7227)

        1 Day

        • CEU: 0.6
        • CPE: 6

        Virtual Seminars:

        • Dec 2

        • Dec 4

        • Dec 5

        • + 28 more dates

        Training image for Microsoft® Excel® Basics

        Leadership, Team-Building and Coaching Skills for Managers and Supervisors

        (4448)

        1 Day

        • CEU: 0.6
        • CPE: 6
        • HRCI: 5.5
        • PDC: 6

        Virtual Seminars:

        • Dec 3

        • Dec 5

        • Dec 9

        • + 26 more dates

        In-Person Events:

        • Dec 3, Columbus, OH
        • Dec 4, Bloomington, MN

        • + 5 more dates

        Training image for Leadership, Team-Building and Coaching Skills for Managers and Supervisors

      • Learn All Year Long

        PryorPlus for you or your team

        • Free attendance to all in-person events and live virtual seminars priced $399 and below
        • 24/7 access to all on-demand courses
        • Access to microlearning, quizzes, videos, eBooks, webinars and more
        • Unlimited learning in 15+ categories including Excel, HR, Leadership and more
        More information about PryorPlus
        More information about PryorPlus
  • Get Team Training
    • Group Training
      • Corporate Training
      • Government Training
      • Onsite Training
      • PryorPlus Annual Pass
      • Content for Your LMS

      • We bring onsite training to you – in-person or online

        Schedule the perfect training for your team at a time convenient for you.

        • Choose from 200+ topics
        • In-person at your location or online
        • For groups of any size
        • Interactive with a live instructor
        Corporate Training
        View info
        Learn more
  • PryorPlus Annual Pass
  • PryorPlus Login
  • PryorPlus Login

Tag: data validation

Excel Data Validation: Check Formatting of Entered Data

  • Author: Excel Tips and Tricks from Pryor.com
  • Categories:
    • Excel®
  • Tags:
    • data validation
Excel allows you to set certain cells to accept only a certain data format that you specify. You can prompt the user with guidelines about the proper way to enter their data. You can even specify that data must fall in a certain data range if you wish. When data…
Read More
  • Categories
    • Administrative Assistant & Front Desk
    • Business Training Center
    • Communication
    • Computer
    • Continuing Education Category
    • Customer Service
    • Excel Training
    • Excel®
      • Advanced Excel
      • Array Formula
      • Basic Excel
      • Charts
      • Conditional Formatting
      • Formulas
      • Functions
      • Macros
      • PivotTables
      • Sparklines
      • VLOOKUP
    • Finance
    • Front Desk & Admin
    • Grammar & Writing Skills
    • Human Resourses Training
      • HR Corner
    • Management, Supervision & Leadership
    • Marketing
    • Medical
    • OSHA & Workplace Safety
    • Payroll
    • Professional Development
    • Project Management
      • Gantt
    • Sales
    • Self-Improvement
    • Social Media Marketing
    • The PRYOR Learning Brief
    • Time Management
    • Uncategorized
Call Toll-Free: 1-800-780-8476
  • Company
    • About Us
    • Awards and Affiliations
    • Become a Trainer
    • FAQ
    • Contact Us
    • Buyer Satisfaction Guarantee
    • Terms of Use and Policies
    • Privacy Policy
    • Do Not Sell My Personal Information
  • Resources
    • Blog
    • White Papers
    • Case Studies
    • Sitemap
  • Training Categories
    • Administrative Assistant, Front Desk & Reception
    • Communication Training
    • Computer Software
    • Customer Service
    • Evelyn Wood Library
    • Finance & Accounting
    • Grammar & Business Writing
    • Human Resources
    • IT
    • Management & Leadership
    • Marketing
    • Microsoft Excel
    • Microsoft Office
    • OSHA & Workplace Safety
    • Personal Development
    • Project Management
    • QuickBooks
    • Sales Training
    • Time Management
    • All Categories
  • Enterprise Training
    • Corporate Training
    • Government Training
    • Online Training
    • eLearning Library
    • LMS Content
    • Microlearning
    • Learning Paths
  • Training Formats
    • Live Seminars
    • In-Person Events
    • 60-minute Webinars
    • Other Learning Products
    • Onsite Training
  • Continuing Education
    • Continuing Education
    • CEU Credits
    • CPE Credits
    • HRCI Credits
    • PDU Credits
    • SHRM Credits
    • Print Certificates

"*" indicates required fields

Sign up for savings

Receive an immediate $10 off your first purchase and future discounts on training up to 50%.

This field is for validation purposes and should be left unchanged.

Copyright © 2024 Continuous learning from pryor.com. All rights reserved.

X
We value your privacy
This website and its partners process personal data.
To manage what we do with your personal information, please visit our privacy page.
Consent Preferences

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
Reject All Save My Preferences Accept All