Many 'Beginner Oriented' Excel How-To books say they can bring you
from zero to familiar with the important features of Microsoft Excel - '**Don't Fear The Spreadsheet**' actually
will. Why are we so confident? Because the questions in this book
were asked by an absolute Excel Beginner - Tyler Nash - with the
answers provided by three (3) Microsoft MVPs specializing in and
dedicated to teaching others Microsoft Excel, from the ground up -
Kevin Jones, Tom Urtis and Bill Jelen.

This book is
designed for the person in level 1 & 2. It will raise your
proficiency to a solid Level 4.

What does "Don't
Fear The Speadsheet" cover? Have a look at the Table of Contents!

Chapter 1 -
Excel Basics 1

Why Do We Need Excel? 1

What ‘Practical’ uses
Does Excel Have? 2

What is the Intersection
of a Row and Column Referred to As? 3

What’s a Workbook? 4

How Many Worksheets come
in a Workbook? 5

How Do I Insert New
Worksheets into a Workbook? 5

What’s With The Masking
Tape? 6

How Can I QUICKLY Erase
an Entire Sheet? 8

How can I QUICKLY Delete
an Entire Sheet From the Workbook? 8

How Would I Go About
Deleting Several Cells at The Same Time? 9

Can I Reset Some Cells in
a Worksheet While Keeping Others? 10

What Does ‘Freeze Panes’
Do? 12

What is the Native File
Format For Excel? 14

Typing Just Enough
Characters To Fill a Cell, Then Moving to Next Cell 14

I Can’t Select the Right
Cell 15

My Laptop Screen is Too
Small I Can’t Manage to Click on the Right Cell 15

How can I Add More Rows
or Columns to My Spreadsheet? 15

What Allows Me to Access
Popular Commands From Any Ribbon Tab? 16

How Do I Use the Arrows
Keys to Navigate More Efficiently? 17

How can I See a List of
Worksheet Names, and Quickly go to a Sheet if I Cannot See its Sheet
tab? 19

How Can I Quickly Move
Between Several Excel Files That I Have Open? 20

When Selecting a Range,
The Corner That I Started in is not Also Highlighted 20

How Do I Select a Large
Area of Cells Without Having to Click and Drag? 21

Can I Cut and Paste Cells
From One Worksheet Into Another? 22

Is it Possible to Change
How Often Excel AutoSaves? 22

How do I Add Headers and
Footers to My Worksheet When I Print it? 23

Old School Print Titles
at Top of Each Page 25

How Do I Center My Work
in Excel? 26

Print to Blueprint
Printer Then Reduce on Copier Three Times 28

Chapter 2 –
Formatting 29

Is There a Way to Make a
Sheet with Only a Few Cells and Columns? 29

That Dotted Line Isn’t
There For Centering! 38

How Do I Put the Path and
File Name in the Footer? 38

Word Wrap Woes 39

How can I Merge Multiple
Cells into a Single Cell? 41

How Can I Copy Cell
Formatting? 42

How Can I Remove Cell
Formatting? 44

Is it Possible to Change
the Color of a Worksheet Tab? 45

Can I Customize Color?
46

All My Numbers Are
Corrupt! 49

Can I Delete Data From a
Spreadsheet without Changing the Formatting? 52

How Do I Set Up Cells to
Show Dollars and Cents? 52

I Type 0345 in a Cell and
Excel Changes it to 345 54

When I Enter 3680, Excel
Leaves Off the Zero 55

How can I Show My Numbers
as Thousands or Millions? 58

How Can I Remove The
Lines From Excel? 59

How can I Insert Rows or
Columns Within My Existing Data? 60

Can I Make Part of the
Text in a Cell Red? 61

Can I Double Space Lines
in Excel? 62

Are There any other
Formatting Tips? 63

Chapter 3 -
Formulas I 65

Back to Top...

When is it OK to use a
Calculator with Excel? 65

My Coworker Used an
Adding Machine to Add a Column of 100 Numbers! 65

How Do I Total All the
Rows and Columns in My Table of Numbers? 66

I Added Up a Column of
Numbers with a Formula of =A2+A3+A4+A5+A6+ A7+A8+A9+A10 67

How Can I Average a Set
of Numbers? 69

Can I Change the Default
Setting for my AutoSum? 69

Do I Have To Put the Sum
Formula In the Same Row or Column As the Data? 71

Can My Formula Be Open
Ended To Accomodate New Numbers? 74

How can I Add up Numbers
in One Column Depending on What is in Another Column? 78

My Numbers Aren’t Adding
Up! 79

Why Isn’t AutoSum
Working? 80

Tab Tab Tab Tab Tab Tab
Shift-Tab Shift-Tab Shift-Tab Shift-Tab Shift-Tab Shift-Tab 81

How Can I Use Excel as a
Calculator? 82

How do I Write Equations
Using Different Numbers in Different Cells? 83

Using the QuickSum
Instead of AutoSum 83

Is There a Difference
Between Typing in the Cell Itself and Typing in the Formula Bar? 84

How do I Build a
Formula? 85

Is There a Way to Do
Exponents in Excel? 89

Why Doesn’t the COUNT
Function Count All Non-Blank Cells? 90

Chapter 4 -
More Advanced Topics 91

