To transform large sets of data to a meaningful, easy to understand analysis using conditional formatting and data validation
To learn how to use the conditional formatting tools for maximum efficiency and productivity
To build data validation rules for numbers, dates and times, texts
Become more creative in Excel
To use different types of conditional formatting to make your data table more informative
To learn advanced conditional formatting by using formula-based rules
To create single and dependent lists using data validation
The course is applicable for graduating students, academics, working professionals of government and private sector in the field of Sales and Marketing, HR, Finance, Business Analytics, Operations - who regularly needs to work with large data sets. Learning these essential tools will help them to work in more efficient and timely manner.
Section E101: Microsoft Excel Conditional Formatting:
Section E102: Excel Data Validation:
Section E103: Quiz and Q&A
BDT 599
EnrolBDT 1000
EnrolBDT 600
EnrolBDT 400
EnrolBDT 600
Enrol