Spreadsheets and Modelling

I can use formulae in spreadsheets such as IF and COUNT to get some results from data.

I can output data in more than one way

e.g. table and graph

I can use functions to produce results and make decisions such as IF, VLOOKUP and COUNTIF

I can represent data visually e.g. graph in the most appropriate way.

I can use the formulae and functions to extract meaningful information and knowledge from a spreadsheet.

How to use:

Using Goal Seek to find a ticket price need to break even

How to create a list of products and automatically fill in an invoice using dropdowns, vlookups and IF statements

Complex Features in Modelling

Report abuse