Dodge, Mark. creator Stinson, Craig 1943- text wau Redmond, WA Microsoft Press 2007 monographic eng

print

xxviii, 1056 pages : illustrations ; 23 cm 1 computer disc (4 3/4 in.). An overview of the latest version of Office Excel 2007 describes the program's new features and capabilities, including formatting and editing advances with Live Preview, graphics capabilities, charting interface, PivotTable, macros, and other custom functions. Part 1: Examining the Excel environment -- What's new in Microsoft Office Excel 2007 -- Exploring Excel fundamentals -- Custom-tailoring the Excel workspace -- Security and privacy -- Part 2: Building worksheets -- Planning your worksheet design -- How to work a worksheet -- How to work a workbook -- Part 3: Formatting and editing worksheets -- Worksheet editing techniques -- Worksheet formatting techniques -- Part 4: Adding graphics and print -- Creating spiffy graphics -- Printing and presenting -- Part 5: Creating formulas and performing data analysis -- Building formulas -- Using functions -- Everyday functions -- Formatting and calculating date and time -- Functions for financial analysis -- Functions for analyzing statistics -- Performing what-if analysis -- Part 6: Creating charts -- Basic charting techniques -- Charting beyond the ribbon -- Part 7: Managing databases and tables -- Managing information in tables -- Analyzing data with PivotTable reports -- Working with external data -- Part 8: Collaborating -- Collaborating on a newtork or by e-mail -- Collaborating using the internet -- Part 9: Automating Excel -- Recording macros -- Creating custom functions -- Debugging macros and custom functions -- Part 10: Integrating Excel with other applications -- Using hyperlinks -- Linking and embedding -- Using Excel data in Word documents -- Part 11: Appendices -- A. Menu to Ribbon command reference -- B. Keyboard shortcuts -- C. Function reference. Mark Dodge, Craig Stinson. Business Computer programs Electronic spreadsheets Bureautique Logiciels Tableaux statistiques Manuels Business Computer programs Electronic spreadsheets Spreadsheet software HF5548.4.M523 D626 2007 005.54 9780735623217 073562321X 2006937709 X12-65192 Microsoft http://catdir.loc.gov/catdir/enhancements/fy1010/2006937709-t.html http://catdir.loc.gov/catdir/enhancements/fy1105/2006937709-b.html http://catdir.loc.gov/catdir/enhancements/fy1004/2006937709-d.html http://catdir.loc.gov/catdir/enhancements/fy1010/2006937709-t.html http://catdir.loc.gov/catdir/enhancements/fy1105/2006937709-b.html http://catdir.loc.gov/catdir/enhancements/fy1004/2006937709-d.html DLC 061031 20180904081013.0 ocm81259543 eng