Conditional Calculations with Excel Formulas - Comprehensive Lessons
Dive into a comprehensive Excel tutorial that explores various methods for performing conditional calculations using formulas. Master the use of built-in functions like SUMIFS, AND, OR, and IS functions, as well as array formulas and D functions. Learn to create cross-tabulated tables, generate monthly sales reports, and develop frequency tables using COUNTIFS. Explore the application of defined names and scope in Excel workbooks, and understand how to use OR criteria for adding and counting with SUMIFS and SUMPRODUCT. Discover techniques for credit analysis in accounts receivable and bank checkbook management. Compare the effectiveness of PivotTables versus formulas for conditional calculations. Download accompanying files to practice along with the instructor throughout this in-depth, 1-hour 23-minute lesson on advanced Excel formula techniques.