Synopses & Reviews
Youre beyond the basics, so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. Its all muscle and no fluff. Discover how the experts tackle Excel 2007and challenge yourself to new levels of mastery!
- Learn expert techniques for designing powerful spreadsheets
- Apply built-in functionsor write your ownand carry out complex calculations
- Use rich charting capabilities and new SmartArt graphics to visually represent data
- Perform sophisticated data analysis: financial, statistical, and “what-if”
- Design PivotTable reports to dynamically analyze data
- Share spreadsheets and collaborate with colleaguesand control access to sensitive data
- Link and embed Excel data into other documents
- Create macros with Microsoft Visual Basic for Applications
- Fully searchable eBook
- Sample spreadsheets from inside the book
- Add-ins and other resources to help you extend Microsoft Office programs
- Links to demos, user communities, and product support
- References for finding Excel 2003 commands in Excel 2007
- Windows Vista Product Guide eReference and other eBooks
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to firstname.lastname@example.org.
Experience learning made easy-and quickly teach yourself how to build custom sites and solutions with SharePoint Designer 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include mastering the tools for building and editing pages visually-no code; using master pages and CSS to control how sites look and work; connecting to lists, libraries, XML data, and RSS feeds; adding interactive and collaborative features with Web Parts and controls; creating workflows and other business-process applications; and managing user settings, accessibility, and site maintenance.
The smart way to build applications with Microsoft SharePoint Designer 2010 -- one step at a time!
Experience learning made easy -- and quickly teach yourself how to create SharePoint 2010 applications and workflows with Microsoft SharePoint Designer 2010. With Step by Step, you set the pace -- building and practicing the skills you need, just when you need them!
- Design solutions to meet your business scenario -- without code
- Customize lists, libraries, and SharePoint site pages
- Use Web Parts to display, edit, and modify list item data
- Access data from a variety of external sources
- Create workflows to automate business processes
- Use master pages and CSS to control how sites work
Your Step by Step digital content includes:
- All the books practice files -- ready to download and put to work.
- Fully searchable online edition of this book -- with unlimited access on the Web.
About the Author
Penelope Coventry is an independent consultant based in the UK, with more than 25 years of industry experience. She currently focuses on the design, implementation, and development of solutions based on SharePoint Products and Technologies. Penny has authored/co-authored a number of books, including Microsoft SharePoint Server 2010 Administrator's Companion, Microsoft Office SharePoint Server 2007 Administrator's Companion, Microsoft SharePoint Products and Technologies Resource Kit, SharePoint Designer 2007 Step by Step and Windows SharePoint Services 3.0 Step by Step. Penny is frequently seen at Tech*Ed and IT forum, either as a Technical Learning guide or on the SharePoint Ask-the-Expert stands. Penny lives in Hinckley, Leicestershire, England with her husband, Peter, and dog, Poppy.
Table of Contents
Acknowledgments; About the CD; Whats on the CD; System Requirements; Support Information; Conventions and Features Used in This Book; Text Conventions; Design Conventions; Part 1: Examining the Excel Environment; Chapter 1: Whats New in Microsoft Office Excel 2007; 1.1 New and Improved for 2007; 1.2 Retired in 2007; 1.3 If You Missed the Last Upgrade . . .; 1.4 Onward . . .; Chapter 2: Exploring Excel Fundamentals; 2.1 What Happens After You Install Excel?; 2.2 Examining the Excel 2007 Workspace; 2.3 Exploring File Management Fundamentals; 2.4 Importing and Exporting Files; 2.5 Using the Online Help System; 2.6 Recovering from Crashes; Chapter 3: Custom-Tailoring the Excel Workspace; 3.1 Customizing the Quick Access Toolbar; 3.2 Controlling Other Elements of the Excel 2007 Interface; 3.3 Enhancing Accessibility; Chapter 4: Security and Privacy; 4.1 The Trust Center; 4.2 File Security; 4.3 Other Security Features; Part 2: Building Worksheets; Chapter 5: Planning Your Worksheet Design; 5.1 Which Data Should Be in Rows, and Which in Columns?; 5.2 Will You Need to Print the Worksheet?; 5.3 Who Is the Audience?; 5.4 Would Your Worksheet Survive Without You?; 5.5 Does the Worksheet Rely on Imported Data?; 5.6 Do You Need More Than One Worksheet?; 5.7 Have You Allowed Room for New Data?; Chapter 6: How to Work a Worksheet; 6.1 Moving Around Regions; 6.2 Understanding Selection; 6.3 Techniques for Entering Data; 6.4 Managing Worksheets; 6.5 Viewing Worksheets; 6.6 Protecting Worksheets; Chapter 7: How to Work a Workbook; 7.1 Managing Multiple Workbooks; 7.2 Opening Multiple Windows for the Same Workbook; 7.3 Hiding and Protecting Workbooks; Part 3: Formatting and Editing Worksheets; Chapter 8: Worksheet Editing Techniques; 8.1 Copying, Cutting, and Pasting; 8.2 Inserting and Deleting; 8.3 Undoing Previous Actions; 8.4 Editing Cell Contents; 8.5 Finding and Replacing Stuff; 8.6 Getting the Words Right; 8.7 Editing Multiple Worksheets; 8.8 Auditing and Documenting Worksheets; 8.9 Outlining Worksheets; 8.10 Consolidating Worksheets; Chapter 9: Worksheet Formatting Techniques; 9.1 Formatting Fundamentals; 9.2 Using Themes and Cell Styles; 9.3 Formatting Conditionally; 9.4 Formatting in Depth; 9.5 Using Template Files to Store Formatting; Part 4: Adding Graphics and Printing; Chapter 10: Creating Spiffy Graphics; 10.1 Using the Shapes Tools; 10.2 Creating WordArt; 10.3 Creating SmartArt; 10.4 Inserting Graphics; 10.5 Formatting Graphics; 10.6 Working with Graphic Objects; 10.7 More Tricks with Graphic Objects; 10.8 Gallery of Spiffy Examples; Chapter 11: Printing and Presenting; 11.1 Controlling the Appearance of Your Pages; 11.2 Specifying What and Where to Print; 11.3 Adjusting Page Breaks; 11.4 Using Print Preview; 11.5 Setting Printer Driver Options; 11.6 Creating Portable Documents; Part 5: Creating Formulas and Performing Data Analysis; Chapter 12: Building Formulas; 12.1 Formula Fundamentals; 12.2 Using Functions: A Preview; 12.3 Working with Formulas; 12.4 Worksheet Calculation; 12.5 Using Arrays; 12.6 Linking Workbooks; 12.7 Creating Conditional Tests; Chapter 13: Using Functions; 13.1 Using the Built-In Function Reference in Excel; 13.2 Exploring the Syntax of Functions; 13.3 Inserting Functions; Chapter 14: Everyday Functions; 14.1 Understanding Mathematical Functions; 14.2 Understanding Text Functions; 14.3 Understanding Logical Functions; 14.4 Understanding Information Functions; 14.5 Understanding Lookup and Reference Functions; Chapter 15: Formatting and Calculating Date and Time; 15.1 Understanding How Excel Records Dates and Times; 15.2 Entering Dates and Times; 15.3 Formatting Dates and Times; 15.4 Calculating with Date and Time; 15.5 Working with Date and Time Functions; Chapter 16: Functions for Financial Analysis; 16.1 Calculating Investments; 16.2 Calculating Depreciation; 16.3 Analyzing Securities; 16.4 Using the Euro Currency Tools Add-In; Chapter 17: Functions for Analyzing Statistics; 17.1 Analyzing Distributions of Data; 17.2 Understanding Linear and Exponential Regression; 17.3 Using the Analysis Toolpak Data Analysis Tools; Chapter 18: Performing What-If Analysis; 18.1 Using Data Tables; 18.2 Using the Scenario Manager; 18.3 Using the Goal Seek Command; 18.4 Using the Solver; Part 6: Creating Charts; Chapter 19: Basic Charting Techniques; 19.1 Selecting Data for Your Chart; 19.2 Choosing a Chart Type; 19.3 Changing the Chart Type; 19.4 Switching Rows and Columns; 19.5 Choosing a Chart Layout; 19.6 Choosing a Chart Style; 19.7 Moving the Chart to a Separaaaaaate Chart Sheet; 19.8 Adding, Editing, and Removing a Chart Title; 19.9 Adding, Editing, and Removing a Legend; 19.10 Adding and Positioning Data Labels; 19.11 Adding a Data Table; 19.12 Manipulating Axes; 19.13 Adding Axis Titles; 19.14 Changing the Rotation of Chart Text; 19.15 Displaying Gridlines; 19.16 Adding Text Annotations; 19.17 Changing the Font or Size of Chart Text; 19.18 Applying Shape Styles and WordArt Styles; 19.19 Saving Templates to Make Chart Formats Reusable; Chapter 20: Charting Beyond the Ribbon; 20.1 Selecting Chart Elements; 20.2 Repositioning Chart Elements with the Mouse; 20.3 Formatting Lines and Borders; 20.4 Formatting Areas; 20.5 Formatting Text; 20.6 Working with Axes; 20.7 Working with Data Labels; 20.8 Formatting Data Series and Markers; 20.9 Modifying the Data Source for Your Chart; 20.10 Using Multilevel Categories; 20.11 Adding Moving Averages and Other Trendlines; 20.12 Adding Error Bars; 20.13 Adding High-Low Lines and Up and Down Bars; Part 7: Managing Databases and Tables; Chapter 21: Managing Information in Tables; 21.1 How to Organize a Table; 21.2 Creating a Table; 21.3 Adding Totals to a Table; 21.4 Sorting Tables and Other Ranges; 21.5 Filtering a List or Table; 21.6 Using Formulas with Tables; 21.7 Formatting Tables; Chapter 22: Analyzing Data with PivotTable Reports; 22.1 Introducing PivotTables; 22.2 Creating a PivotTable; 22.3 Rearranging PivotTable Fields; 22.4 Refreshing a PivotTable; 22.5 Changing the Numeric Format of PivotTable Data; 22.6 Choosing Report Layout Options; 22.7 Formatting a PivotTable; 22.8 Displaying Totals and Subtotals; 22.9 Sorting PivotTable Fields; 22.10 Filtering PivotTable Fields; 22.11 Changing PivotTable Calculations; 22.12 Grouping and Ungrouping Data; 22.13 Displaying the Details Behind a Data Value; 22.14 Creating PivotCharts; Chapter 23: Working with External Data; 23.1 Using and Reusing Data Connections; 23.2 Opening an Entire Access Table in Excel; 23.3 Working with Data in Text Files; 23.4 Working with XML Files; 23.5 Using Microsoft Query to Import Data; 23.6 Using a Web Query to Return Internet Data; Part 8: Collaborating; Chapter 24: Collaborating on a Network or by E-Mail; 24.1 Saving and Retrieving Files on Remote Computers; 24.2 Sharing Workbooks on a Network; 24.3 Combining Changes Made to Multiple Workbooks; 24.4 Distributing Workbooks and Worksheets by E-Mail; 24.5 Controlling Document Access with Information Rights Management; Chapter 25: Collaborating Using the Internet; 25.1 Using a Windows SharePoint Services Site; 25.2 Exporting Excel Tables to SharePoint; 25.3 Using Excel Services; Part 9: Automating Excel; Chapter 26: Recording Macros; 26.1 Configuring Macro Security; 26.2 Using the Macro Recorder; 26.3 Introducing the Visual Basic Editor; 26.4 Learning the Basics of Visual Basic; 26.5 Adding Code to or Editing Recorded Macros; 26.6 Using Subroutines in Macros; 26.7 Using the Personal Macro Workbook; 26.8 Going On from Here; Chapter 27: Creating Custom Functions; 27.1 Creating a Simple Custom Function; 27.2 Using Custom Functions; 27.3 Understanding Custom Function Rules; 27.4 Using VBA Keywords in Custom Functions; 27.5 Documenting Macros and Custom Functions; 27.6 Creating Custom Functions with Optional Arguments; 27.7 Making Your Custom Functions Available Anywhere; Chapter 28: Debugging Macros and Custom Functions; 28.1 Using Design-Time Tools; 28.2 Dealing with Run-Time Errors; Part 10: Integrating Excel with Other Applications; Chapter 29: Using Hyperlinks; 29.1 Creating a Hyperlink in a Cell; 29.2 Assigning a Hyperlink to a Shape, Image, or Chart; 29.3 Selecting a Cell or Object Without Triggering the Hyperlink; 29.4 Using Formulas to Create Hyperlinks; Chapter 30: Linking and Embedding; 30.1 Embedding vs. Linking; 30.2 Embedding vs. Static Pasting; 30.3 Embedding and Linking from the Clipboard; 30.4 Embedding and Linking with the Object Command; 30.5 Managing Links; 30.6 Linking vs. Hyperlinking; Chapter 31: Using Excel Data in Word Documents; 31.1 Using Excel Tables in Word Documents; 31.2 Using Excel Charts in Word Documents; 31.3 Using Excel to Supply Mail-Merge Data to Word; Part 11: Appendixes; Appendix A: Menu to Ribbon Command Reference; File Menu; Edit Menu; View Menu; Insert Menu; Format Menu; Tools Menu; Data Menu; Chart Menu; Window Menu; Help Menu; Standard Toolbar; Formatting Toolbar; Appendix B: Keyboard Shortcuts; Keyboard Shortcuts by Key; Keyboard Shortcuts by Task; Appendix C: Function Reference; Index to Troubleshooting Topics; About the Authors; Choose the Right Book for You; Published and Upcoming Titles;