Course information:

We will teach you how to create complex linked tables. Great emphasis will be placed on data security and protection and maintaining consistency of all input and output data. We will also provide you with a function to back-calculate input values according to the desired target values. Contingency tables and graphs will perfectly extract maximum context from your databases and provide new insights.

Content:

• Linking multiple sheets and workbooks
• Creating named areas
• Working with indirect links
• Extended filter
• Data summaries
• Verification of cell inputs and setting criteria
• Working with dynamic links to different areas
• Scenarios
• Solution search and advanced Solver
• Locking formulas, sheets and workbooks
• Contingency tables and charts
• Form elements in sheets
• Shared workbooks
• Hyperlinks
• Discussion