Asia Pacific University Library catalogue

Includes index.

Introduction -- Jaw-dropping new Excel features -- Where are my menus and toolbars? -- Introducing the ribbon -- Where is the classic mode? -- Conventions used in this book -- I. Mastering the new user interface -- 1. Introducing the ribbon user interface -- The Excel 2007 interface -- Using the Office icon menu -- Understanding the ribbon user interface -- Finding old menu items in the new interface -- 2. The Quick Access toolbar -- Changing the location of the Quick Access toolbar -- Adding your favorite commands to the Quick Access toolbar -- Customizing the Quick Access toolbar -- 3. The mini toolbar and other U.I. improvements -- Using the mini toolbar to format selected text -- Expanding the formula bar -- Zooming in and out on a worksheet -- Using the status bar to add numbers -- Switching between normal view, page break preview, and page layout view modes -- Using the new sheet icon to add worksheets -- 4. Keyboard shortcuts -- Using the new keyboard accelerators -- Using the shortcut keys -- Using Excel 2003 keyboard accelerators -- 5. Galleries, Live Preview, and themes -- Using galleries -- Using Live Preview -- Understanding themes -- 6. The Excel options dialog -- Introducing the Excel options dialog -- Toggling the new Excel 2007 features -- Controlling the look and feel of the worksheet window -- Guide to Excel options --

II. A tour of what's new -- 7. The big grid -- Excel 2007 grid limits -- Other limits in Excel 2007 -- Working with Excel 2003 named ranges in Excel 2007 -- Tips for navigating the big grid -- 8. Fabulous table intelligence -- Defining suitable data for Excel tables -- Keeping headers in view -- Adding a total row to a table -- Toggling totals -- Expanding a table -- Adding new formulas to tables -- Selecting only the data in the column -- Using table data for charts to ensure stickiness -- Replacing named ranges with table references -- Creating banded rows and columns with table styles -- Dealing with the AutoFilter drop-downs -- 9. Visualizing data in Excel -- Creating in-cell bar charts with data bars -- Creating heat maps with color scales -- Using stop if true to improve all conditional formatting -- Using the top/bottom rules -- Using the highlight cells rules -- Tweaking rules with advance formatting -- Combining rules -- Clearing conditional formats -- Extending the reach of conditional formats -- Special considerations for tables -- Special considerations for pivot tables -- 10. Using pivot tables to analyze data -- What is possible with pivot tables -- Preparing your data for pivot table analysis -- Creating our first pivot table -- Changing the default layout of a pivot table -- Adding new fields to a pivot table -- Eliminating blank cells from a pivot table -- Using pivot table legacy mode -- Pivot table limitations -- 11. Formatting pivot tables -- The new compact view -- Report layout options -- Special considerations when adding data fields to the value section -- Formatting a pivot table -- 12. Pivot table data crunching for Excel 2007 -- Grouping daily dates to months and years -- Sorting and filtering -- Exploring even more filtering options -- Adding new items along a dimension -- Showing percentages instead of values -- Exploring interesting uses for pivot tables -- Finding more information on pivot tables -- 13. Removing duplicates and filtering -- Using remove duplicates to find unique values -- Filtering records -- Using the advanced filter command -- 14. Sorting data -- Introducing the new sort dialog -- Using specialized sorting -- One-click sorting -- Sorting randomly -- 15. Using Excel charts -- Understanding the components of a chart -- Setting up your data for charting -- Inserting a chart by choosing a chart type -- Choosing a chart layout to further customize the chart type -- Customizing a chart by using a chart style or theme -- Charting tricks and techniques -- Using pivot charts -- 16. Using SmartArt, shapes, WordArt, and text boxes -- Using SmartArt -- Using shapes to display cell contents -- Using WordArt for interesting titles and headlines -- Using text boxes to flow long text passages -- 17. Using pictures and Clip Art -- Using pictures on worksheets -- Using Clip Art --

III. Working in a legacy environment -- 18. File format differences -- A brief history of file formats -- Using the new binary file format : BIFF12 -- Using the new XML file formats : XLSX and XLSM -- The future of file formats -- 19. Working with prior versions of Excel -- Opening Excel 2007 files in previous versions of Excel -- Creating Excel 2007 file formats in Excel 2003 -- Opening Excel 2003 files in Excel 2007 -- Preparing to save Excel 2007 files for Excel 97 through Excel 2003 -- The digital divide --

