|
Brilliant Excel 2007 Pocket Book
Exactly what you need to know - just when you need it!
Brilliant Excel 2007 Pocket Book is a handy, visual quick-reference guide to the most common features, tasks and problems, that you will come across when using Word 2007 in any day-to-day situation at home or in the office.
brilliant Microsoft Excel 2007 Pocket Book
Brilliant
Excel 2007 Pocket Book delivers the answers you need when you are faced with an unfamiliar or problematic task in Excel 2007. Short, concise explanations and a highly visual, step-by-step approach make it really easy to learn and master any task or problem that you come across Keep it on your desk, in your bag - or even in your pocket - and you will always have the answers you need, just when you need them.
Brilliant Excel 2007 includes:
* Foolproof step-by-step instructions for accomplishing specific tasks
* Numerous screenshots illustrating every step
* Jargonbuster boxes explaining new or unfamiliar terms in plain English
* Timesaving tips to give you ideas on cutting corners and avoiding confusion
* Additional information on key topics to expand your knowledge of a particular feature or concept.
* Important information boxes identifying areas where new users often run into trouble, and offering practical hints and solutions to these problems
Brilliant Pocket Books are handy, accessible resources that you will turn to time and time again when faced with a problem or an unfamiliar task and need an answer at your fingertips.
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
|
