Welcome

Welcome to my Tutorial Website do you need help with something hopefully this site will help you use the Links to the right side of the page to click on any type of Tutorial that you need help on

Translate

Search This Blog

Monday, February 14, 2011

Microsoft Excel

Microsoft Excel is a Great Program Tons of People Use it to Organize There Data It Is Mainly Used For Business Purposes It is Used For Data Purposes

How Do I Merge a Cell Witthin To add a Title

Highlight the Cells Than On the Top Hit Merge Center and you should be able to Merge that Row

I Got a Large Amount of Numbers is There a Easier Way of Adding them Up

Yes There is You Can Do Quite a Few Commands to do that go to the Box at the very top below the menu click on it and type in =the format Example =Sum(B5+B6) Than Hit Enter and it will add those 2 cells togather or if you wanted to do Multiple Do It Like this =Sum(B5:B10) than hit enter and it will add from B5 to B10 If you Wanted to Multiply Do Product If you wanted to Do Subtraction Do Sum Average Type Average and Minimum Min And Maximum Max

How Do I Make The Information into A Table

Too Do That Highlight the Entire Thing than Right Click than Click on that Square than Hit All Borders And your Table will be Created

How Do I Make a Item Bold Or Underline

Click on the cell Than Hit The Bold Or Underline Button and it will Do That Function

How Do i Resize a Item and Change the Font

Go To That Cell And Click on the Size and Than It will Apply Same thing for font on the font box

how do i Wrap Text

Go to The Cell That you Want the Text to Be Wrapped Click on it than Hit Wrap Text Note you May Have to Resize the item in order to get it too follow through

how Do i Sort A Table or a Chart Alphabetically

Click on the Sort Filter than hit Sort A to Z Or Z to A And it will Sort it For you

How Do i Sort From Largest to Smallest

How do i Get A Item to Show the Dollar Sign

When you type in Numbers it will not Automatically show the dollar sign to tell the computer to do that highlight the entire section than hit the dollar button and it will automatically Do That