Excel Portable Genius, Portable Genius by Lisa A. Bucki -- Read -- Imperial Library of Trantor

Index

Cover Table of Contents Title Page Introduction 1 How Do I Start Using Excel?

Starting and Exiting Excel Taking a Look Around Working with Files Making Your First Cell Entries Making Selections Working with Sheets Saving and Closing a File

2 How Do I Make Changes to My Sheet?

Cell Editing Basics Copying or Moving a Range Using Paste Special Using Auto Fill and Filling Series Inserting and Deleting Rows, Columns, and Cells Creating Range Names Using Find and Replace Freezing Rows and Columns On‐Screen

3 How Do I Add Up the Numbers with Formulas?

Entering a Basic Formula Learning More About Operators Understanding Order of Precedence Making a Cell or Range Reference Absolute Rather Than Relative Showing Formulas in Cells Using Other Formula Review Techniques

4 When Do I Need to Include a Function?

Understanding Functions Using AutoSum on the Home or Formulas Tab Typing a Function in a Formula Using the Formulas Tab to Insert a Function Using Range Names in Formulas Reviewing Some Essential Functions

5 How Do I Use Formatting to Enhance My Worksheet?

Changing the Number or Date Format Changing Cell Formatting Working with Borders and Shading Using Styles Clearing Formatting Understanding Themes Working with Column Width and Row Height Using Conditional Formatting to Highlight Information

6 How Do I Use Graphics in Excel?

Inserting Simple Graphics Selecting and Formatting Graphics Inserting WordArt Combining and Creating Your Own Graphics Creating and Working with SmartArt Deleting a Graphic Adding a Background Image

7 How Do I Manage Lists of Information?

Arranging a List in Excel Cleaning Up Data Sorting, Filtering, and Subtotaling Lists of Information Understanding Excel's Table Feature Sorting and Filtering a Table Using Table Calculations Converting a Table Back to a Range of Regular Cells

8 How Do I Present My Data in Charts?

Charts and Their Role in Your Workbooks Chart Types Creating a Chart Changing the Chart Type and Layout Formatting Chart Elements Changing the Charted Data Moving a Chart to Its Own Sheet and Deleting a Chart Using Special Charts: Sparklines, PivotTables, and Maps

9 How Do I Print and Share My Content?

Creating Headers and Footers Changing Page Settings Changing Sheet Settings Working with Page Breaks Previewing a Printout and Printing Other Ways to Share Information

Index Copyright About the Author Acknowledgments End User License Agreement