| |
| |
| |
| Working with Excel | |
| |
| |
| Getting to Know Excel | |
| |
| |
| Start Excel | |
| |
| |
| Tour the Excel Window | |
| |
| |
| Work with Excel's Ribbon | |
| |
| |
| Work with Excel's Galleries | |
| |
| |
| Customize the Quick Access Toolbar | |
| |
| |
| Customize the Ribbon | |
| |
| |
| Work with Smart Tags | |
| |
| |
| Change the View | |
| |
| |
| Configure Excel Options | |
| |
| |
| |
| Entering and Editing Excel Data | |
| |
| |
| Learning the Layout of a Worksheet | |
| |
| |
| Understanding the Types of Data You Can Use | |
| |
| |
| Enter Text into a Cell | |
| |
| |
| Enter a Number into a Cell | |
| |
| |
| Enter a Date or Time into a Cell | |
| |
| |
| Insert a Symbol | |
| |
| |
| Edit Cell Data | |
| |
| |
| Delete Data from a Cell | |
| |
| |
| |
| Working with Excel Ranges | |
| |
| |
| Select a Range | |
| |
| |
| Fill a Range with the Same Data | |
| |
| |
| Fill a Range with a Series of Values | |
| |
| |
| Move or Copy a Range | |
| |
| |
| Insert a Row or Column | |
| |
| |
| Insert a Cell or Range | |
| |
| |
| Delete Data from a Range | |
| |
| |
| Delete a Range | |
| |
| |
| Hide a Row or Column | |
| |
| |
| Freeze Rows or Columns | |
| |
| |
| Merge Two or More Cells | |
| |
| |
| Transpose Rows and Columns | |
| |
| |
| |
| Working with Range Names | |
| |
| |
| Define a Range Name | |
| |
| |
| Use Worksheet Text to Define a Range Name | |
| |
| |
| Navigate a Workbook Using Range Names | |
| |
| |
| Change a Range Name | |
| |
| |
| Delete a Range Name | |
| |
| |
| |
| Formatting Excel Ranges | |
| |
| |
| Change the Font and Font Size | |
| |
| |
| Apply Font Effects | |
| |
| |
| Change the Font Color | |
| |
| |
| Align Text Within a Cell | |
| |
| |
| Center Text Across Multiple Columns | |
| |
| |
| Rotate Text Within a Cell | |
| |
| |
| Add a Background Color to a Range | |
| |
| |
| Apply a Number Format | |
| |
| |
| Change the Number of Decimal Places Displayed | |
| |
| |
| Apply an AutoFormat to a Range | |
| |
| |
| Apply a Conditional Format to a Range | |
| |
| |
| Apply a Style to a Range | |
| |
| |
| Change the Column Width | |
| |
| |
| Change the Row Height | |
| |
| |
| Wrap Text Within a Cell | |
| |
| |
| Add Borders to a Range | |
| |
| |
| |
| Building Formulas and Functions | |
| |
| |
| Understanding Excel Formulas | |
| |
| |
| Build a Formula | |
| |
| |
| Understanding Excel Functions | |
| |
| |
| Add a Function to a Formula | |
| |
| |
| Add a Row or Column of Numbers | |
| |
| |
| Build an AutoSum Formula | |
| |
| |
| Add a Range Name to a Formula | |
| |
| |
| Reference Another Worksheet Range in a Formula | |
| |
| |
| Move or Copy a Formula | |
| |
| |
| |
| Manipulating Excel Worksheets | |
| |
| |
| Navigate a Worksheet | |
| |
| |
| Rename a Worksheet | |
| |
| |
| Create a New Worksheet | |
| |
| |
| Move a Worksheet | |
| |
| |
| Copy a Worksheet | |
| |
| |
| Delete a Worksheet | |
| |
| |
| Change the Gridline Color | |
| |
| |
| Toggle Worksheet Gridlines On and Off | |
| |
| |
| Toggle Worksheet Headings On and Off | |
| |
| |
| |
| Dealing with Excel Workbooks | |
| |
| |
| Create a New Blank Workbook | |
| |
| |
| Create a New Workbook from a Template | |
| |
| |
| Save a Workbook | |
| |
| |
| Open a Workbook | |
| |
| |
| Arrange Workbook Windows | |
| |
| |
| Find Text in a Workbook | |
| |
| |
| Replace Text in a Workbook | |
| |
| |
| |
| Formatting Excel Workbooks | |
| |
| |
| Modify the Workbook Colors | |
| |
| |
| Set the Workbook Fonts | |
| |
| |
| Choose Workbook Effects | |
| |
| |
| Apply a Workbook Theme | |
| |
| |
| |
| Analyzing Excel Data | |
| |
| |
| Sort a Range | |
| |
| |
| Filter a Range | |
| |
| |
| Set Data Validation Rules | |
| |
| |
| Convert a Range to a Table | |
| |
| |
| Create a Data Table | |
| |
| |
| Summarize Data with Subtotals | |
| |
| |
| |
| Visualizing Data with Excel Charts | |
| |
| |
| Examining Chart Elements | |
| |
| |
| Understanding Chart Types | |
| |
| |
| Create a Chart | |
| |
| |
| Add Chart Titles | |
| |
| |
| Add Data Labels | |
| |
| |
| Position the Chart Legend | |
| |
| |
| Display Chart Gridlines | |
| |
| |
| Display a Data Table | |
| |
| |
| Change the Chart Layout and Style | |
| |
| |
| Select a Different Chart Type | |
| |
| |
| |
| Formatting Excel Charts | |
| |
| |
| Format Chart Elements | |
| |
| |
| Customize a Chart Element Background | |
| |
| |
| Set a Chart Element's Outline | |
| |
| |
| Add Effects to a Chart Element | |
| |
| |
| Apply a Style to a Chart Element | |
| |
| |
| |
| Collaborating with Other People | |
| |
| |
| Add a Comment to a Cell | |
| |
| |
| Protect a Worksheet's Data | |
| |
| |
| Protect a Workbook's Structure and Windows | |
| |
| |
| Share a Workbook with Other Users | |
| |
| |
| Track Workbook Changes | |
| |
| |
| Accept or Reject Workbook Changes | |
| |
| |
| Send a Workbook as an E-Mail Attachment | |
| |
| |
| Save Excel Data as a Web Page | |
| |
| |
| Make a Workbook Compatible with Earlier Versions of Excel | |
| |
| |
| Collaborate on a Workbook Online | |