advanced excel by pinaki - How to Use Subtotal Formula and Function Detail in Ms Excel || Ep - 05 || Career Development

Advanced Excel Course-এর পঞ্চম ক্লাসে আপনাদের স্বাগতম । আজকে আমরা শিখবো কিভাবে Excel শিটে Subtotal Formula এবং Formula এর ব্যবহার ( How to Use Subtotal Formula and Function Detail in Ms Excel ). Course টি সম্পূর্ণ দেখতে "Advanced Excel Tutorial" Playlist টি সেভ করে রাখুন । Advanced Excel Tutorial - Practice Sheet -https://docs.google.com/spreadsheets/d/1SrCaHbtAU-dfFC3gW8qF7cdBj22sN87x/edit?usp=sharing&ouid=112467127323432164096&rtpof=true&sd=true Exercise file courtesy: Linkedin Learning The SUBTOTAL function in Excel allows users to create groups and then perform various other Excel functions such as SUM, COUNT, AVERAGE, PRODUCT, MAX, etc. Thus, the SUBTOTAL function in Excel helps in analyzing the data provided. Sometimes, we need data based on different categories. SUBTOTALS help us to get the totals of several columns of data broken down into various categories. If you think SUM is handy, wait till you meet SUBTOTAL. SUBTOTAL has so many tricks up its sleeve you’ll be mesmerized, but don’t be put off because this formula is simple.