ns office 2015 manual

8/10/2019 Ns Office 2015 Manual

1/62

MSOffice2007Courseware


2/62

Page2of62

Index

MSOffice2007.............................................................................................................................................. 5

Explore the User Interface...................................................................................................................... 5

QuickAccessToolbar............................................................................................................................ 5

Minitoolbar.......................................................................................................................................... 5

WorkWiththeRibbon.......................................................................................................................... 6

Key

Tips

.................................................................................................................................................

7

Changethekeyboardfocuswithoutusingthemouse......................................................................... 7

UseaccesskeysfromOffice2003inRibbonprograms........................................................................ 8

Work with Contextual Tabs.................................................................................................................... 9

Use the Galleries...................................................................................................................................... 9

OverviewofQuickStyles........................................................................................................................ 10

DocumentInspector............................................................................................................................... 11

MyPlacesbar.......................................................................................................................................... 12

PDFandXPSfileformats......................................................................................................................... 14

MicrosoftWord2007.................................................................................................................................. 15

DocumentInspectorMSOfficeWord2007............................................................................................ 15

StylesandStyleSet................................................................................................................................. 16

Changeastyle..................................................................................................................................... 16

CreateanewQuickStyle.................................................................................................................... 17

StyleInspector.................................................................................................................................... 19

UsingThemes

..........................................................................................................................................

19

Selectasetofthemeeffects............................................................................................................... 21

QuickParts.............................................................................................................................................. 21

Citationandbibliography........................................................................................................................ 22

Comparedocuments............................................................................................................................... 22

MicrosoftExcel2007................................................................................................................................... 24


3/62

Page3of62

DocumentInspectorMSOfficeExcel2007............................................................................................. 24

ConditionalFormatting........................................................................................................................... 25

Manageconditionalformattingruleprecedence............................................................................... 25

Sorting..................................................................................................................................................... 29

Sortdatainarangeortable............................................................................................................... 29

SortbyCaseSensitivity....................................................................................................................... 31

Table........................................................................................................................................................ 31

PivotTables............................................................................................................................................. 31

DifferencesbetweenPivotChartreportsandcharts.......................................................................... 35

NameManager....................................................................................................................................... 36

ThenewFormulaBar.............................................................................................................................. 37

DuplicateEntries

.....................................................................................................................................

39

Filterforuniquevalues....................................................................................................................... 39

Removeduplicatevalues.................................................................................................................... 40

ConnectingExceltoExternalDataSource.............................................................................................. 40

TogetDataConnections..................................................................................................................... 41

Workingwith3DGraphs......................................................................................................................... 43

3DFormatoptions............................................................................................................................. 44

MSPowerPoint2007.................................................................................................................................. 46

DocumentInspectorMSOfficePowerPoint2007.................................................................................. 46

SmartArt.................................................................................................................................................. 46

EnhancedAnimation............................................................................................................................... 48

ThemesandStyles.................................................................................................................................. 49

Applyabuiltinthemetoaslidemaster............................................................................................. 49

ABriefonStyles.................................................................................................................................. 49

EnhancedSlideDesign............................................................................................................................ 49

AutoContentWizard

...........................................................................................................................

49

TitleMaster......................................................................................................................................... 50

ToAddaSlideMaster......................................................................................................................... 50

MicrosoftOutlook2007.............................................................................................................................. 51

ColorsandShortcuttoCategories......................................................................................................... 53


4/62

Page4of62

AboutCalendars...................................................................................................................................... 55

Viewcalendarssidebysideoroverlaid................................................................................................. 55

Openacalendarinanewwindow...................................................................................................... 56

Overlaythecalendars......................................................................................................................... 56

Removeacalendarfromtheoverlaystack........................................................................................ 57

PublishandShareCalendar.................................................................................................................... 57

TaskandCalendarintegration................................................................................................................ 59

ToDoList................................................................................................................................................ 60


5/62

MaestrosMedilineSystemsLtd.Allrightsreserved Page5of62

MSOffice2007

Explorethe

User

Interface

QuickAccessToolbar

TheQuickAccessToolbarcanbelocatedinoneoftwoplaces:

UpperleftcornernexttotheMicrosoftOfficeButton (defaultlocation)

BelowtheRibbon

Ifyoudon'twanttheQuickAccessToolbartobedisplayedinitscurrentlocation,youcanmoveittothe

other location. Ifyou find that thedefault locationnext to theMicrosoftOfficeButton is too far

fromyourworkareatobeconvenient,youmaywanttomoveitclosertoyourworkarea.Thelocation

belowtheRibbonencroachesontheworkarea.Therefore,ifyouwanttomaximizetheworkarea,you

maywanttokeeptheQuickAccessToolbarinitsdefaultlocation.

ClickCustomizeQuickAccessToolbar tomovetheribbon.

Minitoolbar

Whenyouselecttext,youcanshoworhideahandy,miniature,semitransparenttoolbarcalledtheMini

toolbar.TheMinitoolbarhelpsyouworkwithfonts,fontstyles,fontsizing,alignment,textcolor,indent

levels,andbulletfeatures.

Note YoucannotcustomizetheMinitoolbar.

Thefollowingshowshowthesemitransparenttoolbarlookswhenyouselecttextonaslideorinashape

inMicrosoftOfficePowerPoint2007.


6/62


ThefollowingshowstheMinitoolbarwhenyourestyourpointeronit.Tousethetoolbar,clickanyof

theavailablecommands.

WorkWiththeRibbon

The Ribbon is designed to help you quickly find the commands that you need to complete a task.

Commandsareorganizedinlogicalgroups,whicharecollectedtogetherundertabs.Eachtabrelatesto

atypeofactivity,suchaswritingorlayingoutapage.Toreduceclutter,sometabsareshownonlywhen

needed.Forexample,thePictureToolstabisshownonlywhenapictureisselected.

Ribbon ThepictureaboveiscalledRibbon

Tabs TheHome,Insert,PageLayout,etcarecalledTabs.Someofthetabsappearonly

inacontext

Group EveryTabisfurtherdividedintoGroups.Inthepictureabove,theHomeTab,

showsGroupslikeClipboard,Font,Paragraph,StylesandEditing

Galleries

TheGroup

Styles

shows

agallery.

We

have

other

galleries

as

well.

StylesDialogBox

Launcher

AttheextremeRightBottomyouseetheDialogboxLauncherforthatGroup.


7/62


KeyTips

PressandReleasetheALTkey.

TheKeyTipsaredisplayedovereachfeaturethatisavailableinthecurrentview.Thefollowingexample

isfromMicrosoftOfficeWord.

Changethekeyboardfocuswithoutusingthemouse

AnotherwaytousethekeyboardtoworkwithRibbonprogramsistomovethefocusamongthetabs

andcommandsuntilyoufindthefeaturethatyouwanttouse.Thefollowingtablelistssomewaysto

movethekeyboardfocuswithoutusingthemouse.

Todothis Press

SelecttheactivetaboftheRibbonandactivatetheaccess

keys.

ALTorF10.Presseitherofthesekeys

againtomovebacktothedocument

andcancel

the

access

keys.

MovetoanothertaboftheRibbon. ALTorF10toselecttheactivetab,

andthenLEFTARROWorRIGHT

ARROW

MinimizeorrestoretheRibbon. CTRL+F1


8/62


Displaytheshortcut menu fortheselectedcommand. SHIFT+F10

Movethefocustoselecteachofthefollowingareasofthe

window:

Active

tab

of

the

Ribbon

Viewstatusbaratthebottomofthewindow

Yourdocument

F6

MovethefocustoeachcommandintheRibbon,forwardor

backward.

ALTorF10,andthenTABor

SHIFT+TAB

Movedown,up,left,orrightamongtheitemsintheRibbon. DOWNARROW,UPARROW,LEFT

ARROW,orRIGHTARROW

ActivatetheselectedcommandorcontrolintheRibbon. SPACEBARorENTER

OpentheselectedmenuorgalleryintheRibbon. SPACEBARorENTER

Activate

a

command

or

control

in

the

Ribbon

so

you

can

modifyavalue. ENTER

FinishmodifyingavalueinacontrolintheRibbon,andmove

focusbacktothedocument.

ENTER

GethelpontheselectedcommandorcontrolintheRibbon.(If

noHelptopicisassociatedwiththeselectedcommand,the

Helptableofcontentsforthatprogramisshowninstead.)

F1

UseaccesskeysfromOffice2003inRibbonprograms

InsomeMicrosoftOfficeprograms,menusandtoolbarshavebeenreplacedbytheRibbon.However,if

youhavememorizedandgottenusedtousingtheaccesskeysfromMicrosoftOffice2003,youcanstill

usethem.

Note:inMicrosoftOfficeOutlook,menusandtoolbarsarestillpartofthemainwindowoftheprogram.

However,inopenitemssuchasemailmessages,theaccesskeyshavebeenreplacedwiththeRibbon.

WhenyouareusinganaccesskeyfromOffice2003,amessageisdisplayedtoalertyouandtoremind

youwhichkeysyouhavepressed.

Forexample: If,youwantto insertahyperlink inyour file,andyouareusedtousingtheaccesskey

sequencefromOffice2003,soyoupressALT+I.Thefollowingmessageisshowntoremindyouofwhich

keys youhavepressed:Office 2003 access key:ALT, I,.When youpress the I key again, the Insert

Hyperlinkdialogboxisdisplayed.


9/62


WorkwithContextualTabs

Thetabsthatsurfaceorshowupwhileyouareworkingwithaspecificfeaturearecalledcontextual

tabs.

Forexample:YoudonotseetheDrawingToolsFormatTabhere.Butthemomentyouinsertadrawing

tool,thetabshowsup.ThusbasedonthecontexttheTabsshowup

UsetheGalleries

IordertocreateprofessionallookingdocumentsOfficeWord2007provideseditingandreviewingtools

forcreatingpolisheddocuments.


10/62


Thegalleriesof formattingchoicesgiveyoua livevisualpreviewof the formatting inyourdocument

before you commit to making a change. Thus Word eliminates the guesswork when you apply

formattingtoyourdocument.Andnowyoucanspendmoretimewritingandlesstimeformatting

Especiallywhen

you

are

working

with

templates

such

as

areport,

you

can

select

from

agallery

of

preformatted coverpages,pullquotes, andheaders and footers tomake yourdocument lookmore

polished.

Ifyouwanttocustomizethepreformattedcontent,orifyourorganizationoftenusesthesamepieceof

content,suchaslegaldisclaimertextorcustomercontactinformation,youcancreateyourownbuilding

blocksthatyouselectfromthegallerywithasingleclick.Thusaddingpreformattedelementswithjusta

fewclicks

OverviewofQuickStyles

QuickStylesarecombinationsofdifferent formattingoptionsandaredisplayed ina thumbnail in the

variousQuickStylegalleries.WhenyouplaceyourpointeroveraQuickStyle thumbnail,youcan see

howtheQuickStyleaffectsyourSmartArtgraphicorshape.

QuickStylesforSmartArtgraphics(SmartArtStyles) includeedges,shadows, linestyles,gradients,and

threedimensional(3D)perspectives.TrydifferentcombinationsofSmartArtStylesandcolorsuntilyou

findonethatmatchesthemessagethatyouwant tocommunicate.Youcanpicka layout,aSmartArt

Style,andacolorvariationthatyou like,andthenchangethe layoutagainyourSmartArtStyleand

colorswillstaywithyourSmartArtgraphic,sothatyoudonotneedtoredothem.

SmartArt Stylesmap the theme effects(theme effects: A set of visual attributes that is applied to

elements inafile.Themeeffects,themecolors,andthemefontscomposeatheme.)ofthedocument

theme(theme: A combination of theme colors, theme fonts, and theme effects. A theme may be

appliedtoa fileasasingleselection.)totheshapeswithintheSmartArtgraphic.Forexample,shapes

mighthavethick linesoredges,whilearrowsmighthaveamoresubtlestyleappliedtothem.Youcan

alsoapplycolorsfromthethemecolors(themecolors:Asetofcolorsthatisusedinafile.Themecolors,

themefonts,andthemeeffectscomposeatheme.)ofthedocumentindifferentways,suchaschanging

thecoloroftheshapeborder.IfyoucreatemultipleSmartArtgraphicsandwantthemtolookalike,you

canapplythesamecolorsandSmartArtStyletoachieveaconsistent,professionallook.

You canhave shapes thatdisplaywith edges,depth, and rotate in 3D space. Tomake an SmartArt

graphicthreedimensional,applyan3DSmartArtStyleormanuallyapplya3Drotationtoeachshape.

If the entire SmartArt graphic is threedimensional (called scene coherent 3D(scenecoherent 3D:

Cameraanglesand lightsettingsthatyoucanusetocontroltheorientation,shadow,andperspective

forgroupedshapes.)),youcancontinuetoeditthetextandformattingofeachoftheindividualshapes,

but the shapes cannotbe repositionedor resized.Youcanonly repositionor resize shapes ina two


11/62


dimensionalscene.Toswitchbetween2Dand3D,underSmartArtTools,on theFormat tab, in the

Shapesgroup,clickEdit in2D.TheEdit in2Dbutton temporarilyunlocksyourSmartArtgraphic for

editing so thatyou canmoveand resize shapesbut the3DSmartArtStyle is stillapplied toyour

SmartArt graphic and reappears when you click Edit in 2D again. When your SmartArt graphic is

displayedina3Dscene,youcanrotateitasawholeandpositionlightsourcesandthe"camera"such

thattheentireSmartArtgraphicappearstopopoutofthescreen.

SmartArt Stylesaffect anentire SmartArt graphic,whileQuickStyles forShapes (ShapeStyles)affect

onlytheselectedshape.Youcanmanuallycustomizeashapebychangingthecolor,effects,orborder,

orbyreplacingitwithanothershape.ItisrecommendedthatyoucustomizeyourSmartArtgraphiconly

after you settleon its content and layout, as some customizations arenot transferredbecause they

might not look good in the new layout. Formore information about switching layouts for SmartArt

graphics,seeSwitchthelayoutortypeofaSmartArtgraphic.

DocumentInspector

Inspectdocumentsforhiddendataandpersonalinformation

Before sharing a file or documentwith clients or colleagues, it is good to review the document for

hiddendataorpersonal information thatmightbe stored in thedocument itselfor in thedocument

properties.

Toavoidrevealingdetailsaboutyourorganizationoraboutthedocumentitselfthatyoumightnotwant

tosharepublicly,youmightwant to remove thishidden informationbeforeyou share thedocument

withother

people.

MicrosoftOfficedocumentscancontainthefollowingtypesofhiddendataandpersonalinformation:

Comments,revisionmarksfromtrackedchanges,versions,andinkannotations

If you collaboratedwithotherpeople to createyourdocument, yourdocumentmight contain items

suchasrevisionmarksfromtrackedchanges,comments,inkannotations,orversions.Thisinformation

canenableotherpeopletoseethenamesofpeoplewhoworkedonyourdocument,commentsfrom

reviewers,andchangesthatweremadetoyourdocument.

Documentproperties

and

personal

information

Documentproperties,alsoknownasmetadata(metadata:Datathatdescribesotherdata.Forexample,

thewords inadocumentaredata;thewordcount isanexampleofmetadata.), includedetailsabout

yourdocumentsuchasauthor,subject,andtitle.Documentpropertiesalsoincludeinformationthatis

automaticallymaintainedbyOfficeprograms,suchasthenameofthepersonwhomostrecentlysaved


12/62


adocumentandthedatewhenadocumentwascreated.Ifyouusedspecificfeatures,yourdocument

mightalsocontainadditionalkindsofpersonallyidentifiableinformation(PII)

PersonallyIdentifiableInformation(PII):

Any information that can be used to identify a person, such as a name, address, email address,

governmentID,IPaddress,oranyuniqueidentifierassociatedwithPIIinanotherprogram.),suchase

mailheaders,sendforreviewinformation,routingslips,andtemplatenames.

Headers,footers,andwatermarks

Worddocumentscancontaininformationinheadersandfooters.Additionally,youmighthaveaddeda

watermarktoyourWorddocument.

Hiddentext

Worddocumentscancontaintextthatisformattedashiddentext.Ifyoudonotknowwhetheryour

documentcontainshiddentext,youcanusetheDocumentInspectortosearchforit.

Documentserverproperties

Ifyourdocumentwassavedtoalocationonadocumentmanagementserver,suchasaDocument

WorkspacesiteoralibrarybasedonMicrosoftWindowsSharePointServices,thedocumentmight

containadditionaldocumentpropertiesorinformationrelatedtothisserverlocation.

CustomXML

data

Documents

can

contain

custom

XML

data

that

is

not

visible

in

the

document

itself.

TheDocumentInspectorcanfindandremovethisXMLdata.

MyPlacesbar

TheMyPlacesbar isanareaatthe leftside insomedialogboxes,suchasSaveAs,Open,and Insert

Picture.YoucanusetheMyPlacesbartospecifyafolderwhereyouwanttostoreyourfilesforeasier

access.MakingchangestotheMyPlacesbarinanyonedialogboxcausesthesamechangestoappear

inotherdialogboxesthathavetheMyPlacesbar.

Bydefault,

the

My

Places

bar

contains

shortcuts

to

the

My

Recent

Documents,

Desktop,

My

Documents,

MyComputer,andMyNetworkPlacesfolders.Youcanaddupto256folderstotheMyPlacesbar.You

cannotaddfilestotheMyPlacesbar.


13/62


1. Tochooseafolder,usetheSaveinlist.

2. ToviewthecontentsofafolderontheMyPlacesbar,clickthefolder'sshortcutontheMy

Placesbar.

3.

ToseemoreshortcutsthatyouaddedtotheMyPlacesbar,clickthearrow.

AddashortcuttotheMyPlacesbar

DothefollowinginMSWord,MSExcelandMSPowerPoint2007programs:

1.

ClicktheMicrosoftOfficeButton ,andthenclickSaveAs.

2. IntheSaveinlist,clickthedrive,folder,orInternetlocationforwhichyouwanttocreateaMy

Placesbarshortcut.

3. RightclickablankspaceintheMyPlacesbarbelowtheexistingshortcuts,andthenclickAdd

foldername.

YournewshortcutappearsatthebottomoftheMyPlacesbar.

FurtheryoucanalsoRemoveandmovetheshortcutupanddowntheMyPlacesbar.Youcanalso

resizetheIconsintheMyPlacesbar


14/62


15/62


Byusinganaddin,youcansaveorexportafilefromyourMicrosoftOfficeprogramintothefollowing

formats:

PortableDocumentFormat(PDF) PDFisafixedlayoutelectronicfileformatthatpreserves

documentformattingandenablesfilesharing.ThePDFformatensuresthatwhenthefileis

viewedonlineorprinted, itretainsexactlythe formatthatyou intended,andthatdata in

thefilecannotbeeasilychanged.ThePDFformat isalsousefulfordocumentsthatwillbe

reproducedbyusingcommercialprintingmethods.

XMLPaperSpecification (XPS) XPS isa fixedlayoutelectronic file format thatpreserves

documentformattingandenablesfilesharing.TheXPSformatensuresthatwhenthefileis

viewedonlineorprinted, itretainsexactlythe formatthatyou intended,andthatdata in

thefilecannotbeeasilychanged.

MicrosoftWord2007

DocumentInspectorMSOfficeWord2007

MicrosoftWord2007cancontainthefollowingHiddendata:

Inspectorname Findsandremoves

Comments,Revisions,Versions,and

Annotations

Comments

Revisionmarksfromtrackedchanges

Documentversioninformation

Ink

annotations

DocumentPropertiesandPersonal

Information

Documentproperties,includinginformationfromthe

Summary,Statistics,andCustomtabsoftheDocument

Propertiesdialogbox

Emailheaders

Routingslips

Sendforreviewinformation


DocumentManagementPolicyinformation

Contenttypeinformation

Databindinglinkinformationfordataboundfields(last

valuewillbeconvertedtotext)

Username

Templatename

HeadersandFooters Informationindocumentheaders

Informationindocumentfooters

Watermarks

HiddenText Textthatisformattedashidden(afonteffectthatis


16/62


availableintheFontdialogbox)

NoteThisInspectorcannotdetecttextthatwashiddenby

othermethods(forexample,whitetextonawhite

background).

CustomXML

Data

Custom

XML

data

that

might

be

stored

within

adocument

Toremovehiddendataandpersonalinformation

YoucanusetheDocumentInspectortofindandremovehiddendataandpersonalinformationinWord

documents thatwere created inOfficeWord 2007 andearlier versions. It is a good idea touse the

DocumentInspectorbeforeyoushareanelectroniccopyofyourWorddocument,suchasinanemail

attachment.

1.

OpentheWorddocumentthatyouwanttoinspectforhiddendataandpersonalinformation.

ClicktheMicrosoftOfficeButton ,clickSaveAs,andthentypeanameintheFilenameboxtosave

acopyofyouroriginaldocument.

Important ItisagoodideatousetheDocumentInspectoronacopyofyouroriginaldocument

becauseitisnotalwayspossibletorestorethedatathattheDocumentInspectorremoves.

1. Inthecopyofyouroriginaldocument,clicktheMicrosoftOfficeButton ,pointtoPrepare,

andthenclickInspectDocument.

2.

IntheDocumentInspectordialogbox,selectthecheckboxestochoosethetypesofhidden

contentthatyouwanttobeinspected.

3. ClickInspect.

4. ReviewtheresultsoftheinspectionintheDocumentInspectordialogbox.

5.

ClickRemoveAllnexttotheinspectionresultsforthetypesofhiddencontentthatyouwantto

removefromyourdocument.

Important Ifyouremovehiddencontentfromyourdocument,youmightnotbeabletorestoreitby

clickingUndo.

StylesandStyleSet

Changeastyle

InMicrosoftOfficeWord2007,Quick Stylesare setsof styles that aredesigned towork together to

create an attractive andprofessional lookingdocument. Inmost cases, youwon't change styles in a

QuickStylesetbecausethestyleshavebeendesignedtocomplementoneanother,andit'seasiertouse

adifferentQuickStyleset.But,undercertaincircumstances,youmightwanttochangetheattributesof

astyleinaQuickStyleset.

1. Selecttextthatisstyledwiththestyleattributesthatyouwanttochange.


17/62


Forexample,tochangetheattributesoftheHeading1style,selecttextthathastheHeading1style

applied.

TipToviewtheattributesofaparticularstyle,clicktheStylesDialogBoxLauncher,andthenrestyour

pointerover

astyle

in

the

list.

2.

Formattheselectedtextwiththenewattributesthatyouwant.

Forexample,youmightdecidethatyouwanttochangethepointsizefortheHeading1stylefrom16

pointsto14points.

3.

OntheHometab,intheStylesgroup,rightclickthestylethatyouwanttochange.

4.

ClickUpdatetoMatchSelection.

NoteAlltextwiththestylethatyouchangedwillautomaticallychangetomatchthenewstylethatyou

defined.

TipIfyouchangedthestylesinadocumentandthestylesarenotupdatingthewayyouexpected,click

theStylesDialogBoxLauncher,and thenclickStyle Inspector to findoutwhether textwasmanually

formattedinsteadofformattedbyusingstyles.

CreateanewQuickStyle

QuickStylesaresetsofstylescreatedtoworktogether.AlthoughaQuickStylesetlikelycontainsallof

the styles thatyouneed tobuildadocument,youmaywant toaddabrandnew style.Youcanalso

createadditionalstyles,suchasanewtableorliststyle.

1.

Selectthe

text

that

you

want

to

create

as

anew

style.

Forexample,perhapsyouwantthewordbusinessalwaystoappearasboldandredinyourdocument.

2. OntheMinitoolbarthatappearsaboveyourselection,clickBoldandRedtoformatthetext.

3. Rightclicktheselection,pointtoStyles,andthenclickSaveSelectionasaNewQuickStyle.


18/62


4.

Givethestyleanameforexample,businessandthenclickOK.

ThebusinessstylethatyoucreatedappearsintheQuickStylesgallerywiththenameyougaveit,ready

foryoutousewheneveryouwanttexttobeboldandred.ThiscouldalsobeseenintheStylespane.


19/62


StyleInspector

UsingThemes

You canquickly and easily format an entiredocument to give it a professional andmodern lookby

applying a document theme(theme: A set of unified design elements that provides a look for your

documentbyusingcolor, fonts,andgraphics.).Adocument theme isasetof formattingchoices that

includeasetofthemecolors,asetofthemefonts(includingheadingandbodytextfonts),andasetof

themeeffects(includinglinesandfilleffects).

Youcan

apply

adocument

theme,

Customize

adocument

theme,

save

adocument

theme

Applyadocumenttheme

YoucanchangethedocumentthemethatisappliedbydefaultinOfficeprograms,suchasWord,Excel,

and PowerPoint, by selecting another predefined document theme or a custom document theme.

Document themes that you apply immediately affect the styles(style: A combination of formatting

characteristics, suchas font, font size,and indentation, thatyounameand storeasa set.Whenyou

applyastyle,alloftheformattinginstructionsinthatstyleareappliedatonetime.)thatyoucanusein

yourdocument.

Dooneofthefollowing:

1. InWordorExcel: OnthePageLayouttab,intheThemesgroup,clickThemes,andyouwillsee

eitheroftheThemesgroup


20/62


2. InPowerPoint: OntheDesigntab,intheThemesgroup,clickthedocumentthemethatyou

want,orclickMore toseeallavailabledocumentthemes.

Dooneofthefollowing:

1. Toapplyapredefineddocumenttheme,clickthedocumentthemethatyouwanttouseunder

BuiltIn.

2. Toapplyacustomdocumenttheme,clickthedocumentthemethatyouwanttouseunder

Custom.

Note:Custom

is

available

only

ifyou

created

one

or

more

custom

document

themes.

For

more

informationaboutcreatingcustomdocumentthemes,seeCustomizeadocumenttheme.

Ifadocumentthemethatyouwanttouseisnotlisted,clickBrowseforThemestofinditonyour

computeroranetworklocation.

TosearchforotherdocumentthemesonOfficeOnline,clickSearchOfficeOnline.

Tip:InPowerPoint,youcanapplyadocumentthemetoallslides,toselectedslidesonly,ortothe

masterslide.Rightclickthedocumenttheme,andthenclicktheoptionthatyouwant.

