TY - BOOK AU - MacDonald,Matthew TI - Excel 2007 SN - 9780596527594 (pbk.) : AV - HF5548.4 U1 - 005.54 MAC PY - 2006/// CY - Beijing, Farnham PB - Pogue/O'Reilly KW - Microsoft Excel (Computer file) KW - Computers and IT KW - ukslc KW - Spreadsheet software KW - thema N1 - 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 N2 - 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 ER -