309 Microsoft Excel – Goal Seek, Data Consolidation and Solver
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
The Australian Small Business Training and Support
Courses, Training and Support.
Get bookkeeping, marketing, operations, customer service, sales and finance knowledge via email. Keep up to date with new and emerging trends and technologies and get our free samples.