Book description
This book is fully updated for Excel 2007! Would you like to make Excel formulas easier to create and read, save time by customizing and automating your Excel worksheets, and learn how to present data with dramatic visual appeal? Then this "Visual Quick Tips" book is for you. This book will increase your productivity by providing you with shortcuts, tricks, and tips to help you work smarter and faster. It includes: straightforward task descriptions; succinct explanations; full-color screen shots; and numbered steps. You can also learn how to: add comments and styles to worksheets; sort and filter complex data; and import, export, and hyperlink content.
Table of contents
- Copyright
- Praise for Visual Books
- Credits
- About the Author
- 1. Boosting Efficiency
-
2. Working with Formulas and Functions
- 2.1. Quick Tips
- 2.2. Calculate with the Function Wizard
- 2.3. Define a Constant
- 2.4. Create Formulas That Include Names
- 2.5. Figure Out Loan Terms
- 2.6. Determine the Internal Rate of Return
- 2.7. Determine the Nth Largest Value
- 2.8. Create a Conditional Formula
- 2.9. Calculate a Conditional Sum
- 2.10. Add a Calculator
- 2.11. Find Products and Square Roots
- 2.12. Perform Time Calculations
- 2.13. Perform Date Calculations
-
3. Copying, Formatting, and More
- 3.1. Quick Tips
- 3.2. Check Formulas for Errors
- 3.3. Change Text to Numbers and Then Calculate
- 3.4. Convert a Row to a Column
- 3.5. Copy with the Office Clipboard
- 3.6. Specify How to Paste with Paste Special
- 3.7. Create Your Own Style
- 3.8. Copy Styles to Another Workbook
- 3.9. Conditionally Format a Worksheet
- 3.10. Track Changes While Editing
- 3.11. Consolidate Worksheets
-
4. Manipulating Records
- 4.1. Quick Tips
- 4.2. Enter Data with a Form
- 4.3. Filter Duplicate Records
- 4.4. Perform Simple Sorts and Filters
- 4.5. Perform Complex Sorts
- 4.6. Perform Complex Filters
- 4.7. Filter by Multiple Criteria in the Same Column
- 4.8. Subtotal Sorted Data
- 4.9. Chart Filtered Data Easily
- 4.10. Count Filtered Records
- 4.11. Look Up Information in a Worksheet
- 4.12. Define Data as a Table
- 4.13. Modify a Table Style
-
5. Explore Patterns in Data
- 5.1. Quick Tips
- 5.2. Create a PivotTable
- 5.3. Modify PivotTable Data and Layout
- 5.4. Compute Sub- and Grand Totals
- 5.5. Create a Calculated Field
- 5.6. Hide Columns or Rows in a PivotTable
- 5.7. Sort a PivotTable
- 5.8. Create a PivotChart
- 5.9. Describe Data with Statistics
- 5.10. Find the Correlation Between Variables
- 5.11. Explore Outcomes with What-If Analysis
- 5.12. Optimize a Result with Goal Seek
- 6. Creating Charts
- 7. Presenting Worksheets
- 8. Protecting, Saving, and Printing
- 9. Extending Excel
- 10. Customizing Excel
Product information
- Title: Microsoft® Office Excel® 2007 VISUAL™ Quick Tips
- Author(s):
- Release date: January 2007
- Publisher(s): Visual
- ISBN: 9780470089712
You might also like
book
Special Edition Using Microsoft® Office Excel® 2007
Special Edition Using Microsoft Office Excel 2007 will ease the upgrade path to the lastest version …
book
Special Edition Using® Microsoft® Office Excel 2003
Does your life play out in a spreadsheet? Are numbers in columns and rows what make …
book
Special Edition Using® Microsoft® Office Outlook® 2003
This is the ONLY book you need to achieve maximum productivity when using this messaging and …
book
Microsoft® Office Outlook® 2003 Inside Out
Take your Microsoft Outlook experience to the next level! This supremely organized reference packs hundreds of …