Showing posts with label excel. Show all posts
Showing posts with label excel. Show all posts

Friday, March 1, 2013

File Extensions-What are they?

The following is a list of some of the most popular "file extensions" you will see on your computer and or receive in an email...  File Extensions tell the computer the specific type of "file" something is...    Note if any file extension has an "x" at the end of it, it is an indication it was done in one of the Office 2007, 2010, 2013 programs... (ie.e docx; xlsx, pptx)
Extension
Example File Type
zip
Zip archive
pdf
PDF Document
mp3
MP3 Audio File
jpg
JPEG Image
exe
Executable file
wmv
Windows Media Video
doc
Microsoft Word Document
ppt
Microsoft PowerPoint Presentation
mpg
MPEG-1 Video
tif
Tagged Image File Format
wav
Waveform Audio Format
mov
QuickTime
psd
Photoshop Document
wma
Windows Media Audio
xls
Microsoft Excel spreadsheet
mp4
MPEG-4 Part 14
txt
Plain text file
bmp
Windows bitmap
pps
PowerPoint Show
aif
Audio Interchange File
pub
Microsoft Publisher
gif
GIF (Graphics Interchange Format) Image
qbb
QuickBooks backup file
dat
Data
rm
RealMedia
mdb
Microsoft Access
htm
Hypertext Markup Language (HTML)
flv
Flash video
wpd
WordPerfect Document
rtf
Rich Text Format
jpeg
JPEG image
html
Hypertext Markup Language (HTML) document
pst
Microsoft Personal STorage
ttf
TrueType font
mswmm
Windows Movie Maker Project File
eml
E-mail message
bat
Batch file
wps
Text document; MS Works

Friday, November 2, 2012

Using Auto Complete in Excel (and Word)

