The Resource Excel 2007 for dummies quick reference, by John Walkenbach and Colin Banfield, (electronic resource)

Excel 2007 for dummies quick reference, by John Walkenbach and Colin Banfield, (electronic resource)

Label
Excel 2007 for dummies quick reference
Title
Excel 2007 for dummies quick reference
Statement of responsibility
by John Walkenbach and Colin Banfield
Creator
Contributor
Subject
Genre
Language
  • eng
  • eng
Summary
Fast answers to frequently asked questions Excel 2007 essentials at your fingertips! If you like your answers quick and your information up-to-date, look no further. With this concise, superbly organized reference, you'll quickly find just what you need to know about navigating the new interface; using the Ribbon and Quick Access toolbar; saving, protecting, and recovering workbook files; entering and editing data; creating formulas and functions, and much more
Member of
Cataloging source
MiAaPQ
http://library.link/vocab/creatorName
Walkenbach, John
Dewey number
005.54
Illustrations
illustrations
Index
index present
Language note
English
LC call number
HF5548.4.M523
LC item number
W344856 2007
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/relatedWorkOrContributorName
Banfield, Colin
Series statement
--For dummies
http://library.link/vocab/subjectName
  • Business
  • Electronic spreadsheets
Label
Excel 2007 for dummies quick reference, by John Walkenbach and Colin Banfield, (electronic resource)
Instantiates
Publication
Note
Includes index
Carrier category
online resource
Carrier category code
cr
Content category
text
Content type code
txt
Contents
  • Excel 2007 For Dummies Quick Reference; About the Authors; Dedication; Author's Acknowledgments; Contents at a Glance; Table of Contents; Part 1: Getting to Know Excel 2007; Excel Basics; Familiarizing Yourself with the Excel 2007 Window; Navigating with the Mouse and Keyboard; Introducing the Ribbon; Introducing the Quick Access Toolbar; Introducing the Office Menu; Previewing Your Formatting Live; Formatting with Themes; Soliciting Help; Part 2: Managing Workbooks; Activating a Workbook; Arranging Windows Automatically; Changing the Default File Location; Closing a Workbook
  • Comparing Two Workbooks Side by SideCreating an Empty Workbook; Creating Multiple Windows (Views) for a Workbook; Opening Nonstandard Files; Opening a Workbook; Protecting and Unprotecting a Workbook; Saving Files; Switching among Open Workbooks; Using a Workspace File; Working with Workbook Templates; Part 3: Working with Worksheets; Activating a Worksheet; Adding a New Worksheet; Changing a Worksheet's Name; Coloring a Worksheet Tab; Copying a Worksheet; Deleting a Worksheet; Freezing Row or Column Titles; Grouping and Ungrouping Worksheets; Hiding and Unhiding a Worksheet
  • Moving a WorksheetProtecting a Worksheet; Publishing Your Worksheet Data to the Web; Splitting Panes; Turning Off Gridlines; Using Full-Screen View; Zooming a Worksheet; Part 4: Entering and Editing Worksheet Data; Copying Cells and Ranges; Deleting Entire Rows and Columns; Editing the Contents of a Cell; Entering Data into a Range; Entering Dates and Times; Entering Formulas; Entering Text; Entering Values; Erasing Data in Cells and Ranges; Filling a Series; Inserting Entire Rows and Columns; Moving Cells and Ranges; Replacing the Contents of a Cell; Searching for Data to Replace
  • Selecting Cells and RangesTransposing a Range; Undoing Changes and Mistakes; Validating Data Entry; Part 5: Using Formulas and Functions; Absolute, Relative, and Mixed References; Basic Formula Essentials; Changing When Formulas Are Calculated; Converting Formulas to Values; Editing Functions in Formulas; Entering Functions in Formulas; Modifying a Range Reference Used in a Function; Referencing Cells or Ranges in Other Worksheets; Part 6: Creating and Using Names; Advantages to Naming Cells and Ranges; Applying Names to Existing Cell References; Creating Names; Deleting Names; Editing Names
  • Managing NamesNaming Constants and Formulas; Pasting Names into a Formula; Part 7: Auditing Your Work; Checking for Specific Worksheet Errors; Checking Your Spelling; Creating a Table of Names; Displaying Formulas in a Worksheet; Evaluating Parts of a Formula; Finding Specific Data; Handling Circular References; Locating Errors by Selecting Special Cells; Tracing Cell Relationships; Understanding Formula Error Values; Using Cell Comments; Using the Watch Window; Part 8: Formatting Your Data; Adding Borders to a Cell or a Range; Aligning Cell Contents; Changing the Appearance of Cell Contents
  • Copying Formats
