Data Validation in Excel
Course Content
0 / 52 completedIntroduction about Microsoft Excel
Uses of Microsoft Excel
What is Excel 365
Difference Between Excel 365 and Old Version
Importance of Excel 365
Starting with Excel
Creating and Opening of Workbook in Exel
Opening Workbook in Excel
Enter Data in Cell
Explore Interface in Excel
Rows, Columns, and Cells in Excel
Data and Time
Workbook and Worksheet in Excel
Flash fill in Excel
Data Formatting in Excel
Data Validation in Excel
Edit Worksheet Data in Excel
Worksheet Navigation in Excel
Worksheet Appearance in Excel
Freeze and Split Columns and Rows in Excel
Selection of Cells
Delete, Copy, and Moving Data
Documentation in Excel
Worksheet Meddling
Hide Worksheet
Management of Worksheet
Protect Worksheet
Formulas and Functions
Arithmetic Operations
Comparison Operator in Excel
Cell Reference in Excel
Communication Operators in Excel
Order Presence in Excel
Reference Operators in Excel
Coping Formula Cell Wise
Cell Tracing in Excel
Steps in Excel
Text Concatenation in Excel
Arguments in Function
Averaging Point Value in Excel
Text Characters in Excel
Data Extraction in Excel
Range of Values
Function for Text Capitalizing
PMT Function
Alignment in Excel
What if Analytics
Merging Texts
Delete and Insert Rows and Columns
Borders and Colors in Worksheet
Adjusting Rows and Columns in Excel
Cell Style in Excel