book

2007 Microsoft® Office System Inside Out

Name: 2007 Microsoft® Office System Inside Out
Author: Microsoft Corporation
ISBN: 9780735623248

by Microsoft Corporation

March 2007

Beginner

1312 pages

40h 32m

English

Microsoft Press

Read now

Unlock full access

2007 Microsoft® Office System Inside Out
SPECIAL OFFER: Upgrade this ebook with O’Reilly
A Note Regarding Supplemental Files
Acknowledgments
About the CD
What’s on the CD
Using the CD
System Requirements
Support Information
Conventions and Features Used in This Book
Text Conventions
Design Conventions

1. Introduction
Who This Book Is For
How This Book Is Organized
1. Getting Started
1. Overview of the 2007 Microsoft Office System
The New World of WorkCollaboration Workspaces and ToolsBusiness Intelligence on Your Desktop
The New Microsoft Office User Interface
The RibbonGalleries and Live Preview
The New Microsoft Office XML File Formats
What Else Is New?
Microsoft Office Word 2007Microsoft Office Excel 2007Microsoft Office PowerPoint 2007Microsoft Office Outlook 2007Microsoft Office Access 20072007 Office System ServersForms ServerGroove ServerProject ServerTemplates and Assistance from Microsoft Office Online
2. The 2007 Office System User Interface: What’s Changed, What’s the Same
A Quick Tour and Comparison
The Ribbon and Command Tabs
Customizing the Quick Access Toolbar
The Microsoft Office Button and Menu
Working in Context: More Tabs, Plus Some Menus and Toolbars
Contextual TabsShortcut Menus and the Mini Toolbar
Galleries and Live Preview
Getting Help
Searching Online Help
3. Managing Security and Privacy in the 2007 Office System
Working in the Trust CenterDigital Signatures and Trusted PublishersUsing Trusted LocationsSetting Security Options for Macros and Add-InsSecurity Settings for ActiveX Controls
Setting Your Privacy Options
Removing Hidden Data and Personal Information from Microsoft Office Documents
Applying Information Rights Management
Configuring Your Computer to Use Information Rights ManagementRestricting Permissions
Assigning a Password to a Document
Changing a PasswordRemoving a Password
Avoiding Phishing Schemes
2. Collaboration Essentials
4. Collaborating and Sharing with Others
Understanding and Using the 2007 Office System Collaboration Environments
Creating and Using Shared Workspaces with Windows SharePoint Services
Understanding the WorkspaceLibrariesLists and Other Communication ToolsAccessing or Adding Content in a SharePoint Document LibraryAdding Content to a Library or ListCreating or Editing a Windows SharePoint Services Shared WorkspaceAdding Sites, Pages, or ListsUnderstanding and Using Web PartsManaging Site Settings and Permissions
Creating and Using Groove Workspaces
Understanding Your WorkspaceManaging Files in a WorkspaceCreating a WorkspaceAdding Tools to Your WorkspaceInviting Others to Join a WorkspaceSetting Roles and Permissions
Using Office OneNote 2007 as a Collaboration Tool
Shared Notebooks and Live Sharing SessionsCreating a Live Sharing SessionCreating a Shared Notebook
5. Organizing and Finding Information in Microsoft Office OneNote
Organizing a OneNote NotebookCreating a NotebookWorking in the OneNote WindowOrganizing Notebook SectionsAdding and Grouping Notebook Pages
Adding Notes and Information to a Notebook
Adding and Working with Text NotesTagging Types of NotesPrinting to OneNoteEmbedding References to FilesUsing Office OneNote and Office Outlook TogetherInserting Audio or Video RecordingsAdding Information to a Notebook from the WebCapturing Information on Your Windows Mobile–Powered DeviceInserting an Image in a NotebookCreating a Drawing in OneNoteCreating and Working with Tables in OneNote
Finding Your Information
Using a Notebook on More Than One Computer
Creating a Notebook for Use on More Than One ComputerShare an Existing Notebook Among Your Computers
Working as a Team with Office OneNote 2007
Working with a Shared NotebookProtecting a Shared SectionSharing an Existing NotebookSharing a Notebook in a Live SessionSharing Notes Using E-Mail
6. Working as a Team in a Microsoft Office Groove Workspace
Getting Started with Groove
Setting Up a Groove Account
The View from the Launchbar
Groove Workspace Basics
Creating a WorkspaceInviting Workspace Members and Assigning Member RolesUsing Your Groove Account on a Second ComputerKnowing When Members Are Present and Accounted ForChatting with Workspace MembersSetting Roles and Changing Role PermissionsExploring a Groove Workspace
Outfitting a Groove Workspace with Tools
Keeping a CalendarTopics Under DiscussionMaking Meetings More EffectiveStoring, Organizing, and Sharing FilesTracking IssuesTaking NotesAdding Pictures to a WorkspaceSketching Your Ideas
7. Sharing and Communicating Using Microsoft Office Groove
Setting Up and Using a File-Sharing WorkspaceDownloading Files in a File-Sharing Workspace
Managing Groove Communications
Using the Communications ManagerPausing CommunicationsWorking with Groove OfflineViewing and Modifying Network SettingsGroove Instant MessagingManaging Groove Messages and Message HistoryManaging Groove Alerts
Working with Groove Contacts
Managing Contacts from the LaunchbarViewing a Digital FingerprintVerifying Contact Identities
Introducing the Groove Forms Tool
Designing a FormDesigning a ViewTesting and Publishing Your Form
Managing Workspace Archives and Templates
3. Word
8. Mastering Page Setup and Pagination
Basic Page Setup Options
Changing Margins and Orientation
Changing Margin SettingsChoosing Orientation
Selecting a Paper Size and Source
Choosing a Paper SizeSelecting the Paper SourceSaving Page Setup Defaults to the Current Template
Controlling Page and Section Breaks
Adding Manual Page BreaksCreating Additional SectionsInserting Text Wrapping Breaks
Working with Varying Page Settings
Multiple Page SettingsAligning Content Vertically Between Margins
Including Headers and Footers
Adding Page NumbersCreating Headers and FootersDeleting Headers and Footers
Working with the Document Grid
Specifying Document Grid SettingsDisplaying the Drawing Grid
Adding and Controlling Line Numbers
9. Outlining Documents for Clarity and Structure
Outlining Enhancements in Word 2007
Creative Outlining with Word 2007
Eleven Reasons to Outline Your Next Complex Document
Viewing a Document in Outline View
Exploring the Outlining Tools
Creating a New Outline
Choosing Outline Display
Displaying Different Levels of TextShowing the First Line of TextRemoving and Showing Formatting
Working with Headings in Outline View
Adding a HeadingApplying Outline LevelsPromoting and Demoting Headings
Displaying Outline and Print Layout View at the Same Time
Changing Your Outline
Expanding and Collapsing the OutlineMoving Outline TopicsMoving Topics Up and DownCutting and Pasting Parts of the OutlineDragging to a New Location
Printing Your Outline
Using the Document Map vs. Using Outline View
10. Advanced Layout and Formatting
Layout and Design Fundamentals
Using Backgrounds and Watermarks
Creating Backgrounds and WatermarksAdding Backgrounds to Online PagesAdding Watermarks to DocumentsChanging and Removing Backgrounds and Watermarks
Controlling Text Placement and Formatting with Text Boxes, Shapes, and Frames
Creating Text BoxesInserting Text into Text Boxes and ShapesUsing Floating Frames for Comments, Footnotes, Tables, and FieldsFormatting Text Boxes and AutoShapesControlling Text in Text Boxes and ShapesChanging Text Box ShapesResizing Text Boxes or AutoShapes Automatically to Show All ContentLinking Text Boxes to Flow Text from One Text Box to AnotherMoving Between Linked Text BoxesCopying or Moving Linked Text BoxesBreaking Text Box LinksDeleting Linked Text Boxes Without Losing TextSwitching Between Text Boxes and Frames
Configuring Word 2007 Layout Options
Commanding Attention with Borders and Shading
Adding a Simple Border
Creating Enhanced Borders
Choosing Border OptionsSelecting Line Styles for BordersChoosing a Border ColorControlling Border Width
Creating Partial Borders
Using a Page Border
Creating a Page BorderAdding an Artistic Border
Adding Borders to Document Sections and Paragraphs
Bordering Sections
Adjusting Border Spacing
Inserting Graphical Horizontal Lines
Adding a Graphical Horizontal LineFormatting a Graphical Horizontal LineImporting a Custom Line
Adding Borders to Pictures
Using the Picture Border ToolAdding a Picture Border by Formatting the Picture
Adding Table Borders
Applying Shading Behind Content
Applying Shades to Tables and ParagraphsShading Considerations
11. Revising Documents Using Markup Tools
Benefits of an Organized Revision Process
Familiarizing Yourself with Markup Tools
Using the Highlight Tool
Highlighting InformationRemoving Highlighting from DocumentsFinding Highlighted ItemsReformatting Highlighted Items with Another Highlight Color
Adding and Managing Comments Effectively
Configuring Reviewers’ User NamesConfiguring Colors Associated with ReviewersAllowing Reviewers to Use Only the Comments FeatureInserting Standard CommentsConfiguring Comment Balloon and Reviewing Pane OptionsChanging the Styles of Balloon and Reviewing Pane Text and LabelsShowing and Hiding BalloonsAdjusting Balloon Size and Location for Online ViewingReviewing CommentsDeleting CommentsPrinting CommentsSaving a Document with Comments as a Web Page
Tracking Changes
Tracking Changes While You EditAdjusting the Appearance of Tracked ChangesSpecifying How Insertions and Formatting Changes Are DisplayedTracking Moved Text and Inline ShapesShowing Revisions in TablesCustomizing the Appearance of Changed LinesAccepting and Rejecting Proposed EditsAddressing Tracked Changes One at a TimeAccepting or Rejecting All Tracked Changes at OncePrinting Documents That Contain Revisions
Comparing and Combining Documents
Comparing Two Versions of a Document (Legal Blackline)Combining Revisions from Multiple Authors
4. Excel
12. How to Work a Worksheet and a Workbook
Moving Around RegionsNavigating Regions with the KeyboardNavigating Regions with the MouseNavigating with Special Keys
Understanding Selection
Selecting with the MouseZooming to Select Large Worksheet AreasSelecting Columns, Rows, and Multiple AreasSelecting RegionsUsing the Find & Select CommandsSelecting with Go To SpecialSelecting Precedents and DependentsSelecting Row or Column Differences
Techniques for Entering Data
Making Entries in Cells and in the Formula BarEntering Simple Numeric and Text ValuesUsing Special CharactersUnderstanding the Difference Between Displayed Values and Underlying ValuesCreating Long Text ValuesUsing Text WrappingUnderstanding Numeric Text EntriesEntering SymbolsMaking Entries in RangesEditing and Undoing Entries
Managing Worksheets
Inserting and Deleting WorksheetsNaming and Renaming WorksheetsMoving and Copying Worksheets
Viewing Worksheets
Splitting Worksheets into PanesFreezing PanesZooming WorksheetsUsing Custom Views
Protecting Worksheets
Unlocking Individual CellsProtecting the WorkbookAllowing Password Access to Specific Cell RangesHiding Cells and WorksheetsUsing Passwords
Managing Multiple Workbooks
Navigating Between Open WorkbooksArranging Workbook WindowsGetting the Most Out of Your ScreenComparing Worksheets Side by Side
Opening Multiple Windows for the Same Workbook
Useful Inconsistencies of New Windows
Hiding and Protecting Workbooks
Hiding WorkbooksProtecting WorkbooksEncrypting WorkbooksSaving Workbooks or Windows as HiddenHiding Worksheets
13. Building Formulas
Formula FundamentalsUnderstanding the Precedence of OperatorsUsing Cell References in FormulasEntering Cell References by ClickingUnderstanding Relative, Absolute, and Mixed ReferencesCreating References to Other Worksheets in the Same WorkbookCreating References to Worksheets in Other WorkbooksUnderstanding Row-Column Reference StyleHow Copying Affects Cell ReferencesCopying Relative ReferencesCopying Absolute ReferencesCopying Mixed ReferencesEditing FormulasUnderstanding Reference SyntaxUsing Numeric Text in FormulasAbout Text ValuesUnderstanding Error Values
Using Functions: A Preview
Using the Sum ButtonInserting a FunctionUsing Formula AutoComplete
Working with Formulas
Naming Cells and Cell RangesUsing Names in FormulasDefining and Managing NamesEditing NamesWorkbook-Wide vs. Worksheet-Only NamesCreating Names SemiautomaticallyNaming Constants and FormulasUsing Relative References in Named FormulasCreating Three-Dimensional NamesUsing Names in FormulasCreating a List of NamesReplacing References with NamesUsing Go To with NamesGetting Explicit About IntersectionsCreating Three-Dimensional FormulasFormula-Bar FormattingUsing Structured ReferencesUnderstanding Structured Reference SyntaxUsing Operators with Column SpecifiersAbout the Special Item SpecifiersUsing Formula AutoComplete with Structured ReferencesFilling and Copying Structured References
Worksheet Calculation
Recalculating ManuallyCalculating Part of a FormulaWorking with Circular ReferencesUnderstanding the Precision of Numeric Values
Using Arrays
One-Dimensional ArraysArray Formula RulesTwo-Dimensional ArraysSingle-Cell Array FormulasUsing Array ConstantsUnderstanding Array Expansion
Linking Workbooks
Saving Linked WorkbooksOpening a Dependent WorkbookEditing LinksCopying, Cutting, and Pasting in Linked WorkbooksCopying and Pasting Between WorkbooksCutting and Pasting Between Workbooks
Creating Conditional Tests
Using the Conditional Sum and Lookup WizardsCreating Conditional Sum FormulasCreating Lookup Formulas
14. Using Functions
Using the Built-In Function Reference in Excel
Exploring the Syntax of Functions
Expressions as ArgumentsTypes of ArgumentsNumeric ValuesText ValuesLogical ValuesNamed ReferencesArraysMixed Argument Types
Inserting Functions
Inserting References and Names
Understanding Mathematical Functions
Using the SUM FunctionThe Sum ButtonUsing Selected Mathematical FunctionsThe PRODUCT and SUMPRODUCT FunctionsThe MOD FunctionThe COMBIN FunctionThe RAND and RANDBETWEEN FunctionsUsing the Rounding FunctionsThe ROUND, ROUNDDOWN, and ROUNDUP FunctionsThe EVEN and ODD FunctionsThe FLOOR and CEILING FunctionsThe INT FunctionThe TRUNC Function
Understanding Text Functions
Using Selected Text FunctionsThe TEXT FunctionThe DOLLAR FunctionThe LEN FunctionThe ASCII Functions: CHAR and CODEThe Cleanup Functions: TRIM and CLEANThe EXACT FunctionThe Case Functions: UPPER, LOWER, and PROPERUsing the Substring Text FunctionsThe FIND and SEARCH FunctionsThe RIGHT and LEFT FunctionsThe MID FunctionThe REPLACE and SUBSTITUTE FunctionsThe CONCATENATE Function
Understanding Logical Functions
Using Selected Logical FunctionsThe IF FunctionThe AND, OR, and NOT FunctionsNested IF FunctionsOther Uses for Conditional Functions
Understanding Information Functions
Using Selected Information FunctionsThe TYPE and ERROR.TYPE FunctionsThe COUNTBLANK FunctionUsing the IS Information Functions
Understanding Lookup and Reference Functions
Using Selected Lookup and Reference FunctionsThe VLOOKUP and HLOOKUP FunctionsThe LOOKUP FunctionThe ADDRESS FunctionThe CHOOSE FunctionThe MATCH FunctionThe INDEX FunctionThe INDIRECT FunctionThe ROW and COLUMN FunctionsThe ROWS and COLUMNS FunctionsThe AREAS FunctionThe TRANSPOSE Function
15. Analyzing Data with PivotTable Reports
Introducing PivotTables
Creating a PivotTable
Rearranging PivotTable Fields
Refreshing a PivotTable
Changing the Numeric Format of PivotTable Data
Choosing Report Layout Options
Formatting a PivotTable
Customizing the Display of Empty or Error CellsMerging and Centering Field LabelsHiding Outline ControlsHiding Row Labels and Column Labels
Displaying Totals and Subtotals
Customizing Subtotals
Sorting PivotTable Fields
Filtering PivotTable Fields
Changing PivotTable Calculations
Using a Different Summary FunctionApplying Multiple Summary Functions to the Same FieldUsing Custom CalculationsUsing Calculated Fields and ItemsCreating a Calculated FieldCreating a Calculated ItemDisplaying a List of Calculated Fields and Items
Grouping and Ungrouping Data
Creating Ad Hoc Item GroupingsGrouping Items in Date or Time Ranges
Displaying the Details Behind a Data Value
Creating PivotCharts
5. PowerPoint
16. Introduction to PowerPoint 2007
Command Locations
Customizing Office PowerPoint 2007
Customizing the Quick Access ToolbarSetting PowerPoint 2007 OptionsPowerPoint Options: PopularPowerPoint Options: ProofingPowerPoint Options: SavePowerPoint Options: AdvancedPowerPoint Options: Add-InsPowerPoint Options: Trust CenterPowerPoint Options: Resources
File Formats
Opening a PowerPoint 2007 Presentation in PowerPoint 97–2003Saving to PowerPoint 95 and Earlier File FormatsAbout PDF and XPS File Formats
Formatting
PowerPoint 2007 Views
Slide Masters
Themes
Saving a Document Theme
Tables
Adding a New Table to Your PresentationDrawing a Table in Your PresentationCopying a Table from Word 2007 or Excel 2007Inserting an Excel 2007 SpreadsheetA Word About Table Styles
Custom Slide Layouts
Creating a Custom Slide Layout
PowerPoint 2007 Slide Libraries
Program Recovery
17. Working with Text
Adding a Text Box to a Slide
Finding and Replacing Words or Phrases
Creating and Saving Customized Theme Fonts
Formatting with WordArt
WordArt StylesAdding WordArt Style to Text
Adding Punch to Your Bulleted Lists
Writing on Slides During a Presentation
Using Headers and Footers
Working with Proofing Tools
18. Working with Objects, Diagrams, and Charts in PowerPoint 2007
Working with PicturesAdjust Your PicturesAdding a Picture StyleArrange PicturesSize
Adding Clip Art
Using SmartArt
Creating a SmartArt Graphic from ScratchAdding a SmartArt Style to Your GraphicAdding Pictures to a SmartArt GraphicUsing Picture Placeholders in a ShapeCustomizing Your SmartArt Graphic
Adding Sounds
Including Movies
Playing with Animations
Animating SmartArt Graphics
Creating Charts and Diagrams
Saving a Chart TemplateChart Formatting Options
19. Collaborating and Sharing
Using Templates
Working with Windows SharePoint Services
Reviewing, Approving, and Tracking Changes
Adding CommentsEditing and Deleting Comments
Protecting Your Document
Securing Your Presentation
Using the Document Inspector
20. Working with External Data in PowerPoint 2007
Working with Earlier Versions of PowerPoint
Working with Excel 2007
Create a New Excel 2007 Table in PowerPoint 2007Add an Existing Excel Table from Excel 2007
Working with Access 2007
Add an Existing Table, Form, Report, or Other Object from Access 2007Use a Screen Capture to Copy Content from Access 2007
Blocking and Unblocking External Content
Using Trusted Locations
Create a Trusted LocationRemove a Trusted LocationModify a Trusted Location
Setting Up Security Alerts and Trusted Publishers
21. Setting Up and Presenting a Slide Show
Learning the BasicsKeep Your Viewers on TrackCopyright Your WorkSecure Your Document When It’s CompleteVerify Your Slide Show Before Delivery
Creating Custom Slide Shows
Create a Basic Custom ShowCreate a Hyperlinked Custom ShowRun a Custom Show
Adding Transitions
Using Presenter View
Working with Photo Albums
Publish Your Photo Album to the Web
Exploring Printing Options
6. Outlook
22. Introducing Outlook 2007
A New InterfaceThe RibbonThe Navigation PaneThe To-Do BarOther Interface Changes
Instant Search
Calendar Changes
E-Mail Changes
Color Categories
Collaboration and Sharing Improvements
Integration with Office SharePoint ServerShared CalendarsShared Business Cards
Overview of Outlook 2007 Capabilities
MessagingExchange ServerInternet E-MailHTTP-Based E-MailFax Send and ReceiveExtensible E-Mail SupportSchedulingContact ManagementTask ManagementTracking with the Outlook JournalOrganizing Your Thoughts with Notes
How Outlook Stores Data
Personal Folders—.pst FilesOptions for Working OfflineSharing Storage Files
Understanding Messaging Protocols
SMTP/POP3IMAPMAPILDAPNNTPHTMLMIMES/MIMEMHTMLiCalendar, vCalendar, and vCard
Security Provisions in Outlook
Protection Against Web BeaconsAttachment and Virus SecurityMacro VirusesDigital SignaturesMessage EncryptionSecurity LabelsUnderstanding Outlook Service Options
Options for Starting Outlook
Normal StartupSafe Mode StartupStarting Outlook AutomaticallyAdding Outlook to the Quick Launch BarChanging the Outlook ShortcutUsing RUNAS to Change User ContextStartup SwitchesChoosing a Startup ViewCreating Shortcuts to Start New Outlook Items
23. Finding and Organizing Messages
Finding and Organizing Messages with Search FoldersUsing Search FoldersCustomizing Search FoldersCreating a New Search Folder
Flagging and Monitoring Messages and Contacts
Flagging Received and Previously Sent MessagesFlagging Outgoing MessagesViewing and Responding to Flagged MessagesFlagging Contact Items
Grouping Messages by Customizing the Folder View
Filtering a View Using Categories
Managing E-Mail Effectively
24. Securing Your System, Messages, and Identity
Configuring HTML Message Handling
Protecting Messages with Digital Signatures
Understanding Digital Certificates and SignaturesObtaining a Digital CertificateCopying a Certificate to Another ComputerBacking Up Your CertificateInstalling Your Certificate from a Backup
Signing Messages
Understanding S/MIME and Clear-Text OptionsAdding Your Digital SignatureSetting Global Security OptionsCreating and Using Security ProfilesReading Signed MessagesChanging Certificate Trust RelationshipsConfiguring CA TrustConfiguring CA Trust for Multiple ComputersViewing and Validating a Digital Signature
Encrypting Messages
Getting Ready for EncryptionSwapping CertificatesObtaining a Recipient’s Public Key from a Public CASending Encrypted MessagesReading Encrypted MessagesImporting Certificates from Outlook Express
Protecting Data with Information Rights Management
Using Microsoft’s IRM ServiceViewing IRM-Protected MessagesWorking with Multiple Accounts
25. Collaboration with Outlook and Windows SharePoint Services
Understanding Windows SharePoint Services Collaboration
Setting Up Alerts
Working with Shared Documents
Uploading a DocumentCreating a Document from the SiteWorking with Existing Documents and Version Control
Working with Shared Contacts
Viewing Contacts on a Windows SharePoint Services SiteLinking Windows SharePoint Services 2.0 Contacts Lists to OutlookCopying Contacts from Windows SharePoint Services 2.0 to OutlookCopying Contacts from Outlook to Windows SharePoint Services 2.0
Linking a Team Calendar to Outlook
Configuring Alerts in Outlook
Adding Alerts from OutlookEditing and Deleting Alerts from OutlookRules Based on Alerts
Using Outlook to Work with SharePoint Libraries and Files
Connecting a SharePoint Library to OutlookDownloading Files from a SharePoint Library to OutlookOpening Files from a SharePoint Site in OutlookEditing Files from a SharePoint Site in OutlookRemoving SharePoint Files in OutlookRemoving SharePoint Folders in OutlookUsing E-Mail to Add a File to a SharePoint Library
7. Access
26. Exploring the New Look of Access 2007
Opening Access for the First Time
Getting Started—A New Look for Access
Opening an Existing DatabaseExploring the Microsoft Office ButtonTaking Advantage of the Quick Access Toolbar
Understanding Content Security
Temporarily Enabling a Database That Is Not TrustedUnderstanding the Trust CenterEnabling Content by Defining Trusted Locations
Understanding the New Ribbon Feature
Home TabCreate TabExternal Data TabDatabase Tools Tab
Understanding the New Navigation Pane
Exploring Navigation Pane Object ViewsWorking with Custom Categories and GroupsExploring the Navigation Options Dialog BoxCreating and Modifying a Custom CategoryCreating and Modifying Groups in a Custom CategoryCreating Object Shortcuts in Custom GroupsHiding Custom Groups in a CategoryHiding and Renaming Object ShortcutsRevealing Hidden ShortcutsSorting and Selecting Views in the Navigation PaneManually Sorting Objects in the Navigation PaneSearching for Database Objects
Using the Single-Document vs. Multiple-Document Interface
Modifying Global Settings via the Access Options Dialog Box
27. Creating Your Database and Tables
Creating a New DatabaseUsing a Database Template to Create a DatabaseCreating a New Empty Database
Creating Your First Simple Table by Entering Data
Creating a Table Using a Table Template
Creating a Table in Design View
Defining Fields
Understanding Field Data TypesSetting Field PropertiesCompleting the Fields in the Companies TableDefining Simple Field Validation RulesDefining Input Masks
Defining a Primary Key
Defining a Table Validation Rule
Understanding Other Table Properties
Defining Relationships
Defining Your First RelationshipCreating a Relationship on Multiple Fields
Adding Indexes
Single-Field IndexesMultiple-Field Indexes
Setting Table Design Options
Creating a Default Template for New Databases
Printing a Table Definition
Database Limitations
28. Creating and Working with Simple Queries
Selecting Data from a Single TableSpecifying FieldsSetting Field PropertiesEntering Selection CriteriaWorking with Dates and Times in CriteriaAND vs. ORBetween, In, and LikeUsing ExpressionsCreating Text ExpressionsDefining Arithmetic ExpressionsUsing the Expression BuilderSpecifying Field NamesSorting Data
Testing Validation Rule Changes
Checking a New Field Validation RuleChecking a New Table Validation Rule
Working in Query Datasheet View
Moving Around and Using Keyboard ShortcutsWorking with SubdatasheetsChanging DataUnderstanding Record IndicatorsAdding a New RecordSelecting and Changing DataReplacing DataCopying and Pasting DataDeleting RowsWorking with HyperlinksActivating a HyperlinkInserting a New HyperlinkEditing an Existing HyperlinkSorting and Searching for DataSorting DataSearching For and Filtering DataUsing FindFiltering by SelectionUsing the Filter WindowUsing Filter By Form
29. Building a Form
Forms and Object-Oriented Programming
Starting from Scratch—A Simple Input Form
Building a New Form with Design ToolsThe Form Design Tools Contextual Ribbon TabsThe Field ListThe Property SheetBuilding a Simple Input Form for the tblCompanies TableMoving and Sizing ControlsThe Font GroupSetting Border Color, Type, Line Thickness, and Special EffectSetting Text Box PropertiesSetting Label PropertiesSetting Form PropertiesCustomizing Colors and Checking Your Design Results
Working with Quick Create Commands and the Form Wizard
Creating a Form with the Quick Create CommandsCreating the Basic Products Form with the Form WizardModifying the Products Form
Simplifying Data Input with a Form
Taking Advantage of Combo Boxes and List BoxesUsing Toggle Buttons, Check Boxes, and Option Buttons
30. Constructing a Report
Starting from Scratch—A Simple ReportBuilding the Report QueryDesigning the ReportGrouping Sorting, and Totaling InformationCompleting the Report
Using the Report Command
Using the Report Wizard
Specifying Report Wizard OptionsViewing the ResultModifying a Wizard-Created Report in Layout View
Building a Report in Layout View
Starting with a Blank ReportAdding Grouping and SortingWorking with Control LayoutsAdding Totals to RecordsApplying an AutoFormat
8. Microsoft Office Programming Primer
31. VBA Primer
When and Why to Use VBA
Introduction to the VBA Language and Code Structure
Recording MacrosHow to Read VBA CodeStatements, Procedures, Modules, and Projects
Understanding and Using the Visual Basic Editor
The Code WindowProject ExplorerThe Properties WindowSetting Up Your Workspace
Writing, Editing, and Sharing Simple Macros
Creating Modules and Starting ProceduresObjects, Properties, and MethodsObject ModelsUsing Auto ListsVariablesIntroducing Variable Data TypesDeclaring VariablesSharing Variables Throughout a ProjectDocument VariablesObject Model Member ArgumentsConstantsCollection ObjectsGrouping StatementsLoopsFor Each...Next and For...Next LoopsDo LoopsConditional StructuresOperatorsMessage Boxes and Input BoxesMessage BoxesInput BoxesRunning One Macro from AnotherSetting Macros to Conditionally Stop Executing CommandsRunning Macros and Compiling ProjectsRunning MacrosCompiling ProjectsUnderstanding ErrorsTesting Your Macros and Debugging ErrorsCreating Error HandlersTrapping Individual ErrorsGetting HelpSaving and Sharing MacrosSharing Projects
Using VBA to Save Time on Document Production and Troubleshooting
Using the Immediate Window
Introduction to Using Events
Creating UserForms (Dialog Boxes)
Designing a UserFormAutomating a UserForm
Next Steps for Working with Automation in Microsoft Office
32. Office Open XML Essentials
Chapter Assumptions
XML Basics for Reading Your Documents
Reading a Markup LanguageUnderstanding Key TermsXML Editing Options
Getting to Know the Office Open XML Formats
Breaking into Your DocumentThe Office Open XML File StructureTaking a Closer Look at Key Document PartsBuilding a Basic Word Document from ScratchCreate the Folder StructureCreate the Main Document FileCreate the Content_Types FileCreate the .rels FileCompile and Open Your New DocumentAdd More Content Types, Document Parts, and Relationships
Editing and Managing Documents Through XML
Before You Begin Editing a Document PartEditing Text and FormattingEdit Text and Settings in document.xmlAdd Formatting to Text in document.xmlEdit Custom Styles in styles.xmlEditing PicturesRemoving a Document Part
Customizing the Ribbon
The Basic Components of Ribbon CustomizationAdding a Ribbon TabAdd a Group to a Built-In Ribbon Tab
Binding Data to Content Controls
The Components of a Bound Content ControlBinding a Control to Custom XMLCreate the Custom XML FilesBinding Custom XML to Content Controls
Next Steps for Working with the Office Open XML Formats
A. Appendix: Installing and Configuring the 2007 Office System
Installing the Microsoft Office System from the CD
Changing Your 2007 Office System Setup
Changing Your Setup from Control PanelChanging Setup and Getting Updates from the Options Dialog Box
B. Index to Troubleshooting Topics
C. About the Authors
D. Choose the Right Book for You
Index
About the Author
SPECIAL OFFER: Upgrade this ebook with O’Reilly

Content preview from 2007 Microsoft® Office System Inside Out

Understanding Lookup and Reference Functions

Lookup and reference functions help you use your own worksheet tables as sources of information to be used elsewhere in formulas. You can use three primary functions to look up information stored in a list or a table or to manipulate references: LOOKUP, VLOOKUP, and HLOOKUP. Some powerful lookup and reference functions in addition to these three are available; we describe many of them in the following sections. You’ll find a list of all these functions by clicking the Lookup & Reference button on the Formulas tab on the Ribbon.

Lookup & Reference

Using Selected Lookup and Reference Functions

VLOOKUP and ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Microsoft® Office Outlook® 2007 Inside Out

Publisher Resources

ISBN: 9780735623248Catalog Page Errata

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

2007 Microsoft® Office System Inside Out

by Microsoft Corporation

Understanding Lookup and Reference Functions

Using Selected Lookup and Reference Functions

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

More than 5,000 organizations count on O’Reilly

Julian F.

Addison B.

Amir M.

Mark W.

You might also like

Microsoft® Office Outlook® 2007 Inside Out

Microsoft® Office Excel® 2007 Inside Out

Advanced Microsoft® Office Documents 2007 Edition Inside Out

Microsoft® Outlook® 2010 Inside Out

Publisher Resources