Microsoft Excel – Goal Seek, Data Consolidation and Solver
Find out how much you can afford to pay for a house using goal seek and financial functions, consolidate the information from several sheets, understanding the grouping of data and use solver to explore possible outcomes depending on input variables.
Included topics:
ADVANCED OPTIONS
- Task: Show the Developer Ribbon
GOAL SEEK
- 2.1.1 Task: How much can we afford to pay for a house
DATA CONSOLIDATION
- 3.1.1 Task: Consolidate contents from several sheets
- 3.1.2 Task: Data consolidation with Named Ranges
- 3.1.3 Task: Format Painter between sheets and Groups
- 3.1.4 Task: Understand Grouping
MANUALLY GROUPING
SOLVER
- 5.1.1 Task: Solve a problem
INSERTING FORM COMPONENTS
Back to Microsoft Excel Training Courses outline Enrol now
