Excel Portable Genius

Acknowledgments vii
 
Introduction xiv
 
Chapter 1 How Do I Start Using Excel? 2
 
Starting and Exiting Excel 4
 
Taking a Look Around 5
 
Reviewing key screen features 5
 
Workbooks versus worksheets 8
 
Changing views 8
 
Zooming 10
 
Working with Files 11
 
Creating a blank file 11
 
Exploring templates 12
 
Opening an existing file 13
 
Switching to another file 14
 
Making Your First Cell Entries 16
 
Moving around the sheet 16
 
Text and values 17
 
Dates and times 19
 
Number formatting on the fly 20
 
Making Selections 21
 
Understanding cells and ranges 22
 
Selecting a range 22
 
Selecting a row or column 23
 
Working with Sheets 24
 
Adding, renaming, and jumping to a sheet 25
 
Moving or copying a sheet 26
 
Saving and Closing a File 27
 
Chapter 2 How Do I Make Changes to My Sheet? 30
 
Cell Editing Basics 32
 
Making changes 32
 
Commenting when editing 33
 
Clearing cell contents 33
 
Using Undo and Redo 34
 
Spell-checking your work 35
 
Copying or Moving a Range 35
 
Using Paste Special 37
 
Using Auto Fill and Filling Series 38
 
Inserting and Deleting Rows, Columns, and Cells 41
 
Creating Range Names 44
 
Using the Name box 45
 
Using the New Name dialog box 46
 
Assigning multiple range names at once 47
 
Deleting a range name 48
 
Using Find and Replace 50
 
Freezing Rows and Columns On-Screen 51
 
Chapter 3 How Do I Add Up the Numbers with Formulas? 54
 
Entering a Basic Formula 56
 
Typing the formula 56
 
Cell and range references in formulas 57
 
Using the mouse to save time 58
 
Dealing with minor errors 60
 
Learning More About Operators 60
 
Understanding Order of Precedence

Lisa A. Bucki is an author, trainer, and content creator who's been educating others about computers and software since 1990. She's written dozens of books, provided marketing and training services to her clients, and written online tutorials. She is the co-founder of 1x1 Media.
Fun, hip, and straightforward, the Portable Genius series gives forward-thinking computer users useful information in handy, compact books that are easy to navigate and don't skimp on the essentials. Collect the whole series and make the most of your digital lifestyle.