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
()
Excel_Intro_to_Formulas_Functions.zip
(155 KB)