Excel 101 - Favorite Excel Functions: Episode 1645

Microsoft Excel Tutorial: 10 Top Excel Functions for People Starting their Excel journey. Welcome to the Don't Fear the Spreadsheet podcast. In this episode, we will be discussing our favorite Excel functions. I'm Bill Jelen from MrExcel.com and I will be sharing some of my top picks, along with a special guest appearance from Mike 'Excel is Fun' Girvin, author of "Slaying Excel Dragons." One of my go-to functions is =COUNTA(), which counts anything that is non-blank in a range. This is especially useful when you need to count text or numbers, as the =COUNT() function only counts numbers. Another handy function for creating random data sets is =INDEX(), which allows you to select a random value from a list. This is great for situations like picking a name out of a hat for a department staff meeting. For those of you who are constantly doing date math, the =DATE() function is a must-know. It is incredibly versatile and can be used in conjunction with other functions like =YEAR() and =MONTH() to easily manipulate dates. But enough from me, let's hear from our guest podcaster, Mike Girvin, on his favorite Excel functions. Mike's top picks include the =IF(), =AVERAGE(), =COUNTIFS(), and =SUMIFS() functions. The =IF() function is great for situations where you need to put one of two things in a cell, depending on a logical test. The =AVERAGE() function is perfect for finding the average of a range of cells, and can be easily copied down using the fill handle. The =COUNTIFS() and =SUMIFS() functions are useful for counting and summing values based on multiple criteria. But don't just take our word for it, check out Mike's book "Slaying Excel Dragons" for a comprehensive guide to conquering Excel's frustrations and making it fun. And be sure to tune in to our next episode where we will be discussing the popular VLOOKUP function. Thanks for listening to the Don't Fear the Spreadsheet podcast, and remember, with the right functions, Excel doesn't have to be scary. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Favorite Excel Functions (00:23) COUNTA Function (00:41) INDEX Function (01:03) DATE, YEAR, and MONTH Functions (02:00) Guest Podcaster Introduction (03:02) Guest Podcaster's Favorite Functions (03:33) IF Function (06:19) AVERAGE Function (07:20) COUNTIFS and SUMIFS Functions (09:29) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: AVERAGE function beginner's guide to Excel COUNTA function COUNTIFS function DATE function Don't Fear the Spreadsheet podcast episode 19 Excel is Fun favorite Excel functions IF function IF, AVERAGE, COUNTIFS, SUMIFS functions INDEX function MONTH function RANDBETWEEN function search terms: Slaying Excel Dragons book SUMIFS function YEAR function Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153467/ Today, coming down to the last in our "Don't Fear The Spreadsheet" series on Learn Excel from MrExcel, Tyler wants to know what some of Bill's Favorite Excel Functions are. Follow along with Episode #1645 as Bill covers a variety of Excel Functions that are useful, effective, efficient and worth learning as you grow your knowledge of Microsoft Excel. If you are just starting out in Excel or you want to go back and find the things that you missed when you started using Excel, then "Don't Fear the Spreadsheet" is the 'Beginner Oriented' Excel How-To book for you. Why are we so confident? Because the questions in this book were asked by an absolute Excel Beginner -- Tyler Nash -- with the answers provided by three (3) Microsoft MVPs specializing in and dedicated to teaching others Microsoft Excel, from the ground up -- Kevin Jones, Tom Urtis and Bill Jelen. Check out "Don't Fear the Spreadsheet" - http://www.mrexcel.com/dftss_home.html "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of your Microsoft Excel Needs!

Видео Excel 101 - Favorite Excel Functions: Episode 1645 автора Эксель: справочник по формулам