advanced excel by pinaki - Conditional Formatting ( Vlookup + Countif Refresh ) in Ms Excel || Ep - 12 || Career Development

Advanced Excel Course-এর 12th ক্লাসে আপনাদের স্বাগতম । আজকে আমরা শিখবো Conditional Formatting advanced used । Course টি সম্পূর্ণ দেখতে "Advanced Excel Tutorial" Playlist টি সেভ করে রাখুন । Conditional formatting is a feature in many spreadsheet applications that allows you to apply specific formatting to cells that meet certain criteria. It is most often used as color-based formatting to highlight, emphasize, or differentiate among data and information stored in a spreadsheet. Conditional formatting enables spreadsheet users to do a number of things. First and foremost, it calls attention to important data points such as deadlines, at-risk tasks, or budget items. It can also make large data sets more digestible by breaking up the wall of numbers with a visual organizational component. Finally, conditional formatting can transform your spreadsheet (that previously only stored data) into a dependable “alert” system that highlights key information and keeps you on top of your workload. Originally a powerful feature of Excel, other spreadsheet applications have also adopted this functionality. Practice Sheet - https://docs.google.com/spreadsheets/d/1I_SPIBO7u55UGfMcAubHNy9uSQVDJtnF/edit?usp=sharing&ouid=114464349437213564793&rtpof=true&sd=true ⚡⚡সাবসক্রাইব⚡⚡ Link to previous videos: ➤➤ How to Find Formula & Figure - https://youtu.be/_adlRMXMmCQ ➤➤Entire Row and Column References - https://youtu.be/a-Aws3rnU0M ➤➤ How to Use Range Name in Ms Excel - https://youtu.be/tus-1dhCqPI ➤➤ How to use 3D Formula in MS Excel - https://youtu.be/OxMCkaGArQI ➤➤Subtotal Formula and Function - https://youtu.be/h4YbszjXswI ➤➤IF Formula Simple to Advance - https://youtu.be/2Zz7UxQbMF8 ➤➤ How to use Conditional Formatting - https://youtu.be/onp03njOmU8 FOLLOW ME ON: ⚡⚡ আমার ফেসবুক পেজ - https://www.facebook.com/AuthorPinaki ⚡⚡ আমার টুইটার হ্যান্ডেল - https://twitter.com/PinakiTweetsBD MORE VIDEOS: ➤➤ How to use 3D Formula in MS Excel - https://youtu.be/OxMCkaGArQI ➤➤Subtotal Formula and Function - https://youtu.be/h4YbszjXswI ➤➤ Nested IF Formula - https://youtu.be/w_ajDuPdEUc ➤➤ Clean Data in Excel - https://youtu.be/qzWnUpBMatA ➤➤IF Formula Simple to Advance - https://youtu.be/2Zz7UxQbMF8 ➤➤ How to use Conditional Formatting - https://youtu.be/onp03njOmU8 ➤➤ How to Find Formula & Figure - https://youtu.be/_adlRMXMmCQ ➤➤Entire Row and Column References - https://youtu.be/a-Aws3rnU0M ➤➤ How to Use Range Name in Ms Excel - https://youtu.be/tus-1dhCqPI DISCLAIMER: This channel may use some copyrighted materials without specific authorization of the owner but contents used here which is under the “Fair Use” of YouTube Policy. Copyright Disclaimer under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use. All Rights Reserved. ©2017-2021 Pinaki Bhattacharya. #countif #sumif #averageif #excel #msexcel