Customize

a

document

theme

Tocustomizeadocumenttheme,youstartbychangingthecolors,thefonts,orthelineandfilleffects

thatareused.Changesthatyoumaketooneormoreofthesethemecomponents immediatelyaffect

the styles thatyouhaveapplied in the activedocument. Ifyouwant to apply these changes tonew

documents,youcansavethemasacustomdocumenttheme.

Customizethethemecolors

Themecolorscontainfourtextandbackgroundcolors,sixaccentcolors,andtwohyperlinkcolors.The

colors in the ThemeColors button represent the current text andbackground colors. The setof

colorsthat

you

see

next

to

the

Theme

Colors

name

after

you

click

the

Theme

Colors

button

represent

theaccentandhyperlinkcolors for that theme.Whenyouchangeanyof thesecolors tocreateyour

ownsetofthemecolors,thecolorsthatareshownintheThemeColorsbuttonandnexttotheTheme

Colorsnamewillchangeaccordingly.


21/62


Tip:Toreturnallthemecolorelementstotheiroriginalthemecolors,youcanclickResetbeforeyou

clickSave.

Customizethethemefonts

Themefontscontainaheadingfontandabodytextfont.WhenyouclicktheThemeFontsbutton ,

youcanseethenameoftheheadingfontandbodytextfontthatisusedforeachthemefontbelowthe

ThemeFontsname.Youcanchangebothofthesefontstocreateyourownsetofthemefonts..

Selectasetofthemeeffects

Themeeffectsaresetsoflinesandfilleffects.WhenyouclicktheThemeEffectsbutton ,youcansee

thelinesandfilleffectsthatareusedforeachsetofthemeeffectsinthegraphicthatisdisplayedwith

theThemeEffectsname.Althoughyoucannotcreateyourownsetofthemeeffects,youcanchoosethe

onethatyouwanttouseinyourowndocumenttheme.

Youcansaveadocumenttheme

QuickParts

QuickPartsarereusablepiecesofcontentorotherdocumentpartsthatarestoredingalleries.Youcan

accessandreusethebuildingblocksatanytime.Youcanalsosavebuildingblocksanddistributethem

withtemplates.

YoucanuseAutoText,onetypeofbuildingblock,tostoretextorgraphicsthatyouwanttouseagain,

suchasastandardcontractclauseoralongdistributionlist.Eachselectionoftextorgraphicsisstored

asanAutoTextentryintheBuildingBlocksOrganizerandisassignedauniquenamethatmakesiteasy

foryou

to

find

the

content

when

you

want

to

use

it.

Createareusablecontentbuildingblock

1.

Selectthetextorgraphicthatyouwanttostoreasareusablebuildingblock.

Tostoreparagraphformattingincludingindentation,alignment,linespacing,andpaginationwith

theentry,includetheparagraphmark( )intheselection.

Note Toviewparagraphmarks,ontheHometab,intheParagraphgroup,clickShow/Hide.

2.

OntheInserttab,intheTextgroup,clickQuickParts,andthenclickSaveSelectiontoQuick

PartGallery.OrpressALT+F3.

3. FillouttheinformationintheCreateNewBuildingBlockdialogbox:

Name Typeauniquenameforthebuildingblock.


22/62


Gallery Selectthegallerythatyouwantthebuildingblocktoshowupin.

Category Selectacategory,suchasGeneralorBuiltIn,orcreateanewcategory.

Description

Type

a

description

of

the

building

block.

Savein Selectthenameofthetemplatefromthedropdownlist.

Options SelectInsertcontentinitsownpagetoensurethebuildingblockisplacedon

a separatepage.Select Insert inownparagraph for content that shouldnotbecome

partof anotherparagraph, even if theuser's cursor is in themiddleof aparagraph.

SelectInsertcontentonlyforallothercontent.

Citationandbibliography

Attimesyouinsertsomeabstractofinformationasadditionalinformationandthenthereadersneedto

knowmore

about

it.

In

such

acase

you

will

let

your

reader

know

the

place

from

where

the

information

iscited.Whenyouaddanewcitationtoadocument,youalsocreateanewsourcethatwillappearin

thebibliography.

Abibliographyisalistofsources,usuallyplacedattheendofadocument,thatyouconsultedorcitedin

creatingthedocument. InMicrosoftOfficeWord2007,youcanautomaticallygenerateabibliography

basedonthesourceinformationthatyouprovideforthedocument.

Eachtimethatyoucreateanewsource,thesourceinformationissavedonyourcomputer,sothatyou

canfindanduseanysourceyouhavecreated.

Comparedocuments

Astepbysteptocomparedocumentssidebyside

1.

Openbothofthefilesthatyouwanttocompare.

2. OntheViewtab,intheWindowgroup,clickViewSidebySide.

NotesToscrollbothdocumentsatthesametime,clickSynchronousScrollingintheWindowgroupon

theViewtab.

Ifyoudon'tseeSynchronousScrolling,clickWindowontheViewtab,andthenclickSynchronous

Scrolling.


23/62


TocloseSidebySideview,clickViewSidebySideintheWindowgroupontheViewtab.

Ifyoudon'tseeViewSidebySide,clickWindowontheViewtab,andthenclickViewSidebySide.


24/62


MicrosoftExcel2007

DocumentInspectorMSOfficeExcel2007

MicrosoftExcel2007cancontainthefollowingHiddendata:


CommentsandAnnotations Comments

Inkannotations


Information



Propertiesdialogbox

Emailheaders

Routingslips





Username

Printerpathinformation

Scenariocomments

FilepathforpublishingWebpages

Commentsfordefinednamesandtablenames

Inactiveexternaldataconnections

Headersand

Footers

Information

in

worksheet

headers

Informationinworksheetfooters

HiddenRowsandColumns Hiddenrows

Hiddencolumnsthatcontaindata

Note Iftherearehiddencolumnsinyourworkbookthat

donotcontaindataandtheyarelocatedbetweencolumns

thatdocontaindata,theseemptyhiddencolumnswillalso

bedetectedandremoved.

Ifthehiddenrowsorcolumnsinyourworkbookcontain

data,youmightchangetheresultsofthecalculationsor

formulasinyourworkbookbyremovingthem.Ifyoudonot

knowwhatinformationthehiddenrowsorcolumns

contain,closetheDocumentInspector,unhidethehiddenrowsorcolumns,andthenreviewtheircontents.

ThisInspectordoesnotdetectshapes,charts,controls,

MicrosoftActiveXobjectsandcontrols,pictures,or

SmartArtgraphicsthatmightbelocatedinhiddencolumns.

HiddenWorksheets Hiddenworksheets


25/62


26/62


If you copy and paste cell values that have conditional formats to aworksheet opened in another

instanceofMicrosoftOfficeExcel,a conditional formatting rule isnot createdand the format isnot

copied.

Whathappens

when

aconditional

format

and

amanual

format

conflict

Forarangeofcells, ifaformattingruleistrue, ittakesprecedenceoveramanualformat.Youapplya

manual formatbyusing theFormatcommand in theCellsgroupon theHome tab. Ifyoudelete the

conditionalformattingrule,themanualformattingfortherangeofcellsremains.

Note ManualformattingisnotlistedintheConditionalFormattingRulesManagerdialogboxorused

todetermineprecedence.

Editconditionalformattingruleprecedence

1.

On

the

Home

tab,

in

the

Styles

group,

click

the

arrow

next

to

Conditional

Formatting,

and

then

clickManageRules.

Thelistofconditionalformattingrulesaredisplayedforthecurrentselectionincludingtheruletype,the

format,therangeofcellstheruleappliesto,andtheStopIfTruesetting.

Ifyou

don't

see

the

rule

that

you

want,

in

the

Show

formatting

rules

for

list

box,

make

sure

that

the

appropriaterangeofcells,worksheet,table,orPivotTablereportisselected.

2. Selectarule.Onlyonerulecanbeselectedatatime.

3.

Tomovetheselectedruleupinprecedence,clickMoveUp.Tomovetheselectedruledownin

precedence,clickMoveDown.

4. Optionally,tostopruleevaluationataspecificrule,selecttheStopIfTruecheckbox.

SelecttheStopIfTruecheckboxforbackwardscompatibilitywithpreviousversionsofMicrosoftOffice

Excel

2007

that

do

not

support

multiple

conditional

formatting

rules.

For

example,

if

you

have

three

conditional formattingrules forarangeofcells,bydefault,aversionofExcelprevious toOfficeExcel

2007appliesthelastrule inprecedence.Ifyouwantthefirstorsecondruleapplied,selecttheStopIf

Truecheckboxforthatrule.

Note:ReadhelpforConditionalformattingissues


27/62


28/62


5. SelectIconSetandclicktheEditRulebutton

6.

CheckShowIconOnlycheckbox


29/62


7. ThiscolumncanfurtherbeCustomFilteredasshown

Sorting

Sortdata

