Coverart for item
The Resource Managing data with Microsoft Excel, Conrad Carlberg

Managing data with Microsoft Excel, Conrad Carlberg

Label
Managing data with Microsoft Excel
Title
Managing data with Microsoft Excel
Statement of responsibility
Conrad Carlberg
Creator
Subject
Language
eng
Summary
You have learned the methods to the madness of Excel. Formulas and functions are friends instead of foes. Yet you know there's something missing that could make your job even easier. That "something" is efficient and effective data management. Managing Data with Excel is the only book on the market that focuses on just that. Learn how to efficiently move data, automate data storage and import data into worksheets and pivot tables. Case studies are included in each chapter to illustrate real-world applications of these functions. Invest your time in learning this now so that you can stop wasting your time figuring out how to work around problems
Member of
Cataloging source
N$T
http://library.link/vocab/creatorName
Carlberg, Conrad George
Dewey number
005.54
Illustrations
illustrations
Index
index present
LC call number
HF5548.4.M523
LC item number
C3683 2004eb
Literary form
non fiction
Nature of contents
dictionaries
Series statement
Business solutions
http://library.link/vocab/subjectName
  • Business
  • Electronic spreadsheets
  • COMPUTERS
  • Business
  • Electronic spreadsheets
Label
Managing data with Microsoft Excel, Conrad Carlberg
Instantiates
Publication
Note
  • "Applicable for versions of Microsoft Excel 97 to 2003"--Page 4 of cover
  • Includes index
Antecedent source
unknown
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
Contents
  • 5.
  • Using Microsoft Query
  • 6.
  • Importing data : further considerations
  • 7.
  • VBA essentials reviewed
  • 8.
  • Opening databases
  • 9.
  • Managing database objects
  • 1.
  • 10.
  • Defining fields and records with ActiveX data objects and data access objects
  • 11.
  • Getting data from Access and into Excel with ADO and DAO
  • 12.
  • Controlling a database from Excel using ADO and DAO
  • Misusing Excel as a database management tool
  • 2.
  • Excel's data management features
  • 3.
  • Excel's lists, names, and filters
  • 4.
  • Importing data : an overview
Control code
59759016
Dimensions
unknown
Extent
1 online resource (viii, 366 pages)
File format
unknown
Form of item
online
Isbn
9780768665727
Lccn
2004100887
Level of compression
unknown
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other physical details
illustrations.
http://library.link/vocab/ext/overdrive/overdriveId
b5c119b3-0c43-4290-9b56-c7aecfaaa59c
Quality assurance targets
not applicable
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)59759016
Label
Managing data with Microsoft Excel, Conrad Carlberg
Publication
Note
  • "Applicable for versions of Microsoft Excel 97 to 2003"--Page 4 of cover
  • Includes index
Antecedent source
unknown
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
Contents
  • 5.
  • Using Microsoft Query
  • 6.
  • Importing data : further considerations
  • 7.
  • VBA essentials reviewed
  • 8.
  • Opening databases
  • 9.
  • Managing database objects
  • 1.
  • 10.
  • Defining fields and records with ActiveX data objects and data access objects
  • 11.
  • Getting data from Access and into Excel with ADO and DAO
  • 12.
  • Controlling a database from Excel using ADO and DAO
  • Misusing Excel as a database management tool
  • 2.
  • Excel's data management features
  • 3.
  • Excel's lists, names, and filters
  • 4.
  • Importing data : an overview
Control code
59759016
Dimensions
unknown
Extent
1 online resource (viii, 366 pages)
File format
unknown
Form of item
online
Isbn
9780768665727
Lccn
2004100887
Level of compression
unknown
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other physical details
illustrations.
http://library.link/vocab/ext/overdrive/overdriveId
b5c119b3-0c43-4290-9b56-c7aecfaaa59c
Quality assurance targets
not applicable
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)59759016

Library Locations

    • Ellis LibraryBorrow it
      1020 Lowry Street, Columbia, MO, 65201, US
      38.944491 -92.326012
    • Engineering Library & Technology CommonsBorrow it
      W2001 Lafferre Hall, Columbia, MO, 65211, US
      38.946102 -92.330125
Processing Feedback ...