Excel 2007: Introduction to Formulas and Functions

Get a beginner-level introduction to Excel formulas and functions. Learn how to summarize and analyze data using these powerful data analysis features.

Introduction

• Create powerful Excel formulas
• What you should know before starting

1. Introducing Excel Formulas and Functions

• Familiarize yourself with functions and formulas
• Create a formula
• Introduce arithmetic operators
• Use cell references in formulas
• Use absolute and relative references in formulas
• Copy and paste formulas and values
• Edit a formula

2. Creating Basic Summary Functions

• Create a SUM or AVERAGE formula
• Create an AutoSum formula
• Create formulas to count cells
• Create formulas to summarize cells conditionally
• Summarize data on the status bar

3. Managing Named Ranges and Excel Tables

• Summarize data using named ranges
• Edit and delete named ranges
• Summarize data using an Excel table
• Refer to Excel table cells in formulas

4. Managing Data in Excel

• Manage data using text functions
• Separate data using Flash Fill
• Create data validation rules
• Restrict data entry using lists

5. Auditing Worksheet Formulas

• Trace formula precedents and dependents
• Evaluate Excel formulas step by step
• Identify and trace errors
• Manage Excel formula error indicators

Conclusion

• Further resources