Excel Quick and Easy

MICHAEL ALEXANDER is a senior consultant at Slalom Consulting with more than 15 years’ experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel and has been named Microsoft Excel MVP for his contributions to the Excel community. DICK KUSLEIKA has been working with Microsoft Office for more than 20 years. He was formerly a Microsoft MVP, having been awarded 12 consecutive years. Dick has written several books about Excel and Access.

• Chapter 1: Introducing Excel 1Understanding What Excel Is Used For 1Understanding Workbooks and Worksheets 2Moving Around a Worksheet 3Chapter 2: Creating Your First Excel Workbook 7Getting Started on Your Worksheet 7Filling In the Month Names 7Entering the Sales Data 8Formatting the Numbers 9Making Your Worksheet Look a Bit Fancier 10Summing the Values 11Creating a Chart 11Printing Your Worksheet 12Saving Your Workbook 12Chapter 3: Entering and Editing Worksheet Data 15Exploring Data Types 15Entering Text and Values into Your Worksheets 17Entering Dates and Times into Your Worksheets 19Modifying Cell Contents 20Chapter 4: Introducing Formulas and Functions 31Understanding Formula Basics 31Entering Formulas into Your Worksheets 38Editing Formulas 43Using Cell References in Formulas 44Chapter 5: Moving Beyond Formula Basics 49Introducing Formula Variables 49Correcting Common Formula Errors 52Using Advanced Naming Techniques 54Working With Formulas 59Chapter 6: Performing Basic Worksheet Operations 61Learning the Fundamentals of Excel Worksheets 61Working With Rows and Columns 69Chapter 7: Working with Excel Ranges 75Understanding Cells and Ranges 75Copying or Moving Ranges 85Using Names to Work with Ranges 97Chapter 8: Working with Tables 103Understanding a Table’s Structure 103Creating a Table 105Adding Data to a Table 106Sorting and Filtering Table Data 107Changing the Table’s Appearance 113Using Formulas in Tables 116Chapter 9: Formatting Worksheets 121Getting to Know the Formatting Tools 121Formatting Your Worksheet 124Using Named Styles for Easier Formatting 135Understanding Document Themes 139Chapter 10: Using Conditional Formatting 145Specifying Conditional Formatting 145Using Graphical Conditional Formats 146Creating Formula-Based Rules 150Conditional Formatting Formula Examples 152Working with Conditional Formats 155Chapter 11: Getting Started with Excel Charts 157What Is a Chart? 157Basic Steps for Creating a Chart 164Modifying and Customizing Charts 170Chapter 12: Understanding Chart Types 175Choosing a Chart Type 175Newer Chart Types for Excel 187Chapter 13: Printing Your Work 197Doing Basic Printing 197Changing Your Page View 198Adjusting Common Page Setup Settings 202Adding a Header or a Footer to Your Reports 211Appendix: Excel Keyboard Shortcuts 215