Saturday, March 20, 2010

Basic Formulas of Office2007

Basic Formulas

Formulas in Microsoft Excel require three things in order to work.  All formulas require an equal sign, cell references and a math operative. Every formula must have all three parts.  The equal sign is a warning to the computer that the next entry in the cell will require math.  Cell references are, literally, what cells you are doing the math to.  Math operatives are the signs for addition, subtraction, multiplication and division.  The “+” is for addition, “-“ is for subtraction, a “/” is for division, and an “*” is for multiplication. 





















The primary complaint with this kind of formula is that it requires a lot of typing.  There is something inefficient about this style of doing formulas.

Functions

A function is a formula that requires less typing.  A function will also need an equal sign, cell references and a math operator.  This time the math operator is called a function name.  Each function has its own name.  You must have the right name for the function you would like to perform.  For example, the function name for addition is “SUM.”  A sample function appears below.



















Notice that the math operative has been replaced by the single word “SUM” only typed once.  The cell references are represented as a range instead of single cells.  =SUM(C5:C8)  The colon represents the range.
 The Paste Function
There is really no way to memorize every function name that there is to do.  In fact, Excel is capable of over 300 functions.  So that you don’t need to memorize, there is a feature called the Paste Function.  There is a button on the ribbon this is the symbol for the Greek E, Sigma.  Next to it is a drop down arrow for a list.  At the end of the menu is list an option for “more functions;” that choice will launch the function palette.  Like every other palette, it will have a list of options for you.  It will have a list of every function that you can create.



















You will notice that the panel is cut in half.  On the top of the box is an option to search for a function.  Below that is the drop down list of categories that you can choose from.  On the bottom are the function names.  Notice, too, that even if the function names do not seem intuitive, the palette will tell you what the selected function does in bold at the bottom of the dialog box. 


















Once you have decided upon a function, the paste function feature will talk you through it.  Select the one you would like to use and then click the button that says “OK.”  Follow the prompts through the rest of the wizard to complete the math.

Friday, March 19, 2010

Office PowerPoing 2003 Commands in Office PowerPoint 2007

PowerPoint
Office 2003
Keys
Office 2007
Edit / Copy
Ctrl C
Home tab / Clipboard group / Copy
Edit / Cut
Ctrl X
Home tab / Clipboard group / Cut
Edit / Find
Ctrl F
Home tab / Editing group / Find
Edit / Paste
Ctrl V
Home tab / Clipboard group / Paste
Edit / Redo
Ctrl Y
Quick Access toolbar / Redo
Edit / Replace
Ctrl H
Home tab / Editing group / Replace
Edit / Undo
Ctrl Z
Quick Access toolbar / Undo
File / Close
Ctrl W
Office button / Close
File / Exit
Alt F4
Office button / Exit PowerPoint
File / New
Ctrl N
Office button / New
File / Open
Ctrl O
Office button / Open
File / Page Setup

Page Layout tab / at the bottom right of the Page Setup, click the Launcher button,
File / Print
Ctrl P
Office button / Print
File / Print preview

Office button / Print / Print preview
File / Save
Ctrl S
Office button /Save or click the disk on the Quick Access Toolbar
File / Save as Web page

Office button / Save as / Save as Web page
Format / Bullets and Numbering

Home tab / Paragraph group / Bullets
Format / Font

Home tab / Font group
Format / Line Spacing

Home tab / Paragraph group / Line Spacing
Insert / New Slide
Ctrl M
Home tab / Insert group / New slide
Insert / Picture / Clip Art

Insert tab / Illustrations group / Clip Art
Insert / Picture / From File

Insert tab / Illustrations group / Picture
Insert / Slides From File

Home tab / Slides group / New Slides / Reuse Slides
Insert / Slides From Outline

Home tab / Slides group / New Slides / Slides from Outline
Insert / Symbol

Insert tab / Text group / Symbol
Insert / Text Box

Insert tab / Text group / Text Box
View / Grids and Guides

Home tab / Drawing group / Arrange / Align / Grid settings
View / Header and Footer

Insert tab / Text group / Header & Footer
View / Master / Slide Master

View tab / Presentations Views / Slide Master
View / Normal

View tab / Presentations Views / Normal or click on the bottom right
View / Slide Show

View tab / Presentations Views / Slide Show or tap F5 or click on the bottom right, or in the Slide Show tab, look in the Start Slide Show group
View / Slide sorter

View tab / Presentations Views / Slide sorter or click on the bottom right