filmov
tv
MS EXCEL Drop-down Lists, Extract Unique items for dynamic data validation drop down from Database
Показать описание
#Excel #Exceltricks #ExcelTips #Dropdownlist
In this video, I m going to explain MS EXCEL drop-down lists from simple to advanced levels. Drop-down Lists with unique items for dynamic data validation drop-down list from the main database a column with a list of same items
If you want to learn about software like MS Excel, PowerPoint, MS Word, online data collection tools (like Google Forms, MS Forms, KOBO), How to conduct needs assessment studies, Data management, Windows features and other tips, click the relevant links below:
MS PowerPoint:
MS Access:
MS Word:
Online data collection tools Google Form, KOBO, MS Forms:
Learning Tips:
Project Management:
Windows Features:
Other Software:
Detail Tutorials already shared on the channel (link given above) and upcoming are as below:
Series 2: Learn MS Excel (From Basic to Advance level)- Learn MS Excel from Basic to Advance level developing simple tables, databases, data analysis, and all other topics from basic to advance level, like below:
1. Basic of Excel
2. Basics of Data / Data entry and Databases in Excel (Validations)
3. Basics of Data Analysis via Excel (Basics Formulas)
4. Advance level of Data Analysis via Excel (Advanced Formulas, discover more about your data, spot trends & patterns in data)
5. Analysis with Pivot Table (Slicers and Timelines)
6. Conditional Formatting
7. And more
Series 3: Project Management (Complete Cycle)- In this 3rd series of our Learning Channel, you will learn the complete cycle of project and data management, from basics to advanced level i.e. tools development, databases, implementation, monitoring and evaluation of projects. All the Processes of project management (from inception to proposal submission, implementation, monitoring and end-line evaluation).
Series 4: MS Power Point
Upcoming Tutorials
1. Conducting Research and Studies
2. Interpretation of data and Reporting
3. M&E
4. Result Based Management /Monitoring (RBM)
5. MS Word,
6. Online data collection tools like KOBO, SurveyCTO and more
7. SPSS
In this video, I m going to explain MS EXCEL drop-down lists from simple to advanced levels. Drop-down Lists with unique items for dynamic data validation drop-down list from the main database a column with a list of same items
If you want to learn about software like MS Excel, PowerPoint, MS Word, online data collection tools (like Google Forms, MS Forms, KOBO), How to conduct needs assessment studies, Data management, Windows features and other tips, click the relevant links below:
MS PowerPoint:
MS Access:
MS Word:
Online data collection tools Google Form, KOBO, MS Forms:
Learning Tips:
Project Management:
Windows Features:
Other Software:
Detail Tutorials already shared on the channel (link given above) and upcoming are as below:
Series 2: Learn MS Excel (From Basic to Advance level)- Learn MS Excel from Basic to Advance level developing simple tables, databases, data analysis, and all other topics from basic to advance level, like below:
1. Basic of Excel
2. Basics of Data / Data entry and Databases in Excel (Validations)
3. Basics of Data Analysis via Excel (Basics Formulas)
4. Advance level of Data Analysis via Excel (Advanced Formulas, discover more about your data, spot trends & patterns in data)
5. Analysis with Pivot Table (Slicers and Timelines)
6. Conditional Formatting
7. And more
Series 3: Project Management (Complete Cycle)- In this 3rd series of our Learning Channel, you will learn the complete cycle of project and data management, from basics to advanced level i.e. tools development, databases, implementation, monitoring and evaluation of projects. All the Processes of project management (from inception to proposal submission, implementation, monitoring and end-line evaluation).
Series 4: MS Power Point
Upcoming Tutorials
1. Conducting Research and Studies
2. Interpretation of data and Reporting
3. M&E
4. Result Based Management /Monitoring (RBM)
5. MS Word,
6. Online data collection tools like KOBO, SurveyCTO and more
7. SPSS
0:08:13
0:03:22
0:11:20
0:03:50
0:11:10
0:08:37
0:11:57
0:14:49
1:02:31
0:13:08
0:18:46
0:03:16
0:09:33
0:01:26
0:10:02
0:08:04
0:00:36
0:11:15
0:01:14
0:01:36
0:15:42
0:02:07
0:05:20
0:01:47