Introduction to Excel
Security
Short Keys
Practice Data Sheets
Data Formats
Conditional Formatting
Format as Table
Data Sorting
Data Filtering
Remove Duplicates
Data Validation
Text-To-Columns
Data Consolidation
What-if-Analysis
Grouping
Absolute & Relative Referencing
Mathematical Functions - Sum, Sumif, Sumifs, Count, Counta, Countif, Max, Min, Average
Task1 - Mathematical Formulas
Logical Functions - IF, IFERROR, AND, OR
Date Time Functions - Date, Year, Month, Day, Time, Hour, Minute, Second, Today, Now, Datedif
Text Functions - Proper, Left, Right, Concatenate, Exact, Find, Search, Mid, Replace, Text, Replace
Vlookup Formula
Task2 - Vlookup Problems
Vlookup with Match Formula - Dynamic Duo
Vlookup using (*) example
Vlookup with Running Countif
Task3 - Vlookup, Running Countif Problem
Lookup Functions - Hlookup, Index Match
Lookup Functions - Indirect, Offset
Vlookup-Indirect Example
Sumif, Indirect, Offset, Match Example
Array Functions
Task4 - Array Problem
Advanced Conditional Formatting using Formula
Data Validation using Indirect Function
Charts, Waterfall Graph
Pivot Table, Dashboards

Powered by GitBook

On this page

Was this helpful?

Data Validation

PreviousRemove Duplicates NextText-To-Columns

Last updated 6 years ago

Was this helpful?

Data Validation

You can use data validation to restrict the type of data or the values that users enter into a cell. One of the most common data validation uses is to create a drop-down list.

Short Key --> Alt + A + V