IV. Calculating with Excel -- 20. Understanding formulas -- Getting the most from this chapter -- Introduction to formulas -- Entering your first formula -- Three methods of entering formulas -- Entering the same formula in many cells -- Copying a formula by using the table tool -- 21. Controlling formulas -- Formula operators -- Understanding error messages in formulas -- Using formulas to join text -- Copying versus cutting a formula -- Automatically formatting formula cells -- Using date math -- Troubleshooting formulas -- 22. Understanding functions -- Working with functions -- Getting help with Excel functions -- Using AutoSum -- Using the new general-purpose functions in Excel 2007 -- Using the new CUBE functions in Excel 2007 -- Using the former ATP functions -- The function reference chapters -- 23. Using everyday functions : math, date and time, and text functions -- Examples of math functions -- Dates and times in Excel -- Examples of date and time functions -- Examples of text functions -- 24. Using powerful functions : logical, lookup, and database functions -- Examples of logical functions -- Examples of information functions -- Examples of lookup and reference functions -- Examples of database functions -- 25. Using financial functions -- Examples of common household loan and investment functions -- Examples of functions for financial professionals -- Examples of depreciation functions -- Functions for investment analysis -- Examples of functions for bond investors -- Examples of miscellaneous financial functions -- 26. Using statistical functions -- Examples of functions for descriptive statistics -- Examples of functions for regression and forecasting -- Examples of functions for inferential statistics -- Using the Analysis Toolpak to perform statistical analysis -- 27. Using Trig, matrix, and engineering functions -- A brief review of trigonometry basics -- Examples of logarithm functions -- Working with imaginary numbers -- Solving simultaneous linear equations with matrix functions -- Examples of engineering functions -- Using the Analysis Toolpack to perform fast Fourier Transforms (FFTs) -- 28. Connecting worksheets, workbooks, and external data -- Connecting two worksheets -- Connecting to a worksheet in another workbook -- Connecting to data on a Web page -- Setting up a connection to a text file -- Setting up a connection to an Access database -- Setting up SQL server, XML, OLE DB, and ODBC connections -- Managing connections -- 29. Using super formulas in Excel -- Using 3D formulas to spear through many worksheets -- Combining multiple formulas into one formula -- Calculating a cell reference in the formula by using the INDIRECT function -- Assigning a formula to a name -- Replacing multiple formulas with one array formula -- 30. Using names in Excel -- Defining a name for a cell by using the name box -- Naming a cell by using the new name dialog -- Using the name box for quick navigation -- Using scope to allow duplicate names in a workbook -- Using named ranges to simplify formulas -- Managing names -- Using a name to hold a value -- Assigning a formula to a name -- 31. Using What if , Scenario Manager, Goal Seek, and Solver -- Using What-if -- Using Scenario Manager -- Using Goal Seek -- Using Solver --

V. Formatting and sharing information -- 32. Formatting worksheets -- Why format worksheets? -- Using traditional formatting -- Formatting with styles -- Other formatting techniques -- Copying formats -- 33. Printing -- Using page layout view -- Using the improved headers and footers -- Using the page setup and sheet options -- Working with page breaks -- Printing -- 34. Sharing workbooks with others -- Sending a workbook via email -- Creating a PDF from a worksheet -- Publishing a worksheet to a Webpage -- Publishing to a server -- 35. More tips and tricks for Excel 2007-- Speeding up calculation by using multithreaded calculation -- Watching the results of a far-off cell -- Looking for hidden data in a workbook -- Marking a document as final to prevent changes -- Opening the same files everyday -- Downloading cool spreadsheets from Office online -- Adding visual interest by using a background picture -- Comparing documents side-by-side with synchronous scrolling -- Calculating a formula in slow motion -- Inserting a symbol in a cell -- Adding a digital signature line to a workbook -- Protecting a worksheet -- Sharing a workbook -- Separating text based on a delimiter -- Adding automatic subtotals -- Translating text --

VI. More power -- 36. Automating repetitive functions using VBA macros -- Checking security settings before using macros -- Recording a macro -- Case study : macro for formatting for a mail merge -- Everyday-use macro example : formatting an invoice register -- Understanding VBA code, an analogy -- Using simple variables and object variables -- Using R1C1-style formulas -- Customizing the everyday-use macro example : GetOpenFileName and GetSaveAsFileName -- From-scratch macro example : loops, flow control, and referring to ranges -- Combination macro example : creating a report for each customer -- Conclusion -- 37. Interacting with other Office applications -- Pasting Excel data to Microsoft OneNote -- Pasting Excel data to PowerPoint -- Creating tables in Excel and pasting to Word -- Pasting Word data to an Excel text box -- Using Excel data in a Word mail merge -- Building a pivot table from Access queries -- 38. A tour of the best add-ins for Excel -- Customizing the ribbon by using CustomizeRibbon -- Loading PDF data to Excel by using Able2Extract -- Doing Access with Excel by using DigDB -- Creating dashboards by using Speedometer Chart Creator -- Accessing more functions by using MoreFunc.dll -- Using add-ins from AddIns.com -- Index.