a few tricks to take you beyond the basics of microsoft office 2010
Download
Skip this Video
Download Presentation
A few tricks to take you beyond the basics of Microsoft Office 2010

Loading in 2 Seconds...

play fullscreen
1 / 30

A few tricks to take you beyond the basics of Microsoft Office 2010 - PowerPoint PPT Presentation


  • 94 Views
  • Uploaded on

A few tricks to take you beyond the basics of Microsoft Office 2010. GCPS Tech Tips. Microsoft Excel 2010 : Formatting numbers in cells. Excel 2010 : Formatting Numbers in Cells.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' A few tricks to take you beyond the basics of Microsoft Office 2010' - salaam


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
a few tricks to take you beyond the basics of microsoft office 2010

A few tricks to take you beyond the basics of Microsoft Office 2010

GCPS Tech Tips

Microsoft Excel 2010 : Formatting numbers in cells.

slide2

Excel 2010 : Formatting Numbers in Cells

Gwinnett County Public Schools is committed to providing information related to student technology use in a manner that is clear, concise, organized, accessible, and current. To that end, GCPS has provided articles and handouts on its web site.

The following resource is provided for information only and is NOT an official policy or procedure of Gwinnett County Public Schools. This resource may be used by schools and the school communities to share information and ideas around student technology use.

Should a conflict between the information on this site and the existing policy, regulation or rule occur, then the official or approved policy, rule or regulation supersedes the resources in this document.

slide3

Excel 2010 : Formatting Numbers in Cells

One of the neatest things that Excel does for you is enter the day’s date with minimal prompting. For example, if it is March 14th and you want that date in a certain cell, you only have to type “3/14” in that cell. As soon as you press the “Tab” key to move to the next cell...

slide4

Excel 2010 : Formatting Numbers in Cells

Excel turns what you have typed

into the day’s date.

slide5

Excel 2010 : Formatting Numbers in Cells

In fact, you can choose from over 15 ways of writing the day’s date... and you can set any row, any column, even a whole worksheet to use the number form you like best.

slide6

Excel 2010 : Formatting Numbers in Cells

To set the number format for a row, you select that row by clicking the number of that row.

slide7

Excel 2010 : Formatting Numbers in Cells

Then, with your cursor somewhere in the highlighted section,

… click your right mouse button.

slide8

Excel 2010 : Formatting Numbers in Cells

That will drop down a box of things you can do with those highlighted cells. Click on “Format Cells...”

slide9

Excel 2010 : Formatting Numbers in Cells

That brings up a box where you can “Format Cells.” You will see a list of things you can format within a cell, a row, a column, or even the whole worksheet.

slide10

Excel 2010 : Formatting Numbers in Cells

Clicking on the “Date” category will open a list of ways Excel can display the date for you.

slide11

Excel 2010 : Formatting Numbers in Cells

Choose the one you like, click on it,

slide13

Excel 2010 : Formatting Numbers in Cells

and thereafter, any “number-slash-number” you enter in that row Excel will display as the date.

slide14

Excel 2010 : Formatting Numbers in Cells

To set the date format for all the cells in a column, start by selecting a whole column.

slide15

Excel 2010 : Formatting Numbers in Cells

Then, after right clicking in the highlighted area, go to...

“Format Cells”... “Date”... “Type”... and “OK.”

slide16

Excel 2010 : Formatting Numbers in Cells

You can even select a whole worksheet

and set it to show any “number-slash-number”

you enter as the date.

slide17

Excel 2010 : Formatting Numbers in Cells

But...

what happens when you intend to enter

a fraction into a cell?

slide18

Excel 2010 : Formatting Numbers in Cells

Excel doesn’t know any better than to turn it into a date. You need to re-format the way Excel shows numbers in that cell.

slide19

Excel 2010 : Formatting Numbers in Cells

Once again, select the cell, row, column, or whole worksheet you want to format...

slide20

Excel 2010 : Formatting Numbers in Cells

Right click in the highlighted area

and click on “Format Cells”...

slide21

Excel 2010 : Formatting Numbers in Cells

That opens the formatting box.

Look down the list to find “Fraction.”

slide22

Excel 2010 : Formatting Numbers in Cells

When you click on “Fraction,”

Excel will give you a list of ways

to display fractions.

slide23

Excel 2010 : Formatting Numbers in Cells

Select the one you want and click “OK.”

slide24

Excel 2010 : Formatting Numbers in Cells

Thereafter, Excel will show fractions

as you enter them.

slide25

Excel 2010 : Formatting Numbers in Cells

You can show

the numbers you

enter as

“Percentages”

slide26

Excel 2010 : Formatting Numbers in Cells

Or format them as “Zip Codes,” “Phone Numbers,” or “Social Security Numbers.”

slide27

Excel 2010 : Formatting Numbers in Cells

You can show the “Time”

in many different formats.

slide28

Excel 2010 : Formatting Numbers in Cells

Or you can select “Text” to display things

exactly as you type them in.

slide29

Excel 2010 : Formatting Numbers in Cells

That’s all there is to it. Now, if you would like a copy of the step-by-step directions for formatting numbers in cells with Excel 2010, just print this last page. Have fun formatting!

gcps tech tips
GCPS Tech Tips

We hope you found this technology tip useful. Feel free to share this tip with colleagues and students.

More technology tips can be found on the IMD website here.

For questions or comments about the technology tips, send email to

[email protected]

Gwinnett County Public Schools | 437 Old Peachtree Road NW | Suwanee | GA | 30024-2978 | 678-301-6000

ad