Auto Complete in EXCEL helps save time by reducing the amount of text we have to type (enter) when we are filling out a table with duplicate entries (like names, cities, states, and you can add more of your own... And this feature is also available in WORD.
 
By default, AutoComplete is turned on in Excel. These steps will first show you how to turn it off.

Turn AutoComplete On or Off in Excel 2010
  • Click on the File tab of the ribbon to open the File menu
  • Click on Options to bring up the Excel Options dialog box
  • Click on the Advanced button in the left hand pane
  • Under the Editing Options section
  • Click on the Enable AutoComplete for cell values option box to remove the checkmark and Click OK
  • AutoComplete should now be disabled
  • To re-enable AutoComplete, re-check the option box
Turn AutoComplete On or Off in Excel 2007
  • Click on Office Button > Excel Options to bring up the Excel Options dialog box
  • Click on the Advanced button in the left hand pane
  • Remove the checkmark from the Enable AutoComplete for cell values option box, Click OK
  • AutoComplete should now be disabled
  • To re-enable AutoComplete, re-check the option box
Turn AutoComplete On or Off in Excel 2003
  • On the Tools menu, click Options
  • Now  click the Edit tab.
  • To allow automatic completion, click to select the Enable AutoComplete for cell values check box.
  • To prevent AutoComplete click to clear the check box.
  • AutoComplete should now be disabled
  • To re-enable AutoComplete, re-check the option box

Sunday, June 10, 2012

Changing the default settings in your Office Programs


Default simply means “Standard” – the way in which a program will work each and every time you use it and you can change/modify many of the “default” settings on computer programs that we use daily, including our browsers and office programs…

This is a personal choice – certainly you can continue to use the default settings established by the provider that are built into the program.  But, changing the way your Browser or Office Programs work can make life so much easier.

Customizing your Office programs can impact the way in which documents print, how they are saved, the way they appear on the page, margins, paper layout/orientation – such as portrait or landscape, the font you use, whether the red & green squiggle lines appear as you type indicating spelling & grammatical errors - these are just a few of the many ways in which you can “customize” the way in which your Office Programs work for you.  Decide for yourself – making each program easier for you to use can be done as often as you’d like – some compare it to adjusting the seat position and rear view mirrors when you get into a car…

In Word 97-2003:
Click TOOLS, Then Click OPTIONS
You will see various options available for you to be able to modify to your liking
Click SAVE (set at 1 minutes – doesn’t affect your work, simply saves in the background)
Click SPELL (whichever options you’d like & Auto Text Entries and many others)

In Word 2007-2010:
Click on the Office Button or File Tab
At the bottom of the dialog box/page that opens, left click on “Word Options
This opens the Control/Dialog Box, which lists on the left various categories which allow you to “customize” the software you are using to your own liking..

Special Note for anyone using 2007-2010 Office Programs it is very important to save everything you do as “97-2003 compatible” so that you can share your documents with others who may not have the newest of these software programs.  You can do this as you save each and every document, or do it once when you are in your Options Settings, under the Save category..

Wednesday, June 6, 2012

What is a “Template” and how can you use them?


Basically "templates" are pre-designed layouts for various items you might want to create on your computer using the various Microsoft Office Programs...

Using TEMPLATES in Word, Excel, Power Point and other programs allows you to open a pre-designed document in these and other various programs.  You can then use the pre-designed layout which is stored in the “Template Folders”.  Some templates are built into your Office Program, and if you can’t find what you need, you can go to Microsoft online for even more templates, just as we do with clip art.  

This means you don’t have to create the entire document, form, spreadsheet/budget or other, power point presentation - much of the design work is already done for you.  Once you find a “template” you want to use, you save it in whatever folder you choose, you can modify it to your own needs and use it however you would like…It is yours.

In 1997-2003 Word/Excel/PowerPoint:
  • Go to the Menu Bar, choose "New" and the Template Dialog Box will Open, which has multiple tab categories across the top
  • Select the category you want, and you will see various template choices to choose from
  • Select the template you want and it will be on  your screen
  • Now save the template as your own, finding or creating a folder to save it in and giving it a name that works for you.
  • Now you can modify it anyway you would like.

In 2007-2010 Word/Excel/PowerPoint:
  • Go to the Office Button in 2007 or File Tab in 2010, Choose "New"
  • You will now see the various templates available
  • Select the template you want, and "download it"
  • Select the template you want and it will be on your screen
  • Now save the template as your own, finding or creating a folder to save it in and giving it a name that works for you
  • Now you can modify it anyway you would like.

Tuesday, April 3, 2012

How can I freeze both my top row & first column in Excel at the same time?

Q: I want to freeze the top row & first column in my Excel Spread Sheet at the same time?

A: Love this tip – this this will freeze all rows above the selected cell and all columns to the left of the selected cell –
Example: if you highlight cell B2 – then your top row and first column would be the only 2 things frozen!!!

In 97-2003 Excel
• Left click on a single cell of your worksheet
• Then go to Window; then choose Freeze Pane

In 2007-2010 Excel
• Left Click on the View Tab, go to the “Window Section”
• Open drop down list for "Freeze panes"
• Choose Freeze panes

Note-If you have Office Starter (Word Starter, Excel Starter, Power Point Starter) which is a Microsoft Application program that has replaced the former Microsoft Works - you cannot FREEZE or UNFREEZE cells. Although the starter programs allow you to perform many tasks, it is not a full featured program such as the Microsoft Office for Student & Home Versions and above...

Tuesday, February 28, 2012

EXCEL: How to Turn the Heading Row “On” or “Off”

When we work in Excel (Spreadsheets) whether for numbers or data management, it's always best to be sure that we've typed in a heading row, so that when we sort a column - it will be easier to understand the meaning of the data. By default, the value in the heading is not included in the sort operation.

<div>

&nbsp;</div>

Occasionally, you may need to turn on or off the heading so that the value in the heading is or is not included in the sort operation. Do one of the following:

<ul>

<li>To exclude the first row of data from the sort because it is a column heading, on the Home tab, in the Editing group, click Sort &amp; Filter, click Custom Sort, and then select My data has headers. </li>

<li>To include the first row of data in the sort because it is not a column heading, on the Home tab, in the Editing group, click Sort &amp; Filter, click Custom Sort, and then clear My data has headers.</li>

</ul>

Thursday, October 20, 2011

What is clip art & how do I use it?

Holidays are coming and you might want to use clip art or photos to enhance your documents - invitations, holiday letters and more.... First of all ~ always insert graphics into your documents vs. copying them, so they react the way you want or need them to...

Clip art is a picture or graphic that can be inserted into various documents, such as those you might create in word processing, power point, excel or publisher to name a few...
You don’t have to purchase clip art software (as we did years ago) - There are thousands and thousands of different CLIP ART options built into various documentation programs and you can continue to build your own clip art collection from a variety of sources such as Microsoft online or Google images…

When you are in your word document, put your cursor/insertion point to the specific location in your document where you want the clip art, picture or symbol to be “inserted”.
  • In Office 2007-2010 Word, Excel, etc.. go to the Insert Tab
  • In Office 2003 or older versions, go to Insert on the Menu Bar and then to Pictures, Clip Art, etc.

You will now choose what you want to Insert - Picture, ClipArt, Symbol, Text Box, Word Art etc..

For clip art you will now see the gallery and/or the gallery search bar, so that you can search for or choose the image you want – if it is a picture, then open the folder or sub-folder the picture is in and choose the picture – one it is highlighted choose insert.

The image will now be inserted into your document…

When the graphic is on your page, the Picture Formatting Toolbar appears (in older versions of Word 2003 and prior-you can right click on your toolbar and turn this on or off) in Word 2007 & 2010 it appears as a new/additional tab, after the View tab..

When you insert graphics into your document, always go to the Text Wrap Icon (looks like a little dog in a postage stamp) and when the list appears choose Through. This allows you to easily work with both your text and graphics. Later, you can then change your choice of text wrapping – tight, square, behind text, in front of text (choices vary depending on your version of Word, Excel, PowerPoint etc 2000-2003-2007-2010?)…

Use your sizing handles around your graphic to change the size of your graphic – personally I like to use the sizing handles in the corners so that I change the height and width of my graphic all at once to be sure I don’t distort the graphic making it too tall/short or too wide/narrow…
Use the four headed arrow on the graphic to move the graphic around on your page to where you want it…

If your sizing handles boxes aren’t there or you don’t see the picture formatting toolbar, simply click on your graphic again – you must have the sizing handles around your graphic in order to see the picture formatting toolbar…

Clip Art & other graphics are a great way to enhance your documents - remember: one picture can be worth a thousand words... have fun & enjoy

Saturday, September 24, 2011

What is Excel? And why would I use a spreadsheet?

Most of us understand that word processing software makes it much easier to create documents such as letters, forms, invitations, greeting cards and anything that contains text. Well – Excel does the same thing for us – making it easier to work lists, figures, numbers for list management, budget, statistics, data – anytime any type of calculation needs to be done. Although Excel spreadsheets/worksheets used to be used primarily for accounting and other analytical information where calculations needed to be made easily; but many of us find them a wonderful resource for list and other data management.

Like so many software application programs, Excel opens with a blank document – but in Excel that blank document is a blank worksheet, which is actually a grid of rows and columns.

In Excel, the rows of you spreadsheet/worksheet are serially numbered 1,2,3 .... and the columns are serially lettered A,B,C..... This numbering enables each space or cell to have its unique address; thus D15 represents the cell in the 4th column and the 15th row.

In Excel, using the ‘=’ sign, simple mathematical equations or formula can be used and sums, differences, products etc. calculated. Thus typing say, ‘=23+56’ in any cell will give the result of 79. The same work can be done by typing in the numbers 23 in cell A1, 56 in A2 and ‘=A1+A2’ in cell A3 and in fact what you have done is create a “formula”

Using a formula with cell references allows us to change the value in either cell A1 or A2 to get the revised result. This has significant advantages when using a complex formula or the same formula across multiple cells. The more recent your version of Excel, the easier it is to create and/or use formulas included in the software command list.

So many of the basic commands that we use all the time in Word Processing whether you use Microsoft Word Pad, Word or Word Perfect, such as Open, Save, Copy, Paste, Find, Replace Undo, Redo, Center, Left, Right etc.. are also available and work the same in Excel, Excel also offers a variety of basic commands that are designed to work with spreadsheets – whether you are managing a list of data or one with numbers and some of those are Paste Special, Filter, Sort, Wrap Text, Autofill, and Freeze panes.

And with the newer versions - Excel 2003, 2007 and 2010 - each new version adds more and more "templates" so that we don't have to recreate the wheel - so whether you are creating a budget for the holidays, a special event, your vacation or next years income & expenses - or various lists for managing data - there are hundreds of templates to choose from with the formulas already built in...

So whether you are trying to create a basic budget or want a way to quickly and easily maintain you all of your contact lists in one document – Excel is the answer.. So give it a try... it's easier than you think and can be used for so many things..

Monday, August 15, 2011

CTRL + F - Keyboard shortcut to find specific words

By now, most of you know how much I enjoy using “Keyboard Shortcuts” which make doing certain functions a little easier - and I like easy - but they do allow us to give a command and get results quickly and easily…

To me CTRL + F is one of those keyboard shortcuts that I think you will use as often as I do, which is “all the time”

Most of us spend time looking for documents or other things on our computer because we can’t remember what we named them – but we do remember words specific in that document – report, spreadsheet, letter – whatever… Well if you haven’t tried this keyboard shortcut before – give it a try…

This great keyboard shortcut works in almost every application (Microsoft Word, Microsoft Excel, Microsoft Power Point, with all major browsers, Notepad, Word Pad and many other application software programs... Simply type the keyboard shortcut Ctrl + F (F for Find) to find a word or series of characters.

Give it a try right now while you are on the internet—search for the word “keyboard” in the next section.

Thursday, April 21, 2011

What is OCR Software?

Typically when we “scan” something into our computer – whether it is a photo or a document, the end results is a “digital picture” of whatever we scanned. But, OCR software (OCR stands for Optical Character Recognition) allows us to EDIT what we have scanned.

Simply “scan” your document into your computer and the OCR software converts it to an "editable file" that can be edited in most word processing and spreadsheet software programs. What types of documents can you scan? Basically any printed material –such as notes, letters, documents, spreadsheets, magazine or newspaper articles, books etc.

The quality of the OCR conversion process will largely depend on the quality of the scanned image and the clarity of the characters of that image.

Today – many of the printers for the home market, especially “all-in-one” multi function printers and “photosmart” printers include OCR software capabilities included with the software or you can visit the manufacturer’s website and download it for free.

So your current printer maybe OCR ready- not sure? Once again, go to the manufacturer’s website – put in your model # and it will give you the specifics on if the OCR software is available, if so how to download and use the OCR software.

OCR software is a real timesaver so we don't have to retype documents to be able to edit them. OCR software is also available as “freeware” and for purchase if it doesn’t come with your printer…

Tuesday, April 19, 2011

Excel – Counting “X’s” in a Column

A question that comes up quite often with respect to Excel spreadsheets – is how to create a formula that will add up/count the number of cells in a column containing "X’s":


If you have a specific column or columns, that you have put an X in and want to count the total # of X’s in a specific column, for example for attendance or other criteria, the formula you would enter in the “total cell” is noted below. Be sure however to enter the correct column & line ID’s…


Example – In your excel spreadsheet – Column C, you have put several X’s in Rows 1 thru 28, and want to now count the # of X’s in Column C, the correct formula that would be noted in the total cell C29 would be:

=COUNTIF(C1:C28,"X")

Saturday, April 9, 2011

Sorting Data in Excel

Excel makes it very easy to sort data that is entered in multiple columns, by using the SORT buttons (A-Z or Z-A)… So be sure when you are entering your data, to put information in as many individual columns as possible – In my opinion you can never have too many columns to sort data with..

Make sure before you give the command to SORT that you have highlighted the active sheet, so that all information in the columns and rows will then “move” when the information is sorted…

Excel Sort Data by One Column:

  • Select all the cells in the list
  • Choose Data>Sort
  • When the Sort Dialog Box opens, be sure to check off that your list has a “header row” so you will see the data – not the column ID letter
  • From the Sort by dropdown, select the column you want to sort. Note: If the dropdown is showing Column letters instead of headings, change the setting for My list has, from No header row to Header row.
  • Select to sort in Ascending or Descending order

Excel Sort Data by multiple Columns:

Such as when we are entering data for our contacts to prepare a mailing list – we might want to sort by Last Name, First Name and then Spouses Name which are in 3 three columns. So we will sort it all at once, but giving different levels 1 would be Last Name; 2 would be First Name and then last the Spouses Name…starting with the most important sort.

  • Select all the cells in the list.
  • Choose Data>Sort
  • When the Sort Dialog Box opens, be sure to check off that your list has a “header row” so you will see the data – not the column ID letter
  • From the Sort by dropdown, select Last Name.
  • From the Then by dropdown, select First Name.
  • From the Then by dropdown, select Spouses Name.
  • Click OK

Note about Excel 2007 and 2010

  • The SORT BUTTON is on the HOME TAB to the far right in the Editing quadron and also in the DATA TAB in the Sort & Filter quadron
  • When the Sort Dialog Box Opens you will see one SORT field, but you can add as many levels for sorting as you would like.…

Saturday, March 5, 2011

Google Docs - Part 2 of 2

For anyone who is using Google Doc's - Google has a great new software plug-in “Cloud Connect” that easily will move any and all of our Office Word, Excel and PowerPoint files to Google Docs.

Cloud Connect, was released by Google on Thursday Feb 24th, 2011 and it will allow users to save our files to save their files to "the cloud," which in this case is on Googles servers.

That means that once our files are saved in Google Docs, we can then edit files in Microsoft Office and sync them up to the clouds. This will also mean that it will be much easier if and when we want to collaborate on documents and will eliminate the confusion as to which version of a document is the most recent one.

"For example, you can edit a Word document's Opening Page of Grandma’s Life Story from Lake Havasu, AZ, while your sister in Quincy, MA is adding the family tree and your brother in Weymouth, MA is making other revisions.. This way, instead of having to send emails with tons of attachments, your whole family or group can work together."

And the great news is that Google will save every revision of any document users of Cloud Connect make, whether those edits take place in Office or Google Docs. And files can be shared in a view-only form via Google Docs as well with each document getting a unique Web address (just in case you don’t want someone make changes).

Cloud Connect is free and works with Office 2003, 2007 and 2010 on Windows PCs. Cloud Connect, however, won't work with Mac versions of Office. Sorry – it’s not available for Mac Users yet, but Google indicates it’s working on it, so no doubt it will be in the near future….

Check it out for yourself…

http://tools.google.com/dlpage/cloudconnect


Thursday, March 3, 2011

What are Google Docs - Part 1 of 2

Have you tried Google Doc’s yet? Check it out - if you have Internet access, you can use the various aspects of Google Docs, which include Documents (Word Processing); Spreadsheets; Presentations, Drawings and Forms..

Google Docs is great for:
  • anyone who travels so you can access your documents anytime anywhere

  • groups who want to collaborate on various projects

  • those who only use word processing software once in a while and don’t want to buy and download software on their computer...


Why Google Doc's is becoming so popular:

  • You store your documents online, so you can access your documents from any computer

  • No need to transfer documents to flash or portable drives or "synch" anything

  • Works great with all Microsoft Office products, such as Word, Excel & PowerPoint, as well as OpenOffice, so you can upload or download your files.

  • You can export documents as PDF files, so if you have Office 97-2003, this is a great/free way to convert documents to PDFs without having to upgrade to Office 2007 or 2010, or use other plug-ins

  • Easy to collaborate on projects-you can make a document public or show it to others by sending a link. If you want to allow others to work on the document, you can send out an email to others notifying them that they can access the document.

Use your existing email account to sign into & set-up a Google Account-this video on YouTube explains just how to do that:

http://www.youtube.com/watch?v=gJpkRbNto7E

Thursday, January 20, 2011

Excel 2010 - Create an "Auto Fill List" Office 2010

EXCEL 2010 - HOW TO CREATE/ADD YOUR OWN CUSTOMIZED “AUTO FILL LIST” (this has changed a little since earlier versions of Excel)

If you have a list/header row already typed on a spreadsheet – skip this step

“Type your list either in the first row or the first column” of an Excel spreadsheet

  • Highlight this customized list that you want to add to the Auto Fill Master list
  • Now, go to the File Tab & choose “Options”
  • In the Options list – in the left column, Choose Advanced
  • Bring the scroll bar on the right down almost to the bottom.. until you see the button “EDIT CUSTOM LIST” (to the right of “create lists for the use in sort 7 fill sequences”)
  • That Opens the Edit Custom List Dialog Box – toward the bottom right, left click in the button Import
  • Now you will see your list in the right column-“List Entries” and in the left list “Custom Lists” – Click OK

Notes:

  • If you have a list in another program (word, word perfect, email, etc) – simply highlight and copy the list in that program, open the Edit Custom List Dialog Box, right click and choose paste – the list will not be in the “List Entries” and when you add it – it will be added with the commas after each word/phrase.
  • To change this list in the future (add or remove titles), come back to this dialog box, left click on the custom list on the left side that you want to change – the list will appear in the “List Entries” on the right – make the change and then click on ADD, then click OK
  • You can only change “custom lists” you’ve created, not ones that came with your software..

Monday, October 18, 2010

Name & Save Your Work

Whether you are writing a letter using Word Pad, Word, Word Perfect OR creating a list of items from home or contact list using a spreadsheet software such as Excel OR creating a slide show for a power point presentation - remember when you begin - name your document immediately.
How we name a document is the same, although it varies some based on the version of software you are using...

You will notice when you open a document in Word it will have a Document Number in the title bar; if you open a spreadsheet in Excel it will have a Workbook Number - these will be replaced when you name your work (the more “new documents or spreadsheets you open” the higher the numbers get all day )

We name documents and save them in our choose of specific folders so that we can find them easily when we need them again... Saving work in folders is done in the same way in which we file work in a metal file cabinet...
  • Go to File on the Menu Bar (or in newer versions go to the Office Button)
  • Choose "Save As"
  • In the newer versions of Word/Excel etc - you want to choose "Save as 97-2003" so that it can then be opened by others using these earlier versions
  • Be sure you are in the correct DRIVE - at home the C Drive - OR if you are using a flash memory stick-choose that drive; OR at work or in school, choose the drive assigned to you.
  • Then open the “My Documents” or "Documents" drawer
  • Now choose or create the folder you want your work saved in
  • Now NAME THE DOCUMENT, such as 2010.10.18 letter to paul
  • Remember you can not use / or \ slashes when naming anything on the computer and numbers always come before letters on the computers filing system
  • Once you are done typing the name you can use Enter on the keyboard, or choose OK or save with the mouse
  • It is now saved and when you look at the work on monitor you will see the new name at the top on the title bar and on the open button on your task bar

Monday, September 20, 2010

How to convert older Office documents (97-2003) to Office 2007 Format

Office 2007 applications such as Word and Excel can open a spreadsheet or a document, in any of the older Office Word, Excel or other application software versions. When they open the older versions, they are opened in the Office 2007 Compatibility Mode (which you will see is noted in the title bar on the top of your screen) when you open the document.
If you want to use the new features available in your Office 2007 Software Application program on the “older document” you will first have to convert older Office documents to Office 2007 format.

The feature to covert older Office documents to Office 2007 format is very useful – one example s that now in Excel 2007 you can use 1.1 million rows – whereas the older versions of Excel only offered you sixty-five thousand rows.

Seriously though, converting to use the new features is quick and easy and worth the change. The method to convert older Office documents to Office 2007 format is the same for all applications, but we are using and example of a Word document of previous version. Again, when you open a Word or Excel document of an older version, you will see [Compatibility Mode] as part of the title on the Title Bar…So, to convert older Office documents to Office 2007 format:
  • Open the Word document, which you want to convert into Word 2007 format
  • Click on the Microsoft Office button on the top left
  • Click on Convert on the left hand side of the menu
  • Click on the OK button on the Microsoft Word Office dialog box which appears
  • By clicking OK, your document is automatically converted to the Word 2007 format
  • Now notice that [Compatibility Mode] is no longer part of the title bar

Sunday, July 18, 2010

Excel – what do the “auto’s” mean

When you are working in Excel – there are several “auto” functions and they can be confusing as to how and why they are different.. Hopefully this will help…

AutoFill – creates and/or completes a series of values in an Excel spreadsheet – for example you can type January at the top of a column, and if you then drag the + auto handle from the bottom right corner of the cell that January is typed in across the rows to the right of January, Excel will now “auto-fill” February, March, April etc and continue on…

AutoFormat – adds chosen attributes to your spreadsheets, such as font styles and sizes, borders and even ranges of numerical styles – so highlight the table or area you want to format and when you choose format, auto format various styles, colors etc will appear – choose the one you like and Excel will now format that portion of the table or spreadsheet that you have highlighted – don’t like what you’ve chosen – change it

AutoSum – this adds up a column or several columns or a row of figures in a spreadsheet. This is the icon for Auto Sum “S” – So if you put your cursor in a cell at the end of a row or column (or you can highlight the range of cells” and then click on this icon on the toolbar – once you have clicked on the icon, press enter on your keyboard and Excel will calculate the total for the selected range (By the way the keyboard shortcut for this that does the same thing is: Alt + =)

Monday, June 7, 2010

What is a PDF document???

PDF: Short for Portable Document Format, a file format developed by Adobe Systems. PDF captures formatting information from a variety of software application programs – including Microsoft Word & Excel, Word Perfect and others, so that it is possible to send formatted documents and have them appear on the recipient's monitor or printer as they were intended. So they are welcome to open, read, save & print the documents – but they cannot change them.. When you and I visit websites, such as the registry of motor vehicles, IRS, medical, insurance and other such websites, forms we download are often done in PDF format so that we can view them, save them, print them as we need them – we just couldn’t modify them or change any information on them. In order to view them however, we need to have the Adobe Reader, which is a free application distributed by Adobe Systems

To download the latest version of Adobe Reader go to this website:
http://www.get.adobe.com/reader/

Tuesday, May 25, 2010

NAMING & SAVING WORK

NAME YOUR WORK AND SAVE IT OFTEN
  • When you open a document in Word, Works, Excel, Power Point or any type of “creation’ application software – they will have a document or project number until we give them a name of our choice
  • The more “new documents, spreadsheets, power point slide show presentations” you open” the higher the numbers get all day
  • You want to ALWAYS name your document, spreadsheets, power point slide show presentations, ASAP, so you can find it
  • To name to the document to the Menu Bar (or the office button in the newer Office 2007 products) Choose File – Save As – It will open “My Documents” , and either choose or create the folder you want to save your work in
  • In class – if you also want to save it to your Flash/Memory stick, repeat the process and once you choose “Save As” remember to go to “My Computer” and find the DRIVE that your flash/Memory stick is on–now open “My Documents” and either choose or create the folder you want to save your work in
  • NAME THE DOCUMENT so you can find it in the future – Click Ok or Save

TIPS:

  • Once your work is saved – in the future – you can simply click on the SAVE ICON often which will save your additions and changes to the named document you have
  • If you are creating a second document, then you would repeat the steps above, giving this work an entirely new name