Wednesday, February 17, 2010

Freezing the IF :P

Freeze Panes
1.) Selection
2.) View Tab
3.) Window
4.) Freeze Panes
a.) panes
b.) 1st row
c.) 1st column

IF Function
1.) Logic test
2.) If True
3.) If False

Friday, February 5, 2010

Critical Thinking!!!

**Excel allows you to change values in a worksheet quickly and easily**
This is helpful in running a business because it will make everything more easier and make the business look how you want to look. It can changing values affect business decisions if something goes wrong then it will everything will go wrong and then you wouldn't have the work you will want.

Thursday, February 4, 2010

Who is Warren Buffet?

Warren Buffet is an American investor, businessman, and philanthropist. He is one of the most successful investors in history, the primary shareholder and CEO of Berkshire Hathaway. Buffet is also a notable philanthropist, having pledged to give away 85 percent of his fortune to the Gates Foundation. He also serves as a member of the board of trustees Grinnell College.
1.) Support, General and Administrative
2.) R and D Research and Development
3.) Marketing
4.)
5.)
6.) Operating Income
= Gross Margin- Total Expenses

Wednesday, February 3, 2010

3 Ways to View Large Spreadsheet

1.) You can shrink the size of the text
2.) Clicking in the Home Tab button and then go to Print Preview to see if it will come in one piece of paper.
3.) You can adjust the columns and rows so you can still see everything but just rearranged
4.) Semiannual-