Intro to Spreadsheets
Spreadsheets allow bankers to make billion dollar deals, financiers take million dollar bets & management consultants make the strategic decisions for the CEO.
Are you ready to learn about Spreadsheets? Type "Yes" in the cell B2. Make sure you get the capital letters right!
Nice Job!
In a spreadsheet, starting a box with the equals sign ("=") tells the Spreadsheet to calculate whats in the box.
Now, in Cell 'B3', type in "=50+50".You'll see that B3 now returns '100'.
Great!
You can also use the "=" sign in a spreadsheet to pull the value of another cell. When you type "=B3" in, watch "B4" have the same value as "B3".
{{cells['E2'] = '1000'}}
{{cells['E3'] = '600'}}
{{cells['F2'] = '1700'}}
{{cells['F3'] = '1600'}}
{{cells['G2'] = '2700'}}
{{cells['G3'] = '3000'}}
{{cells['A1'] = 'Assumptions'}}
{{cells['A2'] = 'Can Input:'}}
{{cells['A3'] = 'Can Calculate:'}}
{{cells['A4'] = 'Can Ref:'}}
{{cells['E1'] = 'Year 1'}}
{{cells['F1'] = 'Year 2'}}
{{cells['G1'] = 'Year 3'}}
{{cells['H1'] = 'Year 4'}}
{{cells['I1'] = 'Year 5'}}
{{cells['J1'] = 'Year 6'}}
{{cells['D2'] = 'Revenue'}}
{{cells['D3'] = 'Costs'}}
{{cells['D4'] = 'Profit'}}
{{cells['A6'] = '# of Lessons:'}}
{{cells['A7'] = '# of Discplines:' }}
{{cells['B6'] = '30+'}}
{{cells['B7'] = '4'}}
B2 fx: {{cells['B2']}}
| {{column}} | |
| {{row}} |
|