Dimensions
unknown
Extent
1 online resource (242 p.)
Form of item
online
Isbn
9781280740398
Media category
computer
Media type code
c
Specific material designation
remote
System control number
  • (CKB)1000000000356878
  • (EBL)284499
  • (OCoLC)123908516
  • (SSID)ssj0000151682
  • (PQKBManifestationID)11153275
  • (PQKBTitleCode)TC0000151682
  • (PQKBWorkID)10317509
  • (PQKB)11100165
  • (MiAaPQ)EBC284499
  • (EXLCZ)991000000000356878
Label
Excel 2007 for dummies quick reference, by John Walkenbach and Colin Banfield, (electronic resource)
Publication
Note
Includes index
Carrier category
online resource
Carrier category code
cr
Content category
text
Content type code
txt
Contents
  • Excel 2007 For Dummies Quick Reference; About the Authors; Dedication; Author's Acknowledgments; Contents at a Glance; Table of Contents; Part 1: Getting to Know Excel 2007; Excel Basics; Familiarizing Yourself with the Excel 2007 Window; Navigating with the Mouse and Keyboard; Introducing the Ribbon; Introducing the Quick Access Toolbar; Introducing the Office Menu; Previewing Your Formatting Live; Formatting with Themes; Soliciting Help; Part 2: Managing Workbooks; Activating a Workbook; Arranging Windows Automatically; Changing the Default File Location; Closing a Workbook
  • Comparing Two Workbooks Side by SideCreating an Empty Workbook; Creating Multiple Windows (Views) for a Workbook; Opening Nonstandard Files; Opening a Workbook; Protecting and Unprotecting a Workbook; Saving Files; Switching among Open Workbooks; Using a Workspace File; Working with Workbook Templates; Part 3: Working with Worksheets; Activating a Worksheet; Adding a New Worksheet; Changing a Worksheet's Name; Coloring a Worksheet Tab; Copying a Worksheet; Deleting a Worksheet; Freezing Row or Column Titles; Grouping and Ungrouping Worksheets; Hiding and Unhiding a Worksheet
  • Moving a WorksheetProtecting a Worksheet; Publishing Your Worksheet Data to the Web; Splitting Panes; Turning Off Gridlines; Using Full-Screen View; Zooming a Worksheet; Part 4: Entering and Editing Worksheet Data; Copying Cells and Ranges; Deleting Entire Rows and Columns; Editing the Contents of a Cell; Entering Data into a Range; Entering Dates and Times; Entering Formulas; Entering Text; Entering Values; Erasing Data in Cells and Ranges; Filling a Series; Inserting Entire Rows and Columns; Moving Cells and Ranges; Replacing the Contents of a Cell; Searching for Data to Replace
  • Selecting Cells and RangesTransposing a Range; Undoing Changes and Mistakes; Validating Data Entry; Part 5: Using Formulas and Functions; Absolute, Relative, and Mixed References; Basic Formula Essentials; Changing When Formulas Are Calculated; Converting Formulas to Values; Editing Functions in Formulas; Entering Functions in Formulas; Modifying a Range Reference Used in a Function; Referencing Cells or Ranges in Other Worksheets; Part 6: Creating and Using Names; Advantages to Naming Cells and Ranges; Applying Names to Existing Cell References; Creating Names; Deleting Names; Editing Names
  • Managing NamesNaming Constants and Formulas; Pasting Names into a Formula; Part 7: Auditing Your Work; Checking for Specific Worksheet Errors; Checking Your Spelling; Creating a Table of Names; Displaying Formulas in a Worksheet; Evaluating Parts of a Formula; Finding Specific Data; Handling Circular References; Locating Errors by Selecting Special Cells; Tracing Cell Relationships; Understanding Formula Error Values; Using Cell Comments; Using the Watch Window; Part 8: Formatting Your Data; Adding Borders to a Cell or a Range; Aligning Cell Contents; Changing the Appearance of Cell Contents
  • Copying Formats