in

arange

or

table

Sortingdata isan integralpartofdataanalysis.Youmightwant toputa listofnames inalphabetical

order,compilealistofproductinventorylevelsfromhighesttolowest,ororderrowsbycolorsoricons.


30/62


Sortingdatahelpsyouquicklyvisualizeandunderstandyourdatabetter,organizeandfindthedatathat

youwant,andultimatelymakemoreeffectivedecisions.

Note Tofindthetoporbottomvaluesinarangeofcellsortable,suchastop10gradesorbottom5

salesamounts,

use

AutoFilter

or

conditional

formatting.

Youcan

Sorttext

Sortnumbers

Sortdatesortimes

Sortbycellcolor,fontcolor,oricon

Sortbyacustomlist

Sortrows(Worksonarange)

Sort

by

more

than

column

or

row

Sortonecolumninarangeofcellswithoutaffectingtheothers

Learnaboutsorting

Sortcriteriaaresavedwiththeworkbooksothatyoucanreapplythesorteachtimethatyouopenthe

workbookforanExceltable,butnotforarangeofcells.Ifyouwanttosavesortcriteriasothatyoucan

periodically reapply a sortwhen you open aworkbook, then it's a good idea touse a table. This is

especiallyimportantformulticolumnsortsorforsortsthattakealongtimetocreate.

Sorttext

1.

Selectacolumnofalphanumericdatainarangeofcells,ormakesurethattheactivecellisina

tablecolumncontainingalphanumericdata.

2. OntheHometab,intheEditinggroup,andthenclickSort&Filter.

3.

Do

one

of

the

following:

Tosortinascendingalphanumericorder,clickSortAtoZ.

Tosortindescendingalphanumericorder,clickSortZtoA.

4.

Optionally,youcandoacasesensitivesort.


31/62


SortbyCaseSensitivity

1. OntheHometab,intheEditinggroup,clickSort&Filter,andthenclickCustomSort.

2. IntheSortdialogbox,clickOptions.

3. IntheSortOptionsdialogbox,selectCasesensitive.

4.

ClickOKtwice.

Issue:Checkthatalldataisstoredastext Ifthecolumnthatyouwanttosortcontainsnumbersstored

asnumbersandnumbersstoredastext, thenyouneed to formatthemallas text. Ifyoudonot, the

numbersstoredasnumbersaresortedbeforethenumbersstoredastext.Toformatalloftheselected

dataastext,ontheHometab, intheFontgroup,clicktheFormatCellFontbutton,clicktheNumber

tab,andthenunderCategory,clickText.

Issue:

Remove

any

leading

spaces

In

some

cases,

data

imported

from

another

application

might

have

leadingspacesinsertedbeforedata.Removetheleadingspacesbeforesortingthedata.

Note:ReadthehelptoknowGeneralissuesofsorting

Table

Whenyoucreateatable inMicrosoftOfficeExcel,youcanmanageandanalyzethedata inthattable

independentlyofdataoutsideof the table.Forexample,you can filter table columns,adda row for

totals, apply table formatting, and publish a table to a server that is running Microsoft Windows

SharePointServices

3.0.

Whenyoudon'tneedatableanymore,youcanremove itbyconverting itbacktoarangeoryoucan

deleteit.

Note:OtherwiseyouworkwithTablesexactlythewayyouworkwithanyotherdatarange

Note:ReadthehelptoknowaboutExcelTableissues

PivotTables

ThenewlookofthePivotTableisshownhere.

Inorder

to

get

the

Pivot

Table

1. Pointtothedatainthesheet

2. GotoInsertTabandthenintheextremeleftofyourribbonyouseethe


32/62


3.

YoucanhavethePivotTableonanewsheet

IfyouwanttogobacktotheOldPivotTableformat

1. RightclickonthenewPivottableIconthatyougetontheSheetyouhavethePivotTable

2. InthePivotTableOptionsDialogbox,ClicktheDisplayTab

3. CheckthecheckboxforClassicPivotTableLayout


33/62


ComparingaPivotTable

report

and

aPivotChart

report

WhenyoucreateaPivotChartreport fromaPivotTable report, the layoutof thePivotChartreport

that is,thepositionof itsfields isdetermined initiallybythe layoutofthePivotTablereport.When

you create the PivotChart report first, you determine the chart layout by dragging fields from the

PivotTableFieldListtotheareasonthechartsheet(chartsheet:Asheet inaworkbookthatcontains


34/62


onlyachart.AchartsheetisbeneficialwhenyouwanttoviewachartoraPivotChartreportseparately

fromworksheetdataoraPivotTablereport.).

ThefollowingPivotTableandPivotChartreportsofsalesdatashowtherelationshipbetweenthetwo.


35/62


Reportfilterfields

Valuesfields

Arow

label

corresponds

to

acategory

field

Acolumnlabelcorrespondstoaseriesfield

DifferencesbetweenPivotChartreportsandcharts

Ifyouare familiarwithstandardcharts,youwillfindthatmostoperationsarethesame inPivotChart

reports.However,therearesomedifferences:

Interaction Withstandardcharts,youcreateonechartforeachviewofthedatathatyouwanttosee,

but they arenot interactive.WithPivotChart reports.You can createa single chart and interactively

viewthedataindifferentwaysbychangingthereportlayoutorthedetailthatisdisplayed.

Chart types Thedefaultchart type forastandardchart isaclusteredcolumnchart,whichcompares

valuesacross

categories.

The

default

chart

type

for

aPivotChart

report

is

astacked

column

chart,

which

comparesthecontributionofeachvaluetoatotalacrosscategories.YoucanchangeaPivotChartreport

toanycharttypeexceptxy(scatter),stock,orbubble.

Chartlocation Standardchartsareembedded(embeddedchart:Achartthatisplacedonaworksheet

ratherthanonaseparatechartsheet.Embeddedchartsarebeneficialwhenyouwanttovieworprinta

chartoraPivotChartreportwithitssourcedataorotherinformationinaworksheet.)onworksheetsby

default.PivotChartreportsarecreatedonchartsheets(chartsheet:Asheetinaworkbookthatcontains

onlyachart.AchartsheetisbeneficialwhenyouwanttoviewachartoraPivotChartreportseparately

fromworksheetdataoraPivotTable report.)bydefault.Oncecreated,youcan relocateaPivotChart

report

to

a

worksheet.

Sourcedata Standardchartsarelinkeddirectlytoworksheetcells.PivotChartreportscanbebasedon

severaldifferent typesofdata in theassociatedPivotTable report(associatedPivotTable report:The

PivotTable report that supplies the source data to the PivotChart report. It is created automatically

whenyoucreateanewPivotChartreport.Whenyouchangethelayoutofeitherreport,theotheralso

changes.).


36/62


37/62


Column Description

Iconand

NameAdefinednameisindicatedbyadefinednameicon.

Atablenameisindicatedbyatablenameicon.

Value Thecurrentvalueofthename,suchastheresultsofaformula,astringconstant,acell

range,an

error,

an

array

of

values,

or

aplaceholder

ifthe

formula

cannot

be

evaluated.

Thefollowingarerepresentativeexamples:

"thisismystringconstant"

3.1459

{2003;12,2002;23,;2001,18}

#REF!

{...}

RefersTo Thecurrentreferenceforthename.Thefollowingarerepresentativeexamples:

=Sheet1!$A$3

=8.3

=HR!$A$1:$Z$345

=SUM(Sheet1!A1,Sheet2!B2)Scope Aworksheetname,ifthescopeisthelocalworksheetlevel.

"Workbook",ifthescopeistheglobalworksheetlevel.

Comment Additionalinformationaboutthenameupto255characters.Thefollowingare

representativeexamples:

ThisvaluewillexpireonMay2,2007.

Don'tdelete!Criticalname!

BasedontheISOcertificationexamnumbers.

Note IfyousavetheworkbooktoMicrosoftOfficeSharePointServer2007Excel

Services,andyouspecifyoneormoreparameters,thecommentisusedasatooltipinthe

Parameterstoolpane.

Notes

YoucannotusetheNameManagerdialogboxwhileyouarechangingthecontentsofthecell.

TheNameManagerdialogboxdoesnotdisplaynamesdefinedinVisualBasicforApplications

(VBA),orhiddennames(theVisiblepropertyofthenameissetto"False").

ThenewFormulaBar

Resizetheformulaornameboxintheformulabar

Tomakeiteasiertoviewandeditalongformula(formula:Asequenceofvalues,cellreferences,names,

functions,oroperators inacell that togetherproduceanewvalue.A formulaalwaysbeginswithan

equalsign(=).)orlargeamountoftextinacell,youcanadjustthesizeoftheformulaboxintheformula

bar(formulabar:AbaratthetopoftheExcelwindowthatyouusetoenteroreditvaluesorformulasin

cellsorcharts.Displaystheconstantvalueorformulastored intheactivecell.).Toaccommodate long

