My Account
Log in Registration
All
Cart
Highlights
Fiction Books
Non-Fiction Books
Children's Books
Rare Books
Music
DVD & Blu-Ray
Video Games
Category
Wishlists
Cart
All
Free Shipping in Australia
Trustpilot
Proud to be B-Corp

Brilliant Microsoft Excel 2007 Pocketbook J. Peter Bruzzese

Brilliant Microsoft Excel 2007 Pocketbook By J. Peter Bruzzese

Brilliant Microsoft Excel 2007 Pocketbook by J. Peter Bruzzese

Reviews:
15,49 $
Condition - Very Good
Only 1 left
Very Good

Brilliant Microsoft Excel 2007 Pocketbook Summary

Brilliant Microsoft Excel 2007 Pocketbook by J. Peter Bruzzese

This succinct yet comprehensive guide to Excel 2007 highlights all the latest features, and is packed with useful tips, tricks and hints to help you to use Excel more efficiently and successfully. It is ideal for the completely new Microsoft Excel user, and those upgrading from Office 2000 or 2003. Short, easy-to-follow tutorials help the reader to instantly grasp the essential functions of Excel, including creating macros, using conditional formatting and organising data with SmartArt diagrams, tables and charts. Keenly priced and with an attractive two-colour text design and in a handy pocket or bag-sized format, these books will be an indispensable guide for anyone who wants to improve or master their abilities without buying a bulky or expensive manual. The Windows Vista and Office 2007 Pocket books have entirely new, and substantially more content than the previous editions, which makes then even better value at just GBP8.99. With their bold new jacket designs they will stand out on any shelf.

About J. Peter Bruzzese

Joli Balew is a professional writer, technology trainer, network consultant, and a Microsoft Windows Expert Zone Columnist. Some of her previous jobs include technical writing, education content consulting, PC technician, network administrator, high school algebra teacher, and MCSE instructor. She earned her MCSE, MCT and A+ certifications in less than 14 months. She is the author of Windows XP Professional: The Ultimate User's Guide and over 20 other technical books.

Table of Contents

Contents 1 Getting Started with Excel 2007 Getting Familiar with the Excel 2007 Interface Customise the Excel 2007 Interface: Quick Access Toolbar Using Shortcut Keys in Excel 2007 Working with Workbooks Start a New Workbook Open an Existing Workbook Saving and Naming Your Workbooks Saving Your Workbook under a Different Name or File Format Saving Your Workbook as a PDF or XPS Document Working with Worksheets Navigating Worksheets Rename or Delete a Worksheet Hide a Worksheet Move or Copy a Worksheet Change Your Worksheet Tab Colours Using Excel Templates Closing and Exiting Excel 2 Working with Your Excel Spreadsheet Entering Data into Your Worksheet Insert Data into Cells Navigate to a Specific Cell Worksheet Navigation Tricks Go To Special Insert Different Types of Data Insert Text Working with Comments Insert Numerical Data Insert Dates and Times 3 Automatic Data Entry Methods Selecting Ranges Select a Contiguous Range Select a Random Range Name a Range Insert Data into Multiple Cells Quickly Use the Clipboard to Enter Data Use Ctrl+Enter to Enter Data Use AutoFill to Enter Data Use AutoFill to Enter a Series of Data Creating Custom Series AutoComplete 4 Formatting Cells Formatting Using the Font Grouping Formatting Using the Format Cells Dialogue Box Formatting Using the Alignment Grouping Alignment Options from the Format Cells Dialogue Formatting Using the Number Grouping Number Options from the Format Cells Dialogue Format Row Height and Column Width Hide/Unhide Rows and Columns 5 Excel Styles and Themes Using a Cell Style Create Your Own Cell Styles Create a New Style Modify an Existing Style Using Table Styles Apply a Table Style from the Gallery Create Your Own Table Style Apply, Modify, Duplicate and Delete a Table Style Table Style Options Using Themes 6 Conditional Formatting What is Conditional Formatting? Formatting a Data Bar Apply Conditional Formatting: A Data Bar Advanced Data Bar Configuration Format with Colour Scales and Icon Sets Colour Scales Icon Sets Highlight Cells Rules Top/Bottom Rules Manage Multiple Conditional Formatting Rules 7 Basic Excel Formulas What is a Formula? Operators Combining Operators Properly Enter and Edit Formulas View Your Formula View All Formulas within Your Worksheet Edit Formulas UseName Ranges within Your Formulas 8 Using Basic Excel Functions What is a Function? Insert a Function Five Commonly Used Functions Using AutoSum Caveats to AutoSum Use the AutoSum Down Arrow Status Bar Function Results 9 Understanding Excel Function Groups The Function Library Financial Functions Financial Arguments Logical Functions Text Functions Date and Time Functions Lookup and Reference Functions The Lookup Wizard Maths and Trig Functions Additional Functions 10 Troubleshoot Function Errors Identifying Errors Common Formula Error Codes Automated Error Correction Formula AutoCorrect Formula Auditing Evaluate Your Formula Additional Auditing Tools Using the Watch Window Formula Error Checking Options 11 Using Tables to Sort and Filter Data Sorting Your Data Ascending/Descending Data Sorts (Using Sort & Filter) Sorting Data Using Table Column Headers Performing Custom Sorts Sort by Multiple Columns Sort by Day of the Week or Month Filter Your Data Custom Filters 12 Creating Pivot Tables Understanding Pivot Tables Create a Simple Pivot Table Update Your Pivot Table 13 Protecting Your Workbook and Worksheets Protect Your Data Password Protect Your Entire Workbook Workbook Protection Settings Protect Specific Aspects of Your Workbook Lock or Unlock Cells Protect Your Worksheets Hiding Cells (aka Hiding Formulas) Additional Protection Tools Information Rights Management (IRM) 14 Changing the View Worksheet Views Changing Your Workbook Views Different Workbook Views Zoom Controls Additional Zoom Features Show/Hide Options Window Options Freeze Your Headings Splitting the Worksheet Window Additional Window Options 15 Insert Illustrations and SmartArt Using Illustrations in Your Excel Worksheets Insert Pictures Insert Clip Art Insert Shapes Formatting Your Pictures, Clip Art and Shapes Picture and Clip Art Formatting Options Shape Formatting Options Adding SmartArt into Your Worksheets 16 Basic Charting Excel Chart Building Understanding Chart Types Chart Terminology Create a Simple Chart Create a Column Chart Create a Pie Chart Making Some Design Changes Changing the Type of Data 17 Advanced Chart Formatting Changing Labels Adding a Chart Title Adding Labels to Your Axes Changing Your Legend Adding Data Labels Include the Data Table Changing Colours and Backgrounds Changing Fills Changing the Chart Background Make a Combination Chart 18 Printing Your Worksheets Manually Adjusting the Print Structure Define Your Print Area Using Print Preview Changing Your Print Area Portrait or Landscape? Adjusting Page Setup Options The Page Layout Tab The Margins Tab The Header/Footer Tab The Sheet Tab Printing Your Worksheet 19 Sharing Your Documents Prepare Options Document Properties Inspect Document Encrypt Document Mark as Final Run Compatibility Checker 20 Proofing, Excel Options and Help Proofing Tools Spell-check Research and Thesaurus Translate Excel Options Popular Formulas Proofing Save Advanced The Additional Settings Help Tools Excel 2007: The Journey is Just Beginning

Additional information

GOR001531401
9780132059220
0132059223
Brilliant Microsoft Excel 2007 Pocketbook by J. Peter Bruzzese
J. Peter Bruzzese
Used - Very Good
Paperback
Pearson Education (US)
2007-08-09
272
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us

Customer Reviews - Brilliant Microsoft Excel 2007 Pocketbook