Dimensions
unknown
Extent
1 online resource (242 p.)
Form of item
online
Isbn
9781280740398
Media category
computer
Media type code
c
Specific material designation
remote
System control number
  • (CKB)1000000000356878
  • (EBL)284499
  • (OCoLC)123908516
  • (SSID)ssj0000151682
  • (PQKBManifestationID)11153275
  • (PQKBTitleCode)TC0000151682
  • (PQKBWorkID)10317509
  • (PQKB)11100165
  • (MiAaPQ)EBC284499
  • (EXLCZ)991000000000356878

Library Locations

  • Albert D. Cohen Management LibraryBorrow it
    181 Freedman Crescent, Winnipeg, MB, R3T 5V4, CA
    49.807878 -97.129961
  • Architecture/Fine Arts LibraryBorrow it
    84 Curry Place, Winnipeg, MB, CA
    49.807716 -97.136226
  • Archives and Special CollectionsBorrow it
    25 Chancellors Circle (Elizabeth Dafoe Library), Room 330, Winnipeg, MB, R3T 2N2, CA
    49.809961 -97.131878
  • Bibliothèque Alfred-Monnin (Université de Saint-Boniface)Borrow it
    200, avenue de la Cathédrale, Local 2110, Winnipeg, MB, R2H 0H7, CA
    49.888861 -97.119735
  • Bill Larson Library (Grace Hospital)Borrow it
    300 Booth Drive, G-227, Winnipeg, MB, R3J 3M7, CA
    49.882400 -97.276436
  • Carolyn Sifton - Helene Fuld Library (St. Boniface General Hospital)Borrow it
    409 Tache Avenue, Winnipeg, MB, R2H 2A6, CA
    49.883388 -97.126050
  • Concordia Hospital LibraryBorrow it
    1095 Concordia Avenue, Winnipeg, MB, R2K 3S8, CA
    49.913252 -97.064683
  • Donald W. Craik Engineering LibraryBorrow it
    75B Chancellors Circle (Engineering Building E3), Room 361, Winnipeg, MB, R3T 2N2, CA
    49.809053 -97.133292
  • E.K. Williams Law LibraryBorrow it
    224 Dysart Road, Winnipeg, MB, R3T 5V4, CA
    49.811829 -97.131017
  • Eckhardt-Gramatté Music LibraryBorrow it
    136 Dafoe Road (Taché Arts Complex), Room 257, Winnipeg, MB, R3T 2N2, CA
    49.807964 -97.132222
  • Elizabeth Dafoe LibraryBorrow it
    25 Chancellors Circle, Winnipeg, MB, R3T 2N2, CA
    49.809961 -97.131878
  • Fr. H. Drake Library (St. Paul's College)Borrow it
    70 Dysart Road, Winnipeg, MB, R3T 2M6, CA
    49.810605 -97.138184
  • J.W. Crane Memorial Library (Deer Lodge Centre)Borrow it
    2109 Portage Avenue, Winnipeg, MB, R3J 0L3, CA
    49.878000 -97.235520
  • Libraries Annex (not open to the public; please see web page for details)Borrow it
    25 Chancellors Circle (in the Elizabeth Dafoe Library), Winnipeg, MB, R3T 2N2, CA
    49.809961 -97.131878
  • Neil John Maclean Health Sciences LibraryBorrow it
    727 McDermot Avenue (Brodie Centre), 200 Level, Winnipeg, MB, R3E 3P5, CA
    49.903563 -97.160554
  • Sciences and Technology LibraryBorrow it
    186 Dysart Road, Winnipeg, MB, R3T 2M8, CA
    49.811526 -97.133257
  • Seven Oaks General Hospital LibraryBorrow it
    2300 McPhillips Street, Winnipeg, MB, R2V 3M3, CA
    49.955177 -97.148865
  • Sister St. Odilon Library (Misericordia Health Centre)Borrow it
    99 Cornish Avenue, Winnipeg, MB, R3C 1A2, CA
    49.879592 -97.160425
  • St. John's College LibraryBorrow it
    92 Dysart Road, Winnipeg, MB, R3T 2M5, CA
    49.811242 -97.137156
  • Victoria General Hospital LibraryBorrow it
    2340 Pembina Highway, Winnipeg, MB, R3T 2E8, CA
    49.806755 -97.152739
  • William R Newman Library (Agriculture)Borrow it
    66 Dafoe Road, Winnipeg, MB, R3T 2R3, CA
    49.806936 -97.135525
Processing Feedback ...