Professional Training

Conditional Formatting and Data Validation

5
25 ratings
  • Date: 15 Nov 2023
  • Time: 07:00 PM - 10:00 PM
  • Total Hours: 3
  • Class Schedule: Wednesday
  • Registration Deadline: 15 Nov 2023
  • No. of Classes/Sessions: Total 1 Session
  • Venue: Online (Live Class on Zoom)
  • Price: BDT 399

    Enrol

    What you will learn

  • 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

  • Who should attend the program?

    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.

    Training content

    Detailed Content of the Training

    Section E101: Microsoft Excel Conditional Formatting:

    • What is Conditional Formatting?
    • Create Rules in conditional formatting
    • Highlight Cell Rules using conditional formatting.
    • Top/Bottom Rules using conditional formatting
    • Creation of Data Bar using conditional formatting
    • Changing of Color scales
    • Icon set using conditional formatting
    • Manage an existing rule on Conditional formatting.
    • Conditional formatting using formula


    Section E102:
    Excel Data Validation:

    • Understand and create an Excel Data Validation List.
    • Adding a Custom Excel Data Validation Error
    • Making a dependent Dropdown list using Data Validation


    Section E103:
    Quiz and Q&A

    Instructor's Profile

    Mir Masud Uz Zaman

    Mir Masud Uz Zaman is a professional MS Excel...

    Mentor Details

    Certificate Preview

    Student Feedback

    Recommended Courses

    Mir Masud Uz Zaman

    5
    Excel
    Total 2 Sessions
  • 29 & 30 Dec 2023
  • Live Workshop on Excel Pivot Table and Dynamic Dashboard

    BDT 599

    Enrol

    Mohammad Shariar Nafees

    5
    Content
    Total 2 Sessions
  • 10 & 11 Nov 2023
  • Digital Content for Business Growth

    BDT 1000

    Enrol

    Md. Towfiqur Rahman

    5
    MS Excel
    Total 1 Session
  • 18 Nov 2023
  • Data Analytics with Advanced Excel

    BDT 600

    Enrol

    Nusrat Huda

    5
    Email Writing
    Total 1 Session
  • 10 Mar 2022
  • Professional Email Writing

    BDT 600

    Enrol

    Md. Rashedul Islam

    5
    MS Excel
    Total 2 classes
  • 18 & 19 Feb 2022
  • মাইক্রোসফট এক্সেলে হাতেখড়ি

    BDT 400

    Enrol

    Asad Zaman

    5
    MS Excel
    Total 4 classes
  • 30 Dec 2021 & 01, 02, 04 Jan 2022
  • MS Excel - আপনার পেশাজীবনে এগিয়ে যাবার হাতিয়ার

    BDT 600

    Enrol