Complete Wireless Design or Microsoft Office Excel 2003 Quicksteps

Complete Wireless Design

Author: Cotter W Sayr

Easily design today's wireless systems and circuits

Design an entire radio system from the ground up instead of relying on a simple plug-in selection of circuits to be modified. Avoid an arduous trek through theory and mathematical derivations. Cotter Sayre's Complete Wireless Design covers wireless hardware design more thoroughly than any other handbook —and does it without burying you in math.

This new guide from today's bestselling wireless author gives you all the skills you need to design wireless systems and circuits. If you want to climb the learning curve with grace, and start designing what you need immediately, this reasonably priced resource is your best choice. It's certain to be the most-used reference in your wireless arsenal for designing cutting-edge filters, amplifiers, RF switches, oscillators, and more. You get:
Simplified calculations for impedance matching, analysis of wireless links, and completing a frequency plan
Real-world examples of designing with RFIC's and MMIC's
Full circuit and electromagnetic software simulations
More

Interesting textbook: Corn Free Cookbook and Survival Guide or The Herbal Home Remedy Book

Microsoft Office Excel 2003 Quicksteps

Author: John Cronan

Brace youself, because here comes QuickSteps: The fast, easy, accessible information on Excel 2003 in a full-color cookbook-style format. Provides answers to all of your How-do-I questions in a concise and meaningful way. Lengthwise page layout allows for easy page viewing. Useful tips and cautions are displayed in the margins so that they don’t break the flow of the quick steps themselves.

Series editors Martin and Carole Matthews each have more than thirty years of computing experience. They have written 57 U.S. editions of 32 titles, a number of which have been critically acclaimed. Among their more recent books are: Windows XP, A Beginner’s Guide; FrontPage 2002: The Complete Reference; Windows 2000, A Beginner’s Guide; Office 2000 Answers, Certified Tech Support; Windows 98 Companion; and Windows 98 Answers, Certified Tech Support.

Table of Contents:

	Acknowledgments	xv
	Introduction	xvii
Chapter 1	Stepping into Excel	1
	Start Excel	1
	Use the Start Menu to Load Excel	1
	Starting Excel	3
	Open a Workbook	4
	Opening a Workbook	5
	Add Identifying Information	5
	Find a Workbook	6
	Using Task Panes	7
	Personalize Excel	7
	Remove the Getting Started Task Pane	7
	Select a Toolbar to Display	7
	Show Toolbars on Two Rows	8
	Customize a Toolbar	8
	Using Toolbars	10
	Get Help	10
	Open Help	10
	Using Help	11
	Do Research	11
	End Your Excel Workbook	12
	Save a Workbook Automatically	12
	Save a Workbook Manually	12
	Save a Copy of Your Workbook	13
	Save a Workbook As a Template	14
	Close an Excel Session	14
Chapter 2	Entering and Editing Data	15
	Enter Data	15
	Enter Text	17
	Completing an Entry	18
	Enter Numeric Data	18
	Enter Dates	19
	Formatting Numbers	20
	Use Times	22
	Adding Data Quickly	24
	Edit Data	24
	Edit Cell Data	24
	Remove Cell Contents	25
	Selecting Cells and Ranges	26
	Copy and Paste Data	27
	Use Paste Special	27
	Find and Replace Data	28
	Verify Spelling	30
	Modify Automatic Corrections	31
Chapter 3	Formatting a Worksheet	33
	Work with Cells, Rows, and Columns	33
	Adding and Removing Rows, Columns, and Cells	34
	Adjust Row Height	34
	Adjust Column Width	35
	Hide and Unhide Rows and Columns	36
	Change Cell Borders	37
	Add a Background	39
	Add a Comment	40
	Change How Text Looks	40
	Use Fonts	40
	Using Comments	41
	Change Alignment and Orientation	42
	Use Styles	44
	Transfer Formatting	45
	Format Automatically	46
	Format Conditionally	47
	Arrange and Organize Worksheets	48
	Lock Rows and Columns	48
	Split a Worksheet	49
	View Worksheets from Multiple Workbooks	49
	Working with Worksheets	50
Chapter 4	Using Formulas and Functions	51
	Reference Cells	51
	Change Cell References in Formulas	52
	Change to R1C1 References	53
	Using Cell Reference Operators	54
	Name a Cell	54
	Go to a Named Cell	54
	Build Formulas	54
	Create a Formula	55
	Edit a Formula	56
	Move Formulas	57
	Copy Formulas	57
	Using Formulas	58
	Recalculate Formulas	58
	Use External References in Formulas	59
	Use Functions	60
	Enter a Function	61
	Using Functions	63
	Sum Numbers in Columns or Rows Quickly	63
	Find and Correct Errors	63
	Check for Errors	64
	Trace Precedent and Dependent Cells	64
	Watch a Cell	65
	Evaluate a Formula in Pieces	66
