Microsoft Office Tutorials and References
In Depth Information
Book III: Excel 2013
Contents at a Glance
Chapter 1: Up and Running with Excel ..........................221
Creating a New Excel Workbook ................................................................ 221
Getting Acquainted with Excel ................................................................... 223
Entering Data in a Worksheet .................................................................... 225
Quickly Entering Lists and Serial Data with the AutoFill Command ..... 231
Formatting Numbers, Dates, and Time Values ........................................ 232
Conditional Formats for Calling Attention to Data .................................. 235
Establishing Data-Validation Rules ........................................................... 236
Chapter 2: Refining Your Worksheet ...........................239
Editing Worksheet Data .............................................................................. 239
Moving Around in a Worksheet ................................................................. 240
Getting a Better Look at the Worksheet ................................................... 241
Comments for Documenting Your Worksheet ......................................... 244
Selecting Cells in a Worksheet ................................................................... 246
Deleting, Copying, and Moving Data ......................................................... 247
Handling the Worksheets in a Workbook ................................................. 247
Keeping Others from Tampering with Worksheets ................................ 249
Chapter 3: Formulas and Functions for Crunching Numbers .......253
How Formulas Work .................................................................................... 253
The Basics of Entering a Formula .............................................................. 258
Speed Techniques for Entering Formulas ................................................ 259
Copying Formulas from Cell to Cell ........................................................... 264
Detecting and Correcting Errors in Formulas .......................................... 266
Working with Functions .............................................................................. 269
Chapter 4: Making a Worksheet Easier to Read and Understand ...275
Laying Out a Worksheet ............................................................................. 275
Decorating a Worksheet with Borders and Colors .................................. 280
Getting Ready to Print a Worksheet .......................................................... 285
Chapter 5: Advanced Techniques for Analyzing Data .............293
Seeing What the Sparklines Say ................................................................. 293
Managing Information in Lists ................................................................... 294
Forecasting with the Goal Seek Command ............................................... 298
Performing What-If Analyses with Data Tables ....................................... 299
Analyzing Data with Pivot Tables .............................................................. 303
 
Search JabSto ::




Custom Search