Microsoft Office Tutorials and References
In Depth Information
Project — Financial Projection Worksheet with What-If Analysis and Chart EX 167
With a good understanding of the requirements document, an understanding of the
necessary decisions, and a sketch of the worksheet, the next step is to use Excel to create
Table 3–1 Campus Clothiers Semiannual Financial
Projections Data and What-If Assumptions
Projected Monthly Total Net
Research and Development
Revenue for Bonus
Support, General, and Administrative
The Startup Submenu
Any application on the
Startup submenu starts
you turn your computer
on. To add Excel to the
Startup submenu, do
the following: (1) Click
the Start button on the
Windows taskbar, point
to All Programs on the
Start menu, and then
point to Microsoft Ofﬁ ce
on the All Programs
submenu; (2) Right-drag
Microsoft Ofﬁ ce Excel
2007 from the Microsoft
Ofﬁ ce submenu to the
Startup submenu; (3)
When the shortcut menu
appears, click Copy Here.
The next time you turn
your computer on, Excel
will start automatically.
To Start Excel
If you are using a computer to step through the project in this chapter and you want
your screen to match the ﬁ gures in this topic, you should change your computer’s
resolution to 1024
768. For information about how to change a computer’s resolution, see
page APP 36 in Appendix E.
The following steps, which assume Windows is running, start Excel based on a typical
installation of Microsoft Ofﬁ ce on your computer. You may need to ask your instructor
how to start Excel for your computer.
1 Click the Start button on the Windows taskbar to display the Start menu.
2 Point to All Programs on the Start menu and then point to Microsoft Ofﬁ ce in the All
3 Click Microsoft Ofﬁ ce Excel 2007 on the Microsoft Ofﬁ ce submenu.
4 If the Excel window is not maximized, click the Maximize button next to the Close button
on its title bar to maximize the window.
5 If the worksheet window in Excel is not maximized, click the Maximize button next to the
Close button on its title bar to maximize the worksheet window within Excel.