Funções CONT.SES, SOMASES e MÉDIASES no Excel 10 Minutos

CLICK HERE TO LEARN MORE ABOUT THE COMPLETE EXCEL IMPRESSIONADOR COURSE: https://lp.hashtagtreinamentos.com/es... -------------------------------------------------------------------- DOWNLOAD THE FREE BASIC EXCEL MINI-COURSE: https://excelparaestagio.klickpages.c... BASIC EXCEL MANUAL [FREE DOWNLOAD]: https://www.hashtagtreinamentos.com/h... ----------------------------------------------------------------------- ► To Download the File Used in the Lesson, Access: https://pages.hashtagtreinamentos.com... ----------------------------------------------------------------------- If you prefer the video in text format: https://www.hashtagtreinamentos.com/f... ----------------------------------------------------------------------- Recommended Videos: ► The 5 BASIC Excel FORMULAS you MUST LEARN before VLOOKUP    • As 5 FÓRMULAS BÁSICAS do Excel que você TE...   ► VLOOKUP - Complete Step-by-Step (without complications)    • PROCV - Passo a Passo Completo (sem compli...   ► Pivot Table - How to make a Pivot Table in Excel 5 Steps!    • Tabela Dinâmica - Como fazer Tabela Dinâmi...   ► EXCEL SPREADSHEET to IMPRESS ANYONE    • PLANILHA EXCEL para IMPRESSIONAR QUALQUER UM   ► Learn EVERYTHING about creating GRAPHS in EXCEL    • Aprenda TUDO sobre como criar GRÁFICOS no ...   ----------------------------------------------------------------------- Hey Impressors! In today's lesson, I want to teach you 3 important Excel functions in 10 minutes! So, if you're short on time, you can watch this quick video and learn a lot. I'll be talking about the SUMIFS, COUNTIFS, and AVERAGEIFS functions. Do you already know any of them? If not, I'll explain each one! Let's start with the SUMIFS function in Excel, which is nothing more than a sum with conditions in Excel, that is, you can specify the criteria for your sum. The COUNTIFS function is very similar, but now we'll have a count with conditions in Excel. This means we can count information (numbers or text) using criteria. The AVERAGEIFS function follows the same principle; we'll calculate an average with conditions in Excel. You may have noticed that the IF at the end of these functions indicates that we can insert a condition into the operation we are performing, so we can restrict this calculation. Now, when we have IFS at the end of the function, it means we can insert two or more conditions into this operation, so we can put 3 conditions to perform a sum. This makes it much easier, because you don't have to filter your table with this information to then be able to perform a calculation; you can do it directly in the function! ----------------------------------------------------------------------- Hashtag Training ► Subscribe to our channel: https://bit.ly/2O6A4RP ► Activate notifications (click the bell)! ► Like our video! ----------------------------------------------------------------------- Social Media ► Blog: https://bit.ly/2MRUZs0 ► YouTube: https://bit.ly/2O6A4RP ► Instagram: https://bit.ly/2F7B6t4 ► Facebook: https://bit.ly/2UA4SwY ► Telegram: https://t.me/joinchat/AAAAAFVJr0C7Il-... ► TikTok: https://bit.ly/3dUpwkW To receive daily content on Microsoft Excel, VBA, and Power BI for free, join our Telegram group: https://t.me/joinchat/AAAAAFVJr0C7Il-... In our videos, we teach various Excel tips and tricks so you can develop your skills in this tool! ----------------------------------------------------------------------- Lesson Content 00:00 Introduction 00:30 Explanation of the database 01:25 COUNTIFS function in Excel 05:00 SUMIFS function in Excel 08:55 AVERAGEIFS function in Excel 09:56 Conclusion #excel #hashtagtrainings