Support
Log In

Tutorials
Tips
Dailies
Blog/News
Testimonials
Pricing
Menu

Validating Data

In this video we look at how we can validate data in cells in a Microsoft Excel worksheet.

Highlighting and Removing Duplicates

Consolidating Data

Back to: Tutor for Microsoft Excel for the Mac > Working with Data

Tutor for Microsoft Excel for the Mac Lessons

Previous
Next

Introduction to Microsoft Excel
Introduction
Interface Overview
Managing Windows and Full Screen Mode
Working with Workbooks and Worksheets
Working with Workbooks and Worksheets Introduction
Creating Workbooks and Templates
Page Layout, Themes, and View Options
Adding Headers and Footers
Adding Security to a Workbook
Working with Worksheets
Splitting and Freezing Panes in a Worksheet
Working with Cells
Working with Cells Introduction
Adding Text and Formulas to Cells
Selecting, Styling, and Formatting Cells
Adding Borders and Fills to Cells
Using the Format Painter
Adding Conditional Formatting to Cells
Clearing and Autofilling Cells
Merging Multiple Cells into One Cell
Moving, Inserting, and Deleting Cells
Working with Rows and Columns
Working with Rows and Columns Introduction
Moving and Resizing Rows and Columns
Adding and Hiding Rows and Columns
Sorting and Filtering Columns
Grouping Rows and Columns
Tables, Pictures, Shapes, and Charts
Tables, Pictures, Shapes, and Charts Introduction
Creating and Formatting Tables
Working with PivotTables
Working with Pictures
Working with Text Boxes and Shapes
Working with SmartArt
Working with Charts
Working with Data
Working with Data Introduction
Creating Data Connections
Converting Text to Columns
Highlighting and Removing Duplicates
Validating Data
Consolidating Data
Review Options
Review Options Introduction
Checking Spelling
Adding Comments to Cells
Tracking and Reviewing Changes
Printing and Sharing Options
Printing and Sharing Options Introduction
Printing Options
Sharing Documents
Exporting Documents
Excel Shortcuts and Preferences
Excel Shortcuts and Preferences Introduction
Cut, Copy, and Paste Options
Undo and Redo Changes
Excel Preferences
Download Tutorial
Download Tutor for Excel

Latest News

Tutor for Apple Watch with watchOS 5 Now AvailableMay 28, 2019 - 12:21 pm
Flick Keys on the iPad to access Numbers and SymbolsApril 15, 2019 - 10:50 am
LESSON PREVIEW: Which watchOS am I using?April 8, 2019 - 9:15 am
Apple Didn’t Solve Our Horrible Gadget-Charging Mess and Nobody Else Has, EitherApril 4, 2019 - 1:00 pm
Tutor for using AutoFill with Forms and Passwords is now availableMarch 18, 2019 - 3:38 pm

Like this page? Please share with friends/family.

App Store Availability

Select Tutorials are also available in the App Stores

Account Info

Log In
My Account
Contact Us

App Store Availability

Select Tutorials are also available in the App Stores

Terms of Use and Privacy Policy

Terms of Use
Privacy Policy

© 2019 Noteboom Productions, Ltd. All Rights Reserved. Noteboom Productions, Ltd, and Noteboom Tutorials are independent websites and have not been authorized, sponsored, or otherwise approved by Apple Inc.

Highlighting and Removing Duplicates Consolidating Data