What are Some Useful
Shortcut Keys? 91

What is a Simple Way to
Compare Two Different Ranges of Data? 93

What Does the Format
Painter Do? 94

Does Splitting One
Worksheet Allow Me To Use One Spreadsheet As Two? 96

Why Would I Ever Use the
Shapes? 97

How Can I Click a Cell
That Has a Hyperlink, Without Following the Link? 99

Why is There a Green
Triangle in The Top Left of A Cell? 100

How can I Find or Replace
an Asterisk or Question Mark on My Worksheet? 101

How Do I Make a Cell Show
an Abnormality in a Spreadsheet? 102

How Do I Undo Conditional
Formatting? 103

What Are the Auto-Fill
Options? 104

How Can I Hide Some
Columns? 106

How Do I Unhide The
Columns? 107

How Do I Unhide One
Column But Not The Others? 107

How can I Delete Rows
with Blank Cells? 108

I Need to Increase all
Numbers in a Particular Column by 5? 110

How Do I Set the Same
Page Setup For All Sheets in my Workbook? 111

What are Cell Comments
and When Should I Use Them? 112

Can I Resize a Comment?
113

Use Visible Comments to
Guide the Person Using Your Worksheet 113

Can I Change the Default
Color of All Future Comments? 114

Track Changes - What Does
it do, What Does it Not do? 114

Can I Require a Password
to Open an Excel File? 115

What to do if I Forgot my
Password for a Secured Workbook? 116

How do I Make My Workbook
Read Only so it Can’t be Changed? 116

Why does Excel ask Me to
Save When Nothing has Changed? 118

What is a Macro? 118

What Is an Add-In? 119

Can You Set Up Data to
Auto-Delete After a Certain Amount of Time Has Passed? 119

Can Excel Talk? 120

Chapter 5 –
Charts 121

How do I Convert My Data
Into a Chart? 121

How Do I Go About Setting
Up a Chart and a Table Simultaneously? 122

Chapter 6 -
Formulas II 123

Back to Top...

I Typed 12-13 in a Cell
and Excel Changed it to December 13? 123

I Want to Move to Level
3 125

How Can I Make Excel
Round Numbers? 131

I Have to Divide This Row
By The Mean of All Rows 133

How can I Strip Away the
Left or Right Part of a Cell? 136

How can I Separate
People’s First and Last Names? 137

How can I Fill Empty
Cells With the Entry From Above? 139

What are Your Favorite
Excel Functions? 141

Why Don’t the Formulas in
My Workbook Re-calculate? 142

Is There a Way to Find
the Value of Data or Numbers in Several Different Spreadsheets? 144

Excel Doesn’t Recognize
My Dates? 144

Is it Possible to Make
Excel Auto-Date? 145

How Can I Set Up Dates to
Display The Way I Want After Importing? 146

How can I Combine a Date
with Words in a Cell, and Make it Look Like a Date? 147

How can I Add or Subtract
Days, Months, or Years from a date? 148

Is It Possible to Find
the Date for a Particular Day in Excel? 149

How can I Calculate Time
and Show a Result That Makes Sense? 151

Chapter 7 -
Other Applications 153

Can I Transfer Excel
Files from Excel 2003 to Excel 2010? 153

How do I Import Files
into Excel? 153

How Can I Transfer Data
from Excel to a Word Document? 156

After I Transfer an Excel
Range to PowerPoint, Can I Edit the Data? 157

Chapter 8 -
Every Way To 159

Tell Me Every Way to 159

Tell Me Every Way to
Change Column Widths 159

Tell Me Every Way to Copy
Cells 160

Tell Me Every Way to
Paste Cells 160

Tell Me Every Way to Copy
a Formula Down a Column 161

Tell Me Every Way to
Convert Formulas to Values 162

Tell Me Every Way to
Total a Column 163

Tell Me Every Way to
Format Every Other Row 164

Tell Me Every Way to Turn
Data Sideways 167

Chapter 9 -
Data Analysis Intro 171

Back to Top...

Introduction to the Data
Analysis Chapter 171

How Do I Sort Data? 171

What is the Filter on the
Data tab? 172

Why Can’t I Filter to All
of The Arizona Records? 174

How can I get Just the
Unique Items From a List? 178

How do I Remove
Duplicates? 180

My Boss Wants Me to Sort
by Customer and Add Totals After Each Customer 180

How Can I Bold the
Numbers in My Subtotaled data? 183

What is a Pivot Table?
185

Chapter 10
- Formulas III 189

How Can I Make a Decision
in a Formula? 189

What is VLOOKUP and How
can I use it? 190

How can I Look up a Value
Across a Row Instead of Down a Column? 192

How can I Avoid Those
Ugly Formula Errors Like #DIV/0! and #N/A? 193

How Do I Convert Numbers
to Words? 194

Why Does Excel ask to
Update Links When There Aren’t any Links in My Workbook? 195

How Can I Track Billable
Hours in a Weekly Time Sheet? 196

Chapter 11
- Other Resources 201

I Have a Question That is
not Answered in This Book 201

What Should I do After I
Have Mastered Every Technique in This Book? 202

Index 203

Quick
Reference 208

Excel
Aptitude Test 209

To Learn
More 210

Back to Top...