Formulas – Nested Functions

DESCRIPTION: As your skill develops with Microsoft Excel, so too will the complexity of formulations. Depending on the arrangement of data you may choose to have each individual part of the final calculation stored on your workbook or you could combine several formulas into a single cell. Each has its own advantages and disadvantages. Having each calculation stored results in larger spreadsheets potentially spread across different sheets making tracking difficult. Conversely, combining all formulas into a single cell greatly reduces the workbook space but makes understanding individual elements difficult. The solution is to have a balance of each but also be flexible depending on the data itself. In this course, you’ll learn how to create nested functions as well as how to expand it further. Most importantly you’ll learn how to validate your nested functions to make sure it’s constructed correctly.

TARGET AUDIENCE: This is intermediate users who are now creating more complex tables with several levels of calculations. Potential problems you’ve encountered will most likely be tables that are becoming increasingly large and you’re looking to optimize your workbook.

DOWNLOADABLE FILES: 

 

DIFFICULTY: Intermediate

COURSE OUTCOMES:

  • Basic nested function operation
  • Nested using arithmetic and AutoSum functions
  • Absolute referencing for more complex analyses