Chapter 5	Printing Data	67
	Set Up the Print Job	67
	Add Headers and Footers	68
	Formatting Headers and Footers	70
	Add Pictures to Headers and Footers	70
	Adjust Margins	71
	Select Page Orientation and Scaling	72
	Use Headings as Page Titles	73
	Choosing Worksheet Print Options	74
	Change the Order Pages Print	74
	Print Comments	74
	Choosing What to Print	75
	Print the Data	75
	Use Print Areas	75
	Preview the Print Job	76
	Output the Print Job	80
Chapter 6	Charting Data	83
	Build a Chart with the Chart Wizard	85
	Start the Chart Wizard	85
	Choose a Chart Type	86
	Select Data for Charting	87
	Modify Chart Items	90
	Choose a Chart Location	90
	Modify Existing Charts	92
	Create a Chart from the Chart Toolbar	92
	Selecting Chart Items	93
	Identify Items	93
	Add Titles	94
	Show or Hide Axes	95
	Add or Remove Gridlines	95
	Show or Hide a Legend	96
	Add Data Labels	97
	Display the Data Table	97
	Format Chart Items	98
	Add a Second Value Axis	99
	Create Your Own Chart Type	100
	Working with Charts	101
	Use Charts	101
	Add Pictures and Text	101
	Add a Trendline	103
	Print a Chart	104
	Work with Pie Charts	105
Chapter 7	Working with Graphics	107
	Add Graphics	107
	Add Pictures	109
	Organize Clip Art	112
	Use Clip Art	113
	Add AutoShapes	115
	Add Objects from Other Programs	115
	Working with Curves	116
	Add Special Effects to Text	118
	Create a Diagram	119
	Format and Modify Graphics	121
	Use Color Effects	121
	Using Handles and Borders to Change Graphics	122
	Resize and Rotate a Graphic	124
	Trim a Picture	125
	Positioning Graphics	126
	Combine Graphics by Grouping	126
	Create a Mirrored Image	127
	Keep Changes Intact	127
Chapter 8	Managing Data	129
	Build Lists	129
	Create a List	130
	Adding Rows and Columns to a List	131
	Enter and Manage Data Using a Form	132
	Locating Data Using a Form	134
	Add a Total Row	134
	Remove a List	134
	Validate Data	136
	Organize Data	139
	Sort Data by Columns	139
	Sort Data by Rows	140
	Create an AutoFilter	141
	Removing Filters	142
	Outline Data Automatically	142
	Outline Data by Grouping	143
	Add Styles to an Outline	143
	Using Outlines	144
	Acquire Data	144
	Convert Text to Data	144
	Add All Data from an Access Table	147
	Add Selective Data from an Access Table	147
	Get Data from the Web	150
	Change External Data	151
	Setting External Data Range Properties	152
Chapter 9	Analyzing and Sharing Data	153
	Get the Results You Want	153
	Use Goal Seek	154
	Compare Alternatives Using Scenarios	156
	Use Multiple Variables to Provide a Result	160
	Save Solver Results and Settings	162
	Changing Solver Settings	164
	Work with PivotTables	164
	Create a PivotTable	165
	Create the PivotTable Layout	166
	Using PivotTables	167
	Create a PivotTable Chart	168
	Work with Others	169
	Guard Workbooks with Passwords	169
	Using Passwords in a Shared Workbook	170
	Share a Workbook	170
	Merge Shared Workbooks	172
	Working with Changes in a Shared Workbook	173
	Protect a Shared Workbook	173
	Work with Views	174
	Protect Non-Shared Workbooks and Worksheets	175
Chapter 10	Extending Excel	177
	Use Excel with Web Technology	177
	Save or Publish a Workbook as a Web Page	178
	Save Workbook Items as a Web Page	182
	Publish Workbook Items	182
	Using Excel Interactive Web Pages	183
	Keep Web Pages Updated	183
	Package Excel Web Files	183
	Use Hyperlinks	186
	Plan for the Future	190
	Automate Excel	191
	Use Recorded Macros	191
	Edit a Macro	195
	Starting a Macro	196
	Communicate with Excel	196
	Listen to Excel	196
	Tell Excel What to Do	196
	Index	199