Flylib.com
Sams Teach Yourself Microsoft Office Excel 2003 in 24 Hours (Sams Teach Yourself in 24 Hours)
Sams Teach Yourself Microsoft Office Excel 2003 in 24 Hours (Sams Teach Yourself in 24 Hours)
ISBN: 1435276337
EAN: 2147483647
Year: 2003
Pages: 279
Authors:
Trudi Reisner
BUY ON AMAZON
Main Page
Table of content
Copyright
About the Author
Acknowledgments
We Want to Hear from You
Introduction
Conventions Used in This Book
Part I: Excel Basics
Hour 1. Getting Started
What Is Excel?
Planning Strategies for Excel Worksheets
Starting Excel
Looking at the Excel Screen
Working with Toolbars
Using Excel Menus and Dialog Boxes
Working with Dialog Boxes
Examining the Task Pane
Getting the Most Out of Help
Moving Within a Workbook
Summary
QA
Hour 2. Entering Data
Typing Data in a Cell
Entering Labels
Automating Your Work
Creating a Simple Spreadsheet
Entering Values
Adding Dates and Times
Copying from Cell to Cell
Making Changes to the Worksheet
Inserting and Deleting Cells
Working with Rows and Columns
Summary
QA
Hour 3. Organizing Your Files
Saving Your Workbook
Saving Your Work for the First Time
Saving Your Work Later
Understanding Excel Filenames
Protecting Your Work with AutoRecover
Saving an Existing Workbook with a New Name
Other Save Options
Rearranging Your Files
Summary
QA
Hour 4. Managing Your Files and Workbooks
Creating a Blank Workbook
Opening an Existing Workbook
Making Use of the Getting Started Task Pane
Searching for the Right File
Working with Workbooks and Worksheets
Getting a View of the Workbook
Using Ranges
Changing Worksheet Views
Workbook and Worksheet Navigation Tools
Summary
QA
Hour 5. Letting Excel Do the Math
Why Use Formulas?
How Formulas Work
Creating a Simple Formula
Referencing Cells
Using AutoSum
Using Range Names in Formulas
Using Relative and Absolute Addressing
Copying Formulas
Troubleshooting Formula Errors
Summary
QA
Hour 6. Using Excel Templates
What Is a Template?
Exploring Excel Templates
Creating Your Own Template
Saving a Worksheet as a Template
Summary
QA
Hour 7. Printing Your Workbook
The Value of Hard Copy
Checking Your Spelling Before You Print
Setting Up Your Page
Changing the Orientation and Paper Size
Adding Headers and Footers
Choosing What to Print
Controlling Where Pages Break
Printing What You Want
Summary
QA
Part II: Dress Up Your Work
Hour 8. Changing the Appearance of Text
Formatting Your Text
Treating Numbers Like Text
Using Fonts
Changing Cell Alignment
Rotating Cell Entries
Centering a Heading
Controlling the Flow of Text
Copying Formatting with the Format Painter
Removing Formatting
Adjusting Column Width
Altering Row Height
Finding Data
Replacing Data
Working with Comments
Summary
QA
Hour 9. Changing the Look of Values
What Formats Are Available?
Choosing a Number Style
Working with Decimal Places
Designing Custom Numeric Formats
Formatting Conditionally
Hiding Zeros
Working with Dates
Summary
QA
Hour 10. Adding Borders, Colors, and Fills
Have It Your Way
Changing the Color of Cell Entries
Adding Borders to Cells and Ranges
Working with Fills, Shading, and Color
Formatting with AutoFormat
Summary
QA
Part III: Interactive Data Makes Your Worksheet Come Alive
Hour 11. Working with Graphics Objects
What Is a Graphics Object?
Why Use Graphics?
Using the Drawing Toolbar
Adding Clip Art
Adding Special Effects with WordArt
Manipulating Graphics Objects
Combining Multiple Objects
Deleting Graphics Objects
Summary
QA
Hour 12. Adding a Chart
Why Use a Chart?
Chart Elements
Types of Charts
Creating Charts with the Chart Wizard
Working with Charts
Chart Formatting Techniques
Creating a Pie Chart
Summary
QA
Hour 13. Other Types of Charts
Creating Other Chart Types
Creating an Excel Diagram
Summary
QA
Part IV: Advanced Excel Techniques
Hour 14. Working Smarter
Working with Multiple Workbooks
Working with Formulas That Reference Other Workbooks and Worksheets
Creating Links Between Worksheets and Workbooks
Customizing Excel
Protecting Your Data
Protecting Your Files
Saving Your Workspace
Using Excel Add-ins
Summary
QA
Hour 15. Using Functions
Advantages of Excel Functions
Using the Insert Function Dialog Box and Formula Palette
Financial Functions
Date and Time Functions
DATEVALUE
Logical Functions
How to Use Lookup Functions
Summary
QA
Hour 16. Auditing and Validating Your Work
Auditing Workbooks
Validating Input
Using Named Constants and Formulas
Defining Label Ranges
Summary
QA
Hour 17. Analyzing Your Data
Using the Scenario Manager
Using the Goal Seek Tool
Summary
QA
Hour 18. Working with Pivot Tables
What Is a Pivot Table?
Learning the PivotTable Lingo
Building a Pivot Table
Modifying a Pivot Table
Working with Pivot Table Reports
Building a PivotChart
Creating a Chart from PivotTable Report Data
Summary
QA
Hour 19. Integrating Excel with Other Office Applications
Using Objects in Excel
Inserting Objects
Using Hyperlinks with Other Office Documents
Sending Your Document Via Email with Outlook
Summary
QA
Hour 20. Automating Tasks with Macros and Smart Tags
What Is a Macro?
Creating a Macro
Running the Macro
Fixing Macro Errors
Attaching a Macro to a Toolbar
Using a Macro in Other Workbooks
Understanding Macro Viruses
Working with Smart Tags
Summary
QA
Part V: Creating and Using Databases in Excel
Hour 21. Building an Excel Database
Basic Database Concepts
Starting with a Plan
Creating a Database
Entering and Adding Data
Searching for Data
Saving the Database
Summary
QA
Hour 22. Working with Your Database
Working with Subtotals
Using Advanced AutoFilter Functions
Setting a Criteria Range
Retrieving Data with the Query Wizard
Choosing a Data Source
Saving Data Queries
Summary
QA
Part VI: At the Office and on the InternetIntranet
Hour 23. Sharing Your Work with Your Colleagues
What Is a Network?
Sharing Workbooks
Setting Up a Shared Workbook
Opening a Shared Workbook
Tracking Changes in Your Worksheet
Summary
QA
Hour 24. Worksheets and the Web
What Is the Internet?
Using Internet Explorer 6.0
Searching on the Web
Adding a Hyperlink to a Worksheet
Saving Excel Documents to the Web
Posting Your Worksheet to the Web
Summary
QA
Index
Index SYMBOL
Index A
Index B
Index C
Index D
Index E
Index F
Index G
Index H
Index I
Index J
Index K
Index L
Index M
Index N
Index O
Index P
Index Q
Index R
Index S
Index T
Index U
Index V
Index W
Index X
Index Y
Sams Teach Yourself Microsoft Office Excel 2003 in 24 Hours (Sams Teach Yourself in 24 Hours)
ISBN: 1435276337
EAN: 2147483647
Year: 2003
Pages: 279
Authors:
Trudi Reisner
BUY ON AMAZON
Lotus Notes and Domino 6 Development (2nd Edition)
Working in the Application Design Environment
Working with Fields
Creating a View
Adding and Editing View Columns
What Its All About: XML Exposed
Cisco IP Communications Express: CallManager Express with Cisco Unity Express
Benefits of Cisco IPC Express
Cisco CME Architecture
Summary
Cisco CME GUI Customization Via XML
Configuring the Cisco UE AA
Cisco IOS in a Nutshell (In a Nutshell (OReilly))
The New Cisco IOS Packaging Model
Loading Image Files Through the Network
The Null Interface
Route Filtering
Appendix A Network Basics
Data Structures and Algorithms in Java
Iterators
Quicksort
Binary Search Trees
Interacting with Files
C. Summation Formulae
Quartz Job Scheduling Framework: Building Open Source Enterprise Applications
The Hello, World Quartz Project
Understanding Quartz Triggers
Cron Triggers and More
Registering Your Plug-Ins
Configuring the Quartz ThreadPool
Comparing, Designing, and Deploying VPNs
Advanced MPLS Layer 3 VPN Deployment Considerations
Implementing QoS for MPLS Layer 3 VPNs
Using Clientless SSL Remote Access VPNs (WebVPN) on the Cisco VPN 3000 Concentrator
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies