Share
Create bookmark
Microsoft® Office Excel 2003 Inside Out
Notes
Please login to add notes
- + Cover
- Contents at a Glance
- Table of Contents
- Acknowledgments
- We’d Like to Hear from You!
- + About the CD
- + Conventions and Features Used in this Book
- + Part 1 Examining the Excel Environment
-
+
Part 2 Building Worksheets
-
+
Part 3 Formatting and Editing Worksheets
-
+
Chapter 7 Worksheet Editing Techniques
-
+
Chapter 8 Worksheet Formatting Techniques
- + Formatting Fundamentals
-
+
Formatting in Cells
- Formatting Individual Characters
- Formatting as You Type
- Using the General Format
- Formatting Numbers
- Formatting Currency
- Using the Euro Currency Tools Add-in
- Using Accounting Formats
- Using Accounting Underlines
- Formatting Percentages
- Formatting Fractions
- Formatting Scientific (Exponential) Values
- Understanding the Text Format
- Using the Special Formats
- + Creating Custom Formats
- + Aligning Data in Cells
- + Aligning Text Vertically
- + Using Fonts
- + Customizing Borders
- + Applying Colors and Patterns
- + Controlling the Size of Cells
-
+
Chapter 9 Advanced Formatting and Editing Techniques
-
+
Chapter 7 Worksheet Editing Techniques
- + Part 4 Adding Graphics and Printing
-
+
Part 5 Creating Formulas and Performing Data Analysis
-
+
Chapter 12 Building Formulas
- + Formula Fundamentals
- + Using Functions: A Preview
-
+
Naming Cells and Cell Ranges
- Using Names in Formulas
- Defining and Managing Names
- Editing Names
- Workbook-Wide vs. Worksheet-Only Names
- Creating Names Semiautomatically
- Naming Constants and Formulas
- Creating Three-Dimensional Names
- Pasting Names into Formulas
- Creating a List of Names
- Replacing References with Names
- Using Go To with Named Ranges
- Understanding Error Values
- + Worksheet Calculation
- + Using Arrays
- + Linking Workbooks
- + Creating Conditional Tests
- + Chapter 13 Using Functions
-
+
Chapter 14 Everyday Functions
-
+
Chapter 15 Formatting and Calculating Date and Time
-
+
Chapter 16 Functions for Financial Analysis
- + Calculating Investments
- + Calculating Depreciation
-
+
Analyzing Securities
- The DOLLARDE and DOLLARFR Functions
- The ACCRINT and ACCRINTM Functions
- The INTRATE and RECEIVED Functions
- The PRICE, PRICEDISC, and PRICEMAT Functions
- The DISC Function
- The YIELD, YIELDDISC, and YIELDMAT Functions
- The TBILLEQ, TBILLPRICE, and TBILLYIELD Functions
- The COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, and COUPPCD Functions
- The DURATION and MDURATION Functions
-
+
Chapter 17 Functions for Analyzing Statistics
-
+
Chapter 18 Performing What-If Analysis
-
+
Chapter 12 Building Formulas
-
+
Part 6 Collaboration and the Internet
-
+
Chapter 19 Collaborating with Excel
- Saving and Retrieving Files on Remote Computers
- + Sharing Workbooks on a Network
- + Combining Changes Made to Multiple Workbooks
- + Distributing Workbooks and Worksheets by E-Mail
- + Controlling Document Access with Information Rights Management
- + Using a SharePoint Team Services Site
- Using Web Discussions
-
+
Chapter 20 Transferring Files to and from Internet Sites
-
+
Chapter 19 Collaborating with Excel
- + Part 7 Integrating Excel with Other Applications
-
+
Part 8 Creating Charts
- + Chapter 24 Basic Charting Techniques
-
+
Chapter 25 Enhancing the Appearance of Your Charts
- Working with the Chart Menu and Chart Toolbar
- Selecting Chart Elements
- Copying Formats from One Chart to Another
- Adding a Customized Chart to the Chart Wizard Gallery
- Repositioning Chart Elements with the Mouse
- Moving and Resizing the Plot Area
- + Working with Titles
- Adding Text Annotations
- + Working with Data Labels
- + Working with Axes
- Adding, Removing, and Formatting Gridlines
-
+
Formatting Data Series and Markers
- Assigning a Series to a Secondary Value Axis
- Using Two or More Chart Types in the Same Chart
- Changing the Series Order
- Toggling the Column/Row Orientation
- Changing Colors, Patterns, Fills, and Borders for Markers
- Adjusting Spacing in Two-Dimensional Column and Bar Charts
- Adjusting Data Point Spacing in Three-Dimensional Charts
- Adding Series Lines in Stacked Column and Bar Charts
- Changing Shapes in Three-Dimensional Column and Bar Charts
- Smoothing the Lines in Line and XY (Scatter) Charts
- Changing Line and Marker Styles in Line, XY (Scatter), and Radar Charts
- Adding High-Low Lines and Up and Down Bars to Line Charts
- Adding Drop Lines to Area and Line Charts
- Exploding Pie Slices and Doughnut Bites
- Using Formatting and Split Options in Pie-Column and Pie-Pie Charts
- Changing the Angle of the First Pie Slice or Doughnut Bite
- Working with Data Tables
- + Formatting Background Areas
- + Changing Three-Dimensional Viewing Angles
- + Chapter 26 Working with Chart Data
-
+
Chapter 27 Advanced Charting Techniques
-
+
Part 9 Managing Databases and Lists
- + Chapter 28 Managing Information in Lists
-
+
Chapter 29 Working with External Data
-
+
Chapter 30 Analyzing Data with PivotTable Reports
- A Simple Example
- + Creating a PivotTable
- + Pivoting a PivotTable
- Creating a PivotChart
- + Refreshing a PivotTable
- Selecting Elements of a PivotTable
- + Formatting a PivotTable
- Using Multiple Data Fields
- Renaming Fields and Items
- + Sorting Items
- Showing the Top or Bottom Items in a Field
- Hiding and Showing Inner Field Items
- Displaying the Details Behind a Data Value
- + Grouping and Ungrouping Data
- + Using Grand Totals and Subtotals
-
+
Changing a PivotTable’s Calculations
- Using a Different Summary Function
- Applying Multiple Summary Functions to the Same Field
- Using Custom Calculations
- Using Calculated Fields and Items
- Referencing PivotTable Data from Worksheet Cells
- + Creating a PivotTable from External Data
- Using a PivotTable to Consolidate Ranges
- Building a PivotTable from an Existing PivotTable
- + Printing PivotTables
- Using the PivotTable Web Component
-
+
Part 10 Automating Excel
- + Part 11 Appendixes
- About the Authors
Hey, you know your way around a spreadsheet—so now dig into Excel 2003 and really put your data to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and handy workarounds in concise, fast-answer format. It’s all muscle and no fluff. Discover the best and fastest ways to perform everyday tasks, and challenge yourself to new levels of Excel mastery!
Build on what you already know about Excel and quickly dive into what’s new
Learn how the experts design more powerful spreadsheets
Sharpen your core to advanced document editing and formatting skills
Perform calculations, analyze data, and build PivotTable reports
Drill into new Excel functions for statistical analysis
Create high-impact charts, including bubble, radar, and Gantt charts
Link and embed Excel data in other Microsoft Office programs
Capture, reuse, and share data by exploiting XML features
Use macros and Microsoft Visual Basic for Applications to automate Excel
CD features:
Complete eBook
Insider Extras—including 30-day trial edition of Spreadsheet Assistant add-in.
Catalog of select Excel resources with links to third-party tools and demos
Microsoft add-ins, demos, and trials, including Insider’s Guide to Microsoft Office OneNote eBook
Microsoft Computer Dictionary, Fifth Edition, eBook—10,000+ entries
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 O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's 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 booktech@oreilly.com.
Test the closed alpha on paperc.com
Book Details
Authors
Craig Stinson Craig Stinson and Mark Dodge Mark Dodge
Categories
Computers > Desktop Applications > Spreadsheets
Publishers
Publication year : 2009
License: All rights reserved ©
Times read: 0
