| 000 -LEADER | |
|---|---|
| fixed length control field | 11363cam a22004334a 4500 |
| 001 - CONTROL NUMBER | |
| control field | 2004112340 |
| 003 - CONTROL NUMBER IDENTIFIER | |
| control field | AE-DuAU |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20241127165515.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 050916s2005 inua 001 0 eng |
| 010 ## - LIBRARY OF CONGRESS CONTROL NUMBER | |
| LC control number | 2004112340 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 0764574272 (pbk.) : |
| Terms of availability | 24.99 |
| 040 ## - CATALOGING SOURCE | |
| Original cataloging agency | DLC |
| Transcribing agency | DLC |
| 042 ## - AUTHENTICATION CODE | |
| Authentication code | pcc |
| 050 00 - LIBRARY OF CONGRESS CALL NUMBER | |
| Classification number | HF5548.4.M523 |
| Item number | H3685 2005 |
| 069 ## - | |
| -- | 09397284 |
| 090 ## - LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (OCLC) | |
| Classification number (OCLC) (R) ; Classification number, CALL (RLIN) (NR) | HF 5548.4 .M523 H3685 2005 |
| 090 ## - LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (OCLC) | |
| Classification number (OCLC) (R) ; Classification number, CALL (RLIN) (NR) | HF 5548.4 .M523 H3685 2005 |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Harvey, Greg. |
| 9 (RLIN) | 177927 |
| 245 10 - TITLE STATEMENT | |
| Title | Excel timesaving techniques for dummies / |
| Statement of responsibility, etc | Greg Harvey. |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) | |
| Place of publication, distribution, etc | Indianapolis, IN : |
| Name of publisher, distributor, etc | Wiley, |
| Date of publication, distribution, etc | c2005. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | xiv, 395 p. : |
| Other physical details | ill. ; |
| Dimensions | 23 cm. |
| 336 ## - CONTENT TYPE | |
| Source | rdacontent |
| Content Type Term | text |
| Content Type Code | txt |
| 337 ## - MEDIA TYPE | |
| Source | rdamedia |
| Media Type Term | unmediated |
| Media Type Code | n |
| 338 ## - CARRIER TYPE | |
| Source | rdacarrier |
| Carrier Type Term | volume |
| Carrier Type Code | nc |
| 500 ## - GENERAL NOTE | |
| General note | Includes index. |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Formatted contents note | Making Excel Work Your Way -- Customizing the Excel Screen Display -- Standard Display Settings -- Switching to Full Screen -- Customizing the Worksheet Display -- Saving Custom Display Settings -- Customizing the Excel Menus and Toolbars -- Showing the Toolbars and Menus in All Their Glory -- Toolbars and Menus Made to Order -- A Toolbar and Menu of Your Own -- Adding Macros and Links to Toolbars and Menus -- Perfecting Your Spreadsheet Workspace -- Saving Your Workspace -- Opening a Workspace Whenever Excel Launches -- Saving Your Worksheets So You Can Find Them -- Modifying the Default File Location -- Saving New Files with Summary Information -- Changing the AutoRecover Settings -- Tailoring Excel's Error Checking to Your Needs -- Modifying the Error Checking Settings -- Suppressing All Error Indicators -- Hiding Error Values On-Screen and in Print -- Utilizing Excel's Editing Settings -- Putting the Cell Pointer in the Right Direction -- Completely Turned Off to AutoComplete -- Doing the Drag-and-Drop Thing -- Doing Direct Cell Editing -- Streamlining Excel Program Startup -- Excel Desktop Shortcut -- Adding Excel to the Quick Launch Toolbar -- Pinning Excel to the Start Menu -- Launching Excel on Windows Startup -- Saving Time with Excel Add-ins -- Installing Add-ins -- Using the Built-in Add-ins -- Getting Online Add-ins -- Quick Worksheet Creation Tricks -- Navigating the Worksheet in a Snap -- Saving the Cell Pointer's Position -- Going Direct -- A Little Go To Magic -- Zooming Out to Get the Big Picture -- Making the Most Efficient Cell Selections -- AutoSelect at Your Service -- Go To It and Select It -- Going for the Big Selections -- Speeding Through Long Data Entries with AutoCorrect -- Setting the Correct AutoCorrect Settings -- Losing the Links -- Taming the Smart Tags -- Data Entry Tricks -- Making the Same Entry in Many Places -- Putting the Wraps on the Data Entry -- Let's Do It as a Group! -- Speeding Up Data Entry with AutoFill -- Getting Your Fill of AutoFill -- Incrementally Speaking -- Fill Lists Made to Order -- Ensuring Accurate Data Entries with Data Validation -- Only the Valid Need Apply -- Information Please! -- Warnings to Make Them Wary -- All Aboard the Numerical Entry Express! -- Taking Advantage of the Numeric Keypad -- Putting the Decimal Places at Your Service -- Number Please! -- Verifying Entries with Text to Speech -- "Can You Hear Me Now?" -- Modifying the Text to Speech Settings -- Handy Ways to Format and Present Worksheet Data -- Instant Range Formatting -- Head-to-Toe Table Formatting with AutoFormat -- Getting Artistic with the Format Painter -- Cutting and Pasting Formats Only -- Style Formatting Magic -- Styling -- Creating Styles of Your Own -- Merging Styles from One Book into Another -- Controlling When Certain Formats Are Used -- Formats to Suit Every Condition -- Making Your Outstanding Errors Stand Out -- Customizing Number Formats -- Creating Custom Number Formats -- Assigning Custom Number Formats to Styles and Toolbars -- Applying Euro Currency Formats -- Dazzling Alignments for Data Entries -- Line Me Up -- Getting Your Text under Control -- Charting Data in a Snap -- Instant Charts -- Chart Wizard Magic -- Chart Customization Tricks -- Getting the Chart Titles and Headings in Balance -- Scaling and Formatting the Chart Axes -- Tricks for Making the Plotted Data Easier to Decipher -- Worksheet Formula Timesavers -- Efficient Formula Copying -- Going from Relative to Absolute -- When It's Copy Time -- Speeding Up Table Creation with Array Formulas -- A Quick Look at Array Ranges -- Hurray for Array Formulas! -- Editing Array Formulas -- Using Range Names -- Name That Range! -- Assigning Range Names to Constants -- Using Your Range Names in Formulas -- Smarter Formula Construction -- Pointing Out Cell References in Formulas -- Putting the Insert Function Feature at Your Service -- Using Labels Instead of Cell References in Formulas -- Trapping Those Terrible Errors -- If I Were a Logical Function -- Trapping Division by Zero Errors -- Trapping All Types of Error Values -- Eliminating Errors with Error Tracing -- Formula Auditing 101 -- Tracing Formula Precedents -- Tracing Formula Dependents -- Finding the Original Error and Fixing Its Formula -- Creating Efficient Date and Time Formulas -- The Deal with Dates and Times -- You Do the Date Math! -- When Your Time Is Up -- Worksheet Editing Timesavers -- Quickly Finding the Workbook You Want to Edit -- Opening Recently Used Files -- Making the Most of the File Search Task Pane -- Searching for Files in the Open Dialog Box -- Controlling the Worksheet Window Display -- Zooming In for the Edits -- Frozen Panes in My Windows -- A Worksheet with a Custom View -- Managing Worksheet Windows -- Opening Panes in the Worksheet Window -- Comparing Sheets in the Same Workbook -- Comparing Sheets in Separate Workbooks -- Quick and Easy Insertion and Deletion -- Inserting and Deleting Cells in an Existing Range -- Inserting and Deleting Rows and Columns -- Inserting and Deleting Worksheets -- Outline and Subtotal Magic -- Adding Outline Levels to a Table or List -- Subtotaling a Table or List -- Consolidating Data from Different Worksheets -- Consolidating Data by Position -- Consolidating Data by Category -- Linking Consolidated Data -- Editing with Search & Replace and Spell Check -- Using Find and Replace -- Eliminating Typing Errors with Spell Check -- Tips for Printing, Sharing, and Reviewing Workbooks -- Spreadsheet Security -- Assigning a Password for Opening a Workbook -- Protecting the Worksheet Against Unwanted Changes -- Hiding Sensitive Worksheet Data -- Printing Tricks for Flawless Reports -- Making Last-Minute Adjustments with Print Preview -- Controlling Bad Page Breaks -- Adding Headings to Your Report -- Printing the Formulas in the Report -- Printing the Charts in the Report -- Sharing Data with Other Office Programs -- Swapping Data via the Clipboard -- Importing Text Files into Excel -- Embedding Excel Data in Other Office Documents -- Sharing Workbooks on a Network -- Let's All Learn to Share -- Merging Changes from Different Users -- Merging Different Copies of a Shared Workbook -- Sending Workbooks Out for Review -- Getting a Workbook Ready for Review -- Sending Out a Workbook for Review -- Streamlining Data Listing and Data Analysis -- Adding and Editing Data Lists with the Data Form -- Creating a New Data List and Data Form -- Sorting Worksheet Data -- Don't Be Out of Sorts -- Sorting the Field Names in a Data List -- Quick and Easy Basic Data List Filtering -- AutoFilter Basics -- Customizing the AutoFilter Settings -- More Data List Filtering plus Statistical Analysis -- Putting the Advanced Filter in Service -- Getting Data List Statistics -- Doing What-if Analysis in a Snap with Data Tables -- Creating a One-Variable Data Table -- Creating a Two-Variable Data Table -- Easy What-if Analysis through Scenarios and Goal Seeking -- Exploring Different Scenarios -- Reaching a Target with Goal Seeking -- Summarizing Data with Pivot Tables and Pivot Charts -- Creating Pivot Tables -- Creating a Pivot Chart -- Internet-Related Timesavers -- Saving Worksheets as Web Pages -- Saving Worksheets as Web Pages -- Creating Interactive Web Pages -- Importing Web Data into the Worksheet -- Capturing Information for the Spreadsheet with Web Queries -- Importing XML Data into a Worksheet -- Using Hyperlinks to Make Jumps in Workbooks -- Adding Hyperlinks to a Worksheet -- Following Links in a Worksheet -- Editing Links in a Worksheet -- Creating Hyperlinks for Custom Menus and Toolbars -- The Scary (Or Fun) Stuff -- Instant Lists in Excel 2003 -- Creating an Excel 2003 List -- Sorting and Filtering the List -- Toggling the List's Total Row On and Off -- Easy List Editing -- Sharing Excel Workbooks and Lists with a SharePoint Web Site -- Adding Excel Spreadsheets to the SharePoint Site -- Publishing Lists to the SharePoint Site -- Entering Data and Issuing Commands by Voice -- Hands-Free Data Entry -- Just Tell Me What to Do -- Sprucing Up Your Spreadsheets with Graphics -- Jazz It Up with Clip Art -- Adding Images from Graphics Files -- Drawing Objects for the Spreadsheet -- Doing Automated Table Lookups -- Looking Up a Single Table Value -- Doing a Two-Way Lookup in a Data Table -- Using Text Formulas for Fun and Profit -- Getting Right on the Case -- Joining Separate Text Entries Together -- Replacing Text Formulas with Their Results -- Creating Queries to Import Data from an External Database -- Setting Up the Data Source Definition -- Creating the Database Query -- Automating Repetitive Tasks with Macros -- Recording and Playing Back Macros -- Editing Macros in the Visual Basic Editor -- Creating Custom Functions to Use in Your Worksheets -- Creating Custom Functions -- Saving Custom Functions in an Excel Add-in. |
| 520 #0 - SUMMARY, ETC. | |
| Summary, etc | Covering formulas, charts, data lists, macros, and versions 2000, 2002, and 2003, this book offers more than seventy easy-to-follow techniques that show both new and experienced Excel users how to save time and avoid tedious or redundant tasks. Bestselling author Greg Harvey includes information on customizing Excel’ s menus and toolbars; modifying Excel’ s editing settings; using add-ins, AutoCorrect, AutoFill, AutoFormat, and data validation; copying and moving data between worksheets; encryptin workbook files; creating external database queries; converting worksheet data and charts into Web pages; and much more. Written by Greg Harvey, one of the bestselling technology authors of all time, whose books have combined sales of more than four million copies A unique, two-column format makes it easy for readers to grasp and apply each technique– and begin working more efficiently |
| 630 00 - SUBJECT ADDED ENTRY--UNIFORM TITLE | |
| Uniform title | Microsoft Excel (Computer file) |
| 9 (RLIN) | 177928 |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Business |
| General subdivision | Computer programs. |
| 9 (RLIN) | 177929 |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Electronic spreadsheets. |
| 9 (RLIN) | 177930 |
| 852 ## - LOCATION/CALL NUMBER | |
| -- | p24.99 |
| -- | 04-03-2005 |
| 907 ## - LOCAL DATA ELEMENT G, LDG (RLIN) | |
| a | |
| b | 08-06-10 |
| c | 08-06-10 |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Koha item type | Books |
| 998 ## - LOCAL CONTROL INFORMATION (RLIN) | |
| -- | audmc |
| Operator's initials, OID (RLIN) | 04-03-05 |
| Cataloger's initials, CIN (RLIN) | m |
| First Date, FD (RLIN) | a |
| -- | - |
| -- | eng |
| -- | inu |
| -- | 0 |
| 905 ## - LOCAL DATA ELEMENT E, LDE (RLIN) | |
| a | Greg Harvey is a computer trainer and the author of some 50 books on technology. He operates Mind Over Media, a venture in multimedia publishing |
| 935 ## - | |
| -- | 16976%5FNOV2%5FMM |
| 945 ## - LOCAL PROCESSING INFORMATION (OCLC) | |
| g | 0 |
| i | 659177 |
| j | 0 |
| l | audmc |
| n | Copy Type:01 - Books |
| o | - |
| p | 91.84 |
| q | - |
| r | - |
| s | - |
| t | 1 |
| u | 2 |
| v | 0 |
| w | 2 |
| x | 0 |
| y | i10246812 |
| z | 08-06-10 |
| Lost status | Source of classification or shelving scheme | Materials specified (bound volume or other part) | Damaged status | Not for loan | Home library | Current library | Shelving location | Date acquired | Cost, normal purchase price | Total Checkouts | Full call number | Barcode | Date last seen | Date checked out | Cost, replacement price | Price effective from | Koha item type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Library of Congress Classification | Copy Type:01 - Books | American University in Dubai | American University in Dubai | Main Collection | 2010-08-06 | 91.84 | 3 | HF 5548.4 .M523 H3685 2005 | 659177 | 2023-11-08 | 2019-01-13 | 91.84 | 2015-07-25 | Books |