Excel Power User Module 2: Fundamental Functions, Concepts, Techniques Webinar

• Determine why the SUBTOTAL function is preferred to the SUM function in many situations.
• Identify a technique that helps ensure a new row inserted between the last data row and the formula row is included in the total row formula.
• Recognize at least three workbook design principles.

• Better summing
• Skinny row
• Hide worksheets
• Highlight input cells
• Workbook and Worksheet organization
• Nested functions
• Selection groups
• Workbook design principles