gogo
Amazon cover image
Image from Amazon.com

Excel 2007 / Matthew MacDonald.

By: Material type: TextTextSeries: The missing manualPublication details: Beijing ; Farnham : Pogue/O'Reilly, 2006.Description: xxi, 831 p. : ill. ; 24 cmISBN:
  • 9780596527594 (pbk.) :
  • 0596527594
Subject(s): DDC classification:
  • 005.54 MAC
LOC classification:
  • HF5548.4
Incomplete contents:
Part one: Worksheet basics -- 1.Creating and navigating worksheets -- 2.Adding information to worksheets -- 3.Moving data around a worksheept -- 4.Managing worksheets and workbooks -- 5.Formatting cells -- 6.Smart formatting tricks -- 7.Viewing and printing worksheets -- Part two: Formulas and functions -- 8.Building basic formulas -- 9.Math and statistical functions -- 10.Financial functions -- 11.Manipulating dates, times, and text -- 12.Lookup, reference, and information functions -- 13.Advanced formula writing and troubleshooting -- Part three: Organizing worksheets -- 14.Tables: list management made easy -- 15.Grouping and outlining data -- 16.Templates -- 17.Creating basic charts -- 18.Formatting and perfecting charts -- 19.Inserting graphics -- Part five: Advanced data analysis -- 20.Scenarios and goal seeking -- 21.Pivot tables -- Part six: Sharing data with the rest of the world -- 22.Protecting your workbooks -- 23.Worksheet collaboration -- 24.Querying databases and XML files -- 25.Exchanging data with other programs -- 26.Connecting worksheets to the web -- Part seven: Programming Excel -- 27.Automating tasks with macros -- 28.Programming spreadsheets with VBA.
Summary: Becoming an Excel jockey takes practice, dedication, and expert guidance. But despite its fairly steep learning curve, Excel is a rich program that enables users of every stripe to turn data into information using tools to analyze, communicate, and share knowledge. This resource is ideal for users of all levels.
Holdings
Item type Current library Call number Copy number Status Date due Barcode
Long Loan TUS: Midlands, Main Library Athlone General Lending 005.54 MAC (Browse shelf(Opens below)) 1 Available 202611

Includes index.

Part one: Worksheet basics -- 1.Creating and navigating worksheets -- 2.Adding information to worksheets -- 3.Moving data around a worksheept -- 4.Managing worksheets and workbooks -- 5.Formatting cells -- 6.Smart formatting tricks -- 7.Viewing and printing worksheets -- Part two: Formulas and functions -- 8.Building basic formulas -- 9.Math and statistical functions -- 10.Financial functions -- 11.Manipulating dates, times, and text -- 12.Lookup, reference, and information functions -- 13.Advanced formula writing and troubleshooting -- Part three: Organizing worksheets -- 14.Tables: list management made easy -- 15.Grouping and outlining data -- 16.Templates -- 17.Creating basic charts -- 18.Formatting and perfecting charts -- 19.Inserting graphics -- Part five: Advanced data analysis -- 20.Scenarios and goal seeking -- 21.Pivot tables -- Part six: Sharing data with the rest of the world -- 22.Protecting your workbooks -- 23.Worksheet collaboration -- 24.Querying databases and XML files -- 25.Exchanging data with other programs -- 26.Connecting worksheets to the web -- Part seven: Programming Excel -- 27.Automating tasks with macros -- 28.Programming spreadsheets with VBA.

Becoming an Excel jockey takes practice, dedication, and expert guidance. But despite its fairly steep learning curve, Excel is a rich program that enables users of every stripe to turn data into information using tools to analyze, communicate, and share knowledge. This resource is ideal for users of all levels.

Powered by Koha