This course is the first of a two part series to teach you the ten most important spreadsheet design techniques. Using a classic cash flow projection spreadsheet, each of the techniques will be demonstrated and provide you with a comprehensive guide to help you employ these features after the session.
Learn how to build spreadsheets in less time.
Learn how to design spreadsheets that are less likely to contain errors.
Learn how to design spreadsheets that are easier to update.
Defined Names – Learn how to use these to enhance the design of your spreadsheets to streamline the building of formulas, make your spreadsheets more flexible for expansion, provide better documentation of your formula logic; what they are about, how they are used, syntax rules, tips and tricks for using them.
Data Tables – The most practical features in all of Excel, learn how to create a data table and then utilize all of the tools to analyze and manage your table of data including; filtering, sorting, styles, total row and more.
Learn how to establish your default Excel spreadsheet settings using the template file.
Using variables in formulas, learn one of the most important spreadsheet design techniques in regards to using variable in formulas rather than “hard-coding” them.
Rounding and Precision – nothing is more embarrassing then having a financial spreadsheet that displays rounding errors. We will show you how to use the built-in functionality of Excel to prevent this from happening in your spreadsheets.