names(name:Awordorstringofcharacters inExcelthatrepresentsacell,rangeofcells,formula,or

constantvalue.),youcanalsoresizethenamebox(Namebox:Boxat leftendoftheformulabarthat

identifiestheselectedcell,chartitem,ordrawingobject.Tonameacellorrange,typethenameinthe


38/62


NameboxandpressENTER.Tomovetoandselectanamedcell,clickitsnameintheNamebox.)inthe

formulabar.

Theworksheetandformulabarworkintandemsothatcontentsofbothdonotoverlap.

1. Adjustthewidthofthenameboxleftorright.

2.

Adjustthe

height

of

the

formula

box

up

or

down.

Resizetheformulabox

Dooneormoreofthefollowing:

Toswitchbetweenexpandingtheformulaboxtothreeormorelinesorcollapsingittoone

line,clickthechevronbutton attheendoftheformulabar.Youcanalsopress

CTRL+SHIFT+U.

Topreciselyadjusttheheightoftheformulabox,hoveroverthebottomoftheformulabox

untilthe

pointer

changes

to

avertical

double

arrow

,drag

the

vertical

double

arrow

up

or

downtowhereyouwantit,andtheneitherclicktheverticaldoublearroworpressENTER.

Toautomaticallyfittheformulaboxtothenumberoflinesoftextintheactivecelluptothe

maximumheight,hoverovertheformulaboxuntilthepointerchangestoaverticaldouble

arrow ,andthendoubleclicktheverticaldoublearrow.

Notes

Youcanresizetheformulaboxtoamaximumsizesothatonlyoneworksheetrowisvisible.

Whenyouresizetheformulabox,theactivecellalwaysstaysvisibleontheworksheet.

Ascroll

bar

in

the

formula

box

means

that

there

is

more

text

to

view.

To

activate

the

scroll

bars,clickthecellortheformulabox.

Bydefault,whenyouentertextinacell,itisonelineoftextwithnolinebreaks,butthetext

wrapswhendisplayed inthe formulabar. Ifyoumanually inserta linebreak inthecellby

pressingALT+ENTER,thelinebreakalsodisplaysintheformulabar.


39/62


Resizethenamebox

Toadjustthewidthofthenameboxeithersmallerorlarger,hoverbetweenthenamebox

andthe formulaboxuntilthepointerchangestoahorizontaldoublearrow ,dragthe

horizontaldouble

arrow

left

or

right

to

where

you

want

it,

and

then

either

click

the

horizontaldoublearroworpressENTER.

Note Themaximumwidthofthenameboxishalfofthewidthoftheworksheet.

DuplicateEntries

Filterforuniquevaluesorremoveduplicatevalues

Filtering for unique values and removing duplicate values are two closely related tasks because the

displayedresultsarethesamea listofuniquevalues.Thedifference,however, is important:When

you filter for unique values, you temporarily hide duplicate values, butwhen you remove duplicate

values,you

permanently

delete

duplicate

values.

Aduplicatevalueisonewhereallvaluesintherowareanexactmatchofallthevaluesinanotherrow.

Duplicatevaluesaredeterminedbythevaluedisplayedinthecellandnotnecessarilythevaluestored

inthecell.Forexample,ifyouhavethesamedatevalueindifferentcells,oneformattedas"3/8/2006"

andtheotheras"Mar8,2006",thevaluesareunique.

It'sagoodideatofilterforuniquevaluesfirsttoconfirmthattheresultsarewhatyouwantbefore

removingduplicatevalues.

Filterforuniquevalues

1.

Selectthe

range

of

cells,

or

make

sure

the

active

cell

is

in

atable.

2. OntheDatatab,intheSort&Filtergroup,clickAdvanced.

3. IntheAdvancedFilterdialogbox,dooneofthefollowing:

1.

Tofilter

the

range

of

cells

or

table

in

place,

click

Filter

the

list,

in

place.

2. Tocopytheresultsofthefiltertoanotherlocation,dothefollowing:

1.

ClickCopytoanotherlocation.

2. IntheCopytobox,enteracellreference.


40/62


Alternatively,clickCollapseDialog totemporarilyhidethedialogbox,selectacellontheworksheet,

andthenpressExpandDialog .

4.

Select

the

Unique

records

only

check

box,

and

click

OK.

Theuniquevaluesfromtheselectedrangearecopiedtothenewlocation.

Removeduplicatevalues

Whenyouremoveduplicatevalues,onlythevaluesintherangeofcellsortableareaffected.Anyother

valuesoutsidetherangeofcellsortablearenotalteredormoved.

Caution Becauseyouarepermanentlydeletingdata,it'sagoodideatocopytheoriginalrangeofcells

ortabletoanotherworksheetorworkbookbeforeremovingduplicatevalues.

1.

Selecttherangeofcells,ormakesurethattheactivecellisinatable.

2. OntheDatatab,intheDataToolsgroup,clickRemoveDuplicates.

3. Dooneormoreofthefollowing:

UnderColumns,selectoneormorecolumns.

Toquicklyselectallcolumns,clickSelectAll.

Toquicklyclearallcolumns,clickUnselectAll.

Iftherangeofcellsortablecontainsmanycolumnsandyouwanttoonlyselectafewcolumns,youmay

finditeasiertoclickUnselectAll,andthenunderColumns,selectthosecolumns.

4. ClickOK.

Amessageisdisplayedindicatinghowmanyduplicatevalueswereremovedandhowmanyunique

values

remain,

or

if

no

duplicate

values

were

removed.

5. ClickOK.

ConnectingExceltoExternalDataSource

DatasourcesthatcanbeaccessedfromExcel


41/62


MicrosoftOfficeprovidesdriversthatyoucanusetoretrievedatafromthefollowingdatasources(data

source:Astoredsetof"source" informationusedtoconnecttoadatabase.Adatasourcecan include

thenameand locationofthedatabaseserver,thenameofthedatabasedriver,and informationthat

thedatabaseneedswhenyoulogon.):

MicrosoftSQLServerAnalysisServices (OLAPprovider(OLAPprovider:A setof software that

providesaccesstoaparticulartypeofOLAPdatabase.Thissoftwarecan includeadatasource

driverandotherclientsoftwarethatisnecessarytoconnecttoadatabase.))

MicrosoftOfficeAccess

dBASE

MicrosoftFoxPro

MicrosoftOfficeExcel

Oracle

Paradox

Textfile

databases

You can also useODBC drivers(Open Database Connectivity (ODBC) driver: A program file used to

connect to a particular database. Each database program, such as Access or dBASE, or database

management system, such as SQL Server, requires a different driver.) or data source drivers(data

source driver: A program file used to connect to a specific database. Each database program or

managementsystemrequiresadifferentdriver.)fromothermanufacturerstoretrieveinformationfrom

datasources thatarenot listedhere, includingothertypesofOLAPdatabases.For informationabout

installinganODBCdriverordatasourcedriverthatisnotlistedhere,checkthedocumentationforthe

database,orcontactyourdatabasevendor.

Youcanuse theDataConnectionWizardtoconnecttoanexternaldatasourcethathasalreadybeen

defined.Toopen theDataConnectionWizard,on theData tab, in theGetExternalDatagroup,click

FromOtherSources,andthenclickFromDataConnectionWizard.

TogetDataConnections

1. GottotheDataTabandusetheGetExternalDataandConnectionsgroup

2.

IntheConnectionsgroupclickonConnectionstoopentheWorkbookConnectionsdialogbox

Forexample


42/62


1.

GotoData

2.

ClickonFromAccessintheGetExternalDatagroup

3.

SelectthetablefromtheSelectTabledialogbox,ClickOK

4. WorkwiththeappropriateoptionsintheImportDatadialogbox


43/62


44/62


45/62


Matte Nospecularhighlights,whichresultsinafairly"flat"look.

WarmMatte Somespecularhighlights,whichgivethesurfaceoftheshapeasofterlookthanplastic.

Plastic

Crisp,

white

specular

highlights

that

give

a

shiny,

plastic

appearance

to

the

surface

of

the

shape.

Metal Specularhighlightsmatchsomeofthematerial'sbasecolorsothatthelookoftheshapeisshiny

andhighlyreflective.

SpecialEffect

DarkEdge Similartoplasticbecausewhitespecularhighlightsgiveashinyappearancetothesurface

appearanceoftheshape,butwithdarkedgesthatmorecrisplydefinetheshapeagainstalight

background.

SoftEdgeWhitespecularhighlightswithedgesthatbecomeslightlytransparent,makingtheshapelook

veryintegratedintoasceneorgroupofshapes.Whenthislookisappliedtothesurfaceofashape,the

edgesoftheshapeappeartoreflectsomeofthebackgroundcolor.

Flat Solidcolorwithwhitespecularhighlights.Shadingbasedonthelightdirectionorintensityisnot

done,sothespecularhighlightsdefinetheshape.Thisoptionisdesignedspecificallytoworkwellwith

theFlatLightingoption.

Wireframe Specularhighlightsareappliedonlytotheshapedepth;theedgesareignored.

Translucent

PowderLarge

specular

highlights

that

give

avery

soft

pastel

look

to

the

surface

of

ashape.

TranslucentPowder SimilartoPowder,butresultsinatransparentappearancewithsoftorgradually

fadingedges.

Clear Transparentwithcrisp,whitehighlightsanddarkedgesthatresultinahard,shinyappearance,

similartoglass.

Reset Removes3Dformattingchangesthatyoumadetotheshape.


46/62


MSPowerPoint2007

DocumentInspectorMSOfficePowerPoint2007

MicrosoftPowerPoint2007cancontainthefollowingHiddendata:


CommentsandAnnotations Comments

Inkannotations


Information



Propertiesdialogbox

Emailheaders

Routingslips





FilepathforpublishingWebpages

InvisibleOnSlideContent Objectsthatarenotvisiblebecausetheyareformattedas

invisible

NOTE ThisInspectordoesnotdetectobjectsthatare

coveredbyotherobjects.

OffSlideContent Contentorobjectsthatarenotimmediatelyvisibleina

presentationbecause

they

are

located

outside

the

slide

area,including:

Clipart

Textboxes

Graphics

Tables

NoteTheDocumentInspectordoesnotdetectorremove

offslideobjectswithanimationeffects.

PresentationNotes TextthatwasaddedtotheNotessectionofapresentation

NoteTheDocumentInspectorcannotremovepictures

thatareaddedtotheNotessectionofapresentation.

SmartArtToCreateaSmartArtgraphic

1.

OntheInserttab,intheIllustrationsgroup,clickSmartArt.


47/62


2. IntheChooseaSmartArtGraphicdialogbox,clickthetypeandlayoutthatyouwant.

3.

Enteryourtextbydoingoneofthefollowing:

ClickinashapeinyourSmartArtgraphic,andthentypeyourtext.

Click[Text]intheTextpane,andthentypeorpasteyourtext.

Copytextfromanotherprogram,click[Text],andthenpasteintotheTextpane.

FromtheChooseaSmartArtGraphicdialogboxyoucanpickuptheGraphicthatyouwanttoandwork

accordingly


48/62


49/62


ThemesandStyles

Applyabuilt-inthemetoaslidemaster

When you apply a theme(theme: A set of unified design elements that provides a look for your

documentby

using

color,

fonts,

and

graphics.)

to

aslide

master

(slide

master:

The

slide

that

stores

information about thedesign templateapplied, including font styles,placeholder sizesandpositions,

background design, and color schemes.), the theme is also applied to all layouts(layout: The

arrangementofelements,suchastitleandsubtitletext,lists,pictures,tables,charts,AutoShapes,and

movies,onaslide.)associatedwiththatslidemaster.

1. OntheViewtab,inthePresentationViewsgroup,clickSlideMaster.

2. OntheSlideMastertab,intheEditThemegroup,clickthearrowbelowThemes,andthenclick

atheme.

ABrief

on

Styles

QuickStylesarecombinationsofdifferentformattingoptionsandaredisplayedinathumbnailinthe

variousQuickStylegalleries.WhenyouplaceyourpointeroveraQuickStylethumbnail,youcansee

howtheQuickStyleaffectsyourSmartArtgraphicorshape.

QuickStylesforSmartArtgraphics(SmartArtStyles) includeedges,shadows, linestyles,gradients,and

threedimensional(3D)perspectives.TrydifferentcombinationsofSmartArtStylesandcolorsuntilyou

findonethatmatchesthemessagethatyouwanttocommunicate.Youcanpicka layout,aSmartArt

Style,andacolorvariationthatyou like,andthenchangethe layoutagainyourSmartArtStyleand

colorswillstaywithyourSmartArtgraphic,sothatyoudonotneedtoredothem.

EnhancedSlideDesign

AutoContentWizard

TheAutoContentWizard isnotavailable inMicrosoftOfficePowerPoint2007. Instead,youcancreate

yourpresentationquicklyandeasilybyusing templates(template:A fileor setof files that contains

informationaboutthetheme,layout,andotherelementsofafinishedpresentation.).OfficePowerPoint

2007

templates

include

different

themes

and

layouts,

including

most

of

those

that

existed

in

the

AutoContent Wizard. Templates give you a starting point and make it easier to complete your

presentationquickly.Youcanmodifyatemplate'stextanddesign,addacompany logo,addyourown

images,ordeletetextorothercontentfromthetemplate.


50/62


TitleMaster

Thetitlemaster(titlemaster:Theslidethatstores informationfromthedesigntemplatepertainingto

stylesontitleslides,includingplaceholdersizesandpositions,backgrounddesign,andcolorschemes.)is

notavailableinMicrosoftOfficePowerPoint2007.Instead,OfficePowerPoint2007useslayouts(layout:

Thearrangement

of

elements,

such

as

title

and

subtitle

text,

lists,

pictures,

tables,

charts,

shapes,

and

movies,onaslide.)todefinecontentformattingandpositioningforslides inyourpresentation.Ifyou

donotfindastandardlayoutthatsuitsyourneeds,youcanaddanewlayout.

ToAddaSlideMaster

1.

OntheViewtab,inthePresentationViewsgroup,clickSlideMaster.

2. OntheSlideMastertab,intheEditMastergroup,clickInsertSlideMaster.

3. Dooneorbothofthefollowing:

Ifyou

want

to

remove

an

unwanted,

default

placeholder

,click

the

border

of

the

placeholder,andthenpressDELETE.

Ifyouwanttoaddaplaceholder,dothefollowing:

1. Clickathumbnailslidelayoutbelowtheslidemasterthatyouadded.

2. OntheSlideMastertab,intheMasterLayoutgroup,clickthearrow

nexttoInsertPlaceholder,andthenclickaplaceholder.

3.

Clickalocationontheslidemaster,andthendragtodrawthe

placeholder.

Tip Toresizeaplaceholder,dragoneofitscornerborders.

4. ClicktheMicrosoftOfficeButton ,clickSaveAs.

5. IntheFilenamebox,typeafilename,ordonothingtoacceptthesuggestedfilename.

6. IntheSaveastypelist,clickPowerPointTemplates,andthenclickSave.


51/62


MicrosoftOutlook2007

In Microsoft Office Outlook 2007, categories have colors associated with them and are renamed

accordinglyascolorcategories(colorcategory:Akeywordorphrasewithanassociatedcolorthathelps

youkeeptrackofitems,suchasmessages,contacts,andappointments.Youcanusecolorcategoriesto

easily find, sort, filter,or group items.).By associating colorswith categorized items andplacing the

colorsprominentlyinopenitems,suchascontacts,andintable(table:Aviewtypethatdisplaysalistof

items (rows)and theirattributes (columns).Use thisview todisplaydetailsabout items.Table is the

default view type for Inbox and Tasks.) views, such as your Inbox, you can easily identify and track

categorizeditems.

WhenyouupgradetoOfficeOutlook2007fromanearlierversionofOutlook,yourcategoriesand

categorizeditemsarestillavailable.Calendarlabelsarereplacedwithcolorcategories.

WhathappenstomyexistingcategoriesafterIupgradetoOfficeOutlook2007?

CategoriesfromearlierversionsofOutlookstillworkthesameway.Forexample,youcanstill

groupand searchamongcategorized items. InOfficeOutlook2007, theCategories column is

morevisible,andyoucaneasilysortcategorizeditems.

Calendar labels fromearlierversionsare replacedby color categories inOfficeOutlook2007.

Thecolorcategoriesprovidethesamefunctionsascalendarlabels.Thecalendaritemsthatare

associatedwith

the

calendar

labels

get

the

same

color

or

the

closest

color

match

in

Office

Outlook2007.

ThenewCategorizemenu inOfficeOutlook2007displayssixnewdefaultcolorcategories,

whicharenamedfortheircolors,suchasRedCategory.Themenualsodisplaysthecategories

thatareassignedtocontactsandnotes,orcalendarlabelsassignedinearlierOutlookversions.

Themenudisplaysupto15colorcategoriesatatime.Toseethecompletelistofavailablecolor

categories,which includes thenewdefault color categories,allyourprevious categories,and

theprevious calendar labels (now replacedwith color categories), clickAllCategorieson the

menu.

As a precaution against unintentionally adding categories received from others to recipient

category lists, color categories thatwere assignedonly toemail items arenot automatically

addedtotheOfficeOutlook2007list.

CategoriesthatareassignedbothinOfficeOutlook2007and inearlierversionsofOutlookare

visible inopen items,suchasmessageheaders,opencontacts,andopencalendar items.You


52/62


53/62


distinguishitfromitemsthatarecategorizedinOfficeOutlook2007,whichhaveasmallercolor

blockwithroundedcorners.

Ifyouassigna colorcategory toa contactorCalendar item inOfficeOutlook2007and then

open the item in an earlier version, you see thenameof the assigned color category at the

bottomoftheopen item, intheCategoriesbox.Forthecalendar item,youalsoseethecolor

associatedwiththecolorcategoryintheCalendarLabelbox.ThecoloristhesameasinOffice

Outlook2007ortheclosestmatchavailable.

IfyouassignacolorcategorytoanoteinOfficeOutlook2007andthenviewthenoteinan

earlierversionofOutlook,ithasthesamecolorortheclosestmatchavailable.

ColorsandShortcuttoCategories

ChooseaColortoyourCategory

When you assign an existing color category(color category:A keywordorphrasewith an associated

color thathelpsyoukeep trackof items,suchasmessages,contacts,andappointments.Youcanuse

colorcategoriestoeasilyfind,sort,filter,orgroupitems.)toanitem,acolorisautomaticallyassociated

withthatitem.Youcanchangethecolorforanycategoryandrenameanycategory.Youcanalsocreate

newcategoriesandcolors.Ifyoulaterchangeyourmindandchangethecolorassociatedwithanycolor

category,alloftheitemsthathavethatcategoryassignedareupdatedtothenewcolor.


54/62


AssignakeyboardshortcuttoaColorCategory

Byassociatingakeyboardshortcutwithacolorcategory(colorcategory:Akeywordorphrasewithan

associatedcolorthathelpsyoukeeptrackofitems,suchasmessages,contacts,andappointments.You

canuse

color

categories

to

easily

find,

sort,

filter,

or

group

items.),

you

can

quickly

assign

the

color

category to an item, such as an email message, by selecting the item in your Inbox or another

table(table:Aviewtypethatdisplaysalistofitems(rows)andtheirattributes(columns).Usethisview

to display details about items. Table is the default view type for Inbox and Tasks.) view and then

pressing thekeyboard shortcut.Youcanalsouse thekeyboard shortcut toassignacolorcategory to

multipleitemsatthesametime.

1. OnthetoolbarofthemainMicrosoftOfficeOutlook2007window,clickCategorize .

2. Atthebottomofthemenu,clickAllCategories.

3.

IntheNamelist,selectthecheckboxforacolorcategory.

4. IntheShortcutKeylist,chooseakeyboardshortcut.


55/62


AboutCalendars

Viewcalendarsside-by-sideoroverlaid

InMicrosoftOfficeOutlook2007,youcanviewmultiplecalendarsatonce.Thesecanbeyourcalendars,

sharedcalendarsfromotherpeople,InternetCalendars,orInternetCalendarSubscriptions.

Viewingmultiplecalendars

Youcanopenasecondcalendarinanewwindowanddisplayupto30calendarsinsideby

sideview.

Youcanalsooverlaycalendarstoseetransparentcalendarsstackedontopofeachother,

whenyouwanttofindacommonfreetimeslotonseveraldifferentcalendars.

InCalendar,theNavigationPane(NavigationPane:Thecolumnonthe leftsideoftheOutlookwindow

that

includes

panes

such

as

Shortcuts

or

Mail

and

the

shortcuts

or

folders

within

each

pane.

Click

a

folder to show the items in the folder.) shows a listof your calendarsunderMyCalendars.This list

includesyourdefaultprimarycalendarinOutlookthatdisplaysyourfree/busytimetootherpeople,and

wheremeetingrequeststhatyouacceptedaresaved.


56/62


Othercalendars,or secondarycalendars,can include calendars thatyou created to trackaproject,a

personalschedule,orsomeothercalendareventthatyoudonotwanttomixwiththe itemsonyour

defaultcalendar.

NoteWhen

you

share

your

default

calendar,

appointments

on

secondary

calendars

are

not

displayed

tootherpeopleanddonotaffectyourfree/busyavailability.

Openacalendarinanewwindow

1.

InCalendar,intheNavigationPane,rightclickthenameofanothercalendarthatyouwantto

view.

2.

ClickOpeninNewWindow.

ThecalendarthatyouselectedopensinanewOutlookwindow.

Open

a

calendar

in

side

by

side

view

InCalendar,intheNavigationPane,selectthecheckboxofanothercalendarthatyouwantto

view.

Thecalendarthatyouselectedopensnexttothecalendarthatisalreadydisplayed.

Note Atleastonecalendarmustalwaysbedisplayed.

Overlaythe

calendars

1. InCalendar,intheNavigationPane,selectthecheckboxofanothercalendarthatyouwantto

view.

Thecalendarthatyouselectedopensnexttocalendarthatisalreadydisplayed.


57/62


2.

Repeatstep1foreachcalendarthatyouwanttoview.

3. OntheCalendartab ,click .

Thecalendars

are

now

in

overlay

mode.

Toaddanothercalendartotheoverlay,repeatthisstep.

Removeacalendarfromtheoverlaystack

1. InCalendar,onthetabofthecalendar thatyouwantto

removefromtheoverlaystack,click .

Thetabmovesbacktotheright.Thecalendarthatyouselectedisnolongerdisplayedinoverlaymode.

2.

Repeatstep1foreachcalendarthatyouwanttoremovefromthestack.

PublishandShareCalendar

PublishacalendartoOfficeOnline

1.

InCalendar,intheNavigationPane,rightclickthecalendaryouwanttopublish.

Note IfyouareusingtheNavigationPaneinMinimizedview,intheNavigationPane,click

,clickNavigationPane,andthenrightclickthecalendaryouwanttopublish.

Tip IfyouwanttopublishyourdefaultCalendar,clickPublishMyCalendarintheNavigationPane,and

thenproceedwithstep3.


58/62


2.

Ontheshortcutmenu,clickPublishtoOfficeOnline.

3. IfthisisthefirsttimeyouhavepublishedacalendartoOfficeOnline,youmustregisterfor

OfficeOnlinebyusingyourWindowsLiveIDaccount.IfyoudonothaveafreeWindowsLiveID

account,you

can

create

one.

Follow

the

instructions

on

your

screen.

4. NexttoTimeSpan,selectthenumberofdaysforwhichyouwanttoshareyourcalendar.

5. NexttoDetail,clickthearrowandchoosetheamountofdetailtoshare.Ifyouwant,selectthe

Showtimewithinmyworkinghoursonlycheckboxtorestrictshareddetailstoonlythosefor

yourspecified

working

hours

in

Microsoft

Office

Outlook

2007.

6. NexttoPermissions,choosewhetheryourcalendarinformationcanbeviewedonlybyspecified

people,orbyanyone.


59/62


RestrictedAccess:Onlyusersthatyouinvitecanviewyourcalendar Ifyouclickthis

option,anOutlooksharingemailmessageopensafterthecalendarispublishedto

OfficeOnline.Youcansendthemessagetotheemailaddressofeachpersontowhom

youwanttograntaccesstoyourcalendar.Thesharingmessageincludesalinktothe

calendar,aswellasanymessagethatyouwanttoinclude.

UnrestrictedAccess:Anyonecanviewyourcalendar Ifyouclickthisoption,anyone

whoknowsthelinktoyourcalendarcanviewit.PeopledonothavetouseaWindows

LiveIDaccounttologonorsignintoanyservice.

7.

NexttoUploadMethod.choosewhetheryouwantupdatesyoumaketoyourOutlookcalendar

toautomaticallybeupdatedonOfficeOnline.

8. Ifyouwanttoconfigureoptions,suchaswhetherdetailsforprivateitemsareincluded,nextto

Advanced,clickShow,andtheselectthecheckboxforanyoptionyouwanttoturnon.

9. ClickOK.

AfteryourcalendarissuccessfullysharedonOfficeOnline,youcaninvitepeopletoviewandsubscribe

tothecalendar.Toletothersknowaboutyourpublishedcalendar,whenpromptedtosendasharing

invitation,clickYes.

Note IfyouclickedUnrestrictedAccess:Anyonecanviewyourcalendar,anyonewhoknowsthelink

toyourpublishedcalendarcanvieworsubscribetoit.AWindowsLiveIDaccountisnotrequiredto

vieworsusbscribetothecalendar.

Aftersharingacalendar,thecalendariconintheNavigationPanechangesasshownbelow.

TaskandCalendarintegration

ViewyourtasksintheDailyTaskListinCalendar


60/62


TheDailyTaskListappearsonlyintheDayandWeekviewsinyourOutlookCalendar.TotoggletheDaily

TaskListonoroff,inCalendar,clickView,pointtoDailyTaskList,andthenclickNormalorOff.

Todisplayonlythenumberofcurrenttasks,inCalendar,clickView,pointtoDailyTaskList,andthen

clickMinimized

or,

alternately,

click

the

top

edge

of

the

Daily

Task

List

when

your

pointer

becomes

a

,andthendragupordown.

Tip TocreatenewtasksintheDailyTaskList,youmustusetheNormalDailyTaskListsetting.

To-Do-List

Abouttasksandtodoitems


